// To protect from overposting attacks, enable the specific properties you want to bind to.
// For more details, see https://aka.ms/RazorPagesCRUD.
public async Task <IActionResult> OnPostAsync()
{
if (!ModelState.IsValid)
{
return(Page());
}
_context.Attach(Student).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StudentExists(Student.StudentDetailID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToPage("./Index"));
}
// To protect from overposting attacks, enable the specific properties you want to bind to.
// For more details, see https://aka.ms/RazorPagesCRUD.
public async Task <JsonResult> OnPostAsync(string academicYearID, int enrolmentID)
{
SubmitResult = new SubmitResult
{
SubmitResultID = "ENROLMENT"
};
string academicYear = academicYearID.Replace("-", "/");
Enrolment.AcademicYearID = academicYear;
Enrolment.EnrolmentID = enrolmentID;
TryValidateModel(Enrolment, nameof(Enrolment));
//if (!ModelState.IsValid)
//{
// SubmitResult.IsSuccessful = false;
// SubmitResult.ErrorLevel = ErrorLevel.Error;
// SubmitResult.ErrorCode = "MODEL";
// SubmitResult.ErrorDescription = "Data Model Is Invalid";
// SubmitResult.StackTrace = ModelState.ToString();
// //return Page();
// return new JsonResult(SubmitResult);
//}
_context.Attach(Enrolment).State = EntityState.Modified;
try
{
//await _context.SaveChangesAsync();
await _context.Database
.ExecuteSqlInterpolatedAsync($"EXEC SPR_GPR_UpdateEnrolment @AcademicYear={Enrolment.AcademicYearID}, @EnrolmentID={Enrolment.EnrolmentID}, @PredictedToAchieve={Enrolment.PredictedToAchieve}, @PredictedToAchieveBy={Enrolment.PredictedToAchieveBy}, @PredictedGrade={Enrolment.PredictedGrade}, @Comment={Enrolment.Comment}, @CreatedBy={User.Identity.Name.Split('\\').Last()}, @CreatedDate={DateTime.Now}");
}
catch (DbUpdateConcurrencyException)
{
if (!EnrolmentExists(Enrolment.EnrolmentID))
{
//return NotFound();
SubmitResult.IsSuccessful = false;
SubmitResult.ErrorLevel = ErrorLevel.Error;
SubmitResult.ErrorCode = "NOT_FOUND";
SubmitResult.ErrorDescription = $"The enrolment {Enrolment.EnrolmentID} could not be found";
//return Page();
return(new JsonResult(SubmitResult));
}
else
{
throw;
}
}
//return RedirectToPage("./Index");
SubmitResult.IsSuccessful = true;
return(new JsonResult(SubmitResult));
}
