private void SetCombo()
{
DbTrans trans = new DbTrans();
trans.CreateTransaction();
QuestionnaireENG eng = new QuestionnaireENG();
DataTable dt = eng.GetQuestionnaireSectionList(Convert.ToInt64(txtID.Text), trans);
if (dt.Rows.Count > 0) {
cmbSectionID.SetItemList(dt, "section_name", "id");
}
DataTable dtC = eng.GetChoiceTypeList(trans);
if (dtC.Rows.Count > 0) {
cmbChoiceTypeID.SetItemList(dtC, "choice_type_name", "id");
}
trans.CommitTransaction();
}
private void SetSectionList()
{
if (txtID.Text != "0")
{
DbTrans trans = new DbTrans();
trans.CreateTransaction();
QuestionnaireENG eng = new QuestionnaireENG();
DataTable dt = eng.GetQuestionnaireSectionList(Convert.ToInt64(txtID.Text), trans);
if (dt.Rows.Count > 0) {
gvQuestionnaireSection.DataSource = dt;
gvQuestionnaireSection.DataBind();
}
trans.CommitTransaction();
}
}
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();
}
}
}
