private static void AddEmployee()
{
EMPLOYEE epe = new EMPLOYEE() { FIRSTNAME = "Yu", LASTNAME = "Liang", DEPARTMENTID = 3, EMPLOYEEID = 1, EMAIL = "*****@*****.**", EntityState = KoalaGIS.DAL.IRepository.EntityState.Added };
IEmployeeRepository customerRepository = container.GetExportedValue<IEmployeeRepository>("EmployeeRepository");
customerRepository.Add(epe);
customerRepository.Context.Commit();
customerRepository.Context.Dispose();
}
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();
}
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 AddEmployeeTest()
{
var epe = new EMPLOYEE
{
FIRSTNAME = "Yu",
LASTNAME = "Liang",
DEPARTMENTID = 3,
EMPLOYEEID = 1,
EMAIL = "*****@*****.**",
EntityState = EntityState.Added
};
var customerRepository =
this.container.GetExportedValue<IEmployeeRepository>("EmployeeRepository");
customerRepository.Add(epe);
customerRepository.Context.Commit();
//customerRepository.Context.Dispose();
var retValue = EFUnitTestHelper.ReadRecordValueFromEFTestDB(
@"EMPLOYEE",
@"FIRSTNAME",
@"T.DEPARTMENTID=3");
var ret = @"Yu";
Assert.That(ret, Is.EqualTo(retValue));
}
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));
}
private static void AddNewEmployeeWithExistenceDepartment()
{
IDepartmentRepository departmentRep = container.GetExportedValue<IDepartmentRepository>("DepartmentRepository");
DEPARTMENT dept = departmentRep.GetSingle(e=>e.DEPARTMENTID.Equals(3));
EMPLOYEE epe = new EMPLOYEE() { FIRSTNAME = "Yu4", LASTNAME = "Liang4", DEPARTMENTID = dept.DEPARTMENTID, EMPLOYEEID = 4, EMAIL = "*****@*****.**", EntityState = KoalaGIS.DAL.IRepository.EntityState.Added };
IEmployeeRepository employeeRep = container.GetExportedValue<IEmployeeRepository>("EmployeeRepository");
employeeRep.Modify(epe);
employeeRep.Context.Commit();
employeeRep.Context.Dispose();
}
