public async Task <IActionResult> OnPostAsync() { if (!ModelState.IsValid) { return(Page()); } _context.Attach(IELTSTransaction).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!IELTSTransactionExists(IELTSTransaction.PaymentID)) { return(NotFound()); } else { throw; } } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnPostAsync() { string result = ""; if (!ModelState.IsValid) { return(Page()); } _context.Attach(IELTSTransaction).State = EntityState.Modified; try { //await _context.SaveChangesAsync(); string UserName = User.Identity.Name.Split('\\').Last(); await _context.Database .ExecuteSqlInterpolatedAsync($"EXEC SPR_IEL_UpdateStatus @TransactionID={IELTSTransaction.TransactionID}, @IsBookSent={IELTSTransaction.BookSent}, @IsDVDSent={IELTSTransaction.DVDSent}, @UserName={UserName}"); result = "{ saved: \"Y\", error: \"\" }"; } catch (DbUpdateConcurrencyException e) { //if (!IELTSTransactionExists(IELTSTransaction.PaymentID)) //{ // return NotFound(); //} //else //{ // throw; //} result = "{ saved: \"N\", error: " + e.Message + " }"; } //return RedirectToPage("./Index"); return(Content(result)); }