Class GetEquipmentType

java.lang.Object
org.deltava.dao.DAO
org.deltava.dao.GetEquipmentType
public class GetEquipmentType extends DAO
A Data Access Object to retrieve equipment type profiles.
Since:
1.0
Version:
9.0
Author:
Luke

  • Constructor Details

    • GetEquipmentType

      public GetEquipmentType(Connection c)
      Initializes the DAO with a given JDBC connection.
      Parameters:
      c - the JDBC Connection

  • Method Details

    • get

      public EquipmentType get(String eqType) throws DAOException
      Returns a particular Equipment Program profile. If multiple airlines have the same equipment program name, then the results are undefined.
      Parameters:
      eqType - the Equipment Type to return
      Returns:
      the Equipment Type profile or null if not found
      Throws:
      DAOException - if a JDBC error occurs

    • get

      public EquipmentType get(String eqType, String dbName) throws DAOException
      Returns a particular Equipment Program profile from a specific database.
      Parameters:
      eqType - the Equipment Type to return
      dbName - the database name
      Returns:
      the Equipment Type profile or null if not found
      Throws:
      DAOException - if a JDBC error occurs

    • getDefault

      public String getDefault(String dbName) throws DAOException
      Returns the default equipment type name for an Airline.
      Parameters:
      dbName - the airline's database name
      Returns:
      the EquipmentType
      Throws:
      DAOException - if a JDBC error occurs

    • getByStage

      public Collection<EquipmentType> getByStage(int stage, String dbName) throws DAOException
      Returns all the Equipment Types in a particular stage.
      Parameters:
      stage - the stage number
      dbName - the database name
      Returns:
      a List of EquipmentTypes
      Throws:
      DAOException - if a JDBC error occurs

    • getAvailable

      public Collection<EquipmentType> getAvailable(String aCode) throws DAOException
      Returns all equipment programs a Pilot in a particular airline can get ratings in.
      Parameters:
      aCode - the Airline code
      Returns:
      a Collection of EquipmentType beans
      Throws:
      DAOException - if a JDBC error occurs

    • getActive

      public Collection<EquipmentType> getActive(String dbName) throws DAOException
      Returns all active Equipment Programs.
      Parameters:
      dbName - the database name
      Returns:
      a List of EquipmentTypes
      Throws:
      DAOException - if a JDBC error occurs
      See Also:

    • getActive

      public Collection<EquipmentType> getActive() throws DAOException
      Returns all active Equipment Programs in the current airline.
      Returns:
      a List of EquipmentTypes
      Throws:
      DAOException - if a JDBC error occurs
      See Also:

    • getAll

      public List<EquipmentType> getAll() throws DAOException
      Returns all Equipment Types.
      Returns:
      a List of EquipmentTypes
      Throws:
      DAOException - if a JDBC error occurs

    • getPrimaryTypes

      public Collection<String> getPrimaryTypes(String dbName, String eqType) throws DAOException
      Returns the Equipment Programs for whom a flight in a given aircraft counts for promotion.
      Parameters:
      dbName - the Database name
      eqType - the Aircraft type
      Returns:
      a Collection of equipment program names
      Throws:
      DAOException - if a JDBC error occurs

    • getPilotsWithMissingRatings

      public Collection<Integer> getPilotsWithMissingRatings(EquipmentType eq) throws DAOException
      Returns the database IDs for all Pilots missing an assigned rating in a particular Equipment type program.
      Parameters:
      eq - the EquipmentType bean
      Returns:
      a Collection of database IDs
      Throws:
      DAOException - if a JDBC error occurs