Esempio n. 1
0
        public void DiscardCards(ReplaceCardModel cards)
        {
            int handID = GetHandID(cards.TableId);

            if (cards.Discards == null)
            {
                cards.Discards = new List <Card>();
            }

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();

                    foreach (Card card in cards.Discards)
                    {
                        SqlCommand cmd = new SqlCommand("DELETE FROM hand_cards WHERE hand_id = @handID AND player = @player AND card_suit = @suit AND card_number = @number;", conn);
                        cmd.Parameters.AddWithValue("@handID", handID);
                        cmd.Parameters.AddWithValue("@player", cards.Username);
                        cmd.Parameters.AddWithValue("@suit", card.Suit);
                        cmd.Parameters.AddWithValue("@number", card.Number);

                        cmd.ExecuteNonQuery();
                    }
                }
            }
            catch (SqlException)
            {
                throw;
            }
        }
Esempio n. 2
0
        public ActionResult ReplaceCards(ReplaceCardModel model)
        {
            TableSqlDal dal    = new TableSqlDal();
            int         handID = dal.GetHandID(model.TableId);
            Table       table  = GetTableInfo(model.TableId);

            dal.SetPlayerToHasChecked(model.TableId, handID, model.Username);
            dal.SetCurrentBet(model.TableId, model.Username);
            dal.DiscardCards(model);
            dal.DrawCards(handID, model.Discards.Count, model.Username);
            table = GetTableInfo(model.TableId);

            UpdatePlayerTurn(model.TableId);

            int i = 0;

            foreach (Seat s in table.Seats)
            {
                if (s.Username == "Available")
                {
                    i++;
                }
                else if (s.HasChecked || s.HasFolded)
                {
                    i++;
                }
            }

            if (i == 5)
            {
                table.StateCounter++;
                dal.UpdateStateCounter(model.TableId);
                dal.UncheckAllPlayer(model.TableId);
                return(RedirectToAction("AdvanceGame", new { tableID = model.TableId }));
            }


            return(RedirectToAction("HandSetup", new { tableID = model.TableId }));
        }