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 AddToCustomersTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var customer = new Customer { CustomerId = 1, FirstName = "TestFirst", LastName = "TestLast", Email = "Test" }; var employee = new Employee { EmployeeId = 1, FirstName = "TesteFirst", LastName = "TesteLast", Email = "eTest" }; context.Add(customer); context.Add(employee); context.SaveChanges(); CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider); EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider); employeeBE.Load(1); customerBE.Load(1); employeeBE.AddToCustomer(customerBE); customerBE.Save(); employeeBE.Load(1); var customerBECollection = employeeBE.GetCustomers(); Assert.IsTrue(customerBECollection.First().Id == 1); Assert.IsTrue(customerBECollection.First().SupportRepId == 1); }
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 CustomerCountTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var customer = new Customer { CustomerId = 1, SupportRepId = 1, FirstName = "TestFirst", LastName = "TestLast", Email = "Test" }; var customer2 = new Customer { CustomerId = 2, FirstName = "Test2First", LastName = "Test2Last", Email = "2Test" }; var employee = new Employee { EmployeeId = 1, FirstName = "TesteFirst", LastName = "TesteLast", Email = "eTest" }; context.Add(customer); context.Add(customer2); context.Add(employee); context.SaveChanges(); EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider); employeeBE.Load(1); Assert.IsTrue(employeeBE.CustomerCount == 1); CustomerBE customerBE = new CustomerBE(cRUDTestDBContextProvider); customerBE.Load(2); employeeBE.AddToCustomer(customerBE); customerBE.Save(); EmployeeBE employeeBE2 = new EmployeeBE(cRUDTestDBContextProvider); employeeBE2.Load(1); Assert.IsTrue(employeeBE2.CustomerCount == 2); }
public void ToStringTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var employee = new Employee { EmployeeId = 1, Title = "TestTitle", FirstName = "TestFirst", LastName = "TestLast", Email = "Test" }; context.Add(employee); context.SaveChanges(); EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider); employeeBE.Load(1); Assert.IsTrue(employeeBE.ToString().Equals("Employee Name:TestFirst TestLast Title:TestTitle")); }
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 == "*****@*****.**"); }
public void GetCustomersTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var customerGetCustomersTest = new Customer { CustomerId = 1, SupportRepId = 1, FirstName = "Test", LastName = "Test", Email = "Test" }; var employeeGetCustomersTest = new Employee { EmployeeId = 1, FirstName = "TestFirst", LastName = "TestLast" }; var employeeGetCustomersTest2 = new Employee { EmployeeId = 2, FirstName = "TestFirst", LastName = "TestLast" }; context.Add(customerGetCustomersTest); context.Add(employeeGetCustomersTest); context.Add(employeeGetCustomersTest2); context.SaveChanges(); EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider); EmployeeBE employeeBE2 = new EmployeeBE(cRUDTestDBContextProvider); employeeBE.Load(1); employeeBE2.Load(2); var customerBECollection = employeeBE.GetCustomers(); Assert.IsTrue(customerBECollection.First().GetType() == typeof(CustomerBE)); Assert.IsTrue(customerBECollection.First().FirstName == "Test"); Assert.IsTrue(customerBECollection.First().Id == 1); Assert.IsTrue(employeeBE2.GetCustomers().IsNullOrEmpty()); }
public void LoadValidIdTest() { ICRUDTestDBContextProvider cRUDTestDBContextProvider = new CRUDTestDBContextProvider(Guid.NewGuid().ToString()); var context = cRUDTestDBContextProvider.GetContext(); var employee = new Employee { EmployeeId = 1, FirstName = "TestFirstName", LastName = "TestLastName", Title = "TestTitle", ReportsTo = 2, BirthDate = new DateTime(2000, 1, 1), HireDate = new DateTime(2020, 1, 1), Email = "*****@*****.**", Address = "123 Test Address", City = "TestCity", State = "TestState", Country = "TestCountry", PostalCode = "TestPC", Phone = "TestPhone", Fax = "TestFax", }; var employee2 = new Employee { EmployeeId = 2, FirstName = "TestFirstName2", LastName = "TestLastName2", Title = "TestTitle2", BirthDate = new DateTime(1990, 1, 1), HireDate = new DateTime(2020, 1, 1), Email = "*****@*****.**", Address = "123 Test Address", City = "TestCity", State = "TestState", Country = "TestCountry", PostalCode = "TestPC", Phone = "TestPhone", Fax = "TestFax", }; context.Add(employee); context.Add(employee2); context.SaveChanges(); EmployeeBE employeeBE = new EmployeeBE(cRUDTestDBContextProvider); employeeBE.Load(1); Assert.IsTrue(employeeBE.Id == 1); Assert.IsTrue(employeeBE.FirstName == "TestFirstName"); Assert.IsTrue(employeeBE.LastName == "TestLastName"); Assert.IsTrue(employeeBE.Title == "TestTitle"); Assert.IsTrue(employeeBE.BirthDate.Equals(new DateTime(2000, 1, 1))); Assert.IsTrue(employeeBE.HireDate.Equals(new DateTime(2020, 1, 1))); Assert.IsTrue(employeeBE.Address == "123 Test Address"); Assert.IsTrue(employeeBE.City == "TestCity"); Assert.IsTrue(employeeBE.State == "TestState"); Assert.IsTrue(employeeBE.Country == "TestCountry"); Assert.IsTrue(employeeBE.PostalCode == "TestPC"); Assert.IsTrue(employeeBE.Phone == "TestPhone"); Assert.IsTrue(employeeBE.Fax == "TestFax"); Assert.IsTrue(employeeBE.Email == "*****@*****.**"); Assert.IsTrue(employeeBE.ReportsTo == 2); }