public ActionResult Single(int?id)
        {
            if (id == null)
            {
                return(HttpNotFound("ID is missing"));
            }

            Blog blog = db.Blogs.Find(id);

            if (blog == null)
            {
                return(HttpNotFound("This news does not exists"));
            }
            User user = Session["user"] as User;
            BlogSingleViewModel vm = new BlogSingleViewModel
            {
                Blog         = blog,
                BlogTags     = db.BlogTags.ToList(),
                NewsToTags   = db.BlogToTags.ToList(),
                BlogHeader   = db.BlogHeaders.First(),
                BlogComments = db.BlogComments.ToList(),
                Likes        = db.Likes.Where(l => l.BlogID == blog.ID).ToList(),
                RecentBlogVM = new RecentBlogViewModel
                {
                    Blogs = db.Blogs.Where(n => n.ID != id).OrderByDescending(n => n.UpdatedAt).Take(5).ToList()
                }
            };

            return(View(vm));
        }
Example #2
0
        public ActionResult Post(int postId)
        {
            var db = new BlogDb(_connectionString);
            var vm = new BlogSingleViewModel();

            vm.Post     = db.GetPostById(postId);
            vm.Comments = db.GetCommentsForPost(postId);
            vm.Tags     = db.GetTagsForPost(postId);
            return(View(vm));
        }