namespace STUFV.DataLayer.Migrations
{
    using DomainClasses;
    using System;
    using System.Data.Entity;
    using System.Data.Entity.Migrations;
    using System.Linq;

    public sealed class Configuration : DbMigrationsConfiguration<STUFV.DataLayer.StufvContext>
    {
        public Configuration()
        {
            AutomaticMigrationsEnabled = true;
            AutomaticMigrationDataLossAllowed = true;
        }

        protected override void Seed(STUFV.DataLayer.StufvContext context)
        {
            /*context.Events.AddOrUpdate(
              new Event
              {
                  EventId = 29,
                  Name = "Fuif2",
                  Locatie = "Fuif",
                  Adres = "Fuif",
                  StartDateTime = DateTime.Now,
                  EndDateTime = DateTime.Now.AddHours(6),
         },
              new Event
              {
                  EventId = 2,
                  Name = "Beestenfeest2",
                  Locatie = "Hasselt",
                  Adres = "Hoekstraat 1",
                  StartDateTime = DateTime.Now,
                  EndDateTime = DateTime.Now.AddHours(6),
              },
                            new Event
                            {
                                EventId = 3,
                                Name = "Beestenfeest3",
                                Locatie = "Hasselt",
                                Adres = "Hoekstraat 1",
                                StartDateTime = DateTime.Now,
                                EndDateTime = DateTime.Now.AddHours(6),
                            }
              );

            context.UserEventsSet.AddOrUpdate(
                new UserEvents
                {
                    UserName = "admin@gmail.com",
                    ParticipatingEvents = context.Events.Where(e => e.Name == "Beestenfeest").ToList(),
                },
                new UserEvents
               {
                UserName = "admin2@gmail.com",
                    ParticipatingEvents = context.Events.Take(2).ToList(),
                   // ParticipatingEvents = context.Events.ToList(),
                });

            context.Categories.AddOrUpdate(
                new Category
                {
                    CategoryId = 1,
                    Name = "Fuif"
                });
            context.Categories.AddOrUpdate(
                new Category
                {
                    CategoryId = 2,
                    Name = "Festival"
                });
            context.Events.AddOrUpdate(
                 new Event
                 {
                     EventId = 1,
                     Name = "Beestenfeest",
                     Locatie = "Hasselt",
                     Adres = "Hoekstraat 1",
                     StartDateTime = DateTime.Now,
                     EndDateTime = DateTime.Now.AddHours(6),
                 },
                 new Event
                 {
                     EventId = 2,
                     Name = "Nie Zat Nie Buiten",
                     Locatie = "Genk",
                     Adres = "Hoekstraat 1",
                     StartDateTime = DateTime.Now.AddDays(1),
                     EndDateTime = DateTime.Now.AddDays(1).AddHours(6),
                 },
                  new Event
                   {
                   EventId = 3,
                   Name = "Fris Aan De Vis",
                   Locatie = "Tongeren",
                   Adres = "Hoekstraat 1",
                   StartDateTime = DateTime.Now.AddDays(3),
                   EndDateTime = DateTime.Now.AddDays(3).AddHours(6),
                 },
                  new Event
               {
                     EventId = 4,
                     Name = "Rock Werchter",
                     Locatie = "Hasselt",
                     Adres = "Hoekstraat 1",
                     StartDateTime = DateTime.Now.AddDays(-2),
                     EndDateTime = DateTime.Now.AddDays(-2).AddHours(6),
               },
                new Event
                {
                  EventId = 5,
                  Name = "Pukkepop",
                  Locatie = "Hasselt",
                  StartDateTime = DateTime.Now.AddDays(-6),
                  EndDateTime = DateTime.Now.AddDays(-6).AddHours(6),
                  });/**/

            /*
            context.UserEventsList.AddOrUpdate(
                new UserEvents
                {
                    UserId = 2,
                    ParticipatingEvents = (from e in context.Events select e.EventId).ToArray(),
                    OrganisedEvents = (from e in context.Events select e.EventId).ToArray(),
                });

            context.Users.AddOrUpdate(
                new User
                {
                    UserId = 1,
                    Name = "jan",
                    Password = "jan",
                },
               new User
               {
                   UserId = 2,
                   Name = "piet",
                   Password = "piet",
               });/***/

            //  This method will be called after migrating to the latest version.

            //  You can use the DbSet<T>.AddOrUpdate() helper extension method
            //  to avoid creating duplicate seed data. E.g.
            //
            //    context.People.AddOrUpdate(
            //      p => p.FullName,
            //      new Person { FullName = "Andrew Peters" },
            //      new Person { FullName = "Brice Lambson" },
            //      new Person { FullName = "Rowan Miller" }
            //    );
            //
        }
    }
}