using System;

using Newtonsoft.Json;

using System.Collections.Generic;

using System.Collections.ObjectModel;

using System.Linq;

​

public class Appt

{

    public string CreatedBy { get; set; }

    public int AppointmentTypeID { get; set; }

    public int GlaasStateID { get; set; }

}

​

public class ApptType

{

    public int AppointmentTypeID { get; set; }

    public String Name { get; set; }

}

​

public class Program

{

    public static void Main()

    {

        List<ApptType> types = new List<ApptType>()

        {

            new ApptType() { AppointmentTypeID = 1, Name = "TA" },

            new ApptType() { AppointmentTypeID = 2, Name = "TF" },

            new ApptType() { AppointmentTypeID = 3, Name = "LECT" },

        };

        List<Appt> appts = new List<Appt>

        {

            new Appt() { CreatedBy = "BLambert", AppointmentTypeID = 1, GlaasStateID = 1 },

            new Appt() { CreatedBy = "BLambert", AppointmentTypeID = 1, GlaasStateID = 1 },

            new Appt() { CreatedBy = "BLambert", AppointmentTypeID = 1, GlaasStateID = 2 },

            new Appt() { CreatedBy = "BLambert", AppointmentTypeID = 1, GlaasStateID = 3 },

​

            new Appt() { CreatedBy = "rg", AppointmentTypeID = 1, GlaasStateID = 1 },

        };

        var ApptsByProcessor = from appt in appts

                               group appt by new { appt.CreatedBy, appt.AppointmentTypeID, appt.GlaasStateID } into grp

                               select new { AppointmentProcessor = grp.Key, Count = grp.Count() };

         var typesLeftJoinedApptsByProcessor = from apptType in types

                          join apptByProcessor in ApptsByProcessor on apptType.AppointmentTypeID equals apptByProcessor.AppointmentProcessor.AppointmentTypeID into apptTypeLeftJoinApptByProcessor

                          from apptByProcessor in apptTypeLeftJoinApptByProcessor.DefaultIfEmpty()

                          select new 

                          {

                              AppointmentType = apptType,

                              AppointmentTypeID = apptType.AppointmentTypeID,

​

                              grp = apptTypeLeftJoinApptByProcessor

                          };

        var newdata = typesLeftJoinedApptsByProcessor.SelectMany(x=>

                                                                 x.grp.Select(y=>new{

                                                                     y.Count,

                                                                     y.AppointmentProcessor.CreatedBy,

                                                                     y.AppointmentProcessor.GlaasStateID,

                                                                     x.AppointmentType

                                                                 }));

        var newerdata = from t in types

                        join n in newdata on t.AppointmentTypeID equals n.AppointmentType.AppointmentTypeID into g

                        //group n by t into g

                        from z in g.DefaultIfEmpty()

            select new{

                t,z

        };

        /*

        var test2 = typesLeftJoinedApptsByProcessor

            .SelectMany(g => new { 

                AppointmentType = g.AppointmentType, 

                AppointmentTypeID = g.AppointmentTypeID,

                Processor = g.grp.SelectMany(d => d.AppointmentProcessor.CreatedBy)

                //InProgress = g.grp.SelectMany(s => s.AppointmentProcessor. 

            });*/

        Console.WriteLine(newdata.Count());

        Console.WriteLine(typesLeftJoinedApptsByProcessor.SelectMany(x=>x.grp).Count());

        Console.WriteLine(JsonConvert.SerializeObject(newerdata, Formatting.Indented));

        //Console.WriteLine(JsonConvert.SerializeObject(newdata, Formatting.Indented));

    }

}

​

​

​

​

/*

​

AppointmentType{get;set;}

CreatedBy{get;set;}

GlaasStateID{get;set;}

Count{get;set;}

​

​

*/