private bool saveData()
{
bool blnResult = false;
int intapprove_code, intapprove_level = 0;
string strapprove_name = string.Empty,
strUserName = string.Empty,
strScript = string.Empty;
cefApprove objefApprove = new cefApprove();
DataSet ds = new DataSet();
try
{
#region set Data
intapprove_code = Helper.CInt(txtapprove_code.Text);
strapprove_name = txtapprove_name.Text;
intapprove_level = Helper.CInt(txtapprove_level.Value);
strUserName = Session["username"].ToString();
#endregion
if (ViewState["mode"].ToString().ToLower().Equals("edit"))
{
blnResult = objefApprove.SP_APPROVE_UPD(intapprove_code, strapprove_name, intapprove_level, strUserName);
}
else
{
#region insert
if (objefApprove.SP_APPROVE_INS(ref intapprove_code, strapprove_name, intapprove_level, strUserName))
{
ViewState["approve_code"] = intapprove_code;
blnResult = true;
}
#endregion
}
}
catch (Exception ex)
{
if (ex.Message.Contains("duplicate") && ex.Message.Contains("IX_approve_name"))
{
strScript = "alert(\"ไม่สามารถบันทึกข้อมูล เนื่องจากข้อมูลรายละเอียดระดับการอนุมัติ : " + strapprove_name.Trim() + " ซ้ำ\");\n";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "frMainPage", strScript, true);
}
else if (ex.Message.Contains("duplicate") && ex.Message.Contains("IX_approve_level"))
{
strScript = "alert(\"ไม่สามารถบันทึกข้อมูล เนื่องจากข้อมูลลำดับการอนุมัติ : " + intapprove_level.ToString() + " ซ้ำ\");\n";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "frMainPage", strScript, true);
}
else
{
lblError.Text = ex.Message.ToString();
}
}
finally
{
objefApprove.Dispose();
}
return(blnResult);
}
private void BindGridView(int nPageNo)
{
cefApprove objEfDoctype = new cefApprove();
DataTable dt;
string strMessage = string.Empty;
string strCriteria = string.Empty;
string strapprove_name = string.Empty;
strapprove_name = txtapprove_name.Text.Replace("'", "''").Trim();
if (!strapprove_name.Equals("0"))
{
strCriteria = strCriteria + " And (approve_name like '%" + strapprove_name + "%')";
}
try
{
dt = objEfDoctype.SP_APPROVE_SEL(strCriteria);
try
{
GridView1.PageIndex = nPageNo;
txthTotalRecord.Value = dt.Rows.Count.ToString();
dt.DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = dt;
GridView1.DataBind();
}
catch
{
GridView1.PageIndex = 0;
txthTotalRecord.Value = dt.Rows.Count.ToString();
dt.DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
objEfDoctype.Dispose();
if (GridView1.Rows.Count > 0)
{
GridView1.TopPagerRow.Visible = true;
}
}
}
private void setData()
{
cefApprove objECefDoctype = new cefApprove();
DataTable dt;
string strMessage = string.Empty, strCriteria = string.Empty;
string strapprove_code = string.Empty,
strapprove_name = string.Empty,
strCreatedBy = string.Empty,
strUpdatedBy = string.Empty,
strCreatedDate = string.Empty,
strUpdatedDate = string.Empty,
strapprove_level = "0";
try
{
strCriteria = " and approve_code = '" + ViewState["approve_code"].ToString() + "' ";
dt = objECefDoctype.SP_APPROVE_SEL(strCriteria);
if (dt.Rows.Count > 0)
{
#region get Data
strapprove_code = dt.Rows[0]["approve_code"].ToString();
strapprove_name = dt.Rows[0]["approve_name"].ToString();
strapprove_level = dt.Rows[0]["approve_level"].ToString();
strCreatedBy = dt.Rows[0]["c_created_by"].ToString();
strUpdatedBy = dt.Rows[0]["c_updated_by"].ToString();
strCreatedDate = dt.Rows[0]["d_created_date"].ToString();
strUpdatedDate = dt.Rows[0]["d_updated_date"].ToString();
#endregion
#region set Control
txtapprove_code.Text = strapprove_code;
txtapprove_name.Text = strapprove_name;
txtapprove_level.Value = strapprove_level;
txtUpdatedBy.Text = strUpdatedBy;
txtUpdatedDate.Text = strUpdatedDate;
#endregion
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strMessage = string.Empty;
string strScript = string.Empty;
Label lblapprove_code = (Label)GridView1.Rows[e.RowIndex].FindControl("lblapprove_code");
cefApprove objEfDoctype = new cefApprove();
try
{
objEfDoctype.SP_APPROVE_DEL(Helper.CInt(lblapprove_code.Text));
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
objEfDoctype.Dispose();
}
BindGridView(0);
}
