public static void Demo() { var bolService = new PostgresDAL.PostgresServices(); //bolService.DemoInertVietLott(); bolService.GetListByAmount(); }
public static void ImportOnePageVietlottVN(int pageId) { try { var bolService = new PostgresDAL.PostgresServices(); List <PGVietLottVN> lst = new List <PGVietLottVN>(); var web = new HtmlWeb(); string strURL = string.Format("http://www.vietlott.vn/vi/trung-thuong/ket-qua-trung-thuong/mega-6-45/winning-numbers/?p={0}", pageId); var doc = web.Load(strURL); //TODO: Check valid var divContainer = doc.DocumentNode.SelectSingleNode("//table[@class = 'table table-striped']"); if (divContainer == null) { Console.WriteLine("Nothing to import ^_^"); return; } foreach (HtmlNode childNode in divContainer.ChildNodes) { if (childNode.Name.Equals("tbody")) { if (childNode.HasChildNodes) { foreach (HtmlNode mychildNode in childNode.ChildNodes) { if (mychildNode.Name.Equals("tr")) { Console.WriteLine(mychildNode.InnerText); var obj = new PGVietLottVN(); foreach (var tdChildNodes in mychildNode.ChildNodes) { if (tdChildNodes.Name.Equals("td")) { if (tdChildNodes.Attributes["style"] != null) { obj.StrNumber = tdChildNodes.InnerText; if (tdChildNodes.HasChildNodes) { foreach (HtmlNode spanChildNode in tdChildNodes.ChildNodes) { if (spanChildNode.Name.Equals("span")) { string strNumber = spanChildNode.InnerText; obj.ListNumbers.Add(strNumber); } } } } else { obj.DatePizeString = tdChildNodes.InnerText; } } } lst.Add(obj); } } } } } if (lst.Count > 0) { bolService.ImportVietLottPage(lst); } Console.WriteLine("Finish page ^_^: " + strURL); } catch (Exception ex) { Console.WriteLine(ex.ToString()); } }