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