Esempio n. 1
0
        public virtual void InsertResultToDB(Result result, int examId, string studentID)
        {
            string command = "INSERT INTO RESULTS(\"EXAM_ID\",\"STUDENT_ID\",\"SCORE\") VALUES " +
                             "(" + examId + ", (SELECT ID AS STUDENT_ID FROM STUDENTS WHERE STUDENTID = \"" + studentID + "\"), " + result.score + "));";

            dbaccess.SQLExecute(command);
            foreach (AnsweredQuestion q in result.answeredQuestions)
            {
                questionAccess.InsertAnsweredToDB(q);
            }
        }