/**
     * Adds the given CPT codes to the given office visit
     *
     * @param cptCode
     * @param visitID
     * @return
     * @throws DBException
     */
    public long addProcedureToOfficeVisit (String cptCode, long visitID, String hcpid) throws DBException {
        Connection conn = null;
        PreparedStatement ps = null;
        try {
            conn = factory.getConnection();
            ps = conn.prepareStatement("INSERT INTO OVProcedure (CPTCode,VisitID,HCPID) VALUES (?,?,?)");
            ps.setString(1, cptCode);
            ps.setLong(2, visitID);
            ps.setString(3, hcpid);
            ps.executeUpdate();
            return DBUtil.getLastInsert(conn);
        } catch (SQLException e) {
            e.printStackTrace();
            throw new DBException(e);
        } finally {
            DBUtil.closeConnection(conn, ps);
        }
    }