public static string ParseWebContent(string Url)
{
var web = new HtmlWeb();
var document = web.Load(Url);
var page = document.DocumentNode;
using (var db = new TheFishEntities())
{ //loop through all div tags with item css class
db.Database.ExecuteSqlCommand("TRUNCATE TABLE FdaCalendar");
foreach (var item in page.QuerySelectorAll("table.sortable>tbody>tr"))
{
var i = 0;
var calendar = new CatchTheFish.DbEntities.FdaCalendar();
foreach (var subItem in item.QuerySelectorAll("td"))
{
var str = subItem.InnerText;
switch (i)
{
case 0:
calendar.Symbol = str;
break;
case 1:
decimal price;
Decimal.TryParse(str, System.Globalization.NumberStyles.AllowDecimalPoint, null, out price);
calendar.Price = price;
break;
case 2:
calendar.MarketCapital = str;
break;
case 3:
calendar.Type = str;
break;
case 4:
DateTime dt;
if (DateTime.TryParse(str, out dt))
{
calendar.CatalystDate = dt;
}
break;
case 5:
calendar.CatelystNotes = str;
break;
}
i++;
}
calendar.LastMoidfiedDate = DateTime.Now;
db.FdaCalendars.Add(calendar);
db.SaveChanges();
}
}
return("");
}
public static string ParseWebContent(string Url)
{
var web = new HtmlWeb();
var document = web.Load(Url);
var page = document.DocumentNode;
using(var db = new TheFishEntities())
{ //loop through all div tags with item css class
db.Database.ExecuteSqlCommand("TRUNCATE TABLE FdaCalendar");
foreach(var item in page.QuerySelectorAll("table.sortable>tbody>tr"))
{
var i = 0;
var calendar = new CatchTheFish.DbEntities.FdaCalendar();
foreach(var subItem in item.QuerySelectorAll("td"))
{
var str = subItem.InnerText;
switch(i)
{
case 0:
calendar.Symbol = str;
break;
case 1:
decimal price;
Decimal.TryParse(str, System.Globalization.NumberStyles.AllowDecimalPoint, null, out price);
calendar.Price = price;
break;
case 2:
calendar.MarketCapital = str;
break;
case 3:
calendar.Type = str;
break;
case 4:
DateTime dt;
if(DateTime.TryParse(str, out dt))
{
calendar.CatalystDate = dt;
}
break;
case 5:
calendar.CatelystNotes = str;
break;
}
i++;
}
calendar.LastMoidfiedDate = DateTime.Now;
db.FdaCalendars.Add(calendar);
db.SaveChanges();
}
}
return "";
}