protected void btnLogin_Click(object sender, EventArgs e)
{
DTOSession session = new DTOSession();
CADSession cadSession = new CADSession();
session.User = Int64.Parse(txtUser.Text);
session.Password = txtPassword.Text;
int validation_value = cadSession.login(session);
if (validation_value == 1)
{
ClientScript.RegisterStartupScript(GetType(), "mostrarMensaje", "alertify.alert('Usuario incorrecto');", true);
}
else if (validation_value == 2)
{
ClientScript.RegisterStartupScript(GetType(), "mostrarMensaje", "alertify.alert('Contraseña incorrecta');", true);
}
else if (validation_value == 3)
{
Response.Redirect("./html/usuarios.aspx");
}
else
{
ClientScript.RegisterStartupScript(GetType(), "mostrarMensaje", "alertify.alert('Sin más');", true);
}
}
public int login(DTOSession session)
{
long us = 0;
string cl = "";
int validationValue = 0;
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM tbl_Sesion";
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
foreach (var item in dr)
{
us = Int64.Parse(dr["usuario"].ToString());
cl = dr["clave"].ToString();
}
if (session.User != us)
{
validationValue = 1;
}
else if (!session.Password.Equals(cl))
{
validationValue = 2;
}
else if (session.User == us && session.Password.Equals(cl))
{
validationValue = 3;
con.Close();
}
con.Close();
return(validationValue);
}
