public  ArrayList<Membership> GetPromotionsData()
             throws UnauthorizedUserException, BadConnectionException, DoubleEntryException
    {
        /* Variable Section Start */
            /* Database and Query Preperation */
            PreparedStatement statment = null;
            ResultSet results = null;
            String statString = "SELECT * FROM `membership` ORDER BY MinAmount desc";

            /* Return Parameter */
            ArrayList<Membership> BPList = new ArrayList<Membership>();
        /* Variable Section Stop */
        
        
        /* TRY BLOCK START */
            
            try
            {
            /* Preparing Statment Section Start */                
                statment = con.prepareStatement(statString);
                //statment.setInt(1, FranID);
            /* Preparing Statment Section Stop */
            /* Query Section Start */
                results = statment.executeQuery();
            /* Query Section Stop */
            
            /* Metadata Section Start*/
                //ResultSetMetaData metaData = results.getMetaData();
            /* Metadata Section Start*/
                
            /* List Prepare Section Start */
                
                
                
                while (results.next())
                {
                    Membership temp = new Membership();
                    
                    //results.getBigDecimal("AMOUNT")
                    
                    temp.setDiscount(results.getString("Discount"));
                    temp.setMemberID(results.getString("MemberID"));
                    temp.setMinAmount(results.getString("MinAmount"));
                    
                    BPList.add(temp);
                }
            /* List Prepare Section Stop */
            }
            catch(SQLException sqlE)
            {
                if(sqlE.getErrorCode() == 1142)
                    throw(new UnauthorizedUserException("AccessDenied"));
                else if(sqlE.getErrorCode() == 1062)
                    throw(new DoubleEntryException("DoubleEntry"));
                else 
                    throw(new BadConnectionException("BadConnection"));
            }
            finally
            {
                try
                {
                    if (results != null) results.close();
                }
                catch (Exception e) {};
                try
                {
                    if (statment != null) statment.close();
                }
                catch (Exception e) {};
            }
        /* TRY BLOCK STOP*/
        
            
        /* Return to Buisness Section Start */ 
           
            
            
            return BPList;
        /* Return to Buisness Section Start */
        
        
        
    }