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;
}