public ArrayList getAllQuizResultByQuizID(int quizID, string userID) { SqlConnection conn = new SqlConnection(); ArrayList toReturn = new ArrayList(); try { conn = new SqlConnection(); string connstr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString(); conn.ConnectionString = connstr; conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; comm.CommandText = "select * from [QuizResult] where quizID=@quizID and userID=@userID"; comm.Parameters.AddWithValue("@quizID", quizID); comm.Parameters.AddWithValue("@userID", userID); SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { QuizResult qr = new QuizResult(); UserDAO userDAO = new UserDAO(); QuizDAO quizDAO = new QuizDAO(); QuizResultHistoryDAO qrhDAO = new QuizResultHistoryDAO(); qr.setQuizResultID((int)dr["quizResultID"]); qr.setUser(userDAO.getUserByID((string)dr["userID"])); qr.setQuiz(quizDAO.getQuizByID((int)dr["quizID"])); qr.setScore((int)dr["score"]); qr.setGrade((string)dr["grade"]); qr.setDateSubmitted(dr.GetDateTime(5)); qr.setAttempt((int)dr["attempt"]); toReturn.Add(qr); } dr.Close(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(toReturn); }
public List <QuizQuestion> getAllQuizQuestionByQuizID(int quizID) { SqlConnection conn = new SqlConnection(); List <QuizQuestion> toReturn = new List <QuizQuestion>(); try { conn = new SqlConnection(); string connstr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ToString(); conn.ConnectionString = connstr; conn.Open(); SqlCommand comm = new SqlCommand(); comm.Connection = conn; comm.CommandText = "select * from [QuizQuestion] where quizID=@quizID"; comm.Parameters.AddWithValue("@quizID", quizID); SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { QuizQuestion qq = new QuizQuestion(); qq.setQuizQuestionID((int)dr["quizQuestionID"]); qq.setQuestion((string)dr["question"]); QuizDAO qDAO = new QuizDAO(); qq.setQuiz(qDAO.getQuizByID((int)dr["quizID"])); QuizAnswerDAO qaDAO = new QuizAnswerDAO(); qq.setQuizAnswer(qaDAO.getCorrectQuizAnswerByID((int)dr["correctAnswerID"])); toReturn.Add(qq); } dr.Close(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(toReturn); }