/// <summary>
/// Recopila la información que se va a guardar como sesión de usuario.
/// </summary>
/// <param name="Email">Correo electrónico</param>
/// <param name="Password">Contraseña</param>
/// <returns></returns>
public UserLoginData LoginDAL(string email, string password)
{
try
{
using (var context = new WinNotesEntities())
{
sp_login_Result user = context.sp_login(email, password).First();
//Person user = context.Person.Where(p => p.Email == email && p.Password == password).FirstOrDefault();
UserLoginData login = null;
if (user != null)
{
login = new UserLoginData(
user.PersonID,
user.UserName,
user.Email,
GetAvatarImage(user.AvatarImage, user.AvatarMIMEType),
Convert.ToBoolean(user.Active)
);
//user.LastLoginDate = DateTime.Now;
//context.SaveChanges();
context.sp_refreshLoginDate(user.PersonID);
}
return(login);
}
}
catch
{
throw;
}
}
public ActionResult Login(sp_login_Result model, string returnUrl)
{
try
{
if (ModelState.IsValid)
{
var loginInfo = this._databaseManager.sp_login(model.chrCodUsr, model.chrNomUsr).ToList();
if (loginInfo != null && loginInfo.Count() > 0)
{
var logindetails = loginInfo.First();
this.SignInUser(logindetails.chrNomUsr, logindetails.chrCodUsr, logindetails.chrAcceso, false);
return(this.RedirectToLocal(returnUrl));
}
else
{
ModelState.AddModelError(string.Empty, "Contraseña o usuario invalid@.");
}
}
}
catch (Exception ex)
{
Console.Write(ex);
}
return(this.View(model));
}
