public Object loguearse(Usuarios_E ue)
{
string cnSTR = "data source=.;initial catalog=DerMark;user id = admin;password = 123456789";
using (SqlConnection cn = new SqlConnection(cnSTR))
{
cn.Open();
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "LoginUsuarios";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@correo_electronico", ue.correo_electronico);
cmd.Parameters.AddWithValue("@contraseña", ue.contraseña);
return(cmd.ExecuteScalar());
}
}
public static object loguearse(string correo_electronico, string contraseña)
{
Usuarios_BL bc = new Usuarios_BL();
Usuarios_E ue = new Usuarios_E();
ue.correo_electronico = correo_electronico;
ue.contraseña = contraseña;
HttpContext.Current.Session["email"] = correo_electronico;
return(bc.loguearse(ue));
}
public Object loguearse(Usuarios_E ue)
{
string cnSTR = @"data source=DESKTOP-ALH0A74\SQLEXPRESS01;initial catalog=DerMark;Integrated Security=true";
using (SqlConnection cn = new SqlConnection(cnSTR))
{
cn.Open();
SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "LoginUsuarios";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@correo_electronico", ue.correo_electronico);
cmd.Parameters.AddWithValue("@contraseña", ue.contraseña);
return(cmd.ExecuteScalar());
}
}
public object loguearse(Usuarios_E ue)
{
return(db.loguearse(ue));
}
