protected void lbuEdit_Click(object sender, EventArgs e)
{
string link = MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString());
string encrypt = MyCrypto.GetEncryptedQueryString(link);
Response.Redirect("editproject.aspx?id=" + encrypt);
}
private void FuncGVHistory()
{
OracleConnection.ClearAllPools();
SqlDataSource sds = DatabaseManager.CreateSQLDataSource("SELECT R_ID รหัสคำร้องแก้ไขข้อมูล, (SELECT PS_FIRSTNAME || ' ' || PS_LASTNAME FROM PS_PERSON WHERE PS_PERSON.PS_CITIZEN_ID = TB_REQUEST.CITIZEN_ID) ชื่อ, (SELECT (SELECT CAMPUS_NAME FROM TB_CAMPUS WHERE PS_PERSON.PS_CAMPUS_ID = TB_CAMPUS.CAMPUS_ID) FROM PS_PERSON WHERE PS_PERSON.PS_CITIZEN_ID = TB_REQUEST.CITIZEN_ID) วิทยาเขต, (SELECT (SELECT STAFFTYPE_NAME FROM TB_STAFFTYPE WHERE PS_PERSON.PS_STAFFTYPE_ID = TB_STAFFTYPE.STAFFTYPE_ID) FROM PS_PERSON WHERE PS_PERSON.PS_CITIZEN_ID = TB_REQUEST.CITIZEN_ID) ประเภทบุคลากร, DATE_START วันที่ข้อมูล, (SELECT R_STATUS_NAME FROM TB_REQUEST_STATUS WHERE TB_REQUEST_STATUS.R_STATUS_ID = TB_REQUEST.R_STATUS_ID) สถานะ, NVL(R_ALLOW,0) ผลการอนุมัติ, DATE_END วันที่อนุมัติ FROM TB_REQUEST WHERE R_STATUS_ID IN(2,3,4,5) ORDER BY R_ID DESC");
gvHistory.DataSource = sds;
gvHistory.DataBind();
if (gvHistory.Rows.Count > 0)
{
lbHistory.Visible = false;
TableHeaderCell headerCell = new TableHeaderCell();
headerCell.Text = "ดูข้อมูล";
gvHistory.HeaderRow.Cells.Add(headerCell);
for (int i = 0; i < gvHistory.Rows.Count; ++i)
{
string ID = gvHistory.Rows[i].Cells[0].Text;
TableCell cell = new TableCell();
LinkButton btn = new LinkButton();
btn.CssClass = "ps-button-img";
btn.Text = "<img src='Image/Small/search.png'></img>";
btn.Click += (e2, e3) => {
Response.Redirect("ViewRequestForm.aspx?id=" + MyCrypto.GetEncryptedQueryString(ID).ToString());
};
cell.Controls.Add(btn);
gvHistory.Rows[i].Cells.Add(cell);
if (Util.StringEqual(gvHistory.Rows[i].Cells[6].Text, new string[] { "0" }))
{
gvHistory.Rows[i].Cells[6].Text = "-";
gvHistory.Rows[i].Cells[6].ForeColor = System.Drawing.Color.Black;
}
if (Util.StringEqual(gvHistory.Rows[i].Cells[6].Text, new string[] { "2" }))
{
gvHistory.Rows[i].Cells[6].Text = "ไม่อนุมัติ";
gvHistory.Rows[i].Cells[6].ForeColor = System.Drawing.Color.Red;
}
if (Util.StringEqual(gvHistory.Rows[i].Cells[6].Text, new string[] { "1" }))
{
gvHistory.Rows[i].Cells[6].Text = "อนุมัติ";
gvHistory.Rows[i].Cells[6].ForeColor = System.Drawing.Color.Green;
}
}
Util.NormalizeGridViewDate(gvHistory, 4);
Util.NormalizeGridViewDate(gvHistory, 7);
}
else
{
lbHistory.Visible = true;
}
}
protected void OnDeletePosition(object sender, EventArgs e)
{
RepeaterItem item = (sender as LinkButton).Parent as RepeaterItem;
string ValuePHID = (item.FindControl("HFPH_ID") as HiddenField).Value;
if (ValuePHID != "")
{
string CheckNull = DatabaseManager.ExecuteString("SELECT COUNT(*) FROM PS_POSITION_HISTORY WHERE CITIZEN_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'");
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
if (CheckNull == "1")
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_POSITION_ID = :PS_POSITION_ID WHERE PS_CITIZEN_ID = :PS_CITIZEN_ID", con))
{
com.Parameters.Add(new OracleParameter("PS_POSITION_ID", DBNull.Value));
com.Parameters.Add(new OracleParameter("PS_CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.ExecuteNonQuery();
}
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_FIRST_POSITION_ID = :PS_FIRST_POSITION_ID WHERE PS_CITIZEN_ID = :PS_CITIZEN_ID", con))
{
com.Parameters.Add(new OracleParameter("PS_FIRST_POSITION_ID", DBNull.Value));
com.Parameters.Add(new OracleParameter("PS_CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.ExecuteNonQuery();
}
}
else
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_POSITION_ID = (select P_ID from ( select P_ID, rownum as rn from ( select P_ID from PS_POSITION_HISTORY where CITIZEN_ID = :CITIZEN_ID order by GET_DATE desc )) where rn=2) WHERE PS_CITIZEN_ID = :PS_CITIZEN_ID", con))
{
com.Parameters.Add(new OracleParameter("CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.Parameters.Add(new OracleParameter("PS_CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.ExecuteNonQuery();
}
//using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_FIRST_POSITION_ID = (select P_ID from ( select P_ID, rownum as rn from ( select P_ID from PS_POSITION_HISTORY where CITIZEN_ID = :CITIZEN_ID order by GET_DATE desc )) where rn=2) WHERE PS_CITIZEN_ID = :PS_CITIZEN_ID", con))
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_FIRST_POSITION_ID = (SELECT P_ID FROM PS_POSITION_HISTORY WHERE CITIZEN_ID = :CITIZEN_ID AND GET_DATE = (SELECT MIN(GET_DATE) FROM PS_POSITION_HISTORY WHERE CITIZEN_ID = :CITIZEN_ID)) WHERE PS_CITIZEN_ID = :PS_CITIZEN_ID", con))
{
com.Parameters.Add(new OracleParameter("CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.Parameters.Add(new OracleParameter("PS_CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.ExecuteNonQuery();
}
}
DatabaseManager.ExecuteNonQuery("DELETE PS_POSITION_HISTORY WHERE PH_ID = '" + ValuePHID + "'");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('ลบข้อมูลเรียบร้อย')", true);
BindPosition();
}
}
}
protected void lbuDelete_Click(object sender, EventArgs e)
{
List <int> pro_id = new List <int>();
List <string> pdf_file = new List <string>();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT PRO_ID, PDF_FILE FROM TB_PROJECT WHERE PRO_ID = " + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())), con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
if (!reader.IsDBNull(1))
{
pro_id.Add(reader.GetInt32(0));
pdf_file.Add(reader.GetString(1));
}
}
}
}
}
for (int i = 0; i < pro_id.Count; i++)
{
string path = "Upload/Project/PDF/" + pdf_file[i];
int PRO_ID = pro_id[i];
string PDF_FILE = pdf_file[i];
string pathVS = Server.MapPath("Upload/Project/PDF/" + PDF_FILE);
if ((System.IO.File.Exists(pathVS)))
{
System.IO.File.Delete(pathVS);
}
DatabaseManager.ExecuteNonQuery("DELETE TB_PROJECT WHERE PRO_ID = '" + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + "'");
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('ลบข้อมูลเรียบร้อย')", true);
}
string link = MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString());
DatabaseManager.ExecuteNonQuery("DELETE TB_PROJECT WHERE PRO_ID = '" + link + "'");
Notsuccess.Visible = false;
delete.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
Notsuccess.Visible = true;
delete.Visible = false;
if (!IsPostBack)
{
if (Request.QueryString["id"] != null)
{
int.TryParse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), out id);
ReadSelectID();
}
else
{
Response.Redirect("listproject.aspx");
}
}
ReadFile();
}
protected void btnUpdateSalary_Click(object sender, EventArgs e)
{
string ValueSalary = tbSalary.Text;
string ValuePositionSalary = tbPositionSalary.Text;
string ValueResult1 = tbResult1.Text;
string ValuePercentSalary1 = tbPercentSalary1.Text;
string ValueResult2 = tbResult2.Text;
string ValuePercentSalary2 = tbPercentSalary2.Text;
DateTime ValueDate = Util.ToDateTimeOracle(tbInsertDateSalary.Text);
if (Session["DefaultIdSalary"] == null)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('กรุณาเลือกรายการที่จะแก้ไขก่อน')", true);
return;
}
if (ValueSalary != "")
{
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("UPDATE PS_SALARY SET CITIZEN_ID = :CITIZEN_ID, SALARY = :SALARY, POSITION_SALARY = :POSITION_SALARY, RESULT1 = :RESULT1 ,PERCENT_SALARY1 = :PERCENT_SALARY1 ,RESULT2 = :RESULT2 ,PERCENT_SALARY2 = :PERCENT_SALARY2, DO_DATE = :DO_DATE WHERE SALARY_ID = :SALARY_ID", con))
{
com.Parameters.Add(new OracleParameter("CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.Parameters.Add(new OracleParameter("SALARY", ValueSalary));
com.Parameters.Add(new OracleParameter("POSITION_SALARY", ValuePositionSalary));
com.Parameters.Add(new OracleParameter("RESULT1", ValueResult1));
com.Parameters.Add(new OracleParameter("PERCENT_SALARY1", ValuePercentSalary1));
com.Parameters.Add(new OracleParameter("RESULT2", ValueResult2));
com.Parameters.Add(new OracleParameter("PERCENT_SALARY2", ValuePercentSalary2));
com.Parameters.Add(new OracleParameter("DO_DATE", ValueDate));
com.Parameters.Add(new OracleParameter("SALARY_ID", Session["DefaultIdSalary"].ToString()));
com.ExecuteNonQuery();
}
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('อัพเดทข้อมูลเรียบร้อย')", true);
BindSalary();
ClearSalary();
Session.Remove("DefaultIdSalary");
}
}
protected void btnInsertSalary_Click(object sender, EventArgs e)
{
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("INSERT INTO PS_SALARY (CITIZEN_ID,SALARY,POSITION_SALARY,RESULT1,PERCENT_SALARY1,RESULT2,PERCENT_SALARY2,DO_DATE) VALUES (:CITIZEN_ID,:SALARY,:POSITION_SALARY,:RESULT1,:PERCENT_SALARY1,:RESULT2,:PERCENT_SALARY2,:DO_DATE)", con))
{
com.Parameters.Add(new OracleParameter("CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.Parameters.Add(new OracleParameter("SALARY", tbSalary.Text));
com.Parameters.Add(new OracleParameter("POSITION_SALARY", tbPositionSalary.Text));
com.Parameters.Add(new OracleParameter("RESULT1", tbResult1.Text));
com.Parameters.Add(new OracleParameter("PERCENT_SALARY1", tbPercentSalary1.Text));
com.Parameters.Add(new OracleParameter("RESULT2", tbResult2.Text));
com.Parameters.Add(new OracleParameter("PERCENT_SALARY2", tbPercentSalary2.Text));
com.Parameters.Add(new OracleParameter("DO_DATE", Util.ToDateTimeOracle(tbInsertDateSalary.Text)));
com.ExecuteNonQuery();
}
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('เพิ่มข้อมูลเรียบร้อย')", true);
BindSalary();
ClearSalary();
}
protected void ReadRequest()
{
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT R_ID, CITIZEN_ID, R_STATUS_ID, DATE_START, DATE_END, (SELECT TITLE_NAME_TH FROM TB_TITLENAME WHERE TB_TITLENAME.TITLE_ID = TB_REQUEST.TITLE_ID) TITLE_NAME, FIRSTNAME, LASTNAME, (SELECT GENDER_NAME FROM TB_GENDER WHERE TB_GENDER.GENDER_ID = TB_REQUEST.GENDER_ID) GENDER_NAME, TO_CHAR(ADD_MONTHS(BIRTHDAY_DATE,6516),'DD MON YYYY') BIRTHDAY_DATE, EMAIL, (SELECT NATION_NAME_EN FROM TB_NATION WHERE TB_NATION.NATION_ID = TB_REQUEST.NATION_ID) NATION_NAME, (SELECT CAMPUS_NAME FROM TB_CAMPUS WHERE TB_CAMPUS.CAMPUS_ID = TB_REQUEST.CAMPUS_ID) CAMPUS_NAME, (SELECT FACULTY_NAME FROM TB_FACULTY WHERE TB_FACULTY.FACULTY_ID = TB_REQUEST.FACULTY_ID) FACULTY_NAME, (SELECT DIVISION_NAME FROM TB_DIVISION WHERE TB_DIVISION.DIVISION_ID = TB_REQUEST.DIVISION_ID) DIVISION_NAME, (SELECT WORK_NAME FROM TB_WORK_DIVISION WHERE TB_WORK_DIVISION.WORK_ID = TB_REQUEST.WORK_DIVISION_ID) WORK_DIVISION_NAME, (SELECT STAFFTYPE_NAME FROM TB_STAFFTYPE WHERE TB_STAFFTYPE.STAFFTYPE_ID = TB_REQUEST.STAFFTYPE_ID) STAFFTYPE_NAME, (SELECT TIME_CONTACT_NAME FROM TB_TIME_CONTACT WHERE TB_TIME_CONTACT.TIME_CONTACT_ID = TB_REQUEST.TIME_CONTACT_ID) TIME_CONTACT_NAME, (SELECT BUDGET_NAME FROM TB_BUDGET WHERE TB_BUDGET.BUDGET_ID = TB_REQUEST.BUDGET_ID) BUDGET_NAME, (SELECT SUBSTAFFTYPE_NAME FROM TB_SUBSTAFFTYPE WHERE TB_SUBSTAFFTYPE.SUBSTAFFTYPE_ID = TB_REQUEST.SUBSTAFFTYPE_ID) SUBSTAFFTYPE_NAME, (SELECT ADMIN_POSITION_NAME FROM TB_ADMIN_POSITION WHERE TB_ADMIN_POSITION.ADMIN_POSITION_ID = TB_REQUEST.ADMIN_POS_ID) ADMIN_POSITION_NAME, (SELECT POSITION_WORK_NAME FROM TB_POSITION_WORK WHERE TB_POSITION_WORK.POSITION_WORK_ID = TB_REQUEST.WORK_POS_ID) WORK_POS_NAME, TO_CHAR(ADD_MONTHS(INWORK_DATE,6516),'DD MON YYYY') INWORK_DATE, TO_CHAR(ADD_MONTHS(DATE_START_THIS_U,6516),'DD MON YYYY') DATE_START_THIS_U, SPECIAL_NAME, (SELECT ISCED_NAME FROM TB_ISCED WHERE TB_ISCED.ISCED_ID = TB_REQUEST.TEACH_ISCED_ID) TEACH_ISCED_NAME, (SELECT LEV_NAME_TH FROM TB_LEV WHERE TB_LEV.LEV_ID = TB_REQUEST.GRAD_LEV_ID) GRAD_LEV_NAME, GRAD_CURR, (SELECT ISCED_NAME FROM TB_ISCED WHERE TB_ISCED.ISCED_ID = TB_REQUEST.GRAD_ISCED_ID) GRAD_ISCED_NAME, (SELECT PROGRAM_NAME FROM TB_PROGRAM WHERE TB_PROGRAM.PROGRAM_ID_NEW = TB_REQUEST.GRAD_PROG_ID) GRAD_PROG_NAME, GRAD_UNIV, (SELECT NATION_NAME_EN FROM TB_NATION WHERE TB_NATION.NATION_ID = TB_REQUEST.GRAD_COUNTRY_ID) GRAD_COUNTRY_NAME, (SELECT DEFORM_NAME FROM TB_DEFORM WHERE TB_DEFORM.DEFORM_ID = TB_REQUEST.DEFORM_ID) DEFORM_NAME, (SELECT RELIGION_NAME FROM TB_RELIGION WHERE TB_RELIGION.RELIGION_ID = TB_REQUEST.RELIGION_ID) RELIGION_NAME, COMMENT_INFO, (SELECT R_STATUS_NAME FROM TB_REQUEST_STATUS WHERE TB_REQUEST_STATUS.R_STATUS_ID = TB_REQUEST.R_STATUS_ID) FROM TB_REQUEST WHERE R_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "' ORDER BY R_ID DESC", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
int i = 1;
while (reader.Read())
{
Table tb1 = new Table();
div1.Controls.Add(tb1);
{
TableHeaderRow row = new TableHeaderRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableHeaderCell cell = new TableHeaderCell();
cell.ColumnSpan = 2;
cell.Text = "วันที่อนุมัติ " + reader.GetDateTime(4).ToLongDateString() + " / ";
if (reader.GetValue(2).ToString() == "2" || reader.GetValue(2).ToString() == "3")
{
cell.Text += "<span style=\"color: rgb(34, 177, 76);\">อนุมัติ</span>";
}
else if (reader.GetValue(2).ToString() == "4" || reader.GetValue(2).ToString() == "5")
{
cell.Text += "<span style=\"color: rgb(237, 28, 36);\">ไม่อนุมัติ</span>";
}
row.Cells.Add(cell);
}
if (!reader.IsDBNull(0))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "รหัสคำร้องแก้ไขข้อมูล";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(0).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(5))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "คำนำหน้า";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(5).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(6))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ชื่อ";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(6).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(7))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "นามสกุล";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(7).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(8))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "เพศ";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(8).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(9))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "วันเกิด";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(9).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(10))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "อีเมล";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(10).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(11))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "สัญชาติ";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(11).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(12))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "วิทยาเขต";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(12).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(13))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "สำนัก/สถาบัน/คณะ";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(13).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(14))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "กอง/สำนักงานเลขา/ภาควิชา";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(14).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(15))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "งาน/ฝ่าย";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(15).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(16))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ประเภทบุคลากร";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(16).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(17))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ระยะเวลาจ้าง";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(17).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(18))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ประเภทเงินจ้าง";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(18).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(19))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ประเภทบุคลากรย่อย";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(19).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(20))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ตำแหน่งทางบริหาร";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(20).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(21))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ตำแหน่งในสายงาน";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(21).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(22))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "วันที่เข้าทำงานครั้งแรก";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(22).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(23))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "วันที่เข้าทำงาน ณ สถานที่ปัจจุบัน";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(23).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(24))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "สาขางานที่เชี่ยวชาญ";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(24).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(25))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "กลุ่มสาขาวิชาที่สอน(ISCED)";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(25).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(26))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ระดับการศึกษาที่จบสูงสุด";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(26).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(27))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "หลักสูตรที่จบการศึกษาสูงสุด";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(27).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(28))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "กลุ่มสาขาวิชาที่จบสูงสุด(ISCED)";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(28).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(29))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "สาขาวิชาที่จบสูงสุด";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(29).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(30))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ชื่อสถาบันที่จบการศึกษาสูงสุด";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(30).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(31))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ประเทศที่จบการศึกษาสูงสุด";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(31).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(32))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ความพิการ";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(32).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(33))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "ศาสนา";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(33).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(34))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "<strong>ความเห็น</strong>";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(34).ToString();
row.Cells.Add(cell);
}
if (!reader.IsDBNull(35))
{
TableRow row = new TableRow();
tb1.Controls.Add(row);
tb1.Rows.Add(row);
TableCell cell = new TableCell();
cell.Text = "<strong>ผลการอนุมัติ</strong>";
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = reader.GetValue(35).ToString();
row.Cells.Add(cell);
}
}
}
}
}
}
private void ReadFile()
{
List <int> pro_id = new List <int>();
List <string> pdf_file = new List <string>();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT PRO_ID, PDF_FILE FROM TB_PROJECT WHERE PRO_ID = " + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())), con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
if (!reader.IsDBNull(1))
{
pro_id.Add(reader.GetInt32(0));
pdf_file.Add(reader.GetString(1));
}
}
}
}
}
for (int i = 0; i < pro_id.Count; i++)
{
string path = "Upload/Project/PDF/" + pdf_file[i];
int PRO_ID = pro_id[i];
string PDF_FILE = pdf_file[i];
Panel p = new Panel();
p.Style.Add("display", "inline-block");
LinkButton lb = new LinkButton();
lb.Attributes["href"] = path;
lb.Text = "ดูไฟล์แนบ (รูปภาพ,เอกสาร ประกอบการอบรม)";
p.Controls.Add(lb);
LinkButton lbDelete = new LinkButton();
lbDelete.CssClass = "ps-button";
lbDelete.Text = "<img src='Image/Small/delete.png' class='icon_left' />ลบ";
lbDelete.Click += (e1, e2) =>
{
lbDelete.Attributes.Add("onclick", "javascript:if(!confirm('คุณต้องการที่จะลบใช่หรือไม่'))return false;");
FileInfo FileIn = new FileInfo(Server.MapPath("Upload/Project/PDF/" + PDF_FILE));
if (FileIn.Exists)
{
FileIn.Delete();
}
DatabaseManager.ExecuteNonQuery("UPDATE TB_PROJECT SET PDF_FILE = (null) WHERE PRO_ID = " + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
Page.Response.Redirect(Page.Request.Url.ToString(), true);
};
p.Controls.Add(lbDelete);
file_pdf.Controls.Add(p);
}
}
protected void btnUpdateProject_Click(object sender, EventArgs e)
{
if (Request.QueryString["id"] != null)
{
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT PRO_ID FROM TB_PROJECT WHERE START_DATE BETWEEN " + Util.DatabaseToDateSearch(tbStartDate.Text) + " AND " + Util.DatabaseToDateSearch(tbEndDate.Text) + " AND CITIZEN_ID = '" + loginPerson.PS_CITIZEN_ID + "'", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
if (!reader.IsDBNull(0))
{
Project ProjectData = new Project();
ProjectData.Load(reader.GetInt32(0));
ChangeNotification("danger", "ไม่สามารถเพิ่มข้อมูลได้ พบวันซ้อนทับกัน (รหัสโครงการ " + ProjectData.PRO_ID + ", " + ProjectData.START_DATE.Value.ToLongDateString() + " ถึง " + ProjectData.END_DATE.Value.ToLongDateString() + ")");
return;
}
}
}
}
}
/*string[] validFileTypes = { "pdf" };
* string ext = System.IO.Path.GetExtension(FUdocument.PostedFile.FileName);
* bool isValidFile = false;
*
* for (int i = 0; i < validFileTypes.Length; i++)
* {
* if (ext == "." + validFileTypes[i])
* {
* isValidFile = true;
* break;
* }
* }
* if (!isValidFile)
* {
* ScriptManager.GetCurrent(this.Page).SetFocus(this.FUdocument);
* ChangeNotification("danger", "กรุณาแนบไฟล์นามสกุล " + string.Join(",", validFileTypes) + " เท่านั้น");
* return;
* }
*
* else if (FUdocument.PostedFile.ContentLength > 26214400)
* {
* ScriptManager.GetCurrent(this.Page).SetFocus(this.FUdocument);
* ChangeNotification("danger", "กรุณาแนบไฟล์ไม่เกิน 25 MB");
* return;
* }
* else
* {
* ChangeNotification("", "");
* }*/
if (tbStartDate.Text != "" && tbEndDate.Text != "")
{
DateTime dtEndDate = DateTime.Parse(tbEndDate.Text);
DateTime dtStartDate = DateTime.Parse(tbStartDate.Text);
int totalDay = (int)(dtEndDate - dtStartDate).TotalDays + 1;
if (totalDay <= 0)
{
notification.Attributes["class"] = "alert alert_danger";
notification.InnerHtml = "";
notification.InnerHtml += "<div> <img src='Image/Small/red_alert.png' /> วันที่เริ่มโครงการ - วันที่สิ้นสุดโครงการ : วันที่ไม่ถูกต้อง !</div>";
ScriptManager.GetCurrent(this.Page).SetFocus(this.tbStartDate);
return;
}
else
{
notification.Attributes["class"] = "none";
notification.InnerHtml = "";
}
}
if (Util.ToDateTimeOracle(tbStartDate.Text) > DateTime.Now)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('วันที่ไม่สามารถมากกว่าวันปัจจุบัน')", true);
return;
}
if (Util.ToDateTimeOracle(tbEndDate.Text) > DateTime.Now)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('วันที่ไม่สามารถมากกว่าวันปัจจุบัน')", true);
return;
}
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
Person loginPerson = ps.LoginPerson;
con.Open();
string query = "Update TB_PROJECT Set";
query += " CATEGORY_ID = :CATEGORY_ID ,";
query += " COUNTRY_ID = :COUNTRY_ID ,";
query += " SUB_COUNTRY_ID = :SUB_COUNTRY_ID ,";
query += " PROJECT_NAME = :PROJECT_NAME ,";
query += " ADDRESS_PROJECT = :ADDRESS_PROJECT ,";
query += " START_DATE = :START_DATE ,";
query += " END_DATE = :END_DATE ,";
query += " EXPENSES = :EXPENSES ,";
query += " FUNDING = :FUNDING ,";
query += " CERTIFICATE = :CERTIFICATE ,";
query += " SUMMARIZE_PROJECT = :SUMMARIZE_PROJECT ,";
query += " RESULT_TEACHING = :RESULT_TEACHING ,";
query += " RESULT_ACADEMIC = :RESULT_ACADEMIC ,";
query += " DIFFICULTY_PROJECT = :DIFFICULTY_PROJECT ,";
query += " RESULT_PROJECT = :RESULT_PROJECT ,";
query += " RESULT_RESEARCHING = :RESULT_RESEARCHING ,";
query += " RESULT_OTHER = :RESULT_OTHER ,";
query += " COUNSEL = :COUNSEL ,";
query += " PDF_FILE = :PDF_FILE ";
query += " where PRO_ID = :PRO_ID ";
using (OracleCommand com = new OracleCommand(query, con))
{
com.Parameters.Add(new OracleParameter("CATEGORY_ID", Convert.ToInt32(ddlCategory.SelectedValue)));
com.Parameters.Add(new OracleParameter("COUNTRY_ID", Convert.ToInt32(ddlCountry.SelectedValue)));
com.Parameters.Add(new OracleParameter("SUB_COUNTRY_ID", Convert.ToInt32(ddlSubCountry.SelectedValue)));
com.Parameters.Add(new OracleParameter("PROJECT_NAME", tbProjectName.Text));
com.Parameters.Add(new OracleParameter("ADDRESS_PROJECT", tbAddressProject.Text));
com.Parameters.Add(new OracleParameter("START_DATE", DateTime.Parse(tbStartDate.Text)));
com.Parameters.Add(new OracleParameter("END_DATE", DateTime.Parse(tbEndDate.Text)));
com.Parameters.Add(new OracleParameter("EXPENSES", Convert.ToInt32(tbExpenses.Text)));
com.Parameters.Add(new OracleParameter("FUNDING", tbFunding.Text));
com.Parameters.Add(new OracleParameter("CERTIFICATE", tbCertificate.Text));
com.Parameters.Add(new OracleParameter("SUMMARIZE_PROJECT", tbSummarizeProject.Text));
com.Parameters.Add(new OracleParameter("RESULT_TEACHING", tbResultTeaching.Text));
com.Parameters.Add(new OracleParameter("RESULT_ACADEMIC", tbResultAcademic.Text));
com.Parameters.Add(new OracleParameter("DIFFICULTY_PROJECT", tbDifficultyProject.Text));
com.Parameters.Add(new OracleParameter("RESULT_PROJECT", tbResultProject.Text));
com.Parameters.Add(new OracleParameter("RESULT_RESEARCHING", tbResultResearching.Text));
com.Parameters.Add(new OracleParameter("RESULT_OTHER", tbResultOther.Text));
com.Parameters.Add(new OracleParameter("COUNSEL", tbCounsel.Text));
if (FUdocument.HasFile)
{
string CountBase = DatabaseManager.ExecuteString("SELECT COUNT(*) FROM TB_PROJECT WHERE CITIZEN_ID = '" + loginPerson.PS_CITIZEN_ID + "'");
FileInfo fi = new FileInfo(FUdocument.FileName);
string imgFile = "CID=" + loginPerson.PS_CITIZEN_ID + "&count=" + CountBase + fi.Extension;
FUdocument.SaveAs(Server.MapPath("Upload/Project/PDF/" + imgFile));
com.Parameters.Add(new OracleParameter("PDF_FILE", imgFile));
}
else
{
com.Parameters.Add(new OracleParameter("PDF_FILE", DBNull.Value));
}
com.Parameters.Add(new OracleParameter("PRO_ID", int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()))));
com.ExecuteNonQuery();
}
}
ChangeNotification("", "");
Notsuccess.Visible = false;
success.Visible = true;
}
}
private void ReadSelectID()
{
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT COUNTRY_ID, SUB_COUNTRY_ID, CATEGORY_ID, PROJECT_NAME, ADDRESS_PROJECT, START_DATE, END_DATE, EXPENSES, FUNDING, CERTIFICATE, SUMMARIZE_PROJECT, RESULT_TEACHING, RESULT_ACADEMIC, DIFFICULTY_PROJECT, RESULT_PROJECT, RESULT_RESEARCHING, RESULT_OTHER, COUNSEL FROM TB_PROJECT WHERE PRO_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
int i = 0;
ddlCountry.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetInt32(i).ToString(); ++i;
ddlSubCountry.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetInt32(i).ToString(); ++i;
ddlCategory.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetInt32(i).ToString(); ++i;
tbProjectName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbAddressProject.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbStartDate.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd MMM yyyy"); ++i;
tbEndDate.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd MMM yyyy"); ++i;
tbExpenses.Text = reader.IsDBNull(i) ? "" : reader.GetInt32(i).ToString(); ++i;
tbFunding.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbCertificate.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbSummarizeProject.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbResultTeaching.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbResultAcademic.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbDifficultyProject.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbResultProject.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbResultResearching.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbResultOther.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
tbCounsel.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
}
}
}
}
}
public int UPDATE_PERSON()
{
int id = 0;
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_TITLE_ID=:PS_TITLE_ID, PS_FIRSTNAME=:PS_FIRSTNAME, PS_LASTNAME=:PS_LASTNAME, PS_GENDER_ID=:PS_GENDER_ID, PS_BIRTHDAY_DATE=:PS_BIRTHDAY_DATE, PS_EMAIL=:PS_EMAIL, PS_HOMEADD=:PS_HOMEADD, PS_MOO=:PS_MOO, PS_STREET=:PS_STREET, PS_PROVINCE_ID=:PS_PROVINCE_ID, PS_AMPHUR_ID=:PS_AMPHUR_ID, PS_DISTRICT_ID=:PS_DISTRICT_ID, PS_ZIPCODE=:PS_ZIPCODE, PS_TELEPHONE=:PS_TELEPHONE, PS_NATION_ID=:PS_NATION_ID, PS_CAMPUS_ID=:PS_CAMPUS_ID, PS_FACULTY_ID=:PS_FACULTY_ID, PS_DIVISION_ID=:PS_DIVISION_ID, PS_WORK_DIVISION_ID=:PS_WORK_DIVISION_ID, PS_STAFFTYPE_ID=:PS_STAFFTYPE_ID, PS_TIME_CONTACT_ID=:PS_TIME_CONTACT_ID, PS_BUDGET_ID=:PS_BUDGET_ID, PS_SUBSTAFFTYPE_ID=:PS_SUBSTAFFTYPE_ID, PS_ADMIN_POS_ID=:PS_ADMIN_POS_ID, PS_WORK_POS_ID=:PS_WORK_POS_ID, PS_INWORK_DATE=:PS_INWORK_DATE, PS_DATE_START_THIS_U=:PS_DATE_START_THIS_U, PS_SPECIAL_NAME=:PS_SPECIAL_NAME, PS_TEACH_ISCED_ID=:PS_TEACH_ISCED_ID, PS_GRAD_LEV_ID=:PS_GRAD_LEV_ID, PS_GRAD_CURR=:PS_GRAD_CURR, PS_GRAD_ISCED_ID=:PS_GRAD_ISCED_ID, PS_GRAD_PROG_ID=:PS_GRAD_PROG_ID, PS_GRAD_UNIV=:PS_GRAD_UNIV, PS_GRAD_COUNTRY_ID=:PS_GRAD_COUNTRY_ID, PS_DEFORM_ID=:PS_DEFORM_ID, PS_SIT_NO=:PS_SIT_NO, PS_RELIGION_ID=:PS_RELIGION_ID, PS_MOVEMENT_TYPE_ID=:PS_MOVEMENT_TYPE_ID, PS_MOVEMENT_DATE=:PS_MOVEMENT_DATE WHERE PS_CITIZEN_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_TITLE_ID", ddlTitleID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_FIRSTNAME", tbFirstName.Text));
com.Parameters.Add(new OracleParameter("PS_LASTNAME", tbLastName.Text));
com.Parameters.Add(new OracleParameter("PS_GENDER_ID", ddlGenderID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_BIRTHDAY_DATE", Util.ToDateTimeOracle(tbBirthdayDate.Text)));
com.Parameters.Add(new OracleParameter("PS_EMAIL", tbEmail.Text));
com.Parameters.Add(new OracleParameter("PS_HOMEADD", tbHomeAdd.Text));
com.Parameters.Add(new OracleParameter("PS_MOO", tbMoo.Text));
com.Parameters.Add(new OracleParameter("PS_STREET", tbStreet.Text));
if (ddlProvinceID.SelectedIndex == 0)
{
com.Parameters.Add(new OracleParameter("PS_PROVINCE_ID", DBNull.Value));
}
else
{
com.Parameters.Add(new OracleParameter("PS_PROVINCE_ID", ddlProvinceID.SelectedValue));
}
if (ddlAmphurID.SelectedIndex == 0)
{
com.Parameters.Add(new OracleParameter("PS_AMPHUR_ID", DBNull.Value));
}
else
{
com.Parameters.Add(new OracleParameter("PS_AMPHUR_ID", ddlAmphurID.SelectedValue));
}
if (ddlDistrictID.SelectedIndex == 0)
{
com.Parameters.Add(new OracleParameter("PS_DISTRICT_ID", DBNull.Value));
}
else
{
com.Parameters.Add(new OracleParameter("PS_DISTRICT_ID", ddlDistrictID.SelectedValue));
}
com.Parameters.Add(new OracleParameter("PS_ZIPCODE", tbZipcode.Text));
com.Parameters.Add(new OracleParameter("PS_TELEPHONE", tbTelephone.Text));
com.Parameters.Add(new OracleParameter("PS_NATION_ID", ddlNationID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_CAMPUS_ID", ddlCampusID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_FACULTY_ID", ddlFacultyID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_DIVISION_ID", ddlDivisionID.SelectedValue));
if (ddlWorkDivisionID.SelectedIndex == 0)
{
com.Parameters.Add(new OracleParameter("PS_WORK_DIVISION_ID", DBNull.Value));
}
else
{
com.Parameters.Add(new OracleParameter("PS_WORK_DIVISION_ID", ddlWorkDivisionID.SelectedValue));
}
com.Parameters.Add(new OracleParameter("PS_STAFFTYPE_ID", ddlStafftypeID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_TIME_CONTACT_ID", ddlTimeContactID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_BUDGET_ID", ddlBudgetID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_SUBSTAFFTYPE_ID", ddlSubStafftypeID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_ADMIN_POS_ID", ddlAdminPosID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_WORK_POS_ID", ddlWorkPosID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_INWORK_DATE", Util.ToDateTimeOracle(tbDateInwork.Text)));
com.Parameters.Add(new OracleParameter("PS_DATE_START_THIS_U", Util.ToDateTimeOracle(tbDateStartThisU.Text)));
com.Parameters.Add(new OracleParameter("PS_SPECIAL_NAME", tbSpecialName.Text));
if (ddlTeachIscedID.SelectedIndex == 0)
{
com.Parameters.Add(new OracleParameter("PS_TEACH_ISCED_ID", DBNull.Value));
}
else
{
com.Parameters.Add(new OracleParameter("PS_TEACH_ISCED_ID", ddlTeachIscedID.SelectedValue));
}
com.Parameters.Add(new OracleParameter("PS_GRAD_LEV_ID", ddlGradLevID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_GRAD_CURR", tbGradCurr.Text));
if (ddlGradIscedID.SelectedIndex == 0)
{
com.Parameters.Add(new OracleParameter("PS_GRAD_ISCED_ID", DBNull.Value));
}
else
{
com.Parameters.Add(new OracleParameter("PS_GRAD_ISCED_ID", ddlGradIscedID.SelectedValue));
}
if (ddlGradProgID.SelectedIndex == 0)
{
com.Parameters.Add(new OracleParameter("PS_GRAD_PROG_ID", DBNull.Value));
}
else
{
com.Parameters.Add(new OracleParameter("PS_GRAD_PROG_ID", ddlGradProgID.SelectedValue));
}
com.Parameters.Add(new OracleParameter("PS_GRAD_UNIV", tbGradUniv.Text));
com.Parameters.Add(new OracleParameter("PS_GRAD_COUNTRY_ID", ddlGradCountryID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_DEFORM_ID", ddlDeformID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_SIT_NO", tbSitNo.Text));
com.Parameters.Add(new OracleParameter("PS_RELIGION_ID", ddlReligionID.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_MOVEMENT_TYPE_ID", ddlMovementTypeID.SelectedValue));
if (tbMovementDate.Text == "")
{
com.Parameters.Add(new OracleParameter("PS_MOVEMENT_DATE", DBNull.Value));
}
else
{
com.Parameters.Add(new OracleParameter("PS_MOVEMENT_DATE", Util.ToDateTimeOracle(tbMovementDate.Text)));
}
id = com.ExecuteNonQuery();
}
}
return(id);
}
protected void ReadID()
{
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT PS_CITIZEN_ID,PS_TITLE_ID,PS_FIRSTNAME,PS_LASTNAME,PS_GENDER_ID,PS_BIRTHDAY_DATE,PS_EMAIL,PS_HOMEADD,PS_MOO,PS_STREET,PS_DISTRICT_ID,PS_AMPHUR_ID,PS_PROVINCE_ID,PS_ZIPCODE,PS_TELEPHONE,PS_NATION_ID,PS_CAMPUS_ID,PS_FACULTY_ID,PS_DIVISION_ID,PS_WORK_DIVISION_ID,PS_STAFFTYPE_ID,PS_TIME_CONTACT_ID,PS_BUDGET_ID,PS_SUBSTAFFTYPE_ID,PS_ADMIN_POS_ID,PS_WORK_POS_ID,PS_INWORK_DATE,PS_DATE_START_THIS_U,PS_SPECIAL_NAME,PS_TEACH_ISCED_ID,PS_GRAD_LEV_ID,PS_GRAD_CURR,PS_GRAD_ISCED_ID,PS_GRAD_PROG_ID,PS_GRAD_UNIV,PS_GRAD_COUNTRY_ID,PS_DEFORM_ID,PS_SIT_NO,PS_RELIGION_ID,PS_MOVEMENT_TYPE_ID,PS_MOVEMENT_DATE FROM PS_PERSON WHERE PS_CITIZEN_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
int i = 0;
tbCitizenID.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlTitleID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
tbFirstName.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
tbLastName.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlGenderID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
tbBirthdayDate.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd MMM yyyy"); ++i;
tbEmail.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
tbHomeAdd.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
tbMoo.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
tbStreet.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
//--
ddlProvinceID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlAmphurID.Items.Clear();
string s1 = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
DatabaseManager.BindDropDown(ddlAmphurID, "SELECT * FROM TB_AMPHUR WHERE PROVINCE_ID = '" + ddlProvinceID.SelectedValue + "'", "AMPHUR_TH", "AMPHUR_ID", "--กรุณาเลือก--");
ddlAmphurID.SelectedValue = s1;
//
ddlDistrictID.Items.Clear();
string s2 = reader.IsDBNull(i) ? "0" : reader.GetValue(i).ToString(); ++i;
DatabaseManager.BindDropDown(ddlDistrictID, "SELECT * FROM TB_DISTRICT WHERE AMPHUR_ID = '" + ddlAmphurID.SelectedValue + "'", "DISTRICT_TH", "DISTRICT_ID", "--กรุณาเลือก--");
ddlDistrictID.SelectedValue = s2;
//
tbZipcode.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
tbTelephone.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlNationID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
//--
ddlCampusID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlFacultyID.Items.Clear();
string z1 = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
DatabaseManager.BindDropDown(ddlFacultyID, "SELECT * FROM TB_FACULTY WHERE CAMPUS_ID = '" + ddlCampusID.SelectedValue + "'", "FACULTY_NAME", "FACULTY_ID", "--กรุณาเลือก--");
ddlFacultyID.SelectedValue = z1;
//
ddlDivisionID.Items.Clear();
string z2 = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
DatabaseManager.BindDropDown(ddlDivisionID, "SELECT * FROM TB_DIVISION WHERE FACULTY_ID = '" + ddlFacultyID.SelectedValue + "'", "DIVISION_NAME", "DIVISION_ID", "--กรุณาเลือก--");
ddlDivisionID.SelectedValue = z2;
//
ddlWorkDivisionID.Items.Clear();
string z3 = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
DatabaseManager.BindDropDown(ddlWorkDivisionID, "SELECT * FROM TB_WORK_DIVISION WHERE DIVISION_ID = '" + ddlDivisionID.SelectedValue + "'", "WORK_NAME", "WORK_ID", "--กรุณาเลือก--");
ddlWorkDivisionID.SelectedValue = z3;
//--
ddlStafftypeID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlTimeContactID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlBudgetID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlSubStafftypeID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlAdminPosID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlWorkPosID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
tbDateInwork.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd MMM yyyy"); ++i;
tbDateStartThisU.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd MMM yyyy"); ++i;
tbSpecialName.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlTeachIscedID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlGradLevID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
tbGradCurr.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlGradIscedID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlGradProgID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
tbGradUniv.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlGradCountryID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlDeformID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
tbSitNo.Text = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlReligionID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
ddlMovementTypeID.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i;
tbMovementDate.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd MMM yyyy"); ++i;
}
}
}
}
}
protected void ReadID()
{
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT TITLE_ID, FIRSTNAME, LASTNAME, GENDER_ID, BIRTHDAY_DATE, EMAIL, NATION_ID, CAMPUS_ID, FACULTY_ID, DIVISION_ID, WORK_DIVISION_ID, STAFFTYPE_ID, TIME_CONTACT_ID, BUDGET_ID, SUBSTAFFTYPE_ID, ADMIN_POS_ID, WORK_POS_ID, INWORK_DATE, DATE_START_THIS_U, SPECIAL_NAME, TEACH_ISCED_ID, GRAD_LEV_ID, GRAD_CURR, GRAD_ISCED_ID, GRAD_PROG_ID, GRAD_UNIV, GRAD_COUNTRY_ID, DEFORM_ID, RELIGION_ID, (SELECT TITLE_NAME_TH FROM TB_TITLENAME WHERE TB_TITLENAME.TITLE_ID = TB_REQUEST.TITLE_ID) TITLE_NAME, (SELECT GENDER_NAME FROM TB_GENDER WHERE TB_GENDER.GENDER_ID = TB_REQUEST.GENDER_ID) GENDER_NAME, (SELECT NATION_NAME_EN FROM TB_NATION WHERE TB_NATION.NATION_ID = TB_REQUEST.NATION_ID) NATION_NAME, (SELECT CAMPUS_NAME FROM TB_CAMPUS WHERE TB_CAMPUS.CAMPUS_ID = TB_REQUEST.CAMPUS_ID) CAMPUS_NAME, (SELECT FACULTY_NAME FROM TB_FACULTY WHERE TB_FACULTY.FACULTY_ID = TB_REQUEST.FACULTY_ID) FACULTY_NAME, (SELECT DIVISION_NAME FROM TB_DIVISION WHERE TB_DIVISION.DIVISION_ID = TB_REQUEST.DIVISION_ID) DIVISION_NAME, (SELECT WORK_NAME FROM TB_WORK_DIVISION WHERE TB_WORK_DIVISION.WORK_ID = TB_REQUEST.WORK_DIVISION_ID) WORK_DIVISION_NAME, (SELECT STAFFTYPE_NAME FROM TB_STAFFTYPE WHERE TB_STAFFTYPE.STAFFTYPE_ID = TB_REQUEST.STAFFTYPE_ID) STAFFTYPE_NAME, (SELECT TIME_CONTACT_NAME FROM TB_TIME_CONTACT WHERE TB_TIME_CONTACT.TIME_CONTACT_ID = TB_REQUEST.TIME_CONTACT_ID) TIME_CONTACT_NAME, (SELECT BUDGET_NAME FROM TB_BUDGET WHERE TB_BUDGET.BUDGET_ID = TB_REQUEST.BUDGET_ID) BUDGET_NAME, (SELECT SUBSTAFFTYPE_NAME FROM TB_SUBSTAFFTYPE WHERE TB_SUBSTAFFTYPE.SUBSTAFFTYPE_ID = TB_REQUEST.SUBSTAFFTYPE_ID) SUBSTAFFTYPE_NAME, (SELECT ADMIN_POSITION_NAME FROM TB_ADMIN_POSITION WHERE TB_ADMIN_POSITION.ADMIN_POSITION_ID = TB_REQUEST.ADMIN_POS_ID) ADMIN_POSITION_NAME, (SELECT POSITION_WORK_NAME FROM TB_POSITION_WORK WHERE TB_POSITION_WORK.POSITION_WORK_ID = TB_REQUEST.WORK_POS_ID) WORK_POS_NAME, (SELECT ISCED_NAME FROM TB_ISCED WHERE TB_ISCED.ISCED_ID = TB_REQUEST.TEACH_ISCED_ID) TEACH_ISCED_NAME, (SELECT LEV_NAME_TH FROM TB_LEV WHERE TB_LEV.LEV_ID = TB_REQUEST.GRAD_LEV_ID) GRAD_LEV_NAME, (SELECT ISCED_NAME FROM TB_ISCED WHERE TB_ISCED.ISCED_ID = TB_REQUEST.GRAD_ISCED_ID) GRAD_ISCED_NAME, (SELECT PROGRAM_NAME FROM TB_PROGRAM WHERE TB_PROGRAM.PROGRAM_ID_NEW = TB_REQUEST.GRAD_PROG_ID) GRAD_PROG_NAME, (SELECT NATION_NAME_EN FROM TB_NATION WHERE TB_NATION.NATION_ID = TB_REQUEST.GRAD_COUNTRY_ID) GRAD_COUNTRY_NAME, (SELECT DEFORM_NAME FROM TB_DEFORM WHERE TB_DEFORM.DEFORM_ID = TB_REQUEST.DEFORM_ID) DEFORM_NAME, (SELECT RELIGION_NAME FROM TB_RELIGION WHERE TB_RELIGION.RELIGION_ID = TB_REQUEST.RELIGION_ID) RELIGION_NAME FROM TB_REQUEST WHERE R_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
int i = 0;
if (reader.IsDBNull(i))
{
trTitleID.Visible = false;
}
else
{
ddlTitleID.SelectedValue = reader.GetValue(i).ToString(); ddlTitleID2.Text = reader.GetValue(29).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trFirstName.Visible = false;
}
else
{
tbFirstName.Text = reader.GetValue(i).ToString(); tbFirstName2.Text = reader.GetValue(i).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trLastName.Visible = false;
}
else
{
tbLastName.Text = reader.GetValue(i).ToString(); tbLastName2.Text = reader.GetValue(i).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trGenderID.Visible = false;
}
else
{
ddlGenderID.SelectedValue = reader.GetValue(i).ToString(); ddlGenderID2.Text = reader.GetValue(30).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trBirthdayDate.Visible = false;
}
else
{
tbBirthdayDate.Text = reader.GetDateTime(i).ToString("dd MMM yyyy"); tbBirthdayDate2.Text = reader.GetDateTime(i).ToString("dd MMM yyyy");
}
++i;
if (reader.IsDBNull(i))
{
trEmail.Visible = false;
}
else
{
tbEmail.Text = reader.GetValue(i).ToString(); tbEmail2.Text = reader.GetValue(i).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trNationID.Visible = false;
}
else
{
ddlNationID.SelectedValue = reader.GetValue(i).ToString(); ddlNationID2.Text = reader.GetValue(31).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trCampusID.Visible = false;
}
else
{
ddlCampusID.SelectedValue = reader.GetValue(i).ToString(); ddlCampusID2.Text = reader.GetValue(32).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trFacultyID.Visible = false;
}
else
{
ddlFacultyID.Items.Clear();
string z1 = reader.GetValue(i).ToString();
DatabaseManager.BindDropDown(ddlFacultyID, "SELECT * FROM TB_FACULTY WHERE CAMPUS_ID = '" + ddlCampusID.SelectedValue + "'", "FACULTY_NAME", "FACULTY_ID", "--กรุณาเลือก--");
ddlFacultyID.SelectedValue = z1;
ddlFacultyID2.Text = reader.GetValue(33).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trDivisionID.Visible = false;
}
else
{
ddlDivisionID.Items.Clear();
string z2 = reader.GetValue(i).ToString();
DatabaseManager.BindDropDown(ddlDivisionID, "SELECT * FROM TB_DIVISION WHERE DIVISION_ID = '" + ddlDivisionID.SelectedValue + "'", "DIVISION_NAME", "DIVISION_ID", "--กรุณาเลือก--");
ddlDivisionID.SelectedValue = z2;
ddlDivisionID2.Text = reader.GetValue(34).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trWorkDivisionID.Visible = false;
}
else
{
ddlWorkDivisionID.Items.Clear();
string z3 = reader.GetValue(i).ToString();
DatabaseManager.BindDropDown(ddlWorkDivisionID, "SELECT * FROM TB_WORK_DIVISION WHERE WORK_ID = '" + ddlWorkDivisionID.SelectedValue + "'", "WORK_NAME", "WORK_ID", "--กรุณาเลือก--");
ddlWorkDivisionID.SelectedValue = z3;
ddlWorkDivisionID2.Text = reader.GetValue(35).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trStafftypeID.Visible = false;
}
else
{
ddlStafftypeID.SelectedValue = reader.GetValue(i).ToString(); ddlStafftypeID2.Text = reader.GetValue(36).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trTimeContactID.Visible = false;
}
else
{
ddlTimeContactID.SelectedValue = reader.GetValue(i).ToString(); ddlTimeContactID2.Text = reader.GetValue(37).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trBudgetID.Visible = false;
}
else
{
ddlBudgetID.SelectedValue = reader.GetValue(i).ToString(); ddlBudgetID2.Text = reader.GetValue(38).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trSubStafftypeID.Visible = false;
}
else
{
ddlSubStafftypeID.SelectedValue = reader.GetValue(i).ToString(); ddlSubStafftypeID2.Text = reader.GetValue(39).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trAdminPosID.Visible = false;
}
else
{
ddlAdminPosID.SelectedValue = reader.GetValue(i).ToString(); ddlAdminPosID2.Text = reader.GetValue(40).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trWorkPosID.Visible = false;
}
else
{
ddlWorkPosID.SelectedValue = reader.GetValue(i).ToString(); ddlWorkPosID2.Text = reader.GetValue(41).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trDateInwork.Visible = false;
}
else
{
tbDateInwork.Text = reader.GetDateTime(i).ToString("dd MMM yyyy"); tbDateInwork2.Text = reader.GetDateTime(i).ToString("dd MMM yyyy");
}
++i;
if (reader.IsDBNull(i))
{
trDateStartThisU.Visible = false;
}
else
{
tbDateStartThisU.Text = reader.GetDateTime(i).ToString("dd MMM yyyy"); tbDateStartThisU2.Text = reader.GetDateTime(i).ToString("dd MMM yyyy");
}
++i;
if (reader.IsDBNull(i))
{
trSpecialName.Visible = false;
}
else
{
tbSpecialName.Text = reader.GetValue(i).ToString(); tbSpecialName2.Text = reader.GetValue(i).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trTeachIscedID.Visible = false;
}
else
{
ddlTeachIscedID.SelectedValue = reader.GetValue(i).ToString(); ddlTeachIscedID2.Text = reader.GetValue(42).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trGradLevID.Visible = false;
}
else
{
ddlGradLevID.SelectedValue = reader.GetValue(i).ToString(); ddlGradLevID2.Text = reader.GetValue(43).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trGradCurr.Visible = false;
}
else
{
tbGradCurr.Text = reader.GetValue(i).ToString(); tbGradCurr2.Text = reader.GetValue(i).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trGradIscedID.Visible = false;
}
else
{
ddlGradIscedID.SelectedValue = reader.GetValue(i).ToString(); ddlGradIscedID2.Text = reader.GetValue(44).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trGradProgID.Visible = false;
}
else
{
ddlGradProgID.SelectedValue = reader.GetValue(i).ToString(); ddlGradProgID2.Text = reader.GetValue(45).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trGradUniv.Visible = false;
}
else
{
tbGradUniv.Text = reader.GetValue(i).ToString(); tbGradUniv2.Text = reader.GetValue(i).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trGradCountryID.Visible = false;
}
else
{
ddlGradCountryID.SelectedValue = reader.GetValue(i).ToString(); ddlGradCountryID2.Text = reader.GetValue(46).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trDeformID.Visible = false;
}
else
{
ddlDeformID.SelectedValue = reader.GetValue(i).ToString(); ddlDeformID2.Text = reader.GetValue(47).ToString();
}
++i;
if (reader.IsDBNull(i))
{
trReligionID.Visible = false;
}
else
{
ddlReligionID.SelectedValue = reader.GetValue(i).ToString(); ddlReligionID2.Text = reader.GetValue(48).ToString();
}
++i;
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("ListRequest.aspx");
return;
}
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
loginPerson = ps.LoginPerson;
Citizen_id = DatabaseManager.ExecuteString("SELECT CITIZEN_ID FROM TB_REQUEST WHERE R_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'");
Person QueryString = DatabaseManager.GetPerson(Citizen_id);
if (loginPerson.PERSON_ROLE_ID != "2")
{
Server.Transfer("NoPermission.aspx");
}
if (!IsPostBack)
{
BindDDL();
ReadID();
ReadRequest();
}
lbTitleID.Text = Util.IsBlank(QueryString.PS_TITLE_NAME) ? "-" : QueryString.PS_TITLE_NAME;
lbFirstName.Text = Util.IsBlank(QueryString.PS_FIRSTNAME) ? "-" : QueryString.PS_FIRSTNAME;
lbLastName.Text = Util.IsBlank(QueryString.PS_LASTNAME) ? "-" : QueryString.PS_LASTNAME;
lbGenderID.Text = Util.IsBlank(QueryString.PS_GENDER_NAME) ? "-" : QueryString.PS_GENDER_NAME;
lbBirthdayDate.Text = Util.IsBlank(QueryString.PS_BIRTHDAY_DATE.ToString()) ? "-" : QueryString.PS_BIRTHDAY_DATE.Value.ToLongDateString();
lbEmail.Text = Util.IsBlank(QueryString.PS_EMAIL) ? "-" : QueryString.PS_EMAIL;
lbNationID.Text = Util.IsBlank(QueryString.PS_NATION_NAME) ? "-" : QueryString.PS_NATION_NAME;
lbCampusID.Text = Util.IsBlank(QueryString.PS_CAMPUS_NAME) ? "-" : QueryString.PS_CAMPUS_NAME;
lbFacultyID.Text = Util.IsBlank(QueryString.PS_FACULTY_NAME) ? "-" : QueryString.PS_FACULTY_NAME;
lbDivisionID.Text = Util.IsBlank(QueryString.PS_DIVISION_NAME) ? "-" : QueryString.PS_DIVISION_NAME;
lbWorkDivisionID.Text = Util.IsBlank(QueryString.PS_WORK_DIVISION_NAME) ? "-" : QueryString.PS_WORK_DIVISION_NAME;
lbStafftypeID.Text = Util.IsBlank(QueryString.PS_STAFFTYPE_NAME) ? "-" : QueryString.PS_STAFFTYPE_NAME;
lbTimeContactID.Text = Util.IsBlank(QueryString.PS_TIME_CONTACT_NAME) ? "-" : QueryString.PS_TIME_CONTACT_NAME;
lbBudgetID.Text = Util.IsBlank(QueryString.PS_BUDGET_NAME) ? "-" : QueryString.PS_BUDGET_NAME;
lbSubStafftypeID.Text = Util.IsBlank(QueryString.PS_SUBSTAFFTYPE_NAME) ? "-" : QueryString.PS_SUBSTAFFTYPE_NAME;
lbAdminPosID.Text = Util.IsBlank(QueryString.PS_ADMIN_POS_NAME) ? "-" : QueryString.PS_ADMIN_POS_NAME;
lbWorkPosID.Text = Util.IsBlank(QueryString.PS_WORK_POS_NAME) ? "-" : QueryString.PS_WORK_POS_NAME;
lbDateInwork.Text = Util.IsBlank(QueryString.PS_INWORK_DATE.ToString()) ? "-" : QueryString.PS_INWORK_DATE.Value.ToLongDateString();
lbDateStartThisU.Text = Util.IsBlank(QueryString.PS_DATE_START_THIS_U.ToString()) ? "-" : QueryString.PS_DATE_START_THIS_U.Value.ToLongDateString();
lbSpecialName.Text = Util.IsBlank(QueryString.PS_SPECIAL_NAME) ? "-" : QueryString.PS_SPECIAL_NAME;
lbTeachIscedID.Text = Util.IsBlank(QueryString.PS_TEACH_ISCED_NAME) ? "-" : QueryString.PS_TEACH_ISCED_NAME;
lbGradLevID.Text = Util.IsBlank(QueryString.PS_GRAD_LEV_NAME) ? "-" : QueryString.PS_GRAD_LEV_NAME;
lbGradCurr.Text = Util.IsBlank(QueryString.PS_GRAD_CURR) ? "-" : QueryString.PS_GRAD_CURR;
lbGradIscedID.Text = Util.IsBlank(QueryString.PS_GRAD_ISCED_NAME) ? "-" : QueryString.PS_GRAD_ISCED_NAME;
lbGradProgID.Text = Util.IsBlank(QueryString.PS_GRAD_PROG_NAME) ? "-" : QueryString.PS_GRAD_PROG_NAME;
lbGradUniv.Text = Util.IsBlank(QueryString.PS_GRAD_UNIV) ? "-" : QueryString.PS_GRAD_UNIV;
lbGradCountryID.Text = Util.IsBlank(QueryString.PS_GRAD_COUNTRY_NAME) ? "-" : QueryString.PS_GRAD_COUNTRY_NAME;
lbDeformID.Text = Util.IsBlank(QueryString.PS_DEFORM_NAME) ? "-" : QueryString.PS_DEFORM_NAME;
lbReligionID.Text = Util.IsBlank(QueryString.PS_RELIGION_NAME) ? "-" : QueryString.PS_RELIGION_NAME;
}
protected void btnUpdatePosition_Click(object sender, EventArgs e)
{
string ValueID = ddlInsertIdPosition.SelectedValue;
string ValueDate = Util.ToDateTimeOracle(tbInsertDatePosition.Text).ToString();
if (Session["DefaultIdPosition"] == null)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('กรุณาเลือกรายการที่จะแก้ไขก่อน')", true);
return;
}
if (Util.ToDateTimeOracle(tbInsertDatePosition.Text) > DateTime.Now)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('วันที่ไม่สามารถมากกว่าวันปัจจุบัน')", true);
return;
}
bool ok = false;
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT * FROM (SELECT GET_DATE FROM PS_POSITION_HISTORY WHERE CITIZEN_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "' ORDER BY GET_DATE DESC) WHERE ROWNUM = 1", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
DateTime getDate = reader.GetDateTime(0).AddDays(-1);
if (Util.ToDateTimeOracle(tbInsertDatePosition.Text) > getDate)
{
ok = false;
}
else
{
ok = true;
}
}
}
}
}
if (ok)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('วันที่ไม่ถูกต้อง')", true);
}
else
{
if (ValueID != "" && ValueDate != "")
{
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("UPDATE PS_POSITION_HISTORY SET P_ID = :P_ID, GET_DATE = :GET_DATE WHERE PH_ID = :PH_ID", con))
{
com.Parameters.Add(new OracleParameter("P_ID", ValueID));
com.Parameters.Add(new OracleParameter("GET_DATE", Util.ToDateTimeOracle(tbInsertDatePosition.Text)));
com.Parameters.Add(new OracleParameter("PH_ID", Session["DefaultIdPosition"].ToString()));
com.ExecuteNonQuery();
}
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_POSITION_ID = :PS_POSITION_ID WHERE PS_CITIZEN_ID = :PS_CITIZEN_ID", con))
{
com.Parameters.Add(new OracleParameter("PS_POSITION_ID", ddlInsertIdPosition.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.ExecuteNonQuery();
}
//----------
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_FIRST_POSITION_ID = (SELECT P_ID FROM PS_POSITION_HISTORY WHERE CITIZEN_ID = :CITIZEN_ID AND GET_DATE = (SELECT MIN(GET_DATE) FROM PS_POSITION_HISTORY WHERE CITIZEN_ID = :CITIZEN_ID)) WHERE PS_CITIZEN_ID = :CITIZEN_ID", con))
{
com.Parameters.Add(new OracleParameter("CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.ExecuteNonQuery();
}
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('อัพเดทข้อมูลเรียบร้อย')", true);
BindPosition();
ClearPosition();
Session.Remove("DefaultIdPosition");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this);
loginPerson = ps.LoginPerson;
Citizen_id = DatabaseManager.ExecuteString("SELECT PS_CITIZEN_ID FROM PS_PERSON WHERE PS_CITIZEN_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'");
QueryString = DatabaseManager.GetPerson(Citizen_id);
if (loginPerson.PERSON_ROLE_ID != "2")
{
Server.Transfer("NoPermission.aspx");
}
if (Request.QueryString["id"] == null)
{
Response.Redirect("ListPerson-ADMIN.aspx");
}
if (!IsPostBack)
{
if (QueryString.PS_STAFFTYPE_ID == "1" || QueryString.PS_STAFFTYPE_ID == "5")
{
BindPosition();
}
}
}
private void ReadSelectID()
{
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT (SELECT (SELECT TITLE_NAME_TH FROM TB_TITLENAME WHERE PS_PERSON.PS_TITLE_ID = TB_TITLENAME.TITLE_ID) || ' ' || PS_FIRSTNAME || ' ' || PS_LASTNAME FROM PS_PERSON WHERE PS_PERSON.PS_CITIZEN_ID = TB_PROJECT.CITIZEN_ID) NAME, (SELECT (SELECT POSITION_WORK_NAME FROM TB_POSITION_WORK WHERE TB_POSITION_WORK.POSITION_WORK_ID = PS_PERSON.PS_WORK_POS_ID) FROM PS_PERSON WHERE PS_PERSON.PS_CITIZEN_ID = TB_PROJECT.CITIZEN_ID) POSITION_NAME, (SELECT (SELECT ADMIN_POSITION_NAME FROM TB_ADMIN_POSITION WHERE TB_ADMIN_POSITION.ADMIN_POSITION_ID = PS_PERSON.PS_ADMIN_POS_ID) FROM PS_PERSON WHERE PS_PERSON.PS_CITIZEN_ID = TB_PROJECT.CITIZEN_ID) DEGREE_NAME, (SELECT (SELECT CAMPUS_NAME FROM TB_CAMPUS WHERE TB_CAMPUS.CAMPUS_ID = PS_PERSON.PS_CAMPUS_ID) || ' ' || (SELECT FACULTY_NAME FROM TB_FACULTY WHERE TB_FACULTY.FACULTY_ID = PS_PERSON.PS_FACULTY_ID) || ' ' || (SELECT DIVISION_NAME FROM TB_DIVISION WHERE TB_DIVISION.DIVISION_ID = PS_PERSON.PS_DIVISION_ID) || ' ' || (SELECT WORK_NAME FROM TB_WORK_DIVISION WHERE TB_WORK_DIVISION.WORK_ID = PS_PERSON.PS_WORK_DIVISION_ID) FROM PS_PERSON WHERE PS_PERSON.PS_CITIZEN_ID = TB_PROJECT.CITIZEN_ID) DEPARTMENT_NAME, PROJECT_NAME, ADDRESS_PROJECT, START_DATE, END_DATE, EXPENSES, FUNDING, CERTIFICATE, SUMMARIZE_PROJECT, RESULT_TEACHING, RESULT_ACADEMIC, DIFFICULTY_PROJECT, RESULT_PROJECT, RESULT_RESEARCHING, RESULT_OTHER, COUNSEL FROM TB_PROJECT WHERE PRO_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
int i = 0;
lbName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbPosition.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbDegree.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbDepartment.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbNameProject.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbAddressProject.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbDateStart.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd MMM yyyy"); ++i;
lbDateEnd.Text = reader.IsDBNull(i) ? "" : reader.GetDateTime(i).ToString("dd MMM yyyy"); ++i;
lbExpense.Text = reader.IsDBNull(i) ? "0" : reader.GetInt32(i).ToString("#,###"); ++i;
lbFunding.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbCertificate.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbSummaryProject.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbResultTeaching.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbResultAcademic.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbDifficultyProject.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbResultProject.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbResultResearching.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbResultOther.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
lbCounsel.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i;
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["id"] == null)
{
Response.Redirect("listproject-admin.aspx");
}
if (!IsPostBack)
{
ReadSelectID();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT START_DATE,END_DATE FROM TB_PROJECT WHERE PRO_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
int i = 0;
string start = reader.GetDateTime(i).ToString("dd MMM yyyy"); ++i;
string end = reader.GetDateTime(i).ToString("dd MMM yyyy"); ++i;
if (!reader.IsDBNull(0) && !reader.IsDBNull(1))
{
DateTime df = DateTime.Parse(start);
DateTime dt = DateTime.Parse(end);
int day = (int)(dt - df).TotalDays + 1;
int year = (day / 365);
int month = (day % 365) / 30;
day = (day % 365) % 30;
lbcalYear.Text = "" + year;
lbcalMonth.Text = "" + month;
lbcalDay.Text = "" + day;
}
}
}
}
}
}
}
protected void lbuAllow_Click(object sender, EventArgs e)
{
if (rbAllow.Checked)
{
UPDATE_PERSON();
DataShow.Visible = false;
Accept.Visible = true;
//ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('บันทึกข้อมูลเรียบร้อย')", true);
}
else if (rbNotAllow.Checked)
{
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("UPDATE TB_REQUEST SET DATE_END=:DATE_END, R_STATUS_ID=:R_STATUS_ID, COMMENT_INFO=:COMMENT_INFO, R_ALLOW=:R_ALLOW WHERE R_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'", con))
{
com.Parameters.Add(new OracleParameter("DATE_END", DateTime.Today));
com.Parameters.Add(new OracleParameter("R_STATUS_ID", "4"));
com.Parameters.Add(new OracleParameter("COMMENT_INFO", tbComment.Text));
com.Parameters.Add(new OracleParameter("R_ALLOW", "2"));
com.ExecuteNonQuery();
}
}
DataShow.Visible = false;
NoAccept.Visible = true;
}
}
protected void ReadRequest()
{
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT DATE_START FROM TB_REQUEST WHERE R_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
lbDateReq.Text = reader.GetDateTime(0).ToLongDateString();
}
}
}
}
}
protected void btnInsertPosition_Click(object sender, EventArgs e)
{
string oldID = DatabaseManager.ExecuteString("SELECT P_ID FROM PS_POSITION_HISTORY WHERE P_ID ='" + ddlInsertIdPosition.SelectedValue + "' AND CITIZEN_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'");
if (ddlInsertIdPosition.SelectedValue == oldID)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('มีชื่อระดับตำแหน่ง " + ddlInsertIdPosition.SelectedItem.ToString() + " อยู่แล้วไม่สามารถเพิ่มได้')", true);
return;
}
if (Util.ToDateTimeOracle(tbInsertDatePosition.Text) > DateTime.Now)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('วันที่ไม่สามารถมากกว่าวันปัจจุบัน')", true);
return;
}
bool ok = false;
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
//int salary = DatabaseManager.ExecuteInt("SELECT * FROM (SELECT GET_DATE FROM PS_POSITION_HISTORY WHERE CITIZEN_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "' ORDER BY GET_DATE DESC) WHERE ROWNUM = 1");
using (OracleCommand com = new OracleCommand("SELECT * FROM (SELECT GET_DATE FROM PS_POSITION_HISTORY WHERE CITIZEN_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "' ORDER BY GET_DATE DESC) WHERE ROWNUM = 1", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
DateTime getDate = reader.GetDateTime(0);
if (Util.ToDateTimeOracle(tbInsertDatePosition.Text) > getDate)
{
ok = false;
}
else
{
ok = true;
}
}
}
}
}
if (ok)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('วันที่ไม่ถูกต้อง')", true);
}
else
{
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
string CheckFrist = DatabaseManager.ExecuteString("SELECT COUNT(*) FROM PS_POSITION_HISTORY WHERE CITIZEN_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'");
using (OracleCommand com = new OracleCommand("INSERT INTO PS_POSITION_HISTORY (CITIZEN_ID,P_ID,GET_DATE) VALUES (:CITIZEN_ID,:P_ID,:GET_DATE)", con))
{
com.Parameters.Add(new OracleParameter("CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.Parameters.Add(new OracleParameter("P_ID", ddlInsertIdPosition.SelectedValue));
com.Parameters.Add(new OracleParameter("GET_DATE", Util.ToDateTimeOracle(tbInsertDatePosition.Text)));
com.ExecuteNonQuery();
}
if (CheckFrist == "0")
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_POSITION_ID = :PS_POSITION_ID, PS_FIRST_POSITION_ID = :PS_FIRST_POSITION_ID WHERE PS_CITIZEN_ID = :PS_CITIZEN_ID", con))
{
com.Parameters.Add(new OracleParameter("PS_CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.Parameters.Add(new OracleParameter("PS_POSITION_ID", ddlInsertIdPosition.SelectedValue));
com.Parameters.Add(new OracleParameter("PS_FIRST_POSITION_ID", ddlInsertIdPosition.SelectedValue));
com.ExecuteNonQuery();
}
}
else
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_POSITION_ID = :PS_POSITION_ID WHERE PS_CITIZEN_ID = :PS_CITIZEN_ID", con))
{
com.Parameters.Add(new OracleParameter("PS_CITIZEN_ID", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())));
com.Parameters.Add(new OracleParameter("PS_POSITION_ID", ddlInsertIdPosition.SelectedValue));
com.ExecuteNonQuery();
}
}
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('เพิ่มข้อมูลเรียบร้อย')", true);
BindPosition();
ClearPosition();
}
}
//
protected void BindSalary()
{
OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING);
OracleDataAdapter sda = new OracleDataAdapter("SELECT SALARY_ID, SALARY, POSITION_SALARY, RESULT1, PERCENT_SALARY1, RESULT2, PERCENT_SALARY2, DO_DATE FROM PS_SALARY WHERE CITIZEN_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "' ORDER BY DO_DATE ASC", con);
DataTable dt = new DataTable();
sda.Fill(dt);
myRepeaterSalary.DataSource = dt;
myRepeaterSalary.DataBind();
}
public int UPDATE_PERSON()
{
int id = 0;
OracleConnection.ClearAllPools();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
if (trTitleID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_TITLE_ID=:PS_TITLE_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_TITLE_ID", ddlTitleID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trFirstName.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_FIRSTNAME=:PS_FIRSTNAME WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_FIRSTNAME", tbFirstName.Text));
com.ExecuteNonQuery();
}
}
if (trLastName.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_LASTNAME=:PS_LASTNAME WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_LASTNAME", tbLastName.Text));
com.ExecuteNonQuery();
}
}
if (trGenderID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_GENDER_ID=:PS_GENDER_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_GENDER_ID", ddlGenderID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trBirthdayDate.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_BIRTHDAY_DATE=:PS_BIRTHDAY_DATE WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_BIRTHDAY_DATE", Util.ToDateTimeOracle(tbBirthdayDate.Text)));
com.ExecuteNonQuery();
}
}
if (trEmail.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_EMAIL=:PS_EMAIL WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_EMAIL", tbEmail.Text));
com.ExecuteNonQuery();
}
}
if (trNationID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_NATION_ID=:PS_NATION_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_NATION_ID", ddlNationID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trCampusID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_CAMPUS_ID=:PS_CAMPUS_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_CAMPUS_ID", ddlCampusID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trFacultyID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_FACULTY_ID=:PS_FACULTY_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_FACULTY_ID", ddlFacultyID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trDivisionID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_DIVISION_ID=:PS_DIVISION_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_DIVISION_ID", ddlDivisionID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trWorkDivisionID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_WORK_DIVISION_ID=:PS_WORK_DIVISION_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_WORK_DIVISION_ID", ddlWorkDivisionID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trStafftypeID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_STAFFTYPE_ID=:PS_STAFFTYPE_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_STAFFTYPE_ID", ddlStafftypeID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trTimeContactID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_TIME_CONTACT_ID=:PS_TIME_CONTACT_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_TIME_CONTACT_ID", ddlTimeContactID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trBudgetID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_BUDGET_ID=:PS_BUDGET_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_BUDGET_ID", ddlBudgetID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trSubStafftypeID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_SUBSTAFFTYPE_ID=:PS_SUBSTAFFTYPE_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_SUBSTAFFTYPE_ID", ddlSubStafftypeID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trAdminPosID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_ADMIN_POS_ID=:PS_ADMIN_POS_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_ADMIN_POS_ID", ddlAdminPosID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trWorkPosID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_WORK_POS_ID=:PS_WORK_POS_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_WORK_POS_ID", ddlWorkPosID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trDateInwork.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_INWORK_DATE=:PS_INWORK_DATE WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_INWORK_DATE", Util.ToDateTimeOracle(tbDateInwork.Text)));
com.ExecuteNonQuery();
}
}
if (trDateStartThisU.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_DATE_START_THIS_U=:PS_DATE_START_THIS_U WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_DATE_START_THIS_U", Util.ToDateTimeOracle(tbDateStartThisU.Text)));
com.ExecuteNonQuery();
}
}
if (trSpecialName.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_SPECIAL_NAME=:PS_SPECIAL_NAME WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_SPECIAL_NAME", tbSpecialName.Text));
com.ExecuteNonQuery();
}
}
if (trTeachIscedID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_TEACH_ISCED_ID=:PS_TEACH_ISCED_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_TEACH_ISCED_ID", ddlTeachIscedID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trGradLevID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_GRAD_LEV_ID=:PS_GRAD_LEV_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_GRAD_LEV_ID", ddlGradLevID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trGradCurr.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_GRAD_CURR=:PS_GRAD_CURR WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_GRAD_CURR", tbGradCurr.Text));
com.ExecuteNonQuery();
}
}
if (trGradIscedID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_GRAD_ISCED_ID=:PS_GRAD_ISCED_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_GRAD_ISCED_ID", ddlGradIscedID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trGradProgID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_GRAD_PROG_ID=:PS_GRAD_PROG_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_GRAD_PROG_ID", ddlGradProgID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trGradUniv.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_GRAD_UNIV=:PS_GRAD_UNIV WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_GRAD_UNIV", tbGradUniv.Text));
com.ExecuteNonQuery();
}
}
if (trGradCountryID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_GRAD_COUNTRY_ID=:PS_GRAD_COUNTRY_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_GRAD_COUNTRY_ID", ddlGradCountryID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trDeformID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_DEFORM_ID=:PS_DEFORM_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_DEFORM_ID", ddlDeformID.SelectedValue));
com.ExecuteNonQuery();
}
}
if (trReligionID.Visible == true)
{
using (OracleCommand com = new OracleCommand("UPDATE PS_PERSON SET PS_RELIGION_ID=:PS_RELIGION_ID WHERE PS_CITIZEN_ID = '" + Citizen_id + "'", con))
{
com.Parameters.Add(new OracleParameter("PS_RELIGION_ID", ddlReligionID.SelectedValue));
com.ExecuteNonQuery();
}
}
/*/*/
using (OracleCommand com = new OracleCommand("UPDATE TB_REQUEST SET DATE_END=:DATE_END, R_STATUS_ID=:R_STATUS_ID, COMMENT_INFO=:COMMENT_INFO, R_ALLOW=:R_ALLOW WHERE R_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'", con))
{
com.Parameters.Add(new OracleParameter("DATE_END", DateTime.Today));
com.Parameters.Add(new OracleParameter("R_STATUS_ID", "2"));
com.Parameters.Add(new OracleParameter("COMMENT_INFO", tbComment.Text));
com.Parameters.Add(new OracleParameter("R_ALLOW", "1"));
id = com.ExecuteNonQuery();
}
}
return(id);
}
//
protected void BindPosition()
{
OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING);
OracleDataAdapter sda = new OracleDataAdapter("SELECT PH_ID,P_ID,(SELECT P_NAME FROM TB_POSITION WHERE TB_POSITION.P_ID = PS_POSITION_HISTORY.P_ID)P_NAME, GET_DATE FROM PS_POSITION_HISTORY WHERE CITIZEN_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "' ORDER BY GET_DATE ASC", con);
DataTable dt = new DataTable();
sda.Fill(dt);
myRepeaterPosition.DataSource = dt;
myRepeaterPosition.DataBind();
if (QueryString.PS_STAFFTYPE_ID == "1")
{
DatabaseManager.BindDropDown(ddlInsertIdPosition, "SELECT * FROM TB_POSITION WHERE P_STAFFTYPE_ID = 1 ORDER BY ABS(P_ID) ASC", "P_NAME", "P_ID", "--กรุณาเลือก--");
}
else if (QueryString.PS_STAFFTYPE_ID == "5")
{
DatabaseManager.BindDropDown(ddlInsertIdPosition, "SELECT * FROM TB_POSITION WHERE P_STAFFTYPE_ID = 5 ORDER BY ABS(P_ID) ASC", "P_NAME", "P_ID", "--กรุณาเลือก--");
}
}
private void ReadFile()
{
List <int> pro_id = new List <int>();
List <string> pdf_file = new List <string>();
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
using (OracleCommand com = new OracleCommand("SELECT PRO_ID, PDF_FILE FROM TB_PROJECT WHERE PRO_ID = " + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())), con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
if (!reader.IsDBNull(1))
{
pro_id.Add(reader.GetInt32(0));
pdf_file.Add(reader.GetString(1));
}
}
}
}
}
for (int i = 0; i < pro_id.Count; i++)
{
string path = "Upload/Project/PDF/" + pdf_file[i];
int PRO_ID = pro_id[i];
string PDF_FILE = pdf_file[i];
Panel p = new Panel();
p.Style.Add("display", "inline-block");
LinkButton lb = new LinkButton();
lb.Attributes["href"] = path;
lb.Text = "ดูไฟล์แนบ (รูปภาพ,เอกสาร ประกอบการอบรม)";
p.Controls.Add(lb);
file_pdf.Controls.Add(p);
}
}