//GetProductsForTag
//GetProductsForTag
public List <AuctionSales> GetProductsForSales(long eventID)
{
var dco = new DataCacheObject(DataCacheType.RESOURCE, DataCacheRegions.AUCTIONLISTS, "GETPRODUCTSFORSALES",
new object[] { eventID }, CachingExpirationTime.Seconds_30);
var result = CacheRepository.Get(dco) as List <AuctionSales>;
if (result != null && result.Any())
{
return(result);
}
dataContext.CommandTimeout = 600000;
result = (from p in dataContext.spAuction_View_Sales(eventID)
select new AuctionSales
{
LinkParams =
new LinkParams
{
ID = p.Auction_ID,
EventTitle = p.EventTitle,
MainCategoryTitle = p.MainCategoryTitle,
CategoryTitle = p.CategoryTitle
},
Lot = p.Lot.HasValue ? p.Lot.Value : (short)0,
Price = p.Price,
ThumbnailPath = p.ThumbnailPath,
Title = p.Title,
Estimate = p.Estimate
}).ToList();
if (result.Any())
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}