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

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

        Public Sub New()
            InitializeComponent()
            Name = "Filter Gadget"
            _dataSource = New DataService().AccessDataSource

            InitSpreadSheet(fpSpread.ActiveSheet)
        End Sub

        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

            For col As Integer = 0 To sheet.ColumnCount - 1
                sheet.Columns(col).AllowAutoFilter = True
                sheet.Columns(col).Width = sheet.GetPreferredColumnWidth(col, PreferredSizeColumnOptions.IncludeAll)
            Next
            sheet.AutoFilterMode = AutoFilterMode.FilterGadget
        End Sub
    End Class
End Namespace

'
'FilterGadget.Designer.vb
'

Namespace Features
	Partial Class FilterGadget
		''' <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.pnlMain.SuspendLayout()
			DirectCast(Me.fpSpread, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.fpSpread_Sheet1, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.SuspendLayout()
			' 
			' pnlMain
			' 
			Me.pnlMain.Controls.Add(Me.fpSpread)
			' 
			' 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
			' 
			' SpreadFilterGadget
			' 
			Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
			Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
			Me.Name = "SpreadFilterGadget"
			Me.pnlMain.ResumeLayout(False)
			DirectCast(Me.fpSpread, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.fpSpread_Sheet1, 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
	End Class
End Namespace
