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