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

Namespace Features
    Partial Public Class CustomHeaderCells
        Inherits BaseSampleControl
        Private _table As DataTable
        Private _ascii As Integer = 65
        Private _character As Char
        Private _random As New Random()
        Public Sub New()
            InitializeComponent()
            Name = "Custom Header Cells"
            sheetView.DataAutoSizeColumns = False
            sheetView.Columns.[Default].Width = 90
            sheetView.Rows.[Default].Height = 25

            sheetView.ColumnHeader.Rows(0).Height = 35

            _table = New DataTable()

            For column As Integer = 1 To 9
                _character = ChrW(_ascii)
                _table.Columns.Add(New DataColumn() With {
                     .ColumnName = _character.ToString(),
                     .DataType = GetType(Int32)
                })
                _ascii += 1
            Next
            For row As Integer = 0 To 49
                _table.Rows.Add(_random.[Next](-100, 200), _random.[Next](-100, 200), _random.[Next](-100, 200), _random.[Next](-100, 200), _random.[Next](-100, 200), _random.[Next](-100, 200),
                    _random.[Next](-100, 200), _random.[Next](-100, 200), _random.[Next](-100, 200))
            Next
            sheetView.DataSource = _table

            Dim rules As ConditionalFormattingRule() = New ConditionalFormattingRule() {New UnaryComparisonConditionalFormattingRule(UnaryComparisonOperator.LessThan, 0, False) With {
                .ForeColor = Color.Red,
                .FontStyle = New SpreadFontStyle(RegularBoldItalicFontStyle.Bold)
            }}

            Dim hideRowFilter As New HideRowFilter(sheetView)
            Dim top10FilterItem As New Top10FilterItem(True, 10, False)
            Dim filterLessThan120 As New CustomFilterItem(New FilterCondition(CustomFilterOperatorType.GreaterThanOrEqual, 120), Nothing, False)

            sheetView.ColumnHeader.Columns(1).CellType = New ColumnHeaderCellType(sheetView, New CheckBox() With {
                .Text = "< 0",
                .TextAlign = ContentAlignment.MiddleCenter
            }, rules) With {
                .TooltipText = "Highlight negative numbers"
            }
            sheetView.ColumnHeader.Columns(3).CellType = New ColumnHeaderCellType(sheetView, New Button() With {
                .Text = "Top 10"
            }, hideRowFilter, top10FilterItem) With {
                .TooltipText = "Show Top 10 values"
            }
            sheetView.ColumnHeader.Columns(5).CellType = New ColumnHeaderCellType(sheetView, New CheckBox() With {
                .Text = ">= 120",
                .TextAlign = ContentAlignment.MiddleCenter
            }, hideRowFilter, filterLessThan120) With {
                .TooltipText = "Values greater than 120"
            }
        End Sub

        Public Class ColumnHeaderCellType
            Inherits BaseCellType
            Private _sheet As SheetView
            Private _active As Boolean
            Private _filterAction As Boolean
            Private _toolTip As ToolTip
            Private _tooltipVisible As Boolean

            Public Property Control() As Control
                Get
                    Return m_Control
                End Get
                Private Set
                    m_Control = Value
                End Set
            End Property
            Private m_Control As Control
            Public Property RowFilter() As IRowFilter
                Get
                    Return m_RowFilter
                End Get
                Set
                    m_RowFilter = Value
                End Set
            End Property
            Private m_RowFilter As IRowFilter
            Public Property FilterItem() As BaseFilterItem
                Get
                    Return m_FilterItem
                End Get
                Set
                    m_FilterItem = Value
                End Set
            End Property
            Private m_FilterItem As BaseFilterItem
            Public Property ConditionalFormattingRules() As ConditionalFormattingRule()
                Get
                    Return m_ConditionalFormattingRules
                End Get
                Set
                    m_ConditionalFormattingRules = Value
                End Set
            End Property
            Private m_ConditionalFormattingRules As ConditionalFormattingRule()
            Public Property TooltipText() As String
                Get
                    Return m_TooltipText
                End Get
                Set
                    m_TooltipText = Value
                End Set
            End Property
            Private m_TooltipText As String

            Public Sub New(sheet As SheetView, control As Control, rowFilter__1 As IRowFilter, filterItem__2 As BaseFilterItem)
                Me.New(sheet, control)
                RowFilter = rowFilter__1
                FilterItem = filterItem__2
                _filterAction = True
            End Sub

            Public Sub New(sheet As SheetView, control__1 As Control, rule As ConditionalFormattingRule())
                Me.New(sheet, control__1)
                _sheet = sheet
                Control = control__1
                ConditionalFormattingRules = rule
                _filterAction = False
            End Sub

            Private Sub New(sheet As SheetView, control__1 As Control)
                _sheet = sheet
                Control = control__1
                _toolTip = New ToolTip()

                AddHandler Control.Click, AddressOf Control_Click
                AddHandler Control.MouseEnter, AddressOf Control_MouseEnter
                AddHandler Control.MouseLeave, AddressOf Control_MouseLeave
            End Sub

            Private Sub Control_MouseEnter(sender As Object, e As EventArgs)
                If Not _tooltipVisible Then
                    _toolTip.Show(TooltipText, _sheet.FpSpread, New Point(Control.Left, Control.Bottom))
                    _tooltipVisible = True
                End If
            End Sub

            Private Sub Control_MouseLeave(sender As Object, e As EventArgs)
                _toolTip.Hide(_sheet.FpSpread)
                _tooltipVisible = False
            End Sub

            Private Sub Control_Click(sender As Object, e As EventArgs)
                Dim point As Point = _sheet.FpSpread.PointToClient(MousePosition)
                Dim hitTestInfo As HitTestInformation = _sheet.FpSpread.HitTest(point.X, point.Y)
                Dim col As Integer = hitTestInfo.HeaderInfo.Column

                If _filterAction Then
                    If _active Then
                        ResetFilter(col)
                    Else
                        ApplyFilter(col)
                    End If
                Else
                    If _active Then
                        RemoveFormattingRules(col)
                    Else
                        AddFormattingRules(col)
                    End If
                End If

                _active = Not _active
            End Sub

            Private Sub ApplyFilter(col As Integer)
                Dim fcd As New FilterColumnDefinition(col, FilterListBehavior.[Custom])
                fcd.Filters.Add(FilterItem)
                RowFilter.ColumnDefinitions.Add(fcd)
                If _sheet.RowFilter IsNot RowFilter Then
                    _sheet.RowFilter = RowFilter
                End If
                _sheet.AutoFilterColumn(col, FilterItem.DisplayName, 0)
            End Sub

            Private Sub ResetFilter(col As Integer)
                _sheet.AutoFilterReset(col)
            End Sub

            Private Sub AddFormattingRules(col As Integer)
                RemoveFormattingRules(col)
                _sheet.SetConditionalFormatting(0, col, _sheet.RowCount, 1, True, ConditionalFormattingRules)
            End Sub

            Private Sub RemoveFormattingRules(col As Integer)
                Dim formattings As Object = _sheet.GetConditionalFormatting(0, col, _sheet.RowCount, 1)
                If formattings Is Nothing Then
                    Return
                End If
                For Each formatting As Object In formattings
                    formatting.Clear()
                Next
            End Sub

            Public Overrides Function Format(obj As Object) As String
                Return String.Empty
            End Function

            Public Overrides Function GetEditorControl(appearance As FarPoint.Win.Spread.Appearance, zoomFactor As Single) As Control
                Return Nothing
            End Function

            Public Overrides Function GetEditorValue() As Object
                Return Nothing
            End Function

            Public Overrides Function GetPreferredSize(g As Graphics, size As Size, appearance As FarPoint.Win.Spread.Appearance, value As Object, zoomFactor As Single) As Size
                Return New Size(CInt(Math.Truncate(size.Width * zoomFactor)), CInt(Math.Truncate(size.Height * zoomFactor)))
            End Function

            Public Overrides Sub PaintCell(g As Graphics, r As Rectangle, appearance As FarPoint.Win.Spread.Appearance, value As Object, isSelected As Boolean, isLocked As Boolean,
                zoomFactor As Single)
                Control.Bounds = r
                _sheet.FpSpread.Controls.Add(Control)
            End Sub

            Public Overrides Function Parse(s As String) As Object
                Return Nothing
            End Function

            Public Overrides Sub SetEditorValue(value As Object)

            End Sub
        End Class
    End Class
End Namespace

'
'
'

Namespace Features
	Partial Class CustomHeaderCells
		''' <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 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.sheetView = New FarPoint.Win.Spread.SheetView()
			Me.pnlMain.SuspendLayout()
			DirectCast(Me.spread, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.sheetView, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.SuspendLayout()
			' 
			' pnlMain
			' 
			Me.pnlMain.Controls.Add(Me.spread)
			' 
			' spread
			' 
			Me.spread.AccessibleDescription = "spread, CustomHeader, Row 0, Column 0"
			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.sheetView})
			Me.spread.Size = New System.Drawing.Size(477, 487)
			Me.spread.TabIndex = 0
			' 
			' sheetView
			' 
			Me.sheetView.Reset()
			Me.sheetView.SheetName = "CustomHeader"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.sheetView.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.sheetView.RowHeader.Columns.[Default].Width = 35F
			Me.sheetView.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' CustomHeaderCells
			' 
			Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
			Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
			Me.Name = "CustomHeaderCells"
			Me.pnlMain.ResumeLayout(False)
			DirectCast(Me.spread, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.sheetView, System.ComponentModel.ISupportInitialize).EndInit()
			Me.ResumeLayout(False)

		End Sub

		#End Region

		Private spread As FarPoint.Win.Spread.FpSpread
		Private sheetView As FarPoint.Win.Spread.SheetView
	End Class
End Namespace
