Ejemplo n.º 1
0
        public static void ExtractingHtmlEbuyer(string html, string str)
        {
            positiveReviews.Clear();
            negativeReviews.Clear();
            var    webGet      = new HtmlWeb();
            var    doc         = webGet.Load(str);
            string title       = "";
            string price       = "";
            string imgUrl      = "";
            string description = "";
            double rating      = 0.0;

            try
            {
                title = doc.DocumentNode.SelectSingleNode("//h1[@class='product-title']").InnerText;
                if (title.Contains("EXDISPLAY"))
                {
                    title = title.Replace("EXDISPLAY ", "");
                    if (title.Contains("Laptop"))
                    {
                        title = title.Substring(0, title.IndexOf(@"Laptop") + 6);
                    }
                    else if (title.Contains("Tablet"))
                    {
                        title = title.Substring(0, title.IndexOf(@"Tablet") + 6);
                    }
                    else if (title.Contains("Ultrabook"))
                    {
                        title = title.Substring(0, title.IndexOf(@"Ultrabook") + 9);
                    }
                }

                try
                {
                    price = doc.DocumentNode.SelectSingleNode("//div[@class='inc-vat']/p[1]/span[2]").InnerText;
                }
                catch (Exception)
                { }

                var tempImgUrl = doc.DocumentNode.SelectSingleNode("//div[@class='product-img-hero']//a").Descendants("img").Where(x => x.Attributes.Contains("src"));

                foreach (var link in tempImgUrl)
                {
                    imgUrl = link.Attributes["src"].Value;
                }

                try
                {
                    description = doc.DocumentNode.SelectSingleNode("//div[@class='product-info']//ul[1]//li[1]").InnerText;
                    description = description + "\n" + doc.DocumentNode.SelectSingleNode("//div[@class='product-info']//ul[1]//li[2]").InnerText;
                    description = description + "\n" + doc.DocumentNode.SelectSingleNode("//div[@class='product-info']//ul[1]//li[3]").InnerText;
                    description = description + "\n" + doc.DocumentNode.SelectSingleNode("//div[@class='product-info']//ul[1]//li[4]").InnerText;
                    description = description + "\n" + doc.DocumentNode.SelectSingleNode("//div[@class='product-info']//ul[1]//li[5]").InnerText;
                }
                catch (Exception)
                { };

                try
                {
                    var    reviewLink = doc.DocumentNode.SelectSingleNode("//div[@class='button-reevoo']").Descendants("a").Where(x => x.Attributes.Contains("href"));
                    string reviewUrl  = "";
                    foreach (var link in reviewLink)
                    {
                        reviewUrl = link.Attributes["href"].Value;
                    }
                    if (reviewUrl != null)
                    {
                        //Get product Number
                        int productNumber = int.Parse(Regex.Match(reviewUrl, @"\d+").Value);

                        //Load the dom tree
                        var    webHtml       = new HtmlWeb();
                        string reviewPageUrl = "http://mark.reevoo.com/reevoomark/en-GB/product.html?page=1&sku=" + productNumber + "&tab=reviews&trkref=EBU";
                        var    domTree       = webHtml.Load(reviewPageUrl);

                        //------------------------Extract rating for different features-----------------------------

                        //Feature Name
                        string temp = domTree.DocumentNode.SelectSingleNode("//table[@class='scores']//tr[1]//th[1]").InnerText;
                        temp = temp.Replace(" ", "");
                        //Feature Value
                        string value = domTree.DocumentNode.SelectSingleNode("//table[@class='scores']//tr[1]//td[1]").InnerText;

                        //Feature Name
                        temp = domTree.DocumentNode.SelectSingleNode("//table[@class='scores']//tr[2]//th[1]").InnerText;
                        temp = temp.Replace(" ", "");
                        //Feature Value
                        value = domTree.DocumentNode.SelectSingleNode("//table[@class='scores']//tr[2]//td[1]").InnerText;


                        temp  = domTree.DocumentNode.SelectSingleNode("//table[@class='scores']//tr[3]//th[1]").InnerText;
                        temp  = temp.Replace(" ", "");
                        value = domTree.DocumentNode.SelectSingleNode("//table[@class='scores']//tr[3]//td[1]").InnerText;


                        temp  = domTree.DocumentNode.SelectSingleNode("//table[@class='scores']//tr[4]//th[1]").InnerText;
                        temp  = temp.Replace(" ", "");
                        value = domTree.DocumentNode.SelectSingleNode("//table[@class='scores']//tr[4]//td[1]").InnerText;


                        temp  = domTree.DocumentNode.SelectSingleNode("//table[@class='scores']//tr[5]//th[1]").InnerText;
                        temp  = temp.Replace(" ", "");
                        value = domTree.DocumentNode.SelectSingleNode("//table[@class='scores']//tr[5]//td[1]").InnerText;


                        temp   = domTree.DocumentNode.SelectSingleNode("//table[@class='scores']//tr[6]//th[1]").InnerText;
                        temp   = temp.Replace(" ", "");
                        rating = double.Parse(domTree.DocumentNode.SelectSingleNode("//table[@class='scores']//tr[6]//td[1]").InnerText);
                        rating = rating / 2;

                        //----------------------------------Get Reviews
                        try
                        {
                            int pageNo = 1;
                            while (true)
                            {
                                GetReviews(reviewPageUrl);

                                reviewPageUrl = reviewPageUrl.Replace("page=" + pageNo, "page=" + (pageNo + 1));
                                pageNo++;
                            }
                        }
                        catch (Exception)
                        {
                        }
                    }

                    else
                    {
                        //here add the code for getting te reviews from amazon
                    }
                }
                catch (Exception)
                {
                }
                //FileStream fs = new FileStream("pReviews.txt", FileMode.Append);
                //StreamWriter sw = new StreamWriter(fs);
                //for (int i = 0; i < positiveReviews.Count; i++)
                //{
                //    sw.WriteLine(positiveReviews[i]);
                //}
                //sw.Close();
                //fs.Close();

                //fs = new FileStream("nReviews.txt", FileMode.Append);
                //sw = new StreamWriter(fs);
                //for (int i = 0; i < negativeReviews.Count; i++)
                //{
                //    sw.WriteLine(negativeReviews[i]);
                //}
                //sw.Close();
                //fs.Close();

                //Getting Specifications
                // string t=doc.DocumentNode.SelectSingleNode("//div[@class='product-description']//p[2]").InnerText;
                var             p             = doc.DocumentNode.Descendants().Where(n => n.GetAttributeValue("class", "").Equals("product-description")).Single();
                var             paraHtml      = p.InnerHtml;
                MatchCollection collectedSpec = Regex.Matches(paraHtml, "\\s*(.+?)\\s*\\n<ul>");
                int             uListi        = 1;


                foreach (Match m in collectedSpec)
                {
                    string spec = m.Groups[1].Value;
                    spec = spec.Replace(" ", "");
                    try
                    {
                        spec = spec.Replace("<p>", "");
                        spec = spec.Replace("</p>", "");
                        spec = spec.Replace("<span>", "");
                        spec = spec.Replace("</span>", "");
                    }
                    catch (Exception)
                    {
                    }

                    ExtractSpecs(spec, doc, uListi);
                    uListi++;
                }
                if (uListi == 1)
                {
                    foreach (HtmlNode node in doc.DocumentNode.SelectNodes("//div[@class='product-description']//p"))
                    {
                        string spec = node.InnerText;
                        spec = spec.Replace(" ", "");
                        if (spec.Equals("Processor") || spec.Equals("Memory") || spec.Equals("HardDrive") || spec.Equals("OperatingSystem") || spec.Equals("Software") || spec.Equals("OpticalDrive") || spec.Equals("Display") || spec.Equals("Graphics") || spec.Equals("Audio") || spec.Equals("InputDevices") || spec.Equals("Networking") || spec.Equals("PowerSupply") || spec.Equals("Dimensions") || spec.Equals("Interfaces"))
                        {
                            ExtractSpecs(spec, doc, uListi);

                            uListi++;
                        }
                    }
                }
                Product prod = new Product();
                prod.Title              = title;
                prod.Price              = price;
                prod.ImageUrl           = imgUrl;
                prod.ProductDescription = description;
                prod.Rating             = rating;

                Product_Specification ps   = new Product_Specification();
                DbWrappers            wrap = new DbWrappers();
                ps.ProductId = wrap.AddProductDetails(prod, "Laptop");

                //ps.SpecificationId =GetSpecificationId("HardDrive");
                //ps.Value = dictString["HardDrive"];
                //ps.NumericValue = dictValue["HardDrive"];
                //SaveSpecification(ps);

                //ps.SpecificationId = GetSpecificationId("Memory");
                //ps.Value = dictString["Memory"];
                //ps.NumericValue = dictValue["Memory"];
                //SaveSpecification(ps);

                //ps.SpecificationId = GetSpecificationId("ProcessorSpeed");
                //ps.Value = dictString["Processor"];
                //ps.NumericValue = dictValue["Processor"];
                //SaveSpecification(ps);

                //ps.SpecificationId = GetSpecificationId("OperayingSystem");
                //ps.Value = dictString["OperayingSystem"];
                //ps.NumericValue = dictValue["OperayingSystem"];
                //SaveSpecification(ps);

                //ps.SpecificationId = GetSpecificationId("OpticalDrive");
                //ps.Value = dictString["OpticalDrive"];
                //ps.NumericValue = dictValue["OpticalDrive"];
                //SaveSpecification(ps);

                //ps.SpecificationId = GetSpecificationId("Display");
                //ps.Value = dictString["Display"];
                //ps.NumericValue = dictValue["Display"];
                //SaveSpecification(ps);

                //ps.SpecificationId = GetSpecificationId("Graphics");
                //ps.Value = dictString["Graphics"];
                //ps.NumericValue = dictValue["Graphics"];
                //SaveSpecification(ps);

                //ps.SpecificationId = GetSpecificationId("Audio");
                //ps.Value = dictString["Audio"];
                //ps.NumericValue = dictValue["Audio"];
                //SaveSpecification(ps);

                List <Specification> specifications = wrap.GetAllSpecifications();

                foreach (var s in specifications)
                {
                    //Change it (Processor) in db so that this check can be removed
                    if (s.Name.Equals("ProcessorSpeed"))
                    {
                        try
                        {
                            ps.SpecificationId = s.Id;
                            ps.Value           = dictString["Processor"];
                            ps.NumericValue    = dictValue["Processor"];
                            wrap.SaveSpecification(ps);
                        }
                        catch (Exception)
                        { };
                    }

                    // Change Dimesnion to Dimensions in Db
                    else if (s.Name.Equals("Dimension"))
                    {
                        try
                        {
                            ps.SpecificationId = s.Id;
                            ps.Value           = dictString["Dimensions"];
                            ps.NumericValue    = dictValue["Dimensions"];
                            wrap.SaveSpecification(ps);
                        }
                        catch (Exception)
                        { };
                    }

                    else if (s.Name.Equals("OperatingSystem"))
                    {
                        try
                        {
                            ps.SpecificationId = s.Id;
                            ps.Value           = dictString["OperatingSystem"];
                            ps.NumericValue    = dictValue["OperatingSystem"];
                            wrap.SaveSpecification(ps);
                        }
                        catch (Exception)
                        {
                            if (s.Name.Equals("OperatingSystem"))
                            {
                                try
                                {
                                    ps.SpecificationId = s.Id;
                                    ps.Value           = dictString["Software"];
                                    ps.NumericValue    = dictValue["Software"];
                                    wrap.SaveSpecification(ps);
                                }
                                catch (Exception)
                                { };
                            }
                        };
                    }

                    else
                    {
                        try
                        {
                            ps.SpecificationId = s.Id;
                            ps.Value           = dictString[s.Name];
                            ps.NumericValue    = dictValue[s.Name];
                            wrap.SaveSpecification(ps);
                        }
                        catch (Exception)
                        {
                        };
                    }
                }

                ProductReview pr = new ProductReview();

                foreach (var i in positiveReviews)
                {
                    pr.ProductId   = ps.ProductId;
                    pr.Review      = i;
                    pr.ReviewScore = 4;
                    wrap.SaveReview(pr);
                }
                foreach (var i in negativeReviews)
                {
                    pr.ProductId   = ps.ProductId;
                    pr.Review      = i;
                    pr.ReviewScore = 1;
                    wrap.SaveReview(pr);
                }

                positiveReviews.Clear();
                negativeReviews.Clear();
            }
            catch (Exception)
            { };
        }
Ejemplo n.º 2
0
        public static void ExtractingHtmlGSM(string html, string str)
        {
            Product p = new Product();
            Product_Specification prodSpecs = new Product_Specification();
            DbWrappers            wrapper   = new DbWrappers();
            string temp = "";
            //Product Title
            Regex  r     = new Regex("<h1 class=\"specs-phone-name-title\">\\s*(.+?)\\s*</h1>");
            Match  m     = r.Match(html);
            string title = "";

            try
            {
                p.Title = m.Groups[1].Value;
            }catch (Exception)
            {
            }



            if (p.Title != "")
            {
                //Price
                try
                {
                    r       = new Regex("<span class=\"price\">\\s*(.+?)\\s*</span>");
                    m       = r.Match(html);
                    p.Price = m.Groups[1].Value;
                }catch (Exception)
                {
                }


                try {
                    var    webGet          = new HtmlWeb();
                    var    doc             = webGet.Load(str);
                    string imgUrl          = "";
                    string memory          = "";
                    string operatingSystem = "";
                    string camera          = "";
                    string screenSize      = "";

                    //description
                    try
                    {
                        var description = doc.DocumentNode.SelectSingleNode("//div[@class='center-stage light nobg specs-accent']/ul/li").InnerText;
                        p.ProductDescription = description;
                    }
                    catch (Exception)
                    {
                    }

                    try
                    {
                        //Image Url

                        var links = doc.DocumentNode.SelectSingleNode("//div[@class='specs-photo-main']").Descendants("img").Where(x => x.Attributes.Contains("src"));

                        foreach (var link in links)
                        {
                            p.ImageUrl = link.Attributes["src"].Value;
                        }
                    }catch (Exception)
                    {
                    }

                    //Release Date
                    try
                    {
                        var l = doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[2]//tr[2]//td[2]");
                        p.ReleaseDate = l.InnerText;
                    }catch (Exception e)
                    {
                    }
                    //Screen Size
                    try
                    {
                        var l = doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[4]//tr[2]//td[2]");
                        screenSize = l.InnerText;
                    }catch (Exception)
                    {
                    }
                    try
                    {
                        var    l1       = doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[5]//tr[1]//th[1]");
                        string platform = l1.InnerText;
                        if ((platform.Equals("Platform")))
                        {
                            operatingSystem = (doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[5]//tr[1]//td[2]")).InnerText;
                            try
                            {
                                memory = (doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[6]//tr[1]//td[2]")).InnerText;
                                memory = memory + (doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[6]//tr[2]//td[2]")).InnerText;
                            }
                            catch (Exception)
                            { }
                        }
                        else if ((platform.Equals("Memory")))
                        {
                            try
                            {
                                memory = (doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[5]//tr[1]//td[2]")).InnerText;
                                memory = memory + (doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[5]//tr[4]//td[2]")).InnerText;
                            }
                            catch (Exception)
                            { }
                        }
                        if ((temp = (doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[7]//tr[1]//th[1]")).InnerText).Equals("Camera"))
                        {
                            camera = "Primary :" + (doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[7]//tr[1]//td[2]")).InnerText;
                            try
                            {
                                camera = camera + ", Secondary :" + (doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[7]//tr[4]//td[2]")).InnerText;
                            }
                            catch (Exception)
                            { }
                        }
                        else if ((temp = (doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[6]//tr[1]//th[1]")).InnerText).Equals("Camera"))
                        {
                            camera = "Primary: " + (doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[6]//tr[1]//td[2]")).InnerText;
                            try
                            {
                                camera = camera + ", Secondary: " + (doc.DocumentNode.SelectSingleNode("//div[@id='specs-list']//table[6]//tr[3]//td[2]")).InnerText;
                            }
                            catch (Exception)
                            { }
                        }
                    }catch (Exception)
                    {
                    }
                    DbWrappers prodWrapper = new DbWrappers();
                    prodSpecs.ProductId       = prodWrapper.AddProductDetails(p, "Mobile");
                    prodSpecs.SpecificationId = wrapper.GetSpecificationId("screensize");
                    prodSpecs.Value           = screenSize;
                    wrapper.SaveSpecification(prodSpecs);

                    prodSpecs.SpecificationId = wrapper.GetSpecificationId("memory");
                    prodSpecs.Value           = memory;
                    wrapper.SaveSpecification(prodSpecs);

                    prodSpecs.SpecificationId = wrapper.GetSpecificationId("camera");
                    prodSpecs.Value           = camera;
                    wrapper.SaveSpecification(prodSpecs);

                    prodSpecs.SpecificationId = wrapper.GetSpecificationId("operatingsystem");
                    prodSpecs.Value           = operatingSystem;
                    wrapper.SaveSpecification(prodSpecs);
                }catch (Exception)
                {
                }
                //FileStream fs = new FileStream("data.txt", FileMode.Append);
                //StreamWriter sw = new StreamWriter(fs);
                //sw.WriteLine(title + " | " + price + " | " + releaseDate + " | " + imgUrl + " | " + screenSize + " | " + memory + " | " + operatingSystem + " | " + camera);
                //sw.Close();
                //fs.Close();
            }
        }
Ejemplo n.º 3
0
 //Saving the Specification of Products
 public void SaveSpecification(Product_Specification ps)
 {
     ed.Product_Specification.Add(ps);
     ed.SaveChanges();
 }