public List <ClassWiseResult> GetAllStudentsResultInfoByClass(int classId)
{
float averageResult = 0;
string letterGrade = "";
List <ClassWiseResult> allStudentResults = aClassWiseResultGateway.GetAllStudentResultsByClass(classId);
List <ClassWiseResult> allStudentResultsInformation = new List <ClassWiseResult>();
foreach (ClassWiseResult aStudentResult in allStudentResults)
{
ClassWiseResult aStudentResultInfo = new ClassWiseResult();
averageResult = aStudentResult.TotalMarks / 3;
letterGrade = GetLetterGrade(averageResult);
aStudentResultInfo.StudentName = aStudentResult.StudentName;
aStudentResultInfo.TotalMarks = aStudentResult.TotalMarks;
aStudentResultInfo.Average = averageResult;
aStudentResultInfo.LetterGrade = letterGrade;
allStudentResultsInformation.Add(aStudentResultInfo);
}
return(allStudentResultsInformation);
}
public List <ClassWiseResult> GetAllStudentResultsByClass(int classId)
{
query = "SELECT tbl_students.name AS student_name, SUM(tbl_results.marks) AS total_marks FROM tbl_results " +
"LEFT JOIN tbl_students ON tbl_students.id = tbl_results.student_id " +
"WHERE tbl_students.class_id = '" + classId + "' " +
"GROUP BY tbl_results.student_id, tbl_students.name " +
"ORDER BY student_name ASC";
connection.Open();
command = new SqlCommand(query, connection);
reader = command.ExecuteReader();
List <ClassWiseResult> allStudentResults = new List <ClassWiseResult>();
while (reader.Read())
{
ClassWiseResult aStudentResultInfo = new ClassWiseResult();
aStudentResultInfo.StudentName = reader["student_name"].ToString();
aStudentResultInfo.TotalMarks = Convert.ToInt32(reader["total_marks"]);
allStudentResults.Add(aStudentResultInfo);
}
reader.Close();
connection.Close();
return(allStudentResults);
}
public ClassWiseResult CalculatePassedFailedPercentage(int classId)
{
float averageResult = 0;
float passedPercentage = 0;
float failedPercentage = 0;
int passedStudent = 0;
int failedStudent = 0;
List <ClassWiseResult> allStudentResults = aClassWiseResultGateway.GetAllStudentResultsByClass(classId);
foreach (ClassWiseResult aStudentResult in allStudentResults)
{
averageResult = aStudentResult.TotalMarks / 3;
if (averageResult >= 33)
{
passedStudent++;
}
else
{
failedStudent++;
}
}
passedPercentage = ((float)passedStudent / (float)allStudentResults.Count()) * 100;
failedPercentage = ((float)failedStudent / (float)allStudentResults.Count()) * 100;
ClassWiseResult passedFailedPercentage = new ClassWiseResult();
passedFailedPercentage.Passed = passedPercentage;
passedFailedPercentage.Failed = failedPercentage;
return(passedFailedPercentage);
}
private void searchButton_Click(object sender, EventArgs e)
{
int classId = Convert.ToInt32(classComboBox.SelectedValue);
string className = classComboBox.Text;
List <StudentEntry> totalStudent = aClassWiseResultManager.CalculateTotalStudentInClass(classId);
ClassWiseResult passedFailedPercentage = aClassWiseResultManager.CalculatePassedFailedPercentage(classId);
classNameLabel.Text = className;
totalStudentLabel.Text = totalStudent.Count.ToString();
passedLabel.Text = passedFailedPercentage.Passed.ToString("0.00");
failedLabel.Text = passedFailedPercentage.Failed.ToString("0.00");
LoadAllStudentResultListView(classId);
}
