private List <BlogEntry> GetBlog(int pageSize, int skip) { using (b3752Entities db = new b3752Entities()) { db.Database.CommandTimeout = 5; db.Database.Connection.Open(); db.Database.Log = Console.Write; IEnumerable <BlogEntry> blogEntries = new List <BlogEntry>(from blogs in db.Blogs let admin = blogs.Admins let blogsTags = blogs.BlogsTags let tags = blogs.BlogsTags.Select(i => i.Tags) orderby blogs.CreationDate descending select new BlogEntry { ID = blogs.ID, CreationDate = blogs.CreationDate, ModifyingDate = blogs.ModifyingDate, Url = blogs.Url, Title = blogs.Title, Body = blogs.Body, AdminID = admin.ID, AdminName = admin.Name, TagsList = tags.ToList() }).ToList().Skip(skip).Take(pageSize); db.Database.Connection.Close(); return(new List <BlogEntry>(blogEntries)); } }
public ActionResult Run() { string username = Request.Form["usx"]; string password = SecurityPassword.CreateMD5Hash(Request.Form["passx"]); string guid = Request.Form["guid"]; if (guid == viewModel.CRN) { using (b3752Entities db = new b3752Entities()) { db.Configuration.ProxyCreationEnabled = false; Guid ID = (from admins in db.Admins where admins.Username == username select admins.ID).Single(); Models.Admins admin = (from admins in db.Admins where admins.ID == ID && admins.Password == password select admins).Single(); if (admin == null) { return(Redirect("/Admin/LogIn")); } else { Session["AdminID"] = admin.ID; return(Redirect("/Admin/Dashboard")); } } } else { return(Redirect("/Admin/LogIn")); } }
private BlogEntry GetBlogByUrl(string url) { using (b3752Entities db = new b3752Entities()) { db.Database.CommandTimeout = 5; db.Database.Connection.Open(); db.Database.Log = Console.Write; BlogEntry blogEntry = (from blogs in db.Blogs let admin = blogs.Admins let blogsTags = blogs.BlogsTags let tags = blogs.BlogsTags.Select(i => i.Tags) where blogs.Url == url orderby blogs.CreationDate descending select new BlogEntry() { ID = blogs.ID, CreationDate = blogs.CreationDate, ModifyingDate = blogs.ModifyingDate, Url = blogs.Url, Title = blogs.Title, Body = blogs.Body, AdminID = admin.ID, AdminName = admin.Name, TagsList = tags.ToList() }).FirstOrDefault(); db.Database.Connection.Close(); return(blogEntry); } }
private int GetTotal() { using (b3752Entities db = new b3752Entities()) { db.Database.CommandTimeout = 5; db.Database.Connection.Open(); int count = db.Blogs.Count(); db.Database.Connection.Close(); return(count); } }
// GET: Admin/HomeEdit public ActionResult Index() { ViewData["Status"] = String.Empty; using (b3752Entities db = new b3752Entities()) { ViewData["HomeData"] = ((from homeDb in db.Home orderby homeDb.ModifyingDate descending select homeDb.HomeText).FirstOrDefault() == null) ? string.Empty : (from homeDb in db.Home orderby homeDb.ModifyingDate descending select homeDb.HomeText).FirstOrDefault(); } return(View()); }
private int GetTotalByTagName(string tag) { using (b3752Entities db = new b3752Entities()) { db.Database.CommandTimeout = 5; db.Database.Connection.Open(); int count = (from blogs in db.Blogs let blogTags = blogs.BlogsTags let tags = blogTags.Select(i => i.Tags) where blogs.BlogsTags.Any(i => i.Tags.Name == tag) select blogs).Count(); db.Database.Connection.Close(); return(count); /* * SELECT COUNT(blogs.ID) * FROM */ } }
public ActionResult Submit() { string editor = Request.Form["editor"].ToString(); using (b3752Entities db = new b3752Entities()) { db.Configuration.ProxyCreationEnabled = false; Models.Home home = new Models.Home { ID = Guid.NewGuid(), HomeText = editor, ModifyingDate = DateTime.Now }; home = db.Home.Add(home); db.SaveChanges(); if (home == null) { return(Redirect("/Admin/Home/Status/Error")); } else { return(Redirect("/Admin/Home/Status/Success")); } } }
public ActionResult Index() { if (Session["AdminID"] != null) { using (b3752Entities db = new b3752Entities()) { Models.Admins admin = db.Admins.Find(Guid.Parse(Session["AdminID"].ToString())); if (admin != null) { return(View()); } else { return(Redirect("/Admin/LogIn")); } } } else { return(Redirect("/Admin/LogIn")); } }