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