public OccupationNameEntity Create(OccupationNameEntity entity)
{
using (IDatabaseProvider provider = ProviderFactory.GetProvider(_connectionStringName))
{
return provider.Insert<OccupationNameEntity>(entity);
}
}
public static OccupationNameEntity GetItemForInsert()
{
OccupationNameEntity entity = new OccupationNameEntity()
{
Description = "Tekenaar",
DeletedDate = DateTime.MinValue
};
return entity;
}
public OccupationNameEntity Update(OccupationNameEntity entity)
{
using (IDatabaseProvider provider = ProviderFactory.GetProvider(_connectionStringName))
{
OccupationNameEntity entityToUpdate = Read(entity.Id);
if (entityToUpdate == null)
throw new DataAccessException("Item not found"); // This should not happen seeing that validation should check.
entityToUpdate = UpdateProperties(entity, entityToUpdate);
provider.Update<OccupationNameEntity>(entityToUpdate);
return entityToUpdate;
}
}
public OccupationNameEntity Delete(OccupationNameEntity entity)
{
entity.DeletedDate = DateTime.UtcNow;
return Update(entity);
}
private OccupationNameEntity UpdateProperties(OccupationNameEntity entity, OccupationNameEntity entityToUpdate)
{
entityToUpdate.Description = entity.Description;
entityToUpdate.DeletedDate = entity.DeletedDate;
return entityToUpdate;
}
private static void CreateOccupationNames()
{
OccupationNameRepository repository = new OccupationNameRepository(ConfigSettings.MySqlDatabaseConnectionName);
OccupationNameEntity entity = new OccupationNameEntity()
{
Description = "Tekenaar",
DeletedDate = DateTime.MinValue
};
OccupationNameEntity mEntity = new OccupationNameEntity()
{
Description = "Ingeneur",
DeletedDate = DateTime.MinValue
};
entity = repository.Create(entity);
mEntity = repository.Create(mEntity);
_occupationNameEntities.Add(entity);
_occupationNameEntities.Add(mEntity);
}
