/**
* Called When the MainTrainingPage is loaded.
* Generate a question, either from the file system, or from the
* database, and show that to the user. If a question is generated
* it is also saved to the database.
* */
private void load()
{
// Set the welcome label
lbl_welcome.Text = stateManager.getTrainingName() + " for " + stateManager.getUserName();
// Load a question for the current training
loadQuestion();
}
/**
* Sets the initial title of the page
*/
private void setTitle()
{
string title = stateManager.getUserName() + "'s ";
//Usernames [Admin] Dashboard.
if (stateManager.isAdmin())
{
title += "[ADMIN] ";
}
title += " Dashboard ";
this.Text = title;
}
public List <NameValueCollection> getWorstQuestions(StateManager stateManager, int numQuestions)
{
string userName = stateManager.getUserName();
string trainingName = stateManager.getTrainingName();
string queryString = "select user.id AS userID, question.id AS questionID, (user_answers_question.numCorrect*1.0 / user_answers_question.numAttempt*1.0) AS pctCorrect, " +
" numAttempt, numCorrect, numWrong, trainingName, userName, " +
" question.question, correctAnswer, answer1, answer2, answer3, answer4, answer5, answer6, answer7, " +
" answer8, answer9, answer10, answer11, answer12, answer13, answer14, answer15 " +
"from user_answers_question, user, question " +
"WHERE user_answers_question.userID = user.id " +
" AND user_answers_question.questionID = question.id " +
" AND pctCorrect NOT NULL " +
" AND userName = '******' " +
" AND trainingName = '" + trainingName + "' " +
" ORDER BY pctCorrect " +
" LIMIT " + numQuestions + "; ";
return(query(queryString));
}
/* Returns the name of the currently logged in user */
private string getUser()
{
//TODO: Implement actual getUser
return(stateManager.getUserName());
}
