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 ExplodingKittensLib.Models.Game loadGame(ExplodingKittensLib.Models.Game myGame)
{
using (var db = new Pro250_KittensEntities1())
{
IQueryable <Player> playersList = db.Players.Where(x => x.GameID == myGame.ID);
LinkedList <ExplodingKittensLib.Models.Players.Player> playerObjectsList = new LinkedList <ExplodingKittensLib.Models.Players.Player>();
List <int> cardIDList = new List <int>();
ExplodingKittensLib.Models.WPFDeck myWPFDeck = new ExplodingKittensLib.Models.WPFDeck(myGame, myGame.Players.Count);
foreach (Player newPlayer in playersList)
{
//New Hand and Player
ExplodingKittensLib.Models.Hand myHand = new ExplodingKittensLib.Models.Hand();
ExplodingKittensLib.Models.Players.Player myPlayer = new ExplodingKittensLib.Models.Players.Player(newPlayer.PlayerID, myGame);
for (int i = 0; i < newPlayer.Player_Hand.Count; i++)
{
//Add to CardID List to get the hand information
cardIDList.Add(newPlayer.Player_Hand.ElementAt(i).CardID);
}
//Set active Player
if (myGame.ActivePlayer.Id == newPlayer.PlayerID)
{
myPlayer.IsActive = true;
}
else
{
myPlayer.IsActive = false;
}
myHand = myWPFDeck.GetCardStack(cardIDList);
myPlayer.Id = newPlayer.PlayerID;
myPlayer.Hand = myHand;
myPlayer.IsAskedForFavor = false;
myPlayer.IsBeingStolenFrom = false;
myPlayer.IsUnderAttack = false;
myPlayer.Name = newPlayer.Player_Name;
playerObjectsList.AddFirst(myPlayer);
}
myGame.Players = playerObjectsList;
}
return(myGame);
}
