/// <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)); }