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