protected void Page_Load(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
string strDeptID = ck.d_code;
//Redirect Login users to pending page
//redirectToPendingPage();
//string strDeptID = "01001";
string strProjectStatus = ck.pj_status;
//keep project code in cookie for usage in follwing pages
mgCookie.UpdateCookies("pj_status", strProjectStatus);
string strSQL1 = "select * from dbo.department d, dbo.ministry m where d.mi_id = m.mi_id and d.d_code = '" + strDeptID + "'";
SqlDataSource4.SelectCommand = strSQL1;
SqlDataSource4.DataBind();
DataView dv1 = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty);
foreach (DataRow dRow in dv1.Table.Rows)
{
lblDeptCode.Text = dRow["mi_code"].ToString();
lblDeptName.Text = dRow["mi_name"].ToString();
lblDivisionCode.Text = dRow["d_code"].ToString();
lblDivisionName.Text = dRow["d_name"].ToString();
mgCookie.UpdateCookies("mi_id", dRow["mi_id"].ToString());
}
if (!Page.IsPostBack)
{
string strSQL = "SELECT * from dbo.projects where pj_id = " + ck.pj_id;
SqlDataSource2.SelectCommand = strSQL;
SqlDataSource2.DataBind();
DataView dv = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
lblProjectCode.Text = dv.Table.Rows[0]["pj_code"].ToString();
txtProjectName.Text = dv.Table.Rows[0]["pj_name"].ToString();
ddlYudtasad.SelectedValue = dv.Table.Rows[0]["pj_yut_id"].ToString();
ddlYear.SelectedValue = dv.Table.Rows[0]["pj_year"].ToString();
txtBudget.Text = dv.Table.Rows[0]["pj_budget"].ToString();
DropDownList2.SelectedValue = dv.Table.Rows[0]["pj_budget_type"].ToString();
//txtIntegrate.Text = dv.Table.Rows[0]["pj_integrateproject"].ToString();
//txtRelate.Text = dv.Table.Rows[0]["pj_relateDept"].ToString();
}
}
}
protected void btnNextToQ2_2_Click(object sender, EventArgs e)
{
//บันทักข้อมูล แล้วแสดงประเด็นที่ 2
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
int ret = ans.insertOrUpdateAnswerQ2(radanswer2_1.SelectedValue, ck.pj_id, ck.q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
int ret2 = 0;
if (radanswer2_1.SelectedIndex == 0) // ตอบว่า ใช่
{
// คำถามย่อยข้อ 1.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1.Text, ck.pj_id, "1", ret.ToString());
// คำถามย่อยข้อ 1.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_2.Text, ck.pj_id, "2", ret.ToString());
// คำถามย่อยข้อ 1.3
//ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_3.Text, ck.pj_id, "3", ret.ToString());
}
else
{
// คำถามย่อยข้อ 1.1
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "1", ret.ToString());
// คำถามย่อยข้อ 1.2
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "2", ret.ToString());
// คำถามย่อยข้อ 1.3
//ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "3", ret.ToString());
}
mgCookie.UpdateCookies("q1_id", "2"); //ประเด็นที่สอง
mgCookie.UpdateCookies("q2_id", "2");
if (ret2 > 0)
{
//บันทึกสำเร็จ
litfinish.Text = "เสร็จสิ้นการแก้ไขประเมินชุด ค: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ";
litfinish.Visible = true;
btnToQB.Visible = true;
panel1.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["pj_id"] != null)
{
string strPJ_ID = Request.QueryString["pj_id"];
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
mgCookie.UpdateCookies("pj_id", strPJ_ID);
mgCookie.UpdateCookies("qset_id", ans.getLatestAnswerQSetID(strPJ_ID));
mgCookie.UpdateCookies("q2_id", ans.getLatestAnswerQ2(ck.pj_id, ck.qset_id));
if (Request.QueryString["fm"] == "submitted")
{
Response.Redirect("project_summary_submitted.aspx");
}
else if (Request.QueryString["fm"] == "simnotsubmitted" || Request.QueryString["fm"] == "realnotsubmitted")
{
Response.Redirect("project_summary.aspx");
}
else if (Request.QueryString["fm"] == "simnotcomplete" || Request.QueryString["fm"] == "realnotcomplete")
{
projects pj = new projects();
if (pj.redirectToPendingProjectDetails(ck.pj_id).Contains(".aspx"))
{
Response.Redirect(pj.redirectToPendingProjectDetails(ck.pj_id));
}
}
else if (Request.QueryString["fm"] == "notReqApproval")
{
Response.Redirect("project_summary.aspx?fm=notReqApproval");
}
else
{
switch (ck.q2_id)
{
default:
Response.Redirect("project_pickquestion.aspx");
break;
}
}
}
}
protected void btnToQ9_6_Click(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
int ret = ans.insertOrUpdateAnswerQ2(radanswer8_5.SelectedValue, ck.pj_id, "14", "4");
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
int ret2 = 0;
if (radanswer8_5.SelectedIndex == 0) // ตอบว่า ใช่
{
// คำถามย่อยข้อ 8.5
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion8_5_1.Text, ck.pj_id, "28", ret.ToString());
}
else if (radanswer8_5.SelectedIndex == 1)
{
// คำถามย่อยข้อ 8.5
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "28", ret.ToString());
}
if (ret2 > 0)
{
//บันทึกสำเร็จ
Response.Redirect("question_set_D.aspx?q1=3&q2=6");
}
else
{
//บันทึกไม่สำเร็จ
}
}
protected void lbt_proj_name_Click(object sender, EventArgs e)
{
LinkButton lbt_temp = sender as LinkButton;
//option 1 pass with cookies
ManageCookie mgCookie = new ManageCookie();
mgCookie.UpdateCookies("pj_id", lbt_temp.CommandArgument);
// option 2 pass with QueryString. There are problem with '+' in url
//Server.Transfer(Global_config.RootURL + "project_approval_1.aspx" + "?id=" + ton.Encryption.Encrypt(lbt_temp.CommandArgument, ton.Encryption.keyword));
string approval_status = tonUtilities.cleanQueryString(Request.QueryString["status"]);
string prefix = "1";
if (approval_status == "1")
{
prefix = "4";
}
else if ((approval_status == "2") || (approval_status == "3") || (approval_status == "4"))
{
prefix = "5";
}
else
{
prefix = "1";
}
Response.Redirect(Global_config.RootURL + "project_approval_" + prefix + ".aspx" + "?id=" + ton.Encryption.Encrypt(lbt_temp.CommandArgument, ton.Encryption.keyword));
}
protected void btnNext_Click(object sender, EventArgs e)
{
//บันทักข้อมูล
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
int ret = ans.insertOrUpdateAnswerQ2(radQ2.SelectedValue, ck.pj_id, ck.q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
int ret2 = 0;
if (radQ2.SelectedIndex == 0) // ตอบว่า ใช่
{
// คำถามย่อยข้อ 1.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_6.Text, ck.pj_id, "6", ret.ToString());
// คำถามย่อยข้อ 1.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_7.Text, ck.pj_id, "7", ret.ToString());
// คำถามย่อยข้อ 1.3
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_8.Text, ck.pj_id, "8", ret.ToString());
}
else
{
// คำถามย่อยข้อ 1.1
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "6", ret.ToString());
// คำถามย่อยข้อ 1.2
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "7", ret.ToString());
// คำถามย่อยข้อ 1.3
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "8", ret.ToString());
}
if (ret2 > 0)
{
//บันทึกสำเร็จ
//Response.Redirect("project_edit.aspx");
litfinish.Text = "เสร็จสิ้นการแก้ไขประเมินชุด ก: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ";
litfinish.Visible = true;
btnToQB.Visible = true;
panel2.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
}
}
protected void btnToQ8_4_Click(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
int ret = ans.insertOrUpdateAnswerQ2(radanswer7_3.SelectedValue, ck.pj_id, "12", "4");
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
int ret2 = 0;
if (radanswer7_3.SelectedIndex == 0) // ตอบว่า ใช่
{
// คำถามย่อยข้อ 7.3
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion7_3_1.Text, ck.pj_id, "26", ret.ToString());
}
else if (radanswer7_3.SelectedIndex == 1)
{
// คำถามย่อยข้อ 7.3
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "26", ret.ToString());
}
if (ret2 > 0)
{
//บันทึกสำเร็จ
pnl7_1.Visible = false;
pnl7_2.Visible = false;
pnl7_3.Visible = false;
Response.Redirect("question_set_D.aspx?q1=2&q2=4");
//panel1.Visible = false;
//panel2.Visible = true;
//panel3.Visible = false;
//pnl8_4.Visible = true;
//pnl8_5.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
}
}
protected void btnNext_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
else
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
SqlParameter pj_cate = new SqlParameter("@pj_type", SqlDbType.NVarChar, 100);
pj_cate.Direction = ParameterDirection.Input;
pj_cate.Value = radProjectCate.SelectedValue.ToString();
SqlParameter pj_id = new SqlParameter("@pj_id", SqlDbType.Int);
pj_id.Direction = ParameterDirection.Input;
pj_id.Value = ck.pj_id;
insertParameters.Add(pj_cate);
insertParameters.Add(pj_id);
//try
//{
SqlDataSource1.Update();
mgCookie.UpdateCookies("pj_type", this.radProjectCate.SelectedValue);
Response.Redirect("project_pickquestion.aspx?fm=type");
//}
//catch (Exception ex)
//{
// //ELMA Log
// Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
//}
}
}
protected void btnToQ7_3_Click(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
int ret = ans.insertOrUpdateAnswerQ2(radanswer7_1.SelectedValue, ck.pj_id, "11", "4");
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
int ret2 = 0;
if (radanswer7_2.SelectedIndex == 0) // ตอบว่า ใช่
{
// คำถามย่อยข้อ 7.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion7_2_1.Text, ck.pj_id, "25", ret.ToString());
}
else if (radanswer7_2.SelectedIndex == 1)
{
// คำถามย่อยข้อ 7.2
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "25", ret.ToString());
}
if (ret2 > 0)
{
//บันทึกสำเร็จ
pnl7_1.Visible = false;
pnl7_2.Visible = false;
pnl7_3.Visible = true;
}
else
{
//บันทึกไม่สำเร็จ
}
}
protected void btnSaveQL1(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
Button btn_temp = sender as Button;
string arg = btn_temp.CommandArgument;
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
int ret = -1;
int ret2 = 0;
if (ck == null)
{
ton.JavaScript.MessageBox(" ข้อมูลโปรเจค ว่างเปล่า \r\n กรุณาเข้าสู่ระบบ ");
return;
}
if (arg == "3.2.1")
{
//ประเด็น3
#region 3.2.1
ret = ans.insertOrUpdateAnswerQ2(radanswer2_1.SelectedValue, ck.pj_id, qset.qL1_list[0].qL2_list[0].q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
// มี หรือ ไม่มี
if (radanswer2_1.SelectedValue == "มี") // ตอบว่า มี
{
// คำถามย่อยข้อ 1.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1_1.Text, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[0].q3_id, ret.ToString());
// คำถามย่อยข้อ 1.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1_2.Text, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[1].q3_id, ret.ToString());
// คำถามย่อยข้อ 1.3
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1_3.Text, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[2].q3_id, ret.ToString());
}
else
{
// คำถามย่อยข้อ 1.1
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[0].q3_id, ret.ToString());
// คำถามย่อยข้อ 1.2
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[1].q3_id, ret.ToString());
// คำถามย่อยข้อ 1.3
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[0].qL3_list[2].q3_id, ret.ToString());
}
#endregion
if (ret2 > 0)
{
//บันทึกสำเร็จ
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = true;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
ton.JavaScript.MessageBox("บันทึก ประเด็น3 ไม่สำเร็จ");
}
}
else if (arg == "3.2.2")
{
//ประเด็น3
#region 3.2.2
ret = ans.insertOrUpdateAnswerQ2(radanswer2_2.SelectedValue, ck.pj_id, qset.qL1_list[0].qL2_list[1].q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
if (radanswer2_2.SelectedValue == "มี") // ตอบว่า มี
{
// คำถามย่อยข้อ 2.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_2_1.Text, ck.pj_id, qset.qL1_list[0].qL2_list[1].qL3_list[0].q3_id, ret.ToString());
}
else
{
// คำถามย่อยข้อ 2.1
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[1].qL3_list[0].q3_id, ret.ToString());
}
#endregion
if (ret2 > 0)
{
//บันทึกสำเร็จ
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = true;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
ton.JavaScript.MessageBox("บันทึก ประเด็น3 ไม่สำเร็จ");
}
}
else if (arg == "3.2.3")
{
//ประเด็น3
#region 3.2.3
ret = ans.insertOrUpdateAnswerQ2(radanswer2_3.SelectedValue, ck.pj_id, qset.qL1_list[0].qL2_list[2].q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
if (radanswer2_3.SelectedValue == "มี") // ตอบว่า มี
{
// คำถามย่อยข้อ 3.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_3_1.Text, ck.pj_id, qset.qL1_list[0].qL2_list[2].qL3_list[0].q3_id, ret.ToString());
}
else
{
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[2].qL3_list[0].q3_id, ret.ToString());
}
#endregion
if (ret2 > 0)
{
//บันทึกสำเร็จ
pnlQL1_3.Visible = true;
// nested panel inside pnlql1_3
//--only 1st question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = true;
//-----end nested panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
ton.JavaScript.MessageBox("บันทึก ประเด็น3 ไม่สำเร็จ");
}
}
else if (arg == "3.2.4")
{
//ประเด็น3
#region 3.2.4
ret = ans.insertOrUpdateAnswerQ2(radanswer2_4.SelectedValue, ck.pj_id, qset.qL1_list[0].qL2_list[3].q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
if (radanswer2_4.SelectedValue == "มี")
{
// คำถามย่อยข้อ 4.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_1.Text, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[0].q3_id, ret.ToString());
// คำถามย่อยข้อ 4.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_2.Text, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[1].q3_id, ret.ToString());
// คำถามย่อยข้อ 4.3
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_3.Text, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[2].q3_id, ret.ToString());
// คำถามย่อยข้อ 4.4
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_4.Text, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[3].q3_id, ret.ToString());
}
else
{
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[0].q3_id, ret.ToString());
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[1].q3_id, ret.ToString());
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[2].q3_id, ret.ToString());
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[0].qL2_list[3].qL3_list[3].q3_id, ret.ToString());
}
#endregion
if (ret2 > 0)
{
//บันทึกสำเร็จ
pnlQL1_3.Visible = false;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = true;
pnlQL1_5.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
ton.JavaScript.MessageBox("บันทึก ประเด็น3 ไม่สำเร็จ");
}
}
else if (arg == "4")
{
//ประเด็น4
ret = ans.insertOrUpdateAnswerQ2(radanswer2_5_1.SelectedValue, ck.pj_id, qset.qL1_list[1].qL2_list[0].q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
// มี หรือ ไม่มี
if ((radanswer2_5_1.SelectedValue == "มี") || (radanswer2_5_1.SelectedValue == "มีบางส่วน")) // ตอบว่า มี
{
// คำถามย่อยข้อ 5.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4_1_1.Text, ck.pj_id, qset.qL1_list[1].qL2_list[0].qL3_list[0].q3_id, ret.ToString());
}
else
{
// คำถามย่อยข้อ 5.1
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[1].qL2_list[0].qL3_list[0].q3_id, ret.ToString());
}
if (ret2 > 0)
{
//บันทึกสำเร็จ
pnlQL1_3.Visible = false;
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = true;
}
else
{
//บันทึกไม่สำเร็จ
ton.JavaScript.MessageBox("บันทึก ประเด็น4 ไม่สำเร็จ");
}
}
else if (arg == "5")
{
//ประเด็น5
ret = ans.insertOrUpdateAnswerQ2(radanswer2_6_1.SelectedValue, ck.pj_id, qset.qL1_list[2].qL2_list[0].q2_id, ck.qset_id);
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
// มี หรือ ไม่มี
if (radanswer2_6_1.SelectedValue == "มี") // ตอบว่า มี
{
// คำถามย่อยข้อ 6.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_5_1_1.Text, ck.pj_id, qset.qL1_list[2].qL2_list[0].qL3_list[0].q3_id, ret.ToString());
// คำถามย่อยข้อ 6.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_5_1_2.Text, ck.pj_id, qset.qL1_list[2].qL2_list[0].qL3_list[1].q3_id, ret.ToString());
}
else
{
// คำถามย่อยข้อ 6.1
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[2].qL2_list[0].qL3_list[0].q3_id, ret.ToString());
// คำถามย่อยข้อ 6.2
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, qset.qL1_list[2].qL2_list[0].qL3_list[1].q3_id, ret.ToString());
}
if (ret2 > 0)
{
//บันทึกสำเร็จ
litfinish.Text = "เสร็จสิ้นการแก้ไขประเมิน" + qset.qset_text;
litfinish.Visible = true;
btnToQB.Visible = true;
pnlQL1_3.Visible = false;
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else
{
//บันทึกไม่สำเร็จ
ton.JavaScript.MessageBox("บันทึก ประเด็น5 ไม่สำเร็จ");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
string max = "";
if (ck != null)
{
answer ans = new answer();
max = ans.getLatestAnswerQ2(ck.pj_id, ans.getLatestAnswerQSetID(ck.pj_id));
string strSQL1 = string.Format(@"select * from question1 q1, question2 q2, question3 q3
where q1.qset_id = 3 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id;");
SqlDataSource1.SelectCommand = strSQL1;
SqlDataSource1.DataBind();
DataView dv1 = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
//ประเด็นที่หนึ่ง
lblQuestion1.Text = "ประเด็นที่ " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_text"].ToString();
lblAssumption.Text = "สมมุติฐาน " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_assumption"].ToString();
lblQuestion2_1.Text = "คำถามที่ " + dv1.Table.Rows[0]["q2_order"].ToString() + " " + dv1.Table.Rows[0]["q2_text"].ToString();
lblQuestion3_1.Text = dv1.Table.Rows[0]["q3_order"].ToString() + " " + dv1.Table.Rows[0]["q3_text"].ToString();
lblQuestion3_2.Text = dv1.Table.Rows[1]["q3_order"].ToString() + " " + dv1.Table.Rows[1]["q3_text"].ToString();
//lblQuestion3_3.Text = dv1.Table.Rows[2]["q3_order"].ToString() + " " + dv1.Table.Rows[2]["q3_text"].ToString();
mgCookie.UpdateCookies("qset_id", "3"); //คำถามชุด ค.
#region ต้น
string strQ2ID = max;
//ton.JavaScript.MessageBox(strQ2ID);
if (strQ2ID != null)
{
if (strQ2ID == "8")
{
panel1.Visible = true;
litfinish.Visible = false;
btnToQB.Visible = false;
}
else if (strQ2ID == "9")
{
panel1.Visible = false;
litfinish.Text = "เสร็จสิ้นการประเมินชุด ค: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ";
litfinish.Visible = true;
btnToQB.Visible = true;
}
else
{
panel1.Visible = false;
litfinish.Visible = false;
btnToQB.Visible = false;
}
}
#endregion
if (panel1.Visible == true)
{
mgCookie.UpdateCookies("q1_id", "3"); //ประเด็นที่หนึ่ง
mgCookie.UpdateCookies("q2_id", dv1.Table.Rows[0]["q2_id"].ToString());
}
}
else
{
Response.Redirect(ton.config.Global_config.RootURL);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (!Page.IsPostBack)
{
if (ck != null)
{
//ประเด็นที่หนึ่ง คำถาม
string strSQL1 = "select * from question1 q1, question2 q2, question3 q3 where q1.qset_id = 1 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id and q1.q1_id = 1";
SqlDataSource1.SelectCommand = strSQL1;
SqlDataSource1.DataBind();
DataView dv1 = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
lblQuestion1.Text = "ประเด็นที่ " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_text"].ToString();
lblAssumption.Text = "สมมุติฐาน " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_assumption"].ToString();
lblQuestion2_1.Text = "คำถามที่ " + dv1.Table.Rows[0]["q2_order"].ToString() + " " + dv1.Table.Rows[0]["q2_text"].ToString();
lblQuestion3_1.Text = dv1.Table.Rows[0]["q3_order"].ToString() + " " + dv1.Table.Rows[0]["q3_text"].ToString();
lblQuestion3_2.Text = dv1.Table.Rows[1]["q3_order"].ToString() + " " + dv1.Table.Rows[1]["q3_text"].ToString();
lblQuestion3_3.Text = dv1.Table.Rows[2]["q3_order"].ToString() + " " + dv1.Table.Rows[2]["q3_text"].ToString();
lblQuestion3_4.Text = dv1.Table.Rows[3]["q3_order"].ToString() + " " + dv1.Table.Rows[3]["q3_text"].ToString();
lblQuestion3_5.Text = dv1.Table.Rows[4]["q3_order"].ToString() + " " + dv1.Table.Rows[4]["q3_text"].ToString();
//ประเด็นที่หนึ่ง คำตอบ
strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = 1 and "
+ "q2.pj_id = " + ck.pj_id + " and "
+ "q2.q2_id = 1 and "
+ "q2.answer_q2_id = q3.answer_q2_id";
SqlDataSource1.SelectCommand = strSQL1;
SqlDataSource1.DataBind();
dv1 = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
if (dv1.Table.Rows[0]["answer_q2_text"].ToString() == "มี" ||
dv1.Table.Rows[0]["answer_q2_text"].ToString() == "ใช่")
{
radanswer2_1.SelectedIndex = 0;
}
else
{
radanswer2_1.SelectedIndex = 1;
}
txtAnswerQuestion3_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
txtAnswerQuestion3_2.Text = dv1.Table.Rows[1]["answer_q3_text"].ToString();
txtAnswerQuestion3_3.Text = dv1.Table.Rows[2]["answer_q3_text"].ToString();
txtAnswerQuestion3_4.Text = dv1.Table.Rows[3]["answer_q3_text"].ToString();
txtAnswerQuestion3_5.Text = dv1.Table.Rows[4]["answer_q3_text"].ToString();
//ประเด็นที่สอง คำถาม
string strSQL2 = "select * from question1 q1, question2 q2, question3 q3 where q1.qset_id = 1 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id and q1.q1_id = 2";
SqlDataSource2.SelectCommand = strSQL2;
SqlDataSource2.DataBind();
DataView dv2 = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
lblQuestion2.Text = "ประเด็นที่ " + dv2.Table.Rows[0]["q1_order"].ToString() + " " + dv2.Table.Rows[0]["q1_text"].ToString();
lblAssumption2.Text = "สมมุติฐาน " + dv2.Table.Rows[0]["q1_order"].ToString() + " " + dv2.Table.Rows[0]["q1_assumption"].ToString();
lblQuestion2_2.Text = "คำถามที่ " + dv2.Table.Rows[0]["q2_order"].ToString() + " " + dv2.Table.Rows[0]["q2_text"].ToString();
lblQuestion3_6.Text = dv2.Table.Rows[0]["q3_order"].ToString() + " " + dv2.Table.Rows[0]["q3_text"].ToString();
lblQuestion3_7.Text = dv2.Table.Rows[1]["q3_order"].ToString() + " " + dv2.Table.Rows[1]["q3_text"].ToString();
lblQuestion3_8.Text = dv2.Table.Rows[2]["q3_order"].ToString() + " " + dv2.Table.Rows[2]["q3_text"].ToString();
//ประเด็นที่สอง คำตอบ
strSQL2 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = 1 and "
+ "q2.pj_id = " + ck.pj_id + " and "
+ "q2.q2_id = 2 and "
+ "q2.answer_q2_id = q3.answer_q2_id";
SqlDataSource2.SelectCommand = strSQL2;
SqlDataSource2.DataBind();
dv2 = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
radQ2.SelectedValue = dv2.Table.Rows[0]["answer_q2_text"].ToString();
txtAnswerQuestion3_6.Text = dv2.Table.Rows[0]["answer_q3_text"].ToString();
txtAnswerQuestion3_7.Text = dv2.Table.Rows[1]["answer_q3_text"].ToString();
txtAnswerQuestion3_8.Text = dv2.Table.Rows[2]["answer_q3_text"].ToString();
mgCookie.UpdateCookies("qset_id", "1"); //คำถามชุด ก.
if (panel1.Visible == true)
{
mgCookie.UpdateCookies("q1_id", "1"); //ประเด็นที่หนึ่ง
mgCookie.UpdateCookies("q2_id", dv1.Table.Rows[0]["q2_id"].ToString());
}
else if (panel2.Visible == true)
{
mgCookie.UpdateCookies("q1_id", "2"); //ประเด็นที่สอง
mgCookie.UpdateCookies("q2_id", dv2.Table.Rows[0]["q2_id"].ToString());
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
String strPJid = Request.QueryString["pjid"];
//Add by Itsada Jitchot 2014/04/30 เนื่องจากในการออกรายงานต้องการ pj_id ที่กดมาจากลิ้ง
mgCookie.UpdateCookies("pj_id", strPJid);
StringBuilder strSQL = new StringBuilder();
strSQL.Append("select d.d_code, d.d_name, m.mi_code, m.mi_name, p.pj_code, p.d_id, p.pj_name, y.yut_name, p.pj_year, p.pj_budget, pj_integrateProject, pj_relateDept, pj_background, pj_urgency, pj_type, pj_complete_status ");
strSQL.Append(" from projects p, department d, ministry m, yutasad y");
strSQL.Append(" where p.d_id = d.d_id and p.mi_id = m.mi_id and p.pj_yut_id = y.yut_id and p.pj_id = '" + strPJid + "'");
SqlDataSource4.SelectCommand = strSQL.ToString();
SqlDataSource4.DataBind();
DataView dv1 = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty);
foreach (DataRow dRow in dv1.Table.Rows)
{
lblDeptCode.Text = dRow["mi_code"].ToString();
lblDeptName.Text = dRow["mi_name"].ToString();
lblDivisionCode.Text = dRow["d_code"].ToString();
lblDivisionName.Text = dRow["d_name"].ToString();
lblProjectName.Text = dRow["pj_name"].ToString();
lblProjectCode.Text = dRow["pj_code"].ToString();
lblYutasard.Text = dRow["yut_name"].ToString();
lblBudget.Text = dRow["pj_budget"].ToString();
lblYear.Text = dRow["pj_year"].ToString();
}
gUtilities gt = new gUtilities();
if (dv1.Table.Rows[0]["pj_complete_status"].ToString() == "ไม่อยู่ในเกณฑ์การประเมิน/กรอกสมบูรณ์")
{
linkreport2.Visible = false;
linkreport3.Visible = false;
litHeader.Text = " โครงการกรอกสมบูรณ์ที่ไม่อยู่ในข่ายที่ต้องวิเคราะห์ความเสี่ยง";
litRisk1.Text = "-";
litRisk2.Text = "-";
}
else
{
linkreport2.Visible = true;
linkreport3.Visible = true;
litHeader.Text = "โครงการที่เข้าข่ายการวิเคราะห์ความเสี่ยงตามหลักธรรมาภิบาล";
litRisk1.Text = gt.getReportTammaTotal(ck.pj_id);
litRisk2.Text = gt.getReportFactorRiskTotal(ck.pj_id);
}
}
else
{
//redirect
//Response.Redirect("project_summary.aspx");
}
}
}
protected void btnToSetE_Click(object sender, EventArgs e)
{
//บันทักข้อมูล แล้วแสดงข้อคำถามชุดต่อไปกรณีโครงการต่อเนื่อง หรือ เข้าประเมินปัจจัยถายใน ภายนอก กรณีโครงการใหม่
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
int ret = ans.insertOrUpdateAnswerQ2(radanswer9_6.SelectedValue, ck.pj_id, "15", "4");
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
int ret2 = 0;
if (radanswer9_6.SelectedIndex == 0) // ตอบว่า ใช่
{
// คำถามย่อยข้อ 9.6
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion9_6_1.Text, ck.pj_id, "29", ret.ToString());
}
else if (radanswer9_6.SelectedIndex == 1)
{
// คำถามย่อยข้อ 9.6
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "29", ret.ToString());
}
ret = ans.insertOrUpdateAnswerQ2(radanswer9_6.SelectedValue, ck.pj_id, "15", "4");
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
if (radanswer9_6.SelectedIndex == 0) // ตอบว่า ใช่
{
// คำถามย่อยข้อ 6.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion9_6_2.Text, ck.pj_id, "30", ret.ToString());
}
else if (radanswer9_6.SelectedIndex == 1)
{
// คำถามย่อยข้อ 6.2
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "30", ret.ToString());
}
if (ret2 > 0)
{
//บันทึกสำเร็จ
//บันทักข้อมูล แล้วแสดงข้อคำถามชุดต่อไปกรณีโครงการต่อเนื่อง หรือ เข้าประเมินปัจจัยถายใน ภายนอก กรณีโครงการใหม่
projects pj = new projects();
string pjType = pj.getProjectInfo(ck.pj_id, "pj_type");
if (pjType == "โครงการใหม่")
{
////Response.Redirect("factor_risk.aspx");
//Response.Redirect("project_pickquestion.aspx");
}
else
{
////Response.Redirect("question_set_E.aspx");
//Response.Redirect("project_pickquestion.aspx");
}
// Go To Quest E จ
panel1.Visible = false;
panel2.Visible = false;
panel3.Visible = false;
pnl7_1.Visible = false;
pnl7_2.Visible = false;
pnl7_3.Visible = false;
pnl8_4.Visible = false;
pnl8_5.Visible = false;
pnl9_6.Visible = false;
litfinish.Text = "เสร็จสิ้นการประเมินชุด ง: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ";
pnl_fin.Visible = true;
litfinish.Visible = true;
btnToQB.Visible = true;
}
else
{
//บันทึกไม่สำเร็จ
}
}
protected void btnToSetE_Click(object sender, EventArgs e)
{
//บันทักข้อมูล แล้วแสดงข้อคำถามชุดต่อไปกรณีโครงการต่อเนื่อง หรือ เข้าประเมินปัจจัยถายใน ภายนอก กรณีโครงการใหม่
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
int ret = ans.insertOrUpdateAnswerQ2(radanswer9_6.SelectedValue, ck.pj_id, "15", "4");
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
int ret2 = 0;
if (radanswer9_6.SelectedIndex == 0) // ตอบว่า ใช่
{
// คำถามย่อยข้อ 9.6
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion9_6_1.Text, ck.pj_id, "29", ret.ToString());
}
else if (radanswer9_6.SelectedIndex == 1)
{
// คำถามย่อยข้อ 9.6
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "29", ret.ToString());
}
ret = ans.insertOrUpdateAnswerQ2(radanswer9_6.SelectedValue, ck.pj_id, "15", "4");
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
if (radanswer9_6.SelectedIndex == 0) // ตอบว่า ใช่
{
// คำถามย่อยข้อ 6.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion9_6_2.Text, ck.pj_id, "30", ret.ToString());
}
else if (radanswer9_6.SelectedIndex == 1)
{
// คำถามย่อยข้อ 6.2
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "30", ret.ToString());
}
if (ret2 > 0)
{
//บันทึกสำเร็จ
//บันทักข้อมูล แล้วแสดงข้อคำถามชุดต่อไปกรณีโครงการต่อเนื่อง หรือ เข้าประเมินปัจจัยถายใน ภายนอก กรณีโครงการใหม่
projects pj = new projects();
string pjType = pj.getProjectInfo(ck.pj_id, "pj_type");
if (pjType == "โครงการใหม่")
{
//Response.Redirect("factor_risk.aspx");
Response.Redirect("project_edit.aspx");
}
else
{
//Response.Redirect("question_set_E.aspx");
Response.Redirect("project_edit.aspx");
}
}
else
{
//บันทึกไม่สำเร็จ
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region loadData
qset.qset_id = "2";
qset.loadQuestionSet();
qset.loadQuestionL1();
lbl_qset_text.Text = qset.qset_text;
for (int q1_i = 0; q1_i < qset.qL1_list.Count; q1_i++)
{
question q1 = qset.qL1_list[q1_i];
q1.loadQuestionL2();
for (int q2_i = 0; q2_i < q1.qL2_list.Count; q2_i++)
{
questionL2 q2 = q1.qL2_list[q2_i];
q2.loadQuestionL3();
}
}
#endregion
#region MapQuestion to Interface
//--------------ประเด็น3---------------------------
lblQuestion_1.Text = qset.qL1_list[0].q1_text;
lblAssumption_1.Text = qset.qL1_list[0].q1_assumption;
lblQuestion_id_1.Text = qset.qL1_list[0].q1_id;
lblQuestion_id_praden_1.Text = lblQuestion_id_1.Text;
//---------------คำถาม----------------------------
lblQuestion2_1.Text = Q2Seq + qset.qL1_list[0].qL2_list[0].q2_order + " " + qset.qL1_list[0].qL2_list[0].q2_text;
//--------------คำถามย่อย--------------------------------
lblQuestion3_1_1.Text = qset.qL1_list[0].qL2_list[0].qL3_list[0].q3_order + " " + qset.qL1_list[0].qL2_list[0].qL3_list[0].q3_text;
lblQuestion3_1_2.Text = qset.qL1_list[0].qL2_list[0].qL3_list[1].q3_order + " " + qset.qL1_list[0].qL2_list[0].qL3_list[1].q3_text;
lblQuestion3_1_3.Text = qset.qL1_list[0].qL2_list[0].qL3_list[2].q3_order + " " + qset.qL1_list[0].qL2_list[0].qL3_list[2].q3_text;
//---------------คำถาม----------------------------
lblQuestion2_2.Text = Q2Seq + qset.qL1_list[0].qL2_list[1].q2_order + " " + qset.qL1_list[0].qL2_list[1].q2_text;
//--------------คำถามย่อย--------------------------------
lblQuestion3_2_1.Text = qset.qL1_list[0].qL2_list[1].qL3_list[0].q3_order + " " + qset.qL1_list[0].qL2_list[1].qL3_list[0].q3_text;
//---------------คำถาม----------------------------
lblQuestion2_3.Text = Q2Seq + qset.qL1_list[0].qL2_list[2].q2_order + " " + qset.qL1_list[0].qL2_list[2].q2_text;
//--------------คำถามย่อย--------------------------------
lblQuestion3_3_1.Text = qset.qL1_list[0].qL2_list[2].qL3_list[0].q3_order + " " + qset.qL1_list[0].qL2_list[2].qL3_list[0].q3_text;
//---------------คำถาม----------------------------
lblQuestion2_4.Text = Q2Seq + qset.qL1_list[0].qL2_list[3].q2_order + " " + qset.qL1_list[0].qL2_list[3].q2_text;
//--------------คำถามย่อย--------------------------------
lblQuestion3_4_1.Text = qset.qL1_list[0].qL2_list[3].qL3_list[0].q3_order + " " + qset.qL1_list[0].qL2_list[3].qL3_list[0].q3_text;
lblQuestion3_4_2.Text = qset.qL1_list[0].qL2_list[3].qL3_list[1].q3_order + " " + qset.qL1_list[0].qL2_list[3].qL3_list[1].q3_text;
lblQuestion3_4_3.Text = qset.qL1_list[0].qL2_list[3].qL3_list[2].q3_order + " " + qset.qL1_list[0].qL2_list[3].qL3_list[2].q3_text;
lblQuestion3_4_4.Text = qset.qL1_list[0].qL2_list[3].qL3_list[3].q3_order + " " + qset.qL1_list[0].qL2_list[3].qL3_list[3].q3_text;
//-----------จบ ประเด็น3--------------------------------
//--------------ประเด็น4---------------------------
lblQuestion_2.Text = qset.qL1_list[1].q1_text;
lblAssumption_2.Text = qset.qL1_list[1].q1_assumption;
lblQuestion_id_2.Text = qset.qL1_list[1].q1_id;
lblQuestion_id_praden_2.Text = lblQuestion_id_2.Text;
lblQuestion2_5_1.Text = Q2Seq + qset.qL1_list[1].qL2_list[0].q2_order + " " + qset.qL1_list[1].qL2_list[0].q2_text;
lblQuestion3_4_1_1.Text = qset.qL1_list[1].qL2_list[0].qL3_list[0].q3_order + " " + qset.qL1_list[1].qL2_list[0].qL3_list[0].q3_text;
//-----------จบ ประเด็น4--------------------------------
//--------------ประเด็น5---------------------------
lblQuestion_3.Text = qset.qL1_list[2].q1_text;
lblAssumption_3.Text = qset.qL1_list[2].q1_assumption;
lblQuestion_id_3.Text = qset.qL1_list[2].q1_id;
lblQuestion_id_praden_3.Text = lblQuestion_id_3.Text;
lblQuestion2_6_1.Text = Q2Seq + qset.qL1_list[2].qL2_list[0].q2_order + " " + qset.qL1_list[2].qL2_list[0].q2_text;
lblQuestion3_5_1_1.Text = qset.qL1_list[2].qL2_list[0].qL3_list[0].q3_order + " " + qset.qL1_list[2].qL2_list[0].qL3_list[0].q3_text;
lblQuestion3_5_1_2.Text = qset.qL1_list[2].qL2_list[0].qL3_list[1].q3_order + " " + qset.qL1_list[2].qL2_list[0].qL3_list[1].q3_text;
//-----------จบ ประเด็น5--------------------------------
#endregion
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
string max = "";
if (ck != null)
{
mgCookie.UpdateCookies("qset_id", qset.qset_id); //คำถามชุด ข.
answer ans = new answer();
max = ans.getLatestAnswerQ2(ck.pj_id, ans.getLatestAnswerQSetID(ck.pj_id));
//if (pnlQL1_3.Visible == true)
//{
// //ประเด็น 3
// mgCookie.UpdateCookies("q1_id", qset.qL1_list[0].q1_id);
// mgCookie.UpdateCookies("q2_id", qset.qL1_list[0].qL2_list[0].q2_id);
//}
//else if (pnlQL1_4.Visible == true)
//{
// //ประเด็นที่ 4
// mgCookie.UpdateCookies("q1_id", qset.qL1_list[1].q1_id);
// mgCookie.UpdateCookies("q2_id", qset.qL1_list[1].qL2_list[0].q2_id);
//}
//else if (pnlQL1_5.Visible == true)
//{
// //ประเด็นที่ 5
// mgCookie.UpdateCookies("q1_id", qset.qL1_list[2].q1_id);
// mgCookie.UpdateCookies("q2_id", qset.qL1_list[2].qL2_list[0].q2_id);
//}
}
else
{
Response.Redirect(ton.config.Global_config.RootURL);
}
//ไม่ใช่
if ((!Page.IsPostBack) && (ck != null))
{
//-------get latest------
string strQ2ID = max;
//ton.JavaScript.MessageBox(strQ2ID);
if (strQ2ID != null)
{
if (strQ2ID == "2")
{
// Origin Q2_1
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = true;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "3")
{
// Next is Q2_2
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = true;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "4")
{
// Next is Q2_3
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = true;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "5")
{
// Next is Q2_4
pnlQL1_3.Visible = true;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = true;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "6")
{
// Next is Q2_5
pnlQL1_3.Visible = false;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = true;
pnlQL1_5.Visible = false;
}
else if (strQ2ID == "7")
{
// Next is Q2_6
pnlQL1_3.Visible = false;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = true;
}
else if (strQ2ID == "8")
{
// Next is QSet C ค.
litfinish.Text = "เสร็จสิ้นการแก้ไขประเมิน" + qset.qset_text;
litfinish.Visible = true;
btnToQB.Visible = true;
pnlQL1_3.Visible = false;
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
else
{
// Origin Q2_1
pnlQL1_3.Visible = false;
// Nested Panel inside pnlQL1_3
//--Only 1st Question visible
pnlQL2_1.Visible = false;
pnlQL2_2.Visible = false;
pnlQL2_3.Visible = false;
pnlQL2_4.Visible = false;
//-----End Nested Panel -----
pnlQL1_4.Visible = false;
pnlQL1_5.Visible = false;
}
}
//------------------
/*
#region LoadData_from_DB
* // Load and Map DB Data For Edit Mode only
* string strSQL1 = "";
* SqlCommand cmd = new SqlCommand();
* DataView dv1 = new DataView();
* // Load and Map Data from DB to interface
* //คำตอบ
* // ประเด็นที่ 3
#region คำตอบ คำถามที่ 1
* strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[0].qL2_list[0].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+
+ radanswer2_1.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_1_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_1_2.Text = dv1.Table.Rows[1]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_1_3.Text = dv1.Table.Rows[2]["answer_q3_text"].ToString();
#endregion
+
#region คำตอบ คำถามที่ 2
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[0].qL2_list[1].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_2.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_2_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
#endregion
+
#region คำตอบ คำถามที่ 3
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[0].qL2_list[2].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_3.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_3_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
#endregion
+
#region คำตอบ คำถามที่ 4
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[0].qL2_list[3].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_4.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_4_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_4_2.Text = dv1.Table.Rows[1]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_4_3.Text = dv1.Table.Rows[2]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_4_4.Text = dv1.Table.Rows[3]["answer_q3_text"].ToString();
#endregion
+
+ //ประเด็นที่ 4
#region คำตอบ คำถามที่ 5
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[1].qL2_list[0].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_5_1.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_4_1_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
#endregion
+
+ //ประเด็นที่ 5
#region คำตอบ คำถามที่ 6
+ strSQL1 = "select * from dbo.answer_q2 q2, answer_q3 q3 "
+ " where q2.qset_id = @qset_id and "
+ "q2.pj_id = @pj_id and "
+ "q2.q2_id = @q2_id and "
+ "q2.answer_q2_id = q3.answer_q2_id";
+
+ cmd = new SqlCommand(strSQL1);
+ cmd.Parameters.AddWithValue("@qset_id", qset.qset_id);
+ cmd.Parameters.AddWithValue("@pj_id", ck.pj_id);
+ cmd.Parameters.AddWithValue("@q2_id", qset.qL1_list[2].qL2_list[0].q2_id);
+
+
+ dv1 = ton.Data.DBHelper.getDataSet(cmd).Tables[0].DefaultView;
+
+ radanswer2_6_1.SelectedValue = dv1.Table.Rows[0]["answer_q2_text"].ToString();
+ txtAnswerQuestion3_5_1_1.Text = dv1.Table.Rows[0]["answer_q3_text"].ToString();
+ txtAnswerQuestion3_5_1_2.Text = dv1.Table.Rows[1]["answer_q3_text"].ToString();
+
#endregion
#endregion
*/
}
// set cookies to keep the lastest question Set , Q2
#region set cookies follow to visible panel
#region ไม่ใช้
//if (pnlQL1_3.Visible == true)
//{
// mgCookie.UpdateCookies("q1_id", "3"); //ประเด็นที่สาม
// if (pnlQL2_1.Visible == true)
// {
// mgCookie.UpdateCookies("q2_id", "3"); //คำถามที่1 , IDคำถามเริ่มที่3
// }
// else if (pnlQL2_2.Visible == true)
// {
// mgCookie.UpdateCookies("q2_id", "4"); //คำถามที่2
// }
// else if (pnlQL2_3.Visible == true)
// {
// mgCookie.UpdateCookies("q2_id", "5"); //คำถามที่3
// }
// else if (pnlQL2_4.Visible == true)
// {
// mgCookie.UpdateCookies("q2_id", "6"); //คำถามที่3
// }
//}
//else if (pnlQL1_4.Visible == true)
//{
// mgCookie.UpdateCookies("q1_id", "4"); //ประเด็นที่สี่
// mgCookie.UpdateCookies("q2_id", "7"); //คำถามที่ห้า
//}
//else if (pnlQL1_5.Visible == true)
//{
// mgCookie.UpdateCookies("q1_id", "5"); //ประเด็นที่ห้า
// mgCookie.UpdateCookies("q2_id", "8"); //คำถามที่หก
//}
#endregion
#endregion
//----------------------------------------
//คำถามที่ 1
if (radanswer2_1.SelectedValue == "มี") // ตอบว่า มี
{
txtAnswerQuestion3_1_1.Enabled = txtAnswerQuestion3_1_2.Enabled = txtAnswerQuestion3_1_3.Enabled = true;
reqvld_3_1_1.Enabled = reqvld_3_1_2.Enabled = reqvld_3_1_3.Enabled = true;
}
else
{
txtAnswerQuestion3_1_1.Enabled = txtAnswerQuestion3_1_2.Enabled = txtAnswerQuestion3_1_3.Enabled = false;
reqvld_3_1_1.Enabled = reqvld_3_1_2.Enabled = reqvld_3_1_3.Enabled = false;
}
//คำถามที่ 2
if (radanswer2_2.SelectedValue == "มี") // ตอบว่า มี
{
txtAnswerQuestion3_2_1.Enabled = true;
reqvld_3_2_1.Enabled = true;
}
else
{
txtAnswerQuestion3_2_1.Enabled = false;
reqvld_3_2_1.Enabled = false;
}
//คำถามที่ 3
if (radanswer2_3.SelectedValue == "มี") // ตอบว่า มี
{
txtAnswerQuestion3_3_1.Enabled = true;
reqvld_3_3_1.Enabled = true;
}
else
{
txtAnswerQuestion3_3_1.Enabled = false;
reqvld_3_3_1.Enabled = false;
}
//คำถามที่ 4
if (radanswer2_4.SelectedValue == "มี") // ตอบว่า มี
{
txtAnswerQuestion3_4_1.Enabled = txtAnswerQuestion3_4_2.Enabled = txtAnswerQuestion3_4_3.Enabled = txtAnswerQuestion3_4_4.Enabled = true;
reqvld_3_4_1.Enabled = reqvld_3_4_2.Enabled = reqvld_3_4_3.Enabled = reqvld_3_4_4.Enabled = true;
}
else
{
txtAnswerQuestion3_4_1.Enabled = txtAnswerQuestion3_4_2.Enabled = txtAnswerQuestion3_4_3.Enabled = txtAnswerQuestion3_4_4.Enabled = false;
reqvld_3_4_1.Enabled = reqvld_3_4_2.Enabled = reqvld_3_4_3.Enabled = reqvld_3_4_4.Enabled = false;
}
//คำถามที่ 5
if ((radanswer2_5_1.SelectedValue == "มี") || (radanswer2_5_1.SelectedValue == "มีบางส่วน")) // ตอบว่า มี หรือ มีบางส่วน
{
txtAnswerQuestion3_4_1_1.Enabled = true;
reqvld3_4_1_1.Enabled = true;
}
else
{
txtAnswerQuestion3_4_1_1.Enabled = false;
reqvld3_4_1_1.Enabled = false;
}
//คำถามที่ 6
if (radanswer2_6_1.SelectedValue == "มี") // ตอบว่า มี หรือ มีบางส่วน
{
txtAnswerQuestion3_5_1_1.Enabled = txtAnswerQuestion3_5_1_2.Enabled = true;
reqvld_3_5_1_1.Enabled = reqvld_3_5_1_2.Enabled = true;
}
else
{
txtAnswerQuestion3_5_1_1.Enabled = txtAnswerQuestion3_5_1_2.Enabled = false;
reqvld_3_5_1_1.Enabled = reqvld_3_5_1_2.Enabled = false;
}
}
protected void btnNextToQ2_2_Click(object sender, EventArgs e)
{
//บันทักข้อมูล แล้วแสดงประเด็นที่ 2
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
int ret = ans.insertOrUpdateAnswerQ2(radanswer2_1.SelectedValue, ck.pj_id, "1", "1");
mgCookie.UpdateCookies("answer_q2_id", ret.ToString());
int ret2 = 0;
if (radanswer2_1.SelectedIndex == 0) // ตอบว่า ใช่
{
// คำถามย่อยข้อ 1.1
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_1.Text, ck.pj_id, "1", ret.ToString());
// คำถามย่อยข้อ 1.2
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_2.Text, ck.pj_id, "2", ret.ToString());
// คำถามย่อยข้อ 1.3
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_3.Text, ck.pj_id, "3", ret.ToString());
// คำถามย่อยข้อ 1.4
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_4.Text, ck.pj_id, "4", ret.ToString());
// คำถามย่อยข้อ 1.5
ret2 = ans.insertOrUpdateAnswerQ3(txtAnswerQuestion3_5.Text, ck.pj_id, "5", ret.ToString());
}
else
{
// คำถามย่อยข้อ 1.1
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "1", ret.ToString());
// คำถามย่อยข้อ 1.2
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "2", ret.ToString());
// คำถามย่อยข้อ 1.3
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "3", ret.ToString());
// คำถามย่อยข้อ 1.4
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "4", ret.ToString());
// คำถามย่อยข้อ 1.5
ret2 = ans.insertOrUpdateAnswerQ3(string.Empty, ck.pj_id, "5", ret.ToString());
}
if (ret2 > 0)
{
//บันทึกสำเร็จ
panel1.Visible = false;
panel2.Visible = true;
}
else
{
//บันทึกไม่สำเร็จ
}
}
protected void Page_Load(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
string max = "";
if (ck != null)
{
string strSQL1 = "select * from question1 q1, question2 q2, question3 q3 where q1.qset_id = 1 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id and q1.q1_id = 1";
SqlDataSource1.SelectCommand = strSQL1;
SqlDataSource1.DataBind();
DataView dv1 = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
//ประเด็นที่หนึ่ง
lblQuestion1.Text = "ประเด็นที่ " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_text"].ToString();
lblAssumption.Text = "สมมุติฐาน " + dv1.Table.Rows[0]["q1_order"].ToString() + " " + dv1.Table.Rows[0]["q1_assumption"].ToString();
lblQuestion2_1.Text = "คำถามที่ " + dv1.Table.Rows[0]["q2_order"].ToString() + " " + dv1.Table.Rows[0]["q2_text"].ToString();
lblQuestion3_1.Text = dv1.Table.Rows[0]["q3_order"].ToString() + " " + dv1.Table.Rows[0]["q3_text"].ToString();
lblQuestion3_2.Text = dv1.Table.Rows[1]["q3_order"].ToString() + " " + dv1.Table.Rows[1]["q3_text"].ToString();
lblQuestion3_3.Text = dv1.Table.Rows[2]["q3_order"].ToString() + " " + dv1.Table.Rows[2]["q3_text"].ToString();
lblQuestion3_4.Text = dv1.Table.Rows[3]["q3_order"].ToString() + " " + dv1.Table.Rows[3]["q3_text"].ToString();
lblQuestion3_5.Text = dv1.Table.Rows[4]["q3_order"].ToString() + " " + dv1.Table.Rows[4]["q3_text"].ToString();
//ประเด็นที่สอง
string strSQL2 = "select * from question1 q1, question2 q2, question3 q3 where q1.qset_id = 1 and q1.q1_id = q2.q1_id and q2.q2_id = q3.q2_id and q1.q1_id = 2";
SqlDataSource2.SelectCommand = strSQL2;
SqlDataSource2.DataBind();
DataView dv2 = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
lblQuestion2.Text = "ประเด็นที่ " + dv2.Table.Rows[0]["q1_order"].ToString() + " " + dv2.Table.Rows[0]["q1_text"].ToString();
lblAssumption2.Text = "สมมุติฐาน " + dv2.Table.Rows[0]["q1_order"].ToString() + " " + dv2.Table.Rows[0]["q1_assumption"].ToString();
lblQuestion2_2.Text = "คำถามที่ " + dv2.Table.Rows[0]["q2_order"].ToString() + " " + dv2.Table.Rows[0]["q2_text"].ToString();
lblQuestion3_6.Text = dv2.Table.Rows[0]["q3_order"].ToString() + " " + dv2.Table.Rows[0]["q3_text"].ToString();
lblQuestion3_7.Text = dv2.Table.Rows[1]["q3_order"].ToString() + " " + dv2.Table.Rows[1]["q3_text"].ToString();
lblQuestion3_8.Text = dv2.Table.Rows[2]["q3_order"].ToString() + " " + dv2.Table.Rows[2]["q3_text"].ToString();
mgCookie.UpdateCookies("qset_id", "1"); //คำถามชุด ก.
if (!Page.IsPostBack)
{
// ต้น comment
//string strQ2ID = ck.q2_id;
#region ต้น
answer ans = new answer();
max = ans.getLatestAnswerQ2(ck.pj_id, ans.getLatestAnswerQSetID(ck.pj_id));
string strQ2ID = string.IsNullOrEmpty(max) ? "0" : max;
#endregion
if (strQ2ID != null)
{
// ค่า max ที่ได้คือข้อล่าสุดที่ได้ทำไป ดังนั้นข้อต่อไปคือ max + 1
if (strQ2ID == "0")
{
panel1.Visible = true;
panel2.Visible = false;
}
else if (strQ2ID == "1")
{
panel1.Visible = false;
panel2.Visible = true;
}
else if (strQ2ID == "2")
{
litfinish.Text = "เสร็จสิ้นการประเมินชุด ก: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ";
litfinish.Visible = true;
btnToQB.Visible = true;
panel1.Visible = false;
panel2.Visible = false;
}
else
{
litfinish.Visible = false;
btnToQB.Visible = false;
panel1.Visible = false;
panel2.Visible = false;
}
}
}
if (panel1.Visible == true)
{
mgCookie.UpdateCookies("q1_id", "1"); //ประเด็นที่หนึ่ง
//mgCookie.UpdateCookies("q2_id", dv1.Table.Rows[0]["q2_id"].ToString());
mgCookie.UpdateCookies("q2_id", "1");
}
else if (panel2.Visible == true)
{
mgCookie.UpdateCookies("q1_id", "2"); //ประเด็นที่สอง
//mgCookie.UpdateCookies("q2_id", dv2.Table.Rows[0]["q2_id"].ToString());
mgCookie.UpdateCookies("q2_id", "2");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
string strDeptID = ck.d_code;
//Redirect Login users to pending page
//redirectToPendingPage();
//string strDeptID = "01001";
string strProjectStatus = Request.QueryString["status"];
//keep project code in cookie for usage in follwing pages
mgCookie.UpdateCookies("pj_status", strProjectStatus);
string strSQL1 = "select * from dbo.department d, dbo.ministry m where d.mi_id = m.mi_id and d.d_code = '" + strDeptID + "'";
SqlDataSource4.SelectCommand = strSQL1;
SqlDataSource4.DataBind();
DataView dv1 = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty);
foreach (DataRow dRow in dv1.Table.Rows)
{
lblDeptCode.Text = dRow["mi_code"].ToString();
lblDeptName.Text = dRow["mi_name"].ToString();
lblDivisionCode.Text = dRow["d_code"].ToString();
lblDivisionName.Text = dRow["d_name"].ToString();
mgCookie.UpdateCookies("mi_id", dRow["mi_id"].ToString());
mgCookie.UpdateCookies("d_id", dRow["d_id"].ToString());
}
if (!Page.IsPostBack)
{
string strSQL = string.Empty;
strSQL = "SELECT pj_code from dbo.projects where d_id = " + strDeptID + " and pj_isinuse = 1 and pj_status = '" + strProjectStatus + "' and p_id = " + ck.p_id + " and mi_id is null and pj_name is null and pj_yut_id is null and pj_year is null";
SqlDataSource2.SelectCommand = strSQL;
SqlDataSource2.DataBind();
DataView dv = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
if (dv.Count > 0)
{
strSQL = "SELECT max(cast(substring(pj_code, 7, 3) as int)) from dbo.projects where d_id = " + strDeptID + " and pj_isinuse = 1 and pj_status = '" + strProjectStatus + "' and p_id = " + ck.p_id + " and mi_id is null and pj_name is null and pj_yut_id is null and pj_year is null";
}
else
{
strSQL = "SELECT max(cast(substring(pj_code, 7, 3) as int)) + 1 from dbo.projects where d_id = " + strDeptID + " and pj_isinuse = 1 and pj_status = '" + strProjectStatus + "'";
}
SqlDataSource2.SelectCommand = strSQL;
SqlDataSource2.DataBind();
dv = (DataView)SqlDataSource2.Select(DataSourceSelectArguments.Empty);
if (dv.Count > 0)
{
foreach (DataRow dRow in dv.Table.Rows)
{
if (dRow[0] != null && dRow[0].ToString() != string.Empty)
{
if (dRow[0].ToString().Length == 1)
{
lblProjectCode.Text = strDeptID + "-00" + dRow[0].ToString();
}
else if (dRow[0].ToString().Length == 2)
{
lblProjectCode.Text = strDeptID + "-0" + dRow[0].ToString();
}
else
{
lblProjectCode.Text = strDeptID + "-" + dRow[0].ToString();
}
}
else
{
lblProjectCode.Text = strDeptID + "-" + "001";
}
}
mgCookie.UpdateCookies("pj_code", lblProjectCode.Text);
string strUID = ck.p_id;
/**************************************************************************************************
* insert projects table by setting projects.p_isinuse = 1,
* this is to avoid conflict when creating more than 1 project at the same time by multiple users
**************************************************************************************************/
SqlParameter pj_code = new SqlParameter("@pj_code", SqlDbType.NVarChar, 15);
pj_code.Direction = ParameterDirection.Input;
pj_code.Value = lblProjectCode.Text;
SqlParameter p_id = new SqlParameter("@p_id", SqlDbType.Int);
p_id.Direction = ParameterDirection.Input;
p_id.Value = ck.p_id;
SqlParameter pj_status = new SqlParameter("@pj_status", SqlDbType.NVarChar);
pj_status.Direction = ParameterDirection.Input;
pj_status.Value = strProjectStatus;
SqlParameter d_id = new SqlParameter("@d_id", SqlDbType.NVarChar);
d_id.Direction = ParameterDirection.Input;
d_id.Value = strDeptID;
insertParameters.Add(pj_code);
insertParameters.Add(p_id);
insertParameters.Add(pj_status);
insertParameters.Add(d_id);
try
{
//not insert when the existing record does not have input
string strSQL11 = "select pj_id from projects where pj_code = '" + lblProjectCode.Text + "' and pj_status = '" + Request.QueryString["status"] + "'";
SqlDataSource7.SelectCommand = strSQL11;
SqlDataSource7.DataBind();
DataView dv7 = (DataView)SqlDataSource7.Select(DataSourceSelectArguments.Empty);
if (dv7.Table.Rows.Count == 0)
{
SqlDataSource3.Insert();
}
else
{
mgCookie.UpdateCookies("pj_id", dv7.Table.Rows[0]["pj_id"].ToString());
}
}
catch (Exception ex)
{
//Elmah
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
}
}
}
}
protected void btnNext_Click(object sender, EventArgs e)
{
//save project code to cookie
if (!Page.IsValid)
{
return;
}
else
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
// update to database
SqlParameter p_id = new SqlParameter("@p_id", SqlDbType.Int);
p_id.Direction = ParameterDirection.Input;
p_id.Value = ck.p_id;
SqlParameter d_id = new SqlParameter("@d_id", SqlDbType.NVarChar, 20);
d_id.Direction = ParameterDirection.Input;
d_id.Value = ck.d_code;
SqlParameter mi_id = new SqlParameter("@mi_id", SqlDbType.NVarChar, 25);
mi_id.Direction = ParameterDirection.Input;
mi_id.Value = ck.mi_id;
SqlParameter pj_name = new SqlParameter("@pj_name", SqlDbType.NVarChar, 500);
pj_name.Direction = ParameterDirection.Input;
pj_name.Value = txtProjectName.Text;
SqlParameter pj_yut_id = new SqlParameter("@pj_yut_id", SqlDbType.Int);
pj_yut_id.Direction = ParameterDirection.Input;
pj_yut_id.Value = ddlYudtasad.SelectedValue;
SqlParameter pj_year = new SqlParameter("@pj_year", SqlDbType.NVarChar, 4);
pj_year.Direction = ParameterDirection.Input;
pj_year.Value = ddlYear.SelectedValue;
SqlParameter pj_budget = new SqlParameter("@pj_budget", SqlDbType.NVarChar, 50);
pj_budget.Direction = ParameterDirection.Input;
pj_budget.Value = txtBudget.Text;
SqlParameter pj_budget_money = new SqlParameter("@pj_budget_money", SqlDbType.Float);
pj_budget_money.Direction = ParameterDirection.Input;
pj_budget_money.Value = txtBudget.Text.Replace(",", "");
SqlParameter pj_budget_category = new SqlParameter("@pj_budget_category", SqlDbType.NVarChar, 200);
pj_budget_category.Direction = ParameterDirection.Input;
pj_budget_category.Value = DropDownList2.SelectedValue;
SqlParameter pj_id = new SqlParameter("@pj_id", SqlDbType.Int);
pj_id.Direction = ParameterDirection.Input;
pj_id.Value = ck.pj_id;
//SqlParameter pj_integrateProject = new SqlParameter("@pj_integrateProject", SqlDbType.NVarChar);
//pj_integrateProject.Direction = ParameterDirection.Input;
//pj_integrateProject.Value = txtIntegrate.Text;
//SqlParameter pj_relateDept = new SqlParameter("@pj_relateDept", SqlDbType.NVarChar);
//pj_relateDept.Direction = ParameterDirection.Input;
//pj_relateDept.Value = txtRelate.Text;
insertParameters.Add(p_id);
insertParameters.Add(d_id);
insertParameters.Add(mi_id);
insertParameters.Add(pj_name);
insertParameters.Add(pj_yut_id);
insertParameters.Add(pj_year);
insertParameters.Add(pj_budget);
insertParameters.Add(pj_budget_money);
insertParameters.Add(pj_id);
insertParameters.Add(pj_budget_category);
//insertParameters.Add(pj_integrateProject);
//insertParameters.Add(pj_relateDept);
try
{
SqlDataSource44.Update();
//keep project code in cookie for usage in follwing pages
mgCookie.UpdateCookies("pj_code", lblProjectCode.Text);
}
catch (Exception ex)
{
//ELMA Log
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
//Response.Redirect("project_filter_edit.aspx");
Response.Redirect("project_edit.aspx");
}
}
protected void btnNext_Click(object sender, EventArgs e)
{
//save project code to cookie
if (!Page.IsValid)
{
return;
}
else
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
// update to database
SqlParameter pj_code = new SqlParameter("@pj_code", SqlDbType.NVarChar, 15);
pj_code.Direction = ParameterDirection.Input;
pj_code.Value = lblProjectCode.Text;
SqlParameter p_id = new SqlParameter("@p_id", SqlDbType.Int);
p_id.Direction = ParameterDirection.Input;
p_id.Value = ck.p_id;
SqlParameter d_id = new SqlParameter("@d_id", SqlDbType.NVarChar, 20);
d_id.Direction = ParameterDirection.Input;
d_id.Value = ck.d_id;
SqlParameter mi_id = new SqlParameter("@mi_id", SqlDbType.NVarChar, 25);
mi_id.Direction = ParameterDirection.Input;
mi_id.Value = ck.mi_id;
SqlParameter pj_name = new SqlParameter("@pj_name", SqlDbType.NVarChar, 500);
pj_name.Direction = ParameterDirection.Input;
pj_name.Value = txtProjectName.Text;
SqlParameter pj_yut_id = new SqlParameter("@pj_yut_id", SqlDbType.Int);
pj_yut_id.Direction = ParameterDirection.Input;
pj_yut_id.Value = ddlYudtasad.SelectedValue;
SqlParameter pj_year = new SqlParameter("@pj_year", SqlDbType.NVarChar, 4);
pj_year.Direction = ParameterDirection.Input;
pj_year.Value = ddlYear.SelectedValue;
SqlParameter pj_budget_money = new SqlParameter("@pj_budget_money", SqlDbType.Float);
pj_budget_money.Direction = ParameterDirection.Input;
pj_budget_money.Value = txtBudget.Text.Replace(",", "");
SqlParameter pj_budget = new SqlParameter("@pj_budget", SqlDbType.NVarChar, 50);
pj_budget.Direction = ParameterDirection.Input;
pj_budget.Value = txtBudget.Text;
SqlParameter pj_budget_category = new SqlParameter("@pj_budget_category", SqlDbType.NVarChar, 200);
pj_budget_category.Direction = ParameterDirection.Input;
pj_budget_category.Value = DropDownList2.SelectedValue;
//SqlParameter pj_integrateProject = new SqlParameter("@pj_integrateProject", SqlDbType.NVarChar);
//pj_integrateProject.Direction = ParameterDirection.Input;
////pj_integrateProject.Value = txtIntegrate.Text;
//pj_integrateProject.Value = string.Empty;
//SqlParameter pj_relateDept = new SqlParameter("@pj_relateDept", SqlDbType.NVarChar);
//pj_relateDept.Direction = ParameterDirection.Input;
////pj_relateDept.Value = txtRelate.Text;
//pj_relateDept.Value = string.Empty;
SqlParameter pj_status = new SqlParameter("@pj_status", SqlDbType.NVarChar);
pj_status.Direction = ParameterDirection.Input;
pj_status.Value = Request.QueryString["status"];
insertParameters.Add(pj_code);
insertParameters.Add(p_id);
insertParameters.Add(d_id);
insertParameters.Add(mi_id);
insertParameters.Add(pj_name);
insertParameters.Add(pj_yut_id);
insertParameters.Add(pj_year);
insertParameters.Add(pj_budget);
insertParameters.Add(pj_budget_money);
//insertParameters.Add(pj_integrateProject);
//insertParameters.Add(pj_relateDept);
insertParameters.Add(pj_status);
insertParameters.Add(pj_budget_category);
try
{
SqlDataSource44.Update();
//keep project code in cookie for usage in follwing pages
mgCookie.UpdateCookies("pj_code", lblProjectCode.Text);
}
catch (Exception ex)
{
//ELMA Log
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
SqlDataSource6.SelectCommand = "SELECT pj_id FROM [projects] where pj_code = '" + lblProjectCode.Text + "' and pj_status = '" + Request.QueryString["status"] + "'";
SqlDataSource6.DataBind();
DataView dv1 = (DataView)SqlDataSource6.Select(DataSourceSelectArguments.Empty);
//keep project code in cookie for usage in follwing pages
mgCookie.UpdateCookies("pj_id", dv1.Table.Rows[0]["pj_id"].ToString());
Response.Redirect("project_filter.aspx");
}
}
