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));
}
