Beispiel #1
0
        public ActionResult Index(Post post)
        {
            using (BlogConnection conn = new BlogConnection())
            {
                if (post.BlogTitle == null)
                {
                    List <Post> allpost = conn.Posts.Select(x => x).OrderByDescending(x => x.BlogPostedOn).ToList();
                    ViewBag.AllPost = allpost;
                }
                else
                {
                    List <Post> allpost = conn.Posts.Where(x => x.BlogTitle.Contains(post.BlogTitle)).OrderByDescending(y => y.BlogPostedOn).ToList();
                    ViewBag.AllPost = allpost;
                }

                List <SelectListItem> Categorier = conn.Categories.Select(c => new SelectListItem {
                    Value = c.CategoryID.ToString(), Text = c.CategoryDescription
                }).ToList();
                ViewBag.Drop = Categorier;

                List <Category> CatAll = conn.Categories.Select(x => x).ToList();
                ViewBag.AllCat = CatAll;
            }
            return(View());
        }
Beispiel #2
0
        // GET: Home
        public ActionResult Index()
        {
            using (BlogConnection conn = new BlogConnection())
            {
                var theid = TempData["id"];

                if (theid == null || (int)theid == 0)
                {
                    List <Post> allPost = conn.Posts.Select(x => x).OrderByDescending(x => x.BlogPostedOn).ToList();
                    ViewBag.AllPost = allPost;
                }
                else
                {
                    List <Post> allpost = conn.Posts.Where(x => x.CategoryID == (int)theid).OrderByDescending(x => x.BlogPostedOn).ToList();
                    ViewBag.AllPost = allpost;
                }

                List <SelectListItem> Categorier = conn.Categories.Select(c => new SelectListItem {
                    Value = c.CategoryID.ToString(), Text = c.CategoryDescription
                }).ToList();
                ViewBag.Drop = Categorier;

                List <Category> CatAll = conn.Categories.Select(x => x).ToList();
                ViewBag.AllCat = CatAll;
            }
            return(View());
        }
Beispiel #3
0
 public ActionResult Sort(int id)
 {
     using (BlogConnection conn = new BlogConnection())
     {
         TempData["id"] = id;
         return(RedirectToAction("Index"));
     }
 }
Beispiel #4
0
 public ActionResult Create()
 {
     using (BlogConnection conn = new BlogConnection())
     {
         List <SelectListItem> Categorier = conn.Categories.Select(c => new SelectListItem {
             Value = c.CategoryID.ToString(), Text = c.CategoryDescription
         }).ToList();
         ViewBag.Cats = Categorier;
     }
     return(RedirectToAction("Index"));
 }
Beispiel #5
0
        public ActionResult Create(Post newPost, FormCollection items)
        {
            newPost.CategoryID   = int.Parse(items["Drop"]);
            newPost.BlogPostedOn = DateTime.Now;

            using (BlogConnection conn = new BlogConnection())
            {
                conn.Posts.Add(newPost);
                conn.SaveChanges();

                return(RedirectToAction("Index"));
            }
        }
 public BlogController(BlogConnection connection)
 {
     _connection = connection;
 }