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.Spread
Imports FarPoint.Win
Imports Spread.Common.DataStore
Imports FarPoint.Win.Spread.CellType
Imports Spread.Common.Features.Spread.Common.Features.Sample

Partial Public Class HierarchicalViews
    Inherits BaseSampleControl
    Private _dataSet As New DataSet()
    Private _studentData As New List(Of Student)()
    Private _subjects As String() = New String() {"Maths", "English", "Science", "History", "Hindi"}

    Public Sub New()
        InitializeComponent()
        Name = "Hierarchical Views"

        SetupDataSet()
        InitializeControls()
    End Sub

    Private Sub Spread_ChildViewCreated(sender As Object, e As ChildViewCreatedEventArgs)
        Dim childSheet = e.SheetView
        For i As Integer = 0 To childSheet.Columns.Count - 1
            childSheet.Columns(i).Width = 120
        Next

        childSheet.RowHeader.AutoText = HeaderAutoText.Blank
        childSheet.RowHeader.DefaultStyle.Border = New EmptyBorder()
        childSheet.SheetCornerStyle.Border = New EmptyBorder()
        childSheet.ColumnHeader.DefaultStyle.Font = New Font("Veranda", 8, FontStyle.Italic)
        childSheet.ColumnHeader.DefaultStyle.HorizontalAlignment = CellHorizontalAlignment.Left
        childSheet.ColumnHeader.Cells(0, 0, 0, childSheet.ColumnCount - 1).Border = New LineBorder(Color.LightGray, 1, False, True, True, False)

        If childSheet.ParentRelationName = "Orders" Then
            childSheet.Columns(0).Visible = False
            childSheet.Columns(4).CellType = New PercentCellType()
        ElseIf childSheet.ParentRelationName = "Performance" Then
            childSheet.Columns(1).Visible = False
        End If
    End Sub

    Private Sub InitializeControls()
        'Sheet-1 setup
        sheet1.SheetName = "Hierarchical Data Binding"
        sheet1.DataAutoSizeColumns = False
        sheet1.DataSource = _dataSet
        sheet1.SetColumnWidth(-1, 150)
        sheet1.SetRowHeight(-1, 25)
        sheet1.RowHeader.Columns(0).Width = 50
        sheet1.ColumnHeader.Columns(1).Label = "Customer Name"
        sheet1.Cells(0, 0, sheet1.RowCount - 1, sheet1.ColumnCount - 1).Border = New LineBorder(Color.LightGray, 1, False, True, False, False)
        sheet1.ExpandRow(0, True)

        'Sheet-2 setup
        sheet2.SheetName = "Custom Object List Binding"
        sheet2.DataAutoSizeColumns = False
        sheet2.Columns.[Default].Width = 150
        sheet2.Rows.[Default].Height = 21
        sheet2.DataSource = _studentData
        sheet2.Columns(2).Visible = False
        sheet2.RowHeader.Columns(0).Width = 50
        sheet2.Cells(0, 0, sheet2.RowCount - 1, sheet2.ColumnCount - 1).Border = New LineBorder(Color.LightGray, 1, False, True, False, False)
        sheet2.ExpandRow(0, True)
    End Sub
    Private Sub SetupDataSet()
        Dim service = New DataService()
        Dim orders = service.AccessDataSource.GetDataFrom("Nwind.mdb", "Select Orders.OrderID, Customers.ContactName, Orders.OrderDate From Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID").Tables(0).Copy()
        Dim products = service.AccessDataSource.GetDataFrom("Nwind.mdb", "Select [Order Details].OrderID, Products.ProductName, [Order Details].UnitPrice, [Order Details].Quantity, [Order Details].Discount FROM [Order Details] INNER JOIN Products ON [Order Details].ProductID = Products.ProductID").Tables(0).Copy()

        orders.TableName = "Orders"
        products.TableName = "Products"
        _dataSet.Tables.Add(orders)
        _dataSet.Tables.Add(products)

        _dataSet.Relations.Add("Orders", orders.Columns("OrderID"), products.Columns("OrderID"))

        'Custom Object List Data Source
        Dim students = service.StudentDashboardDataSource.GetAllStudents()
        Dim rnd = New Random()
        For Each student As Object In students
            Dim performance = New List(Of Marks)()
            For i As Integer = 0 To _subjects.Length - 1
                Dim score = New List(Of Object)()
                score.Add(New With {
                     .Week1 = rnd.[Next](10, 99),
                     .Week2 = rnd.[Next](10, 99),
                     .Week3 = rnd.[Next](10, 99),
                     .Week4 = rnd.[Next](10, 99)
                })
                performance.Add(New Marks() With {
                     .Subject = _subjects(i),
                    .Score = score
                })
            Next
            _studentData.Add(New Student() With {
                 .StudentID = student.ID,
                 .Name = student.Name,
                 .Performance = performance
            })
        Next
    End Sub
    Private Class Student
        Public Property StudentID() As Integer
            Get
                Return m_StudentID
            End Get
            Set
                m_StudentID = Value
            End Set
        End Property
        Private m_StudentID As Integer
        Public Property Name() As String
            Get
                Return m_Name
            End Get
            Set
                m_Name = Value
            End Set
        End Property
        Private m_Name As String
        Public Property Performance() As List(Of Marks)
            Get
                Return m_Performance
            End Get
            Set
                m_Performance = Value
            End Set
        End Property
        Private m_Performance As List(Of Marks)
    End Class
    Private Class Marks
        Public Property Subject() As String
            Get
                Return m_Subject
            End Get
            Set
                m_Subject = Value
            End Set
        End Property
        Private m_Subject As String
        Public Property Score() As List(Of Object)
            Get
                Return m_Score
            End Get
            Set
                m_Score = Value
            End Set
        End Property
        Private m_Score As List(Of Object)
    End Class
End Class

'
'
'

Partial Class HierarchicalViews
	''' <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.spread = New FarPoint.Win.Spread.FpSpread()
		Me.sheet1 = New FarPoint.Win.Spread.SheetView()
		Me.sheet2 = New FarPoint.Win.Spread.SheetView()
		Me.pnlMain.SuspendLayout()
		DirectCast(Me.spread, System.ComponentModel.ISupportInitialize).BeginInit()
		DirectCast(Me.sheet1, System.ComponentModel.ISupportInitialize).BeginInit()
		DirectCast(Me.sheet2, System.ComponentModel.ISupportInitialize).BeginInit()
		Me.SuspendLayout()
		' 
		' pnlMain
		' 
		Me.pnlMain.Controls.Add(Me.spread)
		' 
		' spread
		' 
		Me.spread.Dock = System.Windows.Forms.DockStyle.Fill
		Me.spread.Location = New System.Drawing.Point(0, 0)
		Me.spread.Name = "spread"
		Me.spread.Sheets.AddRange(New FarPoint.Win.Spread.SheetView() {Me.sheet1, Me.sheet2})
		Me.spread.Size = New System.Drawing.Size(477, 487)
		Me.spread.Skin = FarPoint.Win.Spread.DefaultSpreadSkins.Office2016White
		Me.spread.StatusBarVisible = True
		Me.spread.TabIndex = 0
		AddHandler Me.spread.ChildViewCreated, New FarPoint.Win.Spread.ChildViewCreatedEventHandler(AddressOf Me.Spread_ChildViewCreated)
		' 
		' sheet1
		' 
		Me.sheet1.Reset()
		Me.sheet1.SheetName = "Sheet1"
		' Formulas and custom names must be loaded with R1C1 reference style
		Me.sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
		Me.sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
		' 
		' sheet2
		' 
		Me.sheet2.Reset()
		Me.sheet2.SheetName = "Sheet2"
		' Formulas and custom names must be loaded with R1C1 reference style
		Me.sheet2.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
		Me.sheet2.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
		' 
		' HierarchicalViews
		' 
		Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
		Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
		Me.Name = "HierarchicalViews"
		Me.pnlMain.ResumeLayout(False)
		DirectCast(Me.spread, System.ComponentModel.ISupportInitialize).EndInit()
		DirectCast(Me.sheet1, System.ComponentModel.ISupportInitialize).EndInit()
		DirectCast(Me.sheet2, System.ComponentModel.ISupportInitialize).EndInit()
		Me.ResumeLayout(False)

	End Sub

	#End Region

	Private spread As FarPoint.Win.Spread.FpSpread
	Private sheet1 As FarPoint.Win.Spread.SheetView
	Private sheet2 As FarPoint.Win.Spread.SheetView
End Class
