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); } }