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()

        {

            DataTable ChartData = new DataTable();

            ChartData.Columns.Add("Order Date", typeof(System.DateTime));

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

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

            ChartData.Rows.Add("1/ 1 / 2011", "Australia", 120.366);

            ChartData.Rows.Add("1/ 1 / 2011", "Australia", 55.242);

            ChartData.Rows.Add("1/ 3 / 2011", "Australia", 276.102);

            ChartData.Rows.Add("1/ 3 / 2011", "Australia", 35.883);

            ChartData.Rows.Add("1/ 4 / 2011", "United States", 16.448);

            ChartData.Rows.Add("1/ 5 / 2011", "United States", 272.736);

            ChartData.Rows.Add("1/ 5 / 2011", "United States", 11.784);

            ChartData.Rows.Add("1/ 6 / 2011", "United States", 19.536);

            ChartData.Rows.Add("1/ 7 / 2011", "United States", 6.54);

            ChartData.Rows.Add("1/ 7 / 2011", "United States", 5.48);

            ChartData.Rows.Add("1/ 8 / 2011", "United States", 76.728);

            ChartData.Rows.Add("1/ 8 / 2011", "United States", 10.43);

            ChartData.Rows.Add("1/ 10 / 2011", "Australia", 1475.095);

            ChartData.Rows.Add("1/ 10 / 2011", "United States", 9.344);

            ChartData.Rows.Add("1/ 11 / 2011", "India", 141.57);

            ChartData.Rows.Add("1/ 11 / 2011", "United States", 51.94);

            ChartData.Rows.Add("1/ 11 / 2011", "United States", 2.89);

            ChartData.Rows.Add("1/ 12 / 2011", "United States", 9.94);

            ChartData.Rows.Add("1/ 13 / 2011", "Australia", 15.93);

            ChartData.Rows.Add("1/ 14 / 2011", "United States", 1325.85);

            ChartData.Rows.Add("1/ 14 / 2011", "United States", 572.58);

            ChartData.Rows.Add("1/ 15 / 2011", "United States", 61.96);

            ChartData.Rows.Add("1/ 16 / 2011", "United States", 149.95);

            ChartData.Rows.Add("1/ 17 / 2011", "United States", 18.588);

            ChartData.Rows.Add("1/ 17 / 2011", "Australia", 18.576);

            ChartData.Rows.Add("1/ 19 / 2011", "United States", 64.864);

            ChartData.Rows.Add("1/ 20 / 2011", "United States", 181.47);

            ChartData.Rows.Add("1/ 20 / 2011", "Australia", 138.753);

            ChartData.Rows.Add("1/ 21 / 2011", "United States", 1067.94);

            ChartData.Rows.Add("1/ 21 / 2011", "United States", 6.63);

            ChartData.Rows.Add("1/ 22 / 2011", "Australia", 59.724);

            ChartData.Rows.Add("1/ 24 / 2011", "India", 59.25);

            ChartData.Rows.Add("1/ 24 / 2011", "United States", 5.94);

            ChartData.Rows.Add("1/ 26 / 2011", "India", 79.38);

            ChartData.Rows.Add("1/ 26 / 2011", "India", 342.51);

            ChartData.Rows.Add("1/ 27 / 2011", "United States", 141.96);

            ChartData.Rows.Add("1/ 27 / 2011", "United States", 489.92);

            ChartData.Rows.Add("1/ 27 / 2011", "United States", 10.68);

            ChartData.Rows.Add("1/ 28 / 2011", "Australia", 531.522);

            ChartData.Rows.Add("1/ 29 / 2011", "United States", 3.928);

            ChartData.Rows.Add("1/ 31 / 2011", "Australia", 838.593);

            // Create static source with this data table

            StaticSource source = new StaticSource(ChartData);

            // Create instance of DataModel class

            DataModel model = new DataModel();

            // Add DataSource to the DataModel

            model.DataSources.Add(source);

            // Filter Applied to the tabular data

            model = model.Where("Order Date is between 1/11/2011 to 1/25/2011 and Country = United States");

            // Instantiate Column Chart

            Charts.ColumnChart column = new Charts.ColumnChart("first_chart");

            // Set Chart's width and height

            column.Width.Pixel(700);

            column.Height.Pixel(400);

            // Set DataModel instance as the data source of the chart

            column.Data.Source = model;

            // Set Chart Title

            column.Caption.Text = "Global online sales of SuperStore";

            // Set chart Sub title

            column.SubCaption.Text = "2017-2018";

            column.ThemeName = FusionChartsTheme.ThemeName.FUSION;

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

            return View();

        }

    }

}