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 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_category", 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();
Response.Redirect("project_type.aspx");
}
catch
{
//ELMA Log
}
}
}
protected void ddlDept_SelectedIndexChanged(object sender, EventArgs e)
{
var mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
var strSql = new StringBuilder();
strSql.Append("select pj_id, pj_code, d_id, pj_name, pj_year, pj_budget, pj_complete_status, pj_category, ");
strSql.Append(" pj_approval_status, pj_lastupdate from projects ");
strSql.Append(" where pj_status = 'real' and pj_complete_status = N'ไม่อยู่ในเกณฑ์การประเมิน/กรอกสมบูรณ์' and ");
strSql.Append(" d_id = " + ddlDept.SelectedValue);
SqlDataSource4.SelectCommand = strSql.ToString();
SqlDataSource4.DataBind();
GridView1.DataSource = SqlDataSource4;
GridView1.DataBind();
var dtView = (DataView)SqlDataSource4.Select(new DataSourceSelectArguments());
var listt = (from t in dtView.Table.AsEnumerable()
group t by t.Field <string>("pj_year") into g
orderby g.Key
select new
{
pj_year = g.Key,
});
ddlProjectYear.DataSource = listt;
ddlProjectYear.DataBind();
ddlProjectYear.Items.Insert(0, new ListItem("[ทุกปีงบประมาณ]", String.Empty));
ddlProjectYear.SelectedIndex = 0;
}
}
protected void Page_Load(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
string strDocNo = Request.QueryString["docno"];
string strDate = Request.QueryString["datedoc"];
projects pj = new projects();
string strDocNumber = pj.getProjectInfo(ck.pj_id, "pj_doc_number");
if (strDocNumber != string.Empty || strDocNumber.ToLower() != "null")
{
pj.updateDocNo_DocDate(ck.pj_id, strDocNo, strDate);
}
string strStatus = pj.getProjectInfo(ck.pj_id, "pj_complete_status");
if (strStatus != "ส่งผลแล้ว")
{
pj.updateProjectCompleteStatus(ck.pj_id, "ส่งผลแล้ว");
pj.updateReport_Submitted(ck.pj_id, ck.p_id);
//gUtilities gt = new gUtilities();
//gt.setFactorImpact(ck.pj_id); //ทำข้อมูลเพื่อแสดงสรุปผลการวิเคราะห์ควาทเสี่ยงภายใน ภายนอก
}
}
}
protected void btnEditProject_Click(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
projects pj = new projects();
string strStatus = pj.getProjectInfo(ck.pj_id, "pj_complete_status");
if (strStatus == "ไม่อยู่ในเกณฑ์การประเมิน/กรอกสมบูรณ์")
{
linkreport2.Visible = false;
linkreport3.Visible = false;
btnEditProject.Visible = false;
//btnSubmitProject.Visible = false;
pnlsubmit.Visible = false;
}
else if (strStatus != "ส่งผลแล้ว" && strStatus != "ไม่อยู่ในเกณฑ์การประเมิน/กรอกสมบูรณ์")
{
//ยังไม่ส่งผล และ เป็นโครงการที่ต้องทำการประเมินความเสี่ยง
Response.Redirect("project_edit.aspx");
}
else
{
linkreport2.Visible = true;
linkreport3.Visible = true;
btnEditProject.Visible = true;
//btnSubmitProject.Visible = true;
pnlsubmit.Visible = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
String strPJid = ck.pj_id;
string strPjType = string.Empty;
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");
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();
//lblIntegrateProject.Text = dRow["pj_integrateProject"].ToString();
//lblRelateDept.Text = dRow["pj_relateDept"].ToString();
lblBudget.Text = dRow["pj_budget"].ToString();
lblYear.Text = dRow["pj_year"].ToString();
strPjType = dRow["pj_type"].ToString();
}
if (strPjType.Trim() == "โครงการใหม่")
{
linkQuestionE.Visible = false;
}
else if (strPjType.Trim() == "โครงการต่อเนื่องหรือโครงการขยายผล")
{
linkQuestionE.Visible = true;
}
else
{
Response.Redirect("default.aspx");
}
}
else
{
//redirect to login page
Response.Redirect("default.aspx");
}
}
}
protected void dgProject_OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
gUtilities gutil = new gUtilities();
double dbTotal = gutil.getReportQSETTotal(ck.p_id);
if (dbTotal > 70)
{
e.Row.Cells[4].Text = "ต่ำ";
}
else if (dbTotal <= 70 && dbTotal > 30)
{
e.Row.Cells[4].Text = "กลาง";
}
else
{
e.Row.Cells[4].Text = "สูง";
}
//if ((e.Row.Cells[5].Text == "ใช่" && e.Row.Cells[6].Text == "ใช่" && e.Row.Cells[7].Text == "ใช่") || e.Row.Cells[8].Text == "ใช่")
//{
// e.Row.Cells[4].Text = "อยู่ในเกณฑ์การประเมิน";
//}
//else
//{
// e.Row.Cells[4].Text = "ไม่อยู่ในเกณฑ์การประเมิน";
//}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
String strPJid = ck.pj_id;
//String strPJCode = "01001-100";
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_category");
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();
lblIntegrateProject.Text = dRow["pj_integrateProject"].ToString();
lblRelateDept.Text = dRow["pj_relateDept"].ToString();
lblBudget.Text = dRow["pj_budget"].ToString();
lblYear.Text = dRow["pj_year"].ToString();
if (dRow["pj_category"].ToString() != string.Empty)
{
if (dRow["pj_category"].ToString() == "บริหารทั่วไป")
{
radProjectCate.SelectedIndex = 0;
}
else if (dRow["pj_category"].ToString() == "บริหารสังคม")
{
radProjectCate.SelectedIndex = 1;
}
else if (dRow["pj_category"].ToString() == "เศรษฐกิจ")
{
radProjectCate.SelectedIndex = 2;
}
}
}
}
else
{
//redirect to login page
}
}
}
protected void btnNext_Click(object sender, EventArgs e)
{
//บันทักข้อมูล
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
answer ans = new answer();
}
protected void Page_Load(object sender, EventArgs e)
{
ton.tonUtilities.pageaAuthorize(ton.config.Global_config.authtext_mangeuser, ton.config.Global_config.warning_text);
var mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
user_role_id.Value = ck.p_role_id;
}
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 Page_Load(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
projects pj = new projects();
dgProject.DataSource = pj.getProject_Not_Require_Approval(ck.p_id);
dgProject.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
projects pj = new projects();
dgProject.DataSource = pj.getProjectInfoAll_Real_notSubmitted(ck.p_id);
dgProject.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
string strPJCode = ck.pj_code;
string strPJStatus = ck.pj_status;
string strPJ_ID = ck.pj_id;
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_filter_q1, pj_filter_q2, pj_filter_q3, pj_filter_q4 ");
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 = " + strPJ_ID);
SqlDataSource4.SelectCommand = strSQL.ToString();
SqlDataSource4.DataBind();
DataView dv1 = (DataView)SqlDataSource4.Select(DataSourceSelectArguments.Empty);
if (dv1.Table.Rows.Count > 0)
{
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();
lblIntegrateProject.Text = dRow["pj_integrateProject"].ToString();
lblRelateDept.Text = dRow["pj_relateDept"].ToString();
lblBudget.Text = dRow["pj_budget"].ToString();
lblYear.Text = dRow["pj_year"].ToString();
radQ1.SelectedValue = dRow["pj_filter_q1"].ToString();
radQ2.SelectedValue = dRow["pj_filter_q2"].ToString();
}
}
else
{
//cannot display project details, redirect to login page
}
}
else
{
//cannot find user login cookie, redirect to login page
}
}
}
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 btn_save_fm_Click(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (String.IsNullOrEmpty(ck.pj_id))
{
ton.JavaScript.MessageBox(" โปรเจค ID ว่างเปล่า กรุณาเข้าสู่ระบบอีกครั้ง ");
return;
}
Button btn_tmep = sender as Button;
Control c = btn_tmep.Parent;
Page.Validate("error_panel_" + btn_tmep.CommandArgument);
if (!Page.IsValid)
{
return;
}
if (btn_tmep.CommandName == "save")
{
int panel_index = Convert.ToInt32(btn_tmep.CommandArgument);
string suffix = panel_index.ToString() + "_";
int sum = 0;
int total = fm[panel_index - 1];
for (int i = 1; i <= total; i++)
{
string final_suffix = suffix + i.ToString();
answer_factors_sub ans_fact_sub = new answer_factors_sub();
ans_fact_sub.af_opportunity = (c.FindControl("ddl_oppo_" + final_suffix) as DropDownList).SelectedValue;
ans_fact_sub.af_effect = (c.FindControl("ddl_effect_" + final_suffix) as DropDownList).SelectedValue;
ans_fact_sub.af_impact = (c.FindControl("ddl_impact_" + final_suffix) as DropDownList).SelectedValue;
ans_fact_sub.factors_sub_etc = (c.FindControl("txt_fs_factors_etc_" + panel_index) as TextBox).Text;
ans_fact_sub.description_more = (c.FindControl("txt_desc_more_text_" + panel_index) as TextBox).Text;
ans_fact_sub.fs_id = (c.FindControl("lbl_fs_id_" + final_suffix) as Label).Text;
ans_fact_sub.pj_id = ck.pj_id;
int result = ans_fact_sub.saveToTable();
if (result > 0)
{
sum++;
}
}
if (c is Panel)
{
Panel pnl_temp = c as Panel;
pnl_temp.Enabled = false;
btn_tmep.Visible = false;
btn_next.Visible = true;
}
ton.JavaScript.MessageBox("บันทึก สำเร็จ " + sum + " จาก " + total + " ข้อ ");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
String strPJid = ck.pj_id;
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();
//lblIntegrateProject.Text = dRow["pj_integrateProject"].ToString();
//lblRelateDept.Text = dRow["pj_relateDept"].ToString();
lblBudget.Text = dRow["pj_budget"].ToString();
lblYear.Text = dRow["pj_year"].ToString();
}
gUtilities gt = new gUtilities();
litRisk1.Text = gt.getReportTammaTotal(ck.pj_id);
litRisk2.Text = gt.getReportFactorRiskTotal(ck.pj_id);
// litRisk12.Text = gt.getReportTammaMainTotal(ck.pj_id);
// litRisk13.Text = gt.getReportTammaSubTotal(ck.pj_id);
if (dv1.Table.Rows[0]["pj_complete_status"].ToString() == null)
{
Response.Redirect("project_summary.aspx");
}
}
else
{
//redirect
Response.Redirect("project_summary.aspx");
}
}
}
protected void lkbLogout_Click(object sender, EventArgs e)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
int retVal = gUtilities.Logout(ck);
if (retVal == 0)
{
Response.Redirect("default.aspx");
}
}
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 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)
//{
// //บันทึกสำเร็จ
// litfinish.Text = "เสร็จสิ้นการประเมินชุด ค: ขั้นตอนการริเริ่มแผนงาน/โครงการและวิเคราะห์เบื้องต้น โปรดดำเนินการต่อ";
// litfinish.Visible = true;
// btnToQB.Visible = true;
//}
//else
//{
// //บันทึกไม่สำเร็จ
//}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
String strPJid = ck.pj_id;
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_risk_info, pj_risk_reduction1, pj_risk_reduction2, pj_risk_eval1, pj_risk_eval2, pj_risk_eval3");
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();
//lblIntegrateProject.Text = dRow["pj_integrateProject"].ToString();
//lblRelateDept.Text = dRow["pj_relateDept"].ToString();
lblBudget.Text = dRow["pj_budget"].ToString();
lblYear.Text = dRow["pj_year"].ToString();
txtBackground.Text = dRow["pj_background"].ToString();
txtUrgency.Text = dRow["pj_urgency"].ToString();
//txtRiskInfo.Text = dRow["pj_risk_info"].ToString();
//txtRiskReduction1.Text = dRow["pj_risk_reduction1"].ToString();
//txtRiskReduction2.Text = dRow["pj_risk_reduction2"].ToString();
//txtRiskEval1.Text = dRow["pj_risk_eval1"].ToString();
//txtRiskEval2.Text = dRow["pj_risk_eval2"].ToString();
//txtRiskEval3.Text = dRow["pj_risk_eval3"].ToString();
}
}
else
{
//redirect to login page
}
}
}
protected void btn_register_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
//force role to get rolesub
ddl_rolesub.DataBind();
string amomo = ddl_rolesub.SelectedValue;
//try
{
int exist = 0;
DataView dv = (DataView)sds_register_staff_persons.Select(DataSourceSelectArguments.Empty);
if (dv.Table != null)
{
exist = dv.Table.Rows.Count;
}
// Check for Existing User ( ID Card No. )
if (exist > 0)
{
// mode แก้ไข
if ((ck != null) && (!string.IsNullOrEmpty(ck.p_id)) && allowEditbyRole())
{
if (save_persons_detail(ck.p_id))
{
ton.JavaScript.MessageBox(" -แก้ไขข้อมูลบุคคลสำเร็จ ");
}
else
{
ton.JavaScript.MessageBox(" -แก้ไขข้อมูลบุคคลล้มเหลว ");
}
}
else
{
ton.JavaScript.MessageBox(" -เลขบัตรประชาชนนี้ได้ลงทะเบียนแล้ว \r\n -ไม่สามารถลงทะเบียนซ้ำได้");
}
}
else
{
sds_register_staff_persons.Insert();
}
}
//catch (Exception ex)
{
//ton.JavaScript.MessageBox(ex.Message.ToString());
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck == null)
{
Response.Redirect("default.aspx");
}
person_id = ck.p_id;
bindData();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//check if the user role <> 3, then redirect to login page.
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
if (ck.p_role_id != "3")
{
//Response.Redirect("default.aspx");
}
}
}
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 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 Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
ddlDept.DataSourceID = "SqlDataSource2";
SqlDataSource2.SelectCommand = "select id, d_id, d_name, d_code, mi_id, (d_id + ' - ' + d_name) as depttext from department where mi_id = " + ck.m_id + " order by d_name";
ddlDept.DataBind();
ddlDept.Items.Insert(0, new ListItem("[กรุณาเลือกหน่วยงาน]", String.Empty));
ddlDept.SelectedIndex = 0;
}
}
}
protected void btn_approve_Click(object sender, EventArgs e)
{
if (!Page.IsValid)
{
return;
}
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if ((ck != null) && (ck.pj_id != null))
{
sds_project_approve_final.UpdateParameters["pj_id"].DefaultValue = ck.pj_id;
sds_project_approve_final.UpdateParameters["pj_approval_status"].DefaultValue = radlist_parliament.SelectedValue;
// 2 สภาอุนมัติ ให้มีการเก็บจำนวนเงินลงไปได้
if (radlist_parliament.SelectedValue == Global_config.pj_approval_status_value[2])
{
sds_project_approve_final.UpdateParameters["pj_approval_budget"].DefaultValue = txt_approval_budget.Text.Trim();
}
else
{
sds_project_approve_final.UpdateParameters["pj_approval_budget"].DefaultValue = "";
}
sds_project_approve_final.UpdateParameters["pj_approver"].DefaultValue = ck.p_id;
int result = sds_project_approve_final.Update();
if (result > 0)
{
ton.JavaScript.MessageBox("บันทึกสำเร็จ", ton.config.Global_config.RootURL + "project_for_budgetor.aspx?status=2");
}
else
{
ton.JavaScript.MessageBox("บันทึกไม่สำเร็จ");
}
}
else
{
ton.JavaScript.MessageBox("บันทึกไม่สำเร็จ /r/n โปรเจคว่างเปล่า ");
}
}
protected bool allowEditbyRole()
{
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
if (!string.IsNullOrEmpty(ck.p_role_id))
{
if (ck.p_role_id != "1")
{
return(true);
}
else
{
Response.Redirect(Global_config.RootURL);
}
}
}
return(false);
}
protected void Page_Load(object sender, EventArgs e)
{
//check if the user role <> 3, then redirect to login page.
ManageCookie mgCookie = new ManageCookie();
users ck = mgCookie.ReadCookies();
if (ck != null)
{
if (ck.p_role_id != "3")
{
//Response.Redirect("default.aspx");
}
}
if (!Page.IsPostBack)
{
GridView1.DataSource = SqlDataSource2;
GridView1.DataBind();
}
}