public AvailableCourseViewModel(AvailableCourse course) : base(course)
{
Brand = course.Brand;
Category = course.Category;
Topic = course.Topic;
DelegateStatus = (DelegateStatus)course.DelegateStatus;
EnrolButtonText = GetEnrolButtonText(DelegateStatus);
EnrolButtonAriaLabel = EnrolButtonText == null ? null : $"{EnrolButtonText} on activity";
}
// V 1.0.0
public List <AvailableStudentData> getAvailableStudent_faculty(string academic_year, string semester, string faculty_code, string degree_char)
{
string TableName = getTableName(degree_char);
List <AvailableStudentData> avaStudent = new List <AvailableStudentData>();
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
oracleObj.SelectCommand = "Select * From " + TableName + " Where ACADEMIC_YEAR='" + academic_year + "' AND SEMESTER='" + semester + "' AND FACULTY_CODE='" + faculty_code + "' Order By COURSE_CODE,SEC_NO,SUBSEC_NO";
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
AvailableCourseData ava_data = new AvailableCourseData();
ava_data = new AvailableCourse().getAvailableCourse(rowData["ACADEMIC_YEAR"].ToString(), rowData["SEMESTER"].ToString(), rowData["COURSE_CODE"].ToString(), Convert.ToInt16(rowData["SEC_NO"].ToString()), degree_char);
CurriculumGeneralData curr_data = new Curriculum().getCurriculum(ava_data.Curr_Code);
if (curr_data.Degree_Char == degree_char)
{
AvailableStudentData ava_student = new AvailableStudentData();
ava_student.AcademicYear = rowData["ACADEMIC_YEAR"].ToString();
ava_student.Semester = rowData["SEMESTER"].ToString();
ava_student.Course_Code = rowData["COURSE_CODE"].ToString();
ava_student.Course_Type = rowData["COURSE_TYPE"].ToString();
ava_student.Sec_No = Convert.ToInt16(rowData["SEC_NO"].ToString());
ava_student.SubSec_No = Convert.ToInt16(rowData["SUBSEC_NO"].ToString());
ava_student.Curr_Code = rowData["CURR_CODE"].ToString();
ava_student.Student_Category_Code = rowData["STD_CATEGORY_CODE"].ToString();
ava_student.Student_Group_Code = rowData["STD_GROUP_CODE"].ToString();
ava_student.Section_Code = rowData["SECTION_CODE"].ToString();
ava_student.Student_Year = Convert.ToInt16(rowData["STUDENT_YEAR"].ToString());
ava_student.Faculty_Code = rowData["FACULTY_CODE"].ToString();
avaStudent.Add(ava_student);
}
}
return(avaStudent);
}
protected void btnEXCEL_Click(object sender, EventArgs e)
{
//Export to Excel
degree_char = ddlDegreeLevel.SelectedValue;
List <AvailableCourseData> availableData = new AvailableCourse().getAvailableCourse(txtACADEMIC_YEAR.Text, ddlSEMESTER.SelectedValue, txtCOURSE_CODE.Text, degree_char);
string fileName = "รายวิชาที่เปิดสอน ภาคการศึกษาที่ " + availableData[0].Semester + "_" + availableData[0].AcademicYear;
utility utname = new utility();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=" + fileName + ".xls");
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = System.Text.Encoding.Unicode;
Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble());
Response.Cache.SetCacheability(HttpCacheability.NoCache);
this.EnableViewState = false;
//StringWriter sw = new StringWriter();
//HtmlTextWriter hw = new HtmlTextWriter(sw);
//panelListAvailableCourse.RenderControl(hw);
Response.Write(AddExcelStyling());
string style = @"<style> .textmode {mso-number-format:'\@'} </style>";
Response.Write(style);
string table_struct1 = createTableStruct();
Response.Write(table_struct1);
Response.Flush();
Response.End();
//End Export to Excel
}
public void Get_available_courses_should_return_courses_for_candidate()
{
// When
const int candidateId = 254480;
const int centreId = 101;
var result = courseDataService.GetAvailableCourses(candidateId, centreId).ToList();
// Then
var expectedFirstCourse = new AvailableCourse
{
Name = "5 Jan Test - New",
Id = 18438,
Brand = "Local content",
Topic = "Microsoft Office",
Category = "Digital Workplace",
DelegateStatus = 0,
HasLearning = true,
HasDiagnostic = true,
IsAssessed = true,
};
result.Should().HaveCountGreaterOrEqualTo(1);
result.First().Should().BeEquivalentTo(expectedFirstCourse);
}
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_faculty) || autro_obj.CheckGroupUser(login_data, group_var.officer_department))
{
divFail.Visible = false;
if ((Session["save_data"] != null) && (Session["service_course"] != null))
{
ConnectDB db = new ConnectDB();
SqlDataSource oracleObj = db.ConnectionOracle();
available_data = (AvailableCourseData)Session["save_data"];
service_code = (bool)Session["service_course"];
CurriculumGeneralData curr = new Curriculum().getCurriculum(available_data.Curr_Code);
degree_char = curr.Degree_Char;
CourseData course_data = new CourseData();
Course course = new Course();
List <string> all_course = new List <string>();
string TableName = new AvailableCourse().getTableName(degree_char);
string sql = "";
if (service_code == true)
{
lblFaculty.Text = "วิชาบริการศึกษา";
lblCurri.Text = curr.Curr_ThaiName + " (ปีหลักสูตร " + curr.Curr_Year + ")";
// ตรวจสอบกำหนดการ
int diffDate = -1;
config_data1 = new TeachExamConfig().getTeachExamConfig();
if (config_data1.Date_Stop != null)
{
diffDate = utlObj.getDiffDate(config_data1.Date_Stop, utlObj.getToday());
}
//วิชาการคณะ
if (autro_obj.CheckGroupUser(login_data, group_var.officer_faculty))
{
List <string> faculty_authorized = autro_obj.getFaculty_Authorized(login_data, group_var.officer_faculty);
sql = "Select COURSE_CODE From " + TableName + " Where ACADEMIC_YEAR='" + available_data.AcademicYear + "' And SEMESTER='" + available_data.Semester + "' And CURR_CODE='" + available_data.Curr_Code + "' And (";
int ii = 0;
foreach (string fac in faculty_authorized)
{
ii++;
sql += "FACULTY_CODE= '" + fac + "'";
if (faculty_authorized.Count != ii)
{
sql += " OR ";
}
}
sql += ") GROUP By COURSE_CODE Order By COURSE_CODE";
}
//วิชาการภาค
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);
sql = "Select COURSE_CODE From " + TableName + " Where ACADEMIC_YEAR='" + available_data.AcademicYear + "' And SEMESTER='" + available_data.Semester + "' And CURR_CODE='" + available_data.Curr_Code + "' And (";
int ii = 0;
foreach (string dep in department_authorized)
{
ii++;
sql += "DEPARTMENT_CODE= '" + dep + "'";
if (department_authorized.Count != ii)
{
sql += " OR ";
}
}
sql += ") GROUP By COURSE_CODE Order By COURSE_CODE";
}
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
all_course.Clear();
foreach (DataRowView rowData in allData)
{
int diffExtDate = -1;
config_data2 = new TeachExamConfig().getExtendTeachExamConfig(rowData["COURSE_CODE"].ToString().Substring(0, 4));
if (config_data2.Date_Stop != null)
{
diffExtDate = utlObj.getDiffDate(config_data2.Date_Stop, utlObj.getToday());
}
if (diffDate >= 0)
{
all_course.Add(rowData["COURSE_CODE"].ToString());
}
else if (diffExtDate >= 0)
{
all_course.Add(rowData["COURSE_CODE"].ToString());
}
}
}
else if (service_code == false)
{
lblFaculty.Text = new Faculty().getFaculty(available_data.Faculty_Code).Faculty_Thai;
lblCurri.Text = curr.Curr_Code + " " + curr.Curr_ThaiName;
sql = "Select COURSE_CODE From " + TableName + " Where ACADEMIC_YEAR='" + available_data.AcademicYear + "' And SEMESTER='" + available_data.Semester + "' And FACULTY_CODE='" + available_data.Faculty_Code + "' And DEPARTMENT_CODE='" + available_data.Department_Code + "' And CURR_CODE='" + available_data.Curr_Code + "' GROUP By COURSE_CODE Order By COURSE_CODE";
oracleObj.SelectCommand = sql;
DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty);
foreach (DataRowView rowData in allData)
{
all_course.Add(rowData["COURSE_CODE"].ToString());
}
}
RadioButton[] radio = new RadioButton[all_course.Count];
int i = 0;
// Head Table
string[] ar = { "รหัสวิชา", "ชื่อวิชา", "หน่วยกิต", "เลือก" };
Table tb1 = new Table();
tb1.Attributes.Add("class", "table table-bordered table-hover");
tb1.Attributes.Add("id", "dt_basic");
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.Attributes.Add("class", "text-center");
cellHead.Text = ar[cellCtr - 1];
tRowHead.Cells.Add(cellHead);
}
tb1.Rows.Add(tRowHead);
foreach (string course_code in all_course)
{
TableRow tRowBody = new TableRow();
tRowBody.TableSection = TableRowSection.TableBody;
course_data = course.getCourse(course_code);
if (course_data.Practice != 0 && course_data.Theory != 0)
{
TableCell cellCourse_Code = new TableCell();
cellCourse_Code.Text = course_data.Course_Code;
tRowBody.Cells.Add(cellCourse_Code);
TableCell cellCourse_Name = new TableCell();
cellCourse_Name.Text = course_data.Course_Thainame + "<br/>" + course_data.Course_Engname;
tRowBody.Cells.Add(cellCourse_Name);
TableCell cellCourse_Credit = new TableCell();
cellCourse_Credit.Attributes.Add("class", "text-center");
cellCourse_Credit.Text = Convert.ToString(course_data.Credit) + "(" + Convert.ToString(course_data.Theory) + "-" + Convert.ToString(course_data.Practice) + "-" + course_data.Self_Study.ToString() + ")";
tRowBody.Cells.Add(cellCourse_Credit);
TableCell cellCourse_Radio = new TableCell();
cellCourse_Radio.Attributes.Add("class", "text-center");
radio[i] = new RadioButton();
radio[i].ID = course_data.Course_Code;
radio[i].AutoPostBack = true;
radio[i].GroupName = "course_group";
if (Session["selected_course"] != null)
{
if (radio[i].ID == (string)Session["selected_course"])
{
radio[i].Checked = true;
}
}
radio[i].CheckedChanged += new EventHandler(radioButtons_CheckedChanged);
cellCourse_Radio.Controls.Add(radio[i]);
tRowBody.Cells.Add(cellCourse_Radio);
tb1.Rows.Add(tRowBody);
i++;
}
}
if (!Page.IsPostBack)
{
//A1.Disabled = true;
}
TableRow row = new TableRow();
TableCell cell = new TableCell();
cell.Controls.Add(tb1);
row.Cells.Add(cell);
tblCourse.Rows.Add(row);
}
else
{
divShow.Visible = false;
divFail.Visible = true;
}
}
else
{
HttpContext.Current.Session["response"] = "ตรวจสอบไม่พบสิทธิ์การเข้าใช้งาน";
HttpContext.Current.Response.Redirect("err_response.aspx");
}
}
}
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");
}
}
