public IHttpActionResult Login(Domain.UserLogin um) { //string message = ""; try { using (AccountDBEntities adb = new AccountDBEntities()) { var v = adb.Users.Where(a => a.Email == um.Email).FirstOrDefault(); if (v != null) { if (string.Compare(um.Password, v.Password) == 0) { return(Content(HttpStatusCode.Accepted, "Login Success")); } else { return(Content(HttpStatusCode.NotFound, "Wrong Password")); } } else { return(Content(HttpStatusCode.NotFound, "Wrong Email")); } } } catch (Exception ex) { return(Content(HttpStatusCode.BadRequest, ex)); } }
public void Put(int id, string column, string value) { using (AccountDBEntities entities = new AccountDBEntities()) { user user = (from usr in entities.users where usr.id == id select usr).First(); switch (column) { case "username": user.username = value; break; case "password": user.password = value; break; case "email": user.email = value; break; case "fullname": user.fullname = value; break; default: break; } entities.SaveChanges(); } }
public bool IsMobileNumberExist(string mobileNumber) { using (AccountDBEntities adb = new AccountDBEntities()) { var v = adb.Users.Where(a => a.MobileNumber == mobileNumber).FirstOrDefault(); return(v != null); } }
public bool IsEmailExist(string email) { using (AccountDBEntities adb = new AccountDBEntities()) { var v = adb.Users.Where(a => a.Email == email).FirstOrDefault(); return(v != null); } }
public void Delete(int id) { using (AccountDBEntities entities = new AccountDBEntities()) { user user = (from usr in entities.users where usr.id == id select usr).First(); entities.users.Remove(user); entities.SaveChanges(); } }
private bool ExistEmail(Account acc) { bool existEmail = false; using (var db = new AccountDBEntities()) { var user = db.Accounts.FirstOrDefault(u => u.Email == acc.Email); if (user != null && user.UserId != acc.UserId) { existEmail = true; } } return(existEmail); }
public void Post(string username, string password, string email, string fullname) { user user = new user { username = username, password = password, email = email, fullname = fullname }; using (AccountDBEntities entities = new AccountDBEntities()) { entities.users.Add(user); entities.SaveChanges(); } }
public HttpResponseMessage Register1(Domain.UserModel um) { string message = ""; try { using (AccountDBEntities adb = new AccountDBEntities()) { var isExistEmail = IsEmailExist(um.Email); if (isExistEmail) { message += "Email already exists|"; } var isMobileNumber = IsMobileNumberExist(um.MobileNumber); if (isMobileNumber) { message += "Mobile number already exists|"; } if (!isExistEmail && !isMobileNumber) { adb.Users.Add(new User() { Email = um.Email, MobileNumber = um.MobileNumber, FirstName = um.FirstName, LastName = um.LastName, DateOfBirth = um.DateOfBirth, Gender = um.Gender, Password = um.Password, }); adb.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.Created, um)); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, message)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public ActionResult ForgotPassword(Models.RestPassModel userEmail) { using (var db = new AccountDBEntities()) { if (userEmail != null) { var user = db.Accounts.FirstOrDefault(u => u.Email == userEmail.UserEmail); if (user == null) { ModelState.AddModelError("error", "Email does not exist"); } else { ModelState.AddModelError("error", "New password send to you ,please Check"); } } ModelState.AddModelError("error", "Email does not exist"); } return(View(userEmail)); }
//To validate private bool IsValid(string email, string password, out int isadmin) { var crypto = new SimpleCrypto.PBKDF2(); isadmin = 0; bool isValid = false; using (var db = new AccountDBEntities()) { var user = db.Accounts.FirstOrDefault(u => u.Email == email); if (user != null) { if (user.Password == password) { isValid = true; isadmin = user.UserType; userAccount = user; } } } return(isValid); }
public user Get(int id) { using (AccountDBEntities entities = new AccountDBEntities()) { return(entities.users.FirstOrDefault(e => e.id == id)); } }
public IEnumerable <user> Get() { using (AccountDBEntities entities = new AccountDBEntities()) { return(entities.users.ToList()); } }