using System;

using System.Xml;

using System.Linq;

//using System.Collections;

using System.Collections.Generic;

using HtmlAgilityPack;

//using Ganss.XSS;

public class Program

{

    public static void Main()

    {

        var app = new App();

        app.process();

    }

    public class App

    {

        public class Tipo

        {

            public long id { get; set; }

            public string nombre { get; set; }

            public string json { get; set; }

        }

        public class SubTipoDeFondo

        {

            public long id { get; set; }

            public string nombre { get; set; }

            public Tipo tipo { get; set; }

            public string json { get; set; }

        }

        public class Valor

        {

            public long id { get; set; }

            public Decimal valor { get; set; }

            public SubTipoDeFondo tipo { get; set; }

            public Tipo tipoValor { get; set; }

            public string json { get; set; }

        }

        public IList<Tipo> tiposDeFondo { get; set; }

        public IList<Tipo> tiposDeValores { get; set; }

        public IList<SubTipoDeFondo> subTiposDeFondo { get; set; }

        public IList<Valor> valores { get; set; }

        public DateTime? date { get; set; }

        public App()

        {

            tiposDeFondo = new List<Tipo>();

            tiposDeValores = new List<Tipo>();

            subTiposDeFondo = new List<SubTipoDeFondo>();

            valores = new List<Valor>();

            date = null;

        }

        public void process()

        {

            var app = new App();

            var htmlString = getSanitizedHtml(@"https://www.santanderrio.com.ar/ConectorPortalStore/Rendimiento");

            var nodesStringList = htmlString.Split('\n');

            date = completeDate(nodesStringList);

            completeLists(nodesStringList);

            printData();

        }

        public string getRawHtml(string url)

        {

            HtmlWeb web = new HtmlWeb();

            var htmlDoc = web.Load(url);

            return htmlDoc.DocumentNode.InnerHtml;

        }

        public string getSanitizedHtml(string url)

        {

            var rawHtml = getRawHtml(url);

            //var sanitizer = new HtmlSanitizer();

            return rawHtml;//sanitizer.Sanitize(rawHtml);

        }

        public DateTime completeDate(string[] url)

        {

            DateTime temp = DateTime.Now;

            var dateLine = url.Where(x => x.Contains("Rendimiento")).FirstOrDefault();

            var dateString = dateLine.Split(' ').Where(x => DateTime.TryParse(x, out temp)).FirstOrDefault();

            if (dateString == string.Empty)

                throw new Exception ("No se ha podido extraer la fecha");

            return temp;

        }

        public void completeLists(string[] url)

        {

            int itemValorColumn = 2;

            for(long i = 0; i < url.Count(); i++)

            {

                var line = url[i].Trim();

                if(line.StartsWith("<th rowspan=\"2\">"))

                {

                    var lenght = line.Length;

                    var closeIndex = line.IndexOf('>');

                    var lastOpenIndex = line.LastIndexOf('<');

                    var text = line.Substring(closeIndex + 1, lenght - closeIndex - (lenght - lastOpenIndex) - 1).Trim();

                    if (!tiposDeValores.Any(x => x.nombre == text))

                    {

                        var itemTDV = new Tipo();

                        itemTDV.id = tiposDeValores.Count() + 1;

                        itemTDV.nombre = text;

                        tiposDeValores.Add(itemTDV);

                    }

                }

                if(line.StartsWith("<th colspan=\"6\" class=\"th2\" height=\"20\">") && !line.Contains("Rendimientos"))

                {

                    var itemTDF = new Tipo();

                    itemTDF.id = tiposDeFondo.Count() + 1;

                    var lenght = line.Length;

                    var closeIndex = line.IndexOf('>');

                    var lastOpenIndex = line.LastIndexOf('<');

                    itemTDF.nombre = line.Substring(closeIndex + 1, lenght - closeIndex - (lenght - lastOpenIndex) - 1).Trim();

                    tiposDeFondo.Add(itemTDF);

                }

                if(line.StartsWith("<td style='border-width:0px; padding: 1px; background-color:transparent;' nowrap=\"\" align=\"left\" width=\"90%\">"))

                {

                    var itemSTDF = new SubTipoDeFondo();

                    itemSTDF.id = subTiposDeFondo.Count() + 1;

                    itemSTDF.nombre = url[i+1].Trim();

                    itemSTDF.tipo = tiposDeFondo.Where(x => x.id == tiposDeFondo.Count()).Single();

                    subTiposDeFondo.Add(itemSTDF);

                }

                if(line.StartsWith("<td align=\"right\" class=\"\">"))

                {

                    var itemV = new Valor();

                    itemV.id = valores.Count() + 1;

                    itemV.tipoValor = tiposDeValores.Where(x => x.id == itemValorColumn).Single();

                    itemV.tipo = subTiposDeFondo.Where(x => x.id == subTiposDeFondo.Count()).Single();

                    var lenght = line.Length;

                    var closeIndex = line.IndexOf('>');

                    var lastOpenIndex = line.LastIndexOf('<');

                    var valueText = line.Substring(closeIndex + 1, lenght - closeIndex - (lenght - lastOpenIndex) - 1).Trim();

                    bool isNegative = valueText.Contains('(') || valueText.Contains(')');

                    valueText = valueText.Replace("(","").Replace(")","").Replace(".","").Replace(",",".");

                    try

                    {

                        itemV.valor = Convert.ToDecimal(valueText);

                    }

                    catch (Exception)

                    {

                        Console.WriteLine(valueText);

                    }

                    if (isNegative)

                        itemV.valor *= -1;

                    valores.Add(itemV);

                    itemValorColumn++;

                }

                if (itemValorColumn == 7)

                    itemValorColumn = 2;

            }

        }

        public void printData()

        {

            var strList = new List<String>();

            strList.Clear();

            foreach (var item in tiposDeValores)

            {

                var text = "{\"id\":" + item.id.ToString() + ",\"nombre\":\"" + item.nombre + "\"}";

                strList.Add(text);

                item.json = text;

            }

            var jsonTDV = String.Join(",",strList.ToArray());

            strList.Clear();

            foreach (var item in tiposDeFondo)

            {

                var text = "{\"id\":" + item.id.ToString() + ",\"nombre\":\"" + item.nombre + "\"}";

                strList.Add(text);

                item.json = text;

            }

            var jsonTDF = String.Join(",",strList.ToArray());

            strList.Clear();

            foreach (var item in subTiposDeFondo)

            {

                var text = "{\"id\":" + item.id.ToString() + ",\"nombre\":\"" + item.nombre 

                            + "\",\"tipo\":" + item.tipo.json + "}";

                strList.Add(text);

                item.json = text;

            }

            var jsonSTDF = String.Join(",",strList.ToArray());

            strList.Clear();

            foreach (var item in valores)

            {

                var text = "{\"id\":" + item.id.ToString() + ",\"valor\":" + item.valor.ToString() 

                            + ",\"tipoValor\":" + item.tipoValor.json

                    + ",\"tipo\":" + item.tipo.json + "}";

                strList.Add(text);

                item.json = text;

            }

            var jsonV = String.Join(",",strList.ToArray());

            var json = "{" + 

                        "\"fecha\":\"" + date.Value.ToShortDateString() + "\"," +

                        "\"tiposDeFondo\":[" + jsonTDF + "]," +

                        "\"tiposDeValores\":[" + jsonTDV + "]," +

                        "\"subTiposDeFondo\":[" + jsonSTDF + "]," +

                        "\"valores\":[" + jsonV + "]" + 

                    "}";

            Console.WriteLine("{\"TiposDeFondo\":[" + jsonTDF + "]}");

            Console.WriteLine("{\"SubTiposDeFondo\":[" + jsonSTDF + "]}");

            Console.WriteLine("{\"TiposDeValor\":[" + jsonTDV + "]}");

            Console.WriteLine(json);

        }

    }

}