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(); } } }