public static void Main() { // item 180 Bar db = new Bar(); // item 35 Equal(null, db.FindEmployeeByNameBirthday("John", 1978)); Equal(null, db.FindEmployeeByNameBirthday("John", 1980)); Equal(null, db.FindEmployeeByNameBirthday("Mark", 1965)); // item 76 Bar.IEmployee john = db.InsertEmployee(400, "John", 1978); // item 77 Equal(400, john.Id); // item 75 Bar.IEmployee mark = db.InsertEmployee(0, "Mark", 1965); Bar.IEmployee john2 = db.InsertEmployee(0, "John", 1980); // item 181 Equal(john, db.FindEmployeeByNameBirthday("John", 1978)); Equal(john2, db.FindEmployeeByNameBirthday("John", 1980)); Equal(mark, db.FindEmployeeByNameBirthday("Mark", 1965)); // item 114 ExpectException( () => db.InsertEmployee(0, "Mark", 1965) ); // item 69 Equal("John", john.Name); Equal("John", john2.Name); Equal("Mark", mark.Name); Equal(1978, john.Birthday); // item 122 ExpectException( () => db.SetEmployeeBirthday(john, 1980) ); // item 124 db.SetEmployeeName(mark, "John"); // item 129 Equal(john, db.FindEmployeeByNameBirthday("John", 1978)); Equal(john2, db.FindEmployeeByNameBirthday("John", 1980)); Equal(mark, db.FindEmployeeByNameBirthday("John", 1965)); // item 125 Equal(null, db.FindEmployeeByNameBirthday("Mark", 1965)); // item 127 Equal("John", john.Name); Equal("John", mark.Name); // item 99 db.DeleteEmployee(john); db.DeleteEmployee(john2); // item 100 db.DeleteEmployee(mark); // item 101 Equal(null, db.GetEmployee(john.Id)); Equal(null, db.GetEmployee(john2.Id)); Equal(null, db.GetEmployee(mark.Id)); // item 182 Equal(null, db.FindEmployeeByNameBirthday("John", 1978)); Equal(null, db.FindEmployeeByNameBirthday("John", 1980)); Equal(null, db.FindEmployeeByNameBirthday("John", 1965)); }
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 176 Bar db = new Bar(); // item 35 Equal(null, db.FindEmployeeByName("John")); Equal(null, db.FindEmployeeByName("Mark")); // item 76 Bar.IEmployee john = db.InsertEmployee(0, "John"); Bar.IEmployee mark = db.InsertEmployee(0, "Mark"); // item 177 Equal(john, db.FindEmployeeByName("John")); Equal(mark, db.FindEmployeeByName("Mark")); // item 114 ExpectException( () => db.InsertEmployee(0, "John") ); // item 118 db.SetEmployeeName(john, "John"); // item 120 Equal("John", john.Name); Equal(john, db.FindEmployeeByName("John")); // item 178 ExpectException( () => db.SetEmployeeName(john, "Mark") ); // item 179 db.SetEmployeeName(john, "John Connor"); // item 180 Equal(null, db.FindEmployeeByName("John")); Equal(john, db.FindEmployeeByName("John Connor")); // item 127 Equal("John Connor", john.Name); Equal("Mark", mark.Name); // item 99 db.DeleteEmployee(john); db.DeleteEmployee(mark); // item 181 Equal(null, db.FindEmployeeByName("John")); Equal(null, db.FindEmployeeByName("Mark")); }
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()); }
public static void Main() { IEnumerator <Bar.IEmployee> _it90 = null; Bar.IEmployee person = default(Bar.IEmployee); // item 19 Bar db = new Bar(); // item 35 Equal(null, db.GetEmployee(400)); // item 108 Equal(0, db.EmployeeCount()); // item 76 Bar.IEmployee john = db.InsertEmployee(400); // item 77 Equal(400, john.Id); // item 78 Equal(john, db.GetEmployee(400)); // item 75 Bar.IEmployee mark = db.InsertEmployee(0); // item 83 NotEqual(mark, john); NotEqual(mark.Id, john.Id); // item 69 Equal(null, john.Name); Equal(null, mark.Name); // item 67 john.Name = "John"; john.Type = 100; // item 68 mark.Name = "Mark"; mark.Type = 200; // item 113 Equal("John", john.Name); Equal(100, john.Type); Equal("Mark", mark.Name); Equal(200, mark.Type); // item 92 List <string> names = new List <string>(); // item 900001 _it90 = ((IEnumerable <Bar.IEmployee>)db.EachEmployee()).GetEnumerator(); while (true) { // item 900002 if (_it90.MoveNext()) { } else { break; } // item 900004 person = _it90.Current; // item 93 names.Add(person.Name); } // item 95 names.Sort(); // item 114 Equal(new string[] { "John", "Mark" }, names); // item 102 Equal(2, db.EmployeeCount()); // item 99 int johnId = john.Id; int markId = mark.Id; // item 100 db.DeleteEmployee(john); db.DeleteEmployee(mark); // item 101 Equal(null, db.GetEmployee(johnId)); Equal(null, db.GetEmployee(markId)); // item 115 Equal(0, db.EmployeeCount()); }