I have a Razor page which OnGet receive a parameter from another page and load the data. The OnGet looks like below
- public async Task
OnGetPTWNoIdAsync( int ptwNoId) - {
- some code here
- }
OnPost looks like below
- public async Task
OnPostHazIdAsync() - {
- if (!ModelState.IsValid)
- {
- return Page();
- }
- var newHazId = new HazId();
- if (await TryUpdateModelAsync(newHazId, "HazId",
- c => c.PTWNo,
- c => c.HazClass,
- c => c.HazDetails,
- c => c.HazPMClass,
- c => c.HazPMDetails
- ))
- {
- _context.HazIds.Add(newHazId);
- await _context.SaveChangesAsync();
- return RedirectToPage(new { ptwNoId = newHazId.PTWNo });
- }
- if (newHazId == null)
- {
- return NotFound();
- }
- return RedirectToPage( new { ptwNoId = newHazId.PTWNo });
- }
However, after OnPost there is no data loaded. Can you help?


Marius VasilePosted Oct 27, 2020, 12:45 AM
Marius VasilePosted Oct 26, 2020, 12:52 PM
SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_HazIds_OrgPTWs_PTWNo". The conflict occurred in database "aspnet-RoSafety-53bc9b9d-9d6a-45d4-8429-2a2761773502", table "dbo.OrgPTWs", column 'PTWNo'.
The statement has been terminated.
Marius VasilePosted Oct 26, 2020, 12:41 PM