public CostCentreEntity Create(CostCentreEntity entity)
{
using (IDatabaseProvider provider = ProviderFactory.GetProvider(_connectionStringName))
{
return provider.Insert<CostCentreEntity>(entity);
}
}
internal static List<ItemHoursEntity> GetItemHoursEntriesForInsert(HourTypeEntity hourType, CostCentreEntity costCentre)
{
List<ItemHoursEntity> entities = new List<ItemHoursEntity>();
entities.Add(GetItemHoursEntryForInsert(hourType, costCentre));
ItemHoursEntity entity = GetItemHoursEntryForInsert(hourType, costCentre);
entity.OrderNumber = 1111;
entities.Add(entity);
return entities;
}
public static CostCentreEntity GetCostCentreForInsert()
{
CostCentreEntity entity = new CostCentreEntity()
{
LookupCode = "TCCC",
Code = "89",
Description = "Test Cost Centre",
DeletedDate = DateTime.MinValue
};
return entity;
}
public CostCentreEntity Update(CostCentreEntity entity)
{
using (IDatabaseProvider provider = ProviderFactory.GetProvider(_connectionStringName))
{
CostCentreEntity entityToUpdate = Read(entity.Id);
if (entityToUpdate == null)
throw new DataAccessException("Address not found"); // This should not happen seeing that validation should check.
entityToUpdate = UpdateProperties(entity, entityToUpdate);
provider.Update<CostCentreEntity>(entityToUpdate);
return entityToUpdate;
}
}
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 static ItemHoursEntity GetItemHoursEntryForInsert(HourTypeEntity hourType, CostCentreEntity costCentre)
{
ItemHoursEntity entity = new ItemHoursEntity()
{
HourTypeId = hourType.Id,
CostCentreId = costCentre.Id,
OrderNumber = 1234,
RoomNumber = 67,
ItemNumber = 5678,
ParentItemNumber = 8765,
PersonNumber = 123456789,
Description = "Work on Monday",
Date = DateTime.UtcNow,
Deleted = true,
DeletedDate = DateTime.MinValue
};
return entity;
}
public CostCentreEntity Delete(CostCentreEntity entity)
{
entity.DeletedDate = DateTime.UtcNow;
return Update(entity);
}
private CostCentreEntity UpdateProperties(CostCentreEntity entity, CostCentreEntity entityToUpdate)
{
entityToUpdate.Code = entity.Code;
entityToUpdate.LookupCode = entity.LookupCode;
entityToUpdate.Description = entity.Description;
entityToUpdate.DeletedDate = entity.DeletedDate;
return entityToUpdate;
}
private CostCentre TranslateToCostCentreResponse(CostCentreEntity entity)
{
return entity.TranslateTo<CostCentre>();
}
public static RoomHoursEntity GetRoomHoursEntryForInsert(HourTypeEntity hourType, CostCentreEntity costCentre)
{
RoomHoursEntity entity = new RoomHoursEntity()
{
HourTypeId = hourType.Id,
CostCentreId = costCentre.Id,
ConceptNumber = 9999,
OrderNumber = 1234,
RoomNumber = 67,
PersonNumber = 123456789,
Description = "Work on Monday",
DeliveryDate = DateTime.UtcNow,
Deleted = true,
DeletedDate = DateTime.MinValue
};
return entity;
}