using Highsoft.Web.Mvc.Stocks;
using MVC_Demo.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Web;
using System.Web.Mvc;

namespace MVC_Demo.Areas.Highstock.Controllers.Shared
{
    public partial class SharedController : Controller
    {
        public ActionResult IntradayArea()
        {
            List<AreaSeriesData> intradayData = new List<AreaSeriesData>();

            using (var db = new HighstockDataEntities())
            {
                foreach (Intraday data in db.Intradays)
                {
                        intradayData.Add(new AreaSeriesData
                            {                                
                                Y = Convert.ToDouble(data.High),
                                X = Convert.ToDouble(data.Date)
                            }
                        );
                }
            }

            ViewBag.IntradayData = intradayData.OrderBy(o => o.X).ToList();

            return View(ViewBag);
        }

        private void IntradayArea_JsonDataToDatabase()
        {
            string json;

            using (WebClient wc = new WebClient())
            {
                json = wc.DownloadString("https://www.highcharts.com/samples/data/jsonp.php?filename=new-intraday.json&callback=?");
            }

            json = json.Substring(json.IndexOf('[') + 1);
            json = json.Substring(json.IndexOf('[') + 1);

            using (var db = new HighstockDataEntities())
            {
                while (true)
                {
                    if (json.IndexOf('[') == -1)
                        break;

                    string entity = json.Substring(0, json.IndexOf(']'));
                    string[] values = entity.Split(',');

                    db.Intradays.Add(
                        new Intraday
                        {
                            Date = Convert.ToDouble(values[0]),
                            Open = Convert.ToDouble(values[1]),
                            High = Convert.ToDouble(values[2]),
                            Low = Convert.ToDouble(values[3]),
                            Close = Convert.ToDouble(values[4])
                        }
                    );

                    json = json.Substring(json.IndexOf('[') + 1);
                }


                db.SaveChanges();
            }
        }

    }
}

@using Highsoft.Web.Mvc.Stocks
@using Highsoft.Web.Mvc.Stocks.Rendering;

<script src="https://code.highcharts.com/stock/highstock.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>

@{ var chartOptions =
      new Highstock
      {
          Title = new Title
          {
              Text = "AAPL stock price by minute"
          },
          Subtitle = new Subtitle
          {
              Text = "Using ordinal X axis"
          },
          XAxis = new List<XAxis>
              {
                new XAxis()
                {
                    Ordinal = true
                }
                              },
          YAxis = new List<YAxis>
              {
                new YAxis()
                {
                    Min = 360
                }
                              },
          RangeSelector = new RangeSelector()
          {
              Buttons = new List<RangeSelectorButton>() { new RangeSelectorButton { Type = "minute", Count = 60, Text = "1h" }, new RangeSelectorButton { Type = "day", Count = 1, Text = "1d" }, new RangeSelectorButton { Type = "all", Count = 1, Text = "All" } },
              InputEnabled = false,
              Selected = 1
          },
          Series = new List<Series>
              {
                new AreaSeries
                {
                    Data = ViewBag.IntradayData as List<AreaSeriesData>,
                    Name = "AAPL",
                    GapSize = 5,
                    Tooltip = new AreaSeriesTooltip
                    {
                        ValueDecimals = 2
                    },
                    TurboThreshold = 10000,
                    FillColor = @ViewBag.fillColor
                }
                              }

      };

    chartOptions.ID = "chart";
    var renderer = new HighstockRenderer(chartOptions);
}

@Html.Raw(renderer.RenderHtml())