Card

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

namespace ROD_Deck_Builder
{
    public class GetPage
    {
        public static HtmlAgilityPack.HtmlNode GetPageData(string url)
        {

            string weburl = url;
            WebClient dl = new WebClient();
            dl.Encoding = Encoding.UTF8;
            string page = dl.DownloadString(weburl);
            HtmlDocument mydoc = new HtmlDocument();
            mydoc.LoadHtml(page);

            HtmlNode table = mydoc.DocumentNode.SelectSingleNode("//table[@class='witiable sortable']");
            var tableHeaders = table.SelectNodes("tr[th]/th");
            foreach (var header in tableHeaders)
            {
                string columnName = header.InnerText.Trim();
            }

            var tableRows = table.SelectNodes("tr").OfType<HtmlNode>().Skip(1);
            foreach (var row in tableRows)
            {
                Cards cardstable = new Cards();
                //string singleLine;
                //string[] splitApart = singleLine.Split(',');
                var rowcolumns = row.SelectNodes("td");
                foreach (var column in rowcolumns)
                {
                    string columnValue = column.InnerText.Trim();
                }
                    Card item = new Card();
                    item.Rarity = Convert.ToString(rowcolumns[0].InnerText).TrimEnd('\r', '\n');
                    item.Name = Convert.ToString(rowcolumns[1].InnerText).TrimEnd('\r', '\n');
                    item.Realm = Convert.ToString(rowcolumns[2].InnerText).TrimEnd('\r', '\n');
                    item.Faction = Convert.ToString(rowcolumns[3].InnerText).TrimEnd('\r', '\n');
                    item.MaxAtk = Convert.ToString(rowcolumns[4].InnerText).TrimEnd('\r', '\n');
                    item.MaxDef = Convert.ToString(rowcolumns[5].InnerText).TrimEnd('\r', '\n');
                    item.Total = Convert.ToInt32(rowcolumns[6].InnerText);
                    item.Cost = Convert.ToInt32(rowcolumns[7].InnerText);
                    item.AttEff = Convert.ToInt32(rowcolumns[8].InnerText);
                    item.DefEff = Convert.ToInt32(rowcolumns[9].InnerText);
                    item.OverallEff = Convert.ToInt32(rowcolumns[10].InnerText);
                    item.Skill = Convert.ToString(rowcolumns[11].InnerText).TrimEnd('\r', '\n');
                    item.EventSkl1 = Convert.ToString(rowcolumns[12].InnerText).TrimEnd('\r', '\n');
                    item.EventSkl2 = Convert.ToString(rowcolumns[13].InnerText).TrimEnd('\r', '\n');
                    cardstable.TableData.Add(item);
            }
           return table;
        }
    }
}