protected void btnSubmitGoverPosition_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtInsertGoverPositionID.Text))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('กรุณาใส่ รหัสระดับข้าราชการ')", true);
return;
}
if (string.IsNullOrEmpty(txtInsertGoverPositionName.Text))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('กรุณาใส่ ชื่อระดับข้าราชการ')", true);
return;
}
if (string.IsNullOrEmpty(txtInsertSubStaffID.Text))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('กรุณาใส่ รหัสประเภทตำแหน่ง')", true);
return;
}
ClassPositionGoverment pg = new ClassPositionGoverment();
pg.ID = Convert.ToInt32(txtInsertGoverPositionID.Text);
pg.NAME = txtInsertGoverPositionName.Text;
pg.ST_ID = txtInsertSubStaffID.Text;
if (pg.CheckUsePositionGovermentID())
{
pg.InsertPositionGoverment();
BindData();
ClearData();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('เพิ่มข้อมูลเรียบร้อย')", true);
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('มีรหัสระดับข้าราชการนี้ อยู่ในระบบแล้ว !')", true);
}
}
void BindData1()
{
ClassPositionGoverment pg = new ClassPositionGoverment();
DataTable dt = pg.GetPositionGovermentSearch(txtSearchGoverPositionID.Text, txtSearchGoverPositionName.Text, txtSearchSubStaffID.Text);
GridView1.DataSource = dt;
GridView1.DataBind();
SetViewState(dt);
}
void BindData()
{
ClassPositionGoverment pg = new ClassPositionGoverment();
DataTable dt = pg.GetPositionGoverment("", "", "");
GridView1.DataSource = dt;
GridView1.DataBind();
SetViewState(dt);
}
protected void btnSearchRefresh_Click(object sender, EventArgs e)
{
ClearData();
ClassPositionGoverment pg = new ClassPositionGoverment();
DataTable dt = pg.GetPositionGoverment("", "", "");
GridView1.DataSource = dt;
GridView1.DataBind();
SetViewState(dt);
}
protected void modDeleteCommand(Object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
ClassPositionGoverment pg = new ClassPositionGoverment();
pg.ID = id;
pg.DeletePositionGoverment();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('ลบข้อมูลเรียบร้อย')", true);
GridView1.EditIndex = -1;
BindData1();
}
protected void modUpdateCommand(Object sender, GridViewUpdateEventArgs e)
{
TextBox txtGoverPositionIDEdit = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtGoverPositionIDEdit");
TextBox txtGoverPositionNameEdit = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtGoverPositionNameEdit");
TextBox txtSubStaffIDEdit = (TextBox)GridView1.Rows[e.RowIndex].FindControl("txtSubStaffIDEdit");
ClassPositionGoverment pg = new ClassPositionGoverment(Convert.ToInt32(txtGoverPositionIDEdit.Text), txtGoverPositionNameEdit.Text, txtSubStaffIDEdit.Text);
pg.UpdatePositionGoverment();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('อัพเดทข้อมูลเรียบร้อย')", true);
GridView1.EditIndex = -1;
BindData1();
}
protected void btnSearchGoverPosition_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtSearchGoverPositionID.Text) && string.IsNullOrEmpty(txtSearchGoverPositionName.Text) && string.IsNullOrEmpty(txtSearchSubStaffID.Text))
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('กรุณากรอก คำค้นหา')", true);
return;
}
else
{
ClassPositionGoverment pg = new ClassPositionGoverment();
DataTable dt = pg.GetPositionGovermentSearch(txtSearchGoverPositionID.Text, txtSearchGoverPositionName.Text, txtSearchSubStaffID.Text);
GridView1.DataSource = dt;
GridView1.DataBind();
SetViewState(dt);
}
}
