public bool SaveQuestionnaire(QuestionnairePara para, DbTrans trans, string UserID) {
bool ret = false;
QuestionnaireLinq lnq = new QuestionnaireLinq();
if (para.ID != 0)
lnq.GetDataByPK(para.ID, trans.Trans);
lnq.QUESTIONNAIRE_NAME = para.QUESTIONNAIRE_NAME;
lnq.OBJECTIVE = para.OBJECTIVE;
lnq.DESCRIPTION = para.DESCRIPTION;
lnq.ACTIVE = para.ACTIVE;
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_id = lnq.ID;
return ret;
}
private bool SaveQuestionnaire(DbTrans trans)
{
bool ret = false;
QuestionnairePara para = new QuestionnairePara();
para.ID = Convert.ToInt64(txtID.Text);
para.QUESTIONNAIRE_NAME = txtQuestionnaireName.Text.Trim();
para.OBJECTIVE = txtObjective.Text.Trim();
para.DESCRIPTION = txtDesc.Text.Trim();
para.ACTIVE = (chkActive.Checked ? 'Y' : 'N');
QuestionnaireENG eng = new QuestionnaireENG();
if (eng.SaveQuestionnaire(para, trans, Config.GetUserName()) == true)
{
ret = true;
txtID.Text = eng.QUESTIONNAIRE_ID.ToString();
}
else
{
ret = false;
_err = eng.ErrorMessage;
}
return ret;
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
DbTrans trans = new DbTrans();
trans.CreateTransaction();
DataTable dt;
//dt.Columns.Add("id");
//dt.Columns.Add("section_name");
//for (int i = 0; i <= 5; i++) {
// DataRow dr = dt.NewRow();
// dr["id"] = (i+1);
// dr["section_name"] = "ส่วนที่ " + (i+1) + " กกกกกกกกกกกกกกกกกกก";
// dt.Rows.Add(dr);
//}
if (Request["id"] != null)
{
QuestionnaireENG eng = new QuestionnaireENG();
QuestionnairePara para = new QuestionnairePara();
para = eng.GetQuestionnarePara(Convert.ToInt64(Request["id"]), trans);
txtID.Text = para.ID.ToString();
lblQusitionnaireName.Text = para.QUESTIONNAIRE_NAME;
lblQuestionnaireObjective.Text = para.OBJECTIVE;
lblQuestionnaireDesc.Text = para.DESCRIPTION;
dt = eng.GetQuestionnaireSectionList(Convert.ToInt64(Request["id"]), trans);
gvSection.DataSource = dt;
gvSection.DataBind();
trans.CommitTransaction();
}
}
}
