// todo lägg endast till player om den inte redan finns i db public void InsertPlayerToDb(Player _player) { using (var db = new HighScoreContext()) { var player = _player; if (!(db.Players.Any(o => o.PlayerID == player.PlayerID))) { db.Players.Add(player); db.SaveChanges(); } } }
// om score finns för en player, hämta den score och inkrementera med ett public void InsertScoreToDb(Player _player) { using (var db = new HighScoreContext()) { var player = _player; var result = db.Scores.SingleOrDefault(o => o.PlayerId == player.PlayerID); if (result != null) { result.NbrOfWins = result.NbrOfWins + 1; db.SaveChanges(); } else { var score = new Score(); score.PlayerId = player.PlayerID; score.NbrOfWins = 1; db.Scores.Add(score); db.SaveChanges(); } } }