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 })); } }