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