public PurchaseDetailReport GetPurchaseDetails(DateTime?FromDate, DateTime?ToDate, string CompanyCode, string search, Boolean IsInternal, Guid Supplier, string InvoiceType, Guid SubType, string AccountCode) { PurchaseDetailReport purchasedetailObj = new PurchaseDetailReport(); List <PurchaseDetailReport> purchaseDetailReportList = null; try { purchaseDetailReportList = _reportRepository.GetPurchaseDetails(FromDate, ToDate, CompanyCode, search, IsInternal, Supplier, InvoiceType, SubType, AccountCode); decimal purchaseDetailSum = purchaseDetailReportList.Where(PD => PD.RowType != "T").Sum(PD => PD.BalanceDue); decimal purchaseDetailInvoiceAmount = purchaseDetailReportList.Where(PS => PS.RowType != "T").Sum(PS => PS.InvoiceAmount); decimal purchaseDetailPaidAmount = purchaseDetailReportList.Where(PS => PS.RowType != "T").Sum(PS => PS.PaidAmount); decimal purchaseDetailPaymentProcessed = purchaseDetailReportList.Where(PS => PS.RowType != "T").Sum(PS => PS.PaymentProcessed); decimal purchaseDetailsTax = purchaseDetailReportList.Where(PS => PS.RowType != "T").Sum(PS => PS.Tax); decimal purchaseDetailTotal = purchaseDetailReportList.Where(PS => PS.RowType != "T").Sum(PS => PS.TotalInvoice); purchasedetailObj.purchaseDetailSum = _commonBusiness.ConvertCurrency(purchaseDetailSum, 2); purchasedetailObj.purchaseDetailPaid = _commonBusiness.ConvertCurrency(purchaseDetailPaidAmount, 2); purchasedetailObj.purchaseDetailInvoice = _commonBusiness.ConvertCurrency(purchaseDetailInvoiceAmount, 2); purchasedetailObj.purchaseDetailPaymentProcess = _commonBusiness.ConvertCurrency(purchaseDetailPaymentProcessed, 2); purchasedetailObj.purchaseDetailsTaxAmount = _commonBusiness.ConvertCurrency(purchaseDetailsTax, 2); purchasedetailObj.purchaseDetailsTotalAmount = _commonBusiness.ConvertCurrency(purchaseDetailTotal, 2); purchasedetailObj.purchaseDetailReportList = purchaseDetailReportList; } catch (Exception ex) { throw ex; } return(purchasedetailObj); }
public PurchaseDetailReport GetRPTViewPurchaseDetail(DateTime?FromDate, DateTime?ToDate, string CompanyCode, Guid SupplierID) { PurchaseDetailReport detailObj = new PurchaseDetailReport(); List <PurchaseDetailReport> DetailList = null; try { DetailList = _reportRepository.GetRPTViewPurchaseDetail(FromDate, ToDate, CompanyCode, SupplierID); detailObj.purchaseDetailReportList = DetailList; } catch (Exception ex) { throw ex; } return(detailObj); }