public ArrayList<Employee> AllEmployeesInFranchise(int FranID)
            throws UnauthorizedUserException, BadConnectionException
    {
        PreparedStatement pStmnt = null;
        ArrayList<Employee> BPList = new ArrayList<Employee>();
    
        // Get the employee type through JClIO instance
        lio = JCGlIO.getInstance();
        try {
            if( "1".equals(lio.geteT())) {
                pStmnt = con.prepareStatement(qs.owner_view_emp);
            }else if("2".equals(lio.geteT())) {
                pStmnt = con.prepareStatement(qs.man_view_emp);
            }else
                throw (new UnauthorizedUserException("AccessDenied"));
           
            pStmnt.setInt(1, FranID);
        
            resultSet = pStmnt.executeQuery();
            while (resultSet.next())
            {
                Employee temp = new Employee();
                    
                temp.setAddress(resultSet.getString("Address"));
                temp.setCity(resultSet.getString("City"));
                temp.setEmail(resultSet.getString("Email"));
                temp.setEmpType(resultSet.getInt("EmpType"));
                temp.setFirstName(resultSet.getString("Fname"));
                temp.setFranchiseNumber(resultSet.getInt("FranchiseNumber"));
                temp.setLastName(resultSet.getString("Surname"));
                temp.setPhone(resultSet.getString("Phone"));
                temp.setState(resultSet.getString("State"));
                temp.setEmployeeID(resultSet.getInt("EmployeeID"));
                temp.setZip(resultSet.getInt("Zip"));
                    
                BPList.add(temp);
            }
        }catch(SQLException sqlE) {
            if(sqlE.getErrorCode() == 1142)
                throw(new UnauthorizedUserException("AccessDenied"));
            else 
                throw(new BadConnectionException("BadConnection"));
        }
        finally {
            try {
                if (resultSet != null) resultSet.close();
                if (pStmnt != null) pStmnt.close();
            }
                catch (Exception e) {};
        }
         
        return BPList;
        
 
    }