using NUnit.Framework;

using System;

using System.Collections.Generic;

using System.Linq;

using Moq;

​

​

namespace EventLog

{

​

    public class EventLogObj

    {

        public decimal RecordId { get; set; }

​

        public string TableKey { get; set; }

​

        public string Status { get; set; }

​

        public DateTime EventTime { get; set; }

​

        public string Perpetrator { get; set; }

    }   

    public interface IEventRepository

    {

        IEnumerable<EventLogObj> GetEvents();

        IEnumerable<EventLogObj> GetEventsFilter();

        void DeleteEvent(decimal RecordId);

        int Count();

    }   

    [TestFixture]

    public class EventLogTests

    {

        EventLogObj eventLogObj, event1, event2, event3, event4, event5;

        List<EventLogObj> events;

        Mock<IEventRepository> mockEventsRepository;

        IEventRepository EventsMockDatabase;

        public static void Main() 

        {

            var est = new EventLogTests();

            est.Setup();

            est.StoreOnlyDuplicateDetailsFromRowsIntoCollection();

            est.pickDuplicateEventWithLeastDate();

        }       

​

        [SetUp]

        public void Setup()

        {

            //dc = new DatabaseConnect("EventLog");

            //query = "SELECT DISTINCT(STATUS) FROM EVENTLOG WHERE ROWNUM = 1";

            eventLogObj = new EventLogObj();

​

            event1 = new EventLogObj() { RecordId = 1, TableKey = "PERSON_CODE=1", Status = "S", EventTime = Convert.ToDateTime("2013-07-15 14:00:00") };

            event2 = new EventLogObj() { RecordId = 2, TableKey = "PERSON_CODE=2", Status = "S", EventTime = Convert.ToDateTime("2013-07-15 13:00:00") };

            event3 = new EventLogObj() { RecordId = 3, TableKey = "PERSON_CODE=3", Status = "S", EventTime = Convert.ToDateTime("2013-07-15 13:00:00") };

            event4 = new EventLogObj() { RecordId = 4, TableKey = "PERSON_CODE=2", Status = "S", EventTime = Convert.ToDateTime("2013-07-15 14:00:00") };

            event5 = new EventLogObj() { RecordId = 5, TableKey = "PERSON_CODE=1", Status = "S", EventTime = Convert.ToDateTime("2013-07-15 13:00:00") };

​

            events = new List<EventLogObj>() { event1, event2, event3, event4, event5 };

        }

​

        [Test]

        public void pickDuplicateEventWithLeastDate()

        {

            var duplicates = events

                //.OrderBy(e => e.EventTime)

                .GroupBy(s => s.TableKey)

                .SelectMany(grp => grp

                            .OrderByDescending(e => e.EventTime)

                            .Skip(1))

                .ToList();

​

            var duplicates2 = from res in events

                              group res by res.TableKey into g

                              select new

                              {

                                  Count = g.Count(),

                                  MemberID = g.Key,

                                  MostRecent = g.OrderByDescending(x => x.EventTime)

                                  .First()

                              };

​

            Assert.AreEqual(2, duplicates.Count);

            var e1 = duplicates[0];

            var e2 = duplicates[1];

​

            Assert.AreEqual(e1.EventTime, Convert.ToDateTime("2013-07-15 13:00:00"));

            Assert.AreEqual(e2.EventTime, Convert.ToDateTime("2013-07-15 13:00:00"));

        }

​

        [Test]

        public void StoreOnlyDuplicateDetailsFromRowsIntoCollection()

        {

            var duplicates = events.GroupBy(s => s.TableKey)

                .SelectMany(grp => grp.Skip(1)).ToList();

​

            Assert.AreEqual(2, duplicates.Count);

        }

​

        [TearDown]

        public void TearDown()

        {

            //dc.Dispose();

        }

    }

}

​