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

100

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

var result = list.GroupBy( result =&gt; result.TrdID)
                 .Select( gr =&gt; {
                 var startDate = DateTime.ParseExact(gr.OrderBy(x =&gt; x.Term).First().Term, "yyyyMM", CultureInfo.InvariantCulture);
                 var endDate = DateTime.ParseExact(gr.OrderByDescending(x =&gt; 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=&gt;x.Quantity)
                 } 
             });

Comments

Submit

0 Comments

More Questions

url()- full() laravel	how to print in c#	c# how to sort a list
print in c#	get mouse position unity	c# initialize array
string to int c#	Retrieve url path	Generate Random String
string to date vb	modal bootstrap style	abril modal boostrap
c# serialize json	boostrap 4 modal	small modal popup bootstrap
model in bootsrap 4	bootstrap modal popup	c# random string
c sharp split string	string to json c#	laravel get current url
how get url in laravel	how to generate random letters in C#	string to date
laravel route redirect	check if two date ranges overlap c#	Console.WriteLine($Hello Ana.ToUpper($)!);
phone number regex in c#	list min and Max value in c#	check shell command success
attribute c# get method name reflection	c# how to get screen resolution in class	how to make dissapear an object in unity
wpf label text in center	hahhaa i hack u	difference between all logging framework .NET Core
new color unity	c# count files in directory and subdirectories	Hello World Dotnet
import tachyons in react	How can I cast string to enum	.net core add header to soap request
open html file in browser using c++	git find commits by message	c# generate random date
how to get angular on visual studio mac	dotnet core encryption and decryption	asp.net list all files in folder

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

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

Comments

0 Comments

More Questions

C

CSS

Objective-C

PHP

Java

C++

Javascript

Html

Python

SQL

Swift

Ruby

Go

R

TypeScript

Kotlin

Assembly

VBA

Scala

Rust

Elixir

Dart

Haskell

Perl

Fortran

Matlab

Scheme

Julia

Lua

Delphi

Pascal

Solidity

BASIC

ActionScript

Csharp