public void InsertStudent(Student student)
{
using (StudentsModel db = new StudentsModel())
{
db.Students.Add(student);
db.SaveChanges();
}
}
public static void CreatePDF(Student[] students)
{
try {
FileStream fs = new FileStream("StudentList.pdf", FileMode.Create, FileAccess.Write, FileShare.None);
Document doc = new Document();
doc.SetPageSize(iTextSharp.text.PageSize.A4.Rotate());
PdfWriter writer = PdfWriter.GetInstance(doc, fs);
PdfPTable table = new PdfPTable(7);
table.TotalWidth = 800f;
table.DefaultCell.FixedHeight = 110f;
table.LockedWidth = true;
float[] widths = { 2f, 2f,2f,2f,2f,2f,2f};
table.SetWidths(widths);
table.HorizontalAlignment = 0;
//PdfPCell cell = new PdfPCell();
//cell.Colspan = 3;
//cell.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right
Paragraph para = new Paragraph("Holdliste for: " + students[0].Team.Name);
foreach (var item in students)
{
PdfPCell cell2 = new PdfPCell(new Phrase("Navn"));
cell2.BackgroundColor = new BaseColor(198, 198, 198);
PdfPCell cell3 = new PdfPCell(new Phrase("Hold"));
cell3.BackgroundColor = new BaseColor(198, 198, 198);
PdfPCell cell4 = new PdfPCell(new Phrase("DB Bruger"));
cell4.BackgroundColor = new BaseColor(198, 198, 198);
PdfPCell cell5 = new PdfPCell(new Phrase("DB PW"));
cell5.BackgroundColor = new BaseColor(198, 198, 198);
PdfPCell cell6 = new PdfPCell(new Phrase("FTP Bruger"));
cell6.BackgroundColor = new BaseColor(198, 198, 198);
PdfPCell cell7 = new PdfPCell(new Phrase("FTP PW"));
cell7.BackgroundColor = new BaseColor(198, 198, 198);
PdfPCell cell8 = new PdfPCell(new Phrase("Website Port"));
cell8.BackgroundColor = new BaseColor(198, 198, 198);
table.AddCell(cell2);
table.AddCell(cell3);
table.AddCell(cell4);
table.AddCell(cell5);
table.AddCell(cell6);
table.AddCell(cell7);
table.AddCell(cell8);
table.AddCell(item.Name);
table.AddCell(item.Team.Name);
table.AddCell(item.Credentials.DatabaseUserName);
table.AddCell(item.Credentials.DatabasePassword);
table.AddCell(item.Credentials.FTPUserName);
table.AddCell(item.Credentials.FTPPassword);
table.AddCell(item.Credentials.WebsitePort + "");
}
doc.Open();
doc.Add(para);
doc.Add(table);
doc.Close();
}
catch (Exception ex)
{
throw ex;
}
}
