Converting c# list to json with group by

Question

I have converted the datatable to c# list , I need to convert the list to json format, But the json response is coming of all rows one by one. I need the json format with no repeating of the id's which was shown below.

ri is the list type which contains the data .

var listResp = r1.GroupBy(x => x.StoreId).SelectMany(x=>x).ToList();

this code converts the datatable to list.

public static List<AllInvoicesModel> InvoiceDataList(System.Data.DataTable dataTable) { var retList = new List<AllInvoicesModel>(); for (int i = 0; i < dataTable.Rows.Count; i++) { var row = dataTable.Rows[i]; var temp = new AllInvoicesModel() { StoreId = Convert.ToInt32(row["StoreId"]), storyname= Convert.ToString(row["storyname"]), }; retList.Add(temp); } return retList; }

actual result:

[ { "storeId": 0, "storeName": "sdfsfd", "partyCode": "82" }, { "storeId": 0, "storeName": "sfsdfs", "partyCode": "827" }, { "storeId": 1, "storeName": "Anfffsdfs", "partyCode": "827", "displayPartyCode": "2477" } ]

But I need the response in this format, with grouping the separate storeid's

{ [ "storedId":0, "isSelected":true, "invoiceslist":[ { "storeName": "sdfsfd", "partyCode": "82" }, { "storeName": "Ansdf", "partyCode": "827" } ], "storedId":1, "isSelected":true, "invoiceslist":[ { "storeName": "sdfsfd", "partyCode": "82" } ] ] }

I tried to fix your question formatting for you, but your JSON isn't entirely valid. Can you please update it and fix the formatting? Thanks! Note that an array directly in a JSON object without a key isn't valid. — ProgrammingLlama
– ProgrammingLlama, Commented Jul 23, 2019 at 5:28

clarkitect · Accepted Answer · 2019-07-23 05:31:14Z

There's a LINQ extension .GroupBy that will do this for you.

var grouped = retList .GroupBy(r => { r.storedId, r.isSelected }) .Select(g => new { storedId = g.Key.storedId, isSelected = g.Key.isSelected, invoicesList = g.Select(i => new { storeName = i.storeName, partyCode = i.partyCode }) ));

Collectives™ on Stack Overflow

Converting c# list to json with group by

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related