asp.net core send two parameters to json procedure

Marius Vasile

I have a tabulated view with data provided from a json. I send one parameter for query and I want to send two parameters. How do I do that?

class="nav nav-tabs" role="tablist" id="myTab">
@{int i = 0;
foreach (var item in Model.WOPlannerL.OrderBy(s => s.WONumberS))
{
if (i == 0)
{
class="nav-item">
class="nav-link active" data-toggle="tab" href="url/@item.WOMainID" data-Id="@item.WOMainID" data-target="#@item.WOMainID">@item.WONumber - @item.WONumberS
}
else
{
class="nav-item">
class="nav-link" data-toggle="tab" href="url/@item.WOMainID" data-Id="@item.WOMainID" data-target="#@item.WOMainID">@item.WONumber - @item.WONumberS
}
i++;
}
}

public async Task OnGetCraftAsync(string id)
{
var woplanner = await _context.WOPlanners.FirstAsync(s => s.WOMainID == id);
return new JsonResult(woplanner);
}

6 Replies

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

Sachin Singh5y ago
Accepted answer
Have you heard the word model? hahah
create one model having 4 properties
public class myData
{
public WOPlanner WOPlanner {get;set;}
public WOApprover WOApprover {get;set;}
public WOReports WOReports {get;set;}
public WOPlanners WOPlanners {get;set;}
}
then send this as a single result, an loop through inside each object in the UI.
public async Task OnGetCraftAsync(string id1, int id2)
        {
            var woplanner1 = await _context.WOPlanners.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
            var woapprover1 = await _context.WOApprovers.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
            var woplannerS1 = await _context.WOPlannerSs.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
            var woreports1 = await _context.WOReports.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);

myData  obj=new myData ();
obj.WOPlanner =WOPlanner1;
obj.WOApprover =woapprover1 ;
obj.WOPlanners =woplannerS1 ;
obj.WOReports=woreports1 ;
            return new JsonResult(obj);
        }
+1
Marius Vasile5y ago
That's something new Sachin, model containing other models, I learn something new every day
+1
Marius Vasile5y ago
Thank you Kiran, and if want to have 4 json results from the same jquery, can I? or beter 4 separate json? Like
public async Task OnGetPlannerAsync(string id1, int id2)
        {
            var woplanner = await _context.WOPlanners.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
            return new JsonResult(woplanner);
        }
        public async Task OnGetApproverAsync(string id1, int id2)
        {
            var woapprover = await _context.WOApprovers.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
            return new JsonResult(woapprover);
        }
        public async Task OnGetPlannerSAsync(string id1, int id2)
        {
            var woplannerS = await _context.WOPlannerSs.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
            return new JsonResult(woplannerS);
        }
        public async Task OnGetReportsAsync(string id1, int id2)
        {
            var woreports = await _context.WOReports.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
            return new JsonResult(woreports);
        }
or can I have
public async Task OnGetCraftAsync(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.WOPlannerSs.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
            var woreports = await _context.WOReports.FirstAsync(s => s.WOMainID == id1 && s.WONumberS == id2);
            return new JsonResult(woplanner);
        }
but then how do I return Json for the other three queries?
+1
Kiran Mohanty5y ago
Hi,
Yes , for HttpGet request you can add parameters in query string however for HttpPost you will need to bind inputs as an object and send data in request body.
+1
Marius Vasile5y ago
It seems is working with
var categoryId = $(this).attr("data-Id1");
                var wonumberS = $(this).attr("data-Id2")
                $.getJSON(`?handler=Craft&id1=${categoryId}&id2=${wonumberS}`, (data) => {
+1
Marius Vasile5y ago
What I tried is to have data-Id1 and data-Id2, but in jquery how do I build the statement?
var categoryId = $(this).attr("data-Id1");
                var wonumberS = $(this).attr("data-Id2")
                $.getJSON(`?handler=Craft&id=${categoryId}`, (data) => {
Craft&id=${categoryId}` and I need to add, let's say id2=${wonumberS}`
+1