private void AbmRol_Load(object sender, EventArgs e)
{
SqlConnection conexion = DBConnection.getConnection();
SqlCommand command = new SqlCommand("select r.rol_id,r.rol_habilitado, r.rol_nombre from SOCORRO.Rol r order by r.rol_id", conexion);
command.CommandType = CommandType.Text;
adapter1 = new SqlDataAdapter();
table1 = new DataTable();
adapter1.UpdateCommand = new SqlCommand("SOCORRO.sp_modificar_rol", conexion);
adapter1.UpdateCommand.CommandType = CommandType.StoredProcedure;
adapter1.UpdateCommand.Parameters.Add("@rol_habilitado", SqlDbType.Bit, 1, "rol_habilitado");
adapter1.UpdateCommand.Parameters.Add("@rol_nombre", SqlDbType.NVarChar, 20, "rol_nombre");
SqlParameter parameter = adapter1.UpdateCommand.Parameters.Add("@rol_id", SqlDbType.Int);
parameter.SourceColumn = "rol_id";
parameter.SourceVersion = DataRowVersion.Original;
DBConnection.fill_grid(dataGridView1, command, adapter1, table1);
SqlCommand command2 = new SqlCommand("select r.rol_id,r.rol_nombre, f.func_id,f.func_descripcion from SOCORRO.Rol r join SOCORRO.FuncionalidadxRol fxr on fxr.rol_id = r.rol_id join SOCORRO.Funcionalidad f on f.func_id = fxr.func_id order by r.rol_id,f.func_id", conexion);
command2.CommandType = CommandType.Text;
adapter2 = new SqlDataAdapter();
table2 = new DataTable();
DBConnection.fill_grid(dataGridView2, command2, adapter2, table2);
List <Funcionalidad> funcs = DBConnection.getFuncs();
foreach (Funcionalidad f in funcs)
{
comboBox_funcionalidades.Items.Add(f.nombre);
}
comboBox_funcionalidades.SelectedIndex = 0;
List <Rol> roles = DBConnection.getRoles();
comboBox_roles.Items.Clear();
foreach (Rol r in roles)
{
comboBox_roles.Items.Add(r.nombre);
}
if (comboBox_roles.Items.Count > 0)
{
comboBox_roles.SelectedIndex = 0;
}
dataGridView1.Columns["rol_id"].ReadOnly = true;
}
