public List <Table> GetFootballTables()
        {
            var tables = new List <Table>();

            var          web = new HtmlWeb();
            HtmlDocument doc;

            try
            {
                //get div 1
                var div1 = new Table {
                    League = "Roinn 1", Division = new List <LeagueRow>()
                };
                var link = "http://www.gaa.ie/fixtures-and-results/league-tables/football-league-tables/roinn-1/2015/";
                doc = web.Load(link);
                var nodes = doc.DocumentNode.SelectNodes("//table [@id='league_table2']//tr");
                for (var i = 1; i < nodes.Count; i++)
                {
                    var row = new LeagueRow
                    {
                        Pos    = nodes[i].ChildNodes[0].InnerText,
                        Name   = nodes[i].ChildNodes[1].InnerText,
                        Played = nodes[i].ChildNodes[2].InnerText,
                        Won    = nodes[i].ChildNodes[3].InnerText,
                        Lost   = nodes[i].ChildNodes[4].InnerText,
                        Drawn  = nodes[i].ChildNodes[5].InnerText,
                        For    = nodes[i].ChildNodes[6].InnerText,
                        Aga    = nodes[i].ChildNodes[7].InnerText,
                        Points = nodes[i].ChildNodes[8].InnerText
                    };
                    div1.Division.Add(row);
                }
                tables.Add(div1);

                //get div 2
                var div2 = new Table {
                    League = "Roinn 2", Division = new List <LeagueRow>()
                };
                var link2 = "http://www.gaa.ie/fixtures-and-results/league-tables/football-league-tables/roinn-2/2015/";
                doc = web.Load(link2);
                var nodes2 = doc.DocumentNode.SelectNodes("//table [@id='league_table2']//tr");
                for (var i = 1; i < nodes2.Count; i++)
                {
                    var row = new LeagueRow
                    {
                        Pos    = nodes2[i].ChildNodes[0].InnerText,
                        Name   = nodes2[i].ChildNodes[1].InnerText,
                        Played = nodes2[i].ChildNodes[2].InnerText,
                        Won    = nodes2[i].ChildNodes[3].InnerText,
                        Lost   = nodes2[i].ChildNodes[4].InnerText,
                        Drawn  = nodes2[i].ChildNodes[5].InnerText,
                        For    = nodes2[i].ChildNodes[6].InnerText,
                        Aga    = nodes2[i].ChildNodes[7].InnerText,
                        Points = nodes2[i].ChildNodes[8].InnerText
                    };
                    div2.Division.Add(row);
                }
                tables.Add(div2);

                //get div 3
                var div3 = new Table {
                    League = "Roinn 3", Division = new List <LeagueRow>()
                };
                var link3 = "http://www.gaa.ie/fixtures-and-results/league-tables/football-league-tables/roinn-3/2015/";
                doc = web.Load(link3);
                var nodes3 = doc.DocumentNode.SelectNodes("//table [@id='league_table2']//tr");
                for (var i = 1; i < nodes3.Count; i++)
                {
                    var row = new LeagueRow
                    {
                        Pos    = nodes3[i].ChildNodes[0].InnerText,
                        Name   = nodes3[i].ChildNodes[1].InnerText,
                        Played = nodes3[i].ChildNodes[2].InnerText,
                        Won    = nodes3[i].ChildNodes[3].InnerText,
                        Lost   = nodes3[i].ChildNodes[4].InnerText,
                        Drawn  = nodes3[i].ChildNodes[5].InnerText,
                        For    = nodes3[i].ChildNodes[6].InnerText,
                        Aga    = nodes3[i].ChildNodes[7].InnerText,
                        Points = nodes3[i].ChildNodes[8].InnerText
                    };
                    div3.Division.Add(row);
                }
                tables.Add(div3);

                //get div 4
                var div4 = new Table {
                    League = "Roinn 4", Division = new List <LeagueRow>()
                };
                var link4 = "http://www.gaa.ie/fixtures-and-results/league-tables/football-league-tables/roinn-4/2015/";
                doc = web.Load(link4);
                var nodes4 = doc.DocumentNode.SelectNodes("//table [@id='league_table2']//tr");
                for (var i = 1; i < nodes4.Count; i++)
                {
                    var row = new LeagueRow
                    {
                        Pos    = nodes4[i].ChildNodes[0].InnerText,
                        Name   = nodes4[i].ChildNodes[1].InnerText,
                        Played = nodes4[i].ChildNodes[2].InnerText,
                        Won    = nodes4[i].ChildNodes[3].InnerText,
                        Lost   = nodes4[i].ChildNodes[4].InnerText,
                        Drawn  = nodes4[i].ChildNodes[5].InnerText,
                        For    = nodes4[i].ChildNodes[6].InnerText,
                        Aga    = nodes4[i].ChildNodes[7].InnerText,
                        Points = nodes4[i].ChildNodes[8].InnerText
                    };
                    div4.Division.Add(row);
                }
                tables.Add(div4);
            }
            catch (Exception ex)
            {
                var stackFrame = new StackFrame();
                var methodBase = stackFrame.GetMethod();
                Database.InsertErrorToDb(methodBase.Name, ex.Message, ex.ToString());
            }

            return(tables);
        }
        public List <Table> GetHurlingTables()
        {
            var tables = new List <Table>();

            var          web = new HtmlWeb();
            HtmlDocument doc;

            try
            {
                //get div 1
                var div1a = new Table {
                    League = "Roinn 1A", Division = new List <LeagueRow>()
                };
                var link = "http://www.gaa.ie/fixtures-and-results/league-tables/hurling-league-tables/roinn-1a/2015/";
                doc = web.Load(link);
                var nodes = doc.DocumentNode.SelectNodes("//table [@id='league_table2']//tr");
                for (var i = 1; i < nodes.Count; i++)
                {
                    var row = new LeagueRow
                    {
                        Pos    = nodes[i].ChildNodes[0].InnerText,
                        Name   = nodes[i].ChildNodes[1].InnerText,
                        Played = nodes[i].ChildNodes[2].InnerText,
                        Won    = nodes[i].ChildNodes[3].InnerText,
                        Lost   = nodes[i].ChildNodes[4].InnerText,
                        Drawn  = nodes[i].ChildNodes[5].InnerText,
                        For    = nodes[i].ChildNodes[6].InnerText,
                        Aga    = nodes[i].ChildNodes[7].InnerText,
                        Points = nodes[i].ChildNodes[8].InnerText
                    };
                    div1a.Division.Add(row);
                }
                tables.Add(div1a);

                //get div 1b
                var div1b = new Table {
                    League = "Roinn 1B", Division = new List <LeagueRow>()
                };
                var link1b = "http://www.gaa.ie/fixtures-and-results/league-tables/hurling-league-tables/roinn-1b/2015/";
                doc = web.Load(link1b);
                var nodes2 = doc.DocumentNode.SelectNodes("//table [@id='league_table2']//tr");
                for (var i = 1; i < nodes2.Count; i++)
                {
                    var row = new LeagueRow
                    {
                        Pos    = nodes2[i].ChildNodes[0].InnerText,
                        Name   = nodes2[i].ChildNodes[1].InnerText,
                        Played = nodes2[i].ChildNodes[2].InnerText,
                        Won    = nodes2[i].ChildNodes[3].InnerText,
                        Lost   = nodes2[i].ChildNodes[4].InnerText,
                        Drawn  = nodes2[i].ChildNodes[5].InnerText,
                        For    = nodes2[i].ChildNodes[6].InnerText,
                        Aga    = nodes2[i].ChildNodes[7].InnerText,
                        Points = nodes2[i].ChildNodes[8].InnerText
                    };
                    div1b.Division.Add(row);
                }
                tables.Add(div1b);

                //get div 2a
                var div2a = new Table {
                    League = "Roinn 2A", Division = new List <LeagueRow>()
                };
                var link3 = "http://www.gaa.ie/fixtures-and-results/league-tables/hurling-league-tables/roinn-2a/2015/";
                doc = web.Load(link3);
                var nodes3 = doc.DocumentNode.SelectNodes("//table [@id='league_table2']//tr");
                for (var i = 1; i < nodes3.Count; i++)
                {
                    var row = new LeagueRow
                    {
                        Pos    = nodes3[i].ChildNodes[0].InnerText,
                        Name   = nodes3[i].ChildNodes[1].InnerText,
                        Played = nodes3[i].ChildNodes[2].InnerText,
                        Won    = nodes3[i].ChildNodes[3].InnerText,
                        Lost   = nodes3[i].ChildNodes[4].InnerText,
                        Drawn  = nodes3[i].ChildNodes[5].InnerText,
                        For    = nodes3[i].ChildNodes[6].InnerText,
                        Aga    = nodes3[i].ChildNodes[7].InnerText,
                        Points = nodes3[i].ChildNodes[8].InnerText
                    };
                    div2a.Division.Add(row);
                }
                tables.Add(div2a);

                //get div 2b
                var div2b = new Table {
                    League = "Roinn 2B", Division = new List <LeagueRow>()
                };
                var link4 = "http://www.gaa.ie/fixtures-and-results/league-tables/hurling-league-tables/roinn-2b/2015/";
                doc = web.Load(link4);
                var nodes4 = doc.DocumentNode.SelectNodes("//table [@id='league_table2']//tr");
                for (var i = 1; i < nodes4.Count; i++)
                {
                    var row = new LeagueRow
                    {
                        Pos    = nodes4[i].ChildNodes[0].InnerText,
                        Name   = nodes4[i].ChildNodes[1].InnerText,
                        Played = nodes4[i].ChildNodes[2].InnerText,
                        Won    = nodes4[i].ChildNodes[3].InnerText,
                        Lost   = nodes4[i].ChildNodes[4].InnerText,
                        Drawn  = nodes4[i].ChildNodes[5].InnerText,
                        For    = nodes4[i].ChildNodes[6].InnerText,
                        Aga    = nodes4[i].ChildNodes[7].InnerText,
                        Points = nodes4[i].ChildNodes[8].InnerText
                    };
                    div2b.Division.Add(row);
                }
                tables.Add(div2b);

                //get div 3a
                var div3a = new Table {
                    League = "Roinn 3A", Division = new List <LeagueRow>()
                };
                var link5 = "http://www.gaa.ie/fixtures-and-results/league-tables/hurling-league-tables/roinn-3a/2015/";
                doc = web.Load(link5);
                var nodes5 = doc.DocumentNode.SelectNodes("//table [@id='league_table2']//tr");
                for (var i = 1; i < nodes5.Count; i++)
                {
                    var row = new LeagueRow
                    {
                        Pos    = nodes5[i].ChildNodes[0].InnerText,
                        Name   = nodes5[i].ChildNodes[1].InnerText,
                        Played = nodes5[i].ChildNodes[2].InnerText,
                        Won    = nodes5[i].ChildNodes[3].InnerText,
                        Lost   = nodes5[i].ChildNodes[4].InnerText,
                        Drawn  = nodes5[i].ChildNodes[5].InnerText,
                        For    = nodes5[i].ChildNodes[6].InnerText,
                        Aga    = nodes5[i].ChildNodes[7].InnerText,
                        Points = nodes5[i].ChildNodes[8].InnerText
                    };
                    div3a.Division.Add(row);
                }
                tables.Add(div3a);

                //get div 3b
                var div3b = new Table {
                    League = "Roinn 3B", Division = new List <LeagueRow>()
                };
                var link6 = "http://www.gaa.ie/fixtures-and-results/league-tables/hurling-league-tables/roinn-3b/2015/";
                doc = web.Load(link6);
                var nodes6 = doc.DocumentNode.SelectNodes("//table [@id='league_table2']//tr");
                for (var i = 1; i < nodes6.Count; i++)
                {
                    var row = new LeagueRow
                    {
                        Pos    = nodes6[i].ChildNodes[0].InnerText,
                        Name   = nodes6[i].ChildNodes[1].InnerText,
                        Played = nodes6[i].ChildNodes[2].InnerText,
                        Won    = nodes6[i].ChildNodes[3].InnerText,
                        Lost   = nodes6[i].ChildNodes[4].InnerText,
                        Drawn  = nodes6[i].ChildNodes[5].InnerText,
                        For    = nodes6[i].ChildNodes[6].InnerText,
                        Aga    = nodes6[i].ChildNodes[7].InnerText,
                        Points = nodes6[i].ChildNodes[8].InnerText
                    };
                    div3b.Division.Add(row);
                }
                tables.Add(div3b);
            }
            catch (Exception ex)
            {
                var stackFrame = new StackFrame();
                var methodBase = stackFrame.GetMethod();
                Database.InsertErrorToDb(methodBase.Name, ex.Message, ex.ToString());
            }

            return(tables);
        }