private void AddTableDataRow(Table table, CardHolderReportInfo chl, bool altRow) { if (chl == null) { return; } table.StartNewRow(); //table.AddCell(new Cell(). // SetBorderLeft(new iText.Layout.Borders.SolidBorder(iText.Kernel.Colors.Color.WHITE, 1)). // SetBorderTop(new iText.Layout.Borders.SolidBorder(iText.Kernel.Colors.Color.WHITE, 1)). // SetBorderBottom(new iText.Layout.Borders.SolidBorder(iText.Kernel.Colors.Color.WHITE, 1))); table.AddCell(new Cell(). Add(new Paragraph(string.IsNullOrEmpty(chl.BlockedStatus) ? string.Empty : chl.BlockedStatus). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(string.IsNullOrEmpty(chl.FirstName) ? string.Empty : chl.FirstName). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(string.IsNullOrEmpty(chl.CNICNumber) ? string.Empty : chl.CNICNumber). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(string.IsNullOrEmpty(chl.BlockedBy) ? string.Empty : chl.BlockedBy). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(string.IsNullOrEmpty(chl.BlockedReason) ? string.Empty : chl.BlockedReason). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(chl.BlockedTime.ToString()). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(string.IsNullOrEmpty(chl.UnBlockedBy) ? string.Empty : chl.UnBlockedBy). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(string.IsNullOrEmpty(chl.UnBlockedReason) ? string.Empty : chl.UnBlockedReason). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(chl.UnBlockedTime == DateTime.MaxValue ? string.Empty : chl.UnBlockedTime.ToString()). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); }
private void SaveAsPdf(Dictionary <string, List <CardHolderReportInfo> > data, string heading) { Cursor currentCursor = Cursor.Current; try { Cursor.Current = Cursors.WaitCursor; if (data != null) { using (PdfWriter pdfWriter = new PdfWriter(this.saveFileDialog1.FileName)) { using (PdfDocument pdfDocument = new PdfDocument(pdfWriter)) { using (Document doc = new Document(pdfDocument)) { doc.SetFont(PdfFontFactory.CreateFont("Fonts/SEGOEUIL.TTF")); string headerLeftText = "Report From: " + this.dtpFromDate.Value.ToShortDateString() + " To: " + this.dtpToDate.Value.ToShortDateString(); string headerRightText = string.Empty; string footerLeftText = "This is computer generated report."; string footerRightText = "Report generated on: " + DateTime.Now.ToString(); pdfDocument.AddEventHandler(PdfDocumentEvent.START_PAGE, new PdfHeaderAndFooter(doc, true, headerLeftText, headerRightText)); pdfDocument.AddEventHandler(PdfDocumentEvent.END_PAGE, new PdfHeaderAndFooter(doc, false, footerLeftText, footerRightText)); pdfDocument.SetDefaultPageSize(new iText.Kernel.Geom.PageSize(1400F, 842F)); Table table = new Table((new List <float>() { 70F, 150F, 100F, 150F, 220F, 120F, 150F, 220F, 120F }).ToArray()); table.SetWidth(1300F); table.SetFixedLayout(); //Table table = new Table((new List<float>() { 8F, 100F, 150F, 225F, 60F, 40F, 100F, 125F, 150F }).ToArray()); this.AddMainHeading(table, heading); this.AddNewEmptyRow(table); //this.AddNewEmptyRow(table); foreach (KeyValuePair <string, List <CardHolderReportInfo> > category in data) { if (category.Value == null) { continue; } //Category this.AddCategoryRow(table, category.Key); //Data //this.AddNewEmptyRow(table, false); this.AddTableHeaderRow(table); for (int i = 0; i < category.Value.Count; i++) { CardHolderReportInfo chl = category.Value[i]; this.AddTableDataRow(table, chl, i % 2 == 0); } this.AddNewEmptyRow(table); } doc.Add(table); doc.Close(); } } System.Diagnostics.Process.Start(this.saveFileDialog1.FileName); } } Cursor.Current = currentCursor; } catch (Exception exp) { Cursor.Current = currentCursor; if (exp.HResult == -2147024864) { MessageBox.Show(this, "\"" + this.saveFileDialog1.FileName + "\" is already is use.\n\nPlease close it and generate report again."); } else if (exp.HResult == -2147024891) { MessageBox.Show(this, "You did not have rights to save file on selected location.\n\nPlease run as administrator."); } else { MessageBox.Show(this, exp.Message); } } }
private void SaveAsExcel(Dictionary <string, List <CardHolderReportInfo> > data, string sheetName, string heading) { Cursor currentCursor = Cursor.Current; try { Cursor.Current = Cursors.WaitCursor; if (data != null) { using (ExcelPackage ex = new ExcelPackage()) { ExcelWorksheet work = ex.Workbook.Worksheets.Add(sheetName); work.View.ShowGridLines = false; work.Cells.Style.Font.Name = "Segoe UI Light"; work.Column(1).Width = 20; work.Column(2).Width = 40; work.Column(3).Width = 22; work.Column(4).Width = 40; work.Column(5).Width = 40; work.Column(6).Width = 25.29; work.Column(7).Width = 40; work.Column(8).Width = 40; work.Column(9).Width = 25.29; //Heading work.Cells["A1:D2"].Merge = true; work.Cells["A1:B2"].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; work.Cells["A1:B2"].Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.FromArgb(252, 213, 180)); work.Cells["A1:B2"].Style.Font.Size = 22; work.Cells["A1:B2"].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; work.Cells["A1:B2"].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; //work.Cells["A1:B2"].Style.Border.Top.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thick; //work.Cells["A1:B2"].Style.Border.Bottom.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thick; //work.Cells["A1:B2"].Style.Border.Left.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thick; //work.Cells["A1:B2"].Style.Border.Right.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thick; //work.Cells["A1:B2"].Style.Border.Top.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); //work.Cells["A1:B2"].Style.Border.Bottom.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); //work.Cells["A1:B2"].Style.Border.Left.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); //work.Cells["A1:B2"].Style.Border.Right.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); work.Cells["A1:B2"].Value = heading; // img variable actually is your image path System.Drawing.Image myImage = System.Drawing.Image.FromFile("Images/logo.png"); var pic = work.Drawings.AddPicture("Logo", myImage); pic.SetPosition(5, 1300); int row = 4; work.Cells[row, 1].Style.Font.Bold = true; work.Cells[row, 1].Style.Font.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); work.Cells[row, 1, row, 2].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; work.Cells[row, 1, row, 2].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; work.Cells[row, 1].Value = "Report From: "; work.Cells[row, 2].Value = this.dtpFromDate.Value.ToShortDateString(); work.Row(row).Height = 20; row++; work.Cells[row, 1].Style.Font.Bold = true; work.Cells[row, 1].Style.Font.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); work.Cells[row, 1, row, 2].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; work.Cells[row, 1, row, 2].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; work.Cells[row, 1].Value = "Report To:"; work.Cells[row, 2].Value = this.dtpToDate.Value.ToShortDateString(); work.Row(row).Height = 20; //row++; //work.Cells[row, 1].Style.Font.Bold = true; //work.Cells[row, 1].Style.Font.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); //work.Cells[row, 1, row, 2].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; //work.Cells[row, 1, row, 2].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; //work.Cells[row, 1].Value = "Late Time Range:"; //work.Cells[row, 2].Value = this.dtpLateTimeStart.Value.ToShortTimeString() + " - " + this.dtpLateTimeEnd.Value.ToShortTimeString(); //work.Row(row).Height = 20; row++; work.Cells[row, 1].Style.Font.Bold = true; work.Cells[row, 1].Style.Font.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); work.Cells[row, 1, row, 2].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; work.Cells[row, 1, row, 2].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; work.Cells[row, 1].Value = "Report Time: "; work.Cells[row, 2].Value = DateTime.Now.ToString(); work.Row(row).Height = 20; row++; row++; foreach (KeyValuePair <string, List <CardHolderReportInfo> > category in data) { if (category.Value == null) { continue; } //Section work.Cells[row, 1].Style.Font.Bold = true; work.Cells[row, 1].Style.Font.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); work.Cells[row, 1, row, 2].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; work.Cells[row, 1, row, 2].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Left; work.Cells[row, 1].Value = "Category:"; work.Cells[row, 2].Value = category.Key; work.Row(row).Height = 20; //Data row++; work.Cells[row, 1, row, 9].Style.Border.Top.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin; work.Cells[row, 1, row, 9].Style.Border.Bottom.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin; work.Cells[row, 1, row, 9].Style.Border.Left.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin; work.Cells[row, 1, row, 9].Style.Border.Right.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin; work.Cells[row, 1, row, 9].Style.Border.Top.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); work.Cells[row, 1, row, 9].Style.Border.Bottom.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); work.Cells[row, 1, row, 9].Style.Border.Left.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); work.Cells[row, 1, row, 9].Style.Border.Right.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); work.Cells[row, 1, row, 9].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; work.Cells[row, 1, row, 9].Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.FromArgb(253, 233, 217)); work.Cells[row, 1, row, 9].Style.VerticalAlignment = OfficeOpenXml.Style.ExcelVerticalAlignment.Center; work.Cells[row, 1, row, 9].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; work.Cells[row, 1].Value = "Blocked Status Number"; work.Cells[row, 2].Value = "First Name"; work.Cells[row, 3].Value = "CNIC Number"; work.Cells[row, 4].Value = "Blocked By"; work.Cells[row, 5].Value = "Blocked Reason"; work.Cells[row, 6].Value = "Blocked Time"; work.Cells[row, 7].Value = "UnBlocked By"; work.Cells[row, 8].Value = "UnBlocked Reason"; work.Cells[row, 9].Value = "UnBlocked Time"; work.Row(row).Height = 20; for (int i = 0; i < category.Value.Count; i++) { row++; work.Cells[row, 1, row, 9].Style.Border.Top.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin; work.Cells[row, 1, row, 9].Style.Border.Bottom.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin; work.Cells[row, 1, row, 9].Style.Border.Left.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin; work.Cells[row, 1, row, 9].Style.Border.Right.Style = OfficeOpenXml.Style.ExcelBorderStyle.Thin; work.Cells[row, 1, row, 9].Style.Border.Top.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); work.Cells[row, 1, row, 9].Style.Border.Bottom.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); work.Cells[row, 1, row, 9].Style.Border.Left.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); work.Cells[row, 1, row, 9].Style.Border.Right.Color.SetColor(System.Drawing.Color.FromArgb(247, 150, 70)); if (i % 2 == 0) { work.Cells[row, 1, row, 9].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid; work.Cells[row, 1, row, 9].Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.LightGray); } work.Cells[row, 1, row, 9].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; //work.Cells[row, 2].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; //work.Cells[row, 3].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Right; CardHolderReportInfo chl = category.Value[i]; work.Cells[row, 1].Value = chl.BlockedStatus; work.Cells[row, 2].Value = chl.FirstName; work.Cells[row, 3].Value = chl.CNICNumber; work.Cells[row, 4].Value = chl.BlockedBy.ToString(); work.Cells[row, 4].Value = chl.BlockedReason.ToString(); work.Cells[row, 4].Value = chl.BlockedTime.ToString(); work.Cells[row, 4].Value = chl.UnBlockedBy.ToString(); work.Cells[row, 4].Value = chl.UnBlockedReason.ToString(); work.Cells[row, 5].Value = chl.UnBlockedTime.ToString(); work.Row(row).Height = 20; } row++; row++; } ex.SaveAs(new System.IO.FileInfo(this.saveFileDialog1.FileName)); System.Diagnostics.Process.Start(this.saveFileDialog1.FileName); } } Cursor.Current = currentCursor; } catch (Exception exp) { Cursor.Current = currentCursor; if (exp.InnerException != null && exp.InnerException.InnerException != null) { if (exp.InnerException.InnerException.HResult == -2147024864) { MessageBox.Show(this, "\"" + this.saveFileDialog1.FileName + "\" is already is use.\n\nPlease close it and generate report again."); } if (exp.InnerException.InnerException.HResult == -2147024891) { MessageBox.Show(this, "You did not have rights to save file on selected location.\n\nPlease run as administrator."); } } else { MessageBox.Show(this, exp.Message); } } }
private void AddTableDataRow(Table table, CardHolderReportInfo chl, bool altRow) { if (chl == null) { return; } table.StartNewRow(); table.AddCell(new Cell(). Add(new Paragraph(string.IsNullOrEmpty(chl.Category) ? string.Empty : chl.Category). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(string.IsNullOrEmpty(chl.FirstName) ? string.Empty : chl.FirstName). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(string.IsNullOrEmpty(chl.CNICNumber) ? string.Empty : chl.CNICNumber). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(string.IsNullOrEmpty(chl.BlockedStatus) ? string.Empty : chl.BlockedStatus). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(string.IsNullOrEmpty(chl.Company) ? string.Empty : chl.Company). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); table.AddCell(new Cell(). Add(new Paragraph(chl.TotalDaysCkekin.ToString()). SetFontSize(11F)). SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). SetTextAlignment(iText.Layout.Properties.TextAlignment.CENTER). SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); //table.AddCell(new Cell(). // Add(new Paragraph(string.IsNullOrEmpty(chl.Crew) ? string.Empty : chl.Crew). // SetFontSize(11F)). // SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). // SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). // SetTextAlignment(iText.Layout.Properties.TextAlignment.LEFT). // SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); //table.AddCell(new Cell(). // Add(new Paragraph(string.IsNullOrEmpty(chl.Cadre) ? string.Empty : chl.Cadre). // SetFontSize(11F)). // SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). // SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). // SetTextAlignment(iText.Layout.Properties.TextAlignment.LEFT). // SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); //table.AddCell(new Cell(). // Add(new Paragraph(string.IsNullOrEmpty(chl.CNICNumber) ? string.Empty : chl.CNICNumber). // SetFontSize(11F)). // SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). // SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). // SetTextAlignment(iText.Layout.Properties.TextAlignment.LEFT). // SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); //table.AddCell(new Cell(). // Add(new Paragraph(string.IsNullOrEmpty(chl.Company) ? string.Empty : chl.Company). // SetFontSize(11F)). // SetBackgroundColor(altRow ? new DeviceRgb(211, 211, 211) : iText.Kernel.Colors.Color.WHITE). // SetBorder(new iText.Layout.Borders.SolidBorder(new DeviceRgb(247, 150, 70), 1)). // SetTextAlignment(iText.Layout.Properties.TextAlignment.LEFT). // SetVerticalAlignment(iText.Layout.Properties.VerticalAlignment.MIDDLE)); }