public PdfProvider(SqlConnection dbCon, MarginProvider marginProvider, Font font) { this.Document = new PdfDocument(); this.BrushColor = PdfBrushes.Black; this.Margin = marginProvider.Margins; this.Font = font; this.TrueTypeFont = new PdfTrueTypeFont(this.Font); this.Alignment = new PdfStringFormat(PdfTextAlignment.Center); this.DbCon = dbCon; this.Page = this.Document.Pages.Add(PdfPageSize.A4, this.Margin); }
static void Main(string[] args) { using (var db = new RheniumSportsEntities()) { Console.WriteLine(db.Matches.FirstOrDefault()); } var dbCon = new SqlConnection("Server=.\\SQLEXPRESS; Database=TelerikAcademy; Integrated Security=true"); var margin = new MarginProvider(2.54f, 3.17f); var font = new Font("Arial", 16f, FontStyle.Bold); var pdfProvider = new PdfProvider(dbCon, margin, font); pdfProvider.SetHeader("Rhenium League", 50); pdfProvider.CreatePdf("../../Reports/PdfReport.pdf", "SELECT TOP 100 FirstName, LastName, Salary FROM Employees"); }