public PdfPTable PdfPTable_Employeeaddressdetails(Document document, PdfWriter writer,string mode,string letter)
{
DataTable dtresult = ff_fillAddress();
var result = from r in dtresult.AsEnumerable()
where r.Field<string>("Add_Type") == letter
select r;
DataTable dt = result.CopyToDataTable();
System.Data.DataView view = new System.Data.DataView(dt);
System.Data.DataTable selected = view.ToTable("Selected", false, dt.Columns[10].ColumnName.ToString(), dt.Columns[3].ColumnName.ToString(), dt.Columns[4].ColumnName.ToString(), dt.Columns[5].ColumnName.ToString(), dt.Columns[6].ColumnName.ToString(), dt.Columns[7].ColumnName.ToString(), dt.Columns[8].ColumnName.ToString(), dt.Columns[9].ColumnName.ToString());
iTextSharp.text.pdf.PdfPTable PdfTableN = new iTextSharp.text.pdf.PdfPTable(selected.Columns.Count);
PdfTableN.WidthPercentage = 90f;
iTextSharp.text.pdf.PdfPCell pcel1 = new PdfPCell(new Phrase(new Chunk("Address Type", textfont)));
pcel1.BackgroundColor = iTextSharp.text.Color.LIGHT_GRAY;
pcel1.HorizontalAlignment = 1;
pcel1.Border = 0;
PdfTableN.AddCell(pcel1);
pcel1 = new PdfPCell(new Phrase(new Chunk("Address1", textfont)));
pcel1.BackgroundColor = iTextSharp.text.Color.LIGHT_GRAY;
pcel1.HorizontalAlignment = 1;
pcel1.Border = 0;
PdfTableN.AddCell(pcel1);
pcel1 = new PdfPCell(new Phrase(new Chunk("Address2", textfont)));
pcel1.BackgroundColor = iTextSharp.text.Color.LIGHT_GRAY;
pcel1.HorizontalAlignment = 1;
pcel1.Border = 0;
PdfTableN.AddCell(pcel1);
pcel1 = new PdfPCell(new Phrase(new Chunk("Address3", textfont)));
pcel1.BackgroundColor = iTextSharp.text.Color.LIGHT_GRAY;
pcel1.HorizontalAlignment = 1;
pcel1.Border = 0;
PdfTableN.AddCell(pcel1);
pcel1 = new PdfPCell(new Phrase(new Chunk("PO Box", textfont)));
pcel1.BackgroundColor = iTextSharp.text.Color.LIGHT_GRAY;
pcel1.HorizontalAlignment = 1;
pcel1.Border = 0;
PdfTableN.AddCell(pcel1);
pcel1 = new PdfPCell(new Phrase(new Chunk("Phone", textfont)));
pcel1.BackgroundColor = iTextSharp.text.Color.LIGHT_GRAY;
pcel1.HorizontalAlignment = 1;
pcel1.Border = 0;
PdfTableN.AddCell(pcel1);
pcel1 = new PdfPCell(new Phrase(new Chunk("Mobile", textfont)));
pcel1.BackgroundColor = iTextSharp.text.Color.LIGHT_GRAY;
pcel1.HorizontalAlignment = 1;
pcel1.Border = 0;
PdfTableN.AddCell(pcel1);
pcel1 = new PdfPCell(new Phrase(new Chunk("Email", textfont)));
pcel1.BackgroundColor = iTextSharp.text.Color.LIGHT_GRAY;
pcel1.HorizontalAlignment = 1;
pcel1.Border = 0;
PdfTableN.AddCell(pcel1);
for (int rowss = 0; rowss < selected.Rows.Count; rowss++)
{
for (int columnn = 0; columnn < selected.Columns.Count; columnn++)
{
iTextSharp.text.pdf.PdfPCell pcel2 = new PdfPCell();
if (selected.Rows[rowss][columnn].ToString() == letter)
{
pcel2 = new PdfPCell(new Phrase(mode, textfont1));
}
else
{
pcel2 = new PdfPCell(new Phrase(new Chunk(selected.Rows[rowss][columnn].ToString(), textfont1)));
}
pcel2.HorizontalAlignment = 1;
pcel2.Border = 0;
PdfTableN.AddCell(pcel2);
}
}
if (selected.Rows.Count != 0)
{
document.Add(PdfTableN);
}
else
{
Paragraph err = new Paragraph("\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t NA");
document.Add(err);
}
return PdfTableN;
}
PdfPTable_Employeeaddressdetails(pdfDoc, writer,"Office","O");