﻿Imports System.Collections.Generic
Imports System.ComponentModel
Imports System.Drawing
Imports System.Data
Imports System.Linq
Imports System.Text
Imports System.Threading.Tasks
Imports System.Windows.Forms
Imports FarPoint.Win.Chart
Imports FarPoint.Win.Spread.Data
Imports FarPoint.Win.Spread.Model
Imports Spread.Common.Features.Spread.Common.Features.Sample
Imports System.Reflection

Partial Public Class AdvancedCharts
    Inherits BaseSampleControl
    Private _chartTypes As New Dictionary(Of String, Dictionary(Of String, Type))() From {
        {"Radar", New Dictionary(Of String, Type)() From {
            {"Point", GetType(RadarPointSeries)},
            {"Line", GetType(RadarLineSeries)},
            {"Area", GetType(RadarAreaSeries)}
        }},
        {"Polar", New Dictionary(Of String, Type)() From {
            {"Point", GetType(PolarPointSeries)},
            {"Line", GetType(PolarLineSeries)},
            {"Area", GetType(PolarAreaSeries)}
        }},
        {"Frequency", New Dictionary(Of String, Type)() From {
            {"Histogram", GetType(HistogramSeries)},
            {"Pareto", GetType(ParetoSeries)}
        }},
        {"Funnel", New Dictionary(Of String, Type)() From {
            {"Funnel", GetType(FunnelSeries)}
        }},
        {"Box and Whisker", New Dictionary(Of String, Type)() From {
            {"Box and Whisker", GetType(BoxWhiskerSeries)},
            {"Clustered", GetType(ClusteredBoxWhiskerSeries)}
        }},
        {"Waterfall", New Dictionary(Of String, Type)() From {
            {"Waterfall", GetType(WaterfallSeries)}
        }},
        {"Hierarchy", New Dictionary(Of String, Type)() From {
            {"Sunburst", GetType(SunburstSeries)},
            {"TreeMap", GetType(TreemapSeries)}
        }}
    }
    Private _dataAdapter As SpreadDataBindingAdapter
    Private rowCount As Integer = 0, colCount As Integer = 0
    Public Sub New()
        InitializeComponent()
        Name = "Advanced Chart Types"

        'Init Controls
        _dataAdapter = New SpreadDataBindingAdapter() With {
            .Spread = fpSpread1,
            .SheetName = "Sheet1",
            .DataAutoCellTypes = False
        }
        _cbChartGroup.DataSource = _chartTypes.Keys.ToList()

        AddHandler _cbChartGroup.SelectedIndexChanged, AddressOf _cbChartGroup_SelectedIndexChanged
        AddHandler _cbChartType.SelectedIndexChanged, AddressOf _cbChartType_SelectedIndexChanged
        AddHandler _chbView.CheckedChanged, Function(s, e)
                                                fpSpread1_Sheet1.Charts(0).ViewType = If(_chbView.Checked, ChartViewType.View3D, ChartViewType.View2D)

                                            End Function

        _cbChartGroup_SelectedIndexChanged(Me, New EventArgs())
    End Sub

    Private Sub _cbChartType_SelectedIndexChanged(sender As Object, e As EventArgs)
        Dim grpName = _cbChartGroup.SelectedItem.ToString()
        Dim typeName = _cbChartType.SelectedItem.ToString()
        Dim series = _chartTypes(grpName)(typeName)

        fpSpread1_Sheet1.Charts.Clear()
        Dim cellRange = If(grpName = "Hierarchy", New CellRange(1, 0, rowCount - 1, colCount), New CellRange(0, 0, rowCount, colCount))
        Dim view = If(_chbView.Checked, ChartViewType.View3D, ChartViewType.View2D)
        fpSpread1_Sheet1.AddChart(cellRange, series, 600, 500, 100, 150,
            view, True)

        SetChartProperties(grpName, typeName)
    End Sub

    Private Sub SetChartProperties(grpName As String, typeName As String)
        Dim chartType = If(grpName <> typeName, String.Join(" ", typeName, grpName), grpName)
        'Set Header
        fpSpread1_Sheet1.Charts(0).Model.LabelAreas.Clear()
        fpSpread1_Sheet1.Charts(0).Model.LabelAreas.Add(New LabelArea() With {
             .Text = chartType,
             .Location = New PointF(0.5F, 0.05F),
             .AlignmentX = 0.5F,
             .AlignmentY = 0.5F
        })

        Dim ser = fpSpread1_Sheet1.Charts(0).Model.PlotAreas(0).Series(0)
        If chartType = "Waterfall" Then
            TryCast(ser, WaterfallSeries).SetTotal(TryCast(ser, WaterfallSeries).Values.Count - 1, True)
        End If
    End Sub

    Private Sub _cbChartGroup_SelectedIndexChanged(sender As Object, e As EventArgs)
        Dim groupName As String = "Radar"
        If _cbChartGroup.SelectedItem IsNot Nothing Then
            groupName = _cbChartGroup.SelectedItem.ToString()
        End If

        'Set Data for selected chart group
        Select Case groupName
            Case "Radar"
                SetData(DataSource.GetMarketShareData(3))
                Exit Select
            Case "Polar"
                SetPolarData()
                Exit Select
            Case "Frequency"
                SetData(DataSource.GetStudentsScore())
                Exit Select
            Case "Funnel"
                SetData(DataSource.GetSalesStageData())
                Exit Select
            Case "Waterfall"
                SetData(DataSource.GetProfitData().ToList())
                Exit Select
            Case "Box and Whisker"
                SetData(DataSource.GetBoxWhiskerData())
                Exit Select
            Case "Hierarchy"
                SetData(DataSource.GetHierarchicalData())
                Exit Select
        End Select
        Dim chartTypes = _chartTypes.Where(Function(x) x.Key = groupName).SelectMany(Function(x) x.Value.Keys.ToList()).ToList()
        _cbChartType.DataSource = chartTypes
    End Sub
    Private Sub SetPolarData()
        ResetSheetData()
        fpSpread1_Sheet1.Cells(0, 0).Text = "Angles(°)"
        fpSpread1_Sheet1.Cells(1, 0).Text = "Sin(x)"
        fpSpread1_Sheet1.Cells(2, 0).Text = "Cos(x)"
        For i As Integer = 0 To 12
            fpSpread1_Sheet1.Cells(0, i + 1).Value = 30 * i
            fpSpread1_Sheet1.Cells(1, i + 1).Text = Math.Sin(30 * i * Math.PI / 180).ToString("0.00")
            fpSpread1_Sheet1.Cells(2, i + 1).Text = Math.Cos(30 * i * Math.PI / 180).ToString("0.00")
        Next
        rowCount = 3
        colCount = 14
    End Sub

    Private Sub SetData(ByVal list As List(Of Object))
        ResetSheetData()
        Dim r As Integer = 0, c As Integer = 1
        Dim prop As PropertyInfo
        '  Dim boolProfit As Boolean = False
        For Each prop In list(0).[GetType]().GetProperties().Skip(1)
            fpSpread1_Sheet1.Cells(r, c).Value = prop.Name
            c += 1
            'If prop.Name = "Profit" Then
            '    boolProfit = True

            'End If
        Next



        'If boolProfit = True Then
        '    Dim total = CType(list, List(Of Object)).Sum(Function(x) x.Profit)
        '    'CType(list, List(Of Object))(9).Profit = total
        '    CType(list, List(Of Object)).Add(New With {
        '     .Period = "Total",
        '     .Profit = total
        '     })
        '    'fpSpread1_Sheet1.Cells(list.Count + 1, 0).Value = "Total"
        '    'fpSpread1_Sheet1.Cells(list.Count, 1).Value = total
        '    _dataAdapter.DataSource = list
        '    _dataAdapter.MapperInfo = New MapperInfo(1, 0, list.Count, c)

        '    _dataAdapter.FillSpreadDataByDataSource()
        '    rowCount = list.Count + 1
        '    colCount = c
        'Else

        _dataAdapter.DataSource = list
            _dataAdapter.MapperInfo = New MapperInfo(1, 0, list.Count, c)

            _dataAdapter.FillSpreadDataByDataSource()
            rowCount = list.Count + 1
            colCount = c
        ' End If



    End Sub

    Private Sub ResetSheetData()
        _dataAdapter.DataSource = Nothing
        _dataAdapter.Reset()
        fpSpread1_Sheet1.ClearRange(0, 0, rowCount + 1, colCount + 1, False,
                                    FarPoint.Win.Spread.ClipboardCopyOptions.All)
    End Sub
End Class

//
//
//

Partial Class AdvancedCharts
	''' <summary> 
	''' Required designer variable.
	''' </summary>
	Private components As System.ComponentModel.IContainer = Nothing

    ''' <summary> 
    ''' Clean up any resources being used.
    ''' </summary>
    ''' <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
    Protected Shadows Sub Dispose(disposing As Boolean)
        If disposing AndAlso (components IsNot Nothing) Then
            components.Dispose()
        End If
        MyBase.Dispose(disposing)
    End Sub

#Region "Component Designer generated code"

    ''' <summary> 
    ''' Required method for Designer support - do not modify 
    ''' the contents of this method with the code editor.
    ''' </summary>
    Private Sub InitializeComponent()
		Me._lChartGroup = New System.Windows.Forms.Label()
		Me._cbChartGroup = New System.Windows.Forms.ComboBox()
		Me._lChartType = New System.Windows.Forms.Label()
		Me._cbChartType = New System.Windows.Forms.ComboBox()
		Me._chbView = New System.Windows.Forms.CheckBox()
		Me.fpSpread1 = New FarPoint.Win.Spread.FpSpread()
		Me.fpSpread1_Sheet1 = New FarPoint.Win.Spread.SheetView()
		Me.pnlMain.SuspendLayout()
		Me.pnlControls.SuspendLayout()
		DirectCast(Me.fpSpread1, System.ComponentModel.ISupportInitialize).BeginInit()
		DirectCast(Me.fpSpread1_Sheet1, System.ComponentModel.ISupportInitialize).BeginInit()
		Me.SuspendLayout()
		' 
		' pnlMain
		' 
		Me.pnlMain.Controls.Add(Me.fpSpread1)
		' 
		' pnlControls
		' 
		Me.pnlControls.Controls.Add(Me._chbView)
		Me.pnlControls.Controls.Add(Me._cbChartType)
		Me.pnlControls.Controls.Add(Me._lChartType)
		Me.pnlControls.Controls.Add(Me._cbChartGroup)
		Me.pnlControls.Controls.Add(Me._lChartGroup)
		' 
		' _lChartGroup
		' 
		Me._lChartGroup.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._lChartGroup.AutoSize = True
		Me._lChartGroup.Location = New System.Drawing.Point(6, 25)
		Me._lChartGroup.Name = "_lChartGroup"
		Me._lChartGroup.Size = New System.Drawing.Size(70, 13)
		Me._lChartGroup.TabIndex = 0
		Me._lChartGroup.Text = "Chart Group :"
		' 
		' _cbChartGroup
		' 
		Me._cbChartGroup.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._cbChartGroup.FormattingEnabled = True
		Me._cbChartGroup.Location = New System.Drawing.Point(20, 42)
		Me._cbChartGroup.Name = "_cbChartGroup"
		Me._cbChartGroup.Size = New System.Drawing.Size(111, 21)
		Me._cbChartGroup.TabIndex = 1
		' 
		' _lChartType
		' 
		Me._lChartType.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._lChartType.AutoSize = True
		Me._lChartType.Location = New System.Drawing.Point(6, 81)
		Me._lChartType.Name = "_lChartType"
		Me._lChartType.Size = New System.Drawing.Size(65, 13)
		Me._lChartType.TabIndex = 2
		Me._lChartType.Text = "Chart Type :"
		' 
		' _cbChartType
		' 
		Me._cbChartType.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._cbChartType.FormattingEnabled = True
		Me._cbChartType.Location = New System.Drawing.Point(20, 97)
		Me._cbChartType.Name = "_cbChartType"
		Me._cbChartType.Size = New System.Drawing.Size(111, 21)
		Me._cbChartType.TabIndex = 3
		' 
		' _chbView
		' 
		Me._chbView.AutoSize = True
		Me._chbView.Location = New System.Drawing.Point(9, 138)
		Me._chbView.Name = "_chbView"
		Me._chbView.Size = New System.Drawing.Size(66, 17)
		Me._chbView.TabIndex = 4
		Me._chbView.Text = "3D View"
		Me._chbView.UseVisualStyleBackColor = True
		' 
		' fpSpread1
		' 
		Me.fpSpread1.AccessibleDescription = ""
		Me.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill
		Me.fpSpread1.Location = New System.Drawing.Point(0, 0)
		Me.fpSpread1.Name = "fpSpread1"
		Me.fpSpread1.Sheets.AddRange(New FarPoint.Win.Spread.SheetView() {Me.fpSpread1_Sheet1})
		Me.fpSpread1.Size = New System.Drawing.Size(477, 487)
		Me.fpSpread1.TabIndex = 0
		' 
		' fpSpread1_Sheet1
		' 
		Me.fpSpread1_Sheet1.Reset()
		Me.fpSpread1_Sheet1.SheetName = "Sheet1"
		' Formulas and custom names must be loaded with R1C1 reference style
		Me.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
		Me.fpSpread1_Sheet1.RowHeader.Columns.[Default].Width = 35F
		Me.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
		' 
		' AdvancedCharts
		' 
		Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
		Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
		Me.Name = "AdvancedCharts"
		Me.pnlMain.ResumeLayout(False)
		Me.pnlControls.ResumeLayout(False)
		Me.pnlControls.PerformLayout()
		DirectCast(Me.fpSpread1, System.ComponentModel.ISupportInitialize).EndInit()
		DirectCast(Me.fpSpread1_Sheet1, System.ComponentModel.ISupportInitialize).EndInit()
		Me.ResumeLayout(False)

	End Sub

	#End Region

	Private _lChartGroup As System.Windows.Forms.Label
	Private _chbView As System.Windows.Forms.CheckBox
	Private _cbChartType As System.Windows.Forms.ComboBox
	Private _lChartType As System.Windows.Forms.Label
	Private _cbChartGroup As System.Windows.Forms.ComboBox
	Private fpSpread1 As FarPoint.Win.Spread.FpSpread
	Private fpSpread1_Sheet1 As FarPoint.Win.Spread.SheetView
End Class
