Class GetAcademyCalendar

java.lang.Object
org.deltava.dao.DAO
org.deltava.dao.GetAcademyCalendar
public class GetAcademyCalendar extends DAO
A Data Access Object to load Flight Academy calendars.
Since:
1.0
Version:
9.0
Author:
Luke

  • Constructor Details

    • GetAcademyCalendar

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

  • Method Details

    • getSession

      public InstructionSession getSession(int id) throws DAOException
      Returns a specific Flight Academy Instruction Session record.
      Parameters:
      id - the Session database ID
      Returns:
      an InstructionSession bean, or null if not found
      Throws:
      DAOException - if a JDBC error occurs

    • getBusyCalendar

      public Collection<InstructionBusy> getBusyCalendar(int insID, DateRange dr) throws DAOException
      Returns Instructor busy time entries for the Calendar.
      Parameters:
      insID - the database ID of the instructor, or zero if all selected
      dr - the DateRange
      Returns:
      a Collection of InstructionBusy beans
      Throws:
      DAOException - if a JDBC error occurs

    • getBusyTime

      public Collection<InstructionBusy> getBusyTime(int instructorID) throws DAOException
      Returns all busy time for a particular Instructor.
      Parameters:
      instructorID - the Instructor database ID
      Returns:
      a Collection of InstructionBusy beans
      Throws:
      DAOException - if a JDBC error occurs

    • getFlight

      public InstructionFlight getFlight(int id) throws DAOException
      Returns a specific Flight Academy Instruction flight record.
      Parameters:
      id - the flight database ID
      Returns:
      an InstructionFlight bean, or null if not found
      Throws:
      DAOException - if a JDBC error occurs

    • getFlights

      public Collection<InstructionFlight> getFlights(int courseID) throws DAOException
      Returns all Flight Academy Instruction log entries.
      Parameters:
      courseID - the database ID of the Course
      Returns:
      a Collection of InstructionFlight beans
      Throws:
      DAOException - if a JDBC error occurs

    • getSessions

      public Collection<InstructionSession> getSessions(int courseID) throws DAOException
      Returns all Instruction Sessions for a particular Flight Academy Course.
      Parameters:
      courseID - the database ID of the Course
      Returns:
      a Collection of InstructionSession beans
      Throws:
      DAOException - if a JDBC error occurs

    • getFlightCalendar

      public Collection<InstructionFlight> getFlightCalendar(int pilotID, DateRange dr) throws DAOException
      Loads the Flight Academy Instruction Flight calendar.
      Parameters:
      pilotID - the database ID of the instructor/student pilot, or zero if all selected
      dr - the DateRange
      Returns:
      a Collection of InstructionFlight beans
      Throws:
      DAOException - if a JDBC error occurs

    • getSessionCalendar

      public Collection<InstructionSession> getSessionCalendar(int pilotID, DateRange dr) throws DAOException
      Loads the Flight Academy Instruction Calendar.
      Parameters:
      pilotID - the Pilot ID to display, or 0 if none
      dr - the DateRange
      Returns:
      a Collection of InstructionSession beans
      Throws:
      DAOException - if a JDBC error occurs