private void button1_Click(object sender, EventArgs e)
{
MenuRol form = new MenuRol();
form.StartPosition = FormStartPosition.CenterScreen;
form.Show();
this.Dispose();
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("Debe especificar un nombre");
}
else if (checkedListBox1.CheckedItems.Count == 0)
{
MessageBox.Show("Debe al menos seleccionar una funcionalidad para su rol");
}
else
{
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["GD_CRUCEROS"].ConnectionString))
{
cn.Open();
/*+SqlCommand cmdc = new SqlCommand("select count(*) as Total from LOS_QUE_VAN_A_APROBAR.Rol where IdRol = " + textBox1.Text,cn);
* cmdc.CommandType = CommandType.Text;
* int pruebita = Convert.ToInt32(cmdc.ExecuteScalar());
* MessageBox.Show(pruebita.ToString());*/
SqlCommand cmd = new SqlCommand("LOS_QUE_VAN_A_APROBAR.NuevoRol", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@NuevoNombre", SqlDbType.NVarChar, 255).Value = textBox1.Text;
cmd.ExecuteNonQuery();
SqlCommand cmd2 = new SqlCommand("select LOS_QUE_VAN_A_APROBAR.ObtenerNuevoRolInsertado()", cn);
cmd2.CommandType = CommandType.Text;
int IdRolNuevo = Convert.ToInt32(cmd2.ExecuteScalar());
SqlCommand cmd3 = new SqlCommand("LOS_QUE_VAN_A_APROBAR.FuncionalidadParaRol", cn);
cmd3.CommandType = CommandType.StoredProcedure;
cmd3.Parameters.Add("@IdRol", SqlDbType.Int).Value = IdRolNuevo;
cmd3.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]);
cmd3.Parameters["@IdFuncionalidad"].Value = valor;
cmd3.ExecuteNonQuery();
}
MessageBox.Show("Rol creado exitosamente");
cn.Close();
MenuRol form = new MenuRol();
form.StartPosition = FormStartPosition.CenterScreen;
form.Show();
this.Dispose();
}
}
}
private void button1_Click(object sender, EventArgs e)
{
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["GD_CRUCEROS"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("LOS_QUE_VAN_A_APROBAR.BajaRol", cn))
{
cn.Open();
cmd.CommandType = CommandType.StoredProcedure;
DataRowView drv = (DataRowView)comboBox1.SelectedItem;
Int32 valueOfItem = Convert.ToInt32(drv["IdRol"]);
cmd.Parameters.Add("@IdRol", SqlDbType.Int).Value = valueOfItem;
cmd.ExecuteNonQuery();
MessageBox.Show("Rol dado de baja exitosamente");
cn.Close();
cn.Dispose();
MenuRol form = new MenuRol();
form.StartPosition = FormStartPosition.CenterScreen;
form.Show();
this.Dispose();
}
}
}