private static List <RecordsTempData> GetHistoricData(FcDeHoekContext context, int idSeason = -1) { var tempDataList = new List <RecordsTempData>(); var allPlayers = PersonQueries.GetPlayers(context).ToList(); foreach (var player in allPlayers) { var historicStats = idSeason != -1 ? HistoricStatsQueries.GetByIdPlayer(context, player.IdPerson).Where(hs => hs.IdSeason == idSeason).ToList() : HistoricStatsQueries.GetByIdPlayer(context, player.IdPerson).ToList(); if (historicStats.Any()) { var tempData = new RecordsTempData { IdPlayer = player.IdPerson, Player = $"{player.Name} {player.FirstName}" }; foreach (var stat in historicStats) { tempData.Goals += stat.Goals ?? 0; tempData.Assists += stat.Assists ?? 0; tempData.Penalties += stat.Penalties ?? 0; } tempDataList.Add(tempData); } } return(tempDataList); }
private List <PersonModel> GetPlayers() { using (var context = new FcDeHoekContext()) { var models = new List <PersonModel>(); var persons = PersonQueries.GetPlayers(context).ToList(); foreach (var person in persons) { if (person.PerkezNumber != null) { models.Add(MapPersonToPersonModel(context, person)); } } return(models); } }
private List <RecordsTempData> GetCurrentData(FcDeHoekContext context, List <RecordsTempData> historicData, int idSeason = -1) { var allPlayers = PersonQueries.GetPlayers(context).ToList(); foreach (var player in allPlayers) { var stats = PersonStatisticsQueries.GetByIdPerson(context, player.IdPerson).ToList(); if (stats.Any()) { var tempData = new RecordsTempData { IdPlayer = player.IdPerson, Player = $"{player.Name} {player.FirstName}" }; foreach (var stat in stats) { var game = GameQueries.GetById(context, stat.IdGame); if (game != null && game.IdCompetition == eCompetitionType.League && (game.IdSeason == idSeason || idSeason == -1)) { if ((stat.Goals != null && stat.Goals != 0) || stat.Assists != 0) { var playersHistoricData = historicData.FirstOrDefault(hd => hd.IdPlayer == player.IdPerson); if (playersHistoricData != null) { playersHistoricData.Assists += stat.Assists; playersHistoricData.Goals += stat.Goals ?? 0; } else { tempData.Assists += stat.Assists; tempData.Goals += stat.Goals ?? 0; historicData.Add(tempData); } } } } } } return(historicData); }
private object GetGameModel(FcDeHoekContext context, Game game) { var model = new FcDeHoekGameModel(); model.MatchDate = game.MatchDate; model.IdGame = game.IdGame; model.GameFixture = $"{game.GameHomeTeam.Name} - {game.GameAwayTeam.Name}"; model.GoalsHome = game.GoalsHomeTeam ?? 0; model.GoalsAway = game.GoalsAwayTeam ?? 0; model.AllGames = GetAllFcDeHoekGames(context, game.MatchDate); var players = PersonQueries.GetPlayers(context).ToList(); model.AllPlayers = SetAllPlayers(players); model.PlayersInGame = GetPlayersInGame(context, players, game.IdGame); return(model); }