using System;

using System.Collections.Generic;

using System.Collections.Specialized;

using System.IO.Ports;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

​

class One

{

    public string BookingId { get; internal set; }

    public string Name { get; internal set; }

    public double Weight { get; internal set; }

    public string WeightUnit { get; internal set; }

    public double Volume { get; internal set; }

    public string VolumeUnit { get; internal set; }

    public int PackageQuantity { get; internal set; }

    public string PackageQuantityUnit { get; internal set; }

    public int CustomerProductQuantity { get; internal set; }

    public string CustomerProductQuantityUnit { get; internal set; }

}

​

class Two

{

    public string OrderBookingId { get; internal set; }

}

​

public class Program

{

    public static void Main()

    {

        List<One> tableOne = new List<One>()

        {

            new One() { Weight = 25, BookingId = "aaa", Volume = 11 },

            new One() { Weight = 12, BookingId = "aaa", Volume = 5 },

            new One() { Weight = 2, BookingId = "aaa", Volume = 8 },

            new One() { Weight = 8, BookingId = "aaa", Volume = 7 },

​

        };

        List<Two> tableTwo = new List<Two>()

        {

            new Two

            {

                 OrderBookingId = "aaa",

            }

        };

​

        var customerOrderResponse =

            tableOne.Join(

                tableTwo,

                firstData => firstData.BookingId,

                secData => secData.OrderBookingId,

                (firstData, secData) => new

                {

                    FirstData = firstData,

                    SecondData = secData,

                    OrderNumber = firstData.Name,

                    Weight = firstData.Weight,

                    WeightUnit = firstData.WeightUnit,  //string = KG

                    Volume = firstData.Volume,

                    VolumeUnit = firstData.VolumeUnit,   ////string = CUBIC-MTR

                    PackageQuantity = firstData.PackageQuantity,

                    PackageQuantityUnit = firstData.PackageQuantityUnit, // 

                    CustomerProductQuantity = firstData.CustomerProductQuantity,

                    CustomerProductQuantityUnit = firstData.CustomerProductQuantityUnit,

                }).GroupBy(co => co.OrderNumber)

                .Select((items) =>

                {

                    var itemsList = items.ToList();

                    string commonVolumeUnit = itemsList[0].VolumeUnit;

                    string commonWeightUnit = itemsList[0].WeightUnit;

                    return new

                    {

                        Items = itemsList,

                        TotalVolume = itemsList.Sum(x => ConvertVolume(x.Volume, x.VolumeUnit, commonVolumeUnit)),

                        TotalWeight = itemsList.Sum(x => ConvertWeight(x.Weight, x.WeightUnit, commonWeightUnit)),

                        TotalVolumeUnit = commonVolumeUnit,

                        TotalWeightUnit = commonWeightUnit,

                    };

                })

                .SelectMany((fullOrderData) =>

                {

                    return fullOrderData.Items.Select(x =>

                    {

                        return new

                        {

                            TotalVolume = fullOrderData.TotalVolume,

                            TotalWeight = fullOrderData.TotalWeight,

                            TotalVolumeUnit = fullOrderData.TotalVolumeUnit,

                            TotalWeightUnit = fullOrderData.TotalWeightUnit,

                            OrderNumber = x.OrderNumber,

                            Weight = x.Weight,

                            WeightUnit = x.WeightUnit,  //string = KG

                            Volume = x.Volume,

                            VolumeUnit = x.VolumeUnit,   ////string = CUBIC-MTR

                            PackageQuantity = x.PackageQuantity,

                            PackageQuantityUnit = x.PackageQuantityUnit, // 

                            CustomerProductQuantity = x.CustomerProductQuantity,

                            CustomerProductQuantityUnit = x.CustomerProductQuantityUnit,

                        };

                    });

                })

                .GroupBy(co => co.OrderNumber)

                .Select(x => x.First());

​

​

        double totalWeight = customerOrderResponse.First().TotalWeight; // reads 47

        double totalVolume= customerOrderResponse.First().TotalVolume; // reads 31

        Console.WriteLine(totalWeight);

        Console.WriteLine(totalVolume);

​

    }

    private static double ConvertWeight(double weight, string weightUnit, string newWeightUnit)

    {

        return weight;

    }

​

    private static double ConvertVolume(double volume, string volumeUnit, string newVolumeUnit)

    {

        return volume;

    }

}