// V 1.0.0 public string insert_HisAdvisor(HisUpdateAdvisorData dataInsert, string degree_char) { string tableName = getHisAdvisorTable(degree_char); string response = ""; int i = 0; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle(); string sql = "Insert Into " + tableName + "(DATE_TIME,ACADEMIC_YEAR,SEMESTER,OLD_ADVISOR_ID,ADVISOR_ID,STUDENT_ID,UPDATE_BY) Values('" + dataInsert.date_time + "','" + dataInsert.academic_year + "','" + dataInsert.semester + "','" + dataInsert.old_advisor_id + "','" + dataInsert.advisor_id + "','" + dataInsert.student_id + "','" + dataInsert.update_by + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "OK"; } } catch (Exception e) { response = e.Message.ToString(); } i++; return(response); }
protected void btnSAVE_Click(object sender, EventArgs e) { List <UpdateAdvisorData> updateAdvisorData = new List <UpdateAdvisorData>(); lblResult.Text = ""; uint chknum; int item_selected = 0; foreach (ListItem item in Duallistbox.Items) { if (item.Selected) { item_selected++; } } if (txtACADEMIC_YEAR.Text.Length != 4) { MsgValidate("กรุณาระบุ ปีการศึกษา เป็นตัวเลขจำนวน 4 ตัว"); } else if (!uint.TryParse(txtACADEMIC_YEAR.Text, out chknum)) { MsgValidate("กรุณาระบุ ปีการศึกษา เป็นตัวเลขเท่านั้น"); } else if (ddlLecturer.SelectedValue == "00") { divShow.Visible = false; MsgValidate("กรุณาระบุ อาจารย์ที่ปรึกษา"); } else if (item_selected == 0) { divShow.Visible = false; MsgValidate("กรุณาเลือก รายชื่อนักศึกษา"); } else { HisUpdateAdvisorData HisAdvisor = new HisUpdateAdvisorData(); foreach (ListItem item in Duallistbox.Items) { if (item.Selected) { UpdateAdvisorData UpdateAdvisor_data = new UpdateAdvisorData(); UpdateAdvisor_data.Student_ID = item.Value; UpdateAdvisor_data.Lecturer_ID = ddlLecturer.SelectedValue; updateAdvisorData.Add(UpdateAdvisor_data); HisAdvisor.date_time = DateTime.Now.ToString(); HisAdvisor.academic_year = AcademicYear; HisAdvisor.semester = ddlSEMESTER.SelectedValue; HisAdvisor.old_advisor_id = new Student().getAdvisor_ID(UpdateAdvisor_data.Student_ID, degree_char); HisAdvisor.advisor_id = UpdateAdvisor_data.Lecturer_ID; HisAdvisor.student_id = UpdateAdvisor_data.Student_ID; HisAdvisor.update_by = login_data.First_Thainame + " " + login_data.Family_Thainame + " (" + login_data.User_ID + ")"; new HistoryUpdate().insert_HisAdvisor(HisAdvisor, degree_char); } } string[] res = new Student().updateAdvisor(updateAdvisorData, degree_char); int j = 0; Student stdData = new Student(); foreach (ListItem item in Duallistbox.Items) { if (item.Selected) { stdData = new Student().getStudent(updateAdvisorData[j].Student_ID, degree_char); if (res[j] == "OK") { item.Attributes.Add("class", "txt-green-bold"); } else { item.Attributes.Add("class", "txt-red"); } item.Text = updateAdvisorData[j].Student_ID + " " + stdData.First_ThaiName + " " + stdData.Family_ThaiName + " (" + new Lecturer().getLecturer(stdData.Advisor_ID).Lecturer_ShortName + ")"; j++; } } } }