public void CreatePlayer(string nick, string pass)
{
PLAYERS pl = new PLAYERS();
pl.NickName = nick;
pl.Password = pass;
pl.Coins = DEFAULT_PLAYER_COINS;
pl.GamesCount = 0;
pl.WinCount = 0;
_bJContext.PLAYERS.Add(pl);
_bJContext.SaveChanges();
}
public void UpdatePlayer(int playerID, int WinnerID)
{
PLAYERS pl = GetPLAYERS(playerID);
pl.GamesCount++;
if (playerID == WinnerID)
{
pl.WinCount++;
}
_bJContext.PLAYERS.Attach(pl);
_bJContext.Entry(pl).State = System.Data.Entity.EntityState.Modified;
_bJContext.SaveChanges();
}
private PLAYERS GetPLAYERS(int playerID)
{
PLAYERS pl = new PLAYERS();
using (var db = new BJContext())
{
var query = from s in db.PLAYERS
where s.PlayerID == playerID
select s;
foreach (var student in query)
{
if (student.PlayerID != 0)
{
pl = student;
}
}
}
return(pl);
}
