void BindData1()
{
ClassInsigRecord2 n = new ClassInsigRecord2();
DataTable dt = n.GetInsigRecord2(txtSearchInsig2CITIZENID.Text, "", "", "", "", "", "", "", "", "", "", "");
GridView1.DataSource = dt;
GridView1.DataBind();
SetViewState(dt);
}
void BindData()
{
ClassInsigRecord2 n = new ClassInsigRecord2();
DataTable dt = n.GetInsigRecord2("", "", "", "", "", "", "", "", "", "", "", "");
GridView1.DataSource = dt;
GridView1.DataBind();
SetViewState(dt);
}
protected void btnSearchRefresh_Click(object sender, EventArgs e)
{
ClearData();
ClassInsigRecord2 n = new ClassInsigRecord2();
DataTable dt = n.GetInsigRecord2("", "", "", "", "", "", "", "", "", "", "", "");
GridView1.DataSource = dt;
GridView1.DataBind();
SetViewState(dt);
}
protected void btnSearchInsig2_Click(object sender, EventArgs e)
{
ClassInsigRecord2 n = new ClassInsigRecord2();
DataTable dt = n.GetInsigRecord2(txtSearchInsig2CITIZENID.Text, "", "", "", "", "", "", "", "", "", "", "");
GridView1.DataSource = dt;
GridView1.DataBind();
SetViewState(dt);
ClassInsigRecord2 P = new ClassInsigRecord2();
if (string.IsNullOrEmpty(txtSearchInsig2CITIZENID.Text))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('กรุณาใส่ บัตรประชาชนในการค้นหา')", true);
return;
}
if (txtSearchInsig2CITIZENID.Text.Length <= 12)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('กรุณาใส่ บัตรประชาชนให้ครบ 13 หลัก')", true);
return;
}
else
{
using (OracleConnection conn = Util.OC())
{
using (OracleCommand cmd = new OracleCommand("select PERSON_NAME,PERSON_LASTNAME,TO_CHAR(INWORK_DATE,'dd MON yyyy','NLS_DATE_LANGUAGE = THAI') from tb_person where citizen_id = '" + txtSearchInsig2CITIZENID.Text + "'", conn))
{
using (OracleDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
txtSearchNAME.Text = reader.IsDBNull(0) ? "" : reader.GetString(0);
txtSearchLASTNAME.Text = reader.IsDBNull(1) ? "" : reader.GetString(1);
txtSearchDATE_INWORK.Text = reader.IsDBNull(2) ? "" : reader.GetString(2);
}
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('ไม่พบรหัสบัตรประชาชนดังกล่าว')", true);
return;
}
}
}
}
}
}
protected void modUpdateCommand(Object sender, GridViewUpdateEventArgs e)
{
if (string.IsNullOrEmpty(txtSearchInsig2CITIZENID.Text))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('กรุณาใส่ บัตรประชาชนในการ Update')", true);
return;
}
if (txtSearchInsig2CITIZENID.Text.Length <= 12)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('กรุณาใส่ บัตรประชาชนให้ครบ 13 หลัก')", true);
return;
}
Label lblID = (Label)GridView1.Rows[e.RowIndex].FindControl("lblID");
Label lblCITIZEN_ID = (Label)GridView1.Rows[e.RowIndex].FindControl("lblCITIZEN_ID");
TextBox lbl0 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt0");
TextBox txt1 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt1");
TextBox txt2 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt2");
TextBox txt3 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt3");
TextBox txt4 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt4");
TextBox txt5 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt5");
TextBox txt6 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt6");
TextBox lbl7 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt7");
TextBox txt8 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt8");
TextBox txt9 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt9");
TextBox txt10 = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txt10");
DateTime DDATE = DateTime.Parse(lbl0.Text);
DateTime GAZETTE_DATE = DateTime.Parse(lbl7.Text);
ClassInsigRecord2 n = new ClassInsigRecord2(Convert.ToInt32(lblID.Text)
, lblCITIZEN_ID.Text
, DDATE
, txt1.Text
, txt2.Text
, txt3.Text
, txt4.Text
, txt5.Text
, txt6.Text
, GAZETTE_DATE
, txt8.Text
, txt9.Text
, txt10.Text);
if (n.CheckHaveCitizenID())
{
n.UpdateInsigRecord2();
ClearData();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('อัพเดทข้อมูลเรียบร้อย')", true);
GridView1.EditIndex = -1;
DataTable dt = n.GetInsigRecord2(txtSearchInsig2CITIZENID.Text, "", "", "", "", "", "", "", "", "", "", "");
GridView1.DataSource = dt;
//GridView1.DataBind();
SetViewState(dt);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('ไม่มีรหัสประจำตัวประชาชนดังกล่าวที่จะอัพเดทข้อมูล !')", true);
}
}
