public DataSet SelectNivelesAutoridad(ENTAutoridad oENTAutoridad, string sConnectionString)
{
SqlConnection Connection = new SqlConnection(sConnectionString);
SqlCommand Command;
SqlDataAdapter DataAdapter;
SqlParameter Parameter;
DataSet ds = new DataSet();
try
{
Command = new SqlCommand("spNivelesAutoridad_selForControl", Connection);
Command.CommandType = CommandType.StoredProcedure;
Parameter = new SqlParameter("AutoridadIdPadre1", SqlDbType.Int);
Parameter.Value = oENTAutoridad.AutoridadIdPadrePrimerNivel;
Command.Parameters.Add(Parameter);
Parameter = new SqlParameter("AutoridadIdPadre2", SqlDbType.Int);
Parameter.Value = oENTAutoridad.AutoridadIdPadreSegundoNivel;
Command.Parameters.Add(Parameter);
DataAdapter = new SqlDataAdapter(Command);
Connection.Open();
DataAdapter.Fill(ds);
Connection.Close();
}
catch (SqlException ex)
{
_ErrorId = ex.Number;
_ErrorDescription = ex.Message;
if (Connection.State == ConnectionState.Open) { Connection.Close(); }
}
return ds;
}