public ProductProfileVO getProductProfile(ProductVO productVO,String productCategory) {
        ProductProfileVO productProfileVO = new ProductProfileVO();
        List<VendorProductVO> vendors=null;
        String imagePath=null;
        productProfileVO = productProfileDAO.getOfferCategoryCountForProduct(productVO.getProductId(),productCategory);
        productProfileVO.setDonationCount(formatRep(Integer.parseInt(productProfileVO.getDonationCount())));
        productProfileVO.setRecycleCount(formatRep(Integer.parseInt(productProfileVO.getRecycleCount())));
        productProfileVO.setTradeInCount(formatRep(Integer.parseInt(productProfileVO.getTradeInCount())));
        if(productCategory.equals("2")){
            vendors=new ArrayList<VendorProductVO>();
            vendors = vendorDAO.getEquivalentVendorPhones(Integer.parseInt(productVO.getProductId()));
            imagePath="phones/models/";
        }else if(productCategory.equals("5")){
            vendors=new ArrayList<VendorProductVO>();
            vendors = vendorDAO.getEquivalentVendorMp3(Integer.parseInt(productVO.getProductId()));
            imagePath="mp3players/models/";
        }

        List<ServiceVO> services = new ArrayList<ServiceVO>();
        productProfileVO.setTradeIn("recycling");
        if(vendors.size() > 0){
            for(VendorProductVO vendorProductVO : vendors){
                EcoSquidPhoneVO ecoSquidPhoneVO = new EcoSquidPhoneVO();
                ecoSquidPhoneVO.setVendorId(vendorProductVO.getVendorId());
                ecoSquidPhoneVO.setVendorPhoneId(vendorProductVO.getVendorProductId());
                //if(productCategory.equals("2")){
                ecoSquidPhoneVO.setCondition(Condition.NEW_IN_BOX);
            /*  }else if(productCategory.equals("5")){
                    ecoSquidPhoneVO.setMp3Condition(com.ecosquid.vo.EcoSquidPhoneVO.MP3Condition.PERFECT);
                }
            */  ServiceVO serviceVO = new ServiceVO();
                VendorVO vendorVO = vendorDAO.getVendor(vendorProductVO.getVendorId());
                VendorOffersService vendorOffersService = serviceFactory.getService(vendorProductVO.getVendorId());
                if(productCategory.equals("2")){
                vendorOffersService.getPhoneVO(dataSource, ecoSquidPhoneVO);
                }else if(productCategory.equals("5")){
                    vendorOffersService.getMP3VO(ecoSquidPhoneVO);
                }
                serviceVO.setServiceId(vendorVO.getVendorId());
                serviceVO.setServiceName(vendorVO.getDisplayName());
                serviceVO.setServicesOffered("trade-in");
                services.add(serviceVO);
                if(!ecoSquidPhoneVO.isRecycleOnly()){
                    productProfileVO.setTradeIn("trade-in");
                }
            }
        }
        if(productProfileVO.getTradeIn().equals("recycling")){
            services = productProfileDAO.getRecycleServices(Integer.parseInt(productCategory));
        }
        productProfileVO.setServices(services);
        List<ProductVO> relatedProducts = productProfileDAO.getRelatedProducts(productVO.getManufacturerId(),productVO.getProductName(),productCategory);
        for(ProductVO relatedProduct : relatedProducts){
            String manufacturer = productVO.getManufacturerName().replace(" ", "_");
            String model = relatedProduct.getProductName().replace(" ", "_");

            String offersLink = manufacturer + "/" + model;
            relatedProduct.setInfoLink(offersLink);

            if (relatedProduct.getHasImage() > 0) {
                relatedProduct.setImageUrl(imagePath + relatedProduct.getProductId() + ".jpg");
            } else {
                relatedProduct.setImageUrl("products/default.jpg");
            }
        }
        productProfileVO.setRelatedProducts(relatedProducts);
        DidYouKnowVO didYouKnowVO = didYouKnowDAO.getDidYouKnowList(Integer.parseInt(productCategory));
        ProductCategoryVO categoryVO = productDAO.getProductCategoryDetails(Integer.parseInt(productCategory));
        categoryVO.setDidYouKnowVO(didYouKnowVO);
        productVO.setCategoryVO(categoryVO);
        return productProfileVO;
    }