/** * 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; }