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