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());
}
