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