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