public IEnumerable <SupplierPaymentReport> GetSupplierPaymentReport(SupplierPaymentReportFilter filter)
{
try
{
var query = new StringBuilder(PurchaseOrderQueries.SelectSupplierPaymentReport);
query.Append(" where 1=1 ");
if (filter.Date.HasValue)
{
query.Append($"and date(Timestamp) = '{filter.Date.Value.ToString("yyyy/MM/dd")}' ");
}
else
{
if (filter.DateFrom.HasValue)
{
query.Append($"and date(Timestamp) >= '{filter.DateFrom.Value.ToString("yyyy/MM/dd")}' ");
}
if (filter.DateTo.HasValue)
{
query.Append($"and date(Timestamp) <= '{filter.DateTo.Value.ToString("yyyy/MM/dd")}' ");
}
}
query.Append("order by Timestamp;");
var report = dbContext.GetList <SupplierPaymentReport>(query.ToString());
return(report);
}
catch (Exception)
{
throw;
}
}
public async Task <IActionResult> GetSupplierPaymentsReport([FromBody] SupplierPaymentReportFilter model)
{
try
{
var payments = await api.Post <SupplierPaymentReportFilter, IEnumerable <SupplierPaymentReport> >("PurchaseOrder/GetSupplierPaymentReport", model);
return(Json(payments));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult <IEnumerable <SupplierPaymentReport> > GetSupplierPaymentReport([FromBody] SupplierPaymentReportFilter value)
{
try
{
var supplierPaymentReport = db.GetSupplierPaymentReport(value);
return(supplierPaymentReport.ToList());
}
catch (Exception ex)
{
throw ex;
}
}
