public string insertSubCredit(SubCreditData insertData, string degree_char)
{
string response = "";
try
{
string TableName = getTableName(degree_char);
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
string sql = "Insert Into " + TableName + "(ACADEMIC_YEAR,SEMESTER,COURSE_CODE,SEC_NO,SUBSEC_NO,LECTURER_ID,SUB_CREDIT,TEACHING_DAY,TEACHING_START_TIME,TEACHING_END_TIME) Values('" + insertData.AcademicYear + "','" + insertData.Semester + "','" + insertData.Course_Code + "'," + insertData.Sec_No + "," + insertData.SubSec_No + ",'" + insertData.Lecturer + "'," + insertData.SubCredit + ",'" + insertData.Teaching_Day + "','" + insertData.Teaching_Start_Time + "','" + insertData.Teaching_End_Time + "')";
oracleObj.InsertCommand = sql;
try
{
if (oracleObj.Insert() == 1)
{
response = "OK";
}
}
catch (Exception e)
{
response = e.Message.ToString() + " ";
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:SubCredit:insertSubCredit" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(response);
}
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 SubCreditData getSubCredit(string academic_year, string semester, string course_code, int sec_no, int subsec_no, string lecturer_code, string teach_date, string teach_start_time, string teach_end_time, string degree_char)
{
SubCreditData subcredit = new SubCreditData();
string TableName = getTableName(degree_char);
string sql = "";
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
try
{
sql = "Select * From " + TableName + " WHERE ACADEMIC_YEAR='" + academic_year + "' And SEMESTER='" + semester + "' And COURSE_CODE='" + course_code + "' And SEC_NO=" + sec_no + " And SUBSEC_NO=" + subsec_no + " And LECTURER_ID = '" + lecturer_code + "' AND TEACHING_DAY='" + teach_date + "' AND TEACHING_START_TIME='" + teach_start_time + "' AND TEACHING_END_TIME='" + teach_end_time + "' ";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
subcredit.AcademicYear = rowData["ACADEMIC_YEAR"].ToString();
subcredit.Semester = rowData["SEMESTER"].ToString();
subcredit.Course_Code = rowData["COURSE_CODE"].ToString();
subcredit.Sec_No = Convert.ToInt16(rowData["SEC_NO"].ToString());
subcredit.SubSec_No = Convert.ToInt16(rowData["SUBSEC_NO"].ToString());
subcredit.Lecturer = rowData["LECTURER_ID"].ToString();
subcredit.SubCredit = float.Parse(rowData["SUB_CREDIT"].ToString());
}
}
catch
{
HttpContext.Current.Session["response"] = "Unit Test:SubCredit:getSubCredit" + " ไม่สามารถดำเนินการได้";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
return(subcredit);
}
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 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");
}
}
}
private void createCreditTable()
{
CourseData course_data = new Course().getCourse(available_data.Course_Code);
tblSubCredit.Rows.Clear();
// แบ่งโหลด
string[] ar5 = { "ชื่ออาจารย์", "ภาระงานสอน ชั่วโมง/หน่วยกิต", "ชั่วโมงสอนอ้างอิง", "หน่วยกิตรวม", "แบ่งหน่วยกิต" };
Table tb5 = new Table();
tb5.Attributes.Add("class", "table table-bordered table-striped");
tb5.Attributes.Add("id", "dt_basic5");
TableHeaderRow tRowHead5 = new TableHeaderRow();
tRowHead5.TableSection = TableRowSection.TableHeader;
for (int cellCtr = 1; cellCtr <= ar5.Length; cellCtr++)
{
// Create a new cell and add it to the row.
TableHeaderCell cellHead5 = new TableHeaderCell();
cellHead5.Text = ar5[cellCtr - 1];
cellHead5.Attributes.Add("class", "text-align-center");
tRowHead5.Cells.Add(cellHead5);
}
tb5.Rows.Add(tRowHead5);
int i = 0;
List <LecturerTableData> new_lecturertable = new List <LecturerTableData>();
//List<LecturerTableData> tmp = new List<LecturerTableData>();
new_lecturertable = lecturertable.OrderBy(o => o.Lecturer).ToList();
//string lec_code = "";
//foreach (LecturerTableData lect_data in tmp)
// {
// if (lect_data.Lecturer != lec_code)
// {
// new_lecturertable.Add(lect_data);
// }
// lec_code = lect_data.Lecturer;
// }
foreach (LecturerTableData lect_data in new_lecturertable)
{
SubCreditData subcredit_data = new SubCreditData();
SysUser user1 = new SysUser();
user1 = new SysUser().getSysUser(lect_data.Lecturer);
Sysuser2 user2 = new Sysuser2();
user2 = new Sysuser2().getSysuser2(lect_data.Lecturer);
TableRow tRowBody5 = new TableRow();
tRowBody5.TableSection = TableRowSection.TableBody;
TableCell cellLecName = new TableCell();
cellLecName.Text = lecturerObj.getLecturer(lect_data.Lecturer).First_ThaiName + " " + lecturerObj.getLecturer(lect_data.Lecturer).Family_ThaiName;
tRowBody5.Cells.Add(cellLecName);
WorkLoadConfigData workload = new WorkLoadConfigData();
workload = new WorkLoadConfig().getWorkLoadConfig(user2.Lecturer_Type, user1.Position);
TableCell cellLoad = new TableCell();
cellLoad.Text = workload.HourReference.ToString() + " / " + workload.TotalCredit.ToString();
cellLoad.Attributes.Add("class", "text-align-center");
tRowBody5.Cells.Add(cellLoad);
TableCell cellHourRef = new TableCell();
cellHourRef.Text = new WorkLoadCalculate().getHourRef(lect_data.AcademicYear, lect_data.Semester, lect_data.Lecturer).ToString();
cellHourRef.Attributes.Add("class", "text-align-center");
tRowBody5.Cells.Add(cellHourRef);
TableCell cellTotalCredit = new TableCell();
cellTotalCredit.Text = new WorkLoadCalculate().getTotalCredit(lect_data.AcademicYear, lect_data.Semester, lect_data.Lecturer).ToString();
cellTotalCredit.Attributes.Add("class", "text-align-center");
tRowBody5.Cells.Add(cellTotalCredit);
int credit = course_data.Credit;
if (lect_data.Course_Type == "1")
{
if (course_data.Practice != 0)
{
credit = course_data.Theory;
}
else
{
credit = course_data.Credit;
}
}
else if (lect_data.Course_Type == "2")
{
if (course_data.Theory != 0)
{
credit = course_data.Practice / 2;
}
else
{
credit = course_data.Credit;
}
}
TableCell cellSubCredit = new TableCell();
txtSubCredit = new TextBox[new_lecturertable.Count];
txtSubCredit[i] = new TextBox();
txtSubCredit[i].ID = lect_data.Lecturer + lect_data.Teaching_Day + lect_data.Teaching_Start_Time.Replace(":", "").Replace(".", "") + lect_data.Teaching_End_Time.Replace(":", "").Replace(".", "");
txtSubCredit[i].MaxLength = 5;
txtSubCredit[i].Width = 50;
txtSubCredit[i].AutoPostBack = true;
// float sub_credit = new SubCredit().getSubCredit(lect_data.AcademicYear, lect_data.Semester, lect_data.Course_Code, lect_data.Sec_No, lect_data.SubSec_No, lect_data.Lecturer, lect_data.Teaching_Day, lect_data.Teaching_Start_Time, lect_data.Teaching_End_Time, degree_char).SubCredit;
float sub_credit = (float)credit / new_lecturertable.Count;
txtSubCredit[i].Text = sub_credit.ToString();
txtSubCredit[i].Attributes.Add("class", "text-align-center");
txtSubCredit[i].TextChanged += new EventHandler(txtChanged);
cellSubCredit.Attributes.Add("class", "text-align-center");
cellSubCredit.Controls.Add(txtSubCredit[i]);
tRowBody5.Cells.Add(cellSubCredit);
tb5.Rows.Add(tRowBody5);
subcredit_data.AcademicYear = lect_data.AcademicYear;
subcredit_data.Semester = lect_data.Semester;
subcredit_data.Course_Code = lect_data.Course_Code;
subcredit_data.Sec_No = lect_data.Sec_No;
subcredit_data.SubSec_No = lect_data.SubSec_No;
subcredit_data.Lecturer = lect_data.Lecturer;
subcredit_data.SubCredit = sub_credit;
subcredit_data.Teaching_Day = lect_data.Teaching_Day;
subcredit_data.Teaching_Start_Time = lect_data.Teaching_Start_Time;
subcredit_data.Teaching_End_Time = lect_data.Teaching_End_Time;
subcreditData.Add(subcredit_data);
i++;
}
Session["subCredit"] = subcreditData;
TableRow row5 = new TableRow();
TableCell cell5 = new TableCell();
cell5.Controls.Add(tb5);
row5.Cells.Add(cell5);
tblSubCredit.Rows.Add(row5);
}
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);
}
public float checkEditLecturerCredit2(string academic_year, string semester, string lecturer_code, float new_credit, SubCreditData old_subcredit)
{
float response = -1;
SysUser user = new SysUser();
user = new SysUser().getSysUser(lecturer_code);
Sysuser2 user2 = new Sysuser2();
user2 = new Sysuser2().getSysuser2(lecturer_code);
float totalCredit = new WorkLoadConfig().getWorkLoadConfig(user2.Lecturer_Type, user.Position).TotalCredit;
float currentCredit = getTotalCreditforEdit(academic_year, semester, lecturer_code, old_subcredit);
float new_currentCredit = currentCredit + new_credit;
if (new_currentCredit <= totalCredit)
{
response = -1;
}
else
{
response = totalCredit - currentCredit;
}
return(response);
}
