// GET: Analytics public ActionResult Index() { using (rvcaEntities db = new rvcaEntities()) { List <analytic> analyticCollection = new List <analytic>(); analyticCollection = db.analytics.OrderByDescending(x => x.publicationDate).ToList(); return(View("Index", analyticCollection)); } }
public ActionResult Index() { HomeViewModel homeModelData = new HomeViewModel(); using (rvcaEntities db = new rvcaEntities()) { homeModelData.all_news = db.news.OrderByDescending(x => x.publicationDate).Take(3).ToList(); homeModelData.all_analytics = db.analytics.OrderByDescending(x => x.publicationDate).Take(3).ToList(); } return(View(homeModelData)); }
public ActionResult View(int id) { using (rvcaEntities db = new rvcaEntities()) { news newsToShow = db.news.FirstOrDefault(x => x.id == id); if (newsToShow == null) { newsToShow = new news(); } return(View("ViewNews", newsToShow)); } }
public ActionResult View(int id) { using (rvcaEntities db = new rvcaEntities()) { analytic item = db.analytics.FirstOrDefault(x => x.id == id); if (item == null) { item = new analytic(); } return(View("ViewAnalytics", item)); } }
// GET: News public ActionResult Index() { string tag = string.Empty; if (Request["tag"] != null) { tag = Request["tag"]; } using (rvcaEntities db = new rvcaEntities()) { List <news> newsCollection = new List <news>(); if (string.IsNullOrEmpty(tag)) { newsCollection = db.news.OrderByDescending(x => x.publicationDate).ToList(); } else { newsCollection = db.news.OrderByDescending(x => x.publicationDate).Where(x => x.newsTag == tag).ToList(); } return(View("Index", newsCollection)); } }