public bool changePass(string name, string oldPass, string newPass) { foodAppEntities db = new foodAppEntities(); List <User_acc> user = db.User_acc.Where(n => n.name == name && n.password == oldPass) .Select(n => n).ToList(); if (user.Count != 1) { throw new ArgumentException("too many or two few entries with that username", "name"); } user.FirstOrDefault().password = newPass; db.SaveChanges(); db.Dispose(); return(true); }
public bool ValidateUser(string userName, string password) { if (String.IsNullOrEmpty(userName)) { throw new ArgumentException("Value cannot be null or empty.", "userName"); } if (String.IsNullOrEmpty(password)) { throw new ArgumentException("Value cannot be null or empty.", "password"); } var db = new foodAppEntities(); List <User_acc> user = db.User_acc.Where(n => n.name == userName && n.password == password).Select(n => n).ToList(); if (user.Count != 1) { db.Dispose(); return(false); } else { db.Dispose(); return(true); } }
public MembershipCreateStatus makeUser(string name, string password, int?number) { MembershipCreateStatus myStatus = MembershipCreateStatus.Success; foodAppEntities db = new foodAppEntities(); User_acc myacc = new User_acc(); List <User_acc> mylist = db.User_acc .Where(n => (n.number == number) && (String.IsNullOrEmpty(n.name) || (n.name == name))) .Select(n => n).ToList(); if (mylist.Count > 0) { return(MembershipCreateStatus.DuplicateUserName); } myacc.number = number.Value; myacc.name = name; myacc.password = password; db.AddToUser_acc(myacc); db.SaveChanges(); db.Dispose(); return(myStatus); }