Ejemplo n.º 1
0
 public static void Execute(HrApplicationContext context)
 {
     ClearDepartmentManagers(context);
     context.Users.Clear();
     context.Departments.Clear();
     context.Contracts.Clear();
     context.Holidays.Clear();
     context.Worktimes.Clear();
     context.SaveChanges();
 }
Ejemplo n.º 2
0
        private static void ClearDepartmentManagers(HrApplicationContext context)
        {
            var departments = context.Departments
                              .Include(dep => dep.Manager)
                              .ToList();

            foreach (var dep in departments)
            {
                dep.Manager = null;
            }
            context.UpdateRange(departments);
            context.SaveChanges();
        }
Ejemplo n.º 3
0
        public static void Seed(HrApplicationContext context)
        {
            var departments = new Department[]
            {
                new Department {
                    DepartmentName = "Human resources"
                },
                new Department {
                    DepartmentName = "Accounting"
                },
                new Department {
                    DepartmentName = "Management"
                },
                new Department {
                    DepartmentName = "Logistics"
                }
            };

            foreach (var department in departments)
            {
                context.Departments.Add(department);
            }

            context.SaveChanges();

            var depHr  = context.Departments.FirstOrDefault(d => d.DepartmentName == "Human resources");
            var depAcc = context.Departments.FirstOrDefault(d => d.DepartmentName == "Accounting");
            var depMan = context.Departments.FirstOrDefault(d => d.DepartmentName == "Management");
            var depLog = context.Departments.FirstOrDefault(d => d.DepartmentName == "Logistics");


            var users = new User[]
            {
                new User
                {
                    Name     = "Paul Franklin",
                    BirthDay = new DateTime(1982, 10, 28),
                    Contract = new Contract
                    {
                        GrossSalary      = 3000,
                        NumberOfHolidays = 20
                    },
                    Department   = depHr,
                    CreationDate = DateTime.Now
                },
                new User
                {
                    Name     = "Hubert Dupargne",
                    BirthDay = new DateTime(1989, 9, 15),
                    Contract = new Contract
                    {
                        GrossSalary      = 3400,
                        NumberOfHolidays = 24
                    },
                    Department   = depHr,
                    CreationDate = DateTime.Now
                },
                new User
                {
                    Name     = "Irene De Maerschalk",
                    BirthDay = new DateTime(1945, 5, 13),
                    Contract = new Contract
                    {
                        GrossSalary      = 2600,
                        NumberOfHolidays = 20
                    },
                    Department   = depHr,
                    CreationDate = DateTime.Now
                },
                new User
                {
                    Name         = "Jack Rousseau",
                    BirthDay     = new DateTime(1992, 3, 19),
                    CreationDate = DateTime.Now
                },
                new User
                {
                    Name         = "Paul Ryan",
                    BirthDay     = new DateTime(1962, 2, 19),
                    Department   = depAcc,
                    CreationDate = DateTime.Now
                },
                new User
                {
                    Name         = "Réné Duchasse",
                    BirthDay     = new DateTime(1973, 2, 12),
                    Department   = depAcc,
                    CreationDate = DateTime.Now
                },
                new User
                {
                    Name     = "Lebron James",
                    BirthDay = new DateTime(1984, 7, 12),
                    Contract = new Contract
                    {
                        GrossSalary      = 8400,
                        NumberOfHolidays = 28
                    },
                    Department   = depMan,
                    CreationDate = DateTime.Now
                },
                new User
                {
                    Name     = "Jonathan Arnoys",
                    BirthDay = DateTime.Now,
                    Contract = new Contract
                    {
                        GrossSalary      = 9032,
                        NumberOfHolidays = 34
                    },
                    Department   = depMan,
                    CreationDate = DateTime.Now
                },
                new User
                {
                    Name         = "Ilse Deprez",
                    BirthDay     = new DateTime(1952, 5, 13),
                    Department   = depLog,
                    CreationDate = DateTime.Now
                },
                new User
                {
                    Name         = "Ahmed Fadik",
                    BirthDay     = new DateTime(1994, 8, 28),
                    Department   = depLog,
                    CreationDate = DateTime.Now
                }
            };

            foreach (var user in users)
            {
                context.Users.Add(user);
            }

            context.SaveChanges();

            var userManagerHr  = context.Users.FirstOrDefault(u => u.Name == "Paul Franklin");
            var userManagerAcc = context.Users.FirstOrDefault(u => u.Name == "Paul Ryan");
            var userManagerMan = context.Users.FirstOrDefault(u => u.Name == "Jonathan Arnoys");
            var userManagerLog = context.Users.FirstOrDefault(u => u.Name == "Ilse Deprez");

            depHr.Manager  = userManagerHr;
            depAcc.Manager = userManagerAcc;
            depMan.Manager = userManagerMan;
            depLog.Manager = userManagerLog;

            context.SaveChanges();

            var paulFranklin = context.Users.FirstOrDefault(u => u.Name == "Paul Franklin");
            var hubert       = context.Users.FirstOrDefault(u => u.Name == "Hubert Dupargne");
            var irene        = context.Users.FirstOrDefault(u => u.Name == "Irene De Maerschalk");
            var jack         = context.Users.FirstOrDefault(u => u.Name == "Jack Rousseau");
            var paulRyan     = context.Users.FirstOrDefault(u => u.Name == "Paul Ryan");
            var rene         = context.Users.FirstOrDefault(u => u.Name == "Réné Duchasse");
            var lebron       = context.Users.FirstOrDefault(u => u.Name == "Lebron James");
            var jonathan     = context.Users.FirstOrDefault(u => u.Name == "Jonathan Arnoys");
            var ilse         = context.Users.FirstOrDefault(u => u.Name == "Ilse Deprez");
            var ahmed        = context.Users.FirstOrDefault(u => u.Name == "Ahmed Fadik");

            var holidays = new Holiday[]
            {
                new Holiday
                {
                    User          = paulFranklin,
                    StartDateTime = new DateTime(2018, 06, 01),
                    EndDateTime   = new DateTime(2018, 06, 16),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = paulFranklin,
                    StartDateTime = new DateTime(2019, 07, 22),
                    EndDateTime   = new DateTime(2019, 07, 28),
                    IsApproved    = false
                },
                new Holiday
                {
                    User          = hubert,
                    StartDateTime = new DateTime(2018, 04, 02),
                    EndDateTime   = new DateTime(2018, 04, 08),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = hubert,
                    StartDateTime = new DateTime(2019, 07, 1),
                    EndDateTime   = new DateTime(2019, 07, 8),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = irene,
                    StartDateTime = new DateTime(2019, 02, 02),
                    EndDateTime   = new DateTime(2019, 02, 08),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = irene,
                    StartDateTime = new DateTime(2019, 07, 1),
                    EndDateTime   = new DateTime(2019, 07, 13),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = jack,
                    StartDateTime = new DateTime(2019, 02, 02),
                    EndDateTime   = new DateTime(2019, 02, 08),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = jack,
                    StartDateTime = new DateTime(2019, 07, 1),
                    EndDateTime   = new DateTime(2019, 07, 13),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = paulRyan,
                    StartDateTime = new DateTime(2019, 10, 12),
                    EndDateTime   = new DateTime(2019, 10, 14),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = paulRyan,
                    StartDateTime = new DateTime(2019, 12, 20),
                    EndDateTime   = new DateTime(2019, 12, 26),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = rene,
                    StartDateTime = new DateTime(2019, 10, 12),
                    EndDateTime   = new DateTime(2019, 10, 14),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = rene,
                    StartDateTime = new DateTime(2019, 12, 20),
                    EndDateTime   = new DateTime(2019, 12, 26),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = rene,
                    StartDateTime = new DateTime(2019, 1, 20),
                    EndDateTime   = new DateTime(2019, 1, 26),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = rene,
                    StartDateTime = new DateTime(2018, 1, 20),
                    EndDateTime   = new DateTime(2018, 1, 26),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = lebron,
                    StartDateTime = new DateTime(2019, 06, 01),
                    EndDateTime   = new DateTime(2019, 06, 16),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = lebron,
                    StartDateTime = new DateTime(2019, 07, 22),
                    EndDateTime   = new DateTime(2019, 07, 28),
                    IsApproved    = false
                },
                new Holiday
                {
                    User          = jonathan,
                    StartDateTime = new DateTime(2019, 1, 20),
                    EndDateTime   = new DateTime(2019, 1, 26),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = jonathan,
                    StartDateTime = new DateTime(2019, 10, 20),
                    EndDateTime   = new DateTime(2019, 10, 26),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = ilse,
                    StartDateTime = new DateTime(2018, 1, 20),
                    EndDateTime   = new DateTime(2018, 1, 26),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = ilse,
                    StartDateTime = new DateTime(2019, 4, 20),
                    EndDateTime   = new DateTime(2019, 4, 26),
                    IsApproved    = true
                },
                new Holiday
                {
                    User          = ahmed,
                    StartDateTime = new DateTime(2019, 1, 20),
                    EndDateTime   = new DateTime(2019, 1, 26),
                    IsApproved    = true
                }
            };

            foreach (var holiday in holidays)
            {
                context.Holidays.Add(holiday);
            }

            context.SaveChanges();

            var workTimes = new WorkTime[]
            {
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 02, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 02, 16, 30, 30)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 03, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 03, 16, 30, 30)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 04, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 04, 16, 30, 30)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 07, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 07, 16, 30, 30)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 08, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 08, 16, 30, 30)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 09, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 09, 16, 30, 30)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 10, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 10, 16, 30, 30)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 13, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 13, 16, 30, 30)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 14, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 14, 16, 30, 30)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 15, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 15, 16, 30, 30)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 16, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 16, 16, 30, 30)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 17, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 17, 16, 30, 30)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 18, 08, 04, 05)
                },
                new WorkTime {
                    User = paulFranklin, WorkDateTime = new DateTime(2019, 01, 18, 16, 30, 30)
                },

                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 02, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 03, 16, 30, 30)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 04, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 04, 16, 30, 30)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 07, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 07, 16, 30, 30)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 08, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 08, 16, 30, 30)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 03, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 09, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 09, 16, 30, 30)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 10, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 10, 16, 30, 30)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 13, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 02, 16, 30, 30)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 13, 16, 30, 30)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 14, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 14, 16, 30, 30)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 15, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 15, 16, 30, 30)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 16, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 16, 16, 30, 30)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 17, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 17, 16, 30, 30)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 18, 08, 04, 05)
                },
                new WorkTime {
                    User = hubert, WorkDateTime = new DateTime(2019, 01, 18, 16, 30, 30)
                },

                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 02, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 03, 16, 30, 30)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 04, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 04, 16, 30, 30)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 07, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 07, 16, 30, 30)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 08, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 08, 16, 30, 30)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 03, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 09, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 09, 16, 30, 30)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 10, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 10, 16, 30, 30)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 13, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 02, 16, 30, 30)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 13, 16, 30, 30)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 14, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 14, 16, 30, 30)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 15, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 15, 16, 30, 30)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 16, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 16, 16, 30, 30)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 17, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 17, 16, 30, 30)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 18, 08, 04, 05)
                },
                new WorkTime {
                    User = irene, WorkDateTime = new DateTime(2019, 01, 18, 16, 30, 30)
                },

                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 02, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 03, 16, 30, 30)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 04, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 04, 16, 30, 30)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 07, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 07, 16, 30, 30)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 08, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 08, 16, 30, 30)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 03, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 09, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 09, 16, 30, 30)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 10, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 10, 16, 30, 30)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 13, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 02, 16, 30, 30)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 13, 16, 30, 30)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 14, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 14, 16, 30, 30)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 15, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 15, 16, 30, 30)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 16, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 16, 16, 30, 30)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 17, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 17, 16, 30, 30)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 18, 08, 04, 05)
                },
                new WorkTime {
                    User = jack, WorkDateTime = new DateTime(2019, 01, 18, 16, 30, 30)
                },

                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 02, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 03, 16, 30, 30)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 04, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 04, 16, 30, 30)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 07, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 07, 16, 30, 30)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 08, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 08, 16, 30, 30)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 03, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 09, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 09, 16, 30, 30)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 10, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 10, 16, 30, 30)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 13, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 02, 16, 30, 30)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 13, 16, 30, 30)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 14, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 14, 16, 30, 30)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 15, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 15, 16, 30, 30)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 16, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 16, 16, 30, 30)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 17, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 17, 16, 30, 30)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 18, 08, 04, 05)
                },
                new WorkTime {
                    User = paulRyan, WorkDateTime = new DateTime(2019, 01, 18, 16, 30, 30)
                },

                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 02, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 03, 16, 30, 30)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 04, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 04, 16, 30, 30)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 07, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 07, 16, 30, 30)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 08, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 08, 16, 30, 30)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 03, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 09, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 09, 16, 30, 30)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 10, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 10, 16, 30, 30)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 13, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 02, 16, 30, 30)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 13, 16, 30, 30)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 14, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 14, 16, 30, 30)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 15, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 15, 16, 30, 30)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 16, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 16, 16, 30, 30)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 17, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 17, 16, 30, 30)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 18, 08, 04, 05)
                },
                new WorkTime {
                    User = rene, WorkDateTime = new DateTime(2019, 01, 18, 16, 30, 30)
                },

                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 02, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 03, 16, 30, 30)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 04, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 04, 16, 30, 30)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 07, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 07, 16, 30, 30)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 08, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 08, 16, 30, 30)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 03, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 09, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 09, 16, 30, 30)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 10, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 10, 16, 30, 30)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 13, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 02, 16, 30, 30)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 13, 16, 30, 30)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 14, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 14, 16, 30, 30)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 15, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 15, 16, 30, 30)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 16, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 16, 16, 30, 30)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 17, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 17, 16, 30, 30)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 18, 08, 04, 05)
                },
                new WorkTime {
                    User = lebron, WorkDateTime = new DateTime(2019, 01, 18, 16, 30, 30)
                },

                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 02, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 03, 16, 30, 30)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 04, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 04, 16, 30, 30)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 07, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 07, 16, 30, 30)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 08, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 08, 16, 30, 30)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 03, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 09, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 09, 16, 30, 30)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 10, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 10, 16, 30, 30)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 13, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 02, 16, 30, 30)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 13, 16, 30, 30)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 14, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 14, 16, 30, 30)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 15, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 15, 16, 30, 30)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 16, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 16, 16, 30, 30)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 17, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 17, 16, 30, 30)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 18, 08, 04, 05)
                },
                new WorkTime {
                    User = jonathan, WorkDateTime = new DateTime(2019, 01, 18, 16, 30, 30)
                },

                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 02, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 03, 16, 30, 30)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 04, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 04, 16, 30, 30)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 07, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 07, 16, 30, 30)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 08, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 08, 16, 30, 30)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 03, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 09, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 09, 16, 30, 30)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 10, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 10, 16, 30, 30)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 13, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 02, 16, 30, 30)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 13, 16, 30, 30)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 14, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 14, 16, 30, 30)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 15, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 15, 16, 30, 30)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 16, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 16, 16, 30, 30)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 17, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 17, 16, 30, 30)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 18, 08, 04, 05)
                },
                new WorkTime {
                    User = ilse, WorkDateTime = new DateTime(2019, 01, 18, 16, 30, 30)
                },

                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 02, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 03, 16, 30, 30)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 04, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 04, 16, 30, 30)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 07, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 07, 16, 30, 30)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 08, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 08, 16, 30, 30)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 03, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 09, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 09, 16, 30, 30)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 10, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 10, 16, 30, 30)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 13, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 02, 16, 30, 30)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 13, 16, 30, 30)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 14, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 14, 16, 30, 30)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 15, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 15, 16, 30, 30)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 16, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 16, 16, 30, 30)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 17, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 17, 16, 30, 30)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 18, 08, 04, 05)
                },
                new WorkTime {
                    User = ahmed, WorkDateTime = new DateTime(2019, 01, 18, 16, 30, 30)
                }
            };

            context.Worktimes.AddRange(workTimes);

            context.SaveChanges();
        }