protected void Page_Load(object sender, EventArgs e)
{
// make some data
var context = new MyEntityContext();
//var p1 = context.Persons.Create();
//p1.Name = "Kal";
//var s1 = context.Skills.Create();
//s1.Name = "nosql";
//p1.Skills.Add(s1);
if (context.Persons.Count() > 0) return;
for (var i = 0; i < 25; i++)
{
var employee = context.Persons.Create();
employee.Name = Firstnames[i] + " " + Surnames[i];
employee.Email = Firstnames[i].ToLower() + Surnames[i].ToLower() + "@company.com";
employee.EmployeeNumber = i;
}
var it = context.Departments.Create();
it.Name = "IT";
for (var i = 0; i < 5; i++)
{
var empCode = i;
var member = context.Persons.Where(emp => emp.EmployeeNumber.Equals(empCode)).FirstOrDefault();
if (member == null) continue;
it.Members.Add(member);
}
var marketing = context.Departments.Create();
marketing.Name = "Marketing";
for (var i = 5; i < 10; i++)
{
var empCode = i;
var member = context.Persons.Where(emp => emp.EmployeeNumber.Equals(empCode)).FirstOrDefault();
if (member == null) continue;
marketing.Members.Add(member);
}
var sales = context.Departments.Create();
sales.Name = "Sales";
for (var i = 10; i < 20; i++)
{
var empCode = i;
var member = context.Persons.Where(emp => emp.EmployeeNumber.Equals(empCode)).FirstOrDefault();
if (member == null) continue;
sales.Members.Add(member);
}
var cs = context.Departments.Create();
cs.Name = "Customer Services";
for (var i = 10; i < 20; i++)
{
var empCode = i;
var member = context.Persons.Where(emp => emp.EmployeeNumber.Equals(empCode)).FirstOrDefault();
if (member == null) continue;
cs.Members.Add(member);
}
context.SaveChanges();
}
