private void FillStudentAbsents()
{
try
{
Student student = CurrentStudent();
int studentId = StudentRepository.GetIdByJmbg(student.Jmbg);
int justifiedAbsents = AbsentsRepository.GetAbsents(studentId, 1);
int unjustifiedAbsents = AbsentsRepository.GetAbsents(studentId, 0);
JustifiedAbsentLabel.Text = justifiedAbsents.ToString();
UnjustifiedAbsentLabel.Text = unjustifiedAbsents.ToString();
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
private void PrintStatisticTeacherRoundedButton_Click(object sender, EventArgs e)
{
int columnNumber = 6;
PdfPTable table = new PdfPTable(columnNumber)
{
//actual width of table in points
TotalWidth = 400f,
//fix the absolute width of the table
LockedWidth = true
};
//relative col widths in proportions - 1/3 and 2/3
float[] widths = new float[] { 1f, 1f, 1f, 1f, 1f, 1f };
table.SetWidths(widths);
table.HorizontalAlignment = 0;
//leave a gap before and after the table
table.SpacingBefore = 20f;
table.SpacingAfter = 30f;
PdfPCell cell = new PdfPCell(new Phrase("Ucenici"))
{
Colspan = columnNumber,
Border = 0,
HorizontalAlignment = 1
};
table.AddCell(cell);
table.AddCell("Ime");
table.AddCell("Prezime");
table.AddCell("Odsustva(U)");
table.AddCell("Odsustva(O)");
table.AddCell("Odsustva(N)");
table.AddCell("Prosjek");
int TeacherId = CurrentTeacher.Id;
int DepartmentId = DepartmentsRepository.GetIdByTeacherId(TeacherId);
string StudentsQuery = StudentRepository.GetQuery(DepartmentId);
SqlCeCommand cmd = new SqlCeCommand(StudentsQuery, Connection);
SqlCeDataReader reader = cmd.ExecuteReader();
try
{
while (reader.Read())
{
int justifiedAbsents = AbsentsRepository.GetAbsents((int)reader["Id"], 1);
int unJustifiedAbsents = AbsentsRepository.GetAbsents((int)reader["Id"], 0);
int sum = justifiedAbsents + unJustifiedAbsents;
string CoursesId = CoursesRepository.GetCoursesId();
string[] parts = CoursesId.Split(',');
int suum = 0;
for (int i = 0; i < parts.Length; i++)
{
string marks = MarksRepository.GetMarks((int)reader["Id"]);
string[] particles = marks.Split(',');
double mark = Math.Round(float.Parse(CalculateAverageGrade(particles)), MidpointRounding.AwayFromZero);
suum += (int)mark;
}
float average = suum / (parts.Length);
string averageMark = average.ToString("0.00") + "(" + Math.Round(average, MidpointRounding.AwayFromZero) + ")";
table.AddCell(reader["Name"].ToString());
table.AddCell(reader["Surname"].ToString());
table.AddCell(sum.ToString());
table.AddCell(justifiedAbsents.ToString());
table.AddCell(unJustifiedAbsents.ToString());
table.AddCell(averageMark);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
LoginForm logf = new LoginForm();
string Dir = logf.GetHomeDirectory();
FileStream fs = new FileStream("report.pdf", FileMode.Create);
Document doc = new Document(PageSize.A4);
PdfWriter pdfWriter = PdfWriter.GetInstance(doc, fs);
doc.Open();
doc.Add(table);
while (reader.Read())
{
doc.Add(new Paragraph(reader[0].ToString() + reader[1].ToString() + reader[2].ToString()));
}
pdfWriter.CloseStream = true;
doc.Close();
Process.Start("report.pdf");
}