private void cmdSave_Click(object sender, EventArgs e) { _formQuestion.ExecuteNonQuery("DELETE FROM question_insurance_companies WHERE question_id = " + _formQuestion.id); if (clbInsuranceCompanies.GetItemChecked(0)) { // Do nothing! } else { foreach (company selectedCompany in clbInsuranceCompanies.CheckedItems) { _formQuestion.ExecuteNonQuery("INSERT INTO question_insurance_companies (question_id, insurance_id) VALUES " + "(" + _formQuestion.id + ", " + selectedCompany.id + ")"); } } Close(); }
private void ForceAnswerReorder() { int i = 0; _formQuestion.ExecuteNonQuery("UPDATE multiple_choice_answers SET order_id = order_id + " + "1000 WHERE question_id = " + _formQuestion.id); foreach (multiple_choice_answer anAnswer in lstAnswerList.Items) { // Have to save this manually because order_id is part of primary key >< anAnswer.ExecuteNonQuery("UPDATE multiple_choice_answers SET order_id = " + i + " WHERE order_id = (" + anAnswer.order_id + " + 1000) AND question_id = " + anAnswer.question_id); anAnswer.order_id = i; i++; } }