//GetConsignmentTotals
public UICInvoice GetConsignmentTotals(long consignment_id)
{
DataCacheObject dco = new DataCacheObject(DataCacheType.ACTIVITY, DataCacheRegions.INVOICES, "GETCONSIGNMENTTOTALS",
new object[] { consignment_id }, CachingExpirationTime.Hours_01);
UICInvoice result = CacheRepository.Get(dco) as UICInvoice;
if (result != null)
{
return(result);
}
int?totalamount = 0;
result =
(from p in
dataContext.spInvoice_View_ConsignorStatements(consignment_id, null, null, null, 0, 1, ref totalamount)
select new UICInvoice
{
AmountDue = p.ADue.GetValueOrDefault(0),
AmountPaid = p.APaid.GetValueOrDefault(0),
TotalCost = p.TotalCost.GetValueOrDefault(0)
}).FirstOrDefault();
if (result != null)
{
dco.Data = result;
CacheRepository.Add(dco);
}
return(result);
}
//GetConsignorStatementsBySearch
public object GetConsignorStatementsBySearch(string sidx, string sord, int page, int rows, long?invoice_id, long?auction_id, long?event_id, long?user_id)
{
int?totalrecords = 0;
int pageindex = (page > 0) ? page - 1 : 0;
dataContext.CommandTimeout = 600000;
var res = dataContext.spInvoice_View_ConsignorStatements(invoice_id, auction_id, event_id, user_id, pageindex, rows, ref totalrecords);
if (totalrecords.GetValueOrDefault(0) == 0)
{
return new { total = 0, page = page, records = 0 }
}
;
return(new
{
total = (int)Math.Ceiling((float)totalrecords.GetValueOrDefault(0) / (float)rows),
page = page,
records = totalrecords.GetValueOrDefault(0),
rows = (
from query in res
select new
{
i = query.Consignment_ID,
cell = new string[] {
query.Consignment_ID.ToString(),
query.EventTitle,
query.FLName,
query.Pending.GetCurrency(false),
query.TotalCost.GetCurrency(false),
query.APaid.GetCurrency(false),
query.ADue.GetCurrency(false),
query.Owner_ID.GetValueOrDefault(0).ToString()
}
}).ToArray()
});
}
