//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);
}