/C#/Join 2 list rows into one row and add totals fields C#

Join 2 list rows into one row and add totals fields C#

var result = list.GroupBy( result => result.TrdID)
                 .Select( gr => {
                 var startDate = DateTime.ParseExact(gr.OrderBy(x => x.Term).First().Term, "yyyyMM", CultureInfo.InvariantCulture);
                 var endDate = DateTime.ParseExact(gr.OrderByDescending(x => x.Term).First().Term, "yyyyMM", CultureInfo.InvariantCulture);                      
                 return  new ProcessedResult
                 {
                     TrdID = gr.Key
                     StartDate = new DateTime(startDate.Year, startDate.Month, 1),
                     EndDate = (new DateTime(endDate.Year, endDate.Month, 1)).AddMonth(1).AddDays(-1),
                     Price = gr.First().Price,
                     Seller = gr.First().Seller,
                     Buyer = gr.First().Buyer,
                     Quantity = gr.Sum(x=>x.Quantity)
                 } 
             });

Source: stackoverflow.com

Similar codes

1 vote269 views1 answer
Exceeds your upload_max_filesize ini directive (limit is 2048 KiB).
C#
-1 vote304 views1 answer
How to create a random vector2 in unity
C#Unity
0 vote280 views1 answer
Set custom default file in startup
C#
0 vote257 views1 answer
Bubble sort recursive c#
C#
-2 votes286 views1 answer
Get multi-selected rows gridcontrol devexpress
C#
1 vote254 views1 answer
Monogame fullscreen
C#
1 vote269 views2 answers
C# find duplicates in list of strings
C#
0 vote269 views1 answer
Startup c# class winform
C#
0 vote259 views1 answer
Parse error message: could not create type webservice.webservice asp .net
C#
0 vote238 views1 answer
Controller class
C#