public async Task <int> SaveScore(ShapeModel winnerShape) { using (var db = new PlayerDb()) { var players = from p in db.player select p; foreach (var p in players) { p.GamesPlayed += 1; if (p.PlayerID == winnerShape.ActivePlayerId) { p.GamesWon += 1; } db.Entry(p).State = System.Data.Entity.EntityState.Modified; } var i = await db.SaveChangesAsync(); return(i); } }
public async Task <int> updateDb(List <ShapeModel> shapeList, ShapeModel winner) { using (var db = new PlayerDb()) { var players = from p in db.player select p; foreach (var p in players) { if (shapeList.Exists(s => s.ActivePlayerId == p.PlayerID)) { p.GamesPlayed += 1; } if (p.PlayerID == winner.ActivePlayerId) { p.GamesWon += 1; } db.Entry(p).State = System.Data.Entity.EntityState.Modified; } var i = await db.SaveChangesAsync(); return(i); } }