public ActionResult Index(RankingsIndexModel rankingsIndexModel) { rankingsIndexModel.Rankings = db.rankings .Select(ranking => ranking) .Where(r => r.year.Value == rankingsIndexModel.Year && r.player.gender == rankingsIndexModel.Type) .OrderByDescending(r => r.points) .ToList(); rankingsIndexModel.Years = new SelectList(db.rankings .Select(ranking => ranking) .Where(r => r.player.gender == rankingsIndexModel.Type) .Select(r => r.year.Value) .Distinct() .OrderByDescending(year => year)); return(View(rankingsIndexModel)); }
public ActionResult Index(RankingsIndexModel rankingsIndexModel) { rankingsIndexModel.Rankings = db.Ranking .Include("Player") .Include("Player.Country") .Select(ranking => ranking) .Where(r => r.Year.Value == rankingsIndexModel.Year && r.Player.Gender == rankingsIndexModel.Type) .OrderByDescending(r => r.Points) .ToList(); rankingsIndexModel.Years = new SelectList(db.Ranking .Include("Player") .Include("Player.Country") .Select(ranking => ranking) .Where(r => r.Player.Gender == rankingsIndexModel.Type) .Select(r => r.Year.Value) .Distinct() .OrderByDescending(year => year)); return(View(rankingsIndexModel)); }