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