Exemplos de StockScraper.Services Database.AddCNNMoneyIntoDatabase em C# (CSharp)

Exemplo n.º 1

        // GET: CNNmoneyStocks/Details/5
        public ActionResult HAPScrapeCNNHotStocks()
        {
            if (ModelState.IsValid)
            {
                string html = @"https://money.cnn.com/data/hotstocks/index.html";

                HtmlWeb web = new HtmlWeb();

                HtmlDocument htmlDoc = web.Load(html);

                List <Stock> stockList = new List <Stock>();

                HtmlNodeCollection rowsNodesList = htmlDoc.DocumentNode.SelectNodes("//table[contains(@class, 'wsod_dataTable')]//tr");

                int stockId = 1;
                foreach (var row in rowsNodesList)
                {
                    stockId++;

                    var cells = row.SelectNodes("td");
                    if (cells != null && cells.Count > 0)
                    {
                        var companyName   = cells[0].InnerText;
                        var price         = cells[1].InnerText;
                        var change        = cells[2].InnerText;
                        var percentChange = cells[3].InnerText;


                        Stock newStock = new Stock(stockId, companyName, price, change, percentChange);
                        stockList.Add(newStock);
                        Database.AddCNNMoneyIntoDatabase(newStock);
                    }
                }
            }
            return(RedirectToAction("Index"));
        }