public float getTotalCredit(string academic_year, string semester, string lectuere_id) { string prev_course = ""; int prev_sec = 0; int prev_subsec = 0; float totalCredit = new AddWorkLoad().getAddWorkLoad(academic_year, semester, lectuere_id).TotalCredit; List <LecturerTableData> lecturerData = new List <LecturerTableData>(); lecturerData = new LecturerTable().getAllDegreeLecturerTable(academic_year, semester, lectuere_id); foreach (LecturerTableData data in lecturerData) { //if ((prev_course == "") || (prev_course != data.Course_Code) || (prev_sec != data.Sec_No) || (prev_subsec != data.SubSec_No)) // { SubCreditData subcredit = new SubCreditData(); subcredit = new SubCredit().getSubCredit(data.AcademicYear, data.Semester, data.Course_Code, data.Sec_No, data.SubSec_No, data.Lecturer, data.Teaching_Day, data.Teaching_Start_Time, data.Teaching_End_Time, data.Course_Degree_Char); totalCredit += subcredit.SubCredit; prev_course = data.Course_Code; prev_sec = data.Sec_No; prev_subsec = data.SubSec_No; // } } return(totalCredit); }
public float getTotalCreditforEdit(string academic_year, string semester, string lectuere_id, SubCreditData oldData) { string prev_course = ""; int prev_sec = 0; int prev_subsec = 0; float totalCredit = new AddWorkLoad().getAddWorkLoad(academic_year, semester, lectuere_id).TotalCredit; List <LecturerTableData> lecturerData = new List <LecturerTableData>(); lecturerData = new LecturerTable().getAllDegreeLecturerTable(academic_year, semester, lectuere_id); SubCreditData subcredit = new SubCreditData(); foreach (LecturerTableData data in lecturerData) { if (!(data.AcademicYear == oldData.AcademicYear && data.Semester == oldData.Semester && data.Course_Code == oldData.Course_Code && data.Sec_No == oldData.Sec_No && data.SubSec_No == oldData.SubSec_No && data.Lecturer == oldData.Lecturer)) { subcredit = new SubCredit().getSubCredit(data.AcademicYear, data.Semester, data.Course_Code, data.Sec_No, data.SubSec_No, data.Lecturer, data.Teaching_Day, data.Teaching_Start_Time, data.Teaching_End_Time, data.Course_Degree_Char); totalCredit += subcredit.SubCredit; // prev_course = data.Course_Code; // prev_sec = data.Sec_No; // prev_subsec = data.SubSec_No; } } return(totalCredit); }
public List <LecturerTableData> checkLecturer(List <LecturerTableData> new_lecturertable, TeachingTableData old_teachtable, string degree_char) { List <LecturerTableData> db_lecturertime = new List <LecturerTableData>(); List <LecturerTableData> db_lecturertime_1 = new LecturerTable().checkAllDupLecturer(new_lecturertable, degree_char); if (db_lecturertime_1 == null) { db_lecturertime = null; } else { foreach (LecturerTableData dup in db_lecturertime_1) { if (dup.Course_Code != old_teachtable.Course_Code) { db_lecturertime.Add(dup); } else if (dup.Course_Code == old_teachtable.Course_Code && dup.Sec_No != old_teachtable.Sec_No) { db_lecturertime.Add(dup); } else if (dup.Course_Code == old_teachtable.Course_Code && dup.Sec_No == old_teachtable.Sec_No && dup.SubSec_No != old_teachtable.SubSec_No) { db_lecturertime.Add(dup); } } if (db_lecturertime.Count == 0) { db_lecturertime = null; } } return(db_lecturertime); }
public float getInTimeHourRef(string academic_year, string semester, string lectuere_id) { string prev_course = ""; int prev_sec = 0; int prev_subsec = 0; //float hour_ref = new AddWorkLoad().getAddWorkLoad(academic_year, semester, lectuere_id).HourRefer; float hour_ref = 0; List <LecturerTableData> lecturerData = new List <LecturerTableData>(); lecturerData = new LecturerTable().getAllDegreeLecturerTable(academic_year, semester, lectuere_id); foreach (LecturerTableData data in lecturerData) { int end_time = (int)Convert.ToDouble(data.Teaching_End_Time.Replace(':', '.')); if ((data.Teaching_Day == "1" || data.Teaching_Day == "2" || data.Teaching_Day == "3" || data.Teaching_Day == "4" || data.Teaching_Day == "5") && (end_time <= 16)) { HourReferData hour_data = new HourReferData(); CourseData course_data = new CourseData(); course_data = new Course().getCourse(data.Course_Code); float credit = 0; SubCreditData subcredit = new SubCreditData(); subcredit = new SubCredit().getSubCredit(data.AcademicYear, data.Semester, data.Course_Code, data.Sec_No, data.SubSec_No, data.Lecturer, data.Teaching_Day, data.Teaching_Start_Time, data.Teaching_End_Time, data.Course_Degree_Char); credit = subcredit.SubCredit; if (course_data.Course_DegreeLevel == "01")// ปวช. { hour_data = new HourRefer().getHourRefer("U", data.Course_Type); hour_ref += hour_data.HourRefer * credit; } else if (course_data.Course_DegreeLevel == "02") //ป.ตรี { hour_data = new HourRefer().getHourRefer("B", data.Course_Type); hour_ref += hour_data.HourRefer * credit; } else { // บัณฑิต hour_data = new HourRefer().getHourRefer("M", data.Course_Type); hour_ref += hour_data.HourRefer * credit; } prev_course = data.Course_Code; prev_sec = data.Sec_No; prev_subsec = data.SubSec_No; } } return(hour_ref); }
public float getHourRef(string academic_year, string semester, string lectuere_id) { string prev_course = ""; int prev_sec = 0; int prev_subsec = 0; float hour_ref = new AddWorkLoad().getAddWorkLoad(academic_year, semester, lectuere_id).HourRefer; List <LecturerTableData> lecturerData = new List <LecturerTableData>(); lecturerData = new LecturerTable().getAllDegreeLecturerTable(academic_year, semester, lectuere_id); foreach (LecturerTableData data in lecturerData) { //if ((prev_course == "") || (prev_course != data.Course_Code) || (prev_sec != data.Sec_No) || (prev_subsec != data.SubSec_No)) // { HourReferData hour_data = new HourReferData(); CourseData course_data = new CourseData(); course_data = new Course().getCourse(data.Course_Code); float credit = 0; SubCreditData subcredit = new SubCreditData(); subcredit = new SubCredit().getSubCredit(data.AcademicYear, data.Semester, data.Course_Code, data.Sec_No, data.SubSec_No, data.Lecturer, data.Teaching_Day, data.Teaching_Start_Time, data.Teaching_End_Time, data.Course_Degree_Char); credit = subcredit.SubCredit; if (course_data.Course_DegreeLevel == "01") // ปวช. { hour_data = new HourRefer().getHourRefer("U", data.Course_Type); hour_ref += hour_data.HourRefer * credit; } else if (course_data.Course_DegreeLevel == "02") //ป.ตรี { hour_data = new HourRefer().getHourRefer("B", data.Course_Type); hour_ref += hour_data.HourRefer * credit; } else { // บัณฑิต hour_data = new HourRefer().getHourRefer("M", data.Course_Type); hour_ref += hour_data.HourRefer * credit; } prev_course = data.Course_Code; prev_sec = data.Sec_No; prev_subsec = data.SubSec_No; // } } return(hour_ref); }
protected void Page_Load(object sender, EventArgs e) { if (Session["login_data"] == null) { Response.Redirect("../index.aspx"); } else { //ตรวจสอบสิทธิ์ login_data = (UserLoginData)Session["login_data"]; if (autro_obj.CheckGroupUser(login_data, group_var.officer_department) || autro_obj.CheckGroupUser(login_data, group_var.officer_faculty) || autro_obj.CheckGroupUser(login_data, group_var.lecturer)) { /*=============================*/ try { string lec_code = Request.QueryString["lecturer"]; SysUser lec = new SysUser().getSysUser(lec_code); bool authorized = false; if (autro_obj.CheckGroupUser(login_data, group_var.lecturer)) { if (lec_code == login_data.Nation_ID) { authorized = true; } else { authorized = false; } } else if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty)) { authorized = true; } else if (autro_obj.CheckGroupUser(login_data, group_var.officer_department)) { List <string> department_authorized = autro_obj.getDepartment_Authorized(login_data, group_var.officer_department); foreach (string dep in department_authorized) { if (dep == lec.DepartmentCode) { authorized = true; break; } } } if (authorized == true) { string academic_year = Request.QueryString["year"]; string semester = Request.QueryString["semester"]; string prev_course = ""; int prev_sec = 0; int prev_subsec = 0; List <LecturerTableData> lecturerData = new List <LecturerTableData>(); lecturerData = new LecturerTable().getAllDegreeLecturerTable(academic_year, semester, lec_code); headLecturer.Text = new AcademicPosition().getAcademicPosition(lec.AcademicPositionCode).AcademicPositionThName + " " + lec.ThName + " " + lec.ThSurName; // Head Table string[] ar = { "ลำดับ", "ชื่อวิชา", "ตอนเรียน", "วัน", "เวลา", "ตัวคูณ", "หน่วยกิต", "ชั่วโมงอ้างอิง" }; Table tb1 = new Table(); tb1.Attributes.Add("class", "table table-bordered table-striped table-hover"); tb1.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead = new TableHeaderRow(); tRowHead.TableSection = TableRowSection.TableHeader; for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++) { TableHeaderCell cellHead = new TableHeaderCell(); cellHead.Text = ar[cellCtr - 1]; cellHead.Attributes.Add("class", "text-center"); tRowHead.Cells.Add(cellHead); } tb1.Rows.Add(tRowHead); int num = 1; float totalCredit = 0; float totalHourRef = 0; SubCreditData subcredit = new SubCreditData(); TableCell cellDay = new TableCell(); TableCell cellTime = new TableCell(); foreach (LecturerTableData data in lecturerData) { //if ((prev_course == "") || (prev_course != data.Course_Code) || (prev_sec != data.Sec_No) || (prev_subsec != data.SubSec_No)) // { CourseData course_data = new CourseData(); course_data = new Course().getCourse(data.Course_Code); TableRow tRowBody = new TableRow(); tRowBody.TableSection = TableRowSection.TableBody; TableCell cellNum = new TableCell(); cellNum.Attributes.Add("class", "text-center"); cellNum.Attributes.Add("style", "vertical-align:middle"); cellNum.Text = num.ToString(); tRowBody.Cells.Add(cellNum); TableCell cellCourseName = new TableCell(); cellCourseName.Attributes.Add("style", "vertical-align:middle"); cellCourseName.Text = course_data.Course_Code + " " + course_data.Course_Engname; tRowBody.Cells.Add(cellCourseName); string course_type = ""; string course_sec = ""; if (data.Course_Type == "1") { course_type = "S."; } else if (data.Course_Type == "2") { course_type = "L."; } else if (data.Course_Type == "4") { course_type = "T."; } else if (data.Course_Type == "5") { course_type = "M."; } else if (data.Course_Type == "6") { course_type = "SP."; } else if (data.Course_Type == "7") { course_type = "D."; } if (data.SubSec_No != 0) { course_sec = data.SubSec_No.ToString(); } else { course_sec = data.Sec_No.ToString(); } TableCell cellSec = new TableCell(); cellSec.Attributes.Add("class", "text-center"); cellSec.Attributes.Add("style", "vertical-align:middle"); cellSec.Text = course_type + course_sec; tRowBody.Cells.Add(cellSec); string day = ""; if (data.Teaching_Day == "1") { day = "Mon"; } else if (data.Teaching_Day == "2") { day = "Tue"; } if (data.Teaching_Day == "3") { day = "Wed"; } if (data.Teaching_Day == "4") { day = "Thu"; } if (data.Teaching_Day == "5") { day = "Fri"; } if (data.Teaching_Day == "6") { day = "Sat"; } if (data.Teaching_Day == "7") { day = "Sun"; } cellDay = new TableCell(); cellDay.Attributes.Add("class", "text-center"); cellDay.Attributes.Add("style", "vertical-align:middle"); cellDay.Text = day; tRowBody.Cells.Add(cellDay); string teach_time = data.Teaching_Start_Time + " - " + data.Teaching_End_Time; cellTime = new TableCell(); cellTime.Attributes.Add("class", "text-center"); cellTime.Attributes.Add("style", "vertical-align:middle"); cellTime.Text = teach_time; tRowBody.Cells.Add(cellTime); subcredit = new SubCredit().getSubCredit(data.AcademicYear, data.Semester, data.Course_Code, data.Sec_No, data.SubSec_No, data.Lecturer, data.Teaching_Day, data.Teaching_Start_Time, data.Teaching_End_Time, data.Course_Degree_Char); float credit = subcredit.SubCredit; totalCredit += subcredit.SubCredit; HourReferData hour_data = new HourReferData(); float hour_ref = 0; if (course_data.Course_DegreeLevel == "01")// ปวช. { hour_data = new HourRefer().getHourRefer("U", data.Course_Type); hour_ref = hour_data.HourRefer * credit; } else if (course_data.Course_DegreeLevel == "02") //ป.ตรี { hour_data = new HourRefer().getHourRefer("B", data.Course_Type); hour_ref = hour_data.HourRefer * credit; } else { // บัณฑิต hour_data = new HourRefer().getHourRefer("M", data.Course_Type); hour_ref = hour_data.HourRefer * credit; } totalHourRef += hour_ref; TableCell cellMultiply = new TableCell(); cellMultiply.Attributes.Add("class", "text-center"); cellMultiply.Attributes.Add("style", "vertical-align:middle"); cellMultiply.Text = hour_data.HourRefer.ToString(); tRowBody.Cells.Add(cellMultiply); TableCell cellCredit = new TableCell(); cellCredit.Attributes.Add("class", "text-center"); cellCredit.Attributes.Add("style", "vertical-align:middle"); cellCredit.Text = credit.ToString(); tRowBody.Cells.Add(cellCredit); TableCell cellHourRef = new TableCell(); cellHourRef.Attributes.Add("class", "text-center"); cellHourRef.Attributes.Add("style", "vertical-align:middle"); cellHourRef.Text = hour_ref.ToString(); tRowBody.Cells.Add(cellHourRef); tb1.Rows.Add(tRowBody); num++; prev_course = data.Course_Code; prev_sec = data.Sec_No; prev_subsec = data.SubSec_No; } AddWorkLoadData AddWork_data = new AddWorkLoadData(); AddWork_data = new AddWorkLoad().getAddWorkLoad(academic_year, semester, lec_code); if (AddWork_data.Lecturer != null) { totalCredit += AddWork_data.TotalCredit; totalHourRef += AddWork_data.HourRefer; TableRow tRowBody1 = new TableRow(); tRowBody1.TableSection = TableRowSection.TableBody; TableCell cellAddNum = new TableCell(); cellAddNum.Attributes.Add("class", "text-center"); cellAddNum.Attributes.Add("style", "vertical-align:middle"); cellAddNum.Text = num.ToString(); tRowBody1.Cells.Add(cellAddNum); TableCell cellAddTitle = new TableCell(); cellAddTitle.Attributes.Add("class", "text-left"); cellAddTitle.Attributes.Add("style", "vertical-align:middle"); cellAddTitle.ColumnSpan = 5; cellAddTitle.Text = "ภาระงานต้นสังกัด"; tRowBody1.Cells.Add(cellAddTitle); TableCell cellAddCredit = new TableCell(); cellAddCredit.Attributes.Add("class", "text-center"); cellAddCredit.Attributes.Add("style", "vertical-align:middle"); cellAddCredit.Text = AddWork_data.TotalCredit.ToString(); tRowBody1.Cells.Add(cellAddCredit); TableCell cellAddHourRef = new TableCell(); cellAddHourRef.Attributes.Add("class", "text-center"); cellAddHourRef.Attributes.Add("style", "vertical-align:middle"); cellAddHourRef.Text = AddWork_data.HourRefer.ToString(); tRowBody1.Cells.Add(cellAddHourRef); tb1.Rows.Add(tRowBody1); } //==================== TableFooterRow footRow = new TableFooterRow(); footRow.TableSection = TableRowSection.TableFooter; TableCell cellSumTitle = new TableCell(); cellSumTitle.Attributes.Add("class", "text-right txt-blue-bold"); cellSumTitle.ColumnSpan = 6; cellSumTitle.Text = "รวม"; footRow.Cells.Add(cellSumTitle); TableCell cell1 = new TableCell(); cell1.Attributes.Add("class", "text-center txt-blue-bold"); cell1.Text = totalCredit.ToString(); footRow.Cells.Add(cell1); TableCell cell3 = new TableCell(); cell3.Attributes.Add("class", "text-center txt-blue-bold"); cell3.Text = totalHourRef.ToString(); footRow.Cells.Add(cell3); tb1.Rows.Add(footRow); TableRow row = new TableRow(); TableCell cell = new TableCell(); cell.Controls.Add(tb1); row.Cells.Add(cell); tblWorkLoad.Rows.Add(row); } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } catch (Exception err) { } /*=============================*/ } else { HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน"; HttpContext.Current.Response.Redirect("err_response.aspx"); } } }
protected void onclick_section_finish(object sender, EventArgs e) { try { bool check = (bool)Session["isOK"]; if (check) { result.Text = new AvailableCourse().updateAvailableCourse(available_data, old_available_data, degree_char); string[] res = new AvailableStudent().updateAvailableStudent(available_student, old_available_student, degree_char); string[] res2 = new TeachingTable().updateTeachingTable(teachtable, old_teaching, degree_char); string[] res3 = new LecturerTable().updateLecturerTable(lecturertable, old_lecturer, degree_char); string[] res4 = new SubCredit().updateSubCredit(subcreditData, degree_char); divBody.Visible = false; divSuccess.Visible = true; } else { float totalCredit = 0; CourseData course_data = new Course().getCourse(available_data.Course_Code); int credit = course_data.Credit; if (lecturertable[0].Course_Type == "1") { if (course_data.Practice != 0) { credit = course_data.Theory; } else { credit = course_data.Credit; } } else if (lecturertable[0].Course_Type == "2") { if (course_data.Theory != 0) { credit = course_data.Practice / 2; } else { credit = course_data.Credit; } } string credit_err = ""; foreach (SubCreditData subcredit in subcreditData) { totalCredit += subcredit.SubCredit; float remain_credit = new WorkLoadCalculate().checkEditLecturerCredit2(subcredit.AcademicYear, subcredit.Semester, subcredit.Lecturer, subcredit.SubCredit, subcredit); if (remain_credit != -1) { credit_err += subcredit.Lecturer + "," + remain_credit; break; } } if (credit_err.Length > 0) { string[] arr = credit_err.Split(','); lblSubDreditErr.Visible = true; LectuereInformationData lec = new LectuereInformationData(); lec = new Lecturer().getLecturer(arr[0]); lblSubDreditErr.Text = "อาจารย์ " + lec.First_ThaiName + " " + lec.Family_ThaiName + " ไม่สามารถสอนได้เกิน " + arr[1] + " เครดิต"; btnSubmit.Focus(); } else if (totalCredit != credit) { lblSubDreditErr.Visible = true; lblSubDreditErr.Text = "จำนวนหน่วยกิตรวมต้องเท่ากับ " + credit; btnSubmit.Focus(); } else { result.Text = new AvailableCourse().updateAvailableCourse(available_data, old_available_data, degree_char); string[] res = new AvailableStudent().updateAvailableStudent(available_student, old_available_student, degree_char); string[] res2 = new TeachingTable().updateTeachingTable(teachtable, old_teaching, degree_char); string[] res3 = new LecturerTable().updateLecturerTable(lecturertable, old_lecturer, degree_char); string[] res4 = new SubCredit().updateSubCredit(subcreditData, degree_char); divBody.Visible = false; divSuccess.Visible = true; } } } catch { divFail.Visible = true; } }
protected void btnSEARCH_Click(object sender, EventArgs e) { utility utlObj = new utility(); UInt64 chknum; txtSTD_FIRSTNAME.Text = ""; txtSTD_SURNAME.Text = ""; txt_STD_FACULTY.Text = ""; txtSTD_DEPARTMENT.Text = ""; txtSTD_MAJOR.Text = ""; txtSTD_SPEC_FIELD.Text = ""; btnSAVE.Enabled = false; btnEdit.Enabled = false; divFail.Visible = false; divDupRegis.Visible = false; divDupExtend.Visible = false; Session.Remove("save_student_data"); if (txtSTUDENT_ID.Text.Length != 13) { //divShow.Visible = false; MsgValidate("กรุณาระบุ รหัสนักศึกษาด้วยตัวเลข 13 หลัก"); } else if (!UInt64.TryParse(txtSTUDENT_ID.Text, out chknum)) { MsgValidate("กรุณาระบุ รหัสนักศึกษาด้วยตัวเลขเท่านั้น"); } else { divFail.Visible = false; extend_data = (LecturerTableData)Session["Extend_Data"]; course_degree_char = extend_data.Course_Degree_Char; string degree_admission = utlObj.getFactorFromStudentID(txtSTUDENT_ID.Text, utlObj.stdID_Factor_DegreeAdmission); if (degree_admission == "1" || degree_admission == "2" || degree_admission == "3") { degree_char = "U"; } else if (degree_admission == "4" || degree_admission == "5" || degree_admission == "6") { degree_char = "B"; } else if (degree_admission == "7") { degree_char = "P"; } else if (degree_admission == "8") { degree_char = "M"; } else if (degree_admission == "9") { degree_char = "D"; } studentData = new Student().getStudent(txtSTUDENT_ID.Text, degree_char); if (studentData.Student_ID != null) { RegistrationData regisData = new RegistrationData(); regisData = new Student_Registration().getDupRegistration(extend_data.AcademicYear, extend_data.Semester, extend_data.Course_Code, studentData.Student_ID, degree_char); List <ExtendAvailableStudentData> dupextendData = new List <ExtendAvailableStudentData>(); dupextendData = new ExtendAvailableStudent().getExtendStudent(extend_data.AcademicYear, extend_data.Semester, extend_data.Course_Code, extend_data.Course_Type, studentData.Student_ID); //divShow.Visible = true; CourseData course_data = new CourseData(); course_data = new Course().getCourse(extend_data.Course_Code); string course_type = ""; string course_sec = ""; if (extend_data.Course_Type == "1") { course_type = "S."; } else if (extend_data.Course_Type == "2") { course_type = "L."; } else if (extend_data.Course_Type == "4") { course_type = "T."; } else if (extend_data.Course_Type == "5") { course_type = "M."; } else if (extend_data.Course_Type == "6") { course_type = "SP."; } else if (extend_data.Course_Type == "7") { course_type = "D."; } if (extend_data.SubSec_No != 0) { course_sec = extend_data.SubSec_No.ToString(); } else { course_sec = extend_data.Sec_No.ToString(); } lblHead.Text = course_type + course_sec + " " + extend_data.Course_Code + " " + course_data.Course_Thainame + "( " + course_data.Course_Engname + " )"; txtSTD_FIRSTNAME.Text = studentData.First_ThaiName; txtSTD_SURNAME.Text = studentData.Family_ThaiName; txt_STD_FACULTY.Text = new Faculty().getFaculty(studentData.Faculty_Code).Faculty_Thai; txtSTD_DEPARTMENT.Text = new Department().getDepartment(studentData.Department_Code).Department_Thai; txtSTD_MAJOR.Text = new Major().getMajor(studentData.Major_Code).Major_Thai; txtSTD_SPEC_FIELD.Text = new SpecialField().getSpecialField(studentData.Spec_Field_Code).SpecialField_Thai; if (regisData.Course_Code != null) { divDupRegis.Visible = true; string course_type1 = ""; course_data = new Course().getCourse(regisData.Course_Code); List <TeachingTableData> teachingData = new List <TeachingTableData>(); teachingData = new TeachingTable().getSubTeachingTable(regisData.Academic_Year, regisData.Semester, regisData.Course_Code, regisData.Sec_No, regisData.SubSec_No, degree_char); if (extend_data.Course_Type == "1") { course_type1 = "S."; } else if (extend_data.Course_Type == "2") { course_type1 = "L."; } else if (extend_data.Course_Type == "4") { course_type1 = "T."; } else if (extend_data.Course_Type == "5") { course_type1 = "M."; } else if (extend_data.Course_Type == "6") { course_type1 = "SP."; } else if (extend_data.Course_Type == "7") { course_type1 = "D."; } lblErr2.Text = ""; lblErr2.Text += "<div class='row'>"; lblErr2.Text += "<article class='col-sm-12 col-md-12 col-lg-12'>"; lblErr2.Text += "<div class='jarviswidget jarviswidget-color-primary' id='" + regisData.Course_Code + "' data-widget-editbutton='false' data-widget-deletebutton='false' data-widget-fullscreenbutton='false' data-widget-sortable='false'>"; lblErr2.Text += "<header><span class='widget-icon'><i class='fa fa-table'></i></span><h2>ข้อมูลการลงทะเบียน</h2></header>"; lblErr2.Text += "<div><div class='widget-body no-padding'><div class='widget-body-toolbar'></div>"; lblErr2.Text += "<table class='table table-bordered table-striped table-hover smart-form'>"; lblErr2.Text += "<thead><tr><th class='text-center' style='width:50px'>ตอนที่</th><th class='text-center' style='width:50px'>วิชา</th><th class='text-center' style='width:50px'>ห้องเรียน</th><th class='text-center' style='width:50px'>เวลาเรียน</th><th class='text-center' style='width:50px'>ผู้สอน</th></tr></thead>"; lblErr2.Text += "<tbody>"; lblErr2.Text += "<tr>"; if (regisData.SubSec_No != 0) { lblErr2.Text += "<td class='text-center'>" + course_type1 + regisData.SubSec_No + "</td>"; } else { lblErr2.Text += "<td class='text-center'>" + course_type1 + regisData.Sec_No + "</td>"; } lblErr2.Text += "<td class='text-left'>" + regisData.Course_Code + " " + course_data.Course_Thainame + "</td>"; string room = ""; foreach (TeachingTableData teach in teachingData) { room += teach.Building_Code + "-" + teach.Room_Code; if (teach.Campus_Code == "2") { room += "*"; } else if (teach.Campus_Code == "3") { room += "**"; } room += "<br/>"; } lblErr2.Text += "<td class='text-center'>" + room + "</td>"; string teachtime = ""; foreach (TeachingTableData teach in teachingData) { string day = ""; if (teach.Teaching_Day == "1") { day = "Mon"; } else if (teach.Teaching_Day == "2") { day = "Tue"; } if (teach.Teaching_Day == "3") { day = "Wed"; } if (teach.Teaching_Day == "4") { day = "Thu"; } if (teach.Teaching_Day == "5") { day = "Fri"; } if (teach.Teaching_Day == "6") { day = "Sat"; } if (teach.Teaching_Day == "7") { day = "Sun"; } teachtime += day + " " + teach.Teaching_Start_Time + " - " + teach.Teaching_End_Time + "<br>"; } lblErr2.Text += "<td class='text-center'>" + teachtime + "</td>"; string lec_name = ""; List <LecturerTableData> lecturerData = new List <LecturerTableData>(); foreach (TeachingTableData teach in teachingData) { lecturerData = new LecturerTable().getLecturerTable(teach, degree_char); foreach (LecturerTableData lec in lecturerData) { lec_name += new Lecturer().getLecturer(lec.Lecturer).Lecturer_ShortName + ","; } lec_name = lec_name.Substring(0, lec_name.Length - 1); lec_name += "<br>"; } lblErr2.Text += "<td class='text-center'>" + lec_name + "</td>"; lblErr2.Text += "</tr>"; lblErr2.Text += "</tbody>"; lblErr2.Text += "</table></div></div></div></article></div>"; } else if (dupextendData.Count != 0) { divDupExtend.Visible = true; lblErr3.Text = ""; lblErr3.Text += "<div class='row'>"; lblErr3.Text += "<article class='col-sm-12 col-md-12 col-lg-12'>"; lblErr3.Text += "<div class='jarviswidget jarviswidget-color-primary' id='" + regisData.Course_Code + "' data-widget-editbutton='false' data-widget-deletebutton='false' data-widget-fullscreenbutton='false' data-widget-sortable='false'>"; lblErr3.Text += "<header><span class='widget-icon'><i class='fa fa-table'></i></span><h2>ข้อมูลการลงทะเบียน</h2></header>"; lblErr3.Text += "<div><div class='widget-body no-padding'><div class='widget-body-toolbar'></div>"; lblErr3.Text += "<table class='table table-bordered table-striped table-hover smart-form'>"; lblErr3.Text += "<thead><tr><th class='text-center' style='width:50px'>ตอนที่</th><th class='text-center' style='width:50px'>วิชา</th><th class='text-center' style='width:50px'>ห้องเรียน</th><th class='text-center' style='width:50px'>เวลาเรียน</th><th class='text-center' style='width:50px'>ผู้สอน</th></tr></thead>"; foreach (ExtendAvailableStudentData data in dupextendData) { string course_type1 = ""; course_data = new Course().getCourse(data.Course_Code); List <TeachingTableData> teachingData = new List <TeachingTableData>(); teachingData = new TeachingTable().getSubTeachingTable(data.AcademicYear, data.Semester, data.Course_Code, data.Sec_No, data.SubSec_No, course_degree_char); if (data.Course_Type == "1") { course_type1 = "S."; } else if (data.Course_Type == "2") { course_type1 = "L."; } else if (data.Course_Type == "4") { course_type1 = "T."; } else if (data.Course_Type == "5") { course_type1 = "M."; } else if (data.Course_Type == "6") { course_type1 = "SP."; } else if (data.Course_Type == "7") { course_type1 = "D."; } lblErr3.Text += "<tbody>"; lblErr3.Text += "<tr>"; if (data.SubSec_No != 0) { lblErr3.Text += "<td class='text-center'>" + course_type1 + data.SubSec_No + "</td>"; } else { lblErr3.Text += "<td class='text-center'>" + course_type1 + data.Sec_No + "</td>"; } lblErr3.Text += "<td class='text-left'>" + data.Course_Code + " " + course_data.Course_Thainame + "</td>"; string room = ""; foreach (TeachingTableData teach in teachingData) { room += teach.Building_Code + "-" + teach.Room_Code; if (teach.Campus_Code == "2") { room += "*"; } else if (teach.Campus_Code == "3") { room += "**"; } room += "<br/>"; } lblErr3.Text += "<td class='text-center'>" + room + "</td>"; string teachtime = ""; foreach (TeachingTableData teach in teachingData) { string day = ""; if (teach.Teaching_Day == "1") { day = "Mon"; } else if (teach.Teaching_Day == "2") { day = "Tue"; } if (teach.Teaching_Day == "3") { day = "Wed"; } if (teach.Teaching_Day == "4") { day = "Thu"; } if (teach.Teaching_Day == "5") { day = "Fri"; } if (teach.Teaching_Day == "6") { day = "Sat"; } if (teach.Teaching_Day == "7") { day = "Sun"; } teachtime += day + " " + teach.Teaching_Start_Time + " - " + teach.Teaching_End_Time + "<br>"; } lblErr3.Text += "<td class='text-center'>" + teachtime + "</td>"; string lec_name = ""; List <LecturerTableData> lecturerData = new List <LecturerTableData>(); foreach (TeachingTableData teach in teachingData) { lecturerData = new LecturerTable().getLecturerTable(teach, course_degree_char); foreach (LecturerTableData lec in lecturerData) { lec_name += new Lecturer().getLecturer(lec.Lecturer).Lecturer_ShortName + ","; } lec_name = lec_name.Substring(0, lec_name.Length - 1); lec_name += "<br>"; } lblErr3.Text += "<td class='text-center'>" + lec_name + "</td>"; lblErr3.Text += "</tr>"; lblErr3.Text += "</tbody>"; } lblErr3.Text += "</table></div></div></div></article></div>"; } else { divFail.Visible = false; divDupRegis.Visible = false; btnSAVE.Enabled = true; Session["save_student_data"] = studentData; } } else { // divShow.Visible = false; MsgValidate("ตรวจสอบไม่พบ นักศึกษาที่ค้นหา"); } } }
protected void btnSHOW_Click(object sender, EventArgs e) { if (ddlADVISOR.SelectedValue == "00") { divShow.Visible = false; MsgValidate("โปรดระบุ อาจารย์"); } else { divShow.Visible = true; divFail.Visible = false; // Head Table string[] ar = { "ตอนที่", "รหัสวิชา", "ชื่อวิชา", "ห้องเรียน", "เวลาเรียน", "ผู้สอน", "ข้อมูลนักศึกษา" }; tblCourseList.Attributes.Add("class", "table table-bordered table-hover table-striped"); TableHeaderRow tRowHead = new TableHeaderRow(); tRowHead.TableSection = TableRowSection.TableHeader; for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++) { // Create a new cell and add it to the row. TableHeaderCell cellHead = new TableHeaderCell(); cellHead.Text = ar[cellCtr - 1]; cellHead.Attributes.Add("class", "text-center"); tRowHead.Cells.Add(cellHead); } tblCourseList.Rows.Add(tRowHead); int show_row = 0; List <LecturerTableData> lecturerData = new List <LecturerTableData>(); lecturerData = new LecturerTable().getAllDegreeLecturerTable(config_data.AcademicYear, config_data.Semester, ddlADVISOR.SelectedValue); foreach (LecturerTableData data in lecturerData) { Session["showCourse" + show_row] = data; TableRow tRowBody; if ((prev_course == "") || (prev_course != data.Course_Code) || (prev_sec != data.Sec_No) || (prev_subsec != data.SubSec_No)) { tRowBody = new TableRow(); tRowBody.TableSection = TableRowSection.TableBody; string course_type = ""; string course_sec = ""; if (data.Course_Type == "1") { course_type = "S."; } else if (data.Course_Type == "2") { course_type = "L."; } else if (data.Course_Type == "4") { course_type = "T."; } else if (data.Course_Type == "5") { course_type = "M."; } else if (data.Course_Type == "6") { course_type = "SP."; } else if (data.Course_Type == "7") { course_type = "D."; } if (data.SubSec_No != 0) { course_sec = data.SubSec_No.ToString(); } else { course_sec = data.Sec_No.ToString(); } TableCell cellSec = new TableCell(); cellSec.Text = course_type + course_sec; cellSec.Attributes.Add("class", "text-center"); tRowBody.Cells.Add(cellSec); TableCell cellCourseCode = new TableCell(); cellCourseCode.Text = data.Course_Code; cellCourseCode.Attributes.Add("class", "text-center"); tRowBody.Cells.Add(cellCourseCode); TableCell cellCourseName = new TableCell(); cellCourseName.Text = new Course().getCourse(data.Course_Code).Course_Thainame; tRowBody.Cells.Add(cellCourseName); string building_room = data.Building_Code; if (data.Room_Code == "0") // ไม่ระบุห้องเรียน { building_room += "-ไม่ระบุ"; } else { building_room += "-" + data.Room_Code; } if (data.Campus_Code == "2") { building_room += "*"; } else if (data.Campus_Code == "3") { building_room += "**"; } TableCell cellRoom = new TableCell(); cellRoom.Text = building_room; cellRoom.Attributes.Add("class", "text-center"); tRowBody.Cells.Add(cellRoom); string day = ""; if (data.Teaching_Day == "1") { day = "Mon"; } else if (data.Teaching_Day == "2") { day = "Tue"; } if (data.Teaching_Day == "3") { day = "Wed"; } if (data.Teaching_Day == "4") { day = "Thu"; } if (data.Teaching_Day == "5") { day = "Fri"; } if (data.Teaching_Day == "6") { day = "Sat"; } if (data.Teaching_Day == "7") { day = "Sun"; } string teach_time = data.Teaching_Start_Time + " - " + data.Teaching_End_Time; TableCell cellTime = new TableCell(); cellTime.Text = day + " " + teach_time; cellTime.Attributes.Add("class", "text-center"); tRowBody.Cells.Add(cellTime); string lec_all = ""; List <LecturerTableData> allLecturerData = new List <LecturerTableData>(); allLecturerData = new LecturerTable().getAllLecturerSecCourse(config_data.AcademicYear, config_data.Semester, data.Course_Code, data.Sec_No, data.SubSec_No, data.Teaching_Day, data.Teaching_Start_Time, data.Teaching_End_Time); foreach (LecturerTableData lect in allLecturerData) { LectuereInformationData lecturer_data = new LectuereInformationData(); lecturer_data = lecturerObj.getLecturer(lect.Lecturer); lec_all += lecturer_data.Lecturer_ShortName + " " + lecturer_data.Title_ThaiName + " " + lecturer_data.First_ThaiName + " " + lecturer_data.Family_ThaiName + "<br>"; } TableCell cellLectuere = new TableCell(); cellLectuere.Text = lec_all; //cellLectuere.Attributes.Add("class", "text-center"); tRowBody.Cells.Add(cellLectuere); TableCell cellView = new TableCell(); string urlView = "List_Course_Student.aspx?show_row=" + show_row.ToString(); HyperLink hypView = new HyperLink(); hypView.Attributes.Add("target", "_blank"); // hypView.Attributes.Add("data-target", "#View_Segment_Adivisor"); // hypView.Attributes.Add("data-toggle", "modal"); hypView.Attributes.Add("class", "text-center"); hypView.Text = "<h4><i class='fa fa-search'></i></h4>"; hypView.NavigateUrl = urlView; hypView.ToolTip = "ดูข้อมูล"; cellView.Controls.Add(hypView); tRowBody.Cells.Add(cellView); tblCourseList.Rows.Add(tRowBody); show_row++; prev_course = data.Course_Code; prev_sec = data.Sec_No; prev_subsec = data.SubSec_No; } else { tRowBody = tblCourseList.Rows[show_row]; string building_room = data.Building_Code; if (data.Room_Code == "0") // ไม่ระบุห้องเรียน { building_room += "-ไม่ระบุ"; } else { building_room += "-" + data.Room_Code; } if (data.Campus_Code == "2") { building_room += "*"; } else if (data.Campus_Code == "3") { building_room += "**"; } tRowBody.Cells[3].Text += "<br><br>" + building_room; string day = ""; if (data.Teaching_Day == "1") { day = "Mon"; } else if (data.Teaching_Day == "2") { day = "Tue"; } if (data.Teaching_Day == "3") { day = "Wed"; } if (data.Teaching_Day == "4") { day = "Thu"; } if (data.Teaching_Day == "5") { day = "Fri"; } if (data.Teaching_Day == "6") { day = "Sat"; } if (data.Teaching_Day == "7") { day = "Sun"; } string teach_time = data.Teaching_Start_Time + " - " + data.Teaching_End_Time; tRowBody.Cells[4].Text += "<br><br>" + day + " " + teach_time; string lec_all = ""; List <LecturerTableData> allLecturerData = new List <LecturerTableData>(); allLecturerData = new LecturerTable().getAllLecturerSecCourse(config_data.AcademicYear, config_data.Semester, data.Course_Code, data.Sec_No, data.SubSec_No, data.Teaching_Day, data.Teaching_Start_Time, data.Teaching_End_Time); foreach (LecturerTableData lect in allLecturerData) { LectuereInformationData lecturer_data = new LectuereInformationData(); lecturer_data = lecturerObj.getLecturer(lect.Lecturer); lec_all += lecturer_data.Lecturer_ShortName + " " + lecturer_data.Title_ThaiName + " " + lecturer_data.First_ThaiName + " " + lecturer_data.Family_ThaiName + "<br>"; } tRowBody.Cells[5].Text += "<br>" + lec_all; } } } }
protected void btnSEARCH_Click(object sender, EventArgs e) { divShow.Visible = true; txtCOURSE_CODE.Text = new utility().removeAllQuotes(txtCOURSE_CODE.Text); try { divShow.Visible = true; uint chknum; if (txtACADEMIC_YEAR.Text.Length != 4) { MsgValidate("โปรดระบุ ปีการศึกษาเป็นตัวเลขจำนวน 4 ตัว"); } else if (!uint.TryParse(txtACADEMIC_YEAR.Text, out chknum)) { MsgValidate("โปรดระบุ ปีการศึกษาเป็นตัวเลขเท่านั้น"); } else { degree_char = ddlDegreeLevel.SelectedValue; string table_struct1 = ""; string course_code1 = ""; Lecturer lecturerObj = new Lecturer(); List <TeachingTableData> teachtable = new List <TeachingTableData>(); List <TeachingTableData> subteachtable = new List <TeachingTableData>(); List <AvailableStudentData> available_student = new List <AvailableStudentData>(); available_data = new AvailableCourse().getAvailableCourse(txtACADEMIC_YEAR.Text, ddlSEMESTER.SelectedValue, txtCOURSE_CODE.Text, degree_char); CourseData course = new CourseData(); int loop = available_data.Count; for (int i = 0; i < loop; i++) { AvailableCourseData ava_course = available_data[i]; course = new Course().getCourse(ava_course.Course_Code); string course_code = ava_course.Course_Code; string course_name = course.Course_Thainame; string course_credit = course.Credit.ToString(); if (course.Course_Type_Code == "1" || course.Course_Type_Code == "2" || course.Course_Type_Code == "6") { course_credit += "(" + course.Theory + "-" + course.Practice + "-" + course.Self_Study + ")"; } teachtable = new TeachingTable().getTeachingTable(ava_course.AcademicYear, ava_course.Semester, ava_course.Course_Code, ava_course.Sec_No, degree_char); subteachtable = new TeachingTable().getSubTeachingTable(ava_course.AcademicYear, ava_course.Semester, ava_course.Course_Code, ava_course.Sec_No, degree_char); if (course_code != course_code1) { course_code1 = course_code; table_struct1 += "<div class='row'>"; table_struct1 += "<article class='col-sm-12 col-md-12 col-lg-12'>"; table_struct1 += "<div class='jarviswidget jarviswidget-color-primary' id='" + course_code + "' data-widget-editbutton='false' data-widget-deletebutton='false' data-widget-fullscreenbutton='false' data-widget-sortable='false'>"; table_struct1 += "<header><span class='widget-icon'><i class='fa fa-table'></i></span><h2>" + course_code + " : " + course_name + " " + course_credit + "</h2></header>"; table_struct1 += "<div><div class='widget-body no-padding'><div class='widget-body-toolbar'></div>"; table_struct1 += "<table class='table table-bordered table-striped table-hover smart-form'>"; table_struct1 += "<thead><tr><th class='text-center' style='width:50px'>ตอนที่</th><th class='text-center' style='width:50px'>วัน</th><th class='text-center' style='width:70px'>เวลา</th><th class='text-center'>ผู้สอน</th><th class='text-center'>ห้องเรียน</th><th class='text-center'>ข้อมูล น.ศ.</th><th class='text-center' style='width:50px'>จำนวน น.ศ.</th></tr></thead>"; table_struct1 += "<tbody>"; } foreach (TeachingTableData teach_table in teachtable) { available_student = new AvailableStudent().getAvailableStudent(teach_table.AcademicYear, teach_table.Semester, teach_table.Course_Code, teach_table.Sec_No, teach_table.SubSec_No, degree_char); string week_day = utlObj.getDayOfWeek_Thai(teach_table.Teaching_Day); string teach_time = teach_table.Teaching_Start_Time + " - " + teach_table.Teaching_End_Time; string building_room = new Building().getBuilding(teach_table.Building_Code).Building_ShortName; if (teach_table.Room_Code == "0") // ไม่ระบุห้องเรียน { building_room += "-ไม่ระบุ"; } else { building_room += "-" + teach_table.Room_Code; } string course_type = ""; if (teach_table.Course_Type == "1") { course_type = "S."; } else if (teach_table.Course_Type == "2") { course_type = "L."; } else if (teach_table.Course_Type == "4") { course_type = "T."; } else if (teach_table.Course_Type == "5") { course_type = "M."; } else if (teach_table.Course_Type == "6") { course_type = "SP."; } else if (teach_table.Course_Type == "7") { course_type = "D."; } string lec_all = ""; List <LecturerTableData> lecturerData = new List <LecturerTableData>(); lecturerData = new LecturerTable().getLecturerTable(teach_table, degree_char); foreach (LecturerTableData lect in lecturerData) { lec_all += lecturerObj.getLecturer(lect.Lecturer).Title_ThaiName + " " + lecturerObj.getLecturer(lect.Lecturer).First_ThaiName + " " + lecturerObj.getLecturer(lect.Lecturer).Family_ThaiName + "<br>"; } string student_list = ""; foreach (AvailableStudentData student in available_student) { if (student.Student_Group_Code != "-") { student_list += student.Curr_Code.Substring(4) + " - " + student.Student_Year + " " + new Section().getSection(student.Section_Code).Section_Short + new StdGroup().getStdGroup(student.Student_Group_Code).StdGroup_Thai + " " + new StdCategory().getStdCategory(student.Student_Category_Code).StdCategory_Thai + "<br/>"; } else if (student.Student_Group_Code == "-" && student.Faculty_Code != "-") { student_list += new Faculty().getFaculty(student.Faculty_Code).Faculty_Thai + "<br/>"; } else if (student.Student_Group_Code == "-" && student.Curr_Code != "-") { student_list += student.Curr_Code.Substring(4) + " " + new Curriculum().getCurriculum(student.Curr_Code).Curr_ThaiName + "<br/>"; } } table_struct1 += "<tr>"; table_struct1 += "<td class='text-center'>" + course_type + ava_course.Sec_No.ToString() + "</td>"; table_struct1 += "<td class='text-center'>" + week_day + "</td>"; table_struct1 += "<td>" + teach_time + "</td>"; table_struct1 += "<td>" + lec_all + "</td>"; table_struct1 += "<td class='text-center'>" + building_room + "</td>"; table_struct1 += "<td class='text-center'>" + student_list + "</td>"; table_struct1 += "<td class='text-center'>" + ava_course.Number_Student.ToString() + "</td>"; table_struct1 += "</tr>"; } // Pratice Extened foreach (TeachingTableData teach_table in subteachtable) { available_student = new AvailableStudent().getAvailableStudent(teach_table.AcademicYear, teach_table.Semester, teach_table.Course_Code, teach_table.Sec_No, teach_table.SubSec_No, degree_char); string week_day = utlObj.getDayOfWeek_Thai(teach_table.Teaching_Day); string teach_time = teach_table.Teaching_Start_Time + " - " + teach_table.Teaching_End_Time; string building_room = new Building().getBuilding(teach_table.Building_Code).Building_ShortName; if (teach_table.Room_Code == "0") // ไม่ระบุห้องเรียน { building_room += "-ไม่ระบุ"; } else { building_room += "-" + teach_table.Room_Code; } string course_type = ""; if (teach_table.Course_Type == "1") { course_type = "S."; } else if (teach_table.Course_Type == "2") { course_type = "L."; } string lec_all = ""; List <LecturerTableData> lecturerData = new List <LecturerTableData>(); lecturerData = new LecturerTable().getLecturerTable(teach_table, degree_char); foreach (LecturerTableData lect in lecturerData) { lec_all += lecturerObj.getLecturer(lect.Lecturer).Title_ThaiName + " " + lecturerObj.getLecturer(lect.Lecturer).First_ThaiName + " " + lecturerObj.getLecturer(lect.Lecturer).Family_ThaiName + "<br>"; } string student_list = ""; foreach (AvailableStudentData student in available_student) { if (student.Student_Group_Code != "-") { student_list += student.Curr_Code.Substring(4) + " - " + student.Student_Year + " " + new Section().getSection(student.Section_Code).Section_Short + new StdGroup().getStdGroup(student.Student_Group_Code).StdGroup_Thai + " " + new StdCategory().getStdCategory(student.Student_Category_Code).StdCategory_Thai + "<br/>"; } else if (student.Student_Group_Code == "-" && student.Faculty_Code != "-") { student_list += new Faculty().getFaculty(student.Faculty_Code).Faculty_Thai + "<br/>"; } else if (student.Student_Group_Code == "-" && student.Curr_Code != "-") { student_list += student.Curr_Code.Substring(4) + " " + new Curriculum().getCurriculum(student.Curr_Code).Curr_ThaiName + "<br/>"; } } table_struct1 += "<tr>"; table_struct1 += "<td class='text-center'>" + course_type + teach_table.SubSec_No.ToString() + "</td>"; table_struct1 += "<td class='text-center'>" + week_day + "</td>"; table_struct1 += "<td>" + teach_time + "</td>"; table_struct1 += "<td>" + lec_all + "</td>"; table_struct1 += "<td class='text-center'>" + building_room + "</td>"; table_struct1 += "<td class='text-center'>" + student_list + "</td>"; table_struct1 += "<td class='text-center'>" + teach_table.SubNumber_Student.ToString() + "</td>"; table_struct1 += "</tr>"; } if (i < (available_data.Count - 1)) { if (available_data[i + 1].Course_Code != course_code) { table_struct1 += "</tbody>"; table_struct1 += "</table></div></div></div></article></div>"; } } else { table_struct1 += "</tbody>"; table_struct1 += "</table></div></div></div></article></div>"; } } LiteralControl div_row = new LiteralControl(table_struct1); panelListAvailableCourse.Controls.Add(div_row); } } catch { divShow.Visible = false; divFail.Visible = true; } }
protected string createTableStruct() { degree_char = ddlDegreeLevel.SelectedValue; string table_struct = ""; string course_code1 = ""; List <AvailableStudentData> available_student = new List <AvailableStudentData>(); List <TeachingTableData> teachtable = new List <TeachingTableData>(); List <TeachingTableData> subteachtable = new List <TeachingTableData>(); available_data = new AvailableCourse().getAvailableCourse(txtACADEMIC_YEAR.Text, ddlSEMESTER.SelectedValue, txtCOURSE_CODE.Text, degree_char); CourseData course = new CourseData(); int loop = available_data.Count; table_struct += "<table><tr><td colspan='17' style='font-family:Tahoma;font-size:large;text-align:center;vertical-align:middle;height:2cm;border:none;' >"; table_struct += "รายวิชาที่เปิดสอน " + available_data[0].Semester + "/" + available_data[0].AcademicYear + ""; table_struct += "</td></tr></table>"; for (int i = 0; i < loop; i++) { AvailableCourseData ava_course = available_data[i]; course = new Course().getCourse(ava_course.Course_Code); string course_code = ava_course.Course_Code; string course_name = course.Course_Thainame; string course_credit = course.Credit.ToString(); if (course.Course_Type_Code == "1" || course.Course_Type_Code == "2" || course.Course_Type_Code == "6") { course_credit += "(" + course.Theory + "-" + course.Practice + "-" + course.Self_Study + ")"; } teachtable = new TeachingTable().getTeachingTable(ava_course.AcademicYear, ava_course.Semester, ava_course.Course_Code, ava_course.Sec_No, degree_char); subteachtable = new TeachingTable().getSubTeachingTable(ava_course.AcademicYear, ava_course.Semester, ava_course.Course_Code, ava_course.Sec_No, degree_char); if (course_code != course_code1) { course_code1 = course_code; //table_struct += "<div class='row'>"; //table_struct += "<article class='col-sm-12 col-md-12 col-lg-12'>"; //table_struct += "<div class='jarviswidget jarviswidget-color-primary' id='" + course_code + "' data-widget-editbutton='false' data-widget-deletebutton='false' data-widget-fullscreenbutton='false' data-widget-sortable='false'>"; //table_struct += "<header><span class='widget-icon'><i class='fa fa-table'></i></span><h2>" + course_code + " : " + course_name + " " + course_credit + "</h2></header>"; //table_struct += "<div><div class='widget-body no-padding'><div class='widget-body-toolbar'></div>"; table_struct += "<table>"; table_struct += "<thead>"; table_struct += "<tr><th colspan='17' style='font-family:Tahoma;font-size:medium;text-align:left;vertical-align:middle;height:1cm;border:none;'>" + course_code + " : " + course_name + " " + course_credit + "</th></tr>"; table_struct += "<tr style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;border:none;height:1cm' ><th>ตอนที่</th><th colspan='2'>วัน</th><th colspan='2'>เวลา</th><th colspan='4'>ผู้สอน</th><th colspan='2'>ห้องเรียน</th><th colspan='4'>ข้อมูล น.ศ.</th><th colspan='2'>จำนวน น.ศ.</th></tr>"; table_struct += "</thead>"; table_struct += "<tbody>"; } foreach (TeachingTableData teach_table in teachtable) { available_student = new AvailableStudent().getAvailableStudent(teach_table.AcademicYear, teach_table.Semester, teach_table.Course_Code, teach_table.Sec_No, teach_table.SubSec_No, degree_char); string week_day = utlObj.getDayOfWeek_Thai(teach_table.Teaching_Day); string teach_time = teach_table.Teaching_Start_Time + " - " + teach_table.Teaching_End_Time; string building_room = new Building().getBuilding(teach_table.Building_Code).Building_ShortName; if (teach_table.Room_Code == "0") // ไม่ระบุห้องเรียน { building_room += "-ไม่ระบุ"; } else { building_room += "-" + teach_table.Room_Code; } string course_type = ""; if (teach_table.Course_Type == "1") { course_type = "S."; } else if (teach_table.Course_Type == "2") { course_type = "L."; } else if (teach_table.Course_Type == "4") { course_type = "T."; } else if (teach_table.Course_Type == "5") { course_type = "M."; } else if (teach_table.Course_Type == "6") { course_type = "SP."; } else if (teach_table.Course_Type == "7") { course_type = "D."; } string lec_all = ""; List <LecturerTableData> lecturerData = new List <LecturerTableData>(); lecturerData = new LecturerTable().getLecturerTable(teach_table, degree_char); foreach (LecturerTableData lect in lecturerData) { lec_all += lecturerObj.getLecturer(lect.Lecturer).Title_ThaiName + " " + lecturerObj.getLecturer(lect.Lecturer).First_ThaiName + " " + lecturerObj.getLecturer(lect.Lecturer).Family_ThaiName + "<br/>"; } string a1 = lec_all.Substring(lec_all.Length - 5); if (a1 == "<br/>") { lec_all = lec_all.Remove(lec_all.Length - 5); } string student_list = ""; foreach (AvailableStudentData student in available_student) { if (student.Student_Group_Code != "-") { student_list += student.Curr_Code.Substring(4) + " - " + student.Student_Year + " " + new Section().getSection(student.Section_Code).Section_Short + new StdGroup().getStdGroup(student.Student_Group_Code).StdGroup_Thai + " " + new StdCategory().getStdCategory(student.Student_Category_Code).StdCategory_Thai + "<br/>"; } else if (student.Student_Group_Code == "-" && student.Faculty_Code != "-") { student_list += new Faculty().getFaculty(student.Faculty_Code).Faculty_Thai + "<br/>"; } else if (student.Student_Group_Code == "-" && student.Curr_Code != "-") { student_list += student.Curr_Code.Substring(4) + " " + new Curriculum().getCurriculum(student.Curr_Code).Curr_ThaiName + "<br/>"; } } string a2 = student_list.Substring(student_list.Length - 5); if (a2 == "<br/>") { student_list = student_list.Remove(student_list.Length - 5); } table_struct += "<tr>"; table_struct += "<td style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;' >" + course_type + ava_course.Sec_No.ToString() + "</td>"; table_struct += "<td colspan='2' style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;' >" + week_day + "</td>"; table_struct += "<td colspan='2' style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;' >" + teach_time + "</td>"; table_struct += "<td colspan='4' style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;' >" + lec_all + "</td>"; table_struct += "<td colspan='2' style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;' >" + building_room + "</td>"; table_struct += "<td colspan='4' style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;IsTextWrapped:true' >" + student_list + "</td>"; table_struct += "<td colspan='2' style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;' >" + ava_course.Number_Student.ToString() + "</td>"; table_struct += "</tr>"; } // Pratice Extened foreach (TeachingTableData teach_table in subteachtable) { available_student = new AvailableStudent().getAvailableStudent(teach_table.AcademicYear, teach_table.Semester, teach_table.Course_Code, teach_table.Sec_No, teach_table.SubSec_No, degree_char); string week_day = utlObj.getDayOfWeek_Thai(teach_table.Teaching_Day); string teach_time = teach_table.Teaching_Start_Time + " - " + teach_table.Teaching_End_Time; string building_room = new Building().getBuilding(teach_table.Building_Code).Building_ShortName; if (teach_table.Room_Code == "0") // ไม่ระบุห้องเรียน { building_room += "-ไม่ระบุ"; } else { building_room += "-" + teach_table.Room_Code; } string course_type = ""; if (teach_table.Course_Type == "1") { course_type = "S."; } else if (teach_table.Course_Type == "2") { course_type = "L."; } string lec_all = ""; List <LecturerTableData> lecturerData = new List <LecturerTableData>(); lecturerData = new LecturerTable().getLecturerTable(teach_table, degree_char); foreach (LecturerTableData lect in lecturerData) { lec_all += lecturerObj.getLecturer(lect.Lecturer).Title_ThaiName + " " + lecturerObj.getLecturer(lect.Lecturer).First_ThaiName + " " + lecturerObj.getLecturer(lect.Lecturer).Family_ThaiName + "<br/>"; } string a3 = lec_all.Substring(lec_all.Length - 5); if (a3 == "<br/>") { lec_all = lec_all.Remove(lec_all.Length - 5); } string student_list = ""; foreach (AvailableStudentData student in available_student) { if (student.Student_Group_Code != "-") { student_list += student.Curr_Code.Substring(4) + " - " + student.Student_Year + " " + new Section().getSection(student.Section_Code).Section_Short + new StdGroup().getStdGroup(student.Student_Group_Code).StdGroup_Thai + " " + new StdCategory().getStdCategory(student.Student_Category_Code).StdCategory_Thai + "<br/>"; } else if (student.Student_Group_Code == "-" && student.Faculty_Code != "-") { student_list += new Faculty().getFaculty(student.Faculty_Code).Faculty_Thai + "<br/>"; } else if (student.Student_Group_Code == "-" && student.Curr_Code != "-") { student_list += student.Curr_Code.Substring(4) + " " + new Curriculum().getCurriculum(student.Curr_Code).Curr_ThaiName + "<br/>"; } } string a4 = student_list.Substring(student_list.Length - 5); if (a4 == "<br/>") { student_list = student_list.Remove(student_list.Length - 5); } table_struct += "<tr>"; table_struct += "<td style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;'>" + course_type + teach_table.SubSec_No.ToString() + "</td>"; table_struct += "<td colspan='2' style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;'>" + week_day + "</td>"; table_struct += "<td colspan='2' style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;'>" + teach_time + "</td>"; table_struct += "<td colspan='4' style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;'>" + lec_all + "</td>"; table_struct += "<td colspan='2' style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;'>" + building_room + "</td>"; table_struct += "<td colspan='4' style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;'>" + student_list + "</td>"; table_struct += "<td colspan='2' style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:2cm;border:none;'>" + teach_table.SubNumber_Student.ToString() + "</td>"; table_struct += "</tr>"; } table_struct += "<tr><td style='font-family:Tahoma;font-size:medium;text-align:center;vertical-align:middle;width: 100px;height:1cm;border:none;'> </td></tr>"; if (i < (available_data.Count - 1)) { if (available_data[i + 1].Course_Code != course_code) { table_struct += "</tbody>"; table_struct += "</table>"; //</div></div></div></article></div>"; } } else { table_struct += "</tbody>"; table_struct += "</table>"; //table_struct += "</div></div></div></article></div>"; } } return(table_struct); }
protected void btnOK_Click(object sender, EventArgs e) { try { string response1 = "", response2 = "", response3 = "", response4 = ""; row_delete = Request.QueryString["row"]; degree_char = Request.QueryString["degree_char"]; delete_teach_data = (TeachingTableData)Session["delete_teachtable" + row_delete]; delete_lecturer_data.AcademicYear = delete_teach_data.AcademicYear; delete_lecturer_data.Semester = delete_teach_data.Semester; delete_lecturer_data.Course_Code = delete_teach_data.Course_Code; delete_lecturer_data.Sec_No = delete_teach_data.Sec_No; delete_lecturer_data.SubSec_No = delete_teach_data.SubSec_No; delete_lecturer_data.Room_Code = delete_teach_data.Room_Code; delete_lecturer_data.Building_Code = delete_teach_data.Building_Code; delete_lecturer_data.Campus_Code = delete_teach_data.Campus_Code; delete_lecturer_data.Teaching_Day = delete_teach_data.Teaching_Day; delete_lecturer_data.Teaching_Start_Time = delete_teach_data.Teaching_Start_Time; delete_lecturer_data.Teaching_End_Time = delete_teach_data.Teaching_End_Time; delete_student_data.AcademicYear = delete_teach_data.AcademicYear; delete_student_data.Semester = delete_teach_data.Semester; delete_student_data.Course_Code = delete_teach_data.Course_Code; delete_student_data.Sec_No = delete_teach_data.Sec_No; delete_student_data.SubSec_No = delete_teach_data.SubSec_No; delete_availableCourse_data.AcademicYear = delete_teach_data.AcademicYear; delete_availableCourse_data.Semester = delete_teach_data.Semester; delete_availableCourse_data.Course_Code = delete_teach_data.Course_Code; delete_availableCourse_data.Sec_No = delete_teach_data.Sec_No; if (delete_teach_data.Course_Type == "1") { if (new TeachingTable().checkBeforeDelTeachTable(delete_teach_data, degree_char) == true) { response1 = new TeachingTable().deleteTeachingTable(delete_teach_data, degree_char); } } else { response1 = new TeachingTable().deleteTeachingTable(delete_teach_data, degree_char); } if (response1 == "OK") { response2 = new LecturerTable().deleteLecturerTable(delete_lecturer_data, degree_char); } if (response2 == "OK") { new SubCredit().deleteSubCredit2(delete_lecturer_data.AcademicYear, delete_lecturer_data.Semester, delete_lecturer_data.Course_Code, delete_lecturer_data.Sec_No, delete_lecturer_data.SubSec_No, delete_lecturer_data.Teaching_Day, delete_lecturer_data.Teaching_Start_Time, delete_lecturer_data.Teaching_End_Time, degree_char); } if (new TeachingTable().checkBeforeDelStudent(delete_teach_data, degree_char) == true && response1 == "OK" && response2 == "OK") { response3 = new AvailableStudent().deleteAvailableStudent(delete_student_data, degree_char); } else { response3 = "OK"; } if (new TeachingTable().checkBeforeDelAviCourse(delete_teach_data, degree_char) == true && response1 == "OK" && response2 == "OK" && response3 == "OK") { response4 = new AvailableCourse().deleteAvailableCourse(delete_availableCourse_data, degree_char); } else { response4 = "OK"; } if ((response1 == "OK") && (response2 == "OK") && (response3 == "OK") && (response4 == "OK")) { Response.Redirect("list_Section.aspx"); } else { //lblResult.Text = "teach=" + response1 + " lecturer=" + response2 + " student=" + response3 + " avaliable=" + response4 + "aa" + new TeachingTable().checkBeforeDelTeachTable(delete_teach_data, degree_char); Response.Redirect("list_Section.aspx"); } } catch { Response.Redirect("list_Section.aspx"); } }