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