public async Task <IActionResult> OnGetAsync(string academicYear, int plan, string course) { if (course == null) { return(NotFound()); } int planRevisionID = 0; if (plan >= 1) { planRevisionID = plan; } else { planRevisionID = int.Parse(_configuration.GetSection("ProResource")["PlanRevisionID"]); } string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(academicYear, _context); Programme = (await _context.Programme .FromSqlInterpolated($"EXEC SPR_ETG_ProgrammeData @AcademicYear={CurrentAcademicYear}, @PlanRevisionID={planRevisionID}, @Course={course}") .ToListAsync()) .FirstOrDefault(); if (Programme == null) { return(NotFound()); } return(Page()); }
public async Task OnGetAsync(string academicYear, int plan, string course) { Guid sessionID = Guid.NewGuid(); //HttpContext.Session.SetString("SessionID", sessionID.ToString()); SessionID = sessionID; //SessionID = Guid.Parse(HttpContext.Session.GetString("SessionID")); int planRevisionID = 0; if (plan >= 1) { planRevisionID = plan; } else { planRevisionID = int.Parse(_configuration.GetSection("ProResource")["PlanRevisionID"]); } AcademicYear = await AcademicYearFunctions.GetAcademicYear(academicYear, _context); UserDetails = await Identity.GetFullName(academicYear, User.Identity.Name.Split('\\').Last(), _context); UserGreeting = Identity.GetGreeting(); SystemVersion = _configuration["Version"]; string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(academicYear, _context); ProgrammeSelectList = await _context.SelectListData .FromSqlInterpolated($"EXEC SPR_ETG_ProgrammeSelectList @AcademicYear={CurrentAcademicYear}, @PlanRevisionID={planRevisionID}") .ToListAsync(); ViewData["CourseSL"] = new SelectList(ProgrammeSelectList, "Code", "Description"); }
public async Task <IActionResult> OnGetJsonAsync(string academicYear, int plan, string course) { int planRevisionID = 0; if (plan >= 1) { planRevisionID = plan; } else { planRevisionID = int.Parse(_configuration.GetSection("ProResource")["PlanRevisionID"]); } string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(academicYear, _context); Programme = (await _context.Programme .FromSqlInterpolated($"EXEC SPR_ETG_ProgrammeData @AcademicYear={CurrentAcademicYear}, @PlanRevisionID={planRevisionID}, @Course={course}") .ToListAsync()) .FirstOrDefault(); var collectionWrapper = new { programme = Programme }; return(new JsonResult(collectionWrapper)); }
public async Task <IActionResult> OnGetAsync(string system, string systemILP, string AcademicYear, string StudentRef, int CourseID) { if (StudentRef == null) { return(NotFound()); } //Student = await _context.Student.ToListAsync(); string systemDB = DatabaseSelector.GetDatabase(_configuration, system); string systemILPDB = DatabaseSelector.GetILPDatabase(_configuration, systemILP, system); string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(AcademicYear, _context); string ProgressionAcademicYear = await AcademicYearFunctions.GetProgressionYear(AcademicYear, _context); SystemID = systemDB; SystemILPID = systemILPDB; UserDetails = await Identity.GetFullName(system, AcademicYear, User.Identity.Name.Split('\\').Last(), _context, _configuration); Student = (await _context.Student .FromSqlInterpolated($"EXEC SPR_PRG_GetStudent @System={systemDB}, @AcademicYear={ProgressionAcademicYear}, @StudentRef={StudentRef}, @CourseID={CourseID}") .ToListAsync()) .FirstOrDefault(); if (Student == null) { return(NotFound()); } return(Page()); }
public async Task OnGetAsync(string system, string academicYear, string measure, int level, string drill) { //ChartData = await _context.ChartData.ToListAsync(); string systemDB = DatabaseSelector.GetDatabase(_configuration, system); string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(academicYear, _context); ChartData = await _context.ChartData .FromSqlInterpolated($"EXEC SPR_PRG_GetOutcomesChartData @System={systemDB}, @AcademicYear={CurrentAcademicYear}, @Measure={measure}, @Level={level}, @Drill={drill}") .ToListAsync(); }
public async Task OnGetAsync(string system, string systemILP, string AcademicYear, int CourseID, int GroupID) { //Student = await _context.Student.ToListAsync(); string systemDB = DatabaseSelector.GetDatabase(_configuration, system); string SystemILPDB = DatabaseSelector.GetILPDatabase(_configuration, systemILP, system); string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(AcademicYear, _context); Student = await _context.Student .FromSqlInterpolated($"EXEC SPR_PRG_GetStudentList @System={systemDB}, @SystemILP={SystemILPDB}, @AcademicYear={CurrentAcademicYear}, @CourseID={CourseID}, @GroupID={GroupID}") .ToListAsync(); }
public async Task OnGetAsync(string system, string systemILP, string academicYear) { string defaultAcademicYear = await AcademicYearFunctions.GetDefaultAcademicYear(_context); string systemDB = DatabaseSelector.GetDatabase(_configuration, system); string systemILPDB = DatabaseSelector.GetILPDatabase(_configuration, systemILP, system); string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(academicYear, _context); string ProgressionAcademicYear = await AcademicYearFunctions.GetProgressionYear(academicYear, _context); SystemID = systemDB; SystemILPID = systemILPDB; AcademicYear = CurrentAcademicYear; ProgressionYear = ProgressionAcademicYear; DefaultAcademicYear = defaultAcademicYear; string selectListDomain = null; selectListDomain = "ACADEMIC_YEAR"; AcademicYearData = await _context.SelectListData .FromSqlInterpolated($"EXEC SPR_PRG_SelectListData @System={systemDB}, @AcademicYear={CurrentAcademicYear}, @Domain={selectListDomain}") .ToListAsync(); ViewData["AcademicYearID"] = new SelectList(AcademicYearData, "Code", "Description", CurrentAcademicYear); selectListDomain = "APPLICATION_OFFER"; ApplicationOffer = await _context.SelectListData .FromSqlInterpolated($"EXEC SPR_PRG_SelectListData @System={systemDB}, @AcademicYear={CurrentAcademicYear}, @Domain={selectListDomain}") .ToListAsync(); ViewData["OfferID"] = new SelectList(ApplicationOffer, "Code", "Description"); selectListDomain = "APPLICATION_CONDITION"; ApplicationCondition = await _context.SelectListData .FromSqlInterpolated($"EXEC SPR_PRG_SelectListData @System={systemDB}, @AcademicYear={CurrentAcademicYear}, @Domain={selectListDomain}") .ToListAsync(); ViewData["ConditionID"] = new SelectList(ApplicationCondition, "Code", "Description"); UserDetails = await Identity.GetFullName(system, academicYear, User.Identity.Name.Split('\\').Last(), _context, _configuration); UserGreeting = Identity.GetGreeting(); SystemVersion = _configuration["Version"]; Browser = Request.Headers["User-Agent"]; ShowCharts = _showCharts; ShowCoursesWithoutEnrols = _showCoursesWithoutEnrols; }
public async Task OnGetAsync(string system, string academicYear, bool showCoursesWithoutEnrols, bool showOutstanding, string search) { if (String.IsNullOrEmpty(search)) { search = ""; } //CourseGroup = await _context.CourseGroup.ToListAsync(); string systemDB = DatabaseSelector.GetDatabase(_configuration, system); string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(academicYear, _context); CourseGroup = await _context.CourseGroup .FromSqlInterpolated($"EXEC SPR_PRG_GetCourseGroupList @System={systemDB}, @AcademicYear={CurrentAcademicYear}, @ShowCoursesWithoutEnrols={showCoursesWithoutEnrols}, @ShowOutstanding={showOutstanding}, @CourseSearch={search}") .ToListAsync(); }
public async Task OnGetAsync(string system, string academicYear, string domain) { //SelectListData = await _context.SelectListData.ToListAsync(); if (String.IsNullOrEmpty(domain)) { domain = ""; } string systemDB = DatabaseSelector.GetDatabase(_configuration, system); string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(academicYear, _context); SelectListData = await _context.SelectListData .FromSqlInterpolated($"EXEC SPR_PRG_SelectListData @System={systemDB}, @AcademicYear={CurrentAcademicYear}, @Domain={domain}") .ToListAsync(); }
public async Task <IActionResult> OnGetJsonAsync(string system, string systemILP, string AcademicYear, int CourseID, int GroupID) { string systemDB = DatabaseSelector.GetDatabase(_configuration, system); string SystemILPDB = DatabaseSelector.GetILPDatabase(_configuration, systemILP, system); string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(AcademicYear, _context); Student = await _context.Student .FromSqlInterpolated($"EXEC SPR_PRG_GetStudentList @System={systemDB}, @SystemILP={SystemILPDB}, @AcademicYear={CurrentAcademicYear}, @CourseID={CourseID}, @GroupID={GroupID}") .ToListAsync(); var collectionWrapper = new { Students = Student }; return(new JsonResult(collectionWrapper)); }
public async Task <IActionResult> OnGetJsonAsync(string system, string academicYear, string domain) { if (String.IsNullOrEmpty(domain)) { domain = ""; } string systemDB = DatabaseSelector.GetDatabase(_configuration, system); string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(academicYear, _context); SelectListData = await _context.SelectListData .FromSqlInterpolated($"EXEC SPR_PRG_SelectListData @System={systemDB}, @AcademicYear={CurrentAcademicYear}, @Domain={domain}") .ToListAsync(); var collectionWrapper = new { SelectOptions = SelectListData }; return(new JsonResult(collectionWrapper)); }
public async Task <IActionResult> OnGetAsync(string system, string AcademicYear, string StudentRef) { if (StudentRef == null) { return(NotFound()); } //Student = await _context.Student.FirstOrDefaultAsync(m => m.StudentRef == id); string systemDB = DatabaseSelector.GetDatabase(_configuration, system); string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(AcademicYear, _context); Student = (await _context.Student .FromSqlInterpolated($"EXEC SPR_PRG_GetStudent @System={systemDB}, @AcademicYear={CurrentAcademicYear}, @StudentRef={StudentRef}") .ToListAsync()) .FirstOrDefault(); if (Student == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnGetJsonAsync(string system, string academicYear, bool requireEnrols, bool showOutstanding, string search) { if (String.IsNullOrEmpty(search)) { search = ""; } //CourseGroup = await _context.CourseGroup.ToListAsync(); string systemDB = DatabaseSelector.GetDatabase(_configuration, system); string CurrentAcademicYear = await AcademicYearFunctions.GetAcademicYear(academicYear, _context); CourseGroup = await _context.CourseGroup .FromSqlInterpolated($"EXEC SPR_PRG_GetCourseGroupList @System={systemDB}, @AcademicYear={CurrentAcademicYear}, @RequireEnrols={requireEnrols}, @ShowOutstanding={showOutstanding}, @CourseSearch={search}") .ToListAsync(); var collectionWrapper = new { Courses = CourseGroup }; return(new JsonResult(collectionWrapper)); }
public async Task OnGetAsync(string academicYear, string collegeGroup, string fac, string team, string username, string dataMode) { string academicYearID = null; if (academicYear != null) { academicYearID = academicYear.Replace("-", "/"); } AcademicYearID = await AcademicYearFunctions.GetAcademicYear(academicYearID, _context); DefaultAcademicYearID = await AcademicYearFunctions.GetDefaultAcademicYear(_context); if (username != null) { AppUserID = username; } else { AppUserID = User.GetUsername(); } if (team != null) { StructureLevelID = 4; } else if (fac != null) { StructureLevelID = 3; } else if (collegeGroup != null) { StructureLevelID = 2; } else { StructureLevelID = 1; } CollegeGroupID = collegeGroup; FacID = fac; TeamID = team; if (dataMode == null) { dataMode = "STATIC"; } DataModeID = dataMode; //UserDetails = await Identity.GetFullName(academicYear, User.Identity.Name.Split('\\').Last(), _context); UserDetails = await Identity.GetFullName(academicYearID, "r.wilson2", _context); string selectListDomain = null; selectListDomain = "ACADEMIC_YEAR"; AcademicYearData = await _context.SelectListData .FromSqlInterpolated($"EXEC SPR_GPR_SelectListData @AcademicYear={AcademicYearID}, @Domain={selectListDomain}") .ToListAsync(); ViewData["AcademicYearID"] = new SelectList(AcademicYearData, "Code", "Description", AcademicYearID); Staff = await _context.Staff .FromSqlInterpolated($"EXEC SPR_GPR_StaffList @AcademicYear={AcademicYearID}") .ToListAsync(); }
public async Task <IActionResult> OnGetAsync(string academicYear, string courseCode, string groupCode, string dataMode) { if (courseCode == null) { return(NotFound()); } AcademicYearID = academicYear; DefaultAcademicYearID = await AcademicYearFunctions.GetDefaultAcademicYear(_context); if (AcademicYearID == null) { AcademicYearID = DefaultAcademicYearID; } string academicYearID = AcademicYearID.Replace("-", "/"); string username = User.Identity.Name.Split('\\').Last(); //Course = await _context.Course.FirstOrDefaultAsync(m => m.CourseID == id); if (dataMode == "STATIC") { Course = (await _context.Course .FromSqlInterpolated($"EXEC SPR_GPR_CourseList_Static @AcademicYear={academicYearID}, @Username={username}, @CoursesITeach={null}, @CourseCode={courseCode}, @GroupCode={groupCode}, @CollegeGroup={null}, @Fac={null}, @Team={null}, @CourseSearch={null}, @StaffSearch={null}") .ToListAsync()) .FirstOrDefault(); } else { Course = (await _context.Course .FromSqlInterpolated($"EXEC SPR_GPR_CourseList @AcademicYear={academicYearID}, @Username={username}, @CoursesITeach={null}, @CourseCode={courseCode}, @GroupCode={groupCode}, @CollegeGroup={null}, @Fac={null}, @Team={null}, @CourseSearch={null}, @StaffSearch={null}") .ToListAsync()) .FirstOrDefault(); } if (Course == null) { return(NotFound()); } FolderPath = (await _context.FolderPath .FromSqlInterpolated($"EXEC SPR_GPR_FolderPath @AcademicYear={academicYearID}, @CollegeGroup={Course.CollegeCode}, @Fac={Course.FacCode}, @Team={Course.TeamCode}, @Course={Course.CourseCode}") .ToListAsync()) .FirstOrDefault(); if (FolderPath != null) { Path = FolderPath.Path; Path = Path.Replace("[FOLDER]", "<i class=\"fas fa-folder-open\"></i>"); Path = Path.Replace("[DIVIDER]", "<i class=\"fas fa-chevron-right\"></i>"); } string selectListDomain = null; selectListDomain = "YES_NO"; YesNoData = await _context.SelectListData .FromSqlInterpolated($"EXEC SPR_GPR_SelectListData @AcademicYear={AcademicYearID}, @Domain={selectListDomain}") .ToListAsync(); ViewData["YesNoID"] = new SelectList(YesNoData, "Code", "Description"); selectListDomain = "PREDICTED_TO_ACHIEVE_BY"; PredictedToAchieveByData = await _context.SelectListData .FromSqlInterpolated($"EXEC SPR_GPR_SelectListData @AcademicYear={AcademicYearID}, @Domain={selectListDomain}") .ToListAsync(); ViewData["PredictedToAchieveByID"] = new SelectList(PredictedToAchieveByData, "Code", "Description"); selectListDomain = Course.PredictedGradeLookupType; PredictedGradeData = await _context.SelectListData .FromSqlInterpolated($"EXEC SPR_GPR_SelectListData @AcademicYear={AcademicYearID}, @Domain={selectListDomain}") .ToListAsync(); ViewData["PredictedGradeID"] = new SelectList(PredictedGradeData, "Code", "Description"); CourseGroupCode = Course.CourseCode; if (dataMode == null) { dataMode = "STATIC"; } DataModeID = dataMode; if (Course.GroupCode != null) { CourseGroupCode += "-" + Course.GroupCode; } return(Page()); }