Example #1
0
        public static BannerAuction GetFirstActiveAuction(BannerAdvertDimensions dimensions)
        {
            using (var bridge = ParserPool.Acquire(Database.Client))
            {
                var currentSql  = bridge.Instance.ExecuteRawCommandToDataTable(BannerAuctionSQLManager.GetFirstActiveAuctionSQL(dimensions));
                var currentList = TableHelper.GetListFromDataTable <BannerAuction>(currentSql, 1);

                if (currentList.Count > 0)
                {
                    return(currentList[0]);
                }
                else
                {
                    BannerAuctionManager.CRON(); //No auctions created yet, do it
                    return(null);
                }
            }
        }