protected void btnAddQuestion_Click(object sender, EventArgs e)
{
DbTrans trans = new DbTrans();
trans.CreateTransaction();
if (ValidQuestion() == true) {
if (SaveQuestionnaire(trans) == true){
QuestionnaireQuestionsPara para = new QuestionnaireQuestionsPara();
para.ID = Convert.ToInt64(txtQuestionID.Text);
para.QUESTIONNAIRE_SECTION_ID = Convert.ToInt64(cmbSectionID.SelectedValue);
para.QUESTION_NAME = txtQuestionName.Text.Trim();
para.CHOICE_TYPE_ID = Convert.ToInt64(cmbChoiceTypeID.SelectedValue);
para.QUESTION_POINT = Convert.ToDouble(txtPoint.Text.Trim());
para.IS_REQUIRE = (chkRequire.Checked ? 'Y' : 'N');
QuestionnaireENG eng = new QuestionnaireENG();
bool ret = eng.SaveQuestion(para, trans, Config.GetUserName());
if (ret == true)
{
if (SaveQuestionChoice(eng.QUESTION_ID, trans) == true)
{
trans.CommitTransaction();
txtQuestionID.Text = eng.QUESTION_ID.ToString();
SetQuestionnaireForm(Convert.ToInt64(txtID.Text));
ClearQuestionForm();
Config.SetAlert("บันทึกข้อมูลเรียบร้อย", this);
}
else {
trans.RollbackTransaction();
Config.SetAlert(eng.ErrorMessage, this);
}
}
else {
trans.RollbackTransaction();
Config.SetAlert(eng.ErrorMessage, this);
}
}
}
}
public bool SaveQuestion(QuestionnaireQuestionsPara para, DbTrans trans, string UserID) {
bool ret = false;
QuestionnaireQuestionsLinq lnq = new QuestionnaireQuestionsLinq();
if (para.ID != 0)
lnq.GetDataByPK(para.ID, trans.Trans);
lnq.QUESTIONNAIRE_SECTION_ID = para.QUESTIONNAIRE_SECTION_ID;
lnq.QUESTION_NAME = para.QUESTION_NAME;
lnq.CHOICE_TYPE_ID = para.CHOICE_TYPE_ID;
lnq.QUESTION_POINT = para.QUESTION_POINT;
lnq.IS_REQUIRE = para.IS_REQUIRE;
if (lnq.ID != 0)
ret = lnq.UpdateByPK(UserID, trans.Trans);
else
ret = lnq.InsertData(UserID, trans.Trans);
if (ret == false)
_err = lnq.ErrorMessage;
else
_question_id = lnq.ID;
return ret;
}
