using System;

using System.Collections.Generic;

using System.Linq;

​

public class Program

{

    public static void Main()

    {

            var lstRfq = new List<RfqEvents>()

            {

                new RfqEvents(1,1,DateTime.Parse("2021-05-06 03:00:00+00"),1),

                new RfqEvents(2,2,DateTime.Parse("2021-05-06 03:00:00+00"),1),

                new RfqEvents(3,2,DateTime.Parse("2021-05-06 03:00:00+00"),1),

                new RfqEvents(4,3,DateTime.Parse("2021-05-06 00:00:00+00"),2),

                new RfqEvents(5,4,DateTime.Parse("2021-05-06 00:00:00+00"),2),

                new RfqEvents(6,5,DateTime.Parse("2021-05-06 00:00:00+00"),2),

                new RfqEvents(7,5,DateTime.Parse("2021-05-06 00:00:00+00"),2),

                new RfqEvents(8,5,DateTime.Parse("2021-05-06 00:00:00+00"),3),

                new RfqEvents(9,6,DateTime.Parse("2021-05-06 00:00:00+00"),3),

                new RfqEvents(10,6,DateTime.Parse("2021-05-06 00:00:00+00"),3),

            };

​

            var subquery = from c in lstRfq

                           group c by c.RfqId into g

                           select new InternalStatusInformations

                           {

                               RfqId = g.Key,

                               RfqEventId = g.Max(a => a.Id),

                               StatusId = g.Select(p => p.Status).FirstOrDefault()

                           };

            var sss = from d in lstRfq.Where(p=> subquery.Select(p=>p.RfqEventId).Contains(p.Id))

                      group d by d.Status into z

                      select new InternalStatusInformations

                      {

                          StatusId = z.Key,

                          Total = z.Count(),

                          Past = z.Where(p => p.DueDate.HasValue && p.DueDate.Value.Date < DateTime.Now.Date).Count(),

                          Future = z.Where(p => p.DueDate.HasValue && p.DueDate.Value.Date > DateTime.Now.Date).Count(),

                          Today = z.Where(p => p.DueDate.HasValue && p.DueDate.Value.Date == DateTime.Now.Date).Count(),

                          FiveDays = z.Where(p => (p.DueDate.HasValue && p.DueDate.Value.Date > DateTime.Now.Date) && p.DueDate.HasValue && p.DueDate.Value.Date < DateTime.Now.Date.AddDays(5)).Count(),

                      };

​

            //expected: Status 1: 2 values

            //          Status 2: 3 values

            //          Status 3: 2 value

​

            //output:   Status 1: 2 values

            //          Status 2: 2 values

            //          Status 3: 2 values

        sss.Dump();

    }

            public class InternalStatusInformations

        {

​

            public int RfqEventId { get; set; }

            public int RfqId { get; set; }

            public int StatusId { get; set; }

            public int Future { get; set; }

            public int Past { get; set; }

            public int Today { get; set; }

            public int FiveDays { get; set; }

            public int Total { get; set; }

            public DateTime? DueDate { get; set; }

​

        }

​

        public class RfqEvents

        {

            public RfqEvents(int id, int rfqId, DateTime? dueDate, int status)

            {

                Id = id;

                RfqId = rfqId;

                DueDate = dueDate;

                Status = status;

            }

            public int Id { get; set; }

            public DateTime? DueDate { get; set; }

            public int RfqId { get; set; }

            public int Status { get; set; }

        }

​

}