public Player[] GetAllPlayers()
{
using (var db = new AvalonContext())
{
db.Configuration.ProxyCreationEnabled = false;
return(db.Players.ToArray <Player>());
}
}
public void DeleteGame(Game game)
{
using (var db = new AvalonContext())
{
db.Games.Remove(game);
db.SaveChanges();
}
}
public Player GetPlayer(string username)
{
using (var db = new AvalonContext())
{
db.Configuration.ProxyCreationEnabled = false;
String[] usernameArray = { username };
return(db.Players.Find(usernameArray));
}
}
public Game GetGameBy(string name)
{
using (var db = new AvalonContext())
{
//int[] gameIdArray = { gameId };
db.Configuration.ProxyCreationEnabled = false;
return(db.Games.Find(name));
}
}
public void DeletePlayer(string username)
{
using (var db = new AvalonContext())
{
String[] usernameArray = { username };
var playerToDelete = db.Players.Find(usernameArray);
db.Players.Remove(playerToDelete);
db.SaveChanges();
}
}
public int CreateGame(Game game)
{
int gameId;
using (var db = new AvalonContext())
{
db.Games.Add(game);
db.SaveChanges();
gameId = game.GameId;
}
return(gameId);
}
public Game[] GetAllGames()
{
using (var db = new AvalonContext())
{
db.Configuration.ProxyCreationEnabled = false;
var allGames = new List <Game>();
foreach (Game game in db.Games)
{
allGames.Add(game);
}
return(allGames.ToArray());
}
}
public void UpdateGame(Game game)
{
using (var db = new AvalonContext())
{
var retrievedGame = db.Games.Find(game.GameId);
if (retrievedGame != null)
{
db.Entry(retrievedGame).CurrentValues.SetValues(game);
db.SaveChanges();
}
else
{
throw new GameGatewayException("Game with id " + game.GameId + " does not exist!");
}
}
}
public void UpdatePlayer(Player player)
{
using (var db = new AvalonContext())
{
String[] usernameArray = { player.DisplayName };
var retrievedPlayer = db.Players.Find(usernameArray);
if (retrievedPlayer != null)
{
db.Entry(retrievedPlayer).CurrentValues.SetValues(player);
db.SaveChanges();
}
else
{
throw new PlayerGatewayException("Player with username " + player.DisplayName + " does not exist.");
}
}
}
public string CreatePlayer(Player player)
{
using (var db = new AvalonContext())
{
String[] usernameArray = { player.DisplayName };
var playerExists = db.Players.Find(usernameArray);
if (playerExists == null)
{
db.Players.Add(player);
db.SaveChanges();
}
else
{
throw new PlayerGatewayException("Username already exists!");
}
}
return(player.DisplayName);
}