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()); }
// 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()); }
public ActionResult Sort(int id) { using (BlogConnection conn = new BlogConnection()) { TempData["id"] = id; return(RedirectToAction("Index")); } }
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")); }
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; }