protected void btnEditar_Click(object sender, EventArgs e) { try { string rut; rut = txtRut.Text; rut = rut.Replace(".", ""); var connectionString = ConfigurationManager.ConnectionStrings["cnn"].ConnectionString; using (SqlConnection sql = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("sp_EditaUsuario", sql)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@TipoUsuario", tipoUsuario.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@UsuarioId", rut); sql.Open(); cmd.ExecuteNonQuery(); sql.Close(); lblmsg.Visible = true; lblmsg.ForeColor = Color.Blue; lblmsg.Text = "Usuario editado exitosamente"; AgregaCreador.AgregaNombreCreador(Session["nombre"].ToString() + " " + Session["apellido"].ToString()); frmEditar.Visible = false; } } } catch (Exception ex) { lblmsg.Visible = true; lblmsg.ForeColor = Color.Red; lblmsg.Text = "No se editó el usuario"; } }
protected void btnRegistrar_Click(object sender, EventArgs e) { try { string rut; rut = txtRut.Text; rut = rut.Replace(".", ""); if (!VerificaUsuario(rut)) { var connectionString = ConfigurationManager.ConnectionStrings["cnn"].ConnectionString; using (SqlConnection sql = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("sp_CreaUsuario", sql)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UsuarioId", rut); cmd.Parameters.AddWithValue("@Pwd", txtContTemp.Text); cmd.Parameters.AddWithValue("@Tipousuario", tipoUsuario.SelectedItem.ToString()); cmd.Parameters.AddWithValue("@Nombre", txtNombre.Text); cmd.Parameters.AddWithValue("@Apellido", txtApellido.Text); cmd.Parameters.AddWithValue("@Email", txtEmail.Text); sql.Open(); cmd.ExecuteNonQuery(); sql.Close(); lblmsg.ForeColor = Color.Blue; lblmsg.Text = "Usuario registrado exitosamente"; AgregaCreador.AgregaNombreCreador(Session["nombre"].ToString() + " " + Session["apellido"].ToString()); InicializaControles(); } } } else { lblmsg.ForeColor = Color.Red; lblmsg.Text = "Usuario ya está registrado en SINDAS"; } } catch (Exception ex) { lblmsg.ForeColor = Color.Red; lblmsg.Text = "No se registró al usuario" + ex.ToString(); } }
protected void btnCambiaPass_Click(object sender, EventArgs e) { if (ValidaUsuario(txtRut.Text, txtContActual.Text)) { string rut; rut = txtRut.Text; rut = rut.Replace(".", ""); try { var connectionString = ConfigurationManager.ConnectionStrings["cnn"].ConnectionString; using (SqlConnection sql = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("sp_CambiaPass", sql)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@rut", rut); cmd.Parameters.AddWithValue("@pass", txtContActual.Text); cmd.Parameters.AddWithValue("@nuevoPass", txtContNueva.Text); sql.Open(); cmd.ExecuteNonQuery(); sql.Close(); AgregaCreador.AgregaNombreCreador(Session["nombre"].ToString() + " " + Session["apellido"].ToString()); txtRut.Text = string.Empty; lblmsg.ForeColor = Color.Blue; lblmsg.Text = "La contraseña ha sido cambiada exitosamente"; } } } catch (Exception ex) { throw ex; } } else { lblmsg.ForeColor = Color.Red; lblmsg.Text = "Cambio de contraseña no se realizó, datos incorrectos"; } }