using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Globalization;

using System.IO;

​

​

public class Program

{

    public static void Main()

    {

        Row row1 = new Row()

        {

            Date = "20160101",

            Channel = "Facebook",

            Metric = "Investment"

        };

        Row row2 = new Row()

        {

            Date = "20160103",

            Channel = "Google",

            Metric = "Investment"

        };

        Row row3 = new Row()

        {

            Date = "20160103",

            Channel = "Yahoo",

            Metric = "Investment"

        };

        List<Row> tabulka = new List<Row>();

        tabulka.Add(row1);

        tabulka.Add(row2);

        tabulka.Add(row3);

        Dictionary <string, Row> yester_day = new Dictionary<string, Row>();

        Dictionary <string, Row> current_day = new Dictionary<string, Row>();

        DateTime date_count = new DateTime();

        DateTime origin_date = DateTime.ParseExact(row1.Date, "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None);

        date_count = origin_date;

        foreach(var x in tabulka)

        {

            DateTime parameterRowDate = DateTime.ParseExact(x.Date, "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None);

            // jedná-li se o tentýž den, doplní se hodnoty do aktuálního slovníku.          

            if (parameterRowDate == date_count)

            {

                current_day.Add(x.Channel, x);

            }

            //jedná-li se o den následující, uloží se current_day do pole výsledných řádků.

            else if (parameterRowDate.AddDays(1) == date_count) 

            {

                date_count = parameterRowDate;

                yester_day = current_day;

                current_day.Clear();

                current_day.Add(x.Channel, x);

            }

            //je-li rozdíl dnů větší než jeden, zkopírují se hodnoty v období current_date až parameterRowDate a vytvoří se z nich výsledné řádky.

            else

            {

​

                int day_difference = (parameterRowDate.Date - date_count.Date).Days;

                for (int i = 0; i < day_difference; i++)

                {

                    date_count = date_count.AddDays(1);

                    //Vyrob se řádek do listu výstpních řádků

                    yester_day = current_day;

                }

                date_count = parameterRowDate;

            }

        }

        foreach(KeyValuePair<string, Row> y in current_day)

        {

            Console.WriteLine(y);

        }

        Console.WriteLine("---------------------------------------------");

        foreach(KeyValuePair<string, Row> y in yester_day)

        {

            Console.WriteLine(y);

        }

​

    }

    public class Row

    {

        public string Date {get; set;}

        public string Channel {get; set;}

        public string Metric {get; set;}

    }

    public class Output

    {

    }

​

}

​

​