Imports System.Drawing
Imports System.Windows.Forms
Imports Spread.Common.DataStore
Imports FarPoint.Win.Spread
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Features
    Partial Public Class FilterBar
        Inherits BaseSampleControl
        Private _dataSource As AccessDataSource

#Region "ctor"
        Public Sub New()
            InitializeComponent()
            Name = "Filter Bar"
            _dataSource = New DataService().AccessDataSource

            InitSpreadSheet(fpSpread.ActiveSheet)
            InitControls(fpSpread.ActiveSheet)
        End Sub
#End Region

        Private Sub InitSpreadSheet(sheet As SheetView)
            sheet.DataSource = _dataSource.GetDataFrom("fpWine.mdb", "select OrderID, CustomerID," & "SalesPerson, OrderDate, ShippedDate, Freight from Orders")

            sheet.Columns(2).Width = 120
            sheet.Columns(3, 4).Width = 80
            sheet.Columns(5).Width = 70

            sheet.SetMultipleRowHeights(0, sheet.RowCount, 20)

            Dim random As New Random()
            Dim colors = [Enum].GetValues(GetType(KnownColor))
            Dim row As Integer = random.[Next](0, 4)
            While row < sheet.RowCount
                sheet.Cells(row, 1).BackColor = Color.FromKnownColor(CType(colors.GetValue(random.[Next](27, colors.GetUpperBound(0) + 1)), KnownColor))
                row += random.[Next](1, 5)
            End While

            sheet.AutoFilterMode = AutoFilterMode.FilterBar
        End Sub

        Private Sub InitControls(sheet As SheetView)
            comboGridLine.Items.AddRange(New Object() {"HeaderHorizontalGridLine", "HeaderVerticalGridLine", "HorizontalGridLine", "VerticalGridLine"})
            AddHandler comboGridLine.SelectedIndexChanged, AddressOf ComboGridLine_SelectedIndexChanged
            comboGridLine.SelectedIndex = 0

            comboGridType.DataSource = [Enum].GetValues(GetType(GridLineType))

            AddHandler btnColor.Click, AddressOf ShowColorPicker
            AddHandler btnHighlightColor.Click, AddressOf ShowColorPicker
            AddHandler btnShadowColor.Click, AddressOf ShowColorPicker
            AddHandler btnUpdate.Click, AddressOf BtnUpdate_Click
        End Sub

        Private Function GetFilterBarGridLine(name As String) As GridLine
            Select Case name
                Case "HeaderHorizontalGridLine"
                    Return fpSpread.ActiveSheet.FilterBarHeaderHorizontalGridLine
                Case "HeaderVerticalGridLine"
                    Return fpSpread.ActiveSheet.FilterBarHeaderVerticalGridLine
                Case "HorizontalGridLine"
                    Return fpSpread.ActiveSheet.FilterBarHorizontalGridLine
                Case "VerticalGridLine"
                    Return fpSpread.ActiveSheet.FilterBarVerticalGridLine
                Case Else
                    Return Nothing
            End Select
        End Function

#Region "Event handlers"
        Private Sub ShowColorPicker(sender As Object, e As EventArgs)
            Dim button As Button = TryCast(sender, Button)
            Dim dialog As New ColorDialog()
            dialog.Color = button.BackColor

            If dialog.ShowDialog() = DialogResult.OK Then
                button.BackColor = dialog.Color
            End If
        End Sub

        Private Sub BtnUpdate_Click(sender As Object, e As EventArgs)
            Dim gridLine As New GridLine(CType(comboGridType.SelectedItem, GridLineType), btnColor.BackColor, btnHighlightColor.BackColor, btnShadowColor.BackColor, If(numericUpDown.Value = -1, 1, CInt(Math.Truncate(numericUpDown.Value))))
            Dim sheet As SheetView = fpSpread.ActiveSheet

            Select Case comboGridLine.SelectedItem.ToString()
                Case "HeaderHorizontalGridLine"
                    sheet.FilterBarHeaderHorizontalGridLine = gridLine
                    Exit Select
                Case "HeaderVerticalGridLine"
                    sheet.FilterBarHeaderVerticalGridLine = gridLine
                    Exit Select
                Case "HorizontalGridLine"
                    sheet.FilterBarHorizontalGridLine = gridLine
                    Exit Select
                Case "VerticalGridLine"
                    sheet.FilterBarVerticalGridLine = gridLine
                    Exit Select
            End Select
        End Sub

        Private Sub ComboGridLine_SelectedIndexChanged(sender As Object, e As EventArgs)
            Dim gridLine As GridLine = GetFilterBarGridLine(comboGridLine.SelectedItem.ToString())

            comboGridType.SelectedItem = gridLine.Type
            btnColor.BackColor = gridLine.Color
            btnHighlightColor.BackColor = gridLine.HighlightColor
            btnShadowColor.BackColor = gridLine.ShadowColor
            numericUpDown.Value = gridLine.Width
        End Sub
#End Region
    End Class
End Namespace

'
'FilterBar.Designer.vb
'

Namespace Features
	Partial Class FilterBar
		''' <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.fpSpread = New FarPoint.Win.Spread.FpSpread()
			Me.fpSpread_Sheet1 = New FarPoint.Win.Spread.SheetView()
			Me.groupBox1 = New System.Windows.Forms.GroupBox()
			Me.btnUpdate = New System.Windows.Forms.Button()
			Me.numericUpDown = New System.Windows.Forms.NumericUpDown()
			Me.label6 = New System.Windows.Forms.Label()
			Me.label5 = New System.Windows.Forms.Label()
			Me.btnShadowColor = New System.Windows.Forms.Button()
			Me.btnHighlightColor = New System.Windows.Forms.Button()
			Me.label4 = New System.Windows.Forms.Label()
			Me.btnColor = New System.Windows.Forms.Button()
			Me.label3 = New System.Windows.Forms.Label()
			Me.comboGridType = New System.Windows.Forms.ComboBox()
			Me.label2 = New System.Windows.Forms.Label()
			Me.comboGridLine = New System.Windows.Forms.ComboBox()
			Me.label1 = New System.Windows.Forms.Label()
			Me.pnlMain.SuspendLayout()
			Me.pnlControls.SuspendLayout()
			DirectCast(Me.fpSpread, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.fpSpread_Sheet1, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.groupBox1.SuspendLayout()
			DirectCast(Me.numericUpDown, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.SuspendLayout()
			' 
			' pnlMain
			' 
			Me.pnlMain.Controls.Add(Me.fpSpread)
			' 
			' pnlControls
			' 
			Me.pnlControls.Controls.Add(Me.groupBox1)
			' 
			' fpSpread
			' 
			Me.fpSpread.Dock = System.Windows.Forms.DockStyle.Fill
			Me.fpSpread.Location = New System.Drawing.Point(0, 0)
			Me.fpSpread.Name = "fpSpread"
			Me.fpSpread.Sheets.AddRange(New FarPoint.Win.Spread.SheetView() {Me.fpSpread_Sheet1})
			Me.fpSpread.Size = New System.Drawing.Size(477, 487)
			Me.fpSpread.Skin = FarPoint.Win.Spread.DefaultSpreadSkins.Office2016White
			Me.fpSpread.StatusBarVisible = True
			Me.fpSpread.TabIndex = 0
			' 
			' fpSpread_Sheet1
			' 
			Me.fpSpread_Sheet1.Reset()
			Me.fpSpread_Sheet1.SheetName = "Sheet1"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' groupBox1
			' 
			Me.groupBox1.Controls.Add(Me.btnUpdate)
			Me.groupBox1.Controls.Add(Me.numericUpDown)
			Me.groupBox1.Controls.Add(Me.label6)
			Me.groupBox1.Controls.Add(Me.label5)
			Me.groupBox1.Controls.Add(Me.btnShadowColor)
			Me.groupBox1.Controls.Add(Me.btnHighlightColor)
			Me.groupBox1.Controls.Add(Me.label4)
			Me.groupBox1.Controls.Add(Me.btnColor)
			Me.groupBox1.Controls.Add(Me.label3)
			Me.groupBox1.Controls.Add(Me.comboGridType)
			Me.groupBox1.Controls.Add(Me.label2)
			Me.groupBox1.Controls.Add(Me.comboGridLine)
			Me.groupBox1.Controls.Add(Me.label1)
			Me.groupBox1.Dock = System.Windows.Forms.DockStyle.Top
			Me.groupBox1.Location = New System.Drawing.Point(0, 0)
			Me.groupBox1.Name = "groupBox1"
			Me.groupBox1.Size = New System.Drawing.Size(157, 304)
			Me.groupBox1.TabIndex = 0
			Me.groupBox1.TabStop = False
			Me.groupBox1.Text = "FilterBar Settings"
			' 
			' btnUpdate
			' 
			Me.btnUpdate.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.btnUpdate.Location = New System.Drawing.Point(45, 250)
			Me.btnUpdate.Name = "btnUpdate"
			Me.btnUpdate.Size = New System.Drawing.Size(75, 23)
			Me.btnUpdate.TabIndex = 11
			Me.btnUpdate.Text = "Update"
			Me.btnUpdate.UseVisualStyleBackColor = True
			' 
			' numericUpDown
			' 
			Me.numericUpDown.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.numericUpDown.Location = New System.Drawing.Point(63, 213)
			Me.numericUpDown.Minimum = New Decimal(New Integer() {1, 0, 0, -2147483648})
			Me.numericUpDown.Name = "numericUpDown"
			Me.numericUpDown.Size = New System.Drawing.Size(88, 20)
			Me.numericUpDown.TabIndex = 10
			' 
			' label6
			' 
			Me.label6.AutoSize = True
			Me.label6.Location = New System.Drawing.Point(9, 215)
			Me.label6.Name = "label6"
			Me.label6.Size = New System.Drawing.Size(38, 13)
			Me.label6.TabIndex = 9
			Me.label6.Text = "Width:"
			' 
			' label5
			' 
			Me.label5.AutoSize = True
			Me.label5.Location = New System.Drawing.Point(8, 175)
			Me.label5.Name = "label5"
			Me.label5.Size = New System.Drawing.Size(49, 26)
			Me.label5.TabIndex = 8
			Me.label5.Text = "Shadow " & vbCr & vbLf & "Color:"
			' 
			' btnShadowColor
			' 
			Me.btnShadowColor.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.btnShadowColor.Location = New System.Drawing.Point(63, 176)
			Me.btnShadowColor.Name = "btnShadowColor"
			Me.btnShadowColor.Size = New System.Drawing.Size(88, 23)
			Me.btnShadowColor.TabIndex = 7
			Me.btnShadowColor.UseVisualStyleBackColor = True
			' 
			' btnHighlightColor
			' 
			Me.btnHighlightColor.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.btnHighlightColor.Location = New System.Drawing.Point(61, 129)
			Me.btnHighlightColor.Name = "btnHighlightColor"
			Me.btnHighlightColor.Size = New System.Drawing.Size(90, 23)
			Me.btnHighlightColor.TabIndex = 7
			Me.btnHighlightColor.UseVisualStyleBackColor = True
			' 
			' label4
			' 
			Me.label4.AutoSize = True
			Me.label4.Location = New System.Drawing.Point(9, 127)
			Me.label4.Name = "label4"
			Me.label4.Size = New System.Drawing.Size(51, 26)
			Me.label4.TabIndex = 6
			Me.label4.Text = "Highlight " & vbCr & vbLf & "Color:"
			' 
			' btnColor
			' 
			Me.btnColor.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.btnColor.Location = New System.Drawing.Point(61, 89)
			Me.btnColor.Name = "btnColor"
			Me.btnColor.Size = New System.Drawing.Size(90, 23)
			Me.btnColor.TabIndex = 5
			Me.btnColor.UseVisualStyleBackColor = True
			' 
			' label3
			' 
			Me.label3.AutoSize = True
			Me.label3.Location = New System.Drawing.Point(9, 94)
			Me.label3.Name = "label3"
			Me.label3.Size = New System.Drawing.Size(34, 13)
			Me.label3.TabIndex = 4
			Me.label3.Text = "Color:"
			' 
			' comboGridType
			' 
			Me.comboGridType.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.comboGridType.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.comboGridType.FormattingEnabled = True
			Me.comboGridType.Location = New System.Drawing.Point(61, 57)
			Me.comboGridType.Name = "comboGridType"
			Me.comboGridType.Size = New System.Drawing.Size(90, 21)
			Me.comboGridType.TabIndex = 3
			' 
			' label2
			' 
			Me.label2.AutoSize = True
			Me.label2.Location = New System.Drawing.Point(6, 60)
			Me.label2.Name = "label2"
			Me.label2.Size = New System.Drawing.Size(34, 13)
			Me.label2.TabIndex = 2
			Me.label2.Text = "Type:"
			' 
			' comboGridLine
			' 
			Me.comboGridLine.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.comboGridLine.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.comboGridLine.FormattingEnabled = True
			Me.comboGridLine.Location = New System.Drawing.Point(61, 22)
			Me.comboGridLine.Name = "comboGridLine"
			Me.comboGridLine.Size = New System.Drawing.Size(90, 21)
			Me.comboGridLine.TabIndex = 1
			' 
			' label1
			' 
			Me.label1.AutoSize = True
			Me.label1.Location = New System.Drawing.Point(6, 25)
			Me.label1.Name = "label1"
			Me.label1.Size = New System.Drawing.Size(49, 13)
			Me.label1.TabIndex = 0
			Me.label1.Text = "GridLine:"
			' 
			' SpreadFilterBar
			' 
			Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
			Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
			Me.Name = "SpreadFilterBar"
			Me.pnlMain.ResumeLayout(False)
			Me.pnlControls.ResumeLayout(False)
			DirectCast(Me.fpSpread, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.fpSpread_Sheet1, System.ComponentModel.ISupportInitialize).EndInit()
			Me.groupBox1.ResumeLayout(False)
			Me.groupBox1.PerformLayout()
			DirectCast(Me.numericUpDown, System.ComponentModel.ISupportInitialize).EndInit()
			Me.ResumeLayout(False)

		End Sub

		#End Region

		Private fpSpread As FarPoint.Win.Spread.FpSpread
		Private fpSpread_Sheet1 As FarPoint.Win.Spread.SheetView
		Private groupBox1 As System.Windows.Forms.GroupBox
		Private comboGridType As System.Windows.Forms.ComboBox
		Private label2 As System.Windows.Forms.Label
		Private comboGridLine As System.Windows.Forms.ComboBox
		Private label1 As System.Windows.Forms.Label
		Private btnColor As System.Windows.Forms.Button
		Private label3 As System.Windows.Forms.Label
		Private numericUpDown As System.Windows.Forms.NumericUpDown
		Private label6 As System.Windows.Forms.Label
		Private label5 As System.Windows.Forms.Label
		Private btnShadowColor As System.Windows.Forms.Button
		Private btnHighlightColor As System.Windows.Forms.Button
		Private label4 As System.Windows.Forms.Label
		Private btnUpdate As System.Windows.Forms.Button
	End Class
End Namespace
