public static void Main()
{
// item 257
Bar db = new Bar();
// item 258
Bar.IDepartment yellow_m = db.InsertDepartment(0, "Yellow marketing");
Bar.IDepartment grey_m = db.InsertDepartment(0, "Grey marketing");
// item 259
Bar.IEmployee mark = db.InsertEmployee(10, "Mark", grey_m);
Bar.IEmployee john = db.InsertEmployee(20, "John", null);
// item 260
db.SetEmployeeDepartment(john, grey_m);
// item 261
var grey_employees = (
from e in grey_m.Employees
select e.Id).ToList();
var yellow_employees = (
from e in yellow_m.Employees
select e.Id).ToList();
grey_employees.Sort();
yellow_employees.Sort();
// item 262
Equal(new int[] { 10, 20 }, grey_employees);
Equal(new int[0], yellow_employees);
// item 263
db.SetEmployeeDepartment(mark, yellow_m);
// item 266
grey_employees = (
from e in grey_m.Employees
select e.Id).ToList();
yellow_employees = (
from e in yellow_m.Employees
select e.Id).ToList();
grey_employees.Sort();
yellow_employees.Sort();
// item 267
Equal(new int[] { 20 }, grey_employees);
Equal(new int[] { 10 }, yellow_employees);
Equal(yellow_m, mark.Department);
Equal(grey_m, john.Department);
// item 268
db.SetEmployeeDepartment(mark, null);
// item 269
db.DeleteDepartment(yellow_m);
db.DeleteDepartment(grey_m);
// item 271
Equal(null, db.GetDepartment(yellow_m.Id));
Equal(null, db.GetDepartment(grey_m.Id));
// item 272
Equal(null, db.GetEmployee(john.Id));
Equal(mark, db.GetEmployee(mark.Id));
}
public static void Main()
{
// item 255
Bar db = new Bar();
// item 161
Bar.IDepartment yellow_m = db.InsertDepartment(0, "Yellow marketing");
Bar.IDepartment grey_m = db.InsertDepartment(0, "Grey marketing");
// item 162
Bar.IEmployee mark = db.InsertEmployee(10, "Mark", grey_m);
Bar.IEmployee john = db.InsertEmployee(20, "John", null);
// item 188
db.SetEmployeeDepartment(john, grey_m);
// item 189
var grey_employees = (
from e in grey_m.Employees
select e.Id).ToList();
var yellow_employees = (
from e in yellow_m.Employees
select e.Id).ToList();
grey_employees.Sort();
yellow_employees.Sort();
// item 190
Equal(new int[] { 10, 20 }, grey_employees);
Equal(new int[0], yellow_employees);
// item 191
db.SetEmployeeDepartment(mark, yellow_m);
// item 256
grey_employees = (
from e in grey_m.Employees
select e.Id).ToList();
yellow_employees = (
from e in yellow_m.Employees
select e.Id).ToList();
grey_employees.Sort();
yellow_employees.Sort();
// item 257
Equal(new int[] { 20 }, grey_employees);
Equal(new int[] { 10 }, yellow_employees);
// item 194
ExpectException(() => db.DeleteDepartment(grey_m));
ExpectException(() => db.DeleteDepartment(yellow_m));
// item 195
db.SetEmployeeDepartment(mark, null);
// item 196
db.DeleteDepartment(yellow_m);
// item 197
db.DeleteEmployee(john);
// item 198
db.DeleteDepartment(grey_m);
}
public static void Main()
{
// item 233
Bar db = new Bar();
// item 160
Bar.ICompany yellow = db.InsertCompany(0);
Bar.ICompany grey = db.InsertCompany(0);
// item 161
Bar.IDepartment yellow_m = db.InsertDepartment(0, "Yellow marketing");
Bar.IDepartment grey_m = db.InsertDepartment(0, "Grey marketing");
// item 162
Bar.IEmployee grey_e = db.InsertEmployee(0, "Mark", grey_m);
Bar.IEmployee grey_e2 = db.InsertEmployee(0, "John", null);
// item 178
ExpectException(() => db.InsertEmployee(0, "Mark", grey_m));
// item 163
var fake = new FakeDepartment {
Id = 1000, Title = "Fake"
};
ExpectException(() => db.InsertEmployee(0, "Jack", fake));
// item 164
db.SetCompanyMarketing(yellow, yellow_m);
db.SetCompanyMarketing(grey, grey_m);
// item 165
db.SetEmployeeDepartment(grey_e2, grey_m);
// item 169
Equal(yellow_m, db.GetDepartment(yellow_m.Id));
// item 166
ExpectException(() => db.DeleteDepartment(yellow_m));
// item 167
db.DeleteCompany(yellow);
// item 168
Equal(null, db.GetDepartment(yellow_m.Id));
Equal(null, db.GetCompany(yellow.Id));
// item 170
ExpectException(() => db.DeleteCompany(grey));
// item 171
db.SetEmployeeDepartment(grey_e, null);
// item 172
db.DeleteEmployee(grey_e2);
// item 173
db.DeleteCompany(grey);
// item 174
Equal(null, db.GetCompany(grey.Id));
Equal(null, db.GetDepartment(grey_m.Id));
}
public static void Main()
{
// item 251
Bar db = new Bar();
// item 252
Bar.IDepartment yellow_m = db.InsertDepartment(0, "Yellow marketing");
Bar.IDepartment grey_m = db.InsertDepartment(0, "Grey marketing");
// item 253
Bar.IEmployee mark = db.InsertEmployee(10, "Mark");
Bar.IEmployee john = db.InsertEmployee(20, "John");
Bar.IEmployee scott = db.InsertEmployee(30, "Scott");
// item 188
db.AddToDepartmentEmployees(yellow_m, mark);
// item 238
db.AddToDepartmentEmployees(yellow_m, null);
// item 213
var fake = new FakeEmployee {
Id = 800, Name = "fake"
};
ExpectException(() => db.AddToDepartmentEmployees(yellow_m, fake));
// item 212
db.AddToDepartmentEmployees(grey_m, mark);
db.AddToDepartmentEmployees(grey_m, john);
db.AddToDepartmentEmployees(grey_m, scott);
// item 254
var grey_employees = (
from e in grey_m.Employees
select e.Id).ToList();
var yellow_employees = (
from e in yellow_m.Employees
select e.Id).ToList();
grey_employees.Sort();
yellow_employees.Sort();
// item 255
Equal(new int[] { 10, 20, 30 }, grey_employees);
Equal(new int[] { 10 }, yellow_employees);
// item 256
Equal(new Bar.IDepartment[] { yellow_m, grey_m }, mark.Departments);
Equal(new Bar.IDepartment[] { grey_m }, john.Departments);
Equal(new Bar.IDepartment[] { grey_m }, scott.Departments);
// item 227
Bar.ICompany company = db.InsertCompany(800);
// item 228
db.SetEmployeeCompany(mark, company);
db.SetEmployeeCompany(john, company);
db.SetEmployeeCompany(scott, company);
// item 302
db.SetDepartmentCompany(grey_m, company);
db.SetDepartmentCompany(yellow_m, company);
// item 230
db.RemoveFromDepartmentEmployees(yellow_m, mark);
// item 231
db.RemoveFromDepartmentEmployees(grey_m, mark);
db.RemoveFromDepartmentEmployees(grey_m, john);
db.RemoveFromDepartmentEmployees(grey_m, scott);
// item 232
Equal(0, grey_m.Employees.Count);
Equal(0, yellow_m.Employees.Count);
// item 233
Equal(0, mark.Departments.Count);
Equal(0, john.Departments.Count);
Equal(0, scott.Departments.Count);
// item 234
db.AddToDepartmentEmployees(yellow_m, john);
// item 303
db.AddToDepartmentEmployees(grey_m, mark);
db.AddToDepartmentEmployees(grey_m, john);
db.AddToDepartmentEmployees(grey_m, scott);
// item 236
Equal(new Bar.IEmployee[] { mark, john, scott }, grey_m.Employees);
Equal(new Bar.IEmployee[] { john }, yellow_m.Employees);
// item 237
Equal(new Bar.IDepartment[] { yellow_m, grey_m }, john.Departments);
Equal(new Bar.IDepartment[] { grey_m }, mark.Departments);
Equal(new Bar.IDepartment[] { grey_m }, scott.Departments);
// item 239
db.DeleteEmployee(scott);
// item 240
Equal(new Bar.IEmployee[] { mark, john }, grey_m.Employees);
// item 241
db.DeleteDepartment(yellow_m);
// item 242
Equal(new Bar.IDepartment[] { grey_m }, john.Departments);
// item 243
db.DeleteCompany(company);
// item 244
Equal(0, db.EmployeeCount());
Equal(0, db.DepartmentCount());
}
public static void Main()
{
// item 159
Bar db = new Bar();
// item 76
Bar.IEmployee john = db.InsertEmployee(0, "John", new DateTime(1978, 1, 1));
Bar.IEmployee mark = db.InsertEmployee(0, "Mark", new DateTime(1978, 1, 1));
Bar.IEmployee john2 = db.InsertEmployee(0, "John", new DateTime(1985, 1, 1));
// item 75
db.InsertDepartment(0, "Marketing");
db.InsertDepartment(0, "Sales");
db.InsertDepartment(0, "Logistics");
Bar.IDepartment marketing = db.FindDepartmentByTitle("Marketing");
Bar.IDepartment sales = db.FindDepartmentByTitle("Sales");
Bar.IDepartment logistics = db.FindDepartmentByTitle("Logistics");
// item 205
Equal(null, john.Department);
Equal(null, john2.Department);
Equal(null, mark.Department);
// item 137
db.SetEmployeeDepartment(john, null);
db.SetEmployeeDepartment(john2, null);
db.SetEmployeeDepartment(mark, null);
// item 136
Equal(null, john.Department);
Equal(null, john2.Department);
Equal(null, mark.Department);
// item 114
var fakeDepartment = new FakeDepartment {
Id = 1000, Title = "Fake"
};
ExpectException(() =>
db.SetEmployeeDepartment(john, fakeDepartment)
);
// item 138
db.SetEmployeeDepartment(john, marketing);
db.SetEmployeeDepartment(john2, sales);
db.SetEmployeeDepartment(mark, marketing);
// item 139
Equal(marketing, john.Department);
Equal(sales, john2.Department);
Equal(marketing, mark.Department);
// item 141
db.SetEmployeeDepartment(john, marketing);
db.SetEmployeeDepartment(john2, logistics);
db.SetEmployeeDepartment(mark, null);
// item 142
Equal(marketing, john.Department);
Equal(logistics, john2.Department);
Equal(null, mark.Department);
// item 143
db.DeleteDepartment(sales);
Equal(null, db.FindDepartmentByTitle("Sales"));
// item 144
ExpectException(() => db.DeleteDepartment(marketing));
ExpectException(() => db.DeleteDepartment(logistics));
// item 100
db.DeleteEmployee(john);
db.DeleteDepartment(marketing);
// item 101
db.SetEmployeeDepartment(john2, null);
db.DeleteDepartment(logistics);
// item 145
Equal(2, db.EmployeeCount());
Equal(0, db.DepartmentCount());
}
