public OrdersRepository(VodovozClientDbContext ctx)
{
_context = ctx;
}
public static void EnsurePopulated()
{
VodovozClientDbContext context = DI.ServiceProvider.GetService <VodovozClientDbContext>();
context.Database.EnsureCreated();
List <Subdivision> subdivisions = new List <Subdivision>
{
new Subdivision {
Name = "Commercy"
},
new Subdivision {
Name = "Operation"
},
new Subdivision {
Name = "Logistic"
},
new Subdivision {
Name = "IT"
}
};
List <Employee> employees = new List <Employee>
{
new Employee {
Name = "Vasya", Surname = "Vetrov", FatherName = "Yuryevich", Birthday = DateTime.Today.AddYears(-30), Sex = SexEnum.Male, Subdivision = subdivisions[0]
},
new Employee {
Name = "Anastasia", Surname = "Aleksandrova", FatherName = "Yuryevna", Birthday = DateTime.Today.AddYears(-20), Sex = SexEnum.Female, Subdivision = subdivisions[0]
},
new Employee {
Name = "Boris", Surname = "Babushkin", FatherName = "Aleksandrovich", Birthday = DateTime.Today.AddYears(-45), Sex = SexEnum.Male, Subdivision = subdivisions[0]
},
new Employee {
Name = "Viktor", Surname = "Vasilyev", FatherName = "Anatolyevich", Birthday = DateTime.Today.AddYears(-21), Sex = SexEnum.Male, Subdivision = subdivisions[1]
},
new Employee {
Name = "Gennady", Surname = "Georgiyev", FatherName = "Victorovich", Birthday = DateTime.Today.AddYears(-48), Sex = SexEnum.Male, Subdivision = subdivisions[1]
},
new Employee {
Name = "Dmitry", Surname = "Dudinsky", FatherName = "Vyacheslavovich", Birthday = DateTime.Today.AddYears(-55), Sex = SexEnum.Male, Subdivision = subdivisions[2]
},
new Employee {
Name = "Yelena", Surname = "Yeremeyeva", FatherName = "Aleksandrovna", Birthday = DateTime.Today.AddYears(-50), Sex = SexEnum.Female, Subdivision = subdivisions[2]
},
new Employee {
Name = "Zhanna", Surname = "Strizh", FatherName = "Evgenyevna", Birthday = DateTime.Today.AddYears(-33), Sex = SexEnum.Female, Subdivision = subdivisions[2]
},
new Employee {
Name = "Andrey", Surname = "Zaytsev", FatherName = "Vladimirovich", Birthday = DateTime.Today.AddYears(-22), Sex = SexEnum.Male, Subdivision = subdivisions[3]
},
new Employee {
Name = "Leonid", Surname = "Kovalsky", FatherName = "Mikhaylovich", Birthday = DateTime.Today.AddYears(-29), Sex = SexEnum.Male, Subdivision = subdivisions[3]
},
};
//subdivisions[0].Manager = employees[0];
List <Order> orders = new List <Order>
{
new Order {
CounterAgent = "Microsoft", OrderTime = DateTime.Now.AddDays(-10), Author = employees[1]
},
new Order {
CounterAgent = "Microsoft", OrderTime = DateTime.Now.AddDays(-5), Author = employees[0]
},
new Order {
CounterAgent = "Microsoft", OrderTime = DateTime.Now.AddDays(-1), Author = employees[3]
},
new Order {
CounterAgent = "Microsoft", OrderTime = DateTime.Now.AddDays(-2), Author = employees[3]
},
new Order {
CounterAgent = "Microsoft", OrderTime = DateTime.Now.AddDays(-3), Author = employees[5]
},
new Order {
CounterAgent = "Microsoft", OrderTime = DateTime.Now.AddDays(-3), Author = employees[6]
},
};
if (!context.Subdivisions.Any())
{
context.Subdivisions.AddRange(subdivisions);
}
if (!context.Employees.Any())
{
context.Employees.AddRange(employees);
}
if (!context.Orders.Any())
{
context.Orders.AddRange(orders);
}
context.SaveChanges();
}
public EmployeesRepository(VodovozClientDbContext ctx)
{
_context = ctx;
}
public SubdivisionsRepository(VodovozClientDbContext ctx)
{
_context = ctx;
}
