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