JSON in controller class

Question

My question is how can I combine two sets of JSON for example one set comes from one datatable like this:

"ID": 1, "SHORT_NAME": "B", "CARRIER_NAME": "Carrier A"

Another one with multiple values comes from another datatable:

{ "YMDH": "2009-03-07 00:00:00.000", "SELL_DURATION": 222.999995 }, { "YMDH": "2009-03-07 01:00:00.000", "SELL_DURATION": 75.816664 }, { "YMDH": "2009-03-07 02:00:00.000", "SELL_DURATION": 39.349995 }, { "YMDH": "2009-03-07 03:00:00.000", "SELL_DURATION": 75.816664 }, { "YMDH": "2009-03-07 04:00:00.000", "SELL_DURATION": 39.349995 }, { "YMDH": "2009-03-07 05:00:00.000", "SELL_DURATION": 275.91666 }


Since first table will have only one records and another table will be having multiple records for that one row. how can i combine them both in my controller class to build proper JSON like this:

var nwCustomers = [{ "ID": 1, "SHORT_NAME": "A", "CARRIER_NAME": "Carrier A", "SellDuration": [{ "YMDH": "2009-03-07 00:00:00.000", "SELL_DURATION": 222.999995 }, { "YMDH": "2009-03-07 01:00:00.000", "SELL_DURATION": 75.816664 }, { "YMDH": "2009-03-07 02:00:00.000", "SELL_DURATION": 39.349995 }, { "YMDH": "2009-03-07 03:00:00.000", "SELL_DURATION": 75.816664 }, { "YMDH": "2009-03-07 04:00:00.000", "SELL_DURATION": 39.349995 }, { "YMDH": "2009-03-07 05:00:00.000", "SELL_DURATION": 275.91666 }] }       
    ];

I'm tring to do something like this but not able to get the desired output:

Model:

public class GridModel
{
    public DateTime YMDH { get; set; }
    public double ID { get; set; }
    public string SHORT_NAME { get; set; }
    public string CARRIER_NAME { get; set; }
    public double SELL_DURATION { get; set; }      
    public GridSparklineModel SellDuration { get; set; }
}


public class GridSparklineModel
{
    public DateTime YMDH { get; set; }
    public double SELL_DURATION { get; set; }       
}

Controller:


 public ActionResult FetchGraphDataJSON()
        {
            Grid grid = new Grid();
            DataSet ds = grid.GetHistoryData();

            DataTable dt = ds.Tables[0];

            List<GridModel> data = new List<GridModel>();

            if (dt.Rows.Count != 0)
            {
                StringBuilder sb = new StringBuilder();                

                foreach (DataRow row in dt.Rows)
                {
                    sb.Append(new GridModel { ID = Convert.ToDouble(@row["ID"].ToString()), SHORT_NAME = @row["SHORT_NAME"].ToString() });

                    double carrierId = Convert.ToDouble(@row["ID"].ToString());

                    DataRow[] rowsInOtherTable = ds.Tables[1].Select("ID = " + carrierId);

                    for(int i=0; i < rowsInOtherTable.Count(); i++)
                    {
                        // add with existing
                    }

                    data.Add(new GridModel { ID = Convert.ToDouble(@row["ID"].ToString()), SHORT_NAME = @row["SHORT_NAME"].ToString(), CARRIER_NAME = @row["CARRIER_NAME"].ToString(), SellDuration = new GridSparklineModel { YMDH = DateTime.Parse(@rowsInOtherTable[0]["YMDH"].ToString()), SELL_DURATION = Convert.ToDouble(@rowsInOtherTable[0]["SELL_DURATION"].ToString()) } });
                }
            }

            return Json(data, JsonRequestBehavior.AllowGet);
        }

How can I add multiple values of one table with single row of another table. Doss anybody know how to do this.

Are you trying to build json from a list of objects?

Hossain Muctadir
– Hossain Muctadir

2014-03-07 06:31:26 +00:00
Commented Mar 7, 2014 at 6:31 — Hossain Muctadir
– Hossain Muctadir, Commented Mar 7, 2014 at 6:31

EZI · Accepted Answer · 2014-03-07 07:02:43Z

1

To get that json your model should be like this:

public class GridModel
{
    public int ID { get; set; }
    public string SHORT_NAME { get; set; }
    public string CARRIER_NAME { get; set; }
    public List<SellDuration> SellDuration { get; set; }
}

public class SellDuration
{
    public DateTime YMDH { get; set; }
    public double SELL_DURATION { get; set; }
}

answered Mar 7, 2014 at 7:02

EZI

15.4k2 gold badges29 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

JSON in controller class

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related