예제 #1
0
파일: Program.cs 프로젝트: azdyrski/stc
        static void Main(string[] args)
        {
            DataScraper ds = new DataScraper();
            //var pageDomain = "http://sharktanksuccess.blogspot.com";
            var pageGetter = new HtmlWeb();
            string fileText = string.Empty;

            //Dictionary<int,

            #region Season 1
            //season 1 season and episodes
            var tvDbSeason1Page = pageGetter.Load("http://thetvdb.com/?tab=season&seriesid=100981&seasonid=83461&lid=7");
            var tableList = tvDbSeason1Page.GetElementbyId("listtable").Descendants("tr").ToList();
            var seasonNum = 1;
            DataScraper.Season season1 = new DataScraper.Season() { SeasonNumber = seasonNum, SeasonDate = DateTime.Parse("2009-08-09") };
            fileText += ds.SeasonInsertString(season1);
            for (int i = 1; i < tableList.Count; i++) //avoid headers at row 0
            {
                var rowData = tableList[i];
                DataScraper.Episode episode = new DataScraper.Episode();
                episode.EpisodeName = rowData.Descendants("a").ToList()[1].InnerText.Replace("'","''");
                episode.SeasonId = seasonNum;
                episode.EpisodeNumber = i;
                episode.EpisodeDate = DateTime.Parse(rowData.Descendants("td").ToList()[2].InnerText);

                fileText += ds.EpisodeInsertString(episode);

                //season 1 products
                var productPage = pageGetter.Load("http://sharktanksuccess.blogspot.com/2012/10/shark-tank-season-1-15-episodes-68.html"); //use for partial product name completion
                var divList = productPage.DocumentNode.Descendants("div").ToList();
                foreach (var divElement in divList)
                {
                    if (divElement.Attributes["class"] != null && divElement.Attributes["class"].Value == "post-body entry-content")
                    {

                        //Console.Out.WriteLine("Found content div");
                        var episodeElementList = divElement.Descendants("ul").ToList();
                        //fileText += ds.SeasonInsertString(1, new DateTime(2009, 8, 9));
                        var episodeElement = episodeElementList[i-1];
                        //Console.Out.WriteLine("Episode " + episodeNum.ToString());
                        //http://thetvdb.com/?tab=season&seriesid=100981&seasonid=83461&lid=7 possibly use for episode names and dates?
                        //fileText += ds.EpisodeInsertString("",episodeNum,null,1);
                        var productList = episodeElement.Descendants("li").ToList();
                        foreach (var productElement in productList)
                        {
                            DataScraper.Product product = new DataScraper.Product() { EpisodeId = i };
                            var linkProductList = productElement.Descendants("a").ToList();
                            var linkProduct = linkProductList.Count == 0 ? null : linkProductList[0];
                            if (productElement.InnerText != string.Empty)
                            {
                                if (linkProduct == null)
                                {
                                    //Console.Out.WriteLine("   " + productElement.InnerText);
                                    string nameString = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''");
                                    int dashPos = nameString.IndexOf("-");
                                    product.ProductName = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''").Substring(0,dashPos-1).Trim();
                                }
                                else
                                {
                                    //Console.Out.WriteLine("   " + linkProduct.InnerText);
                                    product.ProductName = WebUtility.HtmlDecode(linkProduct.InnerText).Replace("'", "''").Trim();
                                }
                            }
                            if (!string.IsNullOrEmpty(product.ProductName))
                                fileText += ds.ProductInsertString(product);
                        }
                    }
                }
            }
            #endregion

            #region Season 2
            //season 2 season and episodes
            var tvDbSeason2Page = pageGetter.Load("http://thetvdb.com/?tab=season&seriesid=100981&seasonid=444001&lid=7");
            tableList = tvDbSeason2Page.GetElementbyId("listtable").Descendants("tr").ToList();
            seasonNum = 2;
            DataScraper.Season season2 = new DataScraper.Season() { SeasonNumber = seasonNum, SeasonDate = DateTime.Parse("2011-03-20") };
            fileText += ds.SeasonInsertString(season2);
            for (int i = 1; i < tableList.Count; i++) //avoid headers at row 0
            {
                var rowData = tableList[i];
                DataScraper.Episode episode = new DataScraper.Episode();
                episode.EpisodeName = rowData.Descendants("a").ToList()[1].InnerText.Replace("'", "''");
                episode.SeasonId = seasonNum;
                episode.EpisodeNumber = i;
                episode.EpisodeDate = DateTime.Parse(rowData.Descendants("td").ToList()[2].InnerText);

                fileText += ds.EpisodeInsertString(episode);

                //season 2 products
                var productPage = pageGetter.Load("http://sharktanksuccess.blogspot.com/2012/10/shark-tank-season-2-all-episodes-33.html"); //use for partial product name completion
                var divList = productPage.DocumentNode.Descendants("div").ToList();
                foreach (var divElement in divList)
                {
                    if (divElement.Attributes["class"] != null && divElement.Attributes["class"].Value == "post-body entry-content")
                    {

                        //Console.Out.WriteLine("Found content div");
                        var episodeElementList = divElement.Descendants("ul").ToList();
                        //fileText += ds.SeasonInsertString(1, new DateTime(2009, 8, 9));
                        var episodeElement = episodeElementList[i - 1];
                        //Console.Out.WriteLine("Episode " + episodeNum.ToString());
                        //http://thetvdb.com/?tab=season&seriesid=100981&seasonid=83461&lid=7 possibly use for episode names and dates?
                        //fileText += ds.EpisodeInsertString("",episodeNum,null,1);
                        var productList = episodeElement.Descendants("li").ToList();
                        foreach (var productElement in productList)
                        {
                            DataScraper.Product product = new DataScraper.Product() { EpisodeId = i };
                            var linkProductList = productElement.Descendants("a").ToList();
                            var linkProduct = linkProductList.Count == 0 ? null : linkProductList[0];
                            if (productElement.InnerText != string.Empty)
                            {
                                if (linkProduct == null)
                                {
                                    //Console.Out.WriteLine("   " + productElement.InnerText);
                                    string nameString = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''");
                                    int dashPos = nameString.IndexOf("-");
                                    product.ProductName = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''").Substring(0, dashPos - 1).Trim();
                                }
                                else
                                {
                                    //Console.Out.WriteLine("   " + linkProduct.InnerText);
                                    product.ProductName = WebUtility.HtmlDecode(linkProduct.InnerText).Replace("'", "''").Trim();
                                }
                            }
                            if (!string.IsNullOrEmpty(product.ProductName))
                                fileText += ds.ProductInsertString(product);
                        }
                    }
                }
            }
            #endregion

            #region Season 3
            //season 3 season and episodes
            var tvDbSeason3Page = pageGetter.Load("http://thetvdb.com/?tab=season&seriesid=100981&seasonid=480445&lid=7");
            tableList = tvDbSeason3Page.GetElementbyId("listtable").Descendants("tr").ToList();
            seasonNum = 3;
            DataScraper.Season season3 = new DataScraper.Season() { SeasonNumber = seasonNum, SeasonDate = DateTime.Parse("2012-01-20") };
            fileText += ds.SeasonInsertString(season3);
            for (int i = 1; i < tableList.Count; i++) //avoid headers at row 0
            {
                var rowData = tableList[i];
                DataScraper.Episode episode = new DataScraper.Episode();
                episode.EpisodeName = rowData.Descendants("a").ToList()[1].InnerText.Replace("'", "''");
                episode.SeasonId = seasonNum;
                episode.EpisodeNumber = i;
                episode.EpisodeDate = DateTime.Parse(rowData.Descendants("td").ToList()[2].InnerText);

                fileText += ds.EpisodeInsertString(episode);

                //season 3 products
                var productPage = pageGetter.Load("http://sharktanksuccess.blogspot.com/2013/08/shark-tank-season-3.html"); //use for partial product name completion
                var divList = productPage.DocumentNode.Descendants("div").ToList();
                foreach (var divElement in divList)
                {
                    if (divElement.Attributes["class"] != null && divElement.Attributes["class"].Value == "post-body entry-content")
                    {

                        //Console.Out.WriteLine("Found content div");
                        var episodeElementList = divElement.Descendants("ul").ToList();
                        //fileText += ds.SeasonInsertString(1, new DateTime(2009, 8, 9));
                        var episodeElement = episodeElementList[i - 1];
                        //Console.Out.WriteLine("Episode " + episodeNum.ToString());
                        //http://thetvdb.com/?tab=season&seriesid=100981&seasonid=83461&lid=7 possibly use for episode names and dates?
                        //fileText += ds.EpisodeInsertString("",episodeNum,null,1);
                        var productList = episodeElement.Descendants("li").ToList();
                        foreach (var productElement in productList)
                        {
                            DataScraper.Product product = new DataScraper.Product() { EpisodeId = i};
                            var linkProductList = productElement.Descendants("a").ToList();
                            var linkProduct = linkProductList.Count == 0 ? null : linkProductList[0];
                            if (productElement.InnerText != string.Empty)
                            {
                                if (linkProduct == null)
                                {
                                    //Console.Out.WriteLine("   " + productElement.InnerText);
                                    string nameString = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''");
                                    int dashPos = nameString.IndexOf("-");
                                    if(dashPos != -1)
                                        product.ProductName = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''").Substring(0, dashPos - 1).Trim();
                                }
                                else
                                {
                                    //Console.Out.WriteLine("   " + linkProduct.InnerText);
                                    product.ProductName = WebUtility.HtmlDecode(linkProduct.InnerText).Replace("'", "''").Trim();
                                }
                            }
                            if (!string.IsNullOrEmpty(product.ProductName))
                                fileText += ds.ProductInsertString(product);
                        }
                    }
                }
            }
            #endregion

            #region Season 4
            //season 4 season and episodes
            /*var tvDbSeason4Page = pageGetter.Load("http://thetvdb.com/?tab=season&seriesid=100981&seasonid=497747&lid=7");
            tableList = tvDbSeason4Page.GetElementbyId("listtable").Descendants("tr").ToList();
            seasonNum = 4;
            DataScraper.Season season4 = new DataScraper.Season() { SeasonNumber = seasonNum, SeasonDate = DateTime.Parse("2012-09-14") };
            fileText += ds.SeasonInsertString(season4);
            for (int i = 1; i < tableList.Count; i++) //avoid headers at row 0
            {
                var rowData = tableList[i];
                DataScraper.Episode episode = new DataScraper.Episode();
                episode.EpisodeName = rowData.Descendants("a").ToList()[1].InnerText.Replace("'", "''");
                episode.SeasonId = seasonNum;
                episode.EpisodeNumber = i;
                episode.EpisodeDate = DateTime.Parse(rowData.Descendants("td").ToList()[2].InnerText);

                fileText += ds.EpisodeInsertString(episode);

                //season 4 products
                var productPage = pageGetter.Load("http://sharktanksuccess.blogspot.com/2012/10/shark-tank-season-4-all-episodes.html"); //use for partial product name completion
                var divList = productPage.DocumentNode.Descendants("div").ToList();
                foreach (var divElement in divList)
                {
                    if (divElement.Attributes["class"] != null && divElement.Attributes["class"].Value == "post-body entry-content")
                    {

                        //Console.Out.WriteLine("Found content div");
                        var episodeElementList = divElement.Descendants("ul").ToList();
                        //fileText += ds.SeasonInsertString(1, new DateTime(2009, 8, 9));
                        var episodeElement = episodeElementList[i - 1];
                        //Console.Out.WriteLine("Episode " + episodeNum.ToString());
                        //http://thetvdb.com/?tab=season&seriesid=100981&seasonid=83461&lid=7 possibly use for episode names and dates?
                        //fileText += ds.EpisodeInsertString("",episodeNum,null,1);
                        var productList = episodeElement.Descendants("li").ToList();
                        foreach (var productElement in productList)
                        {
                            DataScraper.Product product = new DataScraper.Product() { EpisodeId = i };
                            var linkProductList = productElement.Descendants("a").ToList();
                            var linkProduct = linkProductList.Count == 0 ? null : linkProductList[0];
                            if (productElement.InnerText != string.Empty)
                            {
                                if (linkProduct == null)
                                {
                                    //Console.Out.WriteLine("   " + productElement.InnerText);
                                    string nameString = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''");
                                    int dashPos = nameString.IndexOf("-");
                                    if (dashPos != -1)
                                        product.ProductName = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''").Substring(0, dashPos - 1).Trim();
                                }
                                else
                                {
                                    //Console.Out.WriteLine("   " + linkProduct.InnerText);
                                    product.ProductName = WebUtility.HtmlDecode(linkProduct.InnerText).Replace("'", "''").Trim();
                                }
                            }
                            if (!string.IsNullOrEmpty(product.ProductName))
                                fileText += ds.ProductInsertString(product);
                        }
                    }
                }
            }*/
            #endregion

            File.WriteAllText("C:\\temp\\output.sql",fileText);
            Console.WriteLine("Output sql insert script to C:\\temp\\output.sql.  Enter to close.");
            Console.ReadLine(); //pause until enter
        }
예제 #2
0
파일: Program.cs 프로젝트: azdyrski/stc
        static void Main(string[] args)
        {
            DataScraper ds = new DataScraper();
            //var pageDomain = "http://sharktanksuccess.blogspot.com";
            var    pageGetter = new HtmlWeb();
            string fileText   = string.Empty;

            //Dictionary<int,

            #region Season 1
            //season 1 season and episodes
            var tvDbSeason1Page        = pageGetter.Load("http://thetvdb.com/?tab=season&seriesid=100981&seasonid=83461&lid=7");
            var tableList              = tvDbSeason1Page.GetElementbyId("listtable").Descendants("tr").ToList();
            var seasonNum              = 1;
            DataScraper.Season season1 = new DataScraper.Season()
            {
                SeasonNumber = seasonNum, SeasonDate = DateTime.Parse("2009-08-09")
            };
            fileText += ds.SeasonInsertString(season1);
            for (int i = 1; i < tableList.Count; i++)             //avoid headers at row 0
            {
                var rowData = tableList[i];
                DataScraper.Episode episode = new DataScraper.Episode();
                episode.EpisodeName   = rowData.Descendants("a").ToList()[1].InnerText.Replace("'", "''");
                episode.SeasonId      = seasonNum;
                episode.EpisodeNumber = i;
                episode.EpisodeDate   = DateTime.Parse(rowData.Descendants("td").ToList()[2].InnerText);

                fileText += ds.EpisodeInsertString(episode);

                //season 1 products
                var productPage = pageGetter.Load("http://sharktanksuccess.blogspot.com/2012/10/shark-tank-season-1-15-episodes-68.html");                 //use for partial product name completion
                var divList     = productPage.DocumentNode.Descendants("div").ToList();
                foreach (var divElement in divList)
                {
                    if (divElement.Attributes["class"] != null && divElement.Attributes["class"].Value == "post-body entry-content")
                    {
                        //Console.Out.WriteLine("Found content div");
                        var episodeElementList = divElement.Descendants("ul").ToList();
                        //fileText += ds.SeasonInsertString(1, new DateTime(2009, 8, 9));
                        var episodeElement = episodeElementList[i - 1];
                        //Console.Out.WriteLine("Episode " + episodeNum.ToString());
                        //http://thetvdb.com/?tab=season&seriesid=100981&seasonid=83461&lid=7 possibly use for episode names and dates?
                        //fileText += ds.EpisodeInsertString("",episodeNum,null,1);
                        var productList = episodeElement.Descendants("li").ToList();
                        foreach (var productElement in productList)
                        {
                            DataScraper.Product product = new DataScraper.Product()
                            {
                                EpisodeId = i
                            };
                            var linkProductList = productElement.Descendants("a").ToList();
                            var linkProduct     = linkProductList.Count == 0 ? null : linkProductList[0];
                            if (productElement.InnerText != string.Empty)
                            {
                                if (linkProduct == null)
                                {
                                    //Console.Out.WriteLine("   " + productElement.InnerText);
                                    string nameString = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''");
                                    int    dashPos    = nameString.IndexOf("-");
                                    product.ProductName = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''").Substring(0, dashPos - 1).Trim();
                                }
                                else
                                {
                                    //Console.Out.WriteLine("   " + linkProduct.InnerText);
                                    product.ProductName = WebUtility.HtmlDecode(linkProduct.InnerText).Replace("'", "''").Trim();
                                }
                            }
                            if (!string.IsNullOrEmpty(product.ProductName))
                            {
                                fileText += ds.ProductInsertString(product);
                            }
                        }
                    }
                }
            }
            #endregion

            #region Season 2
            //season 2 season and episodes
            var tvDbSeason2Page = pageGetter.Load("http://thetvdb.com/?tab=season&seriesid=100981&seasonid=444001&lid=7");
            tableList = tvDbSeason2Page.GetElementbyId("listtable").Descendants("tr").ToList();
            seasonNum = 2;
            DataScraper.Season season2 = new DataScraper.Season()
            {
                SeasonNumber = seasonNum, SeasonDate = DateTime.Parse("2011-03-20")
            };
            fileText += ds.SeasonInsertString(season2);
            for (int i = 1; i < tableList.Count; i++)             //avoid headers at row 0
            {
                var rowData = tableList[i];
                DataScraper.Episode episode = new DataScraper.Episode();
                episode.EpisodeName   = rowData.Descendants("a").ToList()[1].InnerText.Replace("'", "''");
                episode.SeasonId      = seasonNum;
                episode.EpisodeNumber = i;
                episode.EpisodeDate   = DateTime.Parse(rowData.Descendants("td").ToList()[2].InnerText);

                fileText += ds.EpisodeInsertString(episode);

                //season 2 products
                var productPage = pageGetter.Load("http://sharktanksuccess.blogspot.com/2012/10/shark-tank-season-2-all-episodes-33.html");                 //use for partial product name completion
                var divList     = productPage.DocumentNode.Descendants("div").ToList();
                foreach (var divElement in divList)
                {
                    if (divElement.Attributes["class"] != null && divElement.Attributes["class"].Value == "post-body entry-content")
                    {
                        //Console.Out.WriteLine("Found content div");
                        var episodeElementList = divElement.Descendants("ul").ToList();
                        //fileText += ds.SeasonInsertString(1, new DateTime(2009, 8, 9));
                        var episodeElement = episodeElementList[i - 1];
                        //Console.Out.WriteLine("Episode " + episodeNum.ToString());
                        //http://thetvdb.com/?tab=season&seriesid=100981&seasonid=83461&lid=7 possibly use for episode names and dates?
                        //fileText += ds.EpisodeInsertString("",episodeNum,null,1);
                        var productList = episodeElement.Descendants("li").ToList();
                        foreach (var productElement in productList)
                        {
                            DataScraper.Product product = new DataScraper.Product()
                            {
                                EpisodeId = i
                            };
                            var linkProductList = productElement.Descendants("a").ToList();
                            var linkProduct     = linkProductList.Count == 0 ? null : linkProductList[0];
                            if (productElement.InnerText != string.Empty)
                            {
                                if (linkProduct == null)
                                {
                                    //Console.Out.WriteLine("   " + productElement.InnerText);
                                    string nameString = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''");
                                    int    dashPos    = nameString.IndexOf("-");
                                    product.ProductName = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''").Substring(0, dashPos - 1).Trim();
                                }
                                else
                                {
                                    //Console.Out.WriteLine("   " + linkProduct.InnerText);
                                    product.ProductName = WebUtility.HtmlDecode(linkProduct.InnerText).Replace("'", "''").Trim();
                                }
                            }
                            if (!string.IsNullOrEmpty(product.ProductName))
                            {
                                fileText += ds.ProductInsertString(product);
                            }
                        }
                    }
                }
            }
            #endregion

            #region Season 3
            //season 3 season and episodes
            var tvDbSeason3Page = pageGetter.Load("http://thetvdb.com/?tab=season&seriesid=100981&seasonid=480445&lid=7");
            tableList = tvDbSeason3Page.GetElementbyId("listtable").Descendants("tr").ToList();
            seasonNum = 3;
            DataScraper.Season season3 = new DataScraper.Season()
            {
                SeasonNumber = seasonNum, SeasonDate = DateTime.Parse("2012-01-20")
            };
            fileText += ds.SeasonInsertString(season3);
            for (int i = 1; i < tableList.Count; i++)             //avoid headers at row 0
            {
                var rowData = tableList[i];
                DataScraper.Episode episode = new DataScraper.Episode();
                episode.EpisodeName   = rowData.Descendants("a").ToList()[1].InnerText.Replace("'", "''");
                episode.SeasonId      = seasonNum;
                episode.EpisodeNumber = i;
                episode.EpisodeDate   = DateTime.Parse(rowData.Descendants("td").ToList()[2].InnerText);

                fileText += ds.EpisodeInsertString(episode);

                //season 3 products
                var productPage = pageGetter.Load("http://sharktanksuccess.blogspot.com/2013/08/shark-tank-season-3.html");                 //use for partial product name completion
                var divList     = productPage.DocumentNode.Descendants("div").ToList();
                foreach (var divElement in divList)
                {
                    if (divElement.Attributes["class"] != null && divElement.Attributes["class"].Value == "post-body entry-content")
                    {
                        //Console.Out.WriteLine("Found content div");
                        var episodeElementList = divElement.Descendants("ul").ToList();
                        //fileText += ds.SeasonInsertString(1, new DateTime(2009, 8, 9));
                        var episodeElement = episodeElementList[i - 1];
                        //Console.Out.WriteLine("Episode " + episodeNum.ToString());
                        //http://thetvdb.com/?tab=season&seriesid=100981&seasonid=83461&lid=7 possibly use for episode names and dates?
                        //fileText += ds.EpisodeInsertString("",episodeNum,null,1);
                        var productList = episodeElement.Descendants("li").ToList();
                        foreach (var productElement in productList)
                        {
                            DataScraper.Product product = new DataScraper.Product()
                            {
                                EpisodeId = i
                            };
                            var linkProductList = productElement.Descendants("a").ToList();
                            var linkProduct     = linkProductList.Count == 0 ? null : linkProductList[0];
                            if (productElement.InnerText != string.Empty)
                            {
                                if (linkProduct == null)
                                {
                                    //Console.Out.WriteLine("   " + productElement.InnerText);
                                    string nameString = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''");
                                    int    dashPos    = nameString.IndexOf("-");
                                    if (dashPos != -1)
                                    {
                                        product.ProductName = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''").Substring(0, dashPos - 1).Trim();
                                    }
                                }
                                else
                                {
                                    //Console.Out.WriteLine("   " + linkProduct.InnerText);
                                    product.ProductName = WebUtility.HtmlDecode(linkProduct.InnerText).Replace("'", "''").Trim();
                                }
                            }
                            if (!string.IsNullOrEmpty(product.ProductName))
                            {
                                fileText += ds.ProductInsertString(product);
                            }
                        }
                    }
                }
            }
            #endregion

            #region Season 4
            //season 4 season and episodes

            /*var tvDbSeason4Page = pageGetter.Load("http://thetvdb.com/?tab=season&seriesid=100981&seasonid=497747&lid=7");
             * tableList = tvDbSeason4Page.GetElementbyId("listtable").Descendants("tr").ToList();
             * seasonNum = 4;
             * DataScraper.Season season4 = new DataScraper.Season() { SeasonNumber = seasonNum, SeasonDate = DateTime.Parse("2012-09-14") };
             * fileText += ds.SeasonInsertString(season4);
             * for (int i = 1; i < tableList.Count; i++) //avoid headers at row 0
             * {
             *      var rowData = tableList[i];
             *      DataScraper.Episode episode = new DataScraper.Episode();
             *      episode.EpisodeName = rowData.Descendants("a").ToList()[1].InnerText.Replace("'", "''");
             *      episode.SeasonId = seasonNum;
             *      episode.EpisodeNumber = i;
             *      episode.EpisodeDate = DateTime.Parse(rowData.Descendants("td").ToList()[2].InnerText);
             *
             *      fileText += ds.EpisodeInsertString(episode);
             *
             *      //season 4 products
             *      var productPage = pageGetter.Load("http://sharktanksuccess.blogspot.com/2012/10/shark-tank-season-4-all-episodes.html"); //use for partial product name completion
             *      var divList = productPage.DocumentNode.Descendants("div").ToList();
             *      foreach (var divElement in divList)
             *      {
             *              if (divElement.Attributes["class"] != null && divElement.Attributes["class"].Value == "post-body entry-content")
             *              {
             *
             *                      //Console.Out.WriteLine("Found content div");
             *                      var episodeElementList = divElement.Descendants("ul").ToList();
             *                      //fileText += ds.SeasonInsertString(1, new DateTime(2009, 8, 9));
             *                      var episodeElement = episodeElementList[i - 1];
             *                      //Console.Out.WriteLine("Episode " + episodeNum.ToString());
             *                      //http://thetvdb.com/?tab=season&seriesid=100981&seasonid=83461&lid=7 possibly use for episode names and dates?
             *                      //fileText += ds.EpisodeInsertString("",episodeNum,null,1);
             *                      var productList = episodeElement.Descendants("li").ToList();
             *                      foreach (var productElement in productList)
             *                      {
             *                              DataScraper.Product product = new DataScraper.Product() { EpisodeId = i };
             *                              var linkProductList = productElement.Descendants("a").ToList();
             *                              var linkProduct = linkProductList.Count == 0 ? null : linkProductList[0];
             *                              if (productElement.InnerText != string.Empty)
             *                              {
             *                                      if (linkProduct == null)
             *                                      {
             *                                              //Console.Out.WriteLine("   " + productElement.InnerText);
             *                                              string nameString = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''");
             *                                              int dashPos = nameString.IndexOf("-");
             *                                              if (dashPos != -1)
             *                                                      product.ProductName = WebUtility.HtmlDecode(productElement.InnerText).Replace("'", "''").Substring(0, dashPos - 1).Trim();
             *                                      }
             *                                      else
             *                                      {
             *                                              //Console.Out.WriteLine("   " + linkProduct.InnerText);
             *                                              product.ProductName = WebUtility.HtmlDecode(linkProduct.InnerText).Replace("'", "''").Trim();
             *                                      }
             *                              }
             *                              if (!string.IsNullOrEmpty(product.ProductName))
             *                                      fileText += ds.ProductInsertString(product);
             *                      }
             *              }
             *      }
             * }*/
            #endregion

            File.WriteAllText("C:\\temp\\output.sql", fileText);
            Console.WriteLine("Output sql insert script to C:\\temp\\output.sql.  Enter to close.");
            Console.ReadLine();             //pause until enter
        }