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++;
}
}
