public void ResetHighScoresFromDb()
{
using (var db = new HighScoreContext())
{
db.Database.ExecuteSqlCommand("TRUNCATE TABLE [players]");
db.Database.ExecuteSqlCommand("TRUNCATE TABLE [scores]");
}
}
// 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();
}
}
}
public List <Player> GetPlayersFromDb()
{
List <Player> playerList = new List <Player>();
using (var db = new HighScoreContext())
{
var query = from p in db.Players orderby p.Name select p;
foreach (var item in query)
{
playerList.Add(item);
}
}
return(playerList);
}
public List <Score> GetHighScoresFromDb()
{
List <Score> scoreList = new List <Score>();
using (var db = new HighScoreContext())
{
var query = from s in db.Scores orderby s.NbrOfWins select s;
foreach (var item in query)
{
scoreList.Add(item);
}
}
return(scoreList);
}
// 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();
}
}
}
