public ActionResult UpdatePost(Posts model)
{
using (var ctx = new BlogHealthEntities())
{
var post = ctx.Posts.Where(c => c.ID == model.ID).FirstOrDefault();
if (post == null)
{
return(Json(new { result = "0", msg = "Bài viết không tồn tại!" }, JsonRequestBehavior.AllowGet));
}
try
{
post.Title = model.Title;
post.Slug = model.Slug;
post.IDCategory = model.IDCategory;
post.ShortContent = model.ShortContent;
post.Content = model.Content;
post.Tag = model.Tag;
post.Update = DateTime.Now;
ctx.Entry(post).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
return(Json(new { result = "1", msg = "Cập nhật thành công!" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { result = "0", msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult DeleteCategories(int?ID)
{
if (!ID.HasValue)
{
return(Json(new { result = 0, error = "ID không tồn tại" }, JsonRequestBehavior.AllowGet));
}
using (var ctx = new BlogHealthEntities())
{
var cate = ctx.Categories.Where(c => c.ID == ID).FirstOrDefault();
try
{
if (cate != null)
{
ctx.Categories.Remove(cate);
ctx.SaveChanges();
return(Json(new { result = 1, error = "" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { result = 0, error = "Lỗi" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { result = 0, error = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
}
public async Task <ActionResult> AddPost(Posts model)
{
using (var ctx = new BlogHealthEntities())
{
model.CreateDate = DateTime.Now;
ctx.Posts.Add(model);
try
{
ctx.SaveChanges();
TempData["Success"] = "Đăng thành công!";
return(RedirectToAction("AddPost", "Admin"));
}
catch (Exception ex)
{
var post = ctx.Posts.Where(c => c.ID == model.ID).FirstOrDefault();
if (post != null)
{
ctx.Posts.Remove(post);
ctx.SaveChanges();
}
TempData["Error"] = "Lỗi đăng bài. " + ex.Message;
return(RedirectToAction("AddPost", "Admin"));
}
}
}
public ActionResult GetPosts(string IDCate, DateTime?fDate, DateTime?tDate)
{
using (var ctx = new BlogHealthEntities())
{
var posts = ctx.Posts.Join(ctx.Categories, c => c.IDCategory, b => b.ID,
(c, b) => new {
Rows = 0,
ID = c.ID,
Title = c.Title,
Slug = c.Slug,
IDCate = b.ID,
CateName = b.Name,
Likes = c.Likes ?? 0,
Views = c.Views ?? 0,
Shares = c.Shares ?? 0,
Comments = c.Comments ?? 0,
CreateDate = c.CreateDate,
Tag = c.Tag,
Rates = c.Rates ?? 0,
Update = c.Update,
}).Where(c => fDate.HasValue?c.CreateDate >= fDate:true &&
tDate.HasValue?c.CreateDate <= tDate:true &&
IDCate != ""?IDCate.Contains(c.IDCate.ToString()):true
).OrderByDescending(c => c.CreateDate).ToList();
return(Json(posts, JsonRequestBehavior.AllowGet));
}
}
// GET: Home
public ActionResult Index()
{
var t = DateTime.Now.ToString("ddd MMM YYYYY", CultureInfo.CreateSpecificCulture("vi-VN"));
using (var ctx = new BlogHealthEntities())
{
var posts = ctx.Posts.Join(ctx.Categories, c => c.IDCategory, b => b.ID,
(c, b) => new PostCate {
ID = c.ID,
Title = c.Title,
Slug = c.Slug,
IDCate = b.ID,
CateName = b.Name,
CateColor = b.Color,
Likes = c.Likes ?? 0,
Views = c.Views ?? 0,
Shares = c.Shares ?? 0,
Comments = c.Comments ?? 0,
Rates = c.Rates ?? 0,
CreateDate = c.CreateDate,
Update = c.Update,
ShortContent = c.ShortContent,
}).OrderByDescending(c => new { c.Update, c.CreateDate }).Take(10).ToList();
return(View(posts));
}
}
public ActionResult PartialMenuChild(int id)
{
using (var ctx = new BlogHealthEntities())
{
var cates = ctx.Categories.Where(c => c.ParentID == id).ToList();
return(PartialView(cates));
}
}
public ActionResult PartialMenu()
{
using (var ctx = new BlogHealthEntities())
{
var cates = ctx.Categories.Where(c => c.Level == 1).ToList();
return(PartialView(cates));
}
}
public static bool CheckMenuHasChild(int id)
{
using (var ctx = new BlogHealthEntities())
{
var cate = ctx.Categories.Where(c => c.ParentID == id).FirstOrDefault();
return(cate != null);
}
}
public ActionResult AddCategory(Categories model)
{
if (String.IsNullOrEmpty(model.Name))
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
using (var ctx = new BlogHealthEntities())
{
ctx.Categories.Add(model);
ctx.SaveChanges();
}
return(Json("1", JsonRequestBehavior.AllowGet));
}
public ActionResult GetPostAndCate(int?ID)
{
if (!ID.HasValue)
{
return(Json(new { post = "", cates = "" }, JsonRequestBehavior.AllowGet));
}
using (var ctx = new BlogHealthEntities())
{
var post = ctx.Posts.Where(c => c.ID == ID.Value).FirstOrDefault();
var cates = ctx.Categories.ToList();
if (post == null || cates == null)
{
return(Json(new { post = "", cates = "" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { post = post, cates = cates }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult UpdateCategories(Categories model)
{
using (var ctx = new BlogHealthEntities())
{
var cate = ctx.Categories.Where(c => c.ID == model.ID).FirstOrDefault();
if (cate != null)
{
cate.Name = model.Name;
cate.Priority = model.Priority;
cate.Slug = model.Slug;
cate.Color = model.Color;
ctx.Entry(cate).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
return(Json("1", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult DeletePost(int?ID)
{
if (!ID.HasValue)
{
return(Json(new { result = 0, msg = "Không tồn tại mã!" }, JsonRequestBehavior.AllowGet));
}
using (var ctx = new BlogHealthEntities())
{
try
{
var post = ctx.Posts.Where(c => c.ID == ID.Value).FirstOrDefault();
ctx.Posts.Remove(post);
ctx.SaveChanges();
return(Json(new { result = 1, msg = "Thành công" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { result = 0, msg = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult PartialMostViewPosts()
{
using (var ctx = new BlogHealthEntities())
{
var posts = ctx.Posts.Join(ctx.Categories, c => c.IDCategory, b => b.ID,
(c, b) => new PostCate
{
ID = c.ID,
Title = c.Title,
Slug = c.Slug,
IDCate = b.ID,
CateName = b.Name,
CateColor = b.Color,
Likes = c.Likes ?? 0,
Views = c.Views ?? 0,
Rates = c.Rates ?? 0,
CreateDate = c.CreateDate,
Update = c.Update,
}).OrderByDescending(c => new { c.Views }).Take(5).ToList();
return(PartialView(posts));
}
}
public ActionResult GetCategories(int kind = 1)
{
using (var ctx = new BlogHealthEntities())
{
if (kind == 1)//get all
{
// var result = ctx.Categories.OrderBy(c => c.Priority).ToList();
return(Json(ctx.Categories.OrderBy(c => c.Priority).ToList(), JsonRequestBehavior.AllowGet));
}
else if (kind == 2)//get parent title,id
{
// var result = ctx.Categories.Select(c => new { ID=c.ID, Name=c.Name }).OrderBy(c => c.ID).ToList();
return(Json(ctx.Categories.Where(c => c.Level == 1 || c.ParentID == null).Select(c => new { ID = c.ID, Name = c.Name }).OrderBy(c => c.ID).ToList(), JsonRequestBehavior.AllowGet));
}
else if (kind == 3)//get child title,id
{
// var result = ctx.Categories.Select(c => new { ID=c.ID, Name=c.Name }).OrderBy(c => c.ID).ToList();
return(Json(ctx.Categories.Where(c => c.Level == 2 || c.ParentID != null).Select(c => new { ID = c.ID, Name = c.Name }).OrderBy(c => c.ID).ToList(), JsonRequestBehavior.AllowGet));
}
return(Json("", JsonRequestBehavior.AllowGet));
// return Json(result, JsonRequestBehavior.AllowGet);
}
}
public ActionResult Post(int?id)
{
if (!id.HasValue)
{
return(View());
}
using (var ctx = new BlogHealthEntities())
{
var post = ctx.Posts.Join(ctx.Categories, c => c.IDCategory, b => b.ID,
(c, b) => new PostCate
{
ID = c.ID,
Title = c.Title,
Slug = c.Slug,
IDCate = b.ID,
CateName = b.Name,
CateColor = b.Color,
Likes = c.Likes ?? 0,
Views = c.Views ?? 0,
Shares = c.Shares ?? 0,
Comments = c.Comments ?? 0,
Rates = c.Rates ?? 0,
CreateDate = c.CreateDate,
Update = c.Update,
ShortContent = c.ShortContent,
Content = c.Content,
Tags = c.Tag,
}).FirstOrDefault();
if (post == null)
{
return(View());
}
return(View(post));
}
//return View();
}
