void Actualiza() { string queryString = "UPDATE Departamentos "; queryString += " set "; if (TActivo.Checked == true) { queryString += "Activo=1 ,"; } else { queryString += "Activo=0 ,"; } if (TPorDefecto.Checked == true) { queryString += "PorDefecto=1 ,"; } else { queryString += "PorDefecto=0 ,"; } queryString += "Departamento='" + TDepartamento.Text + "'"; queryString += " WHERE IdDepartamento='" + TID.Text + "'"; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConSql"].ConnectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); command.ExecuteNonQuery(); } clase_auditoria objclass1 = new clase_auditoria(); objclass1.Compara_Auditoria("Departamentos", "IdDepartamento", TID.Text, "MODIFICACION", HttpContext.Current.User.Identity.Name); }
private void AltaUsuario(string Usuario, string Clave) { clase_auditoria objclass1 = new clase_auditoria(); objclass1.Graba_Temp_Auditoria("Usuarios", "IdUsuario", "0", Usuario); string IdMenu = "0"; string IdDepartamento = "0"; string queryString = "Select top 1 isnull(idUsuario,0) from Usuarios order by IdUsuario Desc"; Int16 NroId = 0; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConSql"].ConnectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { NroId = Convert.ToInt16(reader[0]); } } NroId += 1; string queryString2 = "INSERT INTO Usuarios "; queryString2 += "(IdUsuario"; queryString2 += ",Usuario"; queryString2 += ",Clave"; queryString2 += ",Nombre"; queryString2 += ",Apellido"; queryString2 += ",Mail"; queryString2 += ",Telefono"; queryString2 += ",IdDepartamento"; queryString2 += ",Activo"; queryString2 += ",Bloqueado"; queryString2 += ",ActiveDirectory"; queryString2 += ",IdMenu)"; queryString2 += " VALUES "; queryString2 += " (" + Convert.ToString(NroId) + " "; queryString2 += ",'" + Usuario + "' "; queryString2 += ",'" + Clave + "'"; queryString2 += ",''"; queryString2 += ",''"; queryString2 += ",''"; queryString2 += ",''"; queryString2 += "," + IdDepartamento + ""; queryString2 += ",1"; queryString2 += ",0"; queryString2 += ",1"; queryString2 += "," + IdMenu + ")"; using (SqlConnection connection2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConSql"].ConnectionString)) { SqlCommand command2 = new SqlCommand(queryString2, connection2); connection2.Open(); command2.ExecuteNonQuery(); } clase_auditoria objclass2 = new clase_auditoria(); objclass2.Compara_Auditoria("Usuarios", "IdUsuario", Convert.ToString(NroId), "ALTA", Usuario); }
void Grabar() { string queryString = "Select top 1 isnull(idDepartamento,0) from Departamentos order by IdDepartamento Desc"; Int16 NroId = 0; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConSql"].ConnectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { NroId = Convert.ToInt16(reader[0]); } } NroId += 1; string queryString2 = "INSERT INTO Departamentos "; queryString2 += "(IdDepartamento"; queryString2 += ",Departamento"; queryString2 += ",Activo"; queryString2 += ",PorDefecto)"; queryString2 += " VALUES "; queryString2 += " (" + Convert.ToString(NroId) + " "; queryString2 += ",'" + TDepartamento.Text + "' "; if (TActivo.Checked == true) { queryString2 += ",1"; } else { queryString2 += ",0"; } if (TPorDefecto.Checked == true) { queryString2 += ",1"; } else { queryString2 += ",0"; } queryString2 += ")"; using (SqlConnection connection2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConSql"].ConnectionString)) { SqlCommand command2 = new SqlCommand(queryString2, connection2); connection2.Open(); command2.ExecuteNonQuery(); } clase_auditoria objclass1 = new clase_auditoria(); objclass1.Compara_Auditoria("Departamentos", "IdDepartamento", Convert.ToString(NroId), "ALTA", HttpContext.Current.User.Identity.Name); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["Tipo"] == "Modificacion") { LTitulo.Text = "Modificación de Departamentos"; BnInsertar.Text = "Modificar"; TID.Text = Request.QueryString["ID"]; string queryString = "SELECT Departamento,Activo,PorDefecto "; queryString += " FROM Departamentos "; queryString += " where IdDepartamento=" + TID.Text + " "; using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["ConSql"].ConnectionString)) { SqlCommand command = new SqlCommand(queryString, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { TDepartamento.Text = Convert.ToString(reader[0]); if (Convert.ToString(reader[1]) == "1") { TActivo.Checked = true; } else { TActivo.Checked = false; } if (Convert.ToString(reader[2]) == "1") { TPorDefecto.Checked = true; } else { TPorDefecto.Checked = false; } } } clase_auditoria objclass1 = new clase_auditoria(); objclass1.Graba_Temp_Auditoria("Departamentos", "IdDepartamento", TID.Text, HttpContext.Current.User.Identity.Name); } else { LTitulo.Text = "Ingreso de Departamentos"; BnInsertar.Text = "Grabar"; TID.Text = "0"; clase_auditoria objclass1 = new clase_auditoria(); objclass1.Graba_Temp_Auditoria("Departamentos", "IdDepartamento", "0", HttpContext.Current.User.Identity.Name); } } }