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));
}