public AddressEntity Create(AddressEntity entity)
{
using (IDatabaseProvider provider = ProviderFactory.GetProvider(_connectionStringName))
{
return provider.Insert<AddressEntity>(entity);
}
}
public AddressEntity Update(AddressEntity entity)
{
using (IDatabaseProvider provider = ProviderFactory.GetProvider(_connectionStringName))
{
AddressEntity 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<AddressEntity>(entityToUpdate);
return entityToUpdate;
}
}
public static AddressEntity GetItemForInsert()
{
AddressEntity entity = new AddressEntity()
{
AddressTypeId = ContactDetailsHelpers.CreateAddressType().Id,
EntityId = ContactDetailsHelpers.CreateEntity().Id,
Street = "Bonga",
StreetNumber = "6",
StreetNumberAddition = "F",
PostalCode = "3991TS",
City = "Houten",
CountryCode = "NL",
Preferred = true,
DeletedDate = DateTime.MinValue
};
return entity;
}
private AddressEntity UpdateProperties(AddressEntity entity, AddressEntity entityToUpdate)
{
entityToUpdate.AddressTypeId = entity.AddressTypeId;
entityToUpdate.EntityId = entity.EntityId;
entityToUpdate.Street = entity.Street;
entityToUpdate.StreetNumber = entity.StreetNumber;
entityToUpdate.StreetNumberAddition = entity.StreetNumberAddition;
entityToUpdate.PostalCode = entity.PostalCode;
entityToUpdate.City = entity.City;
entityToUpdate.CountryCode = entity.CountryCode;
entityToUpdate.Preferred = entity.Preferred;
entityToUpdate.DeletedDate = entity.DeletedDate;
return entityToUpdate;
}
public AddressEntity Delete(AddressEntity entity)
{
entity.DeletedDate = DateTime.UtcNow;
return Update(entity);
}
private static void CreateAddresses()
{
AddressRepository repository = new AddressRepository(ConfigSettings.MySqlDatabaseConnectionName);
AddressEntity entity = new AddressEntity()
{
AddressTypeId = _addressTypeEntities[0].Id,
EntityId = _entityEntities[0].Id,
Preferred = true,
Street = "De haag",
StreetNumber = "12",
StreetNumberAddition = "",
PostalCode = "3991TW",
City = "Houten",
CountryCode = "NL",
DeletedDate = DateTime.MinValue
};
AddressEntity mEntity = new AddressEntity()
{
AddressTypeId = _addressTypeEntities[1].Id,
EntityId = _entityEntities[1].Id,
Preferred = true,
Street = "De haagd",
StreetNumber = "122",
StreetNumberAddition = "d",
PostalCode = "3991RF",
City = "Utrecht",
CountryCode = "NL",
DeletedDate = DateTime.MinValue
};
entity = repository.Create(entity);
mEntity = repository.Create(mEntity);
_addressEntities.Add(entity);
_addressEntities.Add(mEntity);
}
