protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strMessage = string.Empty;
string strScript = string.Empty;
HiddenField hddbudget_open_detail_id = (HiddenField)GridView1.Rows[e.RowIndex].FindControl("hddbudget_open_detail_id");
cBudget_open oBudget_open = new cBudget_open();
try
{
oBudget_open.SP_BUDGET_OPEN_DETAIL_DEL(hddbudget_open_detail_id.Value);
oBudget_open.SP_BUDGET_OPEN_TOTAL_UPD(txtbudget_open_doc.Text);
}
catch (Exception ex)
{
if (ex.Message.Contains("REFERENCE constraint"))
{
MsgBox("ไม่สามารถลบข้อมูลได้เนื่องจากมีการนำไปใช้ในระบบแล้ว");
}
else
{
lblError.Text = ex.Message.ToString();
}
}
finally
{
oBudget_open.Dispose();
}
BindGridDetail();
}
private bool saveData()
{
bool blnResult = false;
Budget_open_head budget_open_head = new Budget_open_head();
cBudget_open obudget_open = new cBudget_open();
try
{
#region set Data
budget_open_head.budget_open_doc = txtbudget_open_doc.Text;
budget_open_head.degree_code = cboDegree.SelectedValue;
budget_open_head.budget_open_date = cCommon.GetDate(Request.Form[txtbudget_open_date.UniqueID]);
if (!string.IsNullOrEmpty(Request.Form[txtbudget_open_date_actual.UniqueID]))
{
budget_open_head.budget_open_date_actual = cCommon.GetDate(Request.Form[txtbudget_open_date_actual.UniqueID]);
}
budget_open_head.budget_type = cboBudget_type.SelectedValue;
budget_open_head.budget_open_year = cboYear.SelectedValue;
budget_open_head.major_code = cboMajor.SelectedValue;
budget_open_head.budget_plan_code = txtbudget_plan_code.Text;
budget_open_head.budget_open_no = txtbudget_open_no.Text.Trim();
budget_open_head.budget_open_ap = txtbudget_open_ap.Text.Trim();
budget_open_head.budget_open_pr = txtbudget_open_pr.Text.Trim();
budget_open_head.budget_open_budget_no = txtbudget_open_budget_no.Text.Trim();
budget_open_head.ef_open_doc = txtef_open_doc.Text;
if (!string.IsNullOrEmpty(txtopen_code.Text))
{
budget_open_head.open_code = int.Parse(txtopen_code.Text);
}
budget_open_head.open_title = txtopen_title.Text.Trim();
budget_open_head.open_command_desc = txtopen_command_desc.Text.Trim();
budget_open_head.open_desc = txtopen_desc.Text.Trim();
budget_open_head.open_remark = txtopen_remark.Text.Trim();
budget_open_head.approve_head_status = cboApproveStatus.SelectedValue;
budget_open_head.person_open = txtperson_code.Text;
budget_open_head.c_created_by = Session["username"].ToString();
budget_open_head.c_updated_by = Session["username"].ToString();
#endregion
if (ViewState["mode"].ToString().ToLower().Equals("edit"))
{
if (obudget_open.SP_BUDGET_OPEN_HEAD_UPD(budget_open_head))
{
saveDataDetail();
obudget_open.SP_BUDGET_OPEN_TOTAL_UPD(txtbudget_open_doc.Text);
}
}
else
{
obudget_open.SP_BUDGET_OPEN_HEAD_INS(budget_open_head);
ViewState["budget_open_doc"] = budget_open_head.budget_open_doc;
}
blnResult = true;
}
catch (Exception ex)
{
if (ex.Message.Contains("duplicate key"))
{
MsgBox("ข้อมูลซ้ำโปรดตรวจสอบ");
}
else
{
lblError.Text = ex.Message.ToString();
}
}
finally
{
obudget_open.Dispose();
}
return(blnResult);
}
