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