Class GetTransferRequest

java.lang.Object
org.deltava.dao.DAO
org.deltava.dao.GetTransferRequest
public class GetTransferRequest extends DAO
A Data Access Object to read Pilot Transfer requests.
Since:
1.0
Version:
9.0
Author:
Luke

  • Constructor Details

    • GetTransferRequest

      public GetTransferRequest(Connection c)
      Initializes the Data Access Object.
      Parameters:
      c - the JDBC connection to use

  • Method Details

    • get

      public TransferRequest get(int pilotID) throws DAOException
      Returns a Transfer Request for a particular Pilot.
      Parameters:
      pilotID - the Pilot's database ID
      Returns:
      a TransferRequest bean, or null if not found
      Throws:
      DAOException - if a JDBC error occurs

    • hasTransfer

      public boolean hasTransfer(int pilotID) throws DAOException
      Returns whether the Pilot has a pending transfer request at any airline.
      Parameters:
      pilotID - the Pilot ID
      Returns:
      TRUE if the pilot has a transfer request, otherwise FALSE
      Throws:
      DAOException - if a JDBC error occurs

    • getCount

      public int getCount(String eqType) throws DAOException
      Returns the number of pending Transfer Requests into a particular equipment program.
      Parameters:
      eqType - the Equipment program name, or null for all
      Returns:
      the number of Transfer Requests
      Throws:
      DAOException - if a JDBC error occurs

    • getByCheckRide

      public TransferRequest getByCheckRide(int checkRideID) throws DAOException
      Returns the Transfer Request associated with a paritcular Check Ride.
      Parameters:
      checkRideID - the Check Ride database ID
      Returns:
      a TransferRequest bean, or null if not found
      Throws:
      DAOException - if a JDBC error occurs

    • getAged

      public Collection<TransferRequest> getAged(int minAge) throws DAOException
      Returns all Transfer Requests older than a certain age.
      Parameters:
      minAge - the number of days
      Returns:
      a Collection of TransferRequest beans
      Throws:
      DAOException - if a JDBC error occurs

    • getAll

      public List<TransferRequest> getAll(String orderBy) throws DAOException
      Returns all Transfer Requests.
      Parameters:
      orderBy - the sort order
      Returns:
      a List of TransferRequest beans
      Throws:
      DAOException - if a JDBC error occurs

    • getByEQ

      public List<TransferRequest> getByEQ(String eqType, String orderBy) throws DAOException
      Returns all Transfer Requests for a particular Equipment program.
      Parameters:
      eqType - the Equipment program name
      orderBy - the sort order
      Returns:
      a List of TransferRequest beans
      Throws:
      DAOException - if a JDBC error occurs