protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { int.TryParse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), out id); } else { Response.Redirect("listGP7-admin.aspx"); } BindData(); BindDataBase(); } if (HF1.Value != "") { p = HF1.Value; } if (p == null) { selectTab("1"); if (CreateSelectPersonPageLoad(this, "addGP7-admin.aspx")) { return; } } }
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 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); }
public bool CreateSelectPersonPageLoad(Page page, string pageURL) { if (p == null) { p = MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()); HF1.Value = p; return(true); } return(false); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { int.TryParse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), out id); ReadSelectID(); } } }
protected void btnSave5_Click(object sender, EventArgs e) { PS_PUNISHMENT Punish = new PS_PUNISHMENT(); Punish.UOC_ID = Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())); Punish.YEAR = tbYear13.Text; Punish.PUNISH_NAME = tbPunishName13.Text; Punish.REF_DOC = tbRefDoc13.Text; Punish.INSERT_PS_PUNISHMENT(); ClearPunish(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('เพิ่มข้อมูลเรียบร้อย')", true); BindData(); }
protected void btnSave4_Click(object sender, EventArgs e) { PS_TRAINING Training = new PS_TRAINING(); Training.UOC_ID = Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())); Training.TRAINING_NAME = tbCourse12.Text; Training.START_DATE = DateTime.Parse(tbStartDate12.Text); Training.END_DATE = DateTime.Parse(tbEndDate12.Text); Training.DEPARTMENT = tbDepartment12.Text; Training.INSERT_PS_TRAINING(); ClearTraining(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('เพิ่มข้อมูลเรียบร้อย')", true); BindData(); }
protected void btnSave3_Click(object sender, EventArgs e) { PS_PRO_LICENSE PLicense = new PS_PRO_LICENSE(); PLicense.UOC_ID = Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())); PLicense.LICENSE_NAME = tbLicenseName11.Text; PLicense.DEPARTMENT = tbDepartment11.Text; PLicense.LICENSE_NUMBER = tbLicenseNumber11.Text; PLicense.START_DATE = DateTime.Parse(tbStartDate11.Text); PLicense.INSERT_PS_PRO_LICENSE(); ClearPLicense(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('เพิ่มข้อมูลเรียบร้อย')", true); BindData(); }
protected void lbuDelete_Click(object sender, EventArgs e) { List <int> pro_id = new List <int>(); List <string> img_file = new List <string>(); using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT PRO_ID, IMG_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)); img_file.Add(reader.GetString(1)); } } } } } for (int i = 0; i < pro_id.Count; i++) { string path = "Upload/Project/PDF/" + img_file[i]; int PRO_ID = pro_id[i]; string IMG_FILE = img_file[i]; string pathVS = Server.MapPath("Upload/Project/PDF/" + IMG_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; success.Visible = false; delete.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { int.TryParse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), out id); } else { Response.Redirect("listrequest-admin.aspx"); } if (!IsPostBack) { BindDDL(); ReadSelectID(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { int.TryParse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), out id); ReadSelectID(); } else { Response.Redirect("listproject-admin.aspx"); } 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 = '" + id + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { int i = 0; string start = reader.GetDateTime(i).ToString("dd/MM/yyyy"); ++i; string end = reader.GetDateTime(i).ToString("dd/MM/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 btnSave1_Click(object sender, EventArgs e) { PS_PERSON Pson = new PS_PERSON(); Pson.UOC_ID = Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())); Pson.FATHER_NAME = tbFatherName.Text; Pson.FATHER_LNAME = tbFatherLastName.Text; Pson.MOTHER_NAME = tbMotherName.Text; Pson.MOTHER_LNAME = tbMotherLastName.Text; Pson.MOTHER_ONAME = tbMotherOldLastName.Text; Pson.COUPLE_NAME = tbCoupleName.Text; Pson.COUPLE_LNAME = tbCoupleLastName.Text; Pson.COUPLE_ONAME = tbCoupleOldLastName.Text; Pson.UPDATE_GP7(); ClearGP7(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('เพิ่มข้อมูลเรียบร้อย')", true); BindDataBase(); }
protected void Page_Load(object sender, EventArgs e) { Notsuccess.Visible = true; success.Visible = false; 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 Page_Load(object sender, EventArgs e) { if (MultiView1.ActiveViewIndex == 0) { btnSelectView0.CssClass = "btn btn-info"; btnSelectView1.CssClass = "btn btn-primary"; btnSelectView2.CssClass = "btn btn-primary"; } if (Request.QueryString["id"] != null) { int.TryParse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), out id); BindDDL(); ReadSelectID(); } else { Response.Redirect("listuser-admin.aspx"); } }
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(); }
protected void Page_Load(object sender, EventArgs e) { Notsuccess.Visible = true; success.Visible = false; if (!IsPostBack) { if (Request.QueryString["id"] != null) { int.TryParse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), out id); BindDDL(); ReadSelectID(); } else { Response.Redirect("listproject-admin.aspx"); } string CheckIsNull = DatabaseManager.ExecuteString("SELECT COUNT(IMG_FILE) FROM TB_PROJECT WHERE PRO_ID = " + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + ""); if (CheckIsNull == "0") { lbFile.Visible = true; FUdocument.Visible = true; spFile.InnerText = "*"; spFile.Attributes.Add("class", "ps-lb-red"); spFile.Attributes["style"] = "color:red;"; FUdocument.Attributes.Add("required", "true"); } else { lbFile.Visible = false; FUdocument.Visible = false; spFile.InnerText = ""; spFile.Attributes.Add("class", ""); spFile.Attributes["style"] = ""; FUdocument.Attributes.Add("required", "false"); } } ReadFile(); }
void BindData() { PS_STUDY PStudy = new PS_STUDY(); DataTable dt1 = PStudy.SELECT_PS_STUDY("", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), "", "", "", ""); GridViewStudy.DataSource = dt1; GridViewStudy.DataBind(); SetViewState(dt1); PS_PRO_LICENSE PLicense = new PS_PRO_LICENSE(); DataTable dt2 = PLicense.SELECT_PS_PRO_LICENSE("", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), "", "", "", ""); GridViewLicense.DataSource = dt2; GridViewLicense.DataBind(); SetViewState(dt2); PS_TRAINING Training = new PS_TRAINING(); DataTable dt3 = Training.SELECT_PS_TRAINING("", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), "", "", "", ""); GridViewTraining.DataSource = dt3; GridViewTraining.DataBind(); SetViewState(dt3); PS_PUNISHMENT Punishment = new PS_PUNISHMENT(); DataTable dt4 = Punishment.SELECT_PS_PUNISHMENT("", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), "", "", ""); GridViewPunish.DataSource = dt4; GridViewPunish.DataBind(); SetViewState(dt4); PS_POSI_AND_SALARY PosiSalary = new PS_POSI_AND_SALARY(); DataTable dt5 = PosiSalary.SELECT_PS_POSI_AND_SALARY("", MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), "", "", "", "", "", "", "", ""); GridViewPosiSalary.DataSource = dt5; GridViewPosiSalary.DataBind(); SetViewState(dt5); }
protected void btnSave2_Click(object sender, EventArgs e) { if (tbStartDate10.Text != "" && tbEndDate10.Text != "") { DateTime dtEndDate10 = DateTime.Parse(tbEndDate10.Text); DateTime dtStartDate10 = DateTime.Parse(tbStartDate10.Text); int totalDay = (int)(dtEndDate10 - dtStartDate10).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.tbStartDate10); return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } } PS_STUDY PStudy = new PS_STUDY(); PStudy.UOC_ID = Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())); PStudy.UNIV_NAME = tbUnivName10.Text; PStudy.START_DATE = DateTime.Parse(tbStartDate10.Text); PStudy.END_DATE = DateTime.Parse(tbEndDate10.Text); PStudy.QUALIFICATION = tbCertificate10.Text; PStudy.INSERT_PS_STUDY(); ClearStudy10(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('เพิ่มข้อมูลเรียบร้อย')", true); BindData(); }
private void ReadFile() { List <int> pro_id = new List <int>(); List <string> img_file = new List <string>(); using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT PRO_ID, IMG_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)); img_file.Add(reader.GetString(1)); } } } } } for (int i = 0; i < pro_id.Count; i++) { string path = "Upload/Project/PDF/" + img_file[i]; int PRO_ID = pro_id[i]; string IMG_FILE = img_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); } }
private void ReadSelectID() { using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); int uoc_id = DatabaseManager.ExecuteInt("SELECT UOC_ID FROM TB_REQUEST WHERE R_ID = '" + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + "'"); using (OracleCommand com = new OracleCommand("SELECT (SELECT UNIV_NAME_TH FROM REF_UNIV WHERE REF_UNIV.UNIV_ID = UOC_STAFF.UNIV_ID) UNIV_NAME," + "(SELECT FULLNAME FROM REF_PREFIX_NAME WHERE UOC_STAFF.PREFIX_NAME = REF_PREFIX_NAME.PREFIX_NAME_ID) PREFIX_NAME," + "STF_FNAME," + "STF_LNAME" + " FROM UOC_STAFF WHERE UOC_ID = '" + uoc_id + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { int i = 0; lb4Univ.Text = reader.GetValue(i).ToString(); ++i; lb4PrefixName.Text = reader.GetValue(i).ToString(); ++i; lb4Name.Text = reader.GetValue(i).ToString(); ++i; lb4LastName.Text = reader.GetValue(i).ToString(); ++i; } } } using (OracleCommand com = new OracleCommand("SELECT UNIV_ID, PREFIX_NAME, STF_FNAME, STF_LNAME FROM TB_REQUEST WHERE R_ID = '" + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { int i = 0; if (!reader.IsDBNull(0)) { tr4_lb4Univ.Visible = true; ddlUniv.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i; ddlUniv.Visible = true; } else { ++i; } if (!reader.IsDBNull(1)) { tr4_lb4PrefixName.Visible = true; ddlPrefixName.SelectedValue = reader.IsDBNull(i) ? "" : reader.GetValue(i).ToString(); ++i; ddlPrefixName.Visible = true; } else { ++i; } if (!reader.IsDBNull(2)) { tr4_lb4Name.Visible = true; lb4Name2.Text = reader.GetValue(i).ToString(); ++i; } else { ++i; } if (!reader.IsDBNull(3)) { tr4_lb4LastName.Visible = true; lb4LastName2.Text = reader.GetValue(i).ToString(); ++i; } else { ++i; } } } } } }
protected void btnCancel_Click(object sender, EventArgs e) { int r_id = DatabaseManager.ExecuteInt("SELECT R_ID FROM TB_REQUEST WHERE R_ID = '" + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + "'"); int id = 0; OracleConnection.ClearAllPools(); using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("UPDATE TB_REQUEST SET STATUS_ID = :STATUS_ID, DATE_END = :DATE_END WHERE R_ID = '" + r_id + "'", con)) { com.Parameters.Add(new OracleParameter("STATUS_ID", "2")); com.Parameters.Add(new OracleParameter("DATE_END", DateTime.Today)); id = com.ExecuteNonQuery(); } } MultiView1.ActiveViewIndex = 2; }
protected void btnUpdateProject_Click(object sender, EventArgs e) { if (Request.QueryString["id"] != null) { 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 = ""; } } PersonnelSystem ps = PersonnelSystem.GetPersonnelSystem(this); UOC_STAFF loginPerson = ps.LoginPerson; PROJECT p = new PROJECT(); p.Load(int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()))); p.CATEGORY_ID = Convert.ToInt32(ddlCategory.SelectedValue); p.PROJECT_NAME = tbProjectName.Text; p.ADDRESS_PROJECT = tbAddressProject.Text; p.START_DATE = DateTime.Parse(tbStartDate.Text); p.END_DATE = DateTime.Parse(tbEndDate.Text); p.EXPENSES = Convert.ToInt32(tbExpenses.Text); p.FUNDING = tbFunding.Text; p.CERTIFICATE = tbCertificate.Text; p.SUMMARIZE_PROJECT = tbSummarizeProject.Text; p.RESULT_TEACHING = tbResultTeaching.Text; p.RESULT_ACADEMIC = tbResultAcademic.Text; p.DIFFICULTY_PROJECT = tbDifficultyProject.Text; p.RESULT_PROJECT = tbResultProject.Text; p.RESULT_RESEARCHING = tbResultResearching.Text; p.RESULT_OTHER = tbResultOther.Text; p.COUNSEL = tbCounsel.Text; p.COUNTRY_ID = Convert.ToInt32(ddlCountry.SelectedValue); p.SUB_COUNTRY_ID = Convert.ToInt32(ddlSubCountry.SelectedValue); if (FUdocument.HasFile) { string CountBase = DatabaseManager.ExecuteString("select count(*) from tb_project where pro_id = '" + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + "'"); FileInfo fi = new FileInfo(FUdocument.FileName); string imgFile = "UID=" + p.UOC_ID + "&count=" + CountBase + fi.Extension; FUdocument.SaveAs(Server.MapPath("Upload/Project/PDF/" + imgFile)); p.IMG_FILE = imgFile; } p.PRO_ID = int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())); p.UPDATE_PROJECT(); Notsuccess.Visible = false; success.Visible = true; } }
public int UPDATE_REQUEST() { int r_id = DatabaseManager.ExecuteInt("SELECT R_ID FROM TB_REQUEST WHERE R_ID = '" + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + "'"); int uoc_id = DatabaseManager.ExecuteInt("SELECT UOC_ID FROM TB_REQUEST WHERE R_ID = '" + int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + "'"); int id = 0; OracleConnection.ClearAllPools(); using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("UPDATE TB_REQUEST SET STATUS_ID = :STATUS_ID, DATE_END = :DATE_END WHERE R_ID = '" + r_id + "'", con)) { com.Parameters.Add(new OracleParameter("STATUS_ID", "1")); com.Parameters.Add(new OracleParameter("DATE_END", DateTime.Today)); id = com.ExecuteNonQuery(); } } if (tr4_lb4Univ.Visible == true) { DatabaseManager.ExecuteNonQuery("UPDATE UOC_STAFF SET UNIV_ID = '" + ddlUniv.SelectedValue + "' WHERE UOC_ID = '" + uoc_id + "'"); } if (tr4_lb4PrefixName.Visible == true) { DatabaseManager.ExecuteNonQuery("UPDATE UOC_STAFF SET PREFIX_NAME = '" + ddlPrefixName.SelectedValue + "' WHERE UOC_ID = '" + uoc_id + "'"); } if (tr4_lb4Name.Visible == true) { DatabaseManager.ExecuteNonQuery("UPDATE UOC_STAFF SET STF_FNAME = '" + lb4Name2.Text + "' WHERE UOC_ID = '" + uoc_id + "'"); } if (tr4_lb4LastName.Visible == true) { DatabaseManager.ExecuteNonQuery("UPDATE UOC_STAFF SET STF_LNAME = '" + lb4LastName2.Text + "' WHERE UOC_ID = '" + uoc_id + "'"); } return(id); }
public bool UPDATE_PERSON() { bool result = false; using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); string query = "Update UOC_STAFF Set"; query += " UNIV_ID = :UNIV_ID ,"; query += " CITIZEN_ID = :CITIZEN_ID ,"; query += " PREFIX_NAME = :PREFIX_NAME ,"; query += " STF_FNAME = :STF_FNAME ,"; query += " STF_LNAME = :STF_LNAME ,"; query += " GENDER_ID = :GENDER_ID ,"; query += " BIRTHDAY = :BIRTHDAY ,"; query += " HOMEADD = :HOMEADD ,"; query += " MOO = :MOO ,"; query += " STREET = :STREET ,"; query += " PROVINCE_ID = :PROVINCE_ID ,"; query += " DISTRICT_ID = :DISTRICT_ID ,"; query += " SUB_DISTRICT_ID = :SUB_DISTRICT_ID ,"; query += " TELEPHONE = :TELEPHONE ,"; query += " ZIPCODE = :ZIPCODE ,"; query += " NATION_ID = :NATION_ID ,"; query += " STAFFTYPE_ID = :STAFFTYPE_ID ,"; query += " TIME_CONTACT_ID = :TIME_CONTACT_ID ,"; query += " BUDGET_ID = :BUDGET_ID ,"; query += " SUBSTAFFTYPE_ID = :SUBSTAFFTYPE_ID ,"; query += " ADMIN_POSITION_ID = :ADMIN_POSITION_ID ,"; query += " POSITION_ID = :POSITION_ID ,"; query += " POSITION_WORK = :POSITION_WORK ,"; query += " DEPARTMENT_ID = :DEPARTMENT_ID ,"; query += " DATE_INWORK = :DATE_INWORK ,"; query += " DATE_START_THIS_U = :DATE_START_THIS_U ,"; query += " SPECIAL_NAME = :SPECIAL_NAME ,"; query += " TEACH_ISCED_ID = :TEACH_ISCED_ID ,"; query += " GRAD_LEV_ID = :GRAD_LEV_ID ,"; query += " GRAD_CURR = :GRAD_CURR ,"; query += " GRAD_ISCED_ID = :GRAD_ISCED_ID ,"; query += " GRAD_PROG = :GRAD_PROG ,"; query += " GRAD_UNIV = :GRAD_UNIV ,"; query += " GRAD_COUNTRY_ID = :GRAD_COUNTRY_ID ,"; query += " DEFORM_ID = :DEFORM_ID ,"; query += " SIT_NO = :SIT_NO ,"; query += " SALARY = :SALARY ,"; query += " POSITION_SALARY = :POSITION_SALARY ,"; query += " RELIGION_ID = :RELIGION_ID ,"; query += " MOVEMENT_TYPE_ID = :MOVEMENT_TYPE_ID ,"; query += " MOVEMENT_DATE = :MOVEMENT_DATE ,"; query += " DECORATION = :DECORATION ,"; query += " RESULT1 = :RESULT1 ,"; query += " PERCENT_SALARY1 = :PERCENT_SALARY1 ,"; query += " RESULT2 = :RESULT2 ,"; query += " PERCENT_SALARY2 = :PERCENT_SALARY2 "; query += " where UOC_ID = :UOC_ID "; using (OracleCommand com = new OracleCommand(query, con)) { com.Parameters.Add(new OracleParameter("UNIV_ID", ddlUniv.SelectedValue)); com.Parameters.Add(new OracleParameter("CITIZEN_ID", lbCitizenID.Text)); com.Parameters.Add(new OracleParameter("PREFIX_NAME", ddlPrefixName.SelectedValue)); com.Parameters.Add(new OracleParameter("STF_FNAME", tbName.Text)); com.Parameters.Add(new OracleParameter("STF_LNAME", tbLastName.Text)); com.Parameters.Add(new OracleParameter("GENDER_ID", ddlGender.SelectedValue)); com.Parameters.Add(new OracleParameter("BIRTHDAY", DateTime.Parse(tbBirthday.Text))); com.Parameters.Add(new OracleParameter("HOMEADD", tbHomeAdd.Text)); com.Parameters.Add(new OracleParameter("MOO", tbMoo.Text)); com.Parameters.Add(new OracleParameter("STREET", tbStreet.Text)); com.Parameters.Add(new OracleParameter("PROVINCE_ID", ddlProvince.SelectedValue)); com.Parameters.Add(new OracleParameter("DISTRICT_ID", ddlDistrict.SelectedValue)); com.Parameters.Add(new OracleParameter("SUB_DISTRICT_ID", ddlSubDistrict.SelectedValue)); com.Parameters.Add(new OracleParameter("TELEPHONE", tbTelephone.Text)); com.Parameters.Add(new OracleParameter("ZIPCODE", tbZipcode.Text)); com.Parameters.Add(new OracleParameter("NATION_ID", ddlNation.SelectedValue)); com.Parameters.Add(new OracleParameter("STAFFTYPE_ID", ddlStafftype.SelectedValue)); com.Parameters.Add(new OracleParameter("TIME_CONTACT_ID", ddlTimeContact.SelectedValue)); com.Parameters.Add(new OracleParameter("BUDGET_ID", ddlBudget.SelectedValue)); com.Parameters.Add(new OracleParameter("SUBSTAFFTYPE_ID", ddlSubStafftype.SelectedValue)); com.Parameters.Add(new OracleParameter("ADMIN_POSITION_ID", ddlAdminPosition.SelectedValue)); com.Parameters.Add(new OracleParameter("POSITION_ID", ddlPosition.SelectedValue)); com.Parameters.Add(new OracleParameter("POSITION_WORK", tbPositionWork.Text)); com.Parameters.Add(new OracleParameter("DEPARTMENT_ID", ddlDepartment.SelectedValue)); com.Parameters.Add(new OracleParameter("DATE_INWORK", DateTime.Parse(tbDateInwork.Text))); com.Parameters.Add(new OracleParameter("DATE_START_THIS_U", DateTime.Parse(tbDateStartThisU.Text))); com.Parameters.Add(new OracleParameter("SPECIAL_NAME", tbSpecialName.Text)); com.Parameters.Add(new OracleParameter("TEACH_ISCED_ID", ddlTeachISCED.SelectedValue)); com.Parameters.Add(new OracleParameter("GRAD_LEV_ID", ddlGradLev.SelectedValue)); com.Parameters.Add(new OracleParameter("GRAD_CURR", tbGradCURR.Text)); com.Parameters.Add(new OracleParameter("GRAD_ISCED_ID", ddlGradISCED.SelectedValue)); com.Parameters.Add(new OracleParameter("GRAD_PROG", ddlGradProg.SelectedValue)); com.Parameters.Add(new OracleParameter("GRAD_UNIV", tbGradUniv.Text)); com.Parameters.Add(new OracleParameter("GRAD_COUNTRY_ID", ddlGradCountry.SelectedValue)); com.Parameters.Add(new OracleParameter("DEFORM_ID", ddlDeform.SelectedValue)); com.Parameters.Add(new OracleParameter("SIT_NO", tbSitNo.Text)); com.Parameters.Add(new OracleParameter("SALARY", tbSalary.Text)); com.Parameters.Add(new OracleParameter("POSITION_SALARY", tbPositionSalary.Text)); com.Parameters.Add(new OracleParameter("RELIGION_ID", ddlReligion.SelectedValue)); com.Parameters.Add(new OracleParameter("MOVEMENT_TYPE_ID", ddlMovementType.SelectedValue)); if (tbMovementDate.Text == "") { com.Parameters.Add(new OracleParameter("MOVEMENT_DATE", DBNull.Value)); } else { com.Parameters.Add(new OracleParameter("MOVEMENT_DATE", DateTime.Parse(tbMovementDate.Text))); } com.Parameters.Add(new OracleParameter("DECORATION", tbDecoration.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("UOC_ID", int.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())))); if (com.ExecuteNonQuery() > 0) { result = true; } } return(result); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { int.TryParse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()), out id); lb1.Text = id.ToString(); } else { Response.Redirect("listGP7-admin.aspx"); } } OracleConnection objConn = new OracleConnection(); OracleCommand objCmd = new OracleCommand(); OracleDataAdapter dtAdapter = new OracleDataAdapter(); string strConnString = null; DataSet dsMain = new DataSet(); DataTable dtMain = null; StringBuilder strSQLMain = new StringBuilder(); //strConnString = "DATA SOURCE=ORCL_RMUTTO;PASSWORD=Zxcvbnm;PERSIST SECURITY INFO=True;USER ID=Personnel"; strConnString = "DATA SOURCE=ORCL;PASSWORD=Zxcvbnm;PERSIST SECURITY INFO=True;USER ID=Personnel"; strSQLMain.Append("SELECT CITIZEN_ID,"); strSQLMain.Append("(SELECT FULLNAME FROM REF_PREFIX_NAME WHERE UOC_STAFF.PREFIX_NAME = REF_PREFIX_NAME.PREFIX_NAME_ID) PREFIX_NAME,"); strSQLMain.Append("STF_FNAME,"); strSQLMain.Append("STF_LNAME,"); strSQLMain.Append("BIRTHDAY,"); strSQLMain.Append("DATE_INWORK,"); strSQLMain.Append("(SELECT STAFFTYPE_NAME FROM REF_STAFFTYPE WHERE REF_STAFFTYPE.STAFFTYPE_ID = UOC_STAFF.STAFFTYPE_ID) STAFFTYPE_ID,"); strSQLMain.Append("FATHER_NAME || ' ' || FATHER_LNAME FATHER_NAME,"); strSQLMain.Append("MOTHER_NAME || ' ' || MOTHER_LNAME MOTHER_NAME,"); strSQLMain.Append("MOTHER_ONAME,"); strSQLMain.Append("COUPLE_NAME || ' ' || COUPLE_LNAME COUPLE_NAME,"); strSQLMain.Append("COUPLE_ONAME"); strSQLMain.Append(" FROM UOC_STAFF WHERE UOC_ID = " + Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + ""); objConn.ConnectionString = strConnString; var _with1 = objCmd; _with1.Connection = objConn; _with1.CommandText = strSQLMain.ToString(); _with1.CommandType = CommandType.Text; dtAdapter.SelectCommand = objCmd; dtAdapter.Fill(dsMain, "myDataGP7"); dtMain = dsMain.Tables[0]; DataSet dsStudy = new DataSet(); DataTable dtStudy = null; StringBuilder strSQLStudy = new StringBuilder(); strSQLStudy.Append("SELECT UNIV_NAME,"); strSQLStudy.Append("TO_CHAR(START_DATE,'MON YYYY','NLS_CALENDAR=''THAI BUDDHA''NLS_DATE_LANGUAGE=THAI') START_DATE,"); strSQLStudy.Append("TO_CHAR(END_DATE,'MON YYYY','NLS_CALENDAR=''THAI BUDDHA''NLS_DATE_LANGUAGE=THAI') END_DATE,"); strSQLStudy.Append("QUALIFICATION"); strSQLStudy.Append(" FROM PS_STUDY WHERE UOC_ID = " + Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + ""); strSQLStudy.Append(" ORDER BY STUDY_ID ASC"); objConn.ConnectionString = strConnString; var _with2 = objCmd; _with2.Connection = objConn; _with2.CommandText = strSQLStudy.ToString(); _with2.CommandType = CommandType.Text; dtAdapter.SelectCommand = objCmd; dtAdapter.Fill(dsStudy, "myDataStudy"); dtStudy = dsStudy.Tables[0]; DataSet dsProLicense = new DataSet(); DataTable dtProLicense = null; StringBuilder strSQLProLicense = new StringBuilder(); strSQLProLicense.Append("SELECT LICENSE_NAME,"); strSQLProLicense.Append("DEPARTMENT,"); strSQLProLicense.Append("LICENSE_NUMBER,"); strSQLProLicense.Append("TO_CHAR(START_DATE,'DD/MM/YYYY','NLS_CALENDAR=''THAI BUDDHA''NLS_DATE_LANGUAGE=THAI') START_DATE"); strSQLProLicense.Append(" FROM PS_PRO_LICENSE WHERE UOC_ID = " + Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + ""); strSQLProLicense.Append(" ORDER BY PRO_ID ASC"); objConn.ConnectionString = strConnString; var _with3 = objCmd; _with3.Connection = objConn; _with3.CommandText = strSQLProLicense.ToString(); _with3.CommandType = CommandType.Text; dtAdapter.SelectCommand = objCmd; dtAdapter.Fill(dsProLicense, "myDataProLicense"); dtProLicense = dsProLicense.Tables[0]; DataSet dsTraining = new DataSet(); DataTable dtTraining = null; StringBuilder strSQLTraining = new StringBuilder(); strSQLTraining.Append("SELECT TRAINING_NAME,"); strSQLTraining.Append("TO_CHAR(START_DATE,'DD/MM/YYYY','NLS_CALENDAR=''THAI BUDDHA''NLS_DATE_LANGUAGE=THAI') START_DATE,"); strSQLTraining.Append("TO_CHAR(END_DATE,'DD/MM/YYYY','NLS_CALENDAR=''THAI BUDDHA''NLS_DATE_LANGUAGE=THAI') END_DATE,"); strSQLTraining.Append("DEPARTMENT"); strSQLTraining.Append(" FROM PS_TRAINING WHERE UOC_ID = " + Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + ""); strSQLTraining.Append(" ORDER BY TRAINING_ID ASC"); objConn.ConnectionString = strConnString; var _with4 = objCmd; _with4.Connection = objConn; _with4.CommandText = strSQLTraining.ToString(); _with4.CommandType = CommandType.Text; dtAdapter.SelectCommand = objCmd; dtAdapter.Fill(dsTraining, "myDataTraining"); dtTraining = dsTraining.Tables[0]; DataSet dsPunish = new DataSet(); DataTable dtPunish = null; StringBuilder strSQLPunish = new StringBuilder(); strSQLPunish.Append("SELECT YEAR,"); strSQLPunish.Append("PUNISH_NAME,"); strSQLPunish.Append("REF_DOC"); strSQLPunish.Append(" FROM PS_PUNISHMENT WHERE UOC_ID = " + Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + ""); strSQLPunish.Append(" ORDER BY PUNISH_ID ASC"); objConn.ConnectionString = strConnString; var _with5 = objCmd; _with5.Connection = objConn; _with5.CommandText = strSQLPunish.ToString(); _with5.CommandType = CommandType.Text; dtAdapter.SelectCommand = objCmd; dtAdapter.Fill(dsPunish, "myDataPunish"); dtPunish = dsPunish.Tables[0]; DataSet dsPositionAndSalary = new DataSet(); DataTable dtPositionAndSalary = null; StringBuilder strSQLPositionAndSalary = new StringBuilder(); strSQLPositionAndSalary.Append("SELECT TO_CHAR(START_DATE,'DD/MM/YYYY','NLS_CALENDAR=''THAI BUDDHA''NLS_DATE_LANGUAGE=THAI') START_DATE,"); strSQLPositionAndSalary.Append("PAS_NAME,"); strSQLPositionAndSalary.Append("NO_POSITION,"); strSQLPositionAndSalary.Append("POSITION_TYPE,"); strSQLPositionAndSalary.Append("POSITION_DEGREE,"); strSQLPositionAndSalary.Append("SALARY,"); strSQLPositionAndSalary.Append("POSITION_SALARY,"); strSQLPositionAndSalary.Append("REF_DOC"); strSQLPositionAndSalary.Append(" FROM PS_POSI_AND_SALARY WHERE UOC_ID = " + Int32.Parse(MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString())) + ""); strSQLPositionAndSalary.Append(" ORDER BY PAS_ID ASC"); objConn.ConnectionString = strConnString; var _with6 = objCmd; _with6.Connection = objConn; _with6.CommandText = strSQLPositionAndSalary.ToString(); _with6.CommandType = CommandType.Text; dtAdapter.SelectCommand = objCmd; dtAdapter.Fill(dsPositionAndSalary, "myDataPositionAndSalary"); dtPositionAndSalary = dsPositionAndSalary.Tables[0]; dtAdapter = null; objConn.Close(); objConn = null; ReportDocument rpt = new ReportDocument(); rpt.Load(Server.MapPath("~/Report/CR/personGP7.rpt")); rpt.SetDataSource(dtMain); rpt.Subreports["psStudy"].Database.Tables[0].SetDataSource(dtStudy); rpt.Subreports["psProLicense"].Database.Tables[0].SetDataSource(dtProLicense); rpt.Subreports["dsTraining"].Database.Tables[0].SetDataSource(dtTraining); rpt.Subreports["psPunish"].Database.Tables[0].SetDataSource(dtPunish); rpt.Subreports["psPositionAndSalary"].Database.Tables[0].SetDataSource(dtPositionAndSalary); CrystalReportViewer1.ReportSource = rpt; }
private void ReadFile() { List <int> pro_id = new List <int>(); List <string> img_file = new List <string>(); using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT PRO_ID, IMG_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)); img_file.Add(reader.GetString(1)); } } } } } for (int i = 0; i < pro_id.Count; i++) { string path = "Upload/Project/PDF/" + img_file[i]; int PRO_ID = pro_id[i]; string IMG_FILE = img_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/" + IMG_FILE)); if (FileIn.Exists) { FileIn.Delete(); } DatabaseManager.ExecuteNonQuery("UPDATE TB_PROJECT SET IMG_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 BindDataBase() { using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT FATHER_NAME, FATHER_LNAME, MOTHER_NAME, MOTHER_LNAME, MOTHER_ONAME, COUPLE_NAME, COUPLE_LNAME, COUPLE_ONAME FROM UOC_STAFF WHERE UOC_ID = '" + MyCrypto.GetDecryptedQueryString(Request.QueryString["id"].ToString()) + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { int i = 0; tbFatherName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; tbFatherLastName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; tbMotherName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; tbMotherLastName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; tbMotherOldLastName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; tbCoupleName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; tbCoupleLastName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; tbCoupleOldLastName.Text = reader.IsDBNull(i) ? "" : reader.GetString(i); ++i; } } } } }