We are excited to announce that the ASP.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

Converting JSON to Model[Answered] RSS

2 replies

Last post Jul 09, 2018 12:00 PM by johnjalani

‹ Previous Thread|Next Thread ›

Shortcuts

johnjalani

Member

243 Points

566 Posts

Converting JSON to Model

Jul 09, 2018 10:25 AM|johnjalani|LINK

Hi,

This is my JSON

{
    "DashboardBuild": {
        "Reports": [
            {
                "Name": "Data List",
                "StoredProc": "api_Data_Select",
                "Type": "Table",
                "Data": {
                    "x": [
                        0.00,
                        0.00,
                        0.00
                    ],
                    "xField": [
                        "",
                        "",
                        ""
                    ],
                    "xLabel": [
                        "",
                        "",
                        ""
                    ],
                    "y": [
                        0.00,
                        0.00
                    ],
                    "yField": [
                        "",
                        ""
                    ],
                    "yLabel": [
                        "",
                        ""
                    ],
                    "z": [
                        0.00,
                        0.00,
                        0.00
                    ],
                    "zField": [
                        "",
                        "",
                        ""
                    ],
                    "zLabel": [
                        "null",
                        "null",
                        "null"
                    ]
                },
                "Order": 1,
                "Width": 6,
                "Enable": true
            }
        ]
    }
}

This is the Model

public class DashboardBuild
    {
        [JsonProperty(PropertyName = "Reports")]
        public IEnumerable<Report> Reports { get; set; }
    }
 
    public class Data
    {
        [JsonProperty(PropertyName = "x")]
        public List<decimal> x { get; set; }
        [JsonProperty(PropertyName = "xField")]
        public List<string> xField { get; set; }
        [JsonProperty(PropertyName = "xLabel")]
        public List<string> xLabel { get; set; }
        [JsonProperty(PropertyName = "y")]
        public List<decimal> y { get; set; }
        [JsonProperty(PropertyName = "yField")]
        public List<string> yField { get; set; }
        [JsonProperty(PropertyName = "yLabel")]
        public List<string> yLabel { get; set; }
        [JsonProperty(PropertyName = "z")]
        public List<decimal> z { get; set; }
        [JsonProperty(PropertyName = "zField")]
        public List<string> zField { get; set; }
        [JsonProperty(PropertyName = "zLabel")]
        public List<string> zLabel { get; set; }
    }
    public class Report
    {
        [JsonProperty(PropertyName = "Name")]
        public string Name { get; set; }
        [JsonProperty(PropertyName = "StoredProc")]
        public string StoredProc { get; set; }
        [JsonProperty(PropertyName = "Type")]
        public string Type { get; set; }
        [JsonProperty(PropertyName = "Data")]
        public Data Data { get; set; }
        [JsonProperty(PropertyName = "Order")]
        public int Order { get; set; }
        [JsonProperty(PropertyName = "Width")]
        public int Width { get; set; }
        [JsonProperty(PropertyName = "Enable")]
        public bool Enable { get; set; }
    }

And this is the Convert code

 public DashboardBuild GetDashboard(Guid masterId)
        {
            var model = new DashboardBuild ();

            var path = @"c:\DashboardBuild.json";

            model = LoadJSON<DashboardBuild>(path);

            return model;
        }


 public static T LoadJSON<T>(string path) where T : class
        {
            using (StreamReader r = new StreamReader(path))
            {
                string json = r.ReadToEnd();
                var items = JsonConvert.DeserializeObject<T>(json);

                return items;
            }
        }

The problem is the Deserialized object "items" shows the Property Reports = NULL......

as you can see in the JSON, there are data like Name and Type, can anyone help me know why??

Thanks

JFRBPH12™

It's more fun in the Philippines :)
http://www.philippinetourismusa.com/

vahid bakkhi

Star

8119 Points

2778 Posts

Re: Converting JSON to Model

Jul 09, 2018 10:59 AM|vahid bakkhi|LINK

you have to define a class called DashboardBuild for the root object

public class RootObject
    {
        public DashboardBuild DashboardBuild { get; set; }
    }

and your complete code

public RootObject GetDashboard(Guid masterId)
        {
            var model = new RootObject();
            var path = @"c:\DashboardBuild.json";
             model = LoadJSON<RootObject>(path);

            return model;
        }
        public static T LoadJSON<T>(string path) where T : class
        {
            using (StreamReader r = new StreamReader(path))
            {
                string json = r.ReadToEnd();
                var items = JsonConvert.DeserializeObject<T>(json);

                return items;
            }
        }

and your model

public class RootObject
    {
        public DashboardBuild DashboardBuild { get; set; }
    }

    public class DashboardBuild
    {
        [JsonProperty(PropertyName = "Reports")]
        public IEnumerable<Report> Reports { get; set; }
    }

    public class Data
    {
        [JsonProperty(PropertyName = "x")]
        public List<decimal> x { get; set; }
        [JsonProperty(PropertyName = "xField")]
        public List<string> xField { get; set; }
        [JsonProperty(PropertyName = "xLabel")]
        public List<string> xLabel { get; set; }
        [JsonProperty(PropertyName = "y")]
        public List<decimal> y { get; set; }
        [JsonProperty(PropertyName = "yField")]
        public List<string> yField { get; set; }
        [JsonProperty(PropertyName = "yLabel")]
        public List<string> yLabel { get; set; }
        [JsonProperty(PropertyName = "z")]
        public List<decimal> z { get; set; }
        [JsonProperty(PropertyName = "zField")]
        public List<string> zField { get; set; }
        [JsonProperty(PropertyName = "zLabel")]
        public List<string> zLabel { get; set; }
    }
    public class Report
    {
        [JsonProperty(PropertyName = "Name")]
        public string Name { get; set; }
        [JsonProperty(PropertyName = "StoredProc")]
        public string StoredProc { get; set; }
        [JsonProperty(PropertyName = "Type")]
        public string Type { get; set; }
        [JsonProperty(PropertyName = "Data")]
        public Data Data { get; set; }
        [JsonProperty(PropertyName = "Order")]
        public int Order { get; set; }
        [JsonProperty(PropertyName = "Width")]
        public int Width { get; set; }
        [JsonProperty(PropertyName = "Enable")]
        public bool Enable { get; set; }
    }

I hope it can be helpful

vahid bakhtiary

Please MARK AS ANSWER if suggestion helps.

- Reply
johnjalani
Member

243 Points

566 Posts

Re: Converting JSON to Model

Jul 09, 2018 12:00 PM|johnjalani|LINK

Thanks for the help

JFRBPH12™

It's more fun in the Philippines :)
http://www.philippinetourismusa.com/

‹ Previous Thread|Next Thread ›