Team-Zealot-Databases/Databases-Teamwork-2014

Problem #2 – Generate PDF Reports (data loaded from SQL Server and generate PDF reports)

Closed this issue · 1 comments

martin-nikolov commented
  • Your task is to generate a PDF reports summarizing information from the SQL Server.
  • Input: SQL Server database. Output: PDF report.

For example the PDF report may contain a table like the sample (see Databases-Teamwork-Practical-Project-2014.docx)

screenshot

ivaylo-botusharov commented

Completed task by using iTextSharp open source library. All code regarding this task is in 3 files:

RobotsFactory.Data/PdfExportFactoryFromMsSqlDatabase.cs
RobotsFactory.ConsoleClient/RobotsFactoryConsoleClient.cs
RobotsFactory.WPF/MainWindow.xaml.cs

Aggregated report successfully exports into PDF table (the pdf file is being saved in the Reports folder). There is some space for improvement e.g. removing repeating code through design patterns (e.g. factory pattern), but taking into consideration the limited time I consider this task as finished. If you guys want to make some changes for good please feel free to modify the code. Closing issue!