public bool CheckEmail(string emailID) { using (var context = new Datebase1Entities()) { var check_email = context.Users.Where(a => a.EmailID == emailID).FirstOrDefault(); //returns true if check_email is not null return(check_email != null); } }
public override string[] GetRolesForUser(string username) { Datebase1Entities context = new Datebase1Entities(); var userRoles = (from user in context.Users join role in context.UserRoles on user.RoleID equals role.ID where user.EmailID == username && user.IsActive == true select role.Name).ToArray(); return(userRoles); }
public int AddUsers(UsersModel model) { using (var context = new Datebase1Entities()) { Users user = new Users() { FirstName = model.FirstName, LastName = model.LastName, EmailID = model.EmailID, Password = model.Password, SecretCode = model.SecretCode }; context.Users.Add(user); context.SaveChanges(); return(user.ID); } }
public ActionResult Login(UserLogin obj) { //string message = ""; using (Datebase1Entities entity = new Datebase1Entities()) { var take = entity.Users.Where(a => a.EmailID == obj.EmailID).FirstOrDefault(); if (take != null) { if (take.IsEmailVerified == true) { if (string.Compare(obj.Password, take.Password) == 0) { int memberid = entity.UserRoles.Where(x => x.Name.ToLower() == "member").Select(x => x.ID).FirstOrDefault(); //check if user member if (take.RoleID == memberid) { int take_time = obj.RememberMe ? 525600 : 20; // Here,525600 min = 1 year If CheckBox Is Marked Else 20 min var locking = new FormsAuthenticationTicket(obj.EmailID, obj.RememberMe, take_time); string styling = FormsAuthentication.Encrypt(locking); var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, styling); cookie.Expires = DateTime.Now.AddMinutes(take_time); cookie.HttpOnly = true; Response.Cookies.Add(cookie); // check if user profile exists or not var is_userprofile_exist = context.UserProfile.Where(x => x.User_ID == take.ID).FirstOrDefault(); // if user profile is not exists then redirect to userprofile page else search page if (is_userprofile_exist == null) { return(RedirectToAction("UserProfile", "UserProfile")); } else { return(RedirectToAction("Search", "SearchNotes")); } } //for user admin or superadmin else { //set authentication cookie FormsAuthentication.SetAuthCookie(take.EmailID, obj.RememberMe); // check if Admin profile exists or not var is_userprofile_exist = context.Admin.Where(x => x.AdminID == take.ID).FirstOrDefault(); // if Admin profile is not exists then redirect to myprofile page else dashboard page if (is_userprofile_exist == null) { return(RedirectToAction("MyProfile", "AdminProfile")); } else { return(RedirectToAction("Dashboard", "Admin")); } } } else { //message = "Invalid Password"; ModelState.AddModelError("Password", "Your Password Invalid"); return(View(obj)); } } else { ModelState.AddModelError("Email", "Your Email is not verified"); return(View(obj)); } } else { //message = "Invalid Email"; ModelState.AddModelError("Email", "This is Invalid Email"); return(View(obj)); } } //ViewBag.Message = message; //return View(); }