public ActionResult Index() { HomeViewModel home = new HomeViewModel(); var tags = db.tags.ToList(); var demotivators = db.Demotivators.Include(s => s.AspNetUser).ToList(); home.demotivators = demotivators; home.tags = tags; home.DemCount = db.Demotivators.Count(); return View(home); }
public ActionResult Index() { HomeViewModel home = new HomeViewModel(); var tags = db.tags.ToList(); var demotivators = db.Demotivators.Include(s => s.AspNetUser).ToList(); var TopNewDemotivators = demotivators.OrderByDescending(d => d.Date).Take(9).ToList(); var TopRateDemotivators = demotivators.OrderByDescending(r => r.RateCount).Take(9).ToList(); var TopDiscusDemotivators = demotivators.OrderByDescending(d => d.Comments.Count()).Take(9).ToList(); home.TopDiscusDemotivators = TopDiscusDemotivators; home.TopDateDemotivators = TopNewDemotivators; home.TopRateDemotivators = TopRateDemotivators; home.demotivators = demotivators; home.tags = tags; home.DemCount = demotivators.Count(); return View(home); }