public Boolean[] IsEmailExist(string email, string username) { using (DrinkDBEntities dc = new DrinkDBEntities()) { var equery = dc.Users.Where(u => u.Email == email).FirstOrDefault(); var uquery = dc.Users.Where(u => u.Username == username).FirstOrDefault(); Boolean[] exists = { true, true }; if (equery == null) { exists[0] = false; } if (uquery == null) { exists[1] = false; } return(exists); } }
public ActionResult Login(UserCredentials user) { UserLogin login = user.UserLogin; ViewBag.Page = "Login"; string message = ""; using (DrinkDBEntities dc = new DrinkDBEntities()) { var queryResult = dc.Users.Where(u => u.Username == login.Username).FirstOrDefault(); if (queryResult != null) { if (string.Compare(PasswordHashing.Hash(login.Password), queryResult.Password) == 0) { #region Cookie to stay logged in int timeout = login.RememberMe ? 10000 : 60; var ticket = new FormsAuthenticationTicket(login.Username, login.RememberMe, timeout); string encrypted = FormsAuthentication.Encrypt(ticket); var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted); cookie.Expires = DateTime.Now.AddMinutes(timeout); cookie.HttpOnly = true; Response.Cookies.Add(cookie); #endregion return(RedirectToAction("Home", "Home")); } else { message = "Password is incorrect!"; } } else { message = "Invalid credentials"; } } ViewBag.Message = message; return(View("Account")); }
public ActionResult VerifyAccount(string id) { bool Status = false; using (DrinkDBEntities dc = new DrinkDBEntities()) { dc.Configuration.ValidateOnSaveEnabled = false; var query = dc.Users.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault(); if (query != null) { // TODO: See if the user already activated the account! query.isVerified = true; dc.SaveChanges(); Status = true; } else { ViewBag.Message = "Invalid Request!"; } } ViewBag.Status = Status; return(View()); }
public ActionResult Registration([Bind(Exclude = "IsVerified, ActivationCode, Role")] UserCredentials userCred) { ViewBag.Page = "Registration"; User user = new User(); user = userCred.UserRegistration; bool isSuccessful = false; string message = ""; if (ModelState.IsValid) { #region Check if email and username are taken var isExists = IsEmailExist(user.Email, user.Username); if (isExists[0]) { ModelState.AddModelError("EmailExists", "Email already Exists"); return(View("Account")); } if (isExists[1]) { ModelState.AddModelError("UsernameExists", "Username is taken!"); return(View("Account")); } #endregion #region Generate Activation Code user.ActivationCode = Guid.NewGuid(); #endregion #region Pw hashing user.Password = PasswordHashing.Hash(user.Password); user.ConfirmPassword = PasswordHashing.Hash(user.ConfirmPassword); #endregion user.isVerified = false; user.Role = "user"; //cHxY2:)CoCkTaIlFiNdeR #region Save to DB using (DrinkDBEntities dc = new DrinkDBEntities()) { dc.Users.Add(user); dc.SaveChanges(); SendEmailVerification(user.Username, user.Email, user.ActivationCode.ToString()); message = "Successful Registration! Check your email and verify your account!"; isSuccessful = true; } #endregion } else { message = "Invalid request!"; } ViewBag.Status = isSuccessful; ViewBag.Message = message; return(View("Account")); }
public CocktailsRepository() { this.db = new DrinkDBEntities(); }
public CreatorRepository() { this.db = new DrinkDBEntities(); }
public SearchRepository() { db = new DrinkDBEntities(); }
public UserRepository() { this.db = new DrinkDBEntities(); }
public IngredientsRepository() { this.db = new DrinkDBEntities(); }