public ActionResult Login(Users registeredUser) { try { using (CraigsDB db = new CraigsDB()) { var usr = db.craigsUsers.Single(u => u.Email == registeredUser.Email && u.Password == registeredUser.Password); //only if the user email and password are true then it is not null and a session can be created. { Session["Id"] = usr.Id.ToString(); Session["Email"] = usr.Email.ToString(); Session["Name"] = usr.Name.ToString(); if (Session["Email"].ToString() == "*****@*****.**") { return(RedirectToAction("Index", "BlogUsers")); } else { return(RedirectToAction("MembersPage", "BlogUsers")); } } } } catch (Exception) // taken from http://www.codeproject.com/Articles/850062/Exception-handling-in-ASP-NET-MVC-methods-explaine { ModelState.AddModelError("", "Login attempt has been unsuccessful. Please try again."); return(View()); } }
// // GET: /BlogCreation/ public ActionResult Index() { using (CraigsDB db = new CraigsDB()) { return(View(db.craigsBlogs.ToList())); } }
// // GET: /BlogUsers/ public ActionResult Index() { using (CraigsDB db = new CraigsDB()) { return(View(db.craigsUsers.ToList())); //to see a list of table contents } }
public JsonResult publicBlogsCount() { using (CraigsDB db = new CraigsDB()) { var blogtotal = (db.craigsBlogs.Where(p => (p.IsPublic == true)).Count());// checks database, counts public blogs and returns a number - puts it into variable blogtotal return(Json(blogtotal, JsonRequestBehavior.AllowGet)); } }
public ActionResult CreateBlog(Blogs newBlog) { using (CraigsDB db = new CraigsDB()) { db.craigsBlogs.Add(newBlog); db.SaveChanges(); } ModelState.Clear(); ViewBag.Message = "Your blog entry has been created."; return(View()); }
public JsonResult GetPreviousPost(int Id) { using (CraigsDB db = new CraigsDB()) { Blogs post = new Blogs(); post = db.craigsBlogs.Where(p => (p.IsPublic == true) && (p.Id == (Id - 1))) .OrderBy(p => p.Id) .FirstOrDefault(); return(Json(post, JsonRequestBehavior.AllowGet)); } }
public JsonResult GrabNewestPost() { using (CraigsDB db = new CraigsDB()) { Blogs post = new Blogs(); post = db.craigsBlogs.Where(p => (p.IsPublic == true)) .OrderByDescending(p => p.Id) .FirstOrDefault(); return(Json(post, JsonRequestBehavior.AllowGet)); } }
public ActionResult Registration(Users newAccount) { if (ModelState.IsValid) { using (CraigsDB db = new CraigsDB()) { db.craigsUsers.Add(newAccount); db.SaveChanges(); } ModelState.Clear(); ViewBag.Message = newAccount.Name + "'s account has been registered!"; } else { ModelState.AddModelError("", "Please try entering your details again"); } return(View()); }