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