using System;

using System.IO;

using System.Xml;

using System.Net;

using HtmlAgilityPack;

using System.Text.RegularExpressions;

/*using Microsoft.Office.Interop.Excel;

using ClosedXML.Excel;

using System.IO;

using System.Reflection;*/

​

public class Program

{

    public static void Main()

    {

        /*System.Data.DataTable dataTable = new System.Data.DataTable();

        dataTable.Columns.Add("Page URL");

        dataTable.Columns.Add("Site Domain");

        dataTable.Columns.Add("Country");

        dataTable.Columns.Add("Product Name");

        dataTable.Columns.Add("Product Category");

        dataTable.Columns.Add("Quantity");

        dataTable.Columns.Add("Code");

        dataTable.Columns.Add("Currency");

        dataTable.Columns.Add("Promo Flag");

        dataTable.Columns.Add("Regular Price");

        dataTable.Columns.Add("Dicount Price");

        dataTable.Columns.Add("Dicount %");

        dataTable.Columns.Add("Date");*/

        using (var client = new WebClient())

            {

                client.Headers.Add("x-api-key", "IuimuMneIKJd3tapno2Ag1c1WcAES97j");

                for (int i=1;i<=60;i++)

                {

                    string webpage = client.DownloadString("https://apijumboweb.smdigital.cl/catalog/api/v2/products/search/vinos-cervezas-y-licores/vinos");

                    HtmlAgilityPack.HtmlDocument doc = new HtmlAgilityPack.HtmlDocument();

                    doc.LoadHtml(webpage);

                    var json_con=doc.DocumentNode.InnerHtml;

                    Regex bloks = new Regex("productId[\\w\\W]*?\\]\\}");

                    System.Text.RegularExpressions.MatchCollection match = bloks.Matches(json_con);

                    Console.WriteLine(match.Count);

                    for(int k=0;k<=match.Count-1;k++)

                    {

                        //Console.WriteLine(match[k]);

                        var blk=match[k];

                        Match code = Regex.Match(blk.ToString(),"ref_id\\W+(\\d+)\\W+");

                        Match productname = Regex.Match(blk.ToString(),"productName\\W+([\\w\\W]*?)\\\"\\,");

                        Match promoprice = Regex.Match(blk.ToString(),"\\\"Price\\W+(\\d+)");

                        Match listprice = Regex.Match(blk.ToString(),"\\\"PriceWithoutDiscount\\W+(\\d+)");

                        Match link = Regex.Match(blk.ToString(),"\\\"linkText\\W+([\\w\\W]*?)\\\"");

                        Match catagory = Regex.Match(blk.ToString(),"categories\\s*\\\"\\W+[\\w\\W]*?\\,\\\"\\s*\\/[\\w\\W]*?\\/([\\w\\W]*?)\\/\\\"");

                        Match Quantity = Regex.Match(blk.ToString(),"((?:\\d+|\\d+\\.\\d+)(?:\\s*|\\-)(?:cc|CC|ml|ML|Ml|L))");

                        int promoprice1=0;

                        if (listprice.Groups[1]==promoprice.Groups[1])

                        {

                            promoprice1=0;

                        }

                        else

                        {

                             promoprice1=promoprice.Groups[1].ToString();

                        }

                        Console.WriteLine(code.Groups[1]);

                        Console.WriteLine(productname.Groups[1]);

                        Console.WriteLine(listprice.Groups[1]);

                        Console.WriteLine(promoprice1);

                        Console.WriteLine("https://www.jumbo.cl/"+link.Groups[1]+"/p");

                        Console.WriteLine(catagory.Groups[1]);

                        var main_p=listprice.Groups[1].ToString();

                        var promo_p=promoprice1.ToString();

                        var main_p1=int.Parse(main_p);

                        var promo_p1=int.Parse(promo_p);

                        int discount=(main_p1-promo_p1);

                        Console.WriteLine(discount);

                        var dis1=(((double)discount / main_p1)*100).ToString()+" %";

                        Console.WriteLine(dis1);

                        Console.WriteLine(Quantity);

                        DateTime dateTime = DateTime.UtcNow.Date;

                        string date = dateTime.ToString("dd/MM/yyyy");

                        Console.WriteLine(date);

                        /*rows["Page URL"] = "https://www.jumbo.cl/"+link.Groups[1]+"/p";

                        rows["Site Domain"] = "Chl";

                        rows["Country"] = "Spain";

                        rows["Product Name"] =productname.Groups[1];

                        rows["Product Category"] = catagory.Groups[1];

                        rows["Quantity"] = Quantity.Groups[1];

                        rows["Code"] = code.Groups[1];

                        rows["Currency"] = "$";

                        rows["Promo Flag"] = "";

                        rows["Regular Price"] = main_p1;

                        rows["Dicount Price"] = promo_p1;

                        rows["Dicount %"] = dis1+"%";

                        rows["Date"] = date;

                        dataTable.Rows.Add(rows);*/

                    }

                }

            }

    }

}