public static void Initialize(CompanyX_Context context)
{
context.Database.EnsureCreated();
var departments = new List <Department>
{
new Department {
DepartmentName = "Accounting", Employee = new List <Employee>()
},
new Department {
DepartmentName = "HR", Employee = new List <Employee>()
},
new Department {
DepartmentName = "Engineering", Employee = new List <Employee>()
},
};
departments.ForEach(d => context.Departments.Add(d));
context.SaveChanges();
// Look for any students.
if (context.Employees.Any())
{
return; // DB has been seeded
}
var employees = new List <Employee>
{
new Employee {
FirstName = "Carson", LastName = "Alexander", PhoneNumber = "111-222-3333", DepartmentID = 1, Departments = departments.FirstOrDefault(d => d.DepartmentID == 1)
},
new Employee {
FirstName = "Meredith", LastName = "Alonso", PhoneNumber = "222-333-5555", DepartmentID = 2, Departments = departments.FirstOrDefault(d => d.DepartmentID == 2)
},
new Employee {
FirstName = "Arturo", LastName = "Anand", PhoneNumber = "999-888-7777", DepartmentID = 3, Departments = departments.FirstOrDefault(d => d.DepartmentID == 3)
},
new Employee {
FirstName = "Gytis", LastName = "Barzdukas", PhoneNumber = "444-555-6666", DepartmentID = 1, Departments = departments.FirstOrDefault(d => d.DepartmentID == 1)
},
new Employee {
FirstName = "Yan", LastName = "Li", PhoneNumber = "666-777-8888", DepartmentID = 2, Departments = departments.FirstOrDefault(d => d.DepartmentID == 2)
},
new Employee {
FirstName = "Peggy", LastName = "Justice", PhoneNumber = "444-333-2222", DepartmentID = 3, Departments = departments.FirstOrDefault(d => d.DepartmentID == 3)
},
};
employees.ForEach(e => context.Employees.Add(e));
context.SaveChanges();
departments[0].Employee.Add(employees[0]); // in list departments at index 0 add employees from list employees at index 0
departments[1].Employee.Add(employees[1]); // in list departments at index 1 add employees from list employees at index 1
departments[2].Employee.Add(employees[2]); // in list departments at index 2 add employees from list employees at index 2
departments[0].Employee.Add(employees[3]); // in list departments at index 0 add employees from list employees at index 3
departments[1].Employee.Add(employees[4]); // in list departments at index 1 add employees from list employees at index 4
departments[2].Employee.Add(employees[5]); // in list departments at index 2 add employees from list employees at index 5
context.SaveChanges();
}
public EmployeesController(CompanyX_Context context)
{
_context = context;
}
public CompanyX_Repository(CompanyX_Context companyX_Context)
{
_companyX_Context = companyX_Context;
}