// 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();
}
}
}
