//GetConsignmentDetailsByConsignmentID public List <ConsignmentDetail> GetConsignmentDetailsByConsignmentID(long consignmentID) { DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.INVOICES, "GETCONSIGNMENTDETAILSBYCONSIGNMENTID", new object[] { consignmentID }, CachingExpirationTime.Hours_01); List <ConsignmentDetail> result = CacheRepository.Get(dco) as List <ConsignmentDetail>; if (result != null && result.Any()) { return(result); } result = (from p in dataContext.spInvoice_View_GetConsignmentByConsignments(consignmentID) select new ConsignmentDetail { Consignment_ID = p.Consignment_ID, Invoice_ID = p.Invoice_ID.GetValueOrDefault(0), Reserve = p.Reserve.GetValueOrDefault(0), Cost = p.Cost, Amount = p.Amount, LinkParams = new LinkParams { EventTitle = p.EventTitle, MainCategoryTitle = p.MainCategoryTitle, CategoryTitle = p.CategoryTitle, Lot = p.Lot.HasValue ? p.Lot.Value : (short)0, Title = p.Title, ID = p.Auction_ID }, CommissionRate = p.CommRate }).ToList(); if (result.Any()) { dco.Data = result; CacheRepository.Add(dco); } return(result); }