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 Column()
        {   
            List<ColumnSeriesData> appleData = new List<ColumnSeriesData>();

            using (var db = new HighstockDataEntities())
            {
                foreach (AppleData data in db.AppleDatas)
                {
                    appleData.Add(new ColumnSeriesData
                    {
                        X = Convert.ToDouble(data.Date),
                        Y = Convert.ToDouble(data.Value)
                    });
                }
            }

            ViewBag.AppleData = appleData.OrderBy(o => o.X).ToList();

            return View(ViewBag);
        }       

    }
}

@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>

<script type="text/javascript">

    function formatYAxis() {
        return (this.value > 0 ? ' + ' : '') + this.value + '%';
    }

</script>

@{
    var chartOptions = new Highstock
    {
        RangeSelector = new RangeSelector
        {
            Selected = 1
        },
        Title = new Title
        {
            Text = "Apple Stock Price"
        },
        PlotOptions = new PlotOptions()
        {
            Series = new PlotOptionsSeries
            {
                Zones = new List<PlotOptionsSeriesZone>()
            {
                        new PlotOptionsSeriesZone()
                        {
                            ClassName = "zone-negative",
                        }
                    }
            }
        },
        Series = new List<Series>
    {
                new ColumnSeries
                {
                   Data = ViewBag.AppleData as List<ColumnSeriesData>,
                   Name = "Apple Stock Price",
                   TurboThreshold = 10000,
                   Tooltip = new ColumnSeriesTooltip
                   {
                       ValueDecimals = 2
                   }
                }
            }
    };

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

@Html.Raw(renderer.RenderHtml())