private void AddGameToDB(Game game) { using (MinesweeperDataBaseEntities ctx = new MinesweeperDataBaseEntities()) { game.Id = (from g in ctx.Games select g.Id).Max() + 1; ctx.Games.Add(game); } }
public bool IsLegalUser(string username, string password) { using (MinesweeperDataBaseEntities ctx = new MinesweeperDataBaseEntities()) { return((from p in ctx.Players where p.UserName == username && p.Password == password select p.UserName).ToList().Count != 0); } }
public bool PlayerExists(string username) { using (MinesweeperDataBaseEntities ctx = new MinesweeperDataBaseEntities()) { return((from p in ctx.Players where p.UserName == username select p.UserName).ToList().Count != 0); } }
public void EnterPlayerToDB(Player player) { using (MinesweeperDataBaseEntities ctx = new MinesweeperDataBaseEntities()) { if (PlayerExists(player.UserName)) { throw new FaultException <UserExistsFault>( new UserExistsFault { Message = player.UserName + " already exists" }, new FaultReason(player.UserName + " already exists")); } else { ctx.Players.Add(player); ctx.SaveChanges(); } } }
public List <string[]> GetAllGames() { List <string[]> allGames = new List <string[]>(); using (MinesweeperDataBaseEntities ctx = new MinesweeperDataBaseEntities()) { foreach (Game game in ctx.Games.ToList()) { string[] gameStats = new string[4]; gameStats[0] = game.GameDate.ToString(); gameStats[1] = game.Winner; gameStats[2] = game.Loser; gameStats[3] = game.Tie ? "YEAH" : "NOPE"; allGames.Add(gameStats); } return(allGames); } }
public List <string[]> GetAllPlayers() { List <string[]> allPlayerStats = new List <string[]>(); using (MinesweeperDataBaseEntities ctx = new MinesweeperDataBaseEntities()) { foreach (Player p in ctx.Players.ToList()) { { string[] playerStats = new string[6]; var gamesWon = (from g in ctx.Games where g.Winner == p.UserName select g).ToList().Count; var gamesLost = (from g in ctx.Games where g.Loser == p.UserName select g).ToList().Count; var gamesTied = (from g in ctx.Games where g.Tie && (g.Winner == p.UserName) || (g.Loser == p.UserName) select g).ToList().Count; var totalGames = gamesWon + gamesLost + gamesTied; var winPercent = totalGames == 0 ? 0 : (double)gamesWon / totalGames; playerStats[0] = p.UserName; playerStats[1] = gamesWon.ToString(); playerStats[2] = gamesLost.ToString(); playerStats[3] = gamesTied.ToString(); playerStats[4] = totalGames.ToString(); playerStats[5] = winPercent.ToString(); allPlayerStats.Add(playerStats); } } } return(allPlayerStats); }