public async Task UpdateOrganisationAddresses(OrganisationAddresses organisationAddresses)
{
using (var connection = _dbConnectionHelper.GetDatabaseConnection())
{
await connection.ExecuteAsync(
@"UPDATE OrganisationAddresses SET AddressType = @AddressType, AddressLine1 = @AddressLine1, AddressLine2 = @AddressLine2, AddressLine3 = @AddressLine3, City = @City,Postcode = @Postcode WHERE OrganisationId = @OrganisationId",
new { organisationAddresses.AddressType, organisationAddresses.AddressLine1, organisationAddresses.AddressLine2, organisationAddresses.AddressLine3, organisationAddresses.City, organisationAddresses.Postcode, organisationAddresses.OrganisationId });
}
}
public async Task <int> CreateOrganisationAddresses(OrganisationAddresses organisationAddresses)
{
using (var connection = _dbConnectionHelper.GetDatabaseConnection())
{
organisationAddresses.Id = await connection.QuerySingleAsync <int>(@"INSERT INTO OrganisationAddresses (OrganisationId, AddressType, AddressLine1, AddressLine2, AddressLine3, City, Postcode)" +
"OUTPUT INSERTED.[Id] " + "VALUES (@OrganisationId, @AddressType, @AddressLine1, @AddressLine2, @AddressLine3, @City, @Postcode)",
new { organisationAddresses.OrganisationId, organisationAddresses.AddressType, organisationAddresses.AddressLine1, organisationAddresses.AddressLine2,
organisationAddresses.AddressLine3, organisationAddresses.City, organisationAddresses.Postcode });
return(organisationAddresses.Id);
}
}
private async Task <OrganisationAddresses> CreateOrganisationAddresses(Organisation request)
{
var organisationAddresses = new OrganisationAddresses
{
OrganisationId = request.Id,
AddressType = (int)OrganisationAddressType.LegalAddress,
AddressLine1 = request.OrganisationDetails.Address1,
AddressLine2 = request.OrganisationDetails.Address2,
AddressLine3 = request.OrganisationDetails.Address3,
City = request.OrganisationDetails.City,
Postcode = request.OrganisationDetails.Postcode
};
organisationAddresses.Id = await _organisationAddressesRepository.CreateOrganisationAddresses(organisationAddresses);
return(organisationAddresses);
}
public OrganisationAddress GetLatestAddress(AddressStatuses status = AddressStatuses.Active)
{
var addressStatus = OrganisationAddresses.SelectMany(a =>
a.AddressStatuses.Where(s => s.Status == status))
.OrderByDescending(s => s.StatusDate)
.FirstOrDefault();
if (addressStatus != null && addressStatus.Address.Status == status)
{
return(addressStatus.Address);
}
if (LatestAddress != null && LatestAddress.Status == status)
{
return(LatestAddress);
}
return(null);
}
public OrganisationAddress GetLatestAddress()
{
return(OrganisationAddresses
.OrderByDescending(add => add.Created)
.FirstOrDefault());
}
