public void PopulateLeagueTable()
{
PopulatePlayerPicks();
using (var db = new leaguepredictorEntities())
{
CurrentLeaguePositions = db.team_rankings.Select(tr => new LeaguePosition {
Team = tr.team.team_name, Position = tr.position
})
.ToList();
//calculate each player scores
PlayerPicks.ForEach(pp =>
{
var ltm = GenerateLeagueTableModel(pp);
ltm.ID = pp.ID;
LeagueTable.Add(ltm);
});
LeagueTable = LeagueTable.OrderBy(ltm => ltm.Points).ToList();
foreach (var ltm in LeagueTable)
{
ltm.Position = LeagueTable.IndexOf(ltm) + 1;
}
}
}
