public List <GradeReport> GetListGradeReportBySection(int sectionID)
{
List <GradeReport> listGradeReports = new List <GradeReport>();
OleDbCommand cmd = dbconn.SqlCommand("SELECT * FROM grade_report WHERE section_id=?", sectionID);
OleDbDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
listGradeReports.Add(GradeReportReader.Read(ref rd));
}
return(listGradeReports);
}
public List <GradeReport> GetListAllGradeReports()
{
List <GradeReport> listGradeReports = new List <GradeReport>();
OleDbCommand cmd = dbconn.SqlCommand(
"SELECT * FROM grade_report");
OleDbDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
listGradeReports.Add(GradeReportReader.Read(ref rd));
}
return(listGradeReports);
}
public GradeReport GetGradeReport(int sectionID, string studentID)
{
OleDbCommand cmd = dbconn.SqlCommand(
"SELECT * FROM grade_report WHERE section_id=? AND student_id=?",
sectionID, studentID
);
OleDbDataReader rd = cmd.ExecuteReader();
GradeReport gradeReport = null;
while (rd.Read())
{
gradeReport = GradeReportReader.Read(ref rd);
}
return(gradeReport);
}
