public  ArrayList<Customer> AllCustomersInFranchise( int FranID)
             throws UnauthorizedUserException, BadConnectionException, DoubleEntryException
    {
        PreparedStatement statment = null;
        ResultSet results = null;
        
        ArrayList<Customer> BPArrayList = new ArrayList<Customer>();
        
        try {
            statment = con.prepareStatement(qs.get_fran_customer);
            statment.setInt(1, FranID);
            results = statment.executeQuery();
            
            while (results.next()) {
                Customer temp = new Customer();
                
                temp.setAddress(results.getString("Address"));
                temp.setCity(results.getString("City"));
                temp.setCustomerID(results.getInt("CustomerID"));
                temp.setEmail(results.getString("Email"));
                temp.setFirstName(results.getString("Fname"));
                temp.setLastName(results.getString("Surname"));
                temp.setMemberID(results.getString("MemberID"));
                temp.setPhone(results.getString("Phone"));
                temp.setReservationCount(results.getInt("ReservationCount"));
                temp.setState(results.getString("State"));
                temp.setZip(results.getInt("Zip"));

                BPArrayList.add(temp);
           }
        }catch(SQLException sqlE) {
                if(sqlE.getErrorCode() == 1142)
                    throw(new UnauthorizedUserException("AccessDenied"));
                else 
                    throw(new BadConnectionException("BadConnection"));
        }finally {
            try {
                if (results != null) results.close();
            }catch (Exception e) {};
            try {
                if (statment != null) statment.close();
            }catch (Exception e) {};
        }
        
        return BPArrayList;
              
    }