public void SetCoCData(CoCPlayer coCPlayer)
{
coCPlayer.COCRecordStamp = $"{DateTime.Now}";
if (_context.CoCPlayers.Any(b => b.name == coCPlayer.name))
{
var username = coCPlayer.name;
// var clanTag = "#29VG0828V";
_context.Database.ExecuteSqlRaw($"DELETE FROM Heroes WHERE COCPlayername = '{username}'");
_context.Database.ExecuteSqlRaw($"DELETE FROM Achievements WHERE COCPlayername = '{username}'");
// _context.Database.ExecuteSqlRaw($"DELETE FROM Clans WHERE tag = '{clanTag}'");
_context.Database.ExecuteSqlRaw($"DELETE FROM Spells WHERE COCPlayername = '{username}'");
_context.Database.ExecuteSqlRaw($"DELETE FROM Troops WHERE COCPlayername = '{username}'");
_context.Update(coCPlayer);
}
else
{
_context.CoCPlayers.Add(coCPlayer);
}
}
public ActionResult <CoCPlayer> SetNewPlayer(CoCPlayer coCPlayer)
{
_repository.SetCoCData(coCPlayer);
_repository.SaveChanges();
return(Ok());
}
