void BindData() { //GridViewStudy PS_STUDY PStudy = new PS_STUDY(); DataTable dt1 = PStudy.SELECT_PS_STUDY(p, "", "", "", "", "", "", "", "", ""); GridViewStudy.DataSource = dt1; GridViewStudy.DataBind(); SetViewState(dt1); //GridViewLicense PS_PROFESSIONAL_LICENSE PLicense = new PS_PROFESSIONAL_LICENSE(); DataTable dt2 = PLicense.SELECT_PS_PROFESSIONAL_LICENSE(p, "", "", "", ""); GridViewLicense.DataSource = dt2; GridViewLicense.DataBind(); SetViewState(dt2); //GridViewTraining PS_TRAINING PTraining = new PS_TRAINING(); DataTable dt3 = PTraining.SELECT_PS_TRAINING(p, "", "", "", "", "", ""); GridViewTraining.DataSource = dt3; GridViewTraining.DataBind(); SetViewState(dt3); //GridViewDisciplinary PS_DISCIPLINARY_AND_AMNESTY PDAA = new PS_DISCIPLINARY_AND_AMNESTY(); DataTable dt4 = PDAA.SELECT_PS_DISCIPLINARY_AND_AMNESTY(p, "", "", ""); GridViewDAA.DataSource = dt4; GridViewDAA.DataBind(); SetViewState(dt4); //GridViewPositionAndSalary PS_POSITION_AND_SALARY PPAS = new PS_POSITION_AND_SALARY(); DataTable dt5 = PPAS.SELECT_PS_POSITION_AND_SALARY(p, "", "", "", "", "", "", "", ""); GridViewPAS.DataSource = dt5; GridViewPAS.DataBind(); SetViewState(dt5); //GridViewPositionDegreeHistoryGover TB_PDH_GOVER PDHgover = new TB_PDH_GOVER(); DataTable dt6 = PDHgover.SELECT_POSI_GOVER_ONLY(p, "", ""); GridviewPDHgover.DataSource = dt6; GridviewPDHgover.DataBind(); SetViewState(dt6); //GridViewPositionDegreeHistoryEMP TB_PDH_EMP PDHemp = new TB_PDH_EMP(); DataTable dt7 = PDHemp.SELECT_POSI_EMP_ONLY(p, "", ""); GridviewPDHemp.DataSource = dt7; GridviewPDHemp.DataBind(); SetViewState(dt7); }
void BindData1() { PS_STUDY PStudy = new PS_STUDY(); DataTable dt1 = PStudy.SELECT_PS_STUDY(labelCitizenID.Text, "", "", "", "", "", "", "", "", ""); GridViewStudy.DataSource = dt1; GridViewStudy.DataBind(); SetViewState(dt1); PS_PROFESSIONAL_LICENSE PLicense = new PS_PROFESSIONAL_LICENSE(); DataTable dt2 = PLicense.SELECT_PS_PROFESSIONAL_LICENSE(labelCitizenID.Text, "", "", "", ""); GridViewLicense.DataSource = dt2; GridViewLicense.DataBind(); SetViewState(dt2); PS_TRAINING PTraining = new PS_TRAINING(); DataTable dt3 = PTraining.SELECT_PS_TRAINING(labelCitizenID.Text, "", "", "", "", "", ""); GridViewTraining.DataSource = dt3; GridViewTraining.DataBind(); SetViewState(dt3); PS_DISCIPLINARY_AND_AMNESTY PDAA = new PS_DISCIPLINARY_AND_AMNESTY(); DataTable dt4 = PDAA.SELECT_PS_DISCIPLINARY_AND_AMNESTY(labelCitizenID.Text, "", "", ""); GridViewDAA.DataSource = dt4; GridViewDAA.DataBind(); SetViewState(dt4); PS_POSITION_AND_SALARY PPAS = new PS_POSITION_AND_SALARY(); DataTable dt5 = PPAS.SELECT_PS_POSITION_AND_SALARY(labelCitizenID.Text, "", "", "", "", "", "", "", ""); GridViewPAS.DataSource = dt5; GridViewPAS.DataBind(); SetViewState(dt5); TB_PDH_GOVER PDHgover = new TB_PDH_GOVER(); DataTable dt6 = PDHgover.SELECT_POSI_GOVER_ONLY(labelCitizenID.Text, "", ""); GridviewPDHgover.DataSource = dt6; GridviewPDHgover.DataBind(); SetViewState(dt6); TB_PDH_EMP PDHemp = new TB_PDH_EMP(); DataTable dt7 = PDHemp.SELECT_POSI_EMP_ONLY(labelCitizenID.Text, "", ""); GridviewPDHemp.DataSource = dt7; GridviewPDHemp.DataBind(); SetViewState(dt7); }
protected void lbuTab5Save_Click(object sender, EventArgs e) { if (ddlDegree10.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณาเลือกระดับการศึกษา</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (tbUnivName10.Text == "") { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณากรอกสถานศึกษา</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlMonth10From.SelectedIndex == 0 && ddlYear10From.SelectedIndex == 0 && ddlMonth10To.SelectedIndex == 0 && ddlYear10To.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณาเลือกตั้งแต่ - ถึง (เดือน ปี)ให้ถูกต้อง</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (tbQualification10.Text == "") { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณากรอกวุฒิ</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (tbMajor10.Text == "") { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณากรอกสาขาวิชาเอก</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } if (ddlCountrySuccess10.SelectedIndex == 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>กรุณาเลือกประเทศที่จบการศึกษา</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } DateTime dtStudyFrom = new DateTime(int.Parse(ddlYear10From.SelectedValue), int.Parse(ddlMonth10From.SelectedValue), 1); DateTime dtStudyTo = new DateTime(int.Parse(ddlYear10To.SelectedValue), int.Parse(ddlMonth10To.SelectedValue), 1); if((dtStudyTo - dtStudyFrom).TotalDays < 28) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>กรุณากรอกข้อมูลให้ครบถ้วน</strong></div>"; notification.InnerHtml += "<div>ตั้งแต่ - ถึง (เดือน ปี) : ช่วงเวลาการศึกษาต้องมากกว่า 1 เดือน</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } //เช็ค เลือก ระดับการศึกษาซ้ำ using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING)) { con.Open(); using (OracleCommand com = new OracleCommand("SELECT COUNT(*) FROM PS_STUDY WHERE PS_DEGREE_ID = '" + ddlDegree10.SelectedValue + "'", con)) { using (OracleDataReader reader = com.ExecuteReader()) { while (reader.Read()) { if (reader.GetInt32(0) > 0) { notification.Attributes["class"] = "alert alert_danger"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>แจ้งเตือน</strong></div>"; notification.InnerHtml += "<div> - มีข้อมูลระดับการศึกษาที่คุณเลือกนี้อยู่แล้วในระบบ</div>"; return; } else { notification.Attributes["class"] = "none"; notification.InnerHtml = ""; } } } } } PS_STUDY PStudy = new PS_STUDY(); PStudy.PS_CITIZEN_ID = p; PStudy.PS_DEGREE_ID = Convert.ToInt32(ddlDegree10.SelectedValue); PStudy.PS_UNIV_NAME = tbUnivName10.Text; PStudy.PS_FROM_MONTH = Convert.ToInt32(ddlMonth10From.SelectedValue); PStudy.PS_FROM_YEAR = Convert.ToInt32(ddlYear10From.SelectedValue); PStudy.PS_TO_MONTH = Convert.ToInt32(ddlMonth10To.SelectedValue); PStudy.PS_TO_YEAR = Convert.ToInt32(ddlYear10To.SelectedValue); PStudy.PS_QUALIFICATION = tbQualification10.Text; PStudy.PS_MAJOR = tbMajor10.Text; PStudy.PS_COUNTRY_ID = Convert.ToInt32(ddlCountrySuccess10.SelectedValue); PStudy.INSERT_PS_STUDY(); ClearPStudy10(); DataTable dt1 = PStudy.SELECT_PS_STUDY(p, "", "", "", "", "", "", "", "", ""); GridViewStudy.DataSource = dt1; GridViewStudy.DataBind(); SetViewState(dt1); notification.Attributes["class"] = "alert alert_success"; notification.InnerHtml = ""; notification.InnerHtml += "<div><img src='Image/Small/correct.png' /><strong>บันทึกข้อมูลประวัติการศึกษาสำเร็จ</strong></div>"; }