private void btn_delete_Click(object sender, EventArgs e)
{
FunctionDAO itemSelected = (FunctionDAO)lst_functions_added.Items[lst_functions_added.SelectedIndex];
removedFunctions.Add(itemSelected);
addedFunctions.Remove(itemSelected);
RoleConnection.DeleteFunction(role, itemSelected);
}
private static FunctionDAO GetFunction(SqlDataReader reader)
{
FunctionDAO functionDAO = new FunctionDAO();
functionDAO.Id = reader.GetInt32(reader.GetOrdinal("FUN_Id"));
functionDAO.Name = reader.GetString(reader.GetOrdinal("FUN_Nombre"));
functionDAO.Visible = reader.GetBoolean(reader.GetOrdinal("FUN_Visible"));
return(functionDAO);
}
public static void DeleteFunction(RoleDAO role, FunctionDAO function)
{
List <SqlParameter> parameters = new List <SqlParameter>();
SqlParameter parameter;
parameter = new SqlParameter("@Rol_Id", SqlDbType.Int, 100);
parameter.Value = role.Id;
parameters.Add(parameter);
parameter = new SqlParameter("@Funcionalidad_Id", SqlDbType.Int, 100);
parameter.Value = function.Id;
parameters.Add(parameter);
Connection.WriteInTheBase("EL_GROUP_BY.ELIMINAR_FUNCIONALIDAD_A_ROL", Connection.Type.StoredProcedure, parameters);
}
private static List <FunctionDAO> LoadFunctionsSinceReader(SqlDataReader reader)
{
List <FunctionDAO> functions = new List <FunctionDAO>();
if (reader.HasRows)
{
while (reader.Read())
{
FunctionDAO function = GetFunction(reader);
functions.Add(function);
}
}
reader.Close();
return(functions);
}
public static List <FunctionDAO> GetFunctionsNotAssignedForRole(Int32 id)
{
List <FunctionDAO> funciones = new List <FunctionDAO>();
List <SqlParameter> parametros = new List <SqlParameter>();
parametros.Add(new SqlParameter("@Rol_Id", id));
SqlDataReader reader = Connection.GetDataReader("EL_GROUP_BY.LISTAR_FUNCIONES_X_ROL_NO_ASIGNADAS", Connection.Type.StoredProcedure, parametros);
if (reader.HasRows)
{
while (reader.Read())
{
FunctionDAO funcion = GetFunction(reader);
funciones.Add(funcion);
}
}
reader.Close();
return(funciones);
}
public FunctionBUS()
{
sign = new FunctionDAO();
}
