private async void btnGenerate_Click(object sender, EventArgs e)
{
if (ValidateChildren())
{
DateTime dateFrom = new DateTime(DateFrom.Value.Year, DateFrom.Value.Month, DateFrom.Value.Day, 00, 00, 01, 01);
DateTime dateTo = new DateTime(DateTo.Value.Year, DateTo.Value.Month, DateTo.Value.Day, 23, 59, 59, 59);
var request = new Data.Requests.CompletedServicesSearchByDateRequest()
{
DateFrom = dateFrom,
DateTo = dateTo,
carServiceID = _carServiceID.GetValueOrDefault()
};
var model = await _EarningsOfCompletedServicesByDateService.Get <Data.Model.EarningsOfCompletedServices>(request);
txtDateFromTo.Text = request.DateFrom.ToString("dd.MM.yyyy");
txtDateFromTo.Text += " - " + request.DateTo.ToString("dd.MM.yyyy");
dgvServices.AutoGenerateColumns = false;
dgvServices.DataSource = model.servicesList;
}
}
private async void btnToPDF_Click(object sender, EventArgs e)
{
DateTime dateFrom = new DateTime(DateFrom.Value.Year, DateFrom.Value.Month, DateFrom.Value.Day, 00, 00, 01, 01);
DateTime dateTo = new DateTime(DateTo.Value.Year, DateTo.Value.Month, DateTo.Value.Day, 23, 59, 59, 59);
var request = new Data.Requests.CompletedServicesSearchByDateRequest()
{
DateFrom = dateFrom,
DateTo = dateTo,
carServiceID = _carServiceID.GetValueOrDefault()
};
var model = await _EarningsOfCompletedServicesByDateService.Get <Data.Model.EarningsOfCompletedServices>(request);
if (model.servicesList.Count() == 0)
{
MessageBox.Show("U odabranom periodu nema zarade niti od jedne usluge, te nije moguće procesirati izvještaj!", "Greška", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
var fileName = request.DateFrom.ToString("dd.MM.yyyy") + "_" + request.DateTo.ToString("dd.MM.yyyy") + ".pdf";
var path = "..\\..\\Reports\\izvjestaj_o_zaradi_" + fileName;
PdfWriter writer = new PdfWriter(path);
PdfDocument pdf = new PdfDocument(writer);
Document document = new Document(pdf);
iText.Layout.Element.Paragraph header = new iText.Layout.Element.Paragraph("Izvještaj o zaradi od obavljenih usluga u periodu " + request.DateFrom.ToString("dd.MM.yyyy.")
+ " - " + request.DateTo.ToString("dd.MM.yyyy.")).SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER);
document.Add(header);
float[] columnWidths = { 5, 4 };
iText.Layout.Element.Table table = new iText.Layout.Element.Table(UnitValue.CreatePercentArray(columnWidths));
table.SetHorizontalAlignment(iText.Layout.Properties.HorizontalAlignment.CENTER);
Cell[] headerFooter = new Cell[] {
new Cell().SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER).SetBackgroundColor(new DeviceGray(0.75f)).Add(new Paragraph("Usluga")),
new Cell().SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER).SetBackgroundColor(new DeviceGray(0.75f)).Add(new Paragraph("Zarada(u KM)")),
};
foreach (Cell hfCell in headerFooter)
{
table.AddHeaderCell(hfCell);
}
foreach (var x in model.servicesList)
{
table.AddCell(new Cell().SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER).Add(new Paragraph(x.ServiceName)));
table.AddCell(new Cell().SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER).Add(new Paragraph(x.Earnings.ToString())));
}
document.Add(table);
double suma = 0;
foreach (var s in model.servicesList)
{
suma += s.Earnings;
}
Cell sum = new Cell(1, 7)
.Add(new Paragraph("Ukupno: " + suma.ToString() + " KM"))
.SetFontSize(13)
.SetFontColor(DeviceGray.BLACK)
.SetBackgroundColor(DeviceGray.WHITE)
.SetTextAlignment(TextAlignment.RIGHT)
.SetBold();
document.Add(sum);
MessageBox.Show("Uspješno ste kreirali izvještaj", "Kreiranje izvještaja", MessageBoxButtons.OK, MessageBoxIcon.Information);
document.Close();
System.Diagnostics.Process.Start(path);
}
