protected void btnSave6_Click(object sender, EventArgs e)
{
PS_POSI_AND_SALARY PosiSalary = new PS_POSI_AND_SALARY();
PosiSalary.UOC_ID = Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()));
PosiSalary.START_DATE = DateTime.Parse(tbStartDate14.Text);
PosiSalary.PAS_NAME = tbName14.Text;
PosiSalary.NO_POSITION = tbNoPosition14.Text;
PosiSalary.POSITION_TYPE = tbPosiType14.Text;
PosiSalary.POSITION_DEGREE = tbPosiDegree14.Text;
PosiSalary.SALARY = Convert.ToInt32(tbSalary14.Text);
PosiSalary.POSITION_SALARY = Convert.ToInt32(tbPosiSalary14.Text);
PosiSalary.REF_DOC = tbRefDoc14.Text;
PosiSalary.INSERT_PS_POSI_AND_SALARY();
PS_PERSON P0 = new PS_PERSON();
int salary = DatabaseManager.ExecuteInt("SELECT * FROM (SELECT salary FROM PS_POSI_AND_SALARY ORDER BY START_DATE DESC) WHERE ROWNUM = 1");
int posisalary = DatabaseManager.ExecuteInt("SELECT * FROM (SELECT position_salary FROM PS_POSI_AND_SALARY ORDER BY START_DATE DESC) WHERE ROWNUM = 1");
P0.SALARY = salary.ToString();
P0.POSITION_SALARY = posisalary.ToString();
P0.UOC_ID = Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()));
P0.UPDATE_CURRENT_SALARY_PERSON();
ClearPositionAndSalary();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('เพิ่มข้อมูลเรียบร้อย')", true);
BindData();
}
protected void modDeleteCommand5(Object sender, GridViewDeleteEventArgs e)
{
int id = Convert.ToInt32(GridViewPosiSalary.DataKeys[e.RowIndex].Value);
PS_POSI_AND_SALARY PStudy = new PS_POSI_AND_SALARY();
PStudy.PAS_ID = id;
PStudy.DELETE_PS_POSI_AND_SALARY();
PS_PERSON P0 = new PS_PERSON();
int salary = DatabaseManager.ExecuteInt("SELECT * FROM (SELECT salary FROM PS_POSI_AND_SALARY ORDER BY START_DATE DESC) WHERE ROWNUM = 1");
int posisalary = DatabaseManager.ExecuteInt("SELECT * FROM (SELECT position_salary FROM PS_POSI_AND_SALARY ORDER BY START_DATE DESC) WHERE ROWNUM = 1");
P0.SALARY = salary.ToString();
P0.POSITION_SALARY = posisalary.ToString();
P0.UOC_ID = Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()));
P0.UPDATE_CURRENT_SALARY_PERSON();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('ลบข้อมูลเรียบร้อย')", true);
GridViewPosiSalary.EditIndex = -1;
BindData();
}