private void Seed(MyDataContext context)
{
var roleAdmin = new Role {
Id = 1, Name = "Administrator", Description = "Administrator"
};
var roleSuperUser = new Role {
Id = 2, Name = "SuperUser", Description = "Super User"
};
var roleApplicationUser = new Role {
Id = 4, Name = "ApplicationUser", Description = "Application User"
};
context.Roles.Add(roleAdmin);
context.Roles.Add(roleSuperUser);
context.Roles.Add(roleApplicationUser);
context.SaveChanges();
var userAdmin = new User {
Id = 1, IdentityName = "admin", DisplayName = "admin", EmailAddress = "*****@*****.**", Roles = new List <Role>()
};
userAdmin.Roles.Add(roleAdmin);
userAdmin.Roles.Add(roleSuperUser);
userAdmin.Roles.Add(roleApplicationUser);
context.Users.Add(userAdmin);
var superUser = new User {
Id = 2, IdentityName = "super user", DisplayName = "super user", EmailAddress = "*****@*****.**", Roles = new List <Role>()
};
superUser.Roles.Add(roleSuperUser);
superUser.Roles.Add(roleApplicationUser);
context.Users.Add(superUser);
var appUser = new User {
Id = 3, IdentityName = "app user", DisplayName = "app user", EmailAddress = "*****@*****.**", Roles = new List <Role>()
};
appUser.Roles.Add(roleApplicationUser);
context.Users.Add(appUser);
context.SaveChanges();
var functionIct = new Function {
Id = 1, Code = "ICT", Name = "ICT"
};
var functionManagement = new Function {
Id = 2, Code = "MAN", Name = "Management"
};
var functions = new List <Function> {
functionIct, functionManagement
};
functions.ForEach(s => context.Functions.Add(s));
context.SaveChanges();
for (int i = 1; i <= 10; i++)
{
var subFunctionIct = new SubFunction {
Id = 1, Code = "ICT-" + i, Name = "ICT - " + i, Function = functionIct
};
context.SubFunctions.Add(subFunctionIct);
}
for (int i = 1; i <= 5; i++)
{
var subFunctionManagement = new SubFunction {
Id = 1, Code = "MAN-" + i, Name = "Management - " + i, Function = functionManagement
};
context.SubFunctions.Add(subFunctionManagement);
}
context.SaveChanges();
var countryNL = new Country {
Id = 1, Code = "NL", Name = "The Netherlands"
};
var countryBE = new Country {
Id = 2, Code = "BE", Name = "Belgium"
};
var countries = new List <Country> {
countryNL, countryBE
};
countries.ForEach(c => context.Countries.Add(c));
context.SaveChanges();
var mainCompany1 = new MainCompany {
Id = 10, Name = "M - 1"
};
var mainCompany2 = new MainCompany {
Id = 20, Name = "M - 2"
};
var mainCompanies = new List <MainCompany> {
mainCompany1, mainCompany2
};
mainCompanies.ForEach(x => context.MainCompanies.Add(x));
context.SaveChanges();
var companyA = new Company {
Id = 1, Name = "A", MainCompany = mainCompany1
};
var companyB = new Company {
Id = 2, Name = "B", MainCompany = mainCompany1
};
var companyC = new Company {
Id = 3, Name = "C", MainCompany = mainCompany2
};
var companies = new List <Company> {
companyA, companyB, companyC
};
companies.ForEach(x => context.Companies.Add(x));
context.SaveChanges();
var employees = new List <Employee>
{
new Employee {
Id = 1, Assigned = null, Country = countryNL, Company = companyA, FirstName = "Bill", LastName = "Smith", Email = "*****@*****.**", EmployeeNumber = 1001, HireDate = Convert.ToDateTime("01/12/1990"), Function = functionManagement, SubFunction = functionManagement.SubFunctions.First()
},
new Employee {
Id = 2, Assigned = 1, Country = countryNL, Company = companyB, FirstName = "Jack", LastName = "Smith", Email = "*****@*****.**", EmployeeNumber = 1002, HireDate = Convert.ToDateTime("12/12/1997"), Function = functionManagement, SubFunction = functionManagement.SubFunctions.First()
},
new Employee {
Id = 3, Assigned = 2, Country = countryNL, Company = companyC, FirstName = "Mary", LastName = "Gates", Email = "*****@*****.**", EmployeeNumber = 1003, HireDate = Convert.ToDateTime("03/03/2000"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[1]
},
new Employee {
Id = 4, Assigned = null, Country = countryNL, Company = companyA, FirstName = "John", LastName = "Doe", Email = "*****@*****.**", EmployeeNumber = 1004, HireDate = Convert.ToDateTime("11/11/2011"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[2]
},
new Employee {
Id = 5, Assigned = 0, Country = countryBE, Company = companyB, FirstName = "Chris", LastName = "Cross", Email = "*****@*****.**", EmployeeNumber = 1005, HireDate = Convert.ToDateTime("05/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[3]
},
new Employee {
Id = 6, Assigned = 1, Country = countryBE, Company = companyC, FirstName = "Niki", LastName = "Myers", Email = "*****@*****.**", EmployeeNumber = 1006, HireDate = Convert.ToDateTime("06/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[4]
},
new Employee {
Id = 7, Assigned = null, Country = countryBE, Company = companyA, FirstName = "Joseph", LastName = "Hall", Email = "*****@*****.**", EmployeeNumber = 1007, HireDate = Convert.ToDateTime("07/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[5]
},
new Employee {
Id = 8, Assigned = 0, Country = countryBE, Company = companyB, FirstName = "Daniel", LastName = "Wells", Email = "*****@*****.**", EmployeeNumber = 1008, HireDate = Convert.ToDateTime("08/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[6]
},
new Employee {
Id = 9, Assigned = 1, Country = countryNL, Company = companyC, FirstName = "Robert", LastName = "Lawrence", Email = "*****@*****.**", EmployeeNumber = 1009, HireDate = Convert.ToDateTime("09/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[7]
},
new Employee {
Id = 10, Assigned = 0, Country = countryNL, Company = companyA, FirstName = "Reginald", LastName = "Quinn", Email = "*****@*****.**", EmployeeNumber = 1010, HireDate = Convert.ToDateTime("10/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[8]
},
new Employee {
Id = 11, Assigned = 2, Country = countryNL, Company = companyB, FirstName = "Quinn", LastName = "Quick", Email = "*****@*****.**", EmployeeNumber = 1011, HireDate = Convert.ToDateTime("11/05/1995"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[9]
},
new Employee {
Id = 12, Assigned = null, Country = countryNL, Company = companyC, FirstName = "Test", LastName = "User", Email = "*****@*****.**", EmployeeNumber = 1012, HireDate = Convert.ToDateTime("11/05/2012"), Function = functionIct, SubFunction = functionIct.SubFunctions.ToArray()[0]
},
};
employees.ForEach(x => context.Employees.Add(x));
context.SaveChanges();
var products = new List <Product>
{
new Product {
Id = 1, Code = "AR-5381", Name = "Adjustable Race"
},
new Product {
Id = 2, Code = "BA-8327", Name = "Bearing Ball"
},
new Product {
Id = 3, Code = "BE-2349", Name = "BB Ball Bearing"
},
new Product {
Id = 4, Code = "BE-2908", Name = "Headset Ball Bearings"
},
new Product {
Id = 316, Code = "BL-2036", Name = "Blade"
},
new Product {
Id = 317, Code = "CA-5965", Name = "LL Crankarm"
},
new Product {
Id = 318, Code = "CA-6738", Name = "ML Crankarm"
},
new Product {
Id = 319, Code = "CA-7457", Name = "HL Crankarm"
},
new Product {
Id = 320, Code = "CB-2903", Name = "Chainring Bolts"
},
new Product {
Id = 321, Code = "CN-6137", Name = "Chainring Nut"
},
new Product {
Id = 322, Code = "CR-7833", Name = "Chainring"
}
};
products.ForEach(x => context.Products.Add(x));
context.SaveChanges();
const int numOUs = 5000;
var generator = new LipsumGenerator();
var list = new List <OU>();
for (int i = 1000000; i < 1000000 + numOUs; i++)
{
var ou = new OU
{
Code = i.ToString(CultureInfo.InvariantCulture),
Name = string.Join(" ", generator.GenerateWords(3))
};
list.Add(ou);
}
BulkInsert(context, context.OUs, list);
}
public override void ToFunction(out Function function)
{
_left.ToFunction(out var leftF);
_right.ToFunction(out var rightF);
function = new SubFunction(leftF, rightF);
}
