C# Serialize data with linq for chartist.js

Question

I have the following list:

    public class Prices
    {
        public int Year { get; set; }
        public decimal Price { get; set; }
    }

    List<Prices> List1 = new List<Prices>();
    List1.Add(new Prices { Year = 2018, Price = 1.5m });
    List1.Add(new Prices { Year = 2017, Price = 1.2m });
    List1.Add(new Prices { Year = 2016, Price = 3.5m });

    //The linq query i'm trying to build
     var data1 = List1.Select(c=> new
         {
             labels = new List<Int64> {c.Year },
             series = new List<decimal> {
                 new List<decimal> { c.Price }
             }
         });


    // it's what i want to build
    var data2 = new {
      labels = new List<Int64> { 2018, 2017, 2016 },
      series = new List<decimal[]> {
               new decimal[] { 1.5m, 1.2m, 3.5m }
        }
    };

    var Json = JsonConvert.SerializeObject(data2);
    //Json => {"labels":[2018,2017,2016],"series":[[1.5,1.2,3.5]]}

I wish to convert the List1 to a Json Output using linq:

{"labels":[2018,2017,2016],"series":[[1.5,1.2,3.5]]}

user3559349 · Accepted Answer · 2018-02-20 03:57:45Z

4

Create a new object containing properties for labels and prices where each is populated using a .Select() to select the appropriate values.

var data = new
{
    labels = List1.Select(x => x.Year),
    prices = new []{ List1.Select(x => x.Price) }
};
var Json = JsonConvert.SerializeObject(data);

answered Feb 20, 2018 at 3:57

user3559349

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

Comments

Russ Ebbing · Accepted Answer · 2020-12-02 07:18:45Z

0

Expanding on user3559349's answer, put it in a class or view model...

Public class ChartModel
{
    public ChartUnit[] Chart { get; set; } = Array.Empty<ChartUnit>();

    public string ToJson()
    {
        var data = new
        {
            lables = Chart.Select(s => s.Label),
            Value = Chart.Select(s => s.Value)
        };

        var json = JsonConvert.SerializeObject(data);
        return json;
    }
}

answered Dec 2, 2020 at 7:18

Russ Ebbing

5705 silver badges8 bronze badges

Collectives™ on Stack Overflow

C# Serialize data with linq for chartist.js

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related