private void Add10Managers() { var repository = new EFRepositoryTester(); repository.Initialize(); var addingDate = DateTime.UtcNow; for (int i = 0; i < 10; i++) { var manager = new Manager() { Director = director, ManagerTrackers = new List<ManagerTracker>() { new ManagerTracker() }, Office = office1, Computer = new Computer() { Data = "data", Admin = admin }, Things = new List<Thing>() { new Thing() { Id = 1, Admin = admin, Data = "data" }, new Thing() { Id = 2, Admin = admin, Data = "data" } }, Description = new Description() { Data = "data" }, Data = "data", Car = car1, //Projects = new List<Project>() //{ // project1, // project2 //} }; manager.Data = "data" + i; repository.Add(new AddOperationParameters<Manager>() { Entity = manager, OperationDateTime = addingDate }); } }
public void Get_WithAllRelatedEntities_ReturnsEntities() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); var manager = new Manager() { Director = director, ManagerTrackers = new List<ManagerTracker>() { new ManagerTracker() }, Office = office1, Computer = new Computer() { Data = "data", Admin = admin }, Things = new List<Thing>() { new Thing() { Id = 1, Admin = admin, Data = "data" }, new Thing() { Id = 2, Admin = admin, Data = "data" } }, Description = new Description() { Data = "data" }, Data = "data", Car = car1, Projects = new List<Project>() { project1, //project2 } }; repository.Add(new AddOperationParameters<Manager>() { Entity = manager, OperationDateTime = initializingDate }); //Attach using entities var context = new EFContext(); context.Directors.Attach(director); context.Managers.Attach(manager); director.Managers = new List<Manager>(); director.Managers.Add(manager); context.ManagerTrackers.Add(new ManagerTracker() { Manager = manager, Data = "data" }); context.SaveChanges(); //Act var entities = repository.Get(new GetOperationParameters() { LoadSubEntities = true, LoadUsedEntities = true, LoadUsingEntities = true, }); //Assert Assert.AreEqual(true, entities[0].IsUsed); AssertUsingEntities(); AssertSecondLevelUsedEntities(); //Sub entities Assert.AreEqual(1, entities.Length); Assert.AreEqual("data", entities[0].Computer.Data); Assert.AreEqual(admin.Id, entities[0].Computer.Admin.Id); Assert.AreEqual("data", entities[0].Description.Data); Assert.AreEqual("data", entities[0].Things[0].Data); Assert.AreEqual(admin.Id, entities[0].Things[0].Admin.Id); Assert.AreEqual(entities[0].Id, entities[0].Things[0].Manager.Id); Assert.AreEqual("data", entities[0].Things[1].Data); Assert.AreEqual(admin.Id, entities[0].Things[1].Admin.Id); Assert.AreEqual(entities[0].Id, entities[0].Things[1].Manager.Id); //Main entity Assert.AreEqual("data", entities[0].Data); Assert.AreEqual(car1.Id, entities[0].Car.Id); Assert.AreEqual(director.Id, entities[0].Director.Id); Assert.AreEqual(office1.Id, entities[0].Office.Id); //First level used entities Assert.AreEqual(office1.Id, entities[0].Office.Id); Assert.AreEqual("data", entities[0].Office.Data); Assert.AreEqual(admin.Id, entities[0].Car.Admin.Id); Assert.AreEqual(car1.Id, entities[0].Car.Id); Assert.AreEqual("data", entities[0].Car.Data); Assert.AreEqual(admin.Id, entities[0].Projects[0].Admin.Id); Assert.AreEqual(project1.Id, entities[0].Projects[0].Id); Assert.AreEqual("data", entities[0].Projects[0].Data); Assert.AreEqual(manager.Id, entities[0].Projects[0].Manager.Id); //Assert.AreEqual(admin.Id, entities[0].Projects[1].AdminId); //Assert.AreEqual(project2.Id, entities[0].Projects[1].Id); //Assert.AreEqual(initializingDate, entities[0].Projects[1].CreatedOn); //Assert.AreEqual(initializingDate, entities[0].Projects[1].LastUpdateOn); //Assert.AreEqual("data", entities[0].Projects[1].Data); //Assert.AreEqual(false, entities[0].Projects[1].IsDeleted); //Assert.AreEqual(manager.Id, entities[0].Projects[1].ManagerId); //Using entities Assert.AreEqual("data", entities[0].ManagerTrackers[0].Data); Assert.AreEqual(manager.Id, entities[0].ManagerTrackers[0].Manager.Id); //Get result }
public void Get_WithUsingEntities_IsUsedIsTrue() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); var manager = new Manager() { Director = director, ManagerTrackers = new List<ManagerTracker>() { new ManagerTracker() }, Office = office1, Computer = new Computer() { Data = "data", Admin = admin }, Things = new List<Thing>() { new Thing() { Id = 1, Admin = admin, Data = "data" }, new Thing() { Id = 2, Admin = admin, Data = "data" } }, Description = new Description() { Data = "data" }, Data = "data", Car = car1, Projects = new List<Project>() { project1, //project2 } }; repository.Add(new AddOperationParameters<Manager>() { Entity = manager, OperationDateTime = initializingDate }); //Attach using entities var context = new EFContext(); context.Directors.Attach(director); context.Managers.Attach(manager); director.Managers = new List<Manager>(); director.Managers.Add(manager); context.ManagerTrackers.Add(new ManagerTracker() { Manager = manager, Data = "data" }); context.SaveChanges(); //Act var entities = repository.Get(new GetOperationParameters() { LoadSubEntities = true, LoadUsedEntities = true, LoadUsingEntities = true, }); //Assert Assert.AreEqual(true, entities[0].IsUsed); }
public void GetTotalCount_EntitiesExist_ReturnsEntitiesCount() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); var addingDate = DateTime.UtcNow; var manager1 = new Manager() { Director = director, ManagerTrackers = new List<ManagerTracker>() { new ManagerTracker() }, Office = office1, Computer = new Computer() { Data = "data", Admin = admin }, Things = new List<Thing>() { new Thing() { Id = 1, Admin = admin, Data = "data" }, new Thing() { Id = 2, Admin = admin, Data = "data" } }, Description = new Description() { Data = "data" }, Data = "data", Car = car1, Projects = new List<Project>() { project1 } }; var manager2 = new Manager() { Director = director, ManagerTrackers = new List<ManagerTracker>() { new ManagerTracker() }, Office = office2, Computer = new Computer() { Data = "data", Admin = admin }, Things = new List<Thing>() { new Thing() { Id = 1, Admin = admin, Data = "data" }, new Thing() { Id = 2, Admin = admin, Data = "data" } }, Description = new Description() { Data = "data" }, Data = "data", Car = car2, Projects = new List<Project>() { project2 } }; repository.Add(new AddOperationParameters<Manager>() { Entity = manager1, OperationDateTime = addingDate }); repository.Add(new AddOperationParameters<Manager>() { Entity = manager2, OperationDateTime = addingDate }); repository.Delete(new DeleteOperationParameters() { OperationDateTime = DateTime.UtcNow, PrimaryKeys = new object[] { manager2.Id } }); //Act var result = repository.GetTotalCount(new OperationParameters()); //Assert Assert.AreEqual(1, result); }
public void Delete_WithAllSubEntitiesAndAllUsedEntities_Succeeds() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); var addingDate = DateTime.UtcNow; var manager = new Manager() { Director = director, ManagerTrackers = new List<ManagerTracker>() { new ManagerTracker() }, Office = office1, Computer = new Computer() { Data = "data", Admin = admin }, Things = new List<Thing>() { new Thing() { Id = 1, Admin = admin, Data = "data" }, new Thing() { Id = 2, Admin = admin, Data = "data" } }, Description = new Description() { Data = "data" }, Data = "data", Car = car1, Projects = new List<Project>() { project1, project2 } }; repository.Add(new AddOperationParameters<Manager>() { Entity = manager, OperationDateTime = addingDate }); //Act var deletingDate = DateTime.UtcNow; repository.Delete(new DeleteOperationParameters() { PrimaryKeys = new object[] { manager.Id }, OperationDateTime = deletingDate }); //Assert var context = new EFContext(); var managers = context.Managers.ToArray(); var things = context.Things.ToArray(); AssertUsingEntities(); AssertSecondLevelUsedEntities(); //Sub entities AssertComputers(addingDate, deletingDate, "data", true); AssertDescriptions(addingDate, deletingDate, "data", true); Assert.AreEqual(0, things.Length); //Main entity Assert.AreEqual(0, managers.Length); //First level used entities AssertOffices(); AssertCars(); AssertProjects(null, null); }
public void Delete_WithRequiredSubEntitiesAndRequiredUsedEntities_Succeeds() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); var addingDate = DateTime.UtcNow; var manager = new Manager() { Director = director, ManagerTrackers = new List<ManagerTracker>() { new ManagerTracker() }, Office = office1, Computer = new Computer() { Data = "data", Admin = admin }, Data = "data" }; repository.Add(new AddOperationParameters<Manager>() { Entity = manager, OperationDateTime = addingDate }); //Act var deletingDate = DateTime.UtcNow; repository.Delete(new DeleteOperationParameters() { PrimaryKeys = new object[] { manager.Id }, OperationDateTime = deletingDate }); //Assert var context = new EFContext(); var managers = context.Managers.ToArray(); var computers = context.Computers.ToArray(); AssertUsingEntities(); AssertSecondLevelUsedEntities(); //Sub entities AssertComputers(addingDate, deletingDate, "data", true); //Main entity Assert.AreEqual(0, managers.Length); //First level used entities AssertOffices(); }
public void Add_WithRequiredSubEntitiesAndRequiredUsedEntities_Succeeds() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); var addingDate = DateTime.UtcNow; var manager = new Manager() { Director = director, ManagerTrackers = new List<ManagerTracker>() { new ManagerTracker() }, Office = office1, Computer = new Computer() { Data = "data", Admin = admin }, Data = "data" }; //Act repository.Add(new AddOperationParameters<Manager>() { Entity = manager, OperationDateTime = addingDate }); //Assert var context = new EFContext(); var managers = context.Managers .Include(ReflectionHelper.GetPropertyName<Manager, Car>(e => e.Car)) .Include(ReflectionHelper.GetPropertyName<Manager, Computer>(e => e.Computer)) .Include(ReflectionHelper.GetPropertyName<Manager, Description>(e => e.Description)) .Include(ReflectionHelper.GetPropertyName<Manager, Director>(e => e.Director)) .Include(ReflectionHelper.GetPropertyName<Manager, Office>(e => e.Office)) .ToArray(); var computers = context.Computers.ToArray(); AssertUsingEntities(); AssertSecondLevelUsedEntities(); //Sub entities AssertComputers(addingDate, addingDate, "data", false); //Main entity Assert.AreEqual(1, managers.Length); Assert.AreEqual("data", managers[0].Data); Assert.AreEqual(null, managers[0].Car); Assert.AreEqual(computers[0].Id, managers[0].Computer.Id); Assert.AreEqual(null, managers[0].Description); Assert.AreEqual(null, managers[0].Director); Assert.AreEqual(office1.Id, managers[0].Office.Id); //First level used entities AssertOffices(); }
public void Add_WithAllSubEntitiesAndAllUsedEntities_Succeeds() { //Arrange var repository = new EFRepositoryTester(); repository.Initialize(); var addingDate = DateTime.UtcNow; var manager = new Manager() { Director = director, ManagerTrackers = new List<ManagerTracker>() { new ManagerTracker() }, Office = office1, Computer = new Computer() { Data = "data", Admin = admin }, Things = new List<Thing>() { new Thing() { Id = 1, Admin = admin, Data = "data" }, new Thing() { Id = 2, Admin = admin, Data = "data" } }, Description = new Description() { Data = "data" }, Data = "data", Car = car1, Projects = new List<Project>() { project1, project2 } }; //Act repository.Add(new AddOperationParameters<Manager>() { Entity = manager, OperationDateTime = addingDate }); //Assert var context = new EFContext(); var managers = context.Managers .Include(ReflectionHelper.GetPropertyName<Manager, Car>(e => e.Car)) .Include(ReflectionHelper.GetPropertyName<Manager, Computer>(e => e.Computer)) .Include(ReflectionHelper.GetPropertyName<Manager, Description>(e => e.Description)) .Include(ReflectionHelper.GetPropertyName<Manager, Director>(e => e.Director)) .Include(ReflectionHelper.GetPropertyName<Manager, Office>(e => e.Office)) .ToArray(); var computers = context.Computers.ToArray(); var things = context.Things .Include(ReflectionHelper.GetPropertyName<Thing, Admin>(e => e.Admin)) .Include(ReflectionHelper.GetPropertyName<Thing, Manager>(e => e.Manager)) .ToArray(); var descriptions = context.Descriptions.ToArray(); AssertUsingEntities(); AssertSecondLevelUsedEntities(); //Sub entities AssertComputers(addingDate, addingDate, "data", false); AssertDescriptions(addingDate, addingDate, "data", false); Assert.AreEqual(2, things.Length); AssertThing(things[0], addingDate, addingDate, "data", managers[0].Id); AssertThing(things[1], addingDate, addingDate, "data", managers[0].Id); //Main entity Assert.AreEqual(1, managers.Length); Assert.AreEqual("data", managers[0].Data); Assert.AreEqual(car1.Id, managers[0].Car.Id); Assert.AreEqual(computers[0].Id, managers[0].Computer.Id); Assert.AreEqual(descriptions[0].Id, managers[0].Description.Id); Assert.AreEqual(null, managers[0].Director); Assert.AreEqual(office1.Id, managers[0].Office.Id); //First level used entities AssertOffices(); AssertCars(); AssertProjects(manager.Id, manager.Id); }