using System;

using System.Collections.Generic;

using System.Linq;

​

public class Program

{

    static event EventHandler MyEvent;

    public static void Main()

    {

        List<Employee> employees = new List<Employee>();

        Employee emp = new Employee();

        emp.EmployeeId = 1;

        emp.Name = "Sanders";

        emp.SupervisorId = null;

        emp.CreatedOn = new DateTime(2019,1,1,16,20,33);

        employees.Add(emp);

        emp = new Employee();

        emp.EmployeeId = 2;

        emp.Name = "Flanders";

        emp.SupervisorId = 1;

        emp.CreatedOn = null;

        employees.Add(emp);

        emp = new Employee();

        emp.EmployeeId = 3;

        emp.Name = "Andrews";

        emp.SupervisorId = 1;

        emp.CreatedOn = null;

        employees.Add(emp);

        emp = new Employee();

        emp.EmployeeId = 4;

        emp.Name = "Ranger";

        emp.SupervisorId = null;

        emp.CreatedOn = new DateTime(2019,3,20,18,4,56);

        employees.Add(emp);

        emp = new Employee();

        emp.EmployeeId = 5;

        emp.Name = "Hammer";

        emp.SupervisorId = 4;

        emp.CreatedOn = null;

        employees.Add(emp);

        emp = new Employee();

        emp.EmployeeId = 6;

        emp.Name = "Enderson";

        emp.SupervisorId = 4;

        emp.CreatedOn = null;

        employees.Add(emp);

        emp = new Employee();

        emp.EmployeeId = 7;

        emp.Name = "Larsson";

        emp.SupervisorId = null;

        emp.CreatedOn = new DateTime(2019,10,3,4,55,16);

        employees.Add(emp);

        emp = new Employee();

        emp.EmployeeId = 8;

        emp.Name = "Simpson";

        emp.SupervisorId = 7;

        emp.CreatedOn = null;

        employees.Add(emp);

        var list = employees.Where(m=> m.CreatedOn >= new DateTime(2019,1,1) && m.CreatedOn < new DateTime(2019,1,2)).Join(employees,sc=> sc.EmployeeId, soc=> soc.SupervisorId, (sc,soc)=> new {left= sc, right=soc}  ).ToList();

        foreach(var x in list)

        {

            Console.Write(x.left.EmployeeId);

            Console.Write("\t");

            Console.Write(x.left.Name);

            Console.Write("\t");

            Console.Write(x.left.SupervisorId);

            Console.Write("\t");

            Console.WriteLine(x.left.CreatedOn);

            Console.Write("\t");

            Console.Write(x.right.EmployeeId);

            Console.Write("\t");

            Console.Write(x.right.Name);

            Console.Write("\t");

            Console.Write(x.right.SupervisorId);

            Console.Write("\t");

            Console.WriteLine(x.right.CreatedOn);

            Console.WriteLine();

            Console.WriteLine();

        }

        //int id = 1;

        //var result = statuses.FirstOrDefault(x => x.StatusID == id);

        //string test = "";

        //if (result != null)

        //  test = result.StatusDescr;

        //Console.WriteLine(test);

    }

​

    public class Employee

    {

        public int EmployeeId

        {

            get;

            set;

        }

​

        public string Name

        {

            get;

            set;

        }

​

        public int? SupervisorId

        {

            get;

            set;

        }

​

        public DateTime? CreatedOn

        {

            get;

            set;

        }

    }

}