Similar OnPost actions with different results

I have similar OnPost actions but in one case it writes all data in another it does not. I've checked, there are no errors, however, in first case Remarks are written in the second are not. What is wrong?

First case

public async Task OnPostPTWManagementAsync(int ptwNoId)
{
if (!ModelState.IsValid)
{
return Page();
}
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
var username = await (from a in _context.UsersData.Where(a => a.Id == userId)
join b in _context.CompanyDatas on a.OrgID equals b.OrgID into TempData1
from c in TempData1
select new UserDataRole
{
UserId = a.Id,
UserName = a.UserName,
Email = a.Email,
OrgID = c.OrgID,
UserOrganization = c.CompanyName,
}).FirstOrDefaultAsync();
var ptwStatus = _context.PTWContents.First(s => s.PTWNo == ptwNoId);
ptwStatus.PTWStatus = "Management";
await _context.SaveChangesAsync();
PTWLog newPTWLog = new PTWLog()
{
PTWNo = ptwNoId,
PTWStatus = "Management",
PTWDateStatus = DateTime.Now,
UserName = username.UserName,
Remarks = "Awaiting for Management Approval"
};
if (await TryUpdateModelAsync(newPTWLog, "PTWLog"))
{
_context.PTWLogs.Add(newPTWLog);
await _context.SaveChangesAsync();
return RedirectToPage("PTWForm", "PTWNoId", new { ptwNoId = ptwNoId });
}
return RedirectToPage("PTWForm", "PTWNoId", new { ptwNoId = ptwNoId });
}

Second case

public async Task OnPostPTWManagementApproveAsync(int ptwNoId)
{
if (!ModelState.IsValid)
{
return Page();
}
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
var username = await (from a in _context.UsersData.Where(a => a.Id == userId)
join b in _context.CompanyDatas on a.OrgID equals b.OrgID into TempData1
from c in TempData1
select new UserDataRole
{
UserId = a.Id,
UserName = a.UserName,
Email = a.Email,
OrgID = c.OrgID,
UserOrganization = c.CompanyName,
}).FirstOrDefaultAsync();
var ptwStatus = _context.PTWContents.First(s => s.PTWNo == ptwNoId);
ptwStatus.PTWStatus = "Approved";
await _context.SaveChangesAsync();
PTWLog newPTWLog = new PTWLog()
{
PTWNo = ptwNoId,
PTWStatus = "Approved",
PTWDateStatus = DateTime.Now,
UserName = username.UserName,
Remarks = "PTW is approved by Management"
};
if (await TryUpdateModelAsync(newPTWLog, "PTWLog"))
{
_context.PTWLogs.Add(newPTWLog);
await _context.SaveChangesAsync();
return RedirectToPage("PTWForm", "PTWNoId", new { ptwNoId = ptwNoId });
}
return RedirectToPage("PTWForm", "PTWNoId", new { ptwNoId = ptwNoId });
}

So, in the first case, the Remarks, the string, is written to the table in the second are not

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Marius Vasile5y ago
I spent couple of hours looking and trying to see what is wrong and the idea came after I decided to ask on forum
+1
Sachin Singh5y ago
glad , otherwise there was no other reason when both are completely identical hahah.
+1
Marius Vasile5y ago
I fixed it by enclosing each buttons on cshtml page in their own form method. Before I use to have one form at the begining on the page with end form at the end
+1
Marius Vasile5y ago
I tried this Sachin, I only left "Management" to try and see but it is not writting anything
+1
Sachin Singh5y ago
the only case could be the datatype of Remarks in database is too short to hold the sentence "PTW is approved by Management" .
make datatype length to 150 and check as varchar(150)
+1