// // GET: /NewsListing/ public ActionResult Index() { using (MagazineDBEntities contxt = new MagazineDBEntities()) { List<Category> categories = contxt.Categories.ToList(); return View(categories); } }
public PartialViewResult TitleDetails(int categoryID) { using (MagazineDBEntities contxt = new MagazineDBEntities()) { List<News> categoryNews = (from news in contxt.News where news.CategoryID == categoryID && news.IsActive == true select news).ToList(); return PartialView("_NewsListing", categoryNews); } }
public PartialViewResult DescriptionDetails(int NewsID) { using (MagazineDBEntities contxt = new MagazineDBEntities()) { News detailNews = (from news in contxt.News where news.NewsID == NewsID select news).SingleOrDefault(); detailNews.NoOfViews = detailNews.NoOfViews + 1; contxt.SaveChanges(); return PartialView("_DescriptionDetails", detailNews); } }