static void getD2PassSites() { AVSyncerDataContext dc = new AVSyncerDataContext(); HtmlDocument doc = new HtmlDocument(); doc.Load(@"..\..\sites.html", Encoding.UTF8); var sitesNodes = doc.DocumentNode.CssSelect(".list-siteinfo"); foreach (var siteinfo in sitesNodes) { try { var maker = new Maker(); maker.name = siteinfo.CssSelect(".sitename-label").First().InnerText.Trim(); maker.description = siteinfo.CssSelect(".comment").First().InnerText.Trim(); maker.url = siteinfo.CssSelect(".sitename-label").First().GetNextSibling("td").CssSelect("a").First().Attributes["href"].Value; dc.Maker.InsertOnSubmit(maker); dc.SubmitChanges(); } catch (Exception e) { System.Diagnostics.Debug.Write(e.Message + "\n" + e.StackTrace + "\n"); continue; } } System.Diagnostics.Debug.Write("\n"); }
static void desJSON(string json) { try { AVSyncerDataContext dc = new AVSyncerDataContext(); Dictionary <string, int> MakerList = new Dictionary <string, int>(); var tt = json.Substring(6, json.Length - 9); JavaScriptSerializer ser = new JavaScriptSerializer(); Item xx = ser.Deserialize <Item>(tt); foreach (var review in xx.reviews) { if (!MakerList.ContainsKey(review.site_name)) { MakerList.Add(review.site_name, 0); } } //foreach (var key in MakerList.Keys) { // Maker maker = new Maker(); // maker.name = key; // maker.description = key; // dc.Maker.InsertOnSubmit(maker); // dc.SubmitChanges(); //} System.Diagnostics.Debug.Write(""); } catch (Exception e) { System.Diagnostics.Debug.Write(e.StackTrace); } }