public IHttpActionResult GetDeck(int id)
{
using (var dbContext = CardsContextManager.GetContext())
{
var deckQuery = (
from deck in dbContext.Decks
where deck.Id == id
select new
{
Id = deck.Id,
Name = deck.Name,
Cards =
from card in deck.Cards
orderby card.Suit, card.Value
select card
});
var result = deckQuery.FirstOrDefault();
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
}
public object[] GetAllLobbies()
{
using (var dbContext = CardsContextManager.GetContext())
{
var lobbyQuery =
from lobby in dbContext.Lobbies
select lobby;
var result = lobbyQuery.ToArray();
return(result);
}
}
public IHttpActionResult GetLobby(string name)
{
using (var dbContext = CardsContextManager.GetContext())
{
var lobbyQuery =
from lobby in dbContext.Lobbies
where lobby.Name == name
select lobby;
var result = lobbyQuery.FirstOrDefault();
return(Ok(result));
}
}
public object[] GetAllCards()
{
using (var dbContext = CardsContextManager.GetContext())
{
var cards =
from card in dbContext.Cards
where card.DeckId == 1
orderby card.Suit, card.Value
select card;
var result = cards.ToArray();
return(result);
}
}
public IHttpActionResult Post([FromBody] Lobby lobby)
{
var newLobby = new Lobby
{
GameId = lobby.GameId,
GroupId = lobby.GroupId,
Name = lobby.Name
};
using (var dbContext = CardsContextManager.GetContext())
{
dbContext.Lobbies.Add(newLobby);
dbContext.SaveChanges();
return(Ok(newLobby));
}
}
public IHttpActionResult Put([FromBody] Card card, int id)
{
using (var dbContext = CardsContextManager.GetContext())
{
Card newCard = null;
var cardQuery =
from c in dbContext.Cards
where c.Id == id
select c;
var result = cardQuery.FirstOrDefault();
if (result != null)
{
result.DeckId = card.DeckId;
result.Name = card.Name;
result.Value = card.Value;
result.BackImageFileName = card.BackImageFileName;
result.FrontImageFileName = card.FrontImageFileName;
result.Suit = card.Suit;
}
else
{
newCard = new Card
{
DeckId = card.DeckId,
Name = card.Name,
Value = card.Value,
BackImageFileName = card.BackImageFileName,
FrontImageFileName = card.FrontImageFileName,
Suit = card.Suit
};
dbContext.Cards.Add(newCard);
}
dbContext.SaveChanges();
if (newCard != null)
{
return(Ok(newCard));
}
else
{
return(Ok(result));
}
}
}
public IHttpActionResult GetCard(int value, string suit)
{
using (var dbContext = CardsContextManager.GetContext())
{
var cardQuery =
from card in dbContext.Cards
where card.DeckId == 1 && card.Value == value && card.Suit == suit
select card;
var result = cardQuery.FirstOrDefault();
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
}
public IHttpActionResult Post([FromBody] Player player)
{
var newPlayer = new Player
{
WebSocketId = player.WebSocketId,
Name = player.Name,
TeamId = player.TeamId,
Score = player.Score
};
using (var dbContext = CardsContextManager.GetContext())
{
dbContext.Players.Add(newPlayer);
dbContext.SaveChanges();
return(Ok(newPlayer));
}
}
public IHttpActionResult GetPlayer(int id)
{
using (var dbContext = CardsContextManager.GetContext())
{
var playerQuery =
from player in dbContext.Players
where player.Id == id
select player;
var result = playerQuery.FirstOrDefault();
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
}
public IHttpActionResult Post([FromBody] Card card)
{
var newCard = new Card
{
DeckId = card.DeckId,
Name = card.Name,
Value = card.Value,
BackImageFileName = card.BackImageFileName,
FrontImageFileName = card.FrontImageFileName,
Suit = card.Suit
};
using (var dbContext = CardsContextManager.GetContext())
{
dbContext.Cards.Add(newCard);
dbContext.SaveChanges();
return(Ok(newCard));
}
}
public object[] GetAllDecks()
{
using (var dbContext = CardsContextManager.GetContext())
{
var deckQuery = (
from deck in dbContext.Decks
select new
{
Id = deck.Id,
Name = deck.Name,
Cards =
from card in deck.Cards
orderby card.Suit, card.Value
select card
}).ToArray();
var result = deckQuery.ToArray();
return(result);
}
}
public IHttpActionResult Put([FromBody] Player player, int id)
{
using (var dbContext = CardsContextManager.GetContext())
{
Player newPlayer = null;
var playerQuery =
from p in dbContext.Players
where p.Id == id
select p;
var result = playerQuery.FirstOrDefault();
if (result != null)
{
result.TeamId = player.TeamId;
result.Score = player.Score;
}
else
{
newPlayer = new Player
{
WebSocketId = player.WebSocketId,
Name = player.Name,
TeamId = player.TeamId,
Score = player.Score
};
dbContext.Players.Add(newPlayer);
}
dbContext.SaveChanges();
if (newPlayer != null)
{
return(Ok(newPlayer));
}
else
{
return(Ok(result));
}
}
}
public IHttpActionResult Put([FromBody] Lobby lobby, int id)
{
using (var dbContext = CardsContextManager.GetContext())
{
Lobby newLobby = null;
var lobbyQuery =
from l in dbContext.Lobbies
where l.Id == id
select l;
var result = lobbyQuery.FirstOrDefault();
if (result != null)
{
result.GameId = lobby.GameId;
result.Name = lobby.Name;
result.GroupId = lobby.GroupId;
}
else
{
newLobby = new Lobby
{
GameId = lobby.GameId,
Name = lobby.Name,
GroupId = lobby.GroupId
};
dbContext.Lobbies.Add(newLobby);
}
dbContext.SaveChanges();
if (newLobby != null)
{
return(Ok(newLobby));
}
else
{
return(Ok(result));
}
}
}