/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

7 votes56 views4 answers
How to add text to element javascript
C#
0 vote102 views1 answer
C# winscp upload file
C#
0 vote123 views1 answer
Get date value from datepicker c#
C#
0 vote96 views1 answer
Bubble sort recursive c#
C#
0 vote110 views1 answer
Which of the following string methods can be used to determine if a string contains only ‘\n’ characters?
C#
0 vote95 views1 answer
Get current location latitude and longitude in xamarin - NAYCode.com
C#
0 vote93 views1 answer
Unity stop physics
C#
0 vote117 views1 answer
"I'm trying to figure out a way (or find a library) that supports long money string conversion into a decimal. I'm not sure if there's a practical way to so this with all the possible combinations."
C#
13 votes93 views2 answers
Small modal popup bootstrap
C#
4 votes157 views2 answers
How to make among us clone in unity
C#Unity