public IEnumerable <PaymentReport> GetPaymentReport(PaymentReportFilter paymentReportFilter)
{
var paymentReport = PaymentReportQuerys.GetPaymentReport;
if (!string.IsNullOrEmpty(paymentReportFilter.InitialDateIni))
{
paymentReport += " AND Ags.[InitialDate] >= CONVERT(DATETIME, @InitialDateIni, 105) ";
}
if (!string.IsNullOrEmpty(paymentReportFilter.InitialDateEnd))
{
paymentReport += " AND Ags.[InitialDate] <= CONVERT(DATETIME, @InitialDateEnd, 105) ";
}
if (paymentReportFilter.EntityId > 0)
{
paymentReport += "AND Ags.[EntityId] = @EntityId ";
}
if (paymentReportFilter.PlanEntityId > 0)
{
paymentReport += "AND Ags.[PlanEntityId] = @PlanEntityId ";
}
if (paymentReportFilter.ServiceId > 0)
{
paymentReport += "AND Ags.[ServiceId] = @ServiceId ";
}
paymentReport += "ORDER BY Asd.AssignServiceDetailId DESC";
return(_dbConnection.Query <PaymentReport>(paymentReport, paymentReportFilter));
}
public IEnumerable <PaymentReportView> GetPaymentReport([FromBody] PaymentReportFilter value)
{
try
{
return(db.GetFilteredPayments(value));
}
catch (Exception)
{
throw;
}
}
public ServiceResult <IEnumerable <PaymentReport> > GetPaymentReport(PaymentReportFilter paymentReportFilter)
{
var result = _paymentReportRepository.GetPaymentReport(paymentReportFilter);
return(new ServiceResult <IEnumerable <PaymentReport> >
{
Result = result,
Errors = new[] { string.Empty },
Success = true
});
}
public IActionResult Post([FromBody] PaymentReportFilter paymentReportFilter)
{
var data = _paymentReportService.GetPaymentReport(paymentReportFilter);
var rootPath = Path.Combine(_hostingEnvironment.WebRootPath, "Temp");
var excelFile = _excelReportService.GenerateExcelReport(rootPath, data.Result);
var response = new HttpResponseMessage(HttpStatusCode.OK);
var bytes = System.IO.File.ReadAllBytes(excelFile);
var fileName = Path.GetFileNameWithoutExtension(excelFile);
response.Content = new ByteArrayContent(bytes);
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");
response.Content.Headers.ContentType = new MediaTypeHeaderValue("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
response.Content.Headers.ContentDisposition.FileName = fileName + ".xlsx";
return(File(bytes, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", fileName + ".xlsx"));
}
public async Task <IActionResult> GetFilteredPaymentReport([FromBody] PaymentReportFilter model)
{
try
{
var resultData = new PaymentReportDetailedView();
var result = await api.Post <PaymentReportFilter, IEnumerable <PaymentReportView> >("WorkOrder/GetPaymentReport", model);;
resultData.ReportData = result;
resultData.CashTotal = result.Where(r => r.PaymentTypeId == (byte)PaymentOptions.Cash).Sum(r => r.Amount);
resultData.BankTransferTotal = result.Where(r => r.PaymentTypeId == (byte)PaymentOptions.BankTransfer).Sum(r => r.Amount);
resultData.ChequeTotal = result.Where(r => r.PaymentTypeId == (byte)PaymentOptions.Cheque).Sum(r => r.Amount);
resultData.PointOfSaleTotal = result.Where(r => r.PaymentTypeId == (byte)PaymentOptions.PointOfSale).Sum(r => r.Amount);
return(Json(resultData));
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <PaymentReportView> GetFilteredPayments(PaymentReportFilter filter)
{
try
{
var query = new StringBuilder(WorkOrderQueries.GetCustomerPayments);
query.Append(" where 1=1 ");
if (!string.IsNullOrEmpty(filter.CustomerName))
{
query.Append($"and BP.Name like '%{filter.CustomerName}%' ");
}
if (!string.IsNullOrEmpty(filter.ContactName))
{
query.Append($"and BPC.Name like '%{filter.ContactName}%' ");
}
if (filter.Date.HasValue)
{
query.Append($"and date(P.Timestamp) = '{filter.Date.Value.ToString("yyyy/MM/dd")}' ");
}
else
{
if (filter.DateFrom.HasValue)
{
query.Append($"and date(P.Timestamp) >= '{filter.DateFrom.Value.ToString("yyyy/MM/dd")}' ");
}
if (filter.DateTo.HasValue)
{
query.Append($"and date(P.Timestamp) <= '{filter.DateTo.Value.ToString("yyyy/MM/dd")}' ");
}
}
query.Append("order by P.Timestamp;");
var report = dbContext.GetList <PaymentReportView>(query.ToString());
return(report);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw;
}
}
