public List<T_C_Permiso> SeleccionarPermisosPorPerfil(int idPerfil) { try { List<T_C_Permiso> permisos = new List<T_C_Permiso>(); Connection = new System.Data.SqlClient.SqlConnection(ConnectionString); using(Command = new System.Data.SqlClient.SqlCommand("T_C_PermisoXPerfilSelectById_Perfil",Connection)) { Command.CommandType = CommandType.StoredProcedure; Command.Parameters.AddWithValue("@Id_Perfil", idPerfil); Connection.Open(); SqlDataReader reader = Command.ExecuteReader(); while (reader.Read()) { T_C_Permiso permiso = new T_C_Permiso(); permiso.Id_Permiso = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("Id_Permiso")).ToString()); permiso = new PermisoDataAccess().SeleccionarPermiso(permiso.Id_Permiso); permisos.Add(permiso); } } return permisos; } catch (Exception ex) { return null; } finally { Connection.Close(); } }
public PermisoDataLogic() { permisoAccess = new PermisoDataAccess(); }