private List <NBAStanding> GetStandings(HtmlDocument doc) { List <NBAStanding> nsList = new List <NBAStanding>(); HtmlNode dataNode = doc.DocumentNode.SelectSingleNode(XPath); for (int i = 1; i <= 30; i++) { HtmlNodeCollection data = dataNode.SelectNodes(string.Concat("//tr[", i, "]/td")); NBAStanding ns = new NBAStanding(); ns.TeamName = data[0].InnerText; ns.W = data[1].InnerText.CheckIntegerNULLS(); ns.L = data[2].InnerText.CheckIntegerNULLS(); ns.PCT = data[3].InnerText.CheckDoubleNULLS(); ns.GB = data[4].InnerText.CheckFloatNULLS(); ns.Home = data[5].InnerText; ns.HomeWin = Extensions.ExtractWin(ns.Home); ns.HomeLoss = Extensions.ExtractLoss(ns.Home); ns.Away = data[6].InnerText; ns.AwayWin = Extensions.ExtractWin(ns.Away); ns.AwayLoss = Extensions.ExtractLoss(ns.Away); ns.DIV = data[7].InnerText; ns.DIVWin = Extensions.ExtractWin(ns.DIV); ns.DIVLoss = Extensions.ExtractLoss(ns.DIV); ns.CONF = data[8].InnerText; ns.CONFWin = Extensions.ExtractWin(ns.CONF); ns.CONFLoss = Extensions.ExtractLoss(ns.CONF); ns.PPG = data[9].InnerText; ns.OPP_PPG = data[10].InnerText; ns.DIFF = data[11].InnerText; ns.STRK = data[12].InnerText; ns.L10 = data[13].InnerText; nsList.Add(ns); } return(nsList); }
private static IDbDataParameter[] CreateParameters(NBAStanding s) { IDbDataParameter[] parameters = { new SqlParameter("@TeamName", SqlDbType.NVarChar, 150), new SqlParameter("@W", SqlDbType.Int, 4), new SqlParameter("@L", SqlDbType.Int, 4), new SqlParameter("@PCT", SqlDbType.Float), new SqlParameter("@GB", SqlDbType.Int, 4), new SqlParameter("@HomeWin", SqlDbType.NChar, 10), new SqlParameter("@HomeLoss", SqlDbType.NChar, 10), new SqlParameter("@AwayWin", SqlDbType.NChar, 10), new SqlParameter("@AwayLoss", SqlDbType.NChar, 10), new SqlParameter("@DIVWin", SqlDbType.NChar, 10), new SqlParameter("@DIVLoss", SqlDbType.NChar, 10), new SqlParameter("@CONFWin", SqlDbType.NChar, 10), new SqlParameter("@CONFLoss", SqlDbType.NChar, 10), new SqlParameter("@PPG", SqlDbType.NChar, 10), new SqlParameter("@OPP_PPG", SqlDbType.NChar, 10), new SqlParameter("@DIFF", SqlDbType.NChar, 10), new SqlParameter("@STRK", SqlDbType.NChar, 10), new SqlParameter("@L10", SqlDbType.NChar, 10) }; parameters[0].Value = s.TeamName; parameters[1].Value = s.W; parameters[2].Value = s.L; parameters[3].Value = s.PCT; parameters[4].Value = s.GB; parameters[5].Value = s.HomeWin; parameters[6].Value = s.HomeLoss; parameters[7].Value = s.AwayWin; parameters[8].Value = s.AwayLoss; parameters[9].Value = s.DIVWin; parameters[10].Value = s.DIVLoss; parameters[11].Value = s.CONFWin; parameters[12].Value = s.CONFLoss; parameters[13].Value = s.PPG; parameters[14].Value = s.OPP_PPG; parameters[15].Value = s.DIFF; parameters[16].Value = s.STRK; parameters[17].Value = s.L10; return(parameters); }