public PokerTableBL GetTableByHistory(PokerTable pokerTable) { myTable = new PokerTableBL(pokerTable.PokerTableName, 0, pokerTable.MinBet); if (pokerTable.Player1Id != -1) { myTable.Players.Add(new PlayerBL(Database.GetUserById(pokerTable.Player1Id), pokerTable.Id)); } if (pokerTable.Player2Id != -1) { myTable.Players.Add(new PlayerBL(Database.GetUserById(pokerTable.Player2Id), pokerTable.Id)); } if (pokerTable.Player3Id != -1) { myTable.Players.Add(new PlayerBL(Database.GetUserById(pokerTable.Player3Id), pokerTable.Id)); } if (pokerTable.Player4Id != -1) { myTable.Players.Add(new PlayerBL(Database.GetUserById(pokerTable.Player4Id), pokerTable.Id)); } if (pokerTable.Player5Id != -1) { myTable.Players.Add(new PlayerBL(Database.GetUserById(pokerTable.Player5Id), pokerTable.Id)); } if (pokerTable.FirstCard != "") { myTable.TableStatus.TableCards.Add(new Card(pokerTable.FirstCard)); } if (pokerTable.SecondCard != "") { myTable.TableStatus.TableCards.Add(new Card(pokerTable.SecondCard)); } if (pokerTable.ThirdCard != "") { myTable.TableStatus.TableCards.Add(new Card(pokerTable.ThirdCard)); } if (pokerTable.FourthCard != "") { myTable.TableStatus.TableCards.Add(new Card(pokerTable.FourthCard)); } if (pokerTable.FifthCard != "") { myTable.TableStatus.TableCards.Add(new Card(pokerTable.FifthCard)); } myTable.NumOfPlayers = myTable.Players.Count; myTable.DealerId = pokerTable.DealerId; for (int i = 0; i < myTable.Players.Count; i++) { if (myTable.DealerId == myTable.Players[i].PlayerId) { myTable.DealerIndex = i; } } foreach (PlayerBL player in myTable.Players) { if (player.PlayerId == myUser.Id) { myPlayer = player; } } return(myTable); }
public void UpdateHistoryInDB() { PokerTableBL tableBL = myTable; //Updating table from static List foreach (PokerTableBL pokerTable in Tables) { if (pokerTable.Id == myTable.Id) { tableBL = pokerTable; } } PokerTable table = new PokerTable() { PokerTableName = tableBL.PokerTableName, TablePot = tableBL.TablePot, MinBet = tableBL.MinBet, DealerId = tableBL.DealerId }; switch (tableBL.TableStatus.TableCards.Count) { case 1: table.FirstCard = tableBL.TableStatus.TableCards[0].ToString(); table.SecondCard = ""; table.ThirdCard = ""; table.FourthCard = ""; table.FifthCard = ""; break; case 2: table.FirstCard = tableBL.TableStatus.TableCards[0].ToString(); table.SecondCard = tableBL.TableStatus.TableCards[1].ToString(); table.ThirdCard = ""; table.FourthCard = ""; table.FifthCard = ""; break; case 3: table.FirstCard = tableBL.TableStatus.TableCards[0].ToString(); table.SecondCard = tableBL.TableStatus.TableCards[1].ToString(); table.ThirdCard = tableBL.TableStatus.TableCards[2].ToString(); table.FourthCard = ""; table.FifthCard = ""; break; case 4: table.FirstCard = tableBL.TableStatus.TableCards[0].ToString(); table.SecondCard = tableBL.TableStatus.TableCards[1].ToString(); table.ThirdCard = tableBL.TableStatus.TableCards[2].ToString(); table.FourthCard = tableBL.TableStatus.TableCards[3].ToString(); table.FifthCard = ""; break; case 5: table.FirstCard = tableBL.TableStatus.TableCards[0].ToString(); table.SecondCard = tableBL.TableStatus.TableCards[1].ToString(); table.ThirdCard = tableBL.TableStatus.TableCards[2].ToString(); table.FourthCard = tableBL.TableStatus.TableCards[3].ToString(); table.FifthCard = tableBL.TableStatus.TableCards[4].ToString(); break; } myTable.Id = Database.InsertTable(table); foreach (PokerTableBL mytable in Tables) { if (mytable.Id == myTable.Id) { for (int i = 0; i < mytable.Players.Count; i++) { Player player = new Player() { PokerTableId = mytable.Id, PlayerId = mytable.Players[i].PlayerId, PlayerName = mytable.Players[i].PlayerName, ChipsOnTable = mytable.Players[i].ChipsOnTable, FirstCard = mytable.Players[i].PersonalCards[0].ToString(), SecondCard = mytable.Players[i].PersonalCards[1].ToString() }; PlayerIds.Add(Database.InsertPlayer(player)); } } } switch (PlayerIds.Count) { case 1: table.Player1Id = PlayerIds[0]; break; case 2: table.Player1Id = PlayerIds[0]; table.Player2Id = PlayerIds[1]; break; case 3: table.Player1Id = PlayerIds[0]; table.Player2Id = PlayerIds[1]; table.Player3Id = PlayerIds[2]; break; case 4: table.Player1Id = PlayerIds[0]; table.Player2Id = PlayerIds[1]; table.Player3Id = PlayerIds[2]; table.Player4Id = PlayerIds[3]; break; case 5: table.Player1Id = PlayerIds[0]; table.Player2Id = PlayerIds[1]; table.Player3Id = PlayerIds[2]; table.Player4Id = PlayerIds[3]; table.Player5Id = PlayerIds[4]; break; } Database.UpdateTable(table); foreach (Move move in tableBL.Moves) { move.PokerTableId = myTable.Id; Database.InsertMove(move); } }