public void ShouldReadCostCentreWithId()
		{
			// Arrange
			CostCentreRepository repository = new CostCentreRepository(ConfigSettings.MySqlDatabaseConnectionName);
			CostCentreEntity entity = HoursData.GetCostCentreForInsert();
			repository.ClearCollection();

			// Act
			entity = repository.Create(entity);

			// Act
			var actual = repository.Read(entity.Id);

			// Assert
			Assert.AreEqual(entity.Code, actual.Code);
		}
		public static void CreateCostCentres()
		{
			CostCentreRepository repository = new CostCentreRepository(ConfigSettings.HoursDatabaseConnectionName);
			var costCentres = repository.Read();
			if (!CheckCostCentre(costCentres, "ENGI"))
			{
				repository.Create(new CostCentreEntity
				{
					LookupCode = "ENGI",
					Code = "01",
					Description = "Engineering",
					DeletedDate = DateTime.MinValue
				});
			}
			if (!CheckCostCentre(costCentres, "PROD"))
			{
				repository.Create(new CostCentreEntity
				{
					LookupCode = "PROD",
					Code = "02",
					Description = "Werkplaats",
					DeletedDate = DateTime.MinValue
				});
			}
			if (!CheckCostCentre(costCentres, "PNTG"))
			{
				repository.Create(new CostCentreEntity
				{
					LookupCode = "PNTG",
					Code = "03",
					Description = "Spuiterij",
					DeletedDate = DateTime.MinValue
				});
			}
			if (!CheckCostCentre(costCentres, "ONBR"))
			{
				repository.Create(new CostCentreEntity
				{
					LookupCode = "ONBR",
					Code = "04",
					Description = "Boord",
					DeletedDate = DateTime.MinValue
				});
			}
		}