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