/**
* Saves a question to the database, returns the questions id
*/
public int saveQuestion(string question, string correctAnswer, ArrayList allAnswers, StateManager stateManager, QA_TYPE questionType)
{
// check if allAnswers is shorter than 15, if it is, we'll fill it in with blanks
while (allAnswers.Count < 15)
{
allAnswers.Add("");
}
string tquery = "INSERT INTO question (question, correctAnswer, answer1, answer2, answer3, answer4, answer5, answer6, " +
"answer7, answer8, answer9, answer10, answer11, answer12, answer13, answer14," +
"answer15, trainingName ) VALUES('" + question + "', '" + correctAnswer + "', '" +
allAnswers[0] + "', '" + allAnswers[1] + "', '" + allAnswers[2] + "', '" +
allAnswers[3] + "', '" + allAnswers[4] + "', '" + allAnswers[5] + "', '" +
allAnswers[6] + "', '" + allAnswers[7] + "', '" + allAnswers[8] + "', '" +
allAnswers[9] + "', '" + allAnswers[10] + "', '" + allAnswers[11] + "', '" +
allAnswers[12] + "', '" + allAnswers[13] + "', '" + allAnswers[14] + "', '" +
stateManager.getTrainingName() + "');";
insert(tquery);
tquery = "SELECT * from question where question = '" + question + "' AND answer12 = '" + allAnswers[11] + "'; ";
List <NameValueCollection> idList = query(tquery);
return(int.Parse(idList[0]["id"]));
}
/**
* Constructor
*/
public LoginPage(DataBaseManager dbManager, StateManager stateManager)
{
InitializeComponent();
this.dbManager = dbManager;
this.stateManager = stateManager;
}
