public void AddToEmployeeTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var employee1 = new Employee { EmployeeId = 1, FirstName = "Test1First", LastName = "Test1Last" }; var employee2 = new Employee { EmployeeId = 2, FirstName = "Test2First", LastName = "Test2Last" }; context.Add(employee1); context.Add(employee2); context.SaveChanges(); EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider); EmployeeBE employeeBE2 = new EmployeeBE(cRUDTestDBContextProvider); employeeBE.Load(1); employeeBE2.Load(2); employeeBE2.AddSubordinate(employeeBE); employeeBE.Save(); employeeBE.Load(1); var employeeBECollection = employeeBE2.GetReportsToThisEmployee(); Assert.IsTrue(employeeBECollection.First().Id == 1); Assert.IsTrue(employeeBECollection.First().ReportsTo == 2); }
public void ReportsToCountTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var employee = new Employee { EmployeeId = 1, ReportsTo = 3, FirstName = "TestFirst", LastName = "TestLast", Email = "Test" }; var employee2 = new Employee { EmployeeId = 2, FirstName = "Test2First", LastName = "Test2Last", Email = "2Test" }; var employeeReportedTo = new Employee { EmployeeId = 3, FirstName = "Test3First", LastName = "Test3Last", Email = "3Test" }; context.Add(employee); context.Add(employee2); context.Add(employeeReportedTo); context.SaveChanges(); EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider); employeeBE.Load(3); Assert.IsTrue(employeeBE.ReportsToCount == 1); EmployeeBE employeeBE2 = new EmployeeBE(cRUDTestDBContextProvider); employeeBE2.Load(2); employeeBE.AddSubordinate(employeeBE2); employeeBE2.Save(); EmployeeBE employeeBE3 = new EmployeeBE(cRUDTestDBContextProvider); employeeBE3.Load(3); Assert.IsTrue(employeeBE3.ReportsToCount == 2); }
public void SaveWithoutIdTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider); employeeBE.New(); employeeBE.FirstName = "TestFirstName"; employeeBE.LastName = "TestLastName"; employeeBE.Save(); Assert.IsTrue(employeeBE.Id != default); }
public void SaveValidIdTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var employee = new Employee { EmployeeId = 1 }; context.Add(employee); context.SaveChanges(); EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider); employeeBE.Load(1); employeeBE.FirstName = "TestFirstName"; employeeBE.LastName = "TestLastName"; employeeBE.Title = "TestTitle"; employeeBE.BirthDate = new DateTime(2000, 1, 1); employeeBE.HireDate = new DateTime(2020, 1, 1); employeeBE.Address = "123 Test Address"; employeeBE.City = "TestCity"; employeeBE.State = "TestState"; employeeBE.Country = "TestCountry"; employeeBE.PostalCode = "TestPC"; employeeBE.Phone = "TestPhone"; employeeBE.Fax = "TestFax"; employeeBE.Email = "*****@*****.**"; employeeBE.Save(); EmployeeBE employeeBE2 = new EmployeeBE(cRUDTestDBContextProvider); employeeBE2.Load(1); Assert.IsTrue(employeeBE2.Id == 1); Assert.IsTrue(employeeBE2.FirstName == "TestFirstName"); Assert.IsTrue(employeeBE2.LastName == "TestLastName"); Assert.IsTrue(employeeBE2.Title == "TestTitle"); Assert.IsTrue(employeeBE2.BirthDate.Equals(new DateTime(2000, 1, 1))); Assert.IsTrue(employeeBE2.HireDate.Equals(new DateTime(2020, 1, 1))); Assert.IsTrue(employeeBE2.Address == "123 Test Address"); Assert.IsTrue(employeeBE2.City == "TestCity"); Assert.IsTrue(employeeBE2.State == "TestState"); Assert.IsTrue(employeeBE2.Country == "TestCountry"); Assert.IsTrue(employeeBE2.PostalCode == "TestPC"); Assert.IsTrue(employeeBE2.Phone == "TestPhone"); Assert.IsTrue(employeeBE2.Fax == "TestFax"); Assert.IsTrue(employeeBE2.Email == "*****@*****.**"); }