private void button3_Click(object sender, EventArgs e)
{
EleccionDeModificacion form = new EleccionDeModificacion();
form.StartPosition = FormStartPosition.CenterScreen;
form.Show();
this.Dispose();
}
private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("Debe ingresar un nombre");
}
else
{
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["GD_CRUCEROS"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("LOS_QUE_VAN_A_APROBAR.ModificarRol", cn))
{
cn.Open();
cmd.CommandType = CommandType.StoredProcedure;
DataRowView drv = (DataRowView)comboBox1.SelectedItem;
int idRol = Convert.ToInt32(drv["IdRol"]);
cmd.Parameters.Add("@IdRol", SqlDbType.Int).Value = idRol;
cmd.Parameters.Add("@Nombre", SqlDbType.NVarChar, 20).Value = textBox1.Text;
int resultado = cmd.ExecuteNonQuery();
if (resultado != 1)
{
MessageBox.Show("Ya existe nombre rol");
}
else
{
cmd.ExecuteNonQuery();
MessageBox.Show("Nombre de rol modificado");
}
cn.Close();
cn.Dispose();
EleccionDeModificacion form = new EleccionDeModificacion();
form.StartPosition = FormStartPosition.CenterScreen;
form.Show();
this.Dispose();
}
}
}
}
private void button2_Click(object sender, EventArgs e)
{
if (checkedListBox1.CheckedItems.Count == 0)
{
MessageBox.Show("Debe seleccionar al menos una funcionalidad");
}
else
{
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["GD_CRUCEROS"].ConnectionString))
{
cn.Open();
DataRowView drv = (DataRowView)comboBox1.SelectedItem;
int idRol = Convert.ToInt32(drv["IdRol"]);
using (SqlCommand cmd = new SqlCommand("LOS_QUE_VAN_A_APROBAR.BajaFuncionalidadDeRol", cn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@IdRol", SqlDbType.Int).Value = idRol;
cmd.Parameters.Add("@IdFuncionalidad", SqlDbType.Int);
DataRow row;
for (int i = 0; i < checkedListBox1.CheckedItems.Count; i++)
{
row = ((((DataRowView)checkedListBox1.CheckedItems[i]))).Row;
int valor = Convert.ToInt32(row[checkedListBox1.ValueMember]);
cmd.Parameters["@IdFuncionalidad"].Value = valor;
cmd.ExecuteNonQuery();
}
MessageBox.Show("Funcionalidades removidas");
}
cn.Close();
cn.Dispose();
EleccionDeModificacion form = new EleccionDeModificacion();
form.StartPosition = FormStartPosition.CenterScreen;
form.Show();
this.Dispose();
}
}
}
