public LeagueSeasonModule()
{
Get[SharedRoutes.StandingTable] = parameters => {
var seasonId = (int)parameters.seasonId;
var season = leagueRepo.GetLeagueSeasonById(seasonId);
var seasonTeams = analysisRepo.GetSeasonTeams(seasonId);
var teamsDb = leagueRepo.GetFootballTeamsByIds(seasonTeams.Select(t => t.FootballTeamId).ToArray());
var standingTable = new StandingTableDto
{
LeagueSeasonId = seasonId,
StartDate = season.StartDate,
EndDate = season.EndDate,
IsFinished = season.EndDate < DateTime.Now,
Teams = seasonTeams.Select(Mapper.Map <LeagueSeasonTeamDto>).OrderBy(t => t.TablePlace).ToList()
};
foreach (var team in standingTable.Teams)
{
var teamDb = teamsDb.Where(t => t.TeamId == team.FootballTeamId).FirstOrDefault();
team.FootballTeamName = teamDb.Name;
}
return(Response.AsJson(standingTable));
};
Get[SharedRoutes.SeasonGames] = parameters => {
var seasonId = (int)parameters.seasonId;
var seasonGames = leagueRepo.GetAllSeasonGames(seasonId).Select(Mapper.Map <GameDto>).ToList();
return(Response.AsJson(seasonGames));
};
Get[SharedRoutes.GameStats] = parameters => {
var seasonId = (int)parameters.seasonId;
var matchId = (int)parameters.id;
if (!leagueRepo.GetAllSeasonGames(seasonId).Any(g => g.GameId == matchId))
{
return(HttpStatusCode.NotFound);
}
bool onlyCreated;
var gameStatsDb = leagueRepo.GetGameStats(matchId, out onlyCreated);
var gameStats = Mapper.Map <GameInfoDto>(gameStatsDb);
return(Response.AsJson(gameStats));
};
Get[SharedRoutes.SeasonTotalStats] = parameters => {
var seasonId = (int)parameters.seasonId;
var season = leagueRepo.GetLeagueSeasonById(seasonId);
var seasonTeams = analysisRepo.GetSeasonTeams(seasonId);
var teamsFormDb_allGames = analysisRepo.GetSeasonTeamForms_AllGames(seasonId);
var teamsFormDb_homeGames = analysisRepo.GetSeasonTeamForms_HomeGames(seasonId);
var teamsFormDb_awayGames = analysisRepo.GetSeasonTeamForms_AwayGames(seasonId);
var teamTotals = new List <SeasonTeamTotalDto>();
foreach (var team in seasonTeams)
{
var teamFormDb_allGames = teamsFormDb_allGames.Where(t => t.TeamId == team.FootballTeamId).FirstOrDefault();
var teamFormDb_homeGames = teamsFormDb_homeGames.Where(t => t.TeamId == team.FootballTeamId).FirstOrDefault();
var teamFormDb_awayGames = teamsFormDb_awayGames.Where(t => t.TeamId == team.FootballTeamId).FirstOrDefault();
var teamTotal = new SeasonTeamTotalDto
{
FootballTeamId = team.FootballTeamId,
FootballTeamName = team.FootballTeam.Name,
GamePlayed = team.GamePlayed,
TotalOver = teamFormDb_allGames?.GamesOver2_5 ?? 0,
TotalUnder = teamFormDb_allGames?.GamesUnder2_5 ?? 0,
TotalOverHome = teamFormDb_homeGames?.GamesOver2_5 ?? 0,
TotalUnderHome = teamFormDb_homeGames?.GamesUnder2_5 ?? 0,
TotalOverAway = teamFormDb_awayGames?.GamesOver2_5 ?? 0,
TotalUnderAway = teamFormDb_awayGames?.GamesUnder2_5 ?? 0
};
teamTotals.Add(teamTotal);
}
var totalTable = new TotalTableDto
{
LeagueSeasonId = seasonId,
StartDate = season.StartDate,
EndDate = season.EndDate,
IsFinished = season.EndDate < DateTime.Now,
Teams = teamTotals.OrderBy(t => t.TotalOver).ToList()
};
return(Response.AsJson(totalTable));
};
Get[SharedRoutes.SeasonBttsStats] = parameters => {
var seasonId = (int)parameters.seasonId;
var season = leagueRepo.GetLeagueSeasonById(seasonId);
var seasonTeams = analysisRepo.GetSeasonTeams(seasonId);
var teamsFormDb_allGames = analysisRepo.GetSeasonTeamForms_AllGames(seasonId);
var teamsFormDb_homeGames = analysisRepo.GetSeasonTeamForms_HomeGames(seasonId);
var teamsFormDb_awayGames = analysisRepo.GetSeasonTeamForms_AwayGames(seasonId);
var teamTotals = new List <SeasonTeamBttsDto>();
foreach (var team in seasonTeams)
{
var teamFormDb_allGames = teamsFormDb_allGames.Where(t => t.TeamId == team.FootballTeamId).FirstOrDefault();
var teamFormDb_homeGames = teamsFormDb_homeGames.Where(t => t.TeamId == team.FootballTeamId).FirstOrDefault();
var teamFormDb_awayGames = teamsFormDb_awayGames.Where(t => t.TeamId == team.FootballTeamId).FirstOrDefault();
var teamTotal = new SeasonTeamBttsDto
{
FootballTeamId = team.FootballTeamId,
FootballTeamName = team.FootballTeam.Name,
GamePlayed = team.GamePlayed,
BttsYes = teamFormDb_allGames?.BTTS_Yes ?? 0,
BttsNo = teamFormDb_allGames?.BTTS_No ?? 0,
BttsYesHome = teamFormDb_homeGames?.BTTS_Yes ?? 0,
BttsNoHome = teamFormDb_homeGames?.BTTS_No ?? 0,
BttsYesAway = teamFormDb_awayGames?.BTTS_Yes ?? 0,
BttsNoAway = teamFormDb_awayGames?.BTTS_No ?? 0
};
teamTotals.Add(teamTotal);
}
var totalTable = new BttsTableDto
{
LeagueSeasonId = seasonId,
StartDate = season.StartDate,
EndDate = season.EndDate,
IsFinished = season.EndDate < DateTime.Now,
Teams = teamTotals.OrderBy(t => t.BttsYes).ToList()
};
return(Response.AsJson(totalTable));
};
}
