private void generateOldQuestionFromID(string questionID) { string queryString = "SELECT * from question WHERE id = '" + questionID + "';"; NameValueCollection question = dbManager.query(queryString)[0]; string correctAnswer = question["correctAnswer"]; ArrayList answers = new ArrayList(); answers.Add(question["answer1"]); answers.Add(question["answer2"]); answers.Add(question["answer3"]); answers.Add(question["answer4"]); answers.Add(question["answer5"]); answers.Add(question["answer6"]); answers.Add(question["answer7"]); answers.Add(question["answer8"]); answers.Add(question["answer9"]); answers.Add(question["answer10"]); answers.Add(question["answer11"]); answers.Add(question["answer12"]); answers.Add(question["answer13"]); answers.Add(question["answer14"]); answers.Add(question["answer15"]); string image = question["question"]; int correctAnswerPosition = answers.IndexOf(correctAnswer); // Setup the gui with the correct questions and answers. populateQuestionImage(image); populateAnswers(answers, correctAnswerPosition); int totalAttempts = dbManager.getQuestionAttempts(question["id"]); int totalCorrect = dbManager.getQuestionCorrect(question["id"]); int totalWrong = dbManager.getQuestionWrong(question["id"]); int numAttempt = dbManager.getQuestionAttemptsByUser(question["id"], stateManager.getUserID()); int numCorrect = dbManager.getQuestionCorrectByUser(question["id"], stateManager.getUserID()); int numWrong = dbManager.getQuestionWrongByUser(question["id"], stateManager.getUserID()); //increment display labels currentUserTotal.Text = numAttempt.ToString(); currentUserCorrect.Text = numCorrect.ToString(); currentUserWrong.Text = numWrong.ToString(); allUserCorrect.Text = totalCorrect.ToString(); allUserTotal.Text = totalAttempts.ToString(); allUserWrong.Text = totalWrong.ToString(); gb_stats.Text = "Question Statistics for #id: " + question["id"]; stateManager.setQuestionID(int.Parse(question["id"])); dbManager.incrementQuestionDisplay(stateManager.getUserID(), stateManager.getQuestionID()); }
private void Dashboard_Load(object sender, EventArgs e) { setTitle(); setUserInfo(stateManager.getUserID()); }