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"));
        }
示例#2
0
        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));
        }