public async Task OnGetAsync(string sortOrder) { SetCurrentLeague(); //Calls BasePageModel to setup current league in base LeagueSelectVM NameSort = String.IsNullOrEmpty(sortOrder) ? "Name_desc" : ""; PointSort = sortOrder == "Points_desc" ? "Points" : "Points_desc"; TeamSort = sortOrder == "Team" ? "Team_desc" : "Team"; LevelSort = sortOrder == "Level" ? "Level_desc" : "Level"; TeamPlayers = await _teamPlayerService.GetTeamPlayersForLeagueAsync(LeagueSelectVM.SelectedLeague.LeagueId); TeamPlayersIQ = TeamPlayers.AsQueryable(); switch (sortOrder) { case "Name_desc": TeamPlayersIQ = TeamPlayersIQ.OrderByDescending(tp => tp.Player.PlayerName); break; case "Points": TeamPlayersIQ = TeamPlayersIQ.OrderBy(tp => tp.GamesWon); break; case "Points_desc": TeamPlayersIQ = TeamPlayersIQ.OrderByDescending(tp => tp.GamesWon); break; case "Team": TeamPlayersIQ = TeamPlayersIQ.OrderBy(tp => tp.Team.TeamNo).ThenBy(tp => tp.Level); break; case "Team_desc": TeamPlayersIQ = TeamPlayersIQ.OrderByDescending(tp => tp.Team.TeamNo); break; case "Level": TeamPlayersIQ = TeamPlayersIQ.OrderBy(tp => tp.Level).ThenByDescending(tp => tp.GamesWon); break; case "Level_desc": TeamPlayersIQ = TeamPlayersIQ.OrderByDescending(tp => tp.Level); break; default: TeamPlayersIQ = TeamPlayersIQ.OrderBy(tp => tp.Player.PlayerName); break; } TeamPlayers = TeamPlayersIQ.AsNoTracking().ToList(); }
public async Task OnGetAsync() { //Message = "My key val = " + _configuration["SecretDataConnection"]; SetCurrentLeague(); var teamPlayers = await _teamPlayerService.GetTeamPlayersForLeagueAsync(LeagueSelectVM.SelectedLeague.LeagueId); var tempLeagueTable = teamPlayers.GroupBy(t => t.Team) .Select(ct => new TeamVM { TeamId = ct.First().Team.TeamId, TeamName = ct.First().Team.TeamName, TeamNo = ct.First().Team.TeamNo, Section = ct.First().Team.Section, MatchesPlayed = ct.Sum(c => c.MatchesPlayed), MatchesWon = ct.Sum(c => c.MatchesWon), GamesWon = ct.Sum(c => c.GamesWon), GamesLost = ct.Sum(c => c.GamesLost) }).OrderByDescending(c => c.GamesWon).ToList(); LeagueTableA = tempLeagueTable.Where(t => t.Section == "A").ToList(); LeagueTableB = tempLeagueTable.Where(t => t.Section == "B").ToList(); }
public async Task OnGetAsync() { TeamPlayer = await _teamPlayerService.GetTeamPlayersForLeagueAsync(21); }