public async Task ExportProductsToPDFAsync(IEnumerable <Product> products)
{
try
{
PDFGenerator pdf = new PDFGenerator(Phrases.GlobalProducts, Phrases.ProductsListOf);
Section section = pdf.CreateDocumentSection();
// Set title
pdf.AddParagraph(Phrases.GlobalProducts, true, false, 16);
pdf.AddParagraph($"{Phrases.GlobalDate}: {DateTime.Now.ShortDate()}", false, true, null, 1);
// Create table and table columns
Table table = pdf.CreateTable();
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Right);
// Create table header
Row row = pdf.CreateTableHeaderRow(table);
pdf.AddTableRowCell(row, 0, ParagraphAlignment.Left, Phrases.GlobalReference, true);
pdf.AddTableRowCell(row, 1, ParagraphAlignment.Left, Phrases.GlobalName, true);
pdf.AddTableRowCell(row, 2, ParagraphAlignment.Right, Phrases.GlobalStock, true);
// Populate the table rows
products.ToList().ForEach((product) => {
row = table.AddRow();
pdf.AddTableRowCell(row, 0, ParagraphAlignment.Left, product.Reference);
pdf.AddTableRowCell(row, 1, ParagraphAlignment.Left, product.Name);
pdf.AddTableRowCell(row, 2, ParagraphAlignment.Right, product.Stock.ToString());
});
// Add the table to the section
pdf.AddTableToLastSection(table);
// Rendering the document
await pdf.GenerateAsync();
}
catch
{
OperationErrorsList errorsList = new OperationErrorsList();
errorsList.AddError("export-products-error", Phrases.GlobalErrorOperationDB);
throw new ServiceErrorException(errorsList);
}
}
public async Task ExportStockMovementsToPDFAsync(ExportData <IEnumerable <StockMovement>, StockMovementOptions> data)
{
try
{
IEnumerable <StockMovement> movements = data.Data;
StockMovementOptions options = data?.Options;
PDFGenerator pdf = new PDFGenerator(Phrases.StockMovementsLabel, Phrases.StockMovementsListOf);
Section section = pdf.CreateDocumentSection();
// Set title
pdf.AddParagraph(Phrases.StockMovementsLabel, true, false, 16);
if (options != null)
{
string startDate = (options?.StartDate != default)
? $"{options.StartDate.ShortDate()} - "
: "";
string endDate = (options?.EndDate != default)
? options.EndDate.ShortDate()
: "";
pdf.AddParagraph($"{Phrases.GlobalDate}: {startDate}{endDate}", false, true);
if (!string.IsNullOrEmpty(options.SearchValue))
{
Product product = movements.ElementAt(0).Product;
pdf.AddParagraph($"{Phrases.GlobalProduct}: {product.Reference} {product.Name}", false, true);
}
if (options.LocationId != null)
{
Location location = await AppServices.LocationService.GetByIdAsync(( int )options.LocationId);
pdf.AddParagraph($"{Phrases.GlobalLocation}: {location.Name}", false, true);
}
if (options.UserId != null)
{
User user = await AppServices.UserService.GetByIdAsync(( int )options.UserId);
pdf.AddParagraph($"{Phrases.GlobalUser}: {user.Username}", false, true);
}
pdf.AddParagraph("", false, false, null, 1);
}
// Create table and table columns
Table table = pdf.CreateTable();
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Left);
pdf.AddTableColumn(table, ParagraphAlignment.Right);
pdf.AddTableColumn(table, ParagraphAlignment.Right);
// Create table header
Row row = pdf.CreateTableHeaderRow(table);
pdf.AddTableRowCell(row, 0, ParagraphAlignment.Left, Phrases.GlobalDate, true);
pdf.AddTableRowCell(row, 1, ParagraphAlignment.Left, Phrases.GlobalUser, true);
pdf.AddTableRowCell(row, 2, ParagraphAlignment.Left, Phrases.GlobalReference, true);
pdf.AddTableRowCell(row, 3, ParagraphAlignment.Left, Phrases.GlobalName, true);
pdf.AddTableRowCell(row, 4, ParagraphAlignment.Left, Phrases.GlobalMovement, true);
pdf.AddTableRowCell(row, 5, ParagraphAlignment.Right, Phrases.StockMovementQty, true);
pdf.AddTableRowCell(row, 6, ParagraphAlignment.Right, Phrases.StockMovementStockAcc, true);
// Populate the table rows
movements.ToList().ForEach((movement) => {
row = table.AddRow();
pdf.AddTableRowCell(row, 0, ParagraphAlignment.Left, movement.CreatedAt.ShortDateWithTime());
pdf.AddTableRowCell(row, 1, ParagraphAlignment.Left, movement.User.Username);
pdf.AddTableRowCell(row, 2, ParagraphAlignment.Left, movement.Product.Reference);
pdf.AddTableRowCell(row, 3, ParagraphAlignment.Left, movement.Product.Name);
pdf.AddTableRowCell(row, 4, ParagraphAlignment.Left, movement.ConcatMovementString());
pdf.AddTableRowCell(row, 5, ParagraphAlignment.Right, movement.Qty.ToString());
pdf.AddTableRowCell(row, 6, ParagraphAlignment.Right, movement.Stock.ToString());
});
// Add the table to the section
pdf.AddTableToLastSection(table);
// Rendering the document
await pdf.GenerateAsync();
}
catch
{
OperationErrorsList errorsList = new OperationErrorsList();
errorsList.AddError("export-stock-movements-error", Phrases.GlobalErrorOperationDB);
throw new ServiceErrorException(errorsList);
}
}