protected void pdfButton_Click(object sender, EventArgs e)
{
try
{
List<ShowCourse> showCourses = new List<ShowCourse>();
CourseManager aCourseManager = new CourseManager();
int departmentId = Convert.ToInt16(departmentDropDownList.Text);
int semesterId = Convert.ToInt16(semesterDropDownList.Text);
showCourses = aCourseManager.GetScheduleCoursesByDepartmentIdAndSemester(departmentId, semesterId);
Document doc = new Document(iTextSharp.text.PageSize.LETTER, 10, 10, 42, 35);
string pdfFilePath = Server.MapPath("CoursePdf.pdf");
PdfWriter wri = PdfWriter.GetInstance(doc, new FileStream(pdfFilePath, FileMode.Create));
doc.Open(); //Open Document to write
iTextSharp.text.Font font8 = FontFactory.GetFont("ARIAL", 7);
string heading = " \t\t Course Schedule Details for Department: " +
departmentDropDownList.SelectedItem;
Paragraph reportHeading = new Paragraph(heading);
if (showCourses != null)
{
PdfPTable PdfTable = new PdfPTable(6);
PdfPCell PdfPCell = null;
PdfPCell = new PdfPCell(new Phrase(new Chunk("Course Code", font8)));
PdfTable.AddCell(PdfPCell);
PdfPCell = new PdfPCell(new Phrase(new Chunk("Course Name", font8)));
PdfTable.AddCell(PdfPCell);
PdfPCell = new PdfPCell(new Phrase(new Chunk("Semester Name", font8)));
PdfTable.AddCell(PdfPCell);
PdfPCell = new PdfPCell(new Phrase(new Chunk("Course Credit", font8)));
PdfTable.AddCell(PdfPCell);
PdfPCell = new PdfPCell(new Phrase(new Chunk("Assign To", font8)));
PdfTable.AddCell(PdfPCell);
PdfPCell = new PdfPCell(new Phrase(new Chunk("Schedule", font8)));
PdfTable.AddCell(PdfPCell);
foreach (ShowCourse aCourse in showCourses)
{
PdfPCell = new PdfPCell(new Phrase(new Chunk(aCourse.courseCode, font8)));
PdfTable.AddCell(PdfPCell);
PdfPCell = new PdfPCell(new Phrase(new Chunk(aCourse.courseName, font8)));
PdfTable.AddCell(PdfPCell);
PdfPCell = new PdfPCell(new Phrase(new Chunk(aCourse.semesterName, font8)));
PdfTable.AddCell(PdfPCell);
PdfPCell = new PdfPCell(new Phrase(new Chunk((aCourse.credit).ToString(), font8)));
PdfTable.AddCell(PdfPCell);
PdfPCell = new PdfPCell(new Phrase(new Chunk(aCourse.teacherName, font8)));
PdfTable.AddCell(PdfPCell);
PdfPCell = new PdfPCell(new Phrase(new Chunk(aCourse.schedule, font8)));
PdfTable.AddCell(PdfPCell);
}
PdfTable.SpacingBefore = 15f; // Give some space after the text or it m
doc.Add(reportHeading); // add paragraph to the document
doc.Add(PdfTable); // add pdf table to the document
doc.Close();
// string pdfPath = Server.MapPath("~/SomePDFFile.pdf");
WebClient client = new WebClient();
Byte[] buffer = client.DownloadData(pdfFilePath);
Response.ContentType = "application/pdf";
Response.AddHeader("content-length", buffer.Length.ToString());
Response.BinaryWrite(buffer);
}
}
catch (SqlException sqlException)
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = "Database error.See details error: " + sqlException.Message;
}
catch (Exception exception)
{
msgLabel.ForeColor = Color.Red;
string errorMessage = "Unknow error occured.";
errorMessage += exception.Message;
if (exception.InnerException != null)
{
errorMessage += exception.InnerException.Message;
}
msgLabel.Text = errorMessage;
}
}
protected void semesterDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
List<ShowCourse> showCourses = new List<ShowCourse>();
CourseManager aCourseManager = new CourseManager();
int departmentId = Convert.ToInt16(departmentDropDownList.Text);
int semesterId = Convert.ToInt16(semesterDropDownList.Text);
showCourses = aCourseManager.GetScheduleCoursesByDepartmentIdAndSemester(departmentId, semesterId);
courseGridView.DataSource = showCourses;
courseGridView.DataBind();
}
catch (SqlException sqlException)
{
msgLabel.ForeColor = Color.Red;
msgLabel.Text = "Database error.See details error: " + sqlException.Message;
}
catch (Exception exception)
{
msgLabel.ForeColor = Color.Red;
string errorMessage = "Unknow error occured.";
errorMessage += exception.Message;
if (exception.InnerException != null)
{
errorMessage += exception.InnerException.Message;
}
msgLabel.Text = errorMessage;
}
}