public bool ValidateUser(string username, string password) { using (KSUCornerDBEntities1 db = new KSUCornerDBEntities1()) { var result = from u in db.Accounts where (u.UserName == username) select u; if (result.Count() != 0) { var dbuser = result.First(); if (dbuser.Password == password) { return(true); } else { return(false); } } else { return(false); } } }
public string GetPassword(string username, string answer) { using (KSUCornerDBEntities1 db = new KSUCornerDBEntities1()) { var result = from u in db.Accounts where (u.UserName == username) select u; if (result.Count() != 0) { var dbuser = result.FirstOrDefault(); if (dbuser.SecurityAnswer.Trim().ToLower() == answer.Trim().ToLower()) { return(dbuser.Password); } else { return(""); } } else { return(""); } } }
public static void CreateUser(string username, string firstname, string lastname, string email, string password, string gender, int month, int day, int year, string securityquestion, string securityanswer) { using (KSUCornerDBEntities1 db = new KSUCornerDBEntities1()) { Account user = new Account(); user.UserName = username; user.FirstName = firstname; user.LastName = lastname; user.Email = email; user.EmailConfirmed = false; user.Password = password; user.Gender = gender; user.BirthDate = new DateTime(year, month, day); user.SecurityQuestion = securityquestion; user.SecurityAnswer = securityanswer; user.LastLoginDate = DateTime.Now; user.LastUpdateDate = DateTime.Now; user.IsActivated = false; user.IsLockedOut = false; user.LastLockedOutDate = DateTime.Now; user.LastLockedOutReason = ""; user.CreateDate = DateTime.Now; db.Accounts.Add(user); db.SaveChanges(); } }
public static void SetPassword(string username, string newpassword) { using (KSUCornerDBEntities1 db = new KSUCornerDBEntities1()) { var result = from u in db.Accounts where (u.UserName == username) select u; if (result.Count() != 0) { var dbuser = result.FirstOrDefault(); dbuser.Password = newpassword; db.SaveChanges(); } } }
public static void UpdateLoginDate(string username) { using (KSUCornerDBEntities1 db = new KSUCornerDBEntities1()) { var result = from x in db.Accounts where (x.UserName.ToLower() == username.ToLower()) select x; if (result.Count() > 0) { Account user = result.FirstOrDefault(); user.LastLoginDate = DateTime.Now; db.SaveChanges(); } } }
public MembershipUser GetUser(string username) { using (KSUCornerDBEntities1 db = new KSUCornerDBEntities1()) { var result = from u in db.Accounts where (u.UserName == username) select u; if (result.Count() != 0) { var dbuser = result.FirstOrDefault(); int _providerUserKey = dbuser.AccountID; string _username = dbuser.UserName; string _email = dbuser.Email; string _passwordQuestion = dbuser.SecurityQuestion; string _comment = ""; bool _isApproved = dbuser.IsActivated; bool _isLockedOut = dbuser.IsLockedOut; DateTime _creationDate = dbuser.CreateDate; DateTime _lastLoginDate = dbuser.LastLoginDate; DateTime _lastActivityDate = DateTime.Now; DateTime _lastPasswordChangedDate = DateTime.Now; DateTime _lastLockedOutDate = dbuser.LastLockedOutDate; MembershipUser user = new MembershipUser("CustomMembershipProvider", _username, _providerUserKey, _email, _passwordQuestion, _comment, _isApproved, _isLockedOut, _creationDate, _lastLoginDate, _lastActivityDate, _lastPasswordChangedDate, _lastLockedOutDate); return(user); } else { return(null); } } }
public string GetUserNameByEmail(string email) { using (KSUCornerDBEntities1 db = new KSUCornerDBEntities1()) { var result = from u in db.Accounts where (u.Email == email) select u; if (result.Count() != 0) { var dbuser = result.FirstOrDefault(); return(dbuser.UserName); } else { return(""); } } }