private LeagueTableModel GenerateLeagueTableModel(PlayerPicks playerPicks) { var ltm = new LeagueTableModel(); ltm.Player = playerPicks.Player; foreach (var lp in playerPicks.Selections) { var points = GetPositionDifference(lp); if (points == 0) { ltm.Correct++; } ltm.Points += points; } return(ltm); }
public void PopulatePlayerPicks() { using (var db = new leaguepredictorEntities()) { var playerSelections = db.players_selections.Select(sel => new { Player = sel.player.name, Team = sel.team.team_name, Position = sel.position, Id = sel.player.id }).ToList(); foreach (var p in playerSelections.Select(p => p.Player).Distinct()) { var pp = new PlayerPicks(); pp.Player = p; pp.ID = db.players.Where(pl => pl.name.Equals(p)).Single().id; pp.Selections = playerSelections.Where(ps => ps.Player.Equals(pp.Player)) .Select(ps => new LeaguePosition { Team = ps.Team, Position = ps.Position }) .ToList(); PlayerPicks.Add(pp); } } }