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