public ActionResult Registration(User user) { string message = ""; bool status = false; if (ModelState.IsValid) { bool isExist = EmailChecker(user.Email); if (isExist == true) { ModelState.AddModelError("EmailExist", "This email has already used!"); return(View(user)); } using (YourLibraryDBEntities dc = new YourLibraryDBEntities()) { dc.Users.Add(user); dc.SaveChanges(); message = "Registration is succesfully done!"; status = true; } } else { message = "Invalid entries!"; } ViewBag.Message = message; ViewBag.Status = status; return(View()); }
public bool EmailChecker(string email) { using (YourLibraryDBEntities dc = new YourLibraryDBEntities()) { var v = dc.Users.Where(a => a.Email == email).FirstOrDefault(); //select * from User where Email = email if (v != null) { return(true); } else { return(false); } } }
public void Add(int id) { var context = new YourLibraryDBEntities(); User user = Session["mydata"] as User; var book = (from b in context.Books select b).FirstOrDefault(i => i.Id == id); var library = (from u in context.Users select u).FirstOrDefault(i => i.Id == user.Id); if (library.Books.Where(i => i.Id == id).Count() != 0) { } else { library.Books.Add(book); context.SaveChanges(); } }
public override string[] GetRolesForUser(string username) { YourLibraryDBEntities db = new YourLibraryDBEntities(); var user = db.Users.FirstOrDefault(x => x.Email == username); if (user.Role != true) { return(new string[] { "A" }); //string adminRole = admin.Role; } else if (user.Role == true) { return(new string[] { "U" }); //string lecturerRole = lecturer.Role; } else { return(null); } }