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