public ArrayList getPrereqOfQuiz(int quizID)
{
ArrayList toReturn_list = new ArrayList();
SqlConnection conn = new SqlConnection();
Quiz 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 Quiz q inner join " +
"(select prereq_quizID from QuizPrerequisite where quizID = @check) " +
"as temp on q.quizID = temp.prereq_quizID;";
comm.Parameters.AddWithValue("@check", quizID);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
toReturn = new Quiz();
toReturn.setQuizID((int)dr["quizID"]);
toReturn.setTitle((string)dr["title"]);
toReturn.setDescription((string)dr["description"]);
toReturn.setPassingGrade((int)dr["passingGrade"]);
toReturn.setRandomOrder((string)dr["randomOrder"]);
toReturn.setStatus((string)dr["status"]);
Course_elearnDAO ceDAO = new Course_elearnDAO();
toReturn.setMainCourse(ceDAO.get_course_by_id((int)dr["elearn_courseID"]));
toReturn.setTimeLimit((int)dr["timeLimit"]);
toReturn.setMultipleAttempts((string)dr["multipleAttempts"]);
toReturn.setNumberOfAttempts((int)dr["numberOfAttempts"]);
toReturn.setDisplayAnswer((string)dr["displayAnswer"]);
toReturn_list.Add(toReturn);
}
dr.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(toReturn_list);
}
public List <Quiz> getAllQuizByCourseIDActiveAndInactive(int courseID)
{
SqlConnection conn = new SqlConnection();
List <Quiz> toReturn = new List <Quiz>();
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 [Quiz] where elearn_courseID=@elearn_courseID";
comm.Parameters.AddWithValue("@elearn_courseID", courseID);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
Quiz q = new Quiz();
q.setQuizID((int)dr["quizID"]);
q.setTitle((string)dr["title"]);
q.setDescription((string)dr["description"]);
q.setPassingGrade((int)dr["passingGrade"]);
q.setRandomOrder((string)dr["randomOrder"]);
q.setStatus((string)dr["status"]);
Course_elearnDAO ceDAO = new Course_elearnDAO();
q.setMainCourse(ceDAO.get_course_by_id((int)dr["elearn_courseID"]));
q.setTimeLimit((int)dr["timeLimit"]);
q.setMultipleAttempts((string)dr["multipleAttempts"]);
q.setNumberOfAttempts((int)dr["numberOfAttempts"]);
q.setDisplayAnswer((string)dr["displayAnswer"]);
toReturn.Add(q);
}
dr.Close();
}
catch (SqlException ex)
{
throw ex;
}
finally
{
conn.Close();
}
return(toReturn);
}
