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
});
}
}