protected void btnAddSection_Click(object sender, EventArgs e)
{
DbTrans trans = new DbTrans();
trans.CreateTransaction();
if (ValidSection() == true)
{
if (SaveQuestionnaire(trans) == true) {
QuestionnaireSectionPara para = new QuestionnaireSectionPara();
para.ID = Convert.ToInt64(txtQuestionSectionID.Text);
para.QUESTIONNAIRE_ID = Convert.ToInt64(txtID.Text);
para.SECTION_NAME = txtSectionName.Text.Trim();
para.DESCRIPTION = txtSectionDesc.Text.Trim();
para.SECTION_TYPE_ID = Convert.ToInt64(cmbSectionTypeID.SelectedValue);
para.CHOICE_QTY = (txtChoiceQty.Text.Trim()=="" ? 0 : Convert.ToInt64(txtChoiceQty.Text));
QuestionnaireENG eng = new QuestionnaireENG();
bool ret = eng.SaveQuestionnaireSection(para, trans, Config.GetUserName());
if (ret == true)
{
trans.CommitTransaction();
txtQuestionSectionID.Text = eng.QUESTIONNAIRE_SECTION_ID.ToString();
SetQuestionnaireForm(Convert.ToInt64(txtID.Text));
SetSectionList();
Config.SetAlert("บันทึกข้อมูลเรียบร้อย", this);
}
else
{
trans.RollbackTransaction();
Config.SetAlert(eng.ErrorMessage, this);
}
}
}
}
public bool SaveQuestionnaireSection(QuestionnaireSectionPara para, DbTrans trans, string UserID) {
bool ret = false;
QuestionnaireSectionLinq lnq = new QuestionnaireSectionLinq();
if (para.ID != 0)
lnq.GetDataByPK(para.ID, trans.Trans);
lnq.QUESTIONNAIRE_ID = para.QUESTIONNAIRE_ID;
lnq.SECTION_NAME = para.SECTION_NAME;
lnq.DESCRIPTION = para.DESCRIPTION;
lnq.SECTION_TYPE_ID = para.SECTION_TYPE_ID;
lnq.CHOICE_QTY = para.CHOICE_QTY;
if (lnq.ID != 0)
ret = lnq.UpdateByPK(UserID, trans.Trans);
else
ret = lnq.InsertData(UserID, trans.Trans);
if (ret == false)
_err = lnq.ErrorMessage;
else
_questionnaire_section_id = lnq.ID;
return ret;
}
