public List<Update> GetUpdates(string url)
        {
            var updates = new List<Update>();
            var ut = new UpdateTbl();
            ut.Id = GetId().Id;
            url = "http://www.gaa.ie/modules/live_match.php?id=" + ut.Id;
            var texts = new List<string>();
            var time = "";
            var score = "";
            var web = new HtmlWeb();
            HtmlDocument doc;
            try
            {
                var link = url;
                doc = web.Load(link);

                var nodes = doc.DocumentNode.SelectNodes("//div[@class='mt_updates']");

                //var count = nodes.Count();
                var cont = true;
                foreach (var node in nodes)
                {
                    cont = true;
                    time = WebUtility.HtmlDecode(node.ChildNodes[0].InnerText);
                    time = Regex.Replace(time,
                        @"\t|\n|\r|<li>|</li>|<ul>|</ul>|<b>|<br>|</b>|<em>|</em>|<u>|</u>|<strong>|</strong>|<p>|</p>",
                        "");

                    var attr = node.ChildNodes;
                    foreach (var child in attr.Where(a => a.Name == "h4"))
                    {
                        score = WebUtility.HtmlDecode(child.InnerText);
                        score = Regex.Replace(score,
                            @"\t|\n|\r|<li>|</li>|<ul>|</ul>|<b>|<br>|</b>|<em>|</em>|<u>|</u>|<strong>|</strong>|<p>|</p>",
                            "");
                    }
                    foreach (var child in attr.Where(a => a.Name == "p"))
                    {
                        var text = "";
                        text = WebUtility.HtmlDecode(child.InnerHtml);
                        text = Regex.Replace(text,
                            @"\t|\r|<li>|</li>|<ul>|</ul>|<b>|<br>|</b>|<em>|</em>|<u>|</u>|<strong>|</strong>|<p>|</p>",
                            "");

                        if (text == "") cont = false;
                        if (text.Contains("Preview")) cont = false;
                        if (text.Contains("tweet_box")) cont = false;
                        if (text.Contains("youtube_embed"))
                            //cont = false;
                        {
                            var linkText = text;
                            var id = "";
                            var fullLength = linkText.Length;
                            var i = linkText.LastIndexOf(".com/embed/", StringComparison.Ordinal);
                            var start = i + 11;
                            id = linkText.Substring(start, fullLength - start);
                            id = id.Substring(0, id.IndexOf('"'));
                            text = "View Video... " + id;
                        }
                        texts.Add(text);
                    }
                    if (texts.Count > 0)
                    {
                        var update = new Update();
                        update.Text = new List<string>();
                        foreach (var s in texts)
                        {
                            update.Text.Add(s);
                        }
                        update.Time = time;
                        update.Score = score;
                        texts.Clear();
                        if (cont)
                        {
                            updates.Add(update);
                        }
                        score = "";
                        time = "";
                    }
                }
            }
            catch (Exception ex)
            {
                var stackFrame = new StackFrame();
                var methodBase = stackFrame.GetMethod();
                // Database.InsertErrorToDb(methodBase.Name, ex.Message, ex.ToString());
            }

            return updates;
        }
        private UpdateTbl GetId()
        {
            var ut = new UpdateTbl();
            try
            {
                _connection = new MySqlConnection(ConnectionString);
                _connection.Open();

                var query = string.Format("SELECT * from db1305421_wpdev.UpdateTbl where Id like '1';");

                using (var cmd = new MySqlCommand(query, _connection))
                {
                    using (var r = cmd.ExecuteReader())
                    {
                        while (r.Read())
                        {
                            ut.Id = r.GetInt32("UpdateID");
                            ut.Date = DateTime.Parse(r.GetString("Date"));
                        }
                    }
                }
            }

            catch (Exception ex)
            {
                var sf = new StackFrame();
                var methodBase = sf.GetMethod();
                Database.InsertErrorToDb(methodBase.Name, ex.Message, ex.ToString());
            }
            finally
            {
                _connection.Close();
            }

            return ut;
        }