compil3’s gists

compil3 / Converter.cs

Created October 31, 2013 06:59

	using System;
	using System.Collections.Generic;
	using System.IO;
	using System.Linq;
	using System.Net.Mime;
	using System.Text;
	using System.Threading.Tasks;
	using System.Xml.Linq;
	using HtmlAgilityPack;
	using System.Xml;

compil3 / Converter.cs

Created November 1, 2013 19:35

	public void ParseHtml()
	{
	var htmlDoc = new HtmlDocument();
	htmlDoc.LoadHtml(Source);
	var cells = htmlDoc.DocumentNode
	.SelectNodes("/html/body/div[2]/div[4]/div/div[3]/table/tbody/tr/td") // use the right XPath rather than looping manually
	.Select(node => node.InnerText.Trim())
	.ToList();
	var elementNames = new[] { "Name", "Team", "Pos", "GP", "G", "A", "Pts", "PlusMinus", "PIM", "PP", "SH", "GW", "OT", "Shots", "ShotPctg", "TOIPerGame", "ShiftsPerGame", "FOWinPctg" };
	var xmlDoc = new XElement("Stats", new XAttribute("Date", DateTime.Now.ToShortDateString()),

compil3 / Converter.cs

Created November 1, 2013 19:35

	public void ParseHtml()
	{
	var htmlDoc = new HtmlDocument();
	htmlDoc.LoadHtml(Source);
	var cells = htmlDoc.DocumentNode
	.SelectNodes("/html/body/div[2]/div[4]/div/div[3]/table/tbody/tr/td") // use the right XPath rather than looping manually
	.Select(node => node.InnerText.Trim())
	.ToList();
	var elementNames = new[] { "Name", "Team", "Pos", "GP", "G", "A", "Pts", "PlusMinus", "PIM", "PP", "SH", "GW", "OT", "Shots", "ShotPctg", "TOIPerGame", "ShiftsPerGame", "FOWinPctg" };
	var xmlDoc = new XElement("Stats", new XAttribute("Date", DateTime.Now.ToShortDateString()),

compil3 / Converter.cs

Created November 1, 2013 19:36

	public void ParseHtml()
	{
	var htmlDoc = new HtmlDocument();
	htmlDoc.LoadHtml(Source);
	var cells = htmlDoc.DocumentNode
	.SelectNodes("/html/body/div[2]/div[4]/div/div[3]/table/tbody/tr[THIS tr changes to tr[1] etc for each xpath needed]/td") // use the right XPath rather than looping manually
	.Select(node => node.InnerText.Trim())
	.ToList();
	var elementNames = new[] { "Name", "Team", "Pos", "GP", "G", "A", "Pts", "PlusMinus", "PIM", "PP", "SH", "GW", "OT", "Shots", "ShotPctg", "TOIPerGame", "ShiftsPerGame", "FOWinPctg" };
	var xmlDoc = new XElement("Stats", new XAttribute("Date", DateTime.Now.ToShortDateString()),

compil3 / Converter.cs

Created November 4, 2013 06:29

	public void ParseHtml()
	{
	var htmlDoc = new HtmlDocument();
	htmlDoc.LoadHtml(Source);

	var cells = htmlDoc.DocumentNode
	.SelectNodes("//table[@class='data stats']/tbody/tr/td") // can't get it to loop
	.Select(node => node.InnerText.Trim())
	.ToList();

compil3 / Converter.cs

Created November 4, 2013 06:37

	var cells = htmlDoc.DocumentNode
	.SelectNodes ("//table[@class='data stats']/tbody/tr/td") OfType<XmlNode>() // can't get it to loop
	.Select(node => node.InnerText.Trim())
	.ToList();

compil3 / Converter.cs

Created November 4, 2013 07:42

	public void ParseHtml()
	{
	var htmlDoc = new HtmlDocument();
	htmlDoc.LoadHtml(Source);

	var cells = htmlDoc.DocumentNode
	.SelectNodes("//table[@class='data stats']/tbody/tr/td").OfType<XmlNode>()// can't get it to loop
	.Select(node => node.InnerText.Trim())
	.ToList();

compil3 / GetAbbreviation.cs

Created November 5, 2013 19:09

	public void ParseTeams()
	{
	var htmlDoc = new HtmlDocument();
	htmlDoc.LoadHtml(Source);

	var teamName = htmlDoc.DocumentNode
	.SelectNodes("//select[@id='team']//option[position() > 1]")
	.Select(node => node.InnerText.Trim())
	.ToList();

compil3 / GetAbbreviation.cs

Last active December 27, 2015 12:19

	public void ParseTeams()
	{
	var htmlDoc = new HtmlDocument();
	htmlDoc.LoadHtml(Source);

	var teamName = htmlDoc.DocumentNode
	.SelectNodes("//select[@id='team']//option[position() > 1]")
	.Select(node => node.InnerText.Trim())
	.ToList();

compil3 / GetAbbreviation.cs

Created November 6, 2013 04:48

	public void ParseTeams()
	{
	HtmlAgilityPack.HtmlNode.ElementsFlags.Remove("option");

	var htmlDoc = new HtmlDocument();
	htmlDoc.OptionFixNestedTags = true;
	htmlDoc.LoadHtml(Source);

	var teamName = htmlDoc.DocumentNode
	.SelectNodes("//select[@id='team']//option[position() > 1]")