public QuizAnswer getCorrectQuizAnswerByID(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"]); } dr.Close(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(toReturn); }
public List <QuizAnswer> getAllQuizAnswersByQuizQuestionID(int quizQuestionID) { SqlConnection conn = new SqlConnection(); List <QuizAnswer> toReturn = new List <QuizAnswer>(); 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 quizQuestionID=@quizQuestionID"; comm.Parameters.AddWithValue("@quizQuestionID", quizQuestionID); SqlDataReader dr = comm.ExecuteReader(); while (dr.Read()) { QuizAnswer qa = new QuizAnswer(); qa.setQuizAnswerID((int)dr["quizAnswerID"]); qa.setAnswer((string)dr["answer"]); toReturn.Add(qa); } dr.Close(); } catch (SqlException ex) { throw ex; } finally { conn.Close(); } return(toReturn); }
protected void btnNewQn_Click(object sender, EventArgs e) { //to do validation Page.Validate("ValidateForm"); if (!Page.IsValid) { } else { List <QuizQuestion> allQuestions = (List <QuizQuestion>)Session["allQuestions"]; QuizQuestion newQuestion = new QuizQuestion(); newQuestion.setQuestion(txtQuizQuestion.Text); QuizAnswer answer1 = new QuizAnswer(); answer1.setAnswer(txtOptionOne.Text); QuizAnswer answer2 = new QuizAnswer(); answer2.setAnswer(txtOptionTwo.Text); QuizAnswer answer3 = new QuizAnswer(); answer3.setAnswer(txtOptionThree.Text); QuizAnswer answer4 = new QuizAnswer(); answer4.setAnswer(txtOptionFour.Text); List <QuizAnswer> allAnswers = new List <QuizAnswer>(); allAnswers.Add(answer1); allAnswers.Add(answer2); allAnswers.Add(answer3); allAnswers.Add(answer4); newQuestion.setAllAnswers(allAnswers); if (ddlCorrectAns.SelectedValue.Equals("1")) { newQuestion.setQuizAnswer(answer1); } else if (ddlCorrectAns.SelectedValue.Equals("2")) { newQuestion.setQuizAnswer(answer2); } else if (ddlCorrectAns.SelectedValue.Equals("3")) { newQuestion.setQuizAnswer(answer3); } else { newQuestion.setQuizAnswer(answer4); } allQuestions.Add(newQuestion); Session["allQuestions"] = allQuestions; int counter = (int)Session["questionNumber"]; lblAddedMsg.Text = $"Question {counter++} has been added successfully."; lblAddedMsg.Visible = true; Session["questionNumber"] = counter; txtQuizQuestion.Text = ""; txtNumCorrectAns.Text = ""; txtOptionOne.Text = ""; txtOptionTwo.Text = ""; txtOptionThree.Text = ""; txtOptionFour.Text = ""; lblQuestionNumber.Text = "Question " + counter; } }
protected void btnConfirmSubmit_Click(object sender, EventArgs e) { //to do validation Page.Validate("ValidateFormTwo"); if (!Page.IsValid) { } else { //add the last question List <QuizQuestion> allQuestions = (List <QuizQuestion>)Session["allQuestions"]; QuizQuestion newQuestion = new QuizQuestion(); newQuestion.setQuestion(txtQuizQuestion.Text); QuizAnswer answer1 = new QuizAnswer(); answer1.setAnswer(txtOptionOne.Text); QuizAnswer answer2 = new QuizAnswer(); answer2.setAnswer(txtOptionTwo.Text); QuizAnswer answer3 = new QuizAnswer(); answer3.setAnswer(txtOptionThree.Text); QuizAnswer answer4 = new QuizAnswer(); answer4.setAnswer(txtOptionFour.Text); List <QuizAnswer> allAnswersForLastQn = new List <QuizAnswer>(); allAnswersForLastQn.Add(answer1); allAnswersForLastQn.Add(answer2); allAnswersForLastQn.Add(answer3); allAnswersForLastQn.Add(answer4); newQuestion.setAllAnswers(allAnswersForLastQn); if (ddlCorrectAns.SelectedValue.Equals("1")) { newQuestion.setQuizAnswer(answer1); } else if (ddlCorrectAns.SelectedValue.Equals("2")) { newQuestion.setQuizAnswer(answer2); } else if (ddlCorrectAns.SelectedValue.Equals("3")) { newQuestion.setQuizAnswer(answer3); } else { newQuestion.setQuizAnswer(answer4); } allQuestions.Add(newQuestion); QuizDAO quizDAO = new QuizDAO(); QuizAnswerDAO qaDAO = new QuizAnswerDAO(); QuizQuestionDAO qqDAO = new QuizQuestionDAO(); Course_elearnDAO ceDAO = new Course_elearnDAO(); Course_elearn currentCourse = ceDAO.get_course_by_id(Convert.ToInt32(Request.QueryString["id"])); //create quiz List <string> part1 = (List <string>)Session["createQuiz1"]; Quiz newQuiz = new Quiz(); newQuiz.setTitle(part1[0]); newQuiz.setDescription(part1[1]); newQuiz.setMainCourse(currentCourse); newQuiz.setPassingGrade(Convert.ToInt32(txtNumCorrectAns.Text)); newQuiz.setStatus("active"); if (ddlRandomize.SelectedValue.Equals("y")) { newQuiz.setRandomOrder("y"); } else { newQuiz.setRandomOrder("n"); } newQuiz.setTimeLimit(Convert.ToInt32(txtTimeLimit.Text)); if (rdlAttempt.SelectedValue.Equals("unlimited")) { newQuiz.setMultipleAttempts("y"); newQuiz.setNumberOfAttempts(0); } else { newQuiz.setMultipleAttempts("n"); newQuiz.setNumberOfAttempts(Convert.ToInt32(txtNoOfAttempt.Text)); } newQuiz.setDisplayAnswer(ddlDisplayAnswer.SelectedValue); int quizID = quizDAO.createQuiz(newQuiz); //add prerequisites List <int> prereqIDlist = (List <int>)Session["selectedPrereq"]; foreach (int prereqID in prereqIDlist) { quizDAO.insertPrerequisite(quizID, prereqID); } //create question and answer foreach (QuizQuestion question in allQuestions) { question.setQuiz(quizDAO.getQuizByID(quizID)); int questionID = qqDAO.createQuizQuestion(question); QuizQuestion currentQuestion = qqDAO.getQuizQuestionByID(questionID); List <QuizAnswer> allAnswers = question.getAllAnswers(); foreach (QuizAnswer answer in allAnswers) { answer.setQuizQuestion(currentQuestion); int answerID = qaDAO.createQuizAnswer(answer); if (question.getQuizAnswer().getAnswer().Equals(answer.getAnswer())) { qqDAO.updateCorrectAnswerID(questionID, answerID); } } } //set audit User currentUser = (User)Session["currentUser"]; setAudit(currentUser, "quiz", "create", quizID.ToString(), "quiz title: " + newQuiz.getTitle()); Response.Redirect($"quizSummary.aspx?id={quizID}"); } }