Parsing JSON using LINQ

Question

Hello I am facing a very simple problem but it is not getting Solved. Here is my class design

public class Program
{
    public string ProgramName { get; set; }
    public string ProgramTime { get; set; }
    public string ProgramDetails { get; set; }
}

public class Listing
{
    public string ChannelName { get; set; }
    public string NowShowing { get; set; }
    public string NowShowingTime { get; set; }
    public string NowShowingDescription { get; set; }
    public string NowShowingPicture { get; set; }
    public List<Program> Programs { get; set; }
}

public class RootObject
{
    public string status { get; set; }
    public string about { get; set; }
    public List<Listing> listings { get; set; }
}

I am parsing using the following code.

JObject json = JsonConvert.DeserializeObject(e.Result) as JObject;
Listing ls = new Listing
{
    ChannelName = (string)json["listings"].Children()["ChannelName"],
    NowShowing = (string)json["listings"].Children()["NowShowing"],
    Programs = new Program
    {
         ProgramName = (string)json["listings"]["Program"]["ProgramName"]
    }
};

Help me solve my lame approach. My concerns are parsing the items correctly and also how to add them to the nested list "Programs". The second one is more crucial.

Sample Json input-

   {
      "listings": [
      {
          "ChannelName": "NTV BANGLA",
          "NowShowing": "Ei Shomoy (R)",
          "NowShowingTime": "12:10",
          "NowShowingDescription": "Ei Shomoy is a daily talk show ........",
          "Programs": [
          {
              "ProgramName": "Ainer Chokhe (R)",
              "ProgramTime": "13:00",
              "ProgramDetails": "Human Rights and law based program Ainer Chokhe,"
          },
          {
              "ProgramName": "Shonkhobash",
              "ProgramTime": "15:10",
              "ProgramDetails": "Drama serial Shonkhobash, script by Bipasha Hayat and"
          }
        ]
      },
      {
          "ChannelName": "CHANNEL i",
          "NowShowing": "Taroka Kothon (Live)",
          "NowShowingTime": "12:30",
          "NowShowingDescription": "City Cell Taroka Kothon Live is a talk show ",
          "Programs": [
          {
               "ProgramName": "Channel i Top News",
               "ProgramTime": "13:00",
               "ProgramDetails": "Mutual Trust Bank top news (Shirsho Shongbad)"
       },
       {
               "ProgramName": "Ebong Cinemar Gaan",
               "ProgramTime": "13:10",
               "ProgramDetails": "Ebong Cinemar Gaan, a musical show based on "
        }
 ]
         }
      ]
   }

EDIT1

var customers = JsonConvert.DeserializeObject<RootObject>(e.Result);
Listing ls = new Listing
{
       ChannelName = customers.listings.First().ChannelName,
       NowShowing=customers.listings.First().NowShowing,
       Programs=??
};

You have to iterate over the nested arrays to create your Programs. — Keith Payne
– Keith Payne, Commented Jan 8, 2014 at 11:57
your parsing code without runtime error for you sample json? — Grundy
– Grundy, Commented Jan 8, 2014 at 14:37

Grundy · Accepted Answer · 2014-01-08 19:21:12Z

1

if e.Result is string with your JSON try this

var jss = new JavaScriptSerializer();
var o = jss.Deserialize<RootObject>(e.Result);

UPDATE
possibly you need something like this

var customers = JsonConvert.DeserializeObject<RootObject>(e.Result);
Listing ls = new Listing
{
    ChannelName = customers.listings.First().ChannelName,
    NowShowing=customers.listings.First().NowShowing,
    Programs=customers.listings.First().Programs
};

UPDATE2
if you want based on existing you can try comething like this

var customers = JsonConvert.DeserializeObject<RootObject>(e.Result);
Listing ls = new Listing
{
    ChannelName = customers.listings.First().ChannelName,
    NowShowing=customers.listings.First().NowShowing,
    Programs=customers.listings.First().Programs.Select(p=>new Program{
                                        ProgramName=p.ProgramName,
                                        ProgramTime=p.ProgramTime, 
                                        ProgramDetails = p.ProgramDetails
                                       }).ToList()
};

UPDATE3
or if you whant simply random you can try something like this

var customers = JsonConvert.DeserializeObject<RootObject>(e.Result);
Listing ls = new Listing
{
    ChannelName = customers.listings.First().ChannelName,
    NowShowing=customers.listings.First().NowShowing,
    Programs=Enumerable.Range(1,10).Select(p=>new Program{
                                        ProgramName="generated name",
                                        ProgramTime="generated time", 
                                        ProgramDetails = "generated details"
                                       }).ToList()
};

edited Jan 8, 2014 at 19:21

answered Jan 8, 2014 at 13:58

Grundy

13.4k3 gold badges39 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Lamia Mehreen Over a year ago

Sorry I could not express myself properly, I have data in my hands, I want to assign them to the correct properties for later use.How can I populate ChannelName, NowShowing and most importantly nested array Programs?

Grundy Over a year ago

I don't quite understand what you mean, in o you have deserialized object with filed propertise include List<Listing>,List<Program>, so you can simply get it annd change, can you provide sample what you concrete mean?

Lamia Mehreen Over a year ago

I have already solved the first part of my question(I'll elaborate them in my answer). Please tell me how to insert data into "programs"? I'm having trouble because it is a list, not a property like "ChannelName" or "NowShowing"

Lamia Mehreen Over a year ago

This is a correct approach. But I need the values inside "ProgramName", "ProgramTime" , "ProgramDetails" too.

Lamia Mehreen Over a year ago

There is some casting problem. An IEnumerable to Generic conversion error has been thrown.

|

spaghettifunk · Accepted Answer · 2014-01-08 14:02:37Z

0

Use DataContractJsonSerializer to parse json string in windows phone.

MemoryStream memoryStream = new MemoryStream(Encoding.Unicode.GetBytes(e.Result));

DataContractJsonSerializer dataContractJsonSerializer = new DataContractJsonSerializer(typeof(List<RootObject>));
RootObject itemDataList = dataContractJsonSerializer.ReadObject(memoryStream) as RootObject;

ChannelName = itemDataList.listings.First().ChannelName;

edited Jan 8, 2014 at 14:02

spaghettifunk

2,0244 gold badges26 silver badges47 bronze badges

answered Jan 8, 2014 at 12:03

Jaihind

2,7801 gold badge15 silver badges19 bronze badges

4 Comments

Lamia Mehreen Over a year ago

it is saying illegal characters in path

Lamia Mehreen Over a year ago

unfortunately, itemdatalist remains empty. am I missing something?

Jaihind Over a year ago

I made edit in my ans please check it and let me know if it works

Lamia Mehreen Over a year ago

JObject json = JsonConvert.DeserializeObject(e.Result) as JObject; I am getting my json data from here. The problem lies in the parsing and iteration.

Collectives™ on Stack Overflow

Parsing JSON using LINQ

2 Answers 2

6 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related