// V 1.0.0
public string deleteLecturerTable(LecturerTableData delete_data, string degree_char)
{
string response = "";
try
{
string TableName = getTableName(degree_char);
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Delete From " + TableName + " Where ACADEMIC_YEAR='" + delete_data.AcademicYear + "' And SEMESTER='" + delete_data.Semester + "' And COURSE_CODE='" + delete_data.Course_Code + "' And SEC_NO=" + delete_data.Sec_No + " And SUBSEC_NO=" + delete_data.SubSec_No + " And ROOM_CODE='" + delete_data.Room_Code + "' And BUILDING_CODE='" + delete_data.Building_Code + "' And CAMPUS_CODE='" + delete_data.Campus_Code + "' And TEACHING_DAY='" + delete_data.Teaching_Day + "' And TEACHING_START_TIME='" + delete_data.Teaching_Start_Time + "' And TEACHING_END_TIME='" + delete_data.Teaching_End_Time + "' ";
oracleObj.DeleteCommand = sql;
try
{
if (oracleObj.Delete() > 0)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString();
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:LecturerTable:deleteLecturerTable" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
protected void btnSAVE_Click(object sender, EventArgs e)
{
string result = "";
if ((Session["save_student_data"] != null) && (Session["Extend_Data"] != null))
{
LecturerTableData insert_extend_data = new LecturerTableData();
Student insert_studentData = new Student();
ExtendAvailableStudentData insert_extendStudentData = new ExtendAvailableStudentData();
insert_extend_data = (LecturerTableData)Session["Extend_Data"];
insert_studentData = (Student)Session["save_student_data"];
insert_extendStudentData.AcademicYear = insert_extend_data.AcademicYear;
insert_extendStudentData.Semester = insert_extend_data.Semester;
insert_extendStudentData.Course_Code = insert_extend_data.Course_Code;
insert_extendStudentData.Course_Type = insert_extend_data.Course_Type;
insert_extendStudentData.Sec_No = insert_extend_data.Sec_No;
insert_extendStudentData.SubSec_No = insert_extend_data.SubSec_No;
insert_extendStudentData.Student_ID = insert_studentData.Student_ID;
insert_extendStudentData.LECTURER_ADD = insert_extend_data.Lecturer;
insert_extendStudentData.LECTURER_CANCEL = "-";
result = new ExtendAvailableStudent().insertExtendStudent(insert_extendStudentData);
if (result == "OK")
{
divSuccess.Visible = true;
}
}
}
public LecturerTableData checkHourRefWeekEndDay(List <LecturerTableData> alllecturer_data, TeachingTableData teaching_data)
{
LecturerTableData response = new LecturerTableData();
if (teaching_data.Teaching_Day == "6" || teaching_data.Teaching_Day == "7")
{
foreach (LecturerTableData lec in alllecturer_data)
{
SysUser user = new SysUser();
user = new SysUser().getSysUser(lec.Lecturer);
Sysuser2 user2 = new Sysuser2();
user2 = new Sysuser2().getSysuser2(lec.Lecturer);
if (user2.Lecturer_Type != "03") // อาจารย์พิเศษ
{
float totalHourRef = new WorkLoadConfig().getWorkLoadConfig(user2.Lecturer_Type, user.Position).HourReference;
float currentHourRef = getInTimeHourRef(teaching_data.AcademicYear, teaching_data.Semester, lec.Lecturer);
if (currentHourRef < totalHourRef)
{
response = lec;
break;
}
}
}
}
return(response);
}
public LecturerTableData checkLecturerCredit(List <LecturerTableData> alllecturer_data)
{
LecturerTableData response = new LecturerTableData();
foreach (LecturerTableData lec in alllecturer_data)
{
SysUser user = new SysUser();
user = new SysUser().getSysUser(lec.Lecturer);
Sysuser2 user2 = new Sysuser2();
user2 = new Sysuser2().getSysuser2(lec.Lecturer);
float totalCredit = new WorkLoadConfig().getWorkLoadConfig(user2.Lecturer_Type, user.Position).TotalCredit;
float currentCredit = getTotalCredit(lec.AcademicYear, lec.Semester, lec.Lecturer);
if (currentCredit >= totalCredit)
{
response = lec;
break;
}
}
return(response);
}
public LecturerTableData checkSessionDupLectureTime2(List <LecturerTableData> lecture_table)
{
List <LecturerTableData> dupLec = new List <LecturerTableData>();
LecturerTableData result = new LecturerTableData();
int index = 0;
if (HttpContext.Current.Session["index"] != null)
{
index = (int)HttpContext.Current.Session["index"];
}
if (HttpContext.Current.Session["save_lecturer"] == null)
{
result = null;
}
else
{
List <LecturerTableData> tableData = (List <LecturerTableData>)HttpContext.Current.Session["save_lecturer"];
foreach (LecturerTableData lec in lecture_table)
{
string start = lec.Teaching_Start_Time.Replace(':', '.');
string stop = lec.Teaching_End_Time.Replace(':', '.');
double num_start = Convert.ToDouble(start);
double num_stop = Convert.ToDouble(stop);
foreach (LecturerTableData table in tableData)
{
string start2 = table.Teaching_Start_Time.Replace(':', '.');
string stop2 = table.Teaching_End_Time.Replace(':', '.');
double num_start2 = Convert.ToDouble(start2);
double num_stop2 = Convert.ToDouble(stop2);
if (table.index_of_teaching != index && table.Lecturer != "0000000000000" && table.Lecturer == lec.Lecturer && table.Teaching_Day == lec.Teaching_Day && ((num_start >= num_start2 && num_start < num_stop2) || (num_stop > num_start2 && num_stop <= num_stop2) || (num_start <= num_start2 && num_stop >= num_stop2)))
{
dupLec.Add(table);
}
}
}
if (dupLec.Count == 0)
{
result = null;
}
else
{
result = dupLec[0];
}
}
return(result);
}
// V 1.0.0
public LecturerTableData checkDupLecturer(List <LecturerTableData> lecturer_table, string degree_char)
{
LecturerTableData lecturer_dup = new LecturerTableData();
try
{
string TableName = getTableName(degree_char);
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
foreach (LecturerTableData lec in lecturer_table)
{
LecturerTableData lecturer = new LecturerTableData();
double start_time = Convert.ToDouble(lec.Teaching_Start_Time.Replace(':', '.'));
double stop_time = Convert.ToDouble(lec.Teaching_End_Time.Replace(':', '.'));
string sql = "select * from " + TableName + " where COURSE_TYPE != '4' And COURSE_TYPE != '5' And COURSE_TYPE != '6' And ACADEMIC_YEAR='" + lec.AcademicYear + "' And SEMESTER='" + lec.Semester + "' And LECTURER_ID='" + lec.Lecturer + "' And LECTURER_ID != '0000000000000' And TEACHING_DAY='" + lec.Teaching_Day + "' AND (( " + start_time + " >= TO_NUMBER(replace(teaching_start_time,':','.'),'9999.99') AND " + start_time + " < TO_NUMBER(replace(teaching_end_time,':','.'),'9999.99')) OR (" + stop_time + " > TO_NUMBER(replace(teaching_start_time,':','.'),'9999.99') AND " + stop_time + " <= TO_NUMBER(replace(teaching_end_time,':','.'),'9999.99') OR (" + start_time + " <= TO_NUMBER(replace(teaching_start_time,':','.'),'9999.99') AND " + stop_time + " >= TO_NUMBER(replace(teaching_end_time,':','.'),'9999.99') )))";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
if (allData.Count > 0)
{
DataRowView rowData = allData[0];
lecturer.AcademicYear = rowData["ACADEMIC_YEAR"].ToString();
lecturer.Semester = rowData["SEMESTER"].ToString();
lecturer.Course_Code = rowData["COURSE_CODE"].ToString();
lecturer.Course_Type = rowData["COURSE_TYPE"].ToString();
lecturer.Sec_No = Convert.ToInt16(rowData["SEC_NO"].ToString());
lecturer.SubSec_No = Convert.ToInt16(rowData["SUBSEC_NO"].ToString());
lecturer.Room_Code = rowData["ROOM_CODE"].ToString();
lecturer.Building_Code = rowData["BUILDING_CODE"].ToString();
lecturer.Campus_Code = rowData["CAMPUS_CODE"].ToString();
lecturer.Teaching_Day = rowData["TEACHING_DAY"].ToString();
lecturer.Teaching_Start_Time = rowData["TEACHING_START_TIME"].ToString();
lecturer.Teaching_End_Time = rowData["TEACHING_END_TIME"].ToString();
lecturer.Lecturer = rowData["LECTURER_ID"].ToString();
lecturer_dup = lecturer;
break;
}
else
{
lecturer_dup = null;
}
}
}
catch (Exception err)
{
HttpContext.Current.Session["response"] = "Unit Test:LecturerTable:checkDupLecturer" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(lecturer_dup);
}
// V 1.0.0
public string[] updateLecturerTable(List <LecturerTableData> lecturer_table, LecturerTableData old_lecturer, string degree_char)
{
string[] response = new string[lecturer_table.Count];
try
{
string TableName = getTableName(degree_char);
int i = 0;
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
if (deleteLecturerTable(old_lecturer.AcademicYear, old_lecturer.Semester, old_lecturer.Course_Code, old_lecturer.Sec_No, old_lecturer.SubSec_No, degree_char) == "OK")
{
foreach (LecturerTableData data in lecturer_table)
{
string sql = "Insert Into " + TableName + "(ACADEMIC_YEAR,SEMESTER,COURSE_CODE,COURSE_TYPE,SEC_NO,SUBSEC_NO,ROOM_CODE,TEACHING_DAY,TEACHING_START_TIME,TEACHING_END_TIME,LECTURER_ID,BUILDING_CODE,CAMPUS_CODE) Values('" + data.AcademicYear + "','" + data.Semester + "','" + data.Course_Code + "','" + data.Course_Type + "'," + data.Sec_No + "," + data.SubSec_No + ",'" + data.Room_Code + "','" + data.Teaching_Day + "','" + data.Teaching_Start_Time + "','" + data.Teaching_End_Time + "','" + data.Lecturer + "','" + data.Building_Code + "','" + data.Campus_Code + "' )";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response[i] = "OK";
}
}
catch (Exception e)
{
response[i] = e.Message.ToString() + " ";
}
i++;
}
}
else
{
for (int j = 0; j < response.Length; j++)
{
response[j] = "Can't Update";
}
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:LecturerTable:updateLecturerTable" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
// V 1.0.0
public List <LecturerTableData> getLecturerTable(string academic_year, string semester, string teaching_day, string lecture_id, string degree_char)
{
List <LecturerTableData> lecturerData = new List <LecturerTableData>();
try
{
string TableName = getTableName(degree_char);
string sql = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
sql = "Select * From " + TableName + " WHERE ACADEMIC_YEAR='" + academic_year + "' And SEMESTER='" + semester + "' And TEACHING_DAY='" + teaching_day + "' And LECTURER_ID='" + lecture_id + "' Order By TEACHING_START_TIME";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
LecturerTableData lecturer_data = new LecturerTableData();
lecturer_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString();
lecturer_data.Semester = rowData["SEMESTER"].ToString();
lecturer_data.Course_Code = rowData["COURSE_CODE"].ToString();
lecturer_data.Course_Type = rowData["COURSE_TYPE"].ToString();
lecturer_data.Sec_No = Convert.ToInt16(rowData["SEC_NO"].ToString());
lecturer_data.SubSec_No = Convert.ToInt16(rowData["SUBSEC_NO"].ToString());
lecturer_data.Room_Code = rowData["ROOM_CODE"].ToString();
lecturer_data.Building_Code = rowData["BUILDING_CODE"].ToString();
lecturer_data.Campus_Code = rowData["CAMPUS_CODE"].ToString();
lecturer_data.Teaching_Day = rowData["TEACHING_DAY"].ToString();
lecturer_data.Teaching_Start_Time = rowData["TEACHING_START_TIME"].ToString();
lecturer_data.Teaching_End_Time = rowData["TEACHING_END_TIME"].ToString();
lecturer_data.Lecturer = rowData["LECTURER_ID"].ToString();
lecturer_data.Course_Degree_Char = degree_char;
lecturerData.Add(lecturer_data);
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:LecturerTable:getLecturerTable" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(lecturerData);
}
public LecturerTableData checkSessionDupLectureTime1(List <LecturerTableData> lecture_table)
{
LecturerTableData result = new LecturerTableData();
result = null;
if (HttpContext.Current.Session["save_lecturer"] != null)
{
List <LecturerTableData> tableData = (List <LecturerTableData>)HttpContext.Current.Session["save_lecturer"];
foreach (LecturerTableData lec in lecture_table)
{
string start = lec.Teaching_Start_Time.Replace(':', '.');
string stop = lec.Teaching_End_Time.Replace(':', '.');
double num_start = Convert.ToDouble(start);
double num_stop = Convert.ToDouble(stop);
foreach (LecturerTableData table in tableData)
{
string start2 = table.Teaching_Start_Time.Replace(':', '.');
string stop2 = table.Teaching_End_Time.Replace(':', '.');
double num_start2 = Convert.ToDouble(start2);
double num_stop2 = Convert.ToDouble(stop2);
if (table.Lecturer != "0000000000000" && table.Lecturer == lec.Lecturer && table.Teaching_Day == lec.Teaching_Day && ((num_start >= num_start2 && num_start < num_stop2) || (num_stop > num_start2 && num_stop <= num_stop2) || (num_start <= num_start2 && num_stop >= num_stop2)))
{
result = table;
break;
}
}
}
return(result);
}
else
{
return(null);
}
}
public LecturerTableData checkHourRefNormalDay(List <LecturerTableData> alllecturer_data, TeachingTableData teaching_data)
{
LecturerTableData response = new LecturerTableData();
if (teaching_data.Teaching_Day == "1" || teaching_data.Teaching_Day == "2" || teaching_data.Teaching_Day == "3" || teaching_data.Teaching_Day == "4" || teaching_data.Teaching_Day == "5")
{
int start_time = (int)Convert.ToDouble(teaching_data.Teaching_Start_Time.Replace(':', '.'));
if (start_time >= 16)
{
foreach (LecturerTableData lec in alllecturer_data)
{
SysUser user = new SysUser();
user = new SysUser().getSysUser(lec.Lecturer);
Sysuser2 user2 = new Sysuser2();
user2 = new Sysuser2().getSysuser2(lec.Lecturer);
if (user2.Lecturer_Type != "03") // อาจารย์พิเศษ
{
float totalHourRef = new WorkLoadConfig().getWorkLoadConfig(user2.Lecturer_Type, user.Position).HourReference;
float currentHourRef = getInTimeHourRef(teaching_data.AcademicYear, teaching_data.Semester, lec.Lecturer);
if (currentHourRef < totalHourRef)
{
response = lec;
break;
}
}
}
}
}
return(response);
}
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.lecturer))
{
// ======== Process ===========
if (!Page.IsPostBack)
{
if (Session["Extend_Data"] == null)
{
Response.Redirect("List_Course_Lecturer.aspx");
}
Session.Remove("save_student_data");
divFail.Visible = false;
divDupRegis.Visible = false;
divDupExtend.Visible = false;
btnSAVE.Enabled = false;
btnEdit.Enabled = false;
btnEdit.Visible = false;
LecturerTableData lec = (LecturerTableData)Session["Extend_Data"];
lecturer_data = new Lecturer().getLecturer(lec.Lecturer);
course_data = new Course().getCourse(lec.Course_Code);
string course_type = "";
string course_sec = "";
if (lec.Course_Type == "1")
{
course_type = "S.";
}
else if (lec.Course_Type == "2")
{
course_type = "L.";
}
else if (lec.Course_Type == "4")
{
course_type = "T.";
}
else if (lec.Course_Type == "5")
{
course_type = "M.";
}
else if (lec.Course_Type == "6")
{
course_type = "SP.";
}
else if (lec.Course_Type == "7")
{
course_type = "D.";
}
if (lec.SubSec_No != 0)
{
course_sec = lec.SubSec_No.ToString();
}
else
{
course_sec = lec.Sec_No.ToString();
}
lblLec.Text = lecturer_data.Lecturer_ShortName + " " + lecturer_data.First_ThaiName + " " + lecturer_data.Family_ThaiName;
lblHead.Text = course_type + course_sec + " " + course_data.Course_Code + " " + course_data.Course_Thainame + " " + course_data.Course_Engname;
}
row1 = Request.QueryString["show_row"];
divSuccess.Visible = false;
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
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("ตรวจสอบไม่พบ นักศึกษาที่ค้นหา");
}
}
}
// V 1.0.0
public List <LecturerTableData> getAllLecturerSecCourse(string academic_year, string semester, string course_code, int sec_num, int subsec_num, string teach_day, string start_time, string end_time)
{
List <LecturerTableData> lecturerData = new List <LecturerTableData>();
try
{
string sql = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
sql = "Select * From LECTURER_TABLE WHERE ACADEMIC_YEAR='" + academic_year + "' And SEMESTER='" + semester + "' AND COURSE_CODE='" + course_code + "' AND SEC_NO=" + sec_num + " AND SUBSEC_NO=" + subsec_num + " AND TEACHING_DAY='" + teach_day + "' AND TEACHING_START_TIME='" + start_time + "' AND TEACHING_END_TIME = '" + end_time + "' ";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
LecturerTableData lecturer_data = new LecturerTableData();
lecturer_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString();
lecturer_data.Semester = rowData["SEMESTER"].ToString();
lecturer_data.Course_Code = rowData["COURSE_CODE"].ToString();
lecturer_data.Course_Type = rowData["COURSE_TYPE"].ToString();
lecturer_data.Sec_No = Convert.ToInt16(rowData["SEC_NO"].ToString());
lecturer_data.SubSec_No = Convert.ToInt16(rowData["SUBSEC_NO"].ToString());
lecturer_data.Room_Code = rowData["ROOM_CODE"].ToString();
lecturer_data.Building_Code = rowData["BUILDING_CODE"].ToString();
lecturer_data.Campus_Code = rowData["CAMPUS_CODE"].ToString();
lecturer_data.Teaching_Day = rowData["TEACHING_DAY"].ToString();
lecturer_data.Teaching_Start_Time = rowData["TEACHING_START_TIME"].ToString();
lecturer_data.Teaching_End_Time = rowData["TEACHING_END_TIME"].ToString();
lecturer_data.Lecturer = rowData["LECTURER_ID"].ToString();
lecturer_data.Course_Degree_Char = "B";
lecturerData.Add(lecturer_data);
}
sql = "Select * From GRAD_LECTURER_TABLE WHERE ACADEMIC_YEAR='" + academic_year + "' And SEMESTER='" + semester + "' AND COURSE_CODE='" + course_code + "' AND SEC_NO=" + sec_num + " AND SUBSEC_NO=" + subsec_num + " AND TEACHING_DAY='" + teach_day + "' AND TEACHING_START_TIME='" + start_time + "' AND TEACHING_END_TIME = '" + end_time + "' ";
oracleObj.SelectCommand = sql;
allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
LecturerTableData lecturer_data = new LecturerTableData();
lecturer_data.AcademicYear = rowData["ACADEMIC_YEAR"].ToString();
lecturer_data.Semester = rowData["SEMESTER"].ToString();
lecturer_data.Course_Code = rowData["COURSE_CODE"].ToString();
lecturer_data.Course_Type = rowData["COURSE_TYPE"].ToString();
lecturer_data.Sec_No = Convert.ToInt16(rowData["SEC_NO"].ToString());
lecturer_data.SubSec_No = Convert.ToInt16(rowData["SUBSEC_NO"].ToString());
lecturer_data.Room_Code = rowData["ROOM_CODE"].ToString();
lecturer_data.Building_Code = rowData["BUILDING_CODE"].ToString();
lecturer_data.Campus_Code = rowData["CAMPUS_CODE"].ToString();
lecturer_data.Teaching_Day = rowData["TEACHING_DAY"].ToString();
lecturer_data.Teaching_Start_Time = rowData["TEACHING_START_TIME"].ToString();
lecturer_data.Teaching_End_Time = rowData["TEACHING_END_TIME"].ToString();
lecturer_data.Lecturer = rowData["LECTURER_ID"].ToString();
lecturer_data.Course_Degree_Char = "M";
lecturerData.Add(lecturer_data);
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:LecturerTable:getAllLecturerSecCourse" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(lecturerData);
}
public LecturerTableData checkHourRefNormalDay2(List <LecturerTableData> alllecturer_data, TeachingTableData teaching_data, SubCreditData subcredit)
{
LecturerTableData response = new LecturerTableData();
if (teaching_data.Teaching_Day == "1" || teaching_data.Teaching_Day == "2" || teaching_data.Teaching_Day == "3" || teaching_data.Teaching_Day == "4" || teaching_data.Teaching_Day == "5")
{
CourseData course_data = new CourseData();
HourReferData hour_data = new HourReferData();
int start_time = (int)Convert.ToDouble(teaching_data.Teaching_Start_Time.Replace(':', '.'));
if (start_time >= 16)
{
foreach (LecturerTableData lec in alllecturer_data)
{
float hour_ref = 0;
SysUser user = new SysUser();
user = new SysUser().getSysUser(lec.Lecturer);
Sysuser2 user2 = new Sysuser2();
user2 = new Sysuser2().getSysuser2(lec.Lecturer);
if (user2.Lecturer_Type != "03") // อาจารย์พิเศษ
{
course_data = new Course().getCourse(teaching_data.Course_Code);
if (course_data.Course_DegreeLevel == "01")// ปวช.
{
hour_data = new HourRefer().getHourRefer("U", teaching_data.Course_Type);
hour_ref = hour_data.HourRefer * subcredit.SubCredit;
}
else if (course_data.Course_DegreeLevel == "02") //ป.ตรี
{
hour_data = new HourRefer().getHourRefer("B", teaching_data.Course_Type);
hour_ref = hour_data.HourRefer * subcredit.SubCredit;
}
else
{ // บัณฑิต
hour_data = new HourRefer().getHourRefer("M", teaching_data.Course_Type);
hour_ref = hour_data.HourRefer * subcredit.SubCredit;
}
float totalHourRef = new WorkLoadConfig().getWorkLoadConfig(user2.Lecturer_Type, user.Position).HourReference;
float currentHourRef = getHourRef(teaching_data.AcademicYear, teaching_data.Semester, lec.Lecturer);
currentHourRef -= hour_ref;
if (currentHourRef < totalHourRef)
{
response = lec;
break;
}
}
}
}
}
return(response);
}
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.lecturer))
{
// ======== Process ===========
config_data = new SystemConfig().getConfig();
academic_year = config_data.AcademicYear;
semester = config_data.Semester;
row1 = Request.QueryString["show_row"];
if (Session["showCourse" + row1] == null)
{
Response.Redirect("List_Course_Lecturer.aspx");
}
else
{
LecturerTableData lectuere_data = new LecturerTableData();
lnkADD.NavigateUrl = "Extend_Student.aspx?show_row=" + row1;
lectuere_data = (LecturerTableData)Session["showCourse" + row1];
Session["Extend_Data"] = lectuere_data;
lec_info = new Lecturer().getLecturer(lectuere_data.Lecturer);
course_info = new Course().getCourse(lectuere_data.Course_Code);
string course_type = "";
string course_sec = "";
if (lectuere_data.Course_Type == "1")
{
course_type = "S.";
}
else if (lectuere_data.Course_Type == "2")
{
course_type = "L.";
}
else if (lectuere_data.Course_Type == "4")
{
course_type = "T.";
}
else if (lectuere_data.Course_Type == "5")
{
course_type = "M.";
}
else if (lectuere_data.Course_Type == "6")
{
course_type = "SP.";
}
else if (lectuere_data.Course_Type == "7")
{
course_type = "D.";
}
if (lectuere_data.SubSec_No != 0)
{
course_sec = lectuere_data.SubSec_No.ToString();
}
else
{
course_sec = lectuere_data.Sec_No.ToString();
}
lblLec.Text = lec_info.Lecturer_ShortName + " " + lec_info.First_ThaiName + " " + lec_info.Family_ThaiName;
lblHeader.Text = course_type + course_sec + " " + course_info.Course_Code + " " + course_info.Course_Thainame + " " + course_info.Course_Engname;
if (!Page.IsPostBack)
{
// Session.Remove("ApproveRegis");
}
try
{
List <RegistrationData> temp1 = new Student_Registration().getStudentRegistration(academic_year, semester, lectuere_data.Course_Code, lectuere_data.Sec_No, lectuere_data.SubSec_No);
// List<RegistrationData> temp2 = new Student_Registration().getStudentRegistration(academic_year, semester, lectuere_data.Course_Code, lectuere_data.Sec_No, lectuere_data.SubSec_No, "M");
foreach (RegistrationData reg in temp1)
{
studentRegisData.Add(reg);
}
//foreach (RegistrationData reg in temp2)
//{
// studentRegisData.Add(reg);
//}
studentExtendData = new ExtendAvailableStudent().getExtendStudent(academic_year, semester, lectuere_data.Course_Code, lectuere_data.Sec_No, lectuere_data.SubSec_No);
int numrow = 1;
int numrow2 = 1;
string[] ar = { "ลำดับที่", "รหัสนักศึกษา", "ชื่อ-นามสกุล", "คณะ", "หลักสูตร", "ประเภท", "รอบ", "ห้อง", "อาจารย์ที่ปรึกษา อนุมัติ" };
string[] ar2 = { "ลำดับที่", "รหัสนักศึกษา", "ชื่อ-นามสกุล", "คณะ", "หลักสูตร", "ประเภท", "รอบ", "ห้อง", "อาจารย์ผู้ดำเนินการ", "ยกเลิก" };
Table tb1 = new Table();
Table tb2 = new Table();
tb1.Attributes.Add("class", "table table-bordered table-hover table-striped");
tb1.Attributes.Add("id", "dt_basic");
tb2.Attributes.Add("class", "table table-bordered table-hover table-striped");
tb2.Attributes.Add("id", "dt_basic");
TableHeaderRow tRowHead = new TableHeaderRow();
tRowHead.TableSection = TableRowSection.TableHeader;
TableHeaderRow tRowHead2 = new TableHeaderRow();
tRowHead2.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-align-center");
tRowHead.Cells.Add(cellHead);
}
tb1.Rows.Add(tRowHead);
for (int cellCtr = 1; cellCtr <= ar2.Length; cellCtr++)
{
// Create a new cell and add it to the row.
TableHeaderCell cellHead = new TableHeaderCell();
cellHead.Text = ar2[cellCtr - 1];
cellHead.Attributes.Add("class", "text-align-center");
tRowHead2.Cells.Add(cellHead);
}
tb2.Rows.Add(tRowHead2);
foreach (RegistrationData data in studentRegisData)
{
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
TableCell cellNum = new TableCell();
cellNum.Text = numrow.ToString();
cellNum.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellNum);
TableCell cellStudent_ID = new TableCell();
cellStudent_ID.Text = data.Student_ID;
cellStudent_ID.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellStudent_ID);
TableCell cellStudent_Name = new TableCell();
cellStudent_Name.Text = data.First_Thainame + " " + data.Family_Thainame;
cellStudent_Name.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellStudent_Name);
TableCell cellFaculty = new TableCell();
cellFaculty.Text = new Faculty().getFaculty(data.Faculty_Code).Faculty_Thai;
cellFaculty.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellFaculty);
TableCell cellCurri = new TableCell();
cellCurri.Text = data.Curr_Code.Substring(4) + " " + new Curriculum().getCurriculum(data.Curr_Code).Curr_ThaiName;
//cellCurri.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellCurri);
Student student_data = new Student();
student_data = new Student().getStudent(data.Student_ID, new Curriculum().getCurriculum(data.Curr_Code).Degree_Char);
TableCell cellCategory = new TableCell();
cellCategory.Text = student_data.StdCategoryThai;
cellCategory.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellCategory);
TableCell cellSection = new TableCell();
cellSection.Text = student_data.SectionThai;
cellSection.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellSection);
TableCell cellGroup = new TableCell();
cellGroup.Text = student_data.StdGroupName;
cellGroup.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellGroup);
TableCell cellApprove = new TableCell();
if (data.Approve_Status == "y")
{
cellApprove.Text = "อนุมัติ";
cellApprove.Attributes.Add("class", "txt-green-bold text-align-center");
}
else
{
cellApprove.Text = "รออนุมัติ";
cellApprove.Attributes.Add("class", "txt-red text-align-center");
}
tRowBody.Cells.Add(cellApprove);
tb1.Rows.Add(tRowBody);
numrow++;
}
TableRow row = new TableRow();
TableCell cell = new TableCell();
cell.Controls.Add(tb1);
row.Cells.Add(cell);
tblStudentAdvisor.Rows.Add(row);
foreach (ExtendAvailableStudentData data in studentExtendData)
{
Student student_data = new Student();
student_data = new Student().getStudent(data.Student_ID, new DegreeAdmission().getDegreeAdmissionChar(utlObj.getFactorFromStudentID(data.Student_ID, utlObj.stdID_Factor_DegreeAdmission)));
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
TableCell cellNum = new TableCell();
cellNum.Text = numrow2.ToString();
cellNum.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellNum);
TableCell cellStudent_ID = new TableCell();
cellStudent_ID.Text = data.Student_ID;
cellStudent_ID.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellStudent_ID);
TableCell cellStudent_Name = new TableCell();
cellStudent_Name.Text = student_data.First_ThaiName + " " + student_data.Family_ThaiName;
cellStudent_Name.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellStudent_Name);
TableCell cellFaculty = new TableCell();
cellFaculty.Text = student_data.FacultyThai;
cellFaculty.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellFaculty);
TableCell cellCurri = new TableCell();
cellCurri.Text = student_data.Curri_Code.Substring(4) + " " + student_data.CurrThai;
//cellCurri.Text = "-";
tRowBody.Cells.Add(cellCurri);
TableCell cellCategory = new TableCell();
cellCategory.Text = student_data.StdCategoryThai;
cellCategory.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellCategory);
TableCell cellSection = new TableCell();
cellSection.Text = student_data.SectionThai;
cellSection.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellSection);
TableCell cellGroup = new TableCell();
cellGroup.Text = student_data.StdGroupName;
cellGroup.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellGroup);
TableCell cellLecturerAdd = new TableCell();
cellLecturerAdd.Text = new Lecturer().getLecturer(data.LECTURER_ADD).Lecturer_ShortName;
cellLecturerAdd.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellLecturerAdd);
TableCell cellApprove = new TableCell();
cellApprove.Text = "<a href='Cancel_Extend_Student.aspx?student_id=" + data.Student_ID + "&academic_year=" + data.AcademicYear + "&semester=" + data.Semester + "&course_code=" + data.Course_Code + "&sec=" + data.Sec_No + "&subsec=" + data.SubSec_No + "&lecturer_code=" + lectuere_data.Lecturer + "&show_row=" + row1 + "' title='Cancel' data-target='#deleteModal' data-toggle='modal'><h4><i class='fa fa-trash-o'></i></h4></a>";
cellApprove.Attributes.Add("class", "text-align-center");
tRowBody.Cells.Add(cellApprove);
tb2.Rows.Add(tRowBody);
numrow2++;
}
TableRow row2 = new TableRow();
TableCell cell2 = new TableCell();
cell2.Controls.Add(tb2);
row2.Cells.Add(cell2);
tblExtendStudentAdvisor.Rows.Add(row2);
}
catch (Exception err)
{
HttpContext.Current.Session["response"] = "ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
//=============================
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
