public QuizAnswer getQuizAnswerByID(int quizAnswerID) { SqlConnection conn = new SqlConnection(); QuizAnswer toReturn = null; 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 [QuizAnswer] where quizAnswerID=@quizAnswerID"; comm.Parameters.AddWithValue("@quizAnswerID", quizAnswerID); SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { toReturn = new QuizAnswer(); toReturn.setAnswer((string)dr["answer"]); QuizQuestionDAO qqDAO = new QuizQuestionDAO(); toReturn.setQuizQuestion(qqDAO.getQuizQuestionByID((int)dr["quizQuestionID"])); } dr.Close(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(toReturn); }
public List <QuizResultHistory> getAllQuizResultHistoryByQuizIDandAttempt(int attempt, int quizID) { SqlConnection conn = new SqlConnection(); List <QuizResultHistory> toReturn = new List <QuizResultHistory>(); 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 [QuizResultHistory] where attempt=@attempt and quizID=@quizID"; comm.Parameters.AddWithValue("@attempt", attempt); comm.Parameters.AddWithValue("quizID", quizID); SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { QuizResultHistory qrh = new QuizResultHistory(); qrh.setUserID((string)dr["userID"]); QuizQuestionDAO qqDAO = new QuizQuestionDAO(); QuizAnswerDAO qaDAO = new QuizAnswerDAO(); qrh.setQuestion(qqDAO.getQuizQuestionByID((int)dr["quizQuestionID"])); qrh.setAnswer(qaDAO.getQuizAnswerByID((int)dr["quizAnswerID"])); qrh.setAttempt((int)dr["attempt"]); qrh.setQuizID((int)dr["quizID"]); toReturn.Add(qrh); } dr.Close(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(toReturn); }