public static void CreateHourTypes() { HourTypeRepository repository = new HourTypeRepository(ConfigSettings.HoursDatabaseConnectionName); var hourTypes = repository.Read(); if (!CheckHourType(hourTypes, "BOOK")) { repository.Create(new HourTypeEntity { LookupCode = "BOOK", Description = "Geboekt", DeletedDate = DateTime.MinValue }); } if (!CheckHourType(hourTypes, "BUDG")) { repository.Create(new HourTypeEntity { LookupCode = "BUDG", Description = "Gebudgeteerd", DeletedDate = DateTime.MinValue }); } if (!CheckHourType(hourTypes, "PLAN")) { repository.Create(new HourTypeEntity { LookupCode = "PLAN", Description = "Gepland", DeletedDate = DateTime.MinValue }); } }
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 ShouldThrowArgumentNullExceptionOnConstructor() { // Act try { HourTypeRepository repository = new HourTypeRepository(null); Assert.Fail("This should not happen"); } catch (Exception ex) { // Arrange Assert.IsInstanceOf<ArgumentNullException>(ex); } }
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); }