using System;

using System.Web.Mvc;

using System.Collections.Generic;

using System.Diagnostics;

using System.Linq;

using System.Threading.Tasks;

using FusionCharts.Visualization;

using FusionCharts.DataEngine;

using System.Data;

​

namespace FusionChartsSamples

{

    public class HomeController : Controller

    {

        public ActionResult Index()

        {

            ViewData["Title"] = "FusionCharts asp.net csharp wrapper samples in MVC6";

            ViewData["Message"] = "Single Y-axis Combination Chart 3D";

            // initialixe DataModel object

            DataModel model = new DataModel();

            // Create object of JsonFileSource. Provide file path as constructor parameter

            JsonFileSource jsonFileSource = new JsonFileSource("https://raw.githubusercontent.com/poushali-guha-12/SampleData/master/mscombi3d.json");

            DataTable ChartData = new DataTable();

            ChartData.Columns.Add("label", typeof(System.String));

            ChartData.Columns.Add("Eigen vermogen", typeof(System.Double));

            ChartData.Columns.Add("Langlopende schulden", typeof(System.Double));

            ChartData.Columns.Add("Kortlopende schulden", typeof(System.Double));

            /*ChartData.Rows.Add("2011", 2000, 1000, 100);

            ChartData.Rows.Add("2012", 20000, 12000, 10000);

            ChartData.Rows.Add("2013", 20000, 12000, 10000);

            ChartData.Rows.Add("2014", 16000, 15000, 4000);

            ChartData.Rows.Add("2015", 20000, 16000, 5000);*/

            ChartData.Rows.Add("2016", 18000, 17000, 3000);

            ChartData.Rows.Add("2017", 19000, 18000, 4000);

            ChartData.Rows.Add("2018", 15000, 16000, 2000);

            ChartData.Rows.Add("2019", 25000, 19000, 8000);

            ChartData.Rows.Add("2020", 20000, 12000, 10000);

            //ChartData.Rows.Add("Actual Revenue", 16000);

            /*ChartData.Rows.Add("Projected Revenue", 15000);

            ChartData.Rows.Add("Profit", 4000);

            ChartData.Rows.Add("label", "2015");

            ChartData.Rows.Add("Actual Revenue", 20000);

            ChartData.Rows.Add("Projected Revenue", 16000);

            ChartData.Rows.Add("Profit", 5000);

            ChartData.Rows.Add("label", "2016");

            ChartData.Rows.Add("Actual Revenue", 18000);

            ChartData.Rows.Add("Projected Revenue", 17000);

            ChartData.Rows.Add("Profit", 3000);

            ChartData.Rows.Add("label", "2017");

            ChartData.Rows.Add("Actual Revenue", 19000);

            ChartData.Rows.Add("Projected Revenue", 18000);

            ChartData.Rows.Add("Profit", 4000);*/

            StaticSource source = new StaticSource(ChartData);

            // Add json source in datasources store of model

            model.DataSources.Add(source);

            // initialize combination chart object

            Charts.CombinationChart combiChart = new Charts.CombinationChart("mscombi3d");

            // Set threeD

            combiChart.ThreeD = true;

            // set model as data source

            combiChart.Data.Source = model;

            // provide field name, which should be rendered as line column

            combiChart.Data.ColumnPlots("Eigen vermogen");

            // provide field name, which should be rendered as line plot

            combiChart.Data.LinePlots("Langlopende schulden");

            // provide field name, which should be rendered as area plot

            combiChart.Data.AreaPlots("Kortlopende schulden");

            // Set XAxis caption

            combiChart.XAxis.Text = "Jaar";

            // Set YAxis caption

            combiChart.PrimaryYAxis.Text = "Amount (in EUR)";

            // set chart caption

            combiChart.Caption.Text = "Passiva";

            // Set chart sub caption

            combiChart.SubCaption.Text = "";

            // set width, height

            combiChart.Width.Pixel(600);

            combiChart.Height.Pixel(500);

            // set theme

            combiChart.ThemeName = FusionChartsTheme.ThemeName.FUSION;

            ViewData["Chart"] = combiChart.Render();

            return View();

        }

    }

}