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