public void TearDownRelatedData() { RoomHoursRepository repository = new RoomHoursRepository(ConfigSettings.MySqlDatabaseConnectionName); repository.ClearCollection(); CostCentreRepository costCentreRepository = new CostCentreRepository(ConfigSettings.MySqlDatabaseConnectionName); costCentreRepository.ClearCollection(); HourTypeRepository hourTypeRepository = new HourTypeRepository(ConfigSettings.MySqlDatabaseConnectionName); hourTypeRepository.ClearCollection(); }
public void ShouldCreateHourType() { // Arrange HourTypeRepository repository = new HourTypeRepository(ConfigSettings.MySqlDatabaseConnectionName); HourTypeEntity entity = HoursData.GetHourTypeForInsert(); repository.ClearCollection(); // Act entity = repository.Create(entity); // Assert Assert.IsNotNull(entity); Assert.AreNotEqual(0, entity.Id); }
public void ShouldCreateHourTypes() { // Arrange HourTypeRepository repository = new HourTypeRepository(ConfigSettings.MySqlDatabaseConnectionName); List<HourTypeEntity> entities = HoursData.GetHourTypesForInsert(); repository.ClearCollection(); // Act entities = repository.Create(entities); // Assert Assert.IsNotNull(entities); Assert.AreEqual(2, entities.Count); }
public void SetUpRelatedData() { RoomHoursRepository repository = new RoomHoursRepository(ConfigSettings.MySqlDatabaseConnectionName); repository.ClearCollection(); CostCentreRepository costCentreRepository = new CostCentreRepository(ConfigSettings.MySqlDatabaseConnectionName); CostCentreEntity costCentreEntity = HoursData.GetCostCentreForInsert(); costCentreRepository.ClearCollection(); _costCentre = costCentreRepository.Create(costCentreEntity); HourTypeRepository hourTypeRepository = new HourTypeRepository(ConfigSettings.MySqlDatabaseConnectionName); HourTypeEntity hourTypeEntity = HoursData.GetHourTypeForInsert(); hourTypeRepository.ClearCollection(); _hourType = hourTypeRepository.Create(hourTypeEntity); }
public void ShouldReadHourTypeWithId() { // Arrange HourTypeRepository repository = new HourTypeRepository(ConfigSettings.MySqlDatabaseConnectionName); HourTypeEntity entity = HoursData.GetHourTypeForInsert(); repository.ClearCollection(); // Act entity = repository.Create(entity); // Act var actual = repository.Read(entity.Id); // Assert Assert.AreEqual(entity.Description, actual.Description); }
public void ShouldUpdateHourType() { // Arrange HourTypeRepository repository = new HourTypeRepository(ConfigSettings.MySqlDatabaseConnectionName); HourTypeEntity entity = HoursData.GetHourTypeForInsert(); repository.ClearCollection(); entity = repository.Create(entity); entity.Description = "Unplanned"; // Act HourTypeEntity actual = repository.Update(entity); // Assert Assert.AreEqual(entity.Description, actual.Description); }
public void ShouldNotInsertDuplicateHourType() { // Arrange HourTypeRepository repository = new HourTypeRepository(ConfigSettings.MySqlDatabaseConnectionName); HourTypeEntity entity = HoursData.GetHourTypeForInsert(); repository.ClearCollection(); entity = repository.Create(entity); try { // Act entity = repository.Create(entity); Assert.Fail("This should not happen"); } catch (Exception ex) { // Arrange Assert.IsInstanceOf<MySqlException>(ex); } // Assert }
public void ShouldDeleteHourType() { // Arrange HourTypeRepository repository = new HourTypeRepository(ConfigSettings.MySqlDatabaseConnectionName); HourTypeEntity entity = HoursData.GetHourTypeForInsert(); repository.ClearCollection(); entity = repository.Create(entity); // Act HourTypeEntity actual = repository.Delete(entity); // Assert Assert.AreNotEqual(actual.DeletedDate, DateTime.MinValue); }