/// <summary>
/// Method that will Update the Game passed in the parameters to the database
/// </summary>
/// <param name="game">Object Game to Update</param>
public async Task <ApiResponse> Update(Game game)
{
try
{
if (!await _teamBusiness.DuplicatePlayer(game.Plays.ToList()))
{
await _context.Database.ExecuteSqlInterpolatedAsync($"UPDATE [dbo].[GAME] SET [Game_fk_Route_Id] = {game.IdRoute}, [Game_fk_Organizer_Id] = {game.IdOrganizer}, [Game_fk_Transport_Id] = {game.IdTransport} WHERE [Game_Id] = {game.Id}");
await _context.SaveChangesAsync();
// Récupérer tous les id actuels des teams de la game dans la DB
var currentIdPlays = await _context.Plays.Where(p => p.IdGame == game.Id).Select(p => p.IdTeam).ToListAsync();
// Récuperer tous les id teams de la game envoyée en paramètre
var idPlay = game.Plays.Select(p => p.IdTeam).ToList();
// liste des id de la BDD qui ne sont pas dans les ID de l'update
var oldIdPlay = currentIdPlays.Where(p => !idPlay.Contains(p)).ToList();
var responseDelete = await _playBusiness.DeleteFromGame(await _context.Plays.Where(p => p.IdGame == game.Id && oldIdPlay.Contains(p.IdTeam)).ToListAsync());
if (responseDelete.Status == ApiStatus.Ok)
{
var responsePlayAdd = await _playBusiness.SetUp(game.Plays.Where(p => !currentIdPlays.Contains(p.IdTeam)).ToList(), game.Id);
if (responsePlayAdd.Status == ApiStatus.Ok)
{
var responseDeleteTeamRoutes = await _gameBusiness.DeleteAllTeamsRoute(game.Id);
if (responseDeleteTeamRoutes.Status == ApiStatus.Ok)
{
var reponseGenerate = await _gameBusiness.GenerateTeamRoute(await this.FindNoTracking(game.Id), game.Id);
if (reponseGenerate.Status == ApiStatus.Ok)
{
return new ApiResponse {
Status = ApiStatus.Ok, Message = ApiAction.Update, Response = await this.Find(game.Id)
}
}
;
else
{
return(reponseGenerate);
}
}
else
{
return(responseDeleteTeamRoutes);
}
}
else
{
return(responsePlayAdd);
}
}
else
{
return(responseDelete);
}
}
else
{
return(new ApiResponse {
Status = ApiStatus.CantAdd, Message = "Impossible, un joueur est dans plusieurs équipes selectionnées !"
});
}
}
catch (Exception e)
{
return(TranslateError.Convert(e));
}
}
