public async Task <IActionResult> OnGetAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
LecturerClassStat = await _context.LecturerClassStat.FirstOrDefaultAsync(m => m.LecturerClassStatID == id);
if (LecturerClassStat == null)
{
return(NotFound());
}
return(Page());
}
public async Task <IActionResult> OnPostAsync(int?id)
{
if (id == null)
{
return(NotFound());
}
LecturerClassStat = await _context.LecturerClassStat.FindAsync(id);
if (LecturerClassStat != null)
{
_context.LecturerClassStat.Remove(LecturerClassStat);
await _context.SaveChangesAsync();
}
return(RedirectToPage("./Index"));
}
public async Task <IActionResult> OnGetJsonAsync(string academicYear, string username)
{
if (academicYear == null || username == null)
{
return(NotFound());
}
//LecturerClassStat = await _context.LecturerClassStat.FirstOrDefaultAsync(m => m.LecturerClassStatID == id);
string academicYearID = academicYear.Replace("-", "/");
LecturerClassStat = (await _context.LecturerClassStat
.FromSqlInterpolated($"EXEC SPR_GPR_LecturerClassStats @AcademicYear={academicYearID}, @Username={username}")
.ToListAsync())
.FirstOrDefault();
//if (LecturerClassStat == null)
//{
// return NotFound();
//}
return(new JsonResult(LecturerClassStat));
}
