public JsonResult Info([FromQuery] CollegeInfoRequest collegeName) { var response = new Response { Code = 0, Data = null }; try { var enrollment = _context.CollegeEnrollments.Include(c => c.Major).Where(c => c.Uname == collegeName.College).ToArrayAsync().Result; var enrollmentInfo = new EnrollmentInfo[enrollment.Length]; for (int i = 0; i < enrollment.Length; i++) { enrollmentInfo[i] = new EnrollmentInfo { Key = i, Profession = enrollment[i].Major.Mname, Batch = enrollment[i].Bname, Count = enrollment[i].Menrollment }; } response.Data = enrollmentInfo; } catch (Exception ex) { response.Code = 1; _logger.LogError(ex, "An error occurred while get college enrollment infomation."); } return(Json(response)); }
public JsonResult Grade([FromQuery] CollegeInfoRequest collegeName)//查分数线,有待完善(加上时间约束) { var response = new Response { Code = 1, Data = null }; try { var students = from u in _context.Admissions.Include(a => a.AcceptedStudent) select u.AcceptedStudent; students.OrderByDescending(s => s.TotalGrade); var gradeLine = students.Select(s => s.TotalGrade).Last(); response.Data = gradeLine; response.Code = 0; } catch (Exception ex) { _logger.LogError(ex, "Can't get the school's gradeline"); } return(Json(response)); }