public void SaveHand(ExplodingKittensLib.Models.Players.Player myPlayer)
{
using (var db = new Pro250_KittensEntities1())
{
var getPlayerHandQuery = db.Player_Hand.Where(x => x.PlayerID == myPlayer.Id).ToList();
db.Player_Hand.RemoveRange(getPlayerHandQuery);
for (int i = 0; i < myPlayer.Hand.Cards.Count; i++)
{
db.Player_Hand.Add(new Player_Hand
{
CardID = myPlayer.Hand.Cards[i].Id,
PlayerID = myPlayer.Id
});
}
db.SaveChanges();
}
}
public void savePlayer(ExplodingKittensLib.Models.Players.Player myPlayer, int playerPosition, int gameID)
{
using (var db = new Pro250_KittensEntities1())
{
var playerQuery = db.Players.Where(x => x.PlayerID == myPlayer.Id).First();
if (playerQuery != null)
{
db.Players.Remove(playerQuery);
}
db.Players.Add(new Player
{
PlayerID = myPlayer.Id,
Player_Name = myPlayer.Name,
Position = playerPosition,
GameID = gameID
});
db.SaveChanges();
}
}
public void saveDrawDeck(Stack <Card> drawDeck, int gameID)
{
using (var db = new Pro250_KittensEntities1())
{
var getDrawDeckQuery = db.DrawDecks.Where(x => x.GameID == gameID).First();
if (getDrawDeckQuery != null)
{
db.DrawDecks.Remove(getDrawDeckQuery);
}
for (int i = 0; i < drawDeck.Count; i++)
{
db.DrawDecks.Add(new DrawDeck
{
CardID = drawDeck.ElementAt(i).Id,
GameID = gameID
});
db.SaveChanges();
}
}
}