public DepartmentsController(BanagazonWorkforceManagerContext context)
{
_context = context;
}
public EmployeesController(BanagazonWorkforceManagerContext context)
{
_context = context;
}
public TrainingProgramsController(BanagazonWorkforceManagerContext context)
{
_context = context;
}
public HomeController(BanagazonWorkforceManagerContext context)
{
_context = context;
}
// Method runs on startup to initialize dummy data.
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new BanagazonWorkforceManagerContext(serviceProvider.GetRequiredService <DbContextOptions <BanagazonWorkforceManagerContext> >()))
{
// Look for any Employees.
if (context.EmployeeTraining.Any())
{
return; // DB has been seeded, the rest of this method doesn't need to run.
}
// Creating new instances of Department
var Departments = new Department[]
{
new Department {
Name = "Marketing"
},
new Department {
Name = "Sales"
},
new Department {
Name = "Tech Support"
},
new Department {
Name = "Human Resources"
}
};
// Adds each new Department into the context
foreach (Department i in Departments)
{
context.Department.Add(i);
}
// Saves the Departments to the database
context.SaveChanges();
// Creating new instances of Employee
var Employees = new Employee[]
{
new Employee {
FirstName = "Svetlana",
LastName = "Smith",
StartDate = new DateTime(1989, 8, 20),
DepartmentID = 1
},
new Employee {
FirstName = "Nigel",
LastName = "Thornberry",
StartDate = new DateTime(1974, 6, 20),
DepartmentID = 1
},
new Employee {
FirstName = "George",
LastName = "Washington",
StartDate = new DateTime(1776, 7, 4),
DepartmentID = 1
},
new Employee {
FirstName = "Tom",
LastName = "Jerry",
StartDate = new DateTime(1991, 9, 20),
DepartmentID = 2
},
new Employee {
FirstName = "Boris",
LastName = "Johnson",
StartDate = new DateTime(2015, 2, 4),
DepartmentID = 2
},
new Employee {
FirstName = "Mark",
LastName = "Hamill",
StartDate = new DateTime(1984, 12, 14),
DepartmentID = 2
},
new Employee {
FirstName = "George",
LastName = "Dickel",
StartDate = new DateTime(1919, 1, 3),
DepartmentID = 3
},
new Employee {
FirstName = "Jose",
LastName = "Cuervo",
StartDate = new DateTime(2013, 2, 28),
DepartmentID = 3
},
new Employee {
FirstName = "Alexander",
LastName = "Hamilton",
StartDate = new DateTime(1776, 7, 4),
DepartmentID = 3
},
new Employee {
FirstName = "Margaery",
LastName = "Tyrell",
StartDate = new DateTime(1991, 2, 23),
DepartmentID = 4
},
new Employee {
FirstName = "Podrick",
LastName = "Payne",
StartDate = new DateTime(2017, 6, 13),
DepartmentID = 4
},
new Employee {
FirstName = "Rickon",
LastName = "Stark",
StartDate = new DateTime(2004, 4, 14),
DepartmentID = 4
}
};
// Adds each new Employee into the context
foreach (Employee i in Employees)
{
context.Employee.Add(i);
}
// Saves the Employees to the database
context.SaveChanges();
// Creating new instances of TrainingProgram
var TrainingPrograms = new TrainingProgram[]
{
new TrainingProgram {
Name = "Scrum System: The Basics",
Description = "Learn how to be productive during a sprint.",
StartDate = new DateTime(2017, 12, 14),
EndDate = new DateTime(2017, 12, 15),
MaxAttendees = 4
},
new TrainingProgram {
Name = "Mentor Partnership",
Description = "Come and coach or be coached by others in the company.",
StartDate = new DateTime(2017, 11, 12),
EndDate = new DateTime(2017, 11, 14),
MaxAttendees = 20
},
new TrainingProgram {
Name = "2018 Orientation",
Description = "We will discuss new company policies going into effect in 2018.",
StartDate = new DateTime(2018, 1, 4),
EndDate = new DateTime(2018, 1, 7),
MaxAttendees = 8
},
new TrainingProgram {
Name = "Modern Hiring Practices",
Description = "How to conduct interviews in the modern era.",
StartDate = new DateTime(2015, 2, 28),
EndDate = new DateTime(2015, 3, 2),
MaxAttendees = 120
},
new TrainingProgram {
Name = "CPR Class",
Description = "Best to be prepared.",
StartDate = new DateTime(2016, 7, 12),
EndDate = new DateTime(2016, 7, 18),
MaxAttendees = 50
},
new TrainingProgram {
Name = "Public Speaking Workshop",
Description = "Always a handy skill to have.",
StartDate = new DateTime(2017, 4, 25),
EndDate = new DateTime(2017, 4, 28),
MaxAttendees = 15
}
};
foreach (TrainingProgram i in TrainingPrograms)
{
context.TrainingProgram.Add(i);
}
// Saves the TrainingPrograms to the database
context.SaveChanges();
// Creating new instances of Computer
var Computers = new Computer[]
{
new Computer {
Make = "Macbook Pro 2015",
Manufacturer = "Apple",
DatePurchased = new DateTime(2015, 4, 13)
},
new Computer {
Make = "Macbook Pro 2016",
Manufacturer = "Apple",
DatePurchased = new DateTime(2016, 4, 1)
},
new Computer {
Make = "Macbook Pro 2017",
Manufacturer = "Apple",
DatePurchased = new DateTime(2017, 4, 15)
},
new Computer {
Make = "Thinkpad",
Manufacturer = "Lenovo",
DatePurchased = new DateTime(2016, 4, 15)
},
new Computer {
Make = "Yoga",
Manufacturer = "Lenovo",
DatePurchased = new DateTime(2016, 4, 15)
},
new Computer {
Make = "Inspiron",
Manufacturer = "Dell",
DatePurchased = new DateTime(2016, 4, 15)
},
new Computer {
Make = "Aspire",
Manufacturer = "Acer",
DatePurchased = new DateTime(2016, 4, 15)
},
new Computer {
Make = "Pavilion",
Manufacturer = "HP",
DatePurchased = new DateTime(2016, 4, 15)
},
new Computer {
Make = "Sense",
Manufacturer = "Samsung",
DatePurchased = new DateTime(2016, 4, 15)
},
new Computer {
Make = "Zenbook",
Manufacturer = "Asus",
DatePurchased = new DateTime(2016, 4, 15)
},
new Computer {
Make = "Travelmate",
Manufacturer = "Acer",
DatePurchased = new DateTime(2016, 4, 15)
},
new Computer {
Make = "Elitebook",
Manufacturer = "HP",
DatePurchased = new DateTime(2016, 4, 15)
},
};
// Adds each new Computer into the context
foreach (Computer i in Computers)
{
context.Computer.Add(i);
}
// Saves the Computers to the database
context.SaveChanges();
var EmployeeComputers = new EmployeeComputer[]
{
new EmployeeComputer {
EmployeeID = 1,
ComputerID = 1,
DateAssigned = new DateTime(2017, 4, 15),
DateUnassigned = new DateTime(2017, 4, 16)
},
new EmployeeComputer {
EmployeeID = 2,
ComputerID = 1,
DateAssigned = new DateTime(2017, 4, 17),
DateUnassigned = new DateTime(2017, 4, 18)
},
new EmployeeComputer {
EmployeeID = 3,
ComputerID = 1,
DateAssigned = new DateTime(2017, 4, 19),
DateUnassigned = new DateTime(2017, 4, 20)
},
new EmployeeComputer {
EmployeeID = 4,
ComputerID = 1,
DateAssigned = new DateTime(2017, 4, 21),
DateUnassigned = new DateTime(2017, 4, 22)
},
new EmployeeComputer {
EmployeeID = 5,
ComputerID = 1,
DateAssigned = new DateTime(2017, 4, 23),
DateUnassigned = new DateTime(2017, 4, 24)
},
new EmployeeComputer {
EmployeeID = 6,
ComputerID = 1,
DateAssigned = new DateTime(2017, 4, 25),
DateUnassigned = new DateTime(2017, 4, 26)
},
new EmployeeComputer {
EmployeeID = 7,
ComputerID = 1,
DateAssigned = new DateTime(2017, 4, 27),
DateUnassigned = new DateTime(2017, 4, 28)
},
new EmployeeComputer {
EmployeeID = 8,
ComputerID = 1,
DateAssigned = new DateTime(2017, 4, 29),
DateUnassigned = new DateTime(2017, 4, 30)
},
new EmployeeComputer {
EmployeeID = 9,
ComputerID = 1,
DateAssigned = new DateTime(2017, 4, 1),
DateUnassigned = new DateTime(2017, 4, 2)
},
new EmployeeComputer {
EmployeeID = 10,
ComputerID = 1,
DateAssigned = new DateTime(2017, 4, 3),
DateUnassigned = new DateTime(2017, 4, 4)
},
new EmployeeComputer {
EmployeeID = 11,
ComputerID = 1,
DateAssigned = new DateTime(2017, 4, 5),
DateUnassigned = new DateTime(2017, 4, 6)
},
new EmployeeComputer {
EmployeeID = 12,
ComputerID = 1,
DateAssigned = new DateTime(2017, 4, 7),
DateUnassigned = new DateTime(2017, 4, 8)
},
new EmployeeComputer {
EmployeeID = 1,
ComputerID = 1,
DateAssigned = new DateTime(2017, 5, 01)
},
new EmployeeComputer {
EmployeeID = 2,
ComputerID = 2,
DateAssigned = new DateTime(2017, 5, 01)
},
new EmployeeComputer {
EmployeeID = 3,
ComputerID = 3,
DateAssigned = new DateTime(2017, 5, 01)
},
new EmployeeComputer {
EmployeeID = 4,
ComputerID = 4,
DateAssigned = new DateTime(2017, 5, 01)
},
new EmployeeComputer {
EmployeeID = 5,
ComputerID = 5,
DateAssigned = new DateTime(2017, 5, 01)
},
new EmployeeComputer {
EmployeeID = 6,
ComputerID = 6,
DateAssigned = new DateTime(2017, 5, 01)
},
new EmployeeComputer {
EmployeeID = 7,
ComputerID = 7,
DateAssigned = new DateTime(2017, 5, 01)
},
new EmployeeComputer {
EmployeeID = 8,
ComputerID = 8,
DateAssigned = new DateTime(2017, 5, 01)
}
};
// Adds each new EmployeeComputer into the context
foreach (EmployeeComputer i in EmployeeComputers)
{
context.EmployeeComputer.Add(i);
}
// Saves the Computers to the database
context.SaveChanges();
// Creating new instances of EmployeeTraining
var EmployeeTrainings = new EmployeeTraining[]
{
new EmployeeTraining {
EmployeeID = 1,
TrainingProgramID = 1
},
new EmployeeTraining {
EmployeeID = 2,
TrainingProgramID = 1
},
new EmployeeTraining {
EmployeeID = 3,
TrainingProgramID = 1
},
new EmployeeTraining {
EmployeeID = 4,
TrainingProgramID = 2
},
new EmployeeTraining {
EmployeeID = 5,
TrainingProgramID = 2
},
new EmployeeTraining {
EmployeeID = 6,
TrainingProgramID = 2
},
new EmployeeTraining {
EmployeeID = 7,
TrainingProgramID = 4
},
new EmployeeTraining {
EmployeeID = 8,
TrainingProgramID = 4
},
new EmployeeTraining {
EmployeeID = 9,
TrainingProgramID = 4
},
new EmployeeTraining {
EmployeeID = 7,
TrainingProgramID = 5
},
new EmployeeTraining {
EmployeeID = 8,
TrainingProgramID = 5
},
new EmployeeTraining {
EmployeeID = 9,
TrainingProgramID = 5
},
new EmployeeTraining {
EmployeeID = 7,
TrainingProgramID = 6
},
new EmployeeTraining {
EmployeeID = 9,
TrainingProgramID = 6
},
new EmployeeTraining {
EmployeeID = 9,
TrainingProgramID = 2
},
new EmployeeTraining {
EmployeeID = 9,
TrainingProgramID = 3
},
new EmployeeTraining {
EmployeeID = 10,
TrainingProgramID = 6
},
new EmployeeTraining {
EmployeeID = 8,
TrainingProgramID = 6
},
new EmployeeTraining {
EmployeeID = 11,
TrainingProgramID = 4
}
};
// Adds each new EmployeeTraining into the context
foreach (EmployeeTraining i in EmployeeTrainings)
{
context.EmployeeTraining.Add(i);
}
// Saves the EmployeeTraining to the database
context.SaveChanges();
}
}
public ComputersController(BanagazonWorkforceManagerContext context)
{
_context = context;
}
