private static void AddDepartment() { DEPARTMENT it = new DEPARTMENT() { NAME = "IT", DEPARTMENTID = 3, EntityState = KoalaGIS.DAL.IRepository.EntityState.Added }; IDepartmentRepository customerRepository = container.GetExportedValue<IDepartmentRepository>("DepartmentRepository"); customerRepository.Add(it); customerRepository.Context.Commit(); customerRepository.Context.Dispose(); }
public void AddDepartmentTest() { var it = new DEPARTMENT { NAME = "IT", DEPARTMENTID = 3, EntityState = EntityState.Added }; var departmentRepository = this.container.GetExportedValue<IDepartmentRepository>("DepartmentRepository"); departmentRepository.Add(it); departmentRepository.Context.Commit(); //departmentRepository.Context.Dispose(); var retValue = EFUnitTestHelper.ReadRecordValueFromEFTestDB(@"DEPARTMENT", @"NAME", @"T.DEPARTMENTID=3"); var ret = @"IT"; Assert.That(ret, Is.EqualTo(retValue)); }
private static void AddDepartmentWithEmployee2() { EMPLOYEE epe = new EMPLOYEE() { FIRSTNAME = "Yu2", LASTNAME = "Liang2", EMPLOYEEID = 6, EMAIL = "*****@*****.**", EntityState = KoalaGIS.DAL.IRepository.EntityState.Added }; EMPLOYEE epe2 = new EMPLOYEE() { FIRSTNAME = "Yu3", LASTNAME = "Liang3", EMPLOYEEID = 7, EMAIL = "*****@*****.**", EntityState = KoalaGIS.DAL.IRepository.EntityState.Added }; ICollection<EMPLOYEE> items = new Collection<EMPLOYEE>(); items.Add(epe); items.Add(epe2); DEPARTMENT it = new DEPARTMENT() { NAME = "ITeeee", DEPARTMENTID = 6, Employees = items, EntityState = KoalaGIS.DAL.IRepository.EntityState.Added }; IDepartmentRepository customerRepository = container.GetExportedValue<IDepartmentRepository>("DepartmentRepository"); customerRepository.Add(it); customerRepository.Context.Commit(); customerRepository.Context.Dispose(); }
//Department is new but employee is existence private static void AddNewDepartmentWithExistenceEmployee() { IEmployeeRepository employeeRepository = container.GetExportedValue<IEmployeeRepository>("EmployeeRepository"); IList<EMPLOYEE> employeeList = employeeRepository.GetList(e => e.DEPARTMENTID.Equals(4)); IDepartmentRepository departmentRepository = container.GetExportedValue<IDepartmentRepository>("DepartmentRepository"); ICollection<EMPLOYEE> items = new Collection<EMPLOYEE>(); foreach (var employee in employeeList) { items.Add(employee); } DEPARTMENT newOne = new DEPARTMENT() { DEPARTMENTID = 5, NAME = "TEST", Employees = items, EntityState = KoalaGIS.DAL.IRepository.EntityState.Added }; departmentRepository.Modify(newOne); departmentRepository.Context.Commit(); departmentRepository.Context.Dispose(); }
public void AddDepartmentWithEmployeeTest() { var epe = new EMPLOYEE { FIRSTNAME = "Yu2", LASTNAME = "Liang2", DEPARTMENTID = 4, EMPLOYEEID = 2, EMAIL = "*****@*****.**", EntityState = EntityState.Added }; var epe2 = new EMPLOYEE { FIRSTNAME = "Yu3", LASTNAME = "Liang3", DEPARTMENTID = 4, EMPLOYEEID = 3, EMAIL = "*****@*****.**", EntityState = EntityState.Added }; ICollection<EMPLOYEE> items = new Collection<EMPLOYEE>(); items.Add(epe); items.Add(epe2); var it = new DEPARTMENT { NAME = "IT2", DEPARTMENTID = 4, Employees = items, EntityState = EntityState.Added }; var customerRepository = this.container.GetExportedValue<IDepartmentRepository>("DepartmentRepository"); customerRepository.Add(it); customerRepository.Context.Commit(); //customerRepository.Context.Dispose(); var DeptCount = EFUnitTestHelper.ReadRecordCountFromEFTestDB(@"DEPARTMENT"); var retDept = 1; var EmpCount = EFUnitTestHelper.ReadRecordCountFromEFTestDB(@"EMPOLYEE"); var retEmp = 2; Assert.That(retDept, Is.EqualTo(DeptCount)); Assert.That(retEmp, Is.EqualTo(EmpCount)); }
public void ModifyEmployee() { var epe = new EMPLOYEE { FIRSTNAME = "Yu2", LASTNAME = "Liang2", EMPLOYEEID = 6, EMAIL = "*****@*****.**", EntityState = EntityState.Added }; var epe2 = new EMPLOYEE { FIRSTNAME = "Yu3", LASTNAME = "Liang3", EMPLOYEEID = 7, EMAIL = "*****@*****.**", EntityState = EntityState.Added }; ICollection<EMPLOYEE> items = new Collection<EMPLOYEE>(); items.Add(epe); items.Add(epe2); var it = new DEPARTMENT { NAME = "ITeeee", DEPARTMENTID = 6, Employees = items, EntityState = EntityState.Added }; var deptRepository = this.container.GetExportedValue<IDepartmentRepository>("DepartmentRepository"); deptRepository.Add(it); deptRepository.Context.Commit(); var empRepository = this.container.GetExportedValue<IEmployeeRepository>("EmployeeRepository"); var entity = empRepository.GetSingle(e => e.FIRSTNAME.Equals("Yu2")); entity.FIRSTNAME = "YUeeeee"; entity.EntityState = EntityState.Modified; empRepository.Modify(entity); empRepository.Context.Commit(); var retFirstName = EFUnitTestHelper.ReadRecordValueFromEFTestDB( "EMPLOYEE", "FIRSTNAME", "T.EMPLOYEEID=6"); var ret = "YUeeeee"; Assert.That(retFirstName, Is.EqualTo(ret)); }
public void AddNewDepartmentWithExistenceEmployee() { var epe = new EMPLOYEE { FIRSTNAME = "Yu", LASTNAME = "Liang", DEPARTMENTID = 1, EMPLOYEEID = 1, EMAIL = "*****@*****.**", EntityState = EntityState.Added }; var epe2 = new EMPLOYEE { FIRSTNAME = "Yu2", LASTNAME = "Liang2", DEPARTMENTID = 1, EMPLOYEEID = 2, EMAIL = "*****@*****.**", EntityState = EntityState.Added }; var employeeRepository = this.container.GetExportedValue<IEmployeeRepository>("EmployeeRepository"); employeeRepository.Add(epe); employeeRepository.Add(epe2); var employeeList = employeeRepository.GetList(e => e.DEPARTMENTID.Equals(1)); var departmentRepository = this.container.GetExportedValue<IDepartmentRepository>("DepartmentRepository"); ICollection<EMPLOYEE> items = new Collection<EMPLOYEE>(); foreach (var employee in employeeList) { items.Add(employee); } var newOne = new DEPARTMENT { DEPARTMENTID = 5, NAME = "TEST", Employees = items, EntityState = EntityState.Added }; departmentRepository.Add(newOne); departmentRepository.Context.Commit(); var retDeptId = EFUnitTestHelper.ReadRecordValueFromEFTestDB( "EMPLOYEE", "DEPARTMENTID", "T.EMPLOYEEID=1"); var ret = "5"; Assert.That(ret, Is.EqualTo(retDeptId)); }
public void AddDepartmentWithEmployeeTest2() { var it = new DEPARTMENT { NAME = "ITeeee", DEPARTMENTID = 6, EntityState = EntityState.Added }; var epe = new EMPLOYEE { FIRSTNAME = "Yu2", LASTNAME = "Liang2", EMPLOYEEID = 6, DEPARTMENTID = it.DEPARTMENTID, EMAIL = "*****@*****.**", EntityState = EntityState.Added }; var epe2 = new EMPLOYEE { FIRSTNAME = "Yu3", LASTNAME = "Liang3", EMPLOYEEID = 7, DEPARTMENTID = it.DEPARTMENTID, EMAIL = "*****@*****.**", EntityState = EntityState.Added }; ICollection<EMPLOYEE> items = new Collection<EMPLOYEE>(); items.Add(epe); items.Add(epe2); it.Employees = items; var customerRepository = this.container.GetExportedValue<IDepartmentRepository>("DepartmentRepository"); customerRepository.Add(it); customerRepository.Context.Commit(); //customerRepository.Context.Dispose(); var EmployeeId = EFUnitTestHelper.ReadRecordValueFromEFTestDB( "EMPLOYEE", "DEPARTMENTID", "T.EMPLOYEEID=6"); var EmployeeId2 = EFUnitTestHelper.ReadRecordValueFromEFTestDB( "EMPLOYEE", "DEPARTMENTID", "T.EMPLOYEEID=7"); var retId = "6"; Assert.That(retId, Is.EqualTo(EmployeeId)); Assert.That(retId, Is.EqualTo(EmployeeId2)); }