protected void ButtonAgregaAut_Click(object sender, EventArgs e) { SqlConnection con; SqlCommand cmd = new SqlCommand(); String Perfil = DropDownListPerfil.SelectedValue; con = new SqlConnection(BopDBAutorizaciones.ConnectionString); cmd.Connection = con; con.Open(); for (int i = 0; i < GridViewAutDisp.Rows.Count; i++) { Boolean indAut = ((CheckBox)GridViewAutDisp.Rows[i].FindControl("AutorOnOff")).Checked; if (indAut) { try { ((CheckBox)GridViewAutDisp.Rows[i].FindControl("AutorOnOff")).Checked = false; Label Modulo = (Label)GridViewAutDisp.Rows[i].FindControl("Modulo"); Label Opcion = (Label)GridViewAutDisp.Rows[i].FindControl("Opcion"); cmd.CommandText = "INSERT INTO [dbo].[Autorizaciones] ([Perfil],[Modulo],[Opcion],[Estado]) VALUES ('" + Perfil.Trim() + "','" + Modulo.Text.Trim() + "','" + Opcion.Text.Trim() + "','Activo')"; cmd.ExecuteNonQuery(); } catch (SqlException exception) { if (exception.Number == 2601) // Cannot insert duplicate key row in object error { return; } } } } con.Close(); GridViewAutAsig.DataBind(); }
protected void ButtonElimAut_Click(object sender, EventArgs e) { SqlConnection con2; SqlCommand cmd2 = new SqlCommand(); String Perfil = DropDownListPerfil.SelectedValue; con2 = new SqlConnection(BopDBAutorizaciones.ConnectionString); cmd2.Connection = con2; con2.Open(); for (int j = 0; j < GridViewAutAsig.Rows.Count; j++) { Boolean indAut2 = ((CheckBox)GridViewAutAsig.Rows[j].FindControl("CheckBoxAut")).Checked; if (indAut2) { ((CheckBox)GridViewAutAsig.Rows[j].FindControl("CheckBoxAut")).Checked = false; Label Modulo = (Label)GridViewAutAsig.Rows[j].FindControl("Modulo"); Label Opcion = (Label)GridViewAutAsig.Rows[j].FindControl("Opcion"); cmd2.CommandText = "DELETE FROM [dbo].[Autorizaciones] WHERE Perfil ='" + Perfil.Trim() + "' And Modulo='" + Modulo.Text.Trim() + "' And Opcion='" + Opcion.Text.Trim() + "'"; cmd2.ExecuteNonQuery(); } } con2.Close(); GridViewAutAsig.DataBind(); GridViewAutDisp.DataBind(); }
protected void ButtonElimAll_Click(object sender, EventArgs e) { SqlConnection con; SqlCommand cmd = new SqlCommand(); String Perfil = DropDownListPerfil.SelectedValue; con = new SqlConnection(BopDBAutorizaciones.ConnectionString); cmd.Connection = con; con.Open(); cmd.CommandText = "DELETE FROM [dbo].[Autorizaciones] WHERE Perfil ='" + Perfil.Trim() + "'"; cmd.ExecuteNonQuery(); con.Close(); GridViewAutAsig.DataBind(); }
protected void ButtonAgrAll_Click(object sender, EventArgs e) { SqlConnection con; SqlCommand cmd = new SqlCommand(); String Perfil = DropDownListPerfil.SelectedValue; con = new SqlConnection(BopDBAutorizaciones.ConnectionString); cmd.Connection = con; con.Open(); cmd.CommandText = "DELETE FROM [dbo].[Autorizaciones] WHERE Perfil ='" + Perfil.Trim() + "'"; cmd.ExecuteNonQuery(); cmd.CommandText = "Insert into [dbo].[Autorizaciones] SELECT '" + Perfil.Trim() + "' as [Perfil],[Modulo],[Opcion],'Activo' as [Estado],Null as [Fecha Creación],Null as [Fecha Modif],Null as [Usuario Modif] FROM [Opciones]"; cmd.ExecuteNonQuery(); con.Close(); GridViewAutAsig.DataBind(); }