# Reference : Airport and City Coding Directory (LOID)

LOID is a table for airport and coding directory reference.

## :memo: Table of Contents
[ToC]

## LOID Design


## REST APIs for Airport and City Coding Directory resource

- GET /references/airport-and-city-coding-directory

    public Paged<AirportCityCodingDirectory> retrievePagedAirportAndCityCodingDirectory(
        @Valid AirportCityCodingDirectoryFilterTO filter, Page page){
        return service.retrievePagedAirportAndCityCodingDirectory(filter,page);
    }

- POST /references/airport-and-city-coding-directory

    public void createAirportAndCityCodingDirectory(
        @Valid @RequestBody AirportCityCodingDirectory airportCityCodingDirectory)
        throws EdgarException {
        service.createAirportAndCityCodingDirectory(airportCityCodingDirectory);
    }

- PUT /references/airport-and-city-coding-directory

    public void modifyAirportAndCityCodingDirectory(
        @Valid @RequestBody AirportCityCodingDirectory airportCityCodingDirectory)
        throws EdgarException {
        service.modifyAirportAndCityCodingDirectory(airportCityCodingDirectory);
    }

- DELETE /references/airport-and-city-coding-directory/{id}

    public void deleteAirportAndCityCodingDirectory(
        @PathVariable("id") @NotNull Integer airportAndCityCodingDirectoryIdentifier)
        throws EdgarException {
        service.deleteAirportAndCityCodingDirectory(airportAndCityCodingDirectoryIdentifier);
    }

## LOID Filter

- AirportCityCodingDirectoryFilterTO

public class AirportCityCodingDirectoryFilterTO {

private String cityCode;
private String city;
private String airportCode;
private String airport;
private String isoCountryCode;
private LocalDate endDate;
private List<String> sortBy;
}

## LOID Model
- AirportCityCodingDirectory

public class AirportCityCodingDirectory extends Entity {

/*
* locationId maps upon LOID.LOID
*/
private String locationId;

/*
* city maps upon LOID.CITY
*/
private String city;

/*
* stateCode maps upon LOID.STPC
*/
private String stateCode;

/*
* isoCountyCode maps upon LOID.ISCC
*/
private String isoCountryCode;

/*
* timeZone maps upon LOID.TMZO
*/
private String timeZone;

/*
* standardTimeVariation maps upon LOID.STVC
*/
private String standardTimeVariation;

/*
* airportCode maps upon LOID.APTC
*/
private String airportCode;

/*
* airportName maps upon LOID.APTN
*/
private String airportName;

/*
* numericCode maps upon LOID.NUCO
*/
private String numericCode;

/*
* countryCode maps upon LOID.ISOC
*/
private String countryCode;

/*
* iataZone maps upon LOID.IAZN
*/
private Integer iataZone;

/*
* iataSubZone maps upon LOID.IASZ_CODE
*/
private String iataSubzone;

/*
* typeOfLoid maps upon LOID.TYPE
*/
private String typeOfLoid;

/*
* endDate maps upon LOID.ENDA
*/
@NotNull
@JsonFormat(pattern = "dd/MM/yyyy")
private Date endDate;

private String sequenceNumber;
}

- Exception Translation to be added on front.

REFERENCE_LOID_EXISTS("error.exception.reference_loid_exists")