public async Task <IActionResult> Search(DashboardVM dashboardVM)
{
var measurement = await _measurementRepository.GetByMonthAndYear(dashboardVM.MonthNemotecnico, dashboardVM.Year);
if (measurement.HasValue)
{
dashboardVM.ReceiptItemVM = await _receiptRepository.GetReceiptDetailsByMeasurement(measurement.Value.Id);
var totalReceiptsPaid = 0;
var totalPaidAmount = 0d;
var totalPendingAmount = 0d;
foreach (var receipt in dashboardVM.ReceiptItemVM)
{
if (receipt.IsPaid)
{
totalPaidAmount += receipt.TotalAmount;
totalReceiptsPaid++;
}
else
{
totalPendingAmount += receipt.TotalAmount;
}
}
dashboardVM.ChargedAmount = totalPaidAmount;
dashboardVM.PendingAmount = totalPendingAmount;
dashboardVM.DashboardReceiptsVM = new DashboardReceiptsVM(totalReceipts: dashboardVM.ReceiptItemVM.Count, totalReceiptsPaid: totalReceiptsPaid);
await RefreshCollections();
return(View("Index", dashboardVM));
}
return(RedirectToAction("Index"));
}
public async Task <IActionResult> GenerateReceipts(MeasurementReportVM measurementReport)
{
var measurement = await _measurementRepository.GetByMonthAndYear(measurementReport.MonthNemotecnico, measurementReport.Year);
if (measurement.HasNoValue)
{
TempData["InfomationMessage"] = "No se encontró una lectura para el mes y año indicados";
return(RedirectToAction("Index"));
}
var Receipts = await _receiptRepository.GetReceiptDetailsByMeasurement(measurement.Value.Id);
StringBuilder completeHtml = new StringBuilder();
var htmlBaseContent = System.IO.File.ReadAllText("Templates/BaseReceiptTemplate.html");
var htmlTemplate = System.IO.File.ReadAllText("Templates/ReceiptTemplate.html");
var htmlDetailTemplate = System.IO.File.ReadAllText("Templates/DetailReceiptTemplate.html");
var ImageBytes = System.IO.File.ReadAllBytes("Images/LOGO.png");
var clientQr = _clientFactory.CreateClient("QrGeneratorApi");
foreach (var receipt in Receipts)
{
StringBuilder builderDetail = new StringBuilder();
foreach (var item in receipt.Items)
{
builderDetail.Append(htmlDetailTemplate.FormatToken(item));
}
var qrCode = await(await clientQr.PostAsJsonAsync(clientQr.BaseAddress, receipt.ReceiptCode)).Content.ReadAsByteArrayAsync();
StringBuilder builderMeasurement = new StringBuilder();
builderMeasurement.Append(htmlTemplate.FormatToken(new {
MeterNumber = receipt.MeterSerialNumber,
ContractNumber = receipt.ContractIdentifier,
ReceiptNumber = receipt.ReceiptCode,
CustomerName = receipt.FullName.ToUpper(),
IdentificationNumber = receipt.IdentificatioNumber,
MaxPaymentDate = measurement.Value.MaxPaymentDate.ToString("dddd dd 'de' MMMM 'de' yyyy"),
receipt.LastRead,
receipt.CurrentRead,
base64ImageLogo = Convert.ToBase64String(ImageBytes),
base64QrCode = Convert.ToBase64String(qrCode),
TotalCubicMeterConsume = receipt.CubicMetersConsume,
TotalAmount = receipt.TotalAmount.ToString("0.##"),
measurement.Value.PaymentPlace,
measurement.Value.MessageOfTheMonth,
DetailReceipt = builderDetail.ToString()
}));
completeHtml.Append(builderMeasurement.ToString());
}
var clientPdf = _clientFactory.CreateClient("PdfGeneratorApi");
HttpRequestMessage request = new HttpRequestMessage(HttpMethod.Post, clientPdf.BaseAddress)
{
Content = new StringContent(JsonConvert.SerializeObject(new
{
FileName = $"{measurement.Value.Month}-{measurement.Value.Year}",
DocumentTitle = "Lectura de Agua",
Content = htmlBaseContent.FormatToken(new { Content = completeHtml.ToString() }),
GetContentFromUrl = false
}), Encoding.UTF8, "application/json")
};
return(File(await(await clientPdf.SendAsync(request)).Content.ReadAsByteArrayAsync(), "application/pdf", $"{measurement.Value.Month.Nemotecnico}-{measurement.Value.Year}.pdf"));
}