public JsonResult CourseTimePerSemesterSearch(int schoolYear, string semester)
{
try
{
SchoolContext db = new SchoolContext();
List <GetCourseTimePerSemester> getCourseTimePerSemesterList = new List <GetCourseTimePerSemester>();
var schoolsemester = (semester == "第一學期") ? Semester.F : Semester.S;
var courseTimePerSemester = db.CourseTimePerSemester.Where(x => x.StartingSchoolYear == schoolYear && x.Semester == schoolsemester).ToList();
foreach (var c in courseTimePerSemester)
{
var semesterString = (c.Semester == Semester.F) ? "第一學期" : "第二學期";
GetCourseTimePerSemester getCourseTimePerSemester = new GetCourseTimePerSemester();
getCourseTimePerSemester.CourseTimePerSemesterID = c.ID;
getCourseTimePerSemester.SchoolYearSemester = c.StartingSchoolYear + "學年度" + semesterString;
getCourseTimePerSemester.SchoolSystem = c.Section;
getCourseTimePerSemester.CourseTime = (c.Grade > 3) ? c.Grade + "年級(含以上) " + c.SignupBeginDate.ToString("yyyy/MM/dd HH:mm") + " ~ " + c.SignupEndDate.ToString("yyyy/MM/dd HH:mm") : c.Grade + "年級 " + c.SignupBeginDate.ToString("yyyy/MM/dd HH:mm") + " ~ " + c.SignupEndDate.ToString("yyyy/MM/dd HH:mm");
getCourseTimePerSemesterList.Add(getCourseTimePerSemester);
}
return(Json(new { courseTimePerSemester = getCourseTimePerSemesterList }));
}
catch (Exception ex)
{
return(Json(new { message = ex.Message, error = false }));
}
}
public JsonResult GetCourseTimePerSemester()
{
try
{
SchoolContext db = new SchoolContext();
List <GetCourseTimePerSemester> getCourseTimePerSemesterList = new List <GetCourseTimePerSemester>();
List <string> sectionList = new List <string>();
var section = db.SectionDepartment.Where(x => x.CourseSorts == CourseSorts.C).Select(c => new { Section = c.Section }).Distinct().ToList();
foreach (var s in section)
{
sectionList.Add(s.Section);
}
var courses = db.Course.Where(x => x.IsActive == true).OrderByDescending(x => x.CourseID).ToList();
var startingSchoolYear = courses[0].StartingSchoolYear;
var schoolsemester = courses[0].Semester;
var schoolsemesterString = (courses[0].Semester == Semester.F)? "第一學期" : "第二學期";
var courseTimePerSemester = db.CourseTimePerSemester.Where(x => x.StartingSchoolYear == startingSchoolYear && x.Semester == schoolsemester).ToList();
foreach (var c in courseTimePerSemester)
{
var semesterString = (c.Semester == Semester.F)? "第一學期" : "第二學期";
GetCourseTimePerSemester getCourseTimePerSemester = new GetCourseTimePerSemester();
getCourseTimePerSemester.CourseTimePerSemesterID = c.ID;
getCourseTimePerSemester.SchoolYearSemester = c.StartingSchoolYear + "學年度" + semesterString;
getCourseTimePerSemester.SchoolSystem = c.Section;
getCourseTimePerSemester.CourseTime = (c.Grade > 3)? c.Grade + "年級(含以上) " + c.SignupBeginDate.ToString("yyyy/MM/dd HH:mm") + " ~ " + c.SignupEndDate.ToString("yyyy/MM/dd HH:mm") : c.Grade + "年級 " + c.SignupBeginDate.ToString("yyyy/MM/dd HH:mm") + " ~ " + c.SignupEndDate.ToString("yyyy/MM/dd HH:mm");
getCourseTimePerSemesterList.Add(getCourseTimePerSemester);
}
return(Json(new { schoolYear = startingSchoolYear, semester = schoolsemesterString, sections = sectionList, courseTimePerSemester = getCourseTimePerSemesterList }));
}
catch (Exception ex)
{
return(Json(new { message = ex.Message, error = false }));
}
}
