public void FillMailEnseignants()
{
CurrentDataReportEnseignant = new Dal_Enseignant().GetAllEnseignantsDataTable();
CurrentDataReportEnseignant = ReportData.AdaptDataTableEnseignant(CurrentDataReportEnseignant);
foreach (DataRow row in CurrentDataReportEnseignant.Rows)
{
//MessageBox.Show( row[0].ToString()+ " "+ row[1].ToString()+" "+row[2].ToString());
FillReportProgrames(Int32.Parse(row[0].ToString()), row[1].ToString(), row[2].ToString());
}
}
string ExportDataTableToPdf()
{
string folderPath = "E:\\PDF\\";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
//File Name
int fileCount = Directory.GetFiles("E:\\PDF").Length;
string strFileName = "Programmes" + (fileCount + 1) + ".pdf";
System.IO.FileStream fs = new FileStream(folderPath + strFileName, FileMode.Create, FileAccess.Write, FileShare.None);
Document document = new Document(PageSize.A4, 55f, 30f, 45f, 0f);
PdfWriter writer = PdfWriter.GetInstance(document, fs);
document.Open();
//Enseignant
CurrentDataReportEnseignant = new Dal_Enseignant().GetAllEnseignantsDataTable();
CurrentDataReportEnseignant = ReportData.AdaptDataTableEnseignant(CurrentDataReportEnseignant);
foreach (DataRow row in CurrentDataReportEnseignant.Rows)
{
#region Section-Image
BaseFont bfntHead = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
Font fntHead = new Font(bfntHead, 16, 1, BaseColor.GRAY);
string imageURL = @"C:\Users\LMIJ\Documents\Visual Studio 2015\Projects\Mini_Projet\Mini_Projet\Logo FSM - Small.png";
iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(imageURL);
//Resize image depend upon your need
jpg.ScaleToFit(90f, 80f);
//Give space before image
jpg.SpacingBefore = 45f;
jpg.IndentationLeft = 55f;
//Give some space after the image
jpg.SpacingAfter = 20f;
document.Add(jpg);
document.Add(new Chunk("\n", fntHead));
document.Add(new Chunk("\n", fntHead));
jpg.Alignment = Element.ALIGN_LEFT;
#endregion
//Report Header
Paragraph prgHeading = new Paragraph();
prgHeading.Alignment = Element.ALIGN_CENTER;
prgHeading.Add(new Chunk("Programme de surveillance".ToUpper(), fntHead));
document.Add(prgHeading);
document.Add(new Chunk("\n", fntHead));
document.Add(new Chunk("\n", fntHead));
//Author
Paragraph prgAuthor = new Paragraph();
BaseFont btnAuthor = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
Font fntAuthor = new Font(btnAuthor, 12, 2, BaseColor.GRAY);
prgAuthor.Alignment = Element.ALIGN_LEFT;
prgAuthor.IndentationLeft = 45f;
prgAuthor.Add(new Chunk("NOM & PRENOM :" + row[1].ToString(), fntAuthor));
prgAuthor.Add(new Chunk("\nDEPARTEMENT :" + row[2].ToString(), fntAuthor));
document.Add(prgAuthor);
document.Add(new Chunk("\n", fntHead));
Paragraph prgMsg = new Paragraph();
prgMsg.Alignment = Element.ALIGN_CENTER;
prgMsg.Add(new Chunk("Vous êtes prié de vous présenter aux séances de surveillances ci-dessous", fntAuthor));
document.Add(prgMsg);
//Add line break
document.Add(new Chunk("\n", fntHead));
//programme data
CurrentDataReportProgrammes = new Dal_Surveillance().GetSurveillancesByEnseignant(Int32.Parse(row[0].ToString()));
CurrentDataReportProgrammes = ReportData.AdaptDataTableProgrammes(CurrentDataReportProgrammes);
//Write the table
PdfPTable table = new PdfPTable(CurrentDataReportProgrammes.Columns.Count);
//Table header
BaseFont btnColumnHeader = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
Font fntColumnHeader = new iTextSharp.text.Font(btnColumnHeader, 10, 1, BaseColor.WHITE);
for (int i = 0; i < CurrentDataReportProgrammes.Columns.Count; i++)
{
PdfPCell cell = new PdfPCell();
cell.BackgroundColor = BaseColor.GRAY;
cell.AddElement(new Chunk(CurrentDataReportProgrammes.Columns[i].ColumnName.ToUpper(), fntColumnHeader));
table.AddCell(cell);
}
//table Data
for (int i = 0; i < CurrentDataReportProgrammes.Rows.Count; i++)
{
for (int j = 0; j < CurrentDataReportProgrammes.Columns.Count; j++)
{
table.AddCell(CurrentDataReportProgrammes.Rows[i][j].ToString());
}
}
// Footer Section
Paragraph prgfooter = new Paragraph();
BaseFont btnfooter = BaseFont.CreateFont(BaseFont.TIMES_ROMAN, BaseFont.CP1252, BaseFont.NOT_EMBEDDED);
Font fntfooter = fntAuthor;
prgfooter.Alignment = Element.ALIGN_RIGHT;
prgfooter.IndentationLeft = 45f;
prgfooter.Add(new Chunk("Fait le " + DateTime.Now.ToShortDateString(), fntAuthor));
//End Of Footer Section
document.Add(table);
document.AddCreationDate();
document.Add(prgfooter);
document.NewPage();
}
document.Close();
writer.Close();
fs.Close();
return(folderPath + strFileName);
}
