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();
}
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();
}
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();
}