How to view related data from API in WebApp.

Nguyen Anh

5y802Learn iOS Programming

Dear all.

I have create a solution in which I have

- API project.

- WebApp project.

In API projet I have a 3 model

People

{

PeopleID

PeopleName

}

Car

{

CarID

PeopleID //Who own the car.

}

CarDriver

{

CarID

PeopleID //Who drive the car.

}

I have create API to receive the data and it related from Database.

The data is seem to be like that (more complicated than demo model above.

And How can I view it in the razor page in webapp please.

{

"carID": 15,

"peopleID": 1,

"pidInfor": {

"peopleID": 1,

"peopleName": "Lê Van Dung",

"peopleFrom": "Nghia Huong, Qu?c Oai, Hà N?i",

"peopleGende": "Nam",

"peopleDateOfBirth": "1983-08-13T00:00:00",

"peopleAddress": "Xóm 10, Van Quang, Nghia Huong, Qu?c Oai, Hà N?i",

"peoplePIDNumber": "001083011872",

"peoplePIDDate": "2015-02-11T00:00:00",

"peoplePIDPlace": "C?c c?nh sát ÐKQL Cu Trú và DLQG v? dân cu",

"peoplePIDValidUntil": "2030-02-11T00:00:00",

"joinDate": null,

"peopleImagePath": null,

"driverLicence": null,

"contacts": null,

"carOwner": [

{

"carID": 15,

"carModelID": 1,

"carEngieNumber": "1NZ-Y545573",

"carEngieChassisNumber": "RL4BT923C9518900",

"carManufactureYear": "2012",

"carManufactureCountry": "Vi?t Nam",

"locationCompanyID": null,

"locationUser": null,

"locationPass": null,

"locationValidUntil": null,

"peopleID": 1,

"carPlate": "29A-532.95",

"inspectionValidUntil": null,

"insuranceValidUntil": null,

"carOwnerNote": null,

"carRegistrations": null,

"lCompany": null,

"carInsurances": null,

"carInspections": null,

"carModel": null

}

"carRegistrations": null,

"pidImages": null,

"driverLicenceImages": null

"carInfor": {

"carID": 15,

"carModelID": 1,

"carEngieNumber": "1NZ-Y545573",

"carEngieChassisNumber": "RL4BT923C9518900",

"carManufactureYear": "2012",

"carManufactureCountry": "Vi?t Nam",

"locationCompanyID": null,

"locationUser": null,

"locationPass": null,

"locationValidUntil": null,

"peopleID": 1,

"pidInfor": {

"peopleID": 1,

"peopleName": "Lê Van Dung",

"peopleFrom": "Nghia Huong, Qu?c Oai, Hà N?i",

"peopleGende": "Nam",

"peopleDateOfBirth": "1983-08-13T00:00:00",

"peopleAddress": "Xóm 10, Van Quang, Nghia Huong, Qu?c Oai, Hà N?i",

"peoplePIDNumber": "001083011872",

"peoplePIDDate": "2015-02-11T00:00:00",

"peoplePIDPlace": "C?c c?nh sát ÐKQL Cu Trú và DLQG v? dân cu",

"peoplePIDValidUntil": "2030-02-11T00:00:00",

"joinDate": null,

"peopleImagePath": null,

"driverLicence": null,

"contacts": null,

"carOwner": [],

"carRegistrations": null,

"pidImages": null,

"driverLicenceImages": null

"carPlate": "29A-532.95",

"inspectionValidUntil": null,

"insuranceValidUntil": null,

"carOwnerNote": null,

"carRegistrations": null,

"lCompany": null,

"carInsurances": null,

"carInspections": null,

"carModel": null

"driverNote": null

4 Replies

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

Rijwan Ansari5y ago
Better implement swagger to know response model and will helpful to know for API details.
Example:
https://www.c-sharpcorner.com/article/implementing-swagger-in-web-api/
Nguyen Anh5y ago
I feel there is a loop here sir. I create 2 project:
- One for API in this i create the model.
- One for webapp in which I consume API.

And now I one to view the model i have created in API in webapp.
Asma Khalid5y ago
You need to create JSON Object mapper and tstore the resulting Web API JSON data in that JSON oject mapper i.e. https://bit.ly/2ZBQ7NB

Mark answer as accpted if helpful

Thanks & Regards,
Asma Khalid

For More Visit: www.asmak9.com or www.bytezaar.com
Sachin Singh5y ago
just copy paste below class in your project (web api) and then install newtonsoft.Json from nuget then just desearilze the root and loop through the root in view
public class CarOwner    {
    public int carID { get; set; }
    public int carModelID { get; set; }
    public string carEngieNumber { get; set; }
    public string carEngieChassisNumber { get; set; }
    public string carManufactureYear { get; set; }
    public string carManufactureCountry { get; set; }
    public object locationCompanyID { get; set; }
    public object locationUser { get; set; }
    public object locationPass { get; set; }
    public object locationValidUntil { get; set; }
    public int peopleID { get; set; }
    public string carPlate { get; set; }
    public object inspectionValidUntil { get; set; }
    public object insuranceValidUntil { get; set; }
    public object carOwnerNote { get; set; }
    public object carRegistrations { get; set; }
    public object lCompany { get; set; }
    public object carInsurances { get; set; }
    public object carInspections { get; set; }
    public object carModel { get; set; }
}

public class PidInfor    {
    public int peopleID { get; set; }
    public string peopleName { get; set; }
    public string peopleFrom { get; set; }
    public string peopleGende { get; set; }
    public DateTime peopleDateOfBirth { get; set; }
    public string peopleAddress { get; set; }
    public string peoplePIDNumber { get; set; }
    public DateTime peoplePIDDate { get; set; }
    public string peoplePIDPlace { get; set; }
    public DateTime peoplePIDValidUntil { get; set; }
    public object joinDate { get; set; }
    public object peopleImagePath { get; set; }
    public object driverLicence { get; set; }
    public object contacts { get; set; }
    public List carOwner { get; set; }
    public object carRegistrations { get; set; }
    public object pidImages { get; set; }
    public object driverLicenceImages { get; set; }
}

public class CarInfor    {
    public int carID { get; set; }
    public int carModelID { get; set; }
    public string carEngieNumber { get; set; }
    public string carEngieChassisNumber { get; set; }
    public string carManufactureYear { get; set; }
    public string carManufactureCountry { get; set; }
    public object locationCompanyID { get; set; }
    public object locationUser { get; set; }
    public object locationPass { get; set; }
    public object locationValidUntil { get; set; }
    public int peopleID { get; set; }
    public PidInfor pidInfor { get; set; }
    public string carPlate { get; set; }
    public object inspectionValidUntil { get; set; }
    public object insuranceValidUntil { get; set; }
    public object carOwnerNote { get; set; }
    public object carRegistrations { get; set; }
    public object lCompany { get; set; }
    public object carInsurances { get; set; }
    public object carInspections { get; set; }
    public object carModel { get; set; }
}

public class Root    {
    public int carID { get; set; }
    public int peopleID { get; set; }
    public PidInfor pidInfor { get; set; }
    public CarInfor carInfor { get; set; }
    public object driverNote { get; set; }
}

Root myDeserializedClass = JsonConvert.DeserializeObject(myJsonResponse);
in view
@Model.Root

@Model.anyproperty