private static Nhl_Players_Rtss_Skater MapHtmlRowToModel(HtmlNode row, NhlSeasonType nhlSeasonType, int year)
{
HtmlNodeCollection tdNodes = row.SelectNodes(@"./td");
Nhl_Players_Rtss_Skater model = new Nhl_Players_Rtss_Skater();
model.NhlSeasonType = nhlSeasonType;
model.Year = year;
model.Number = 0;
model.Name = tdNodes[1].InnerText;
model.Team = tdNodes[2].InnerText;
model.Position = tdNodes[3].InnerText;
model.GamesPlayed = ConvertStringToInt(tdNodes[4].InnerText);
model.Hits = ConvertStringToInt(tdNodes[5].InnerText);
model.BlockedShots = ConvertStringToInt(tdNodes[6].InnerText);
model.MissedShots = ConvertStringToInt(tdNodes[7].InnerText);
model.Giveaways = ConvertStringToInt(tdNodes[8].InnerText);
model.Takeaways = ConvertStringToInt(tdNodes[9].InnerText);
model.FaceoffsWon = ConvertStringToInt(tdNodes[10].InnerText);
model.FaceoffsLost = ConvertStringToInt(tdNodes[11].InnerText);
model.FaceoffsTaken = ConvertStringToInt(tdNodes[12].InnerText);
model.FaceoffWinPercentage = Convert.ToDouble(tdNodes[13].InnerText);
model.PercentageOfTeamFaceoffsTaken = Convert.ToDouble(tdNodes[14].InnerText);
model.Shots = ConvertStringToInt(tdNodes[15].InnerText);
model.Goals = ConvertStringToInt(tdNodes[16].InnerText);
model.ShootingPercentage = Convert.ToDouble(tdNodes[17].InnerText);
return(model);
}
private static List <Nhl_Players_Rtss_Skater> UpdateSeason(int year, NhlSeasonType nhlSeasonType, bool saveToDb)
{
// Get HTML rows
NhlPlayersRtssSkater nhl = new NhlPlayersRtssSkater();
List <HtmlNode> rows = nhl.GetResultsForSeasonType(year, nhlSeasonType);
// Parse into a list
List <Nhl_Players_Rtss_Skater> results = new List <Nhl_Players_Rtss_Skater>();
foreach (HtmlNode row in rows)
{
Nhl_Players_Rtss_Skater result = NhlPlayersRtssSkater.MapHtmlRowToModel(row, nhlSeasonType, year);
if (null != result)
{
results.Add(result);
}
}
// Update DB
if (saveToDb)
{
NhlPlayersRtssSkater.AddOrUpdateDb(results);
}
return(results);
}
