public List <Exam> GetExamsOfSubject(int subjectID)
{
DataTable dataTable = dbaccess.SQLGetTableData("SELECT * FROM EXAMS JOIN SUBJECTS ON EXAMS.SUBJECT_ID = SUBJECTS.ID WHERE SUBJECTS.ID = " + subjectID + ";");
List <Exam> exams = new List <Exam>();
if (dataTable.Rows.Count > 0)
{
for (int i = 0; i < dataTable.Rows.Count; i++)
{
exams.Add(new Exam(Convert.ToInt32(dataTable.Rows[i].ItemArray[0]), Convert.ToString(dataTable.Rows[i].ItemArray[1]),
Convert.ToInt32(dataTable.Rows[i].ItemArray[2]), Convert.ToInt32(dataTable.Rows[i].ItemArray[3]),
Convert.ToInt32(dataTable.Rows[i].ItemArray[4])));
List <Question> questions = questionAccess.GetQuestionsOfExam(exams[i].id);
for (int j = 0; j < questions.Count; j++)
{
exams[i].AddQuestion(questions[j]);
}
}
}
return(exams);
}
