using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Linq.Expressions;

using System.Data;

using System.Data.DataSetExtensions;

public class Program

{

    public static void Main()

    {

        DataTable dt = new DataTable();

​

            dt.Columns.Add("UID", typeof(string));

            dt.Columns.Add("Emp Name", typeof(string));

            dt.Columns.Add("Role", typeof(string));

            dt.Columns.Add("Sup ID", typeof(string));

            dt.Columns.Add("Sup Name", typeof(string));

            dt.Columns.Add("Designation", typeof(string));

            dt.Columns.Add("Volume", typeof(int));

            dt.Columns.Add("Error_Time", typeof(TimeSpan));

            dt.Columns.Add("ACW", typeof(TimeSpan));

            dt.Columns.Add("Break Time", typeof(TimeSpan));

            dt.Columns.Add("Idle", typeof(TimeSpan));

            dt.Columns.Add("Non Productive", typeof(TimeSpan));

​

            var row1 = dt.NewRow();

            row1["UID"] = "n4742";

            row1["Emp Name"] = "Romson";

            row1["Role"] = "";

            row1["Sup ID"] = "";

            row1["Sup Name"] = "";

            row1["Designation"] = "Associate";

            row1["Volume"] = 2;

            row1["Error_Time"] = new TimeSpan(1, 8, 11);

            row1["ACW"] = new TimeSpan(0, 11, 45);

            row1["Break Time"] =  new TimeSpan(0, 54, 40);

            row1["Idle"] =  new TimeSpan(0, 1, 46);

            row1["Non Productive"] = DBNull.Value;

​

            dt.Rows.Add(row1);

​

            var row2 = dt.NewRow();

            row2["UID"] = "n4742";

            row2["Emp Name"] = "Romson";

            row2["Role"] = "";

            row2["Sup ID"] = "";

            row2["Sup Name"] = "";

            row2["Designation"] = "Associate";

            row2["Volume"] = 5;

            row2["Error_Time"] = new TimeSpan(0, 0, 0);

            row2["ACW"] = new TimeSpan(0, 0, 0);

            row2["Break Time"] =  DBNull.Value;

            row2["Idle"] =  DBNull.Value;

            row2["Non Productive"] = DBNull.Value;

​

            dt.Rows.Add(row2);

​

            var row3 = dt.NewRow();

            row3["UID"] = "n4361";

            row3["Emp Name"] = "Revati";

            row3["Role"] = "";

            row3["Sup ID"] = "";

            row3["Sup Name"] = "";

            row3["Designation"] = "Sr. Associate";

            row3["Volume"] = 4;

            row3["Error_Time"] = new TimeSpan(1, 20, 29);

            row3["ACW"] = new TimeSpan(0, 8, 15);

            row3["Break Time"] =  new TimeSpan(0, 40, 48);

            row3["Idle"] =  DBNull.Value;

            row3["Non Productive"] = new TimeSpan(0, 31, 26);

​

            dt.Rows.Add(row3);

​

            var row4 = dt.NewRow();

            row4["UID"] = "n4361";

            row4["Emp Name"] = "Revati";

            row4["Role"] = "";

            row4["Sup ID"] = "";

            row4["Sup Name"] = "";

            row4["Designation"] = "Sr. Associate";

            row4["Volume"] = 42;

            row4["Error_Time"] = new TimeSpan(2, 35, 21);

            row4["ACW"] = new TimeSpan(1, 26, 42);

            row4["Break Time"] =  new TimeSpan(0, 50, 58);

            row4["Idle"] =  new TimeSpan(0, 17, 41);

            row4["Non Productive"] = DBNull.Value;

​

            dt.Rows.Add(row4);

​

            var row5 = dt.NewRow();

            row5["UID"] = "n4373";

            row5["Emp Name"] = "Shrutika";

            row5["Role"] = "";

            row5["Sup ID"] = "";

            row5["Sup Name"] = "";

            row5["Designation"] = "Senior Associate";

            row5["Volume"] = 56;

            row5["Error_Time"] = new TimeSpan(0, 49, 04);

            row5["ACW"] = new TimeSpan(0, 12, 23);

            row5["Break Time"] =  new TimeSpan(0, 36, 41);

            row5["Idle"] =  DBNull.Value;

            row5["Non Productive"] = DBNull.Value;

​

            dt.Rows.Add(row5);

​

            var Temp_DT = dt.AsEnumerable().Select(x =>

                    new

                    {

                        UID = x["UID"],

                        EMPNAME = x["Emp Name"],

                        EMPROLE = x["Role"],

                        SUPID = x["Sup ID"],

                        SUPNAME = x["Sup Name"],

                        DESIGNATION = x["Designation"],

                        VOLUME = x["Volume"],

                        ERRORTIME = x["Error_Time"],                            

                        ACWTIME = x["ACW"],

                        BREAKTIME = x["Break Time"],

                        IDLETIME = x["Idle"],

                        NONPRODUCTIVE = x["Non Productive"],

                    }).GroupBy(s => new { s.UID, s.EMPNAME, s.EMPROLE, s.SUPID, s.SUPNAME, s.DESIGNATION })

                    .Select(g => {

                      var grouped = g.ToList();

                    return new

                    {

                        UID = g.Key.UID,

                        EMPNAME = g.Key.EMPNAME,

                        EMPROLE = g.Key.EMPROLE,

                        SUPID = g.Key.SUPID,

                        SUPNAME = g.Key.SUPNAME,

                        DESIGNATION = g.Key.DESIGNATION,

                        VOLUME = grouped.Sum(x => Convert.ToInt16(x.VOLUME)),

                        Error_Time = new TimeSpan(grouped.Select(x => ConvertTimeSpan(x.ERRORTIME.ToString())).ToList().Sum(r=> r.Ticks)),

                        ACW = new TimeSpan(grouped.Select(x => ConvertTimeSpan(x.ACWTIME.ToString())).ToList().Sum(r=> r.Ticks)),

                        Break = new TimeSpan(grouped.Select(x => ConvertTimeSpan(x.BREAKTIME.ToString())).ToList().Sum(r=> r.Ticks)),

                        Idle = new TimeSpan(grouped.Select(x => ConvertTimeSpan(x.IDLETIME.ToString())).ToList().Sum(r=> r.Ticks)),

                        NonProductive = new TimeSpan(grouped.Select(x => ConvertTimeSpan(x.NONPRODUCTIVE.ToString())).ToList().Sum(r=> r.Ticks))

                    };

                    }).ToList();

        foreach (var item in Temp_DT)

                 Console.WriteLine(string.Format("{0} | {1} | {2} | {3} | {4} | {5} | {6} | {7} | {8}", item.UID, item.EMPNAME, item.DESIGNATION, item.VOLUME, item.Error_Time, item.ACW, item.Break, item.Idle, item.NonProductive));

    }

    private static TimeSpan ConvertTimeSpan(string str)

        {

             TimeSpan outputValue; 

             TimeSpan.TryParse(str, out outputValue);

​

             return outputValue;

        }

}