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