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