public List <GameDTO> GetAllGamesPlayed() { List <GameDTO> games = null; using (var ctx = new minesweeper_ShlomiOhana_YardenDananEntities()) { var games_db = from g in ctx.Games select new GameDTO(g); games = games_db.ToList(); } return(games); }
private Player GetPlayerFromDB(string username) { Player player = null; using (var ctx = new minesweeper_ShlomiOhana_YardenDananEntities()) { try { player = (from p in ctx.Players where p.UserName == username select p).First(); } catch (Exception) { throw new FaultException("Such user dosen\'t seem to exist"); } } return(player); }
public List <PlayerDTO> GetAllPlayers() { List <PlayerDTO> toRet = new List <PlayerDTO>(); List <Player> players = new List <Player>(); using (var ctx = new minesweeper_ShlomiOhana_YardenDananEntities()) { players = (from p in ctx.Players select p).ToList(); } foreach (Player player in players) { toRet.Add(new PlayerDTO(player)); } return(toRet); }
private void RegisterNewPlayer(string username, string password) { using (var ctx = new minesweeper_ShlomiOhana_YardenDananEntities()) { ctx.Players.Add(new Player() { UserName = username, Password = password }); try { ctx.SaveChanges(); } catch (Exception) { throw new FaultException <UserExistsFault>( new UserExistsFault { Message = username + " already exists\n" }); } } }