public ActionResult SaveFcDeHoekGame(FcDeHoekGameModel model)
{
using (var context = new FcDeHoekContext())
{
var statsToRemove = context.PersonStatistics.Where(ps => ps.IdGame == model.IdGame).ToList();
if (statsToRemove.Any())
{
context.PersonStatistics.RemoveRange(statsToRemove);
context.SaveChanges();
}
foreach (var player in model.PlayersInGame)
{
if (player.IdPlayer != -1)
{
var stat = new PersonStats
{
IdGame = model.IdGame,
IdPerson = player.IdPlayer,
Assists = player.AssistsGiven,
Goals = player.GoalsScored,
Played = true
};
context.PersonStatistics.AddOrUpdate(stat);
context.SaveChanges();
}
}
return(FcDeHoekGameDetail(model.IdGame));
}
}
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);
}