private void parseLottery(string tableContent) { var columns = new List<List<string>>(); XElement table = XElement.Parse(tableContent); XElement headings = table.Elements("tr").First(); Lottery lottery = new Lottery(); foreach(XElement th in headings.Elements("th")) { string heading = th.Value; var column = new List<string>{heading}; columns.Add(column); lottery.Title = heading; } int row = 0; foreach(XElement tr in table.Elements("tr").Skip(1)) { int i = 0; foreach(XElement td in tr.Elements("td")) { string value = td.Value; if (i != 0) continue; switch (row) { case 0: lottery.Jackpots = value; break; case 1: lottery.First = value; break; case 2: lottery.Second = value; break; case 3: lottery.Third = value; break; case 4: lottery.Fourth = value; break; case 5: lottery.Fifth = value; break; case 6: lottery.Six = value; break; case 7: lottery.Seven = value; break; } columns[i].Add(value); i++; } row++; } LotteryRepository.Save(lottery); }
private void parseLottery(string tableContent) { Lottery lottery = new Lottery(); string html_table = "<table>" + tableContent + "</table>"; lottery.Html = html_table; XElement table = XElement.Parse(html_table); XElement headings = table.Elements("tr").First(); foreach(XElement th in headings.Elements("th")) { string heading = th.Value; lottery.Title = heading; } int row = 0; foreach(XElement tr in table.Elements("tr").Skip(1)) { int i = -1; foreach(XElement td in tr.Elements("td")) { i++; string value = td.Value; if (i == 0) continue; switch (row) { case 0: lottery.Jackpots = value; break; case 1: lottery.First = value; break; case 2: lottery.Second = value; break; case 3: lottery.Third = value; break; case 4: lottery.Fourth = value; break; case 5: lottery.Fifth = value; break; case 6: lottery.Six = value; break; case 7: lottery.Seven = value; break; } } row++; } lottery.JackpotsDate = DateTime.Now; lottery.Id = Utils.GenerateRandomId(); LotteryRepository.Save(lottery); }
private void parseLottery(string tableContent) { var columns = new List<List<string>>(); XElement table = XElement.Parse(tableContent); XElement headings = table.Elements("tr").First(); Lottery lottery = new Lottery(); foreach(XElement th in headings.Elements("th")) { string heading = th.Value; var column = new List<string>{heading}; columns.Add(column); lottery.Title = heading; } foreach(XElement tr in table.Elements("tr").Skip(1)) { int i = 0; foreach(XElement td in tr.Elements("td")) { string value = td.Value; switch (i) { case 0: lottery.Jackpots = value; break; } columns[i].Add(value); i++; } } }
private void parseLottery(string tableContent) { Lottery lottery = new Lottery(); lottery.Html = tableContent; XElement table = XElement.Parse(tableContent); XElement headings = table.Elements("tr").First(); foreach (XElement th in headings.Elements("th")) { string heading = th.Value; lottery.Title = heading; } int row = 0; foreach (XElement tr in table.Elements("tr").Skip(1)) { int i = -1; foreach (XElement td in tr.Elements("td")) { i++; string value = td.Value; if (i == 0) continue; switch (row) { case 0: lottery.Jackpots = value; break; case 1: lottery.First = value; break; case 2: lottery.Second = value; break; case 3: lottery.Third = value; break; case 4: lottery.Fourth = value; break; case 5: lottery.Fifth = value; break; case 6: lottery.Six = value; break; case 7: lottery.Seven = value; break; } } row++; } lottery.JackpotsDate = DateTime.Now; lottery.Id = Utils.GenerateRandomId(); Lottery checkLottery = LotteryRepository.FindOneBy(l => l.JackpotsDate == DateTime.Now); if (checkLottery == null) LotteryRepository.Save(lottery); else { lottery.Id = checkLottery.Id; lottery.JackpotsDate = checkLottery.JackpotsDate; LotteryRepository.Update(lottery); } }