Esempio n. 1
0
        /// <summary>
        /// Selects game round cards
        /// </summary>
        /// <param name="gameRoundID">Game Round ID to select cards for</param>
        /// <returns>A list of game round cards for the Game Round ID</returns>
        public List <Entities.GameRoundCard> Execute(Int32 gameRoundID)
        {
            Entities.Filters.GameRoundCard.Select filter = new Entities.Filters.GameRoundCard.Select();
            filter.GameRoundID = gameRoundID;

            return(_selectGameRoundCard.Execute(filter));
        }
Esempio n. 2
0
        /// <summary>
        /// Selects game round cards
        /// </summary>
        /// <param name="gameRoundID">Game Round ID to select cards for</param>
        /// <returns>A list of game round cards for the Game Round ID</returns>
        public List<Entities.GameRoundCard> Execute(Int32 gameRoundID)
        {
            Entities.Filters.GameRoundCard.Select filter = new Entities.Filters.GameRoundCard.Select();
            filter.GameRoundID = gameRoundID;

            return _selectGameRoundCard.Execute(filter);
        }
Esempio n. 3
0
        /// <summary>
        /// Selects game round cards base on supplied filter
        /// </summary>
        /// <param name="filter">Filter used to select game round cards</param>
        /// <returns>A list of game round cards that satisfy the supplied filter</returns>
        public List <Entities.GameRoundCard> Execute(Entities.Filters.GameRoundCard.Select filter)
        {
            List <Entities.GameRoundCard> cards = new List <Entities.GameRoundCard>();

            using (DbCommand cmd = _db.GetStoredProcCommand("GameRoundCard_Select"))
            {
                _db.AddInParameter(cmd, "@GameRoundID", DbType.Int32, filter.GameRoundID);

                using (IDataReader idr = _db.ExecuteReader(cmd))
                {
                    while (idr.Read())
                    {
                        cards.Add(new Entities.GameRoundCard(idr));
                    }
                }
            }

            return(cards);
        }
Esempio n. 4
0
 /// <summary>
 /// Selects game round cards base on supplied filter
 /// </summary>
 /// <param name="filter">Filter used to select game round cards</param>
 /// <returns>A list of game round cards that satisfy the supplied filter</returns>
 public List <Entities.GameRoundCard> Execute(Entities.Filters.GameRoundCard.Select filter)
 {
     return(_selectGameRoundCard.Execute(filter));
 }