public virtual void InsertExamToDB(Exam exam, int subjectId)
{
string command = "INSERT INTO EXAMS(\"TITLE\",\"NUMBEROFQUESTIONS\",\"ATTEMPTS\",\"SUBJECT_ID\") VALUES " +
"(\"" + exam.title + "\", " + exam.numberOfQuestions + ", " + exam.attempts + ", " +
"(SELECT ID AS SUBJECT_ID FROM SUBJECTS WHERE SUBJECTS.ID = \"" + subjectId + "\"));";
dbaccess.SQLExecute(command);
foreach (Question q in exam.questions)
{
questionAccess.InsertQuestionToDB(q);
}
}
