asp.net core razor json null data trigger error

I have a json whic gets data from 4 tables. one of it has no value and because of that I have nothing in my view

public async Task OnGetDetailsAsync(string id1, int id2)
{
var woplanner = await _context.WOPlanners.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
var woapprover = await _context.WOApprovers.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
var woplannerS = await _context.WOPlannerSCHs.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
var woreports = await _context.WOReports.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
WOD obj = new WOD
{
WOPlanner = woplanner,
WOApprover = woapprover,
WOPlannerSCH = woplannerS,
WOReport = woreports
};
return new JsonResult(obj);
}

WOPlannerSCH has no data now, how do I fix this?

2 Replies

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

Sachin Singh5y ago
Accepted answer
instead of FirstAsync use FirstOrDefaultAsync
var woplanner = await _context.WOPlanners.FirstOrDefaultAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
also make sure to handle it in the UI as well.
if(data.woName!=null)
{
$("#DivName").Html(data.woName) ;
}
Marius Vasile5y ago
I also had to change WOPlannerSs name, it was a confusion in jquery with WOPlanners but is working with your solution