Imports System.Collections.Generic
Imports System.Data
Imports FarPoint.Win.Spread
Imports FarPoint.Win.Spread.Data
Imports Spread.Common.DataStore
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Features
    Partial Public Class TableStyles
        Inherits BaseSampleControl
#Region "Fields"
        Private _activeTable As TableView
        Private _dataSource As AccessDataSource
#End Region

#Region "ctor"
        Public Sub New()
            InitializeComponent()
            Name = "Table Styles"

            _dataSource = New DataService().AccessDataSource

            SetSheetProperties(fpSpread.ActiveSheet)
            AddSampleTable(fpSpread.ActiveSheet)

            LoadComboBoxStyles()

            AddHandler fpSpread.SelectionChanged, AddressOf FpSpread_SelectionChanged
            AddHandler comboStyle.SelectedIndexChanged, AddressOf ComboStyle_SelectedIndexChanged

            AddHandler chkHeaderRow.CheckedChanged, AddressOf ChkHeaderRow_CheckedChanged
            AddHandler chkFirstColumn.CheckedChanged, AddressOf ChkFirstColumn_CheckedChanged
            AddHandler chkTotalRow.CheckedChanged, AddressOf ChkTotalRow_CheckedChanged
            AddHandler chkLastColumn.CheckedChanged, AddressOf ChkLastColumn_CheckedChanged
            AddHandler chkBandedColumn.CheckedChanged, AddressOf ChkBandedColumn_CheckedChanged
            AddHandler chkBandedRow.CheckedChanged, AddressOf ChkBandedRow_CheckedChanged
            AddHandler chkFilterButton.CheckedChanged, AddressOf ChkFilterButton_CheckedChanged
        End Sub
#End Region

#Region "Private methods"
        Private Sub SetSheetProperties(sheet As SheetView)
            fpSpread.StatusBarVisible = True
            sheet.SetMultipleRowHeights(0, sheet.RowCount, 20)
            sheet.SetActiveCell(2, 1)
        End Sub

        Private Sub AddSampleTable(sheet As SheetView)
            Dim dataTable As DataTable = _dataSource.GetDataFromTable("Nwind.mdb", "Products").Tables(0)
            Dim adapter As New SpreadDataBindingAdapter()
            adapter.Spread = fpSpread
            adapter.SheetName = "Sheet1"
            adapter.DataSource = dataTable
            adapter.MapperInfo = New MapperInfo(2, 1, 30, dataTable.Columns.Count)
            adapter.FillSpreadDataByDataSource()

            Dim col As Integer = 1
            For Each column As DataColumn In dataTable.Columns
                sheet.Cells(1, System.Math.Max(System.Threading.Interlocked.Increment(col), col - 1)).Text = (column.Caption)
            Next

            _activeTable = sheet.AddTable("Table1", 1, 1, 31, dataTable.Columns.Count, TableStyle.TableStyleLight1)

            For j As Integer = 1 To col - 1
                sheet.Columns(j).Width = sheet.Columns(j).GetPreferredWidth()
            Next
        End Sub

        Private Sub LoadComboBoxStyles()
            Dim styles As List(Of String) = fpSpread.TableStyleCollection.BuiltInTableStyleName
            styles(0) = "None"
            comboStyle.DataSource = styles

            For Each style As Object In comboStyle.Items
                If style.ToString() = _activeTable.StyleName Then
                    comboStyle.SelectedItem = style
                    Exit For
                End If
            Next
        End Sub
#End Region

#Region "Event handlers"
        Private Sub FpSpread_SelectionChanged(sender As Object, e As SelectionChangedEventArgs)
            Dim isTableSelected As Boolean = fpSpread.ActiveSheet.GetTable(e.Range.Row, e.Range.Column) IsNot Nothing
            _activeTable = fpSpread.ActiveSheet.GetTable(e.Range.Row, e.Range.Column)
            chkHeaderRow.Enabled = isTableSelected
            chkFirstColumn.Enabled = isTableSelected
            chkTotalRow.Enabled = isTableSelected
            chkLastColumn.Enabled = isTableSelected
            chkBandedColumn.Enabled = isTableSelected
            chkBandedRow.Enabled = isTableSelected
            chkFilterButton.Enabled = isTableSelected
            comboStyle.Enabled = isTableSelected
        End Sub

        Private Sub ComboStyle_SelectedIndexChanged(sender As Object, e As EventArgs)
            Dim styleName As String = comboStyle.SelectedItem.ToString()
            _activeTable.StyleName = styleName
        End Sub

        Private Sub ChkFilterButton_CheckedChanged(sender As Object, e As EventArgs)
            If _activeTable IsNot Nothing Then
                _activeTable.FilterButtonVisible = chkFilterButton.Checked
            End If
        End Sub

        Private Sub ChkBandedRow_CheckedChanged(sender As Object, e As EventArgs)
            If _activeTable IsNot Nothing Then
                _activeTable.BandedRows = chkBandedRow.Checked
            End If
        End Sub

        Private Sub ChkBandedColumn_CheckedChanged(sender As Object, e As EventArgs)
            If _activeTable IsNot Nothing Then
                _activeTable.BandedColumns = chkBandedColumn.Checked
            End If
        End Sub

        Private Sub ChkLastColumn_CheckedChanged(sender As Object, e As EventArgs)
            If _activeTable IsNot Nothing Then
                _activeTable.LastColumn = chkLastColumn.Checked
            End If
        End Sub

        Private Sub ChkTotalRow_CheckedChanged(sender As Object, e As EventArgs)
            If _activeTable IsNot Nothing Then
                _activeTable.TotalRowVisible = chkTotalRow.Checked
            End If
        End Sub

        Private Sub ChkFirstColumn_CheckedChanged(sender As Object, e As EventArgs)
            If _activeTable IsNot Nothing Then
                _activeTable.FirstColumn = chkFirstColumn.Checked
            End If
        End Sub

        Private Sub ChkHeaderRow_CheckedChanged(sender As Object, e As EventArgs)
            If _activeTable IsNot Nothing Then
                _activeTable.HeaderRowVisible = chkHeaderRow.Checked
            End If
        End Sub
#End Region
    End Class
End Namespace

'
'TableStyles.Designer.vb
'

Namespace Features
	Partial Class TableStyles
		''' <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 Overloads 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.label1 = New System.Windows.Forms.Label()
			Me.chkHeaderRow = New System.Windows.Forms.CheckBox()
			Me.chkFirstColumn = New System.Windows.Forms.CheckBox()
			Me.chkTotalRow = New System.Windows.Forms.CheckBox()
			Me.chkBandedRow = New System.Windows.Forms.CheckBox()
			Me.chkBandedColumn = New System.Windows.Forms.CheckBox()
			Me.chkLastColumn = New System.Windows.Forms.CheckBox()
			Me.chkFilterButton = New System.Windows.Forms.CheckBox()
			Me.comboStyle = New System.Windows.Forms.ComboBox()
			Me.label2 = 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.SuspendLayout()
			' 
			' pnlMain
			' 
			Me.pnlMain.Controls.Add(Me.fpSpread)
			Me.pnlMain.Size = New System.Drawing.Size(505, 487)
			' 
			' pnlControls
			' 
			Me.pnlControls.Controls.Add(Me.label2)
			Me.pnlControls.Controls.Add(Me.comboStyle)
			Me.pnlControls.Controls.Add(Me.chkFilterButton)
			Me.pnlControls.Controls.Add(Me.chkLastColumn)
			Me.pnlControls.Controls.Add(Me.chkBandedColumn)
			Me.pnlControls.Controls.Add(Me.chkBandedRow)
			Me.pnlControls.Controls.Add(Me.chkTotalRow)
			Me.pnlControls.Controls.Add(Me.chkFirstColumn)
			Me.pnlControls.Controls.Add(Me.chkHeaderRow)
			Me.pnlControls.Controls.Add(Me.label1)
			Me.pnlControls.Size = New System.Drawing.Size(167, 487)
			' 
			' 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(505, 487)
			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
			' 
			' label1
			' 
			Me.label1.AutoSize = True
			Me.label1.Location = New System.Drawing.Point(5, 24)
			Me.label1.Name = "label1"
			Me.label1.Size = New System.Drawing.Size(141, 13)
			Me.label1.TabIndex = 0
			Me.label1.Text = "Please select the table area:"
			' 
			' chkHeaderRow
			' 
			Me.chkHeaderRow.AutoSize = True
			Me.chkHeaderRow.Checked = True
			Me.chkHeaderRow.CheckState = System.Windows.Forms.CheckState.Checked
			Me.chkHeaderRow.Location = New System.Drawing.Point(8, 49)
			Me.chkHeaderRow.Name = "chkHeaderRow"
			Me.chkHeaderRow.Size = New System.Drawing.Size(86, 17)
			Me.chkHeaderRow.TabIndex = 1
			Me.chkHeaderRow.Text = "Header Row"
			Me.chkHeaderRow.UseVisualStyleBackColor = True
			' 
			' chkFirstColumn
			' 
			Me.chkFirstColumn.AutoSize = True
			Me.chkFirstColumn.Location = New System.Drawing.Point(8, 72)
			Me.chkFirstColumn.Name = "chkFirstColumn"
			Me.chkFirstColumn.Size = New System.Drawing.Size(83, 17)
			Me.chkFirstColumn.TabIndex = 2
			Me.chkFirstColumn.Text = "First Column"
			Me.chkFirstColumn.UseVisualStyleBackColor = True
			' 
			' chkTotalRow
			' 
			Me.chkTotalRow.AutoSize = True
			Me.chkTotalRow.Location = New System.Drawing.Point(8, 95)
			Me.chkTotalRow.Name = "chkTotalRow"
			Me.chkTotalRow.Size = New System.Drawing.Size(75, 17)
			Me.chkTotalRow.TabIndex = 3
			Me.chkTotalRow.Text = "Total Row"
			Me.chkTotalRow.UseVisualStyleBackColor = True
			' 
			' chkBandedRow
			' 
			Me.chkBandedRow.AutoSize = True
			Me.chkBandedRow.Checked = True
			Me.chkBandedRow.CheckState = System.Windows.Forms.CheckState.Checked
			Me.chkBandedRow.Location = New System.Drawing.Point(8, 164)
			Me.chkBandedRow.Name = "chkBandedRow"
			Me.chkBandedRow.Size = New System.Drawing.Size(88, 17)
			Me.chkBandedRow.TabIndex = 4
			Me.chkBandedRow.Text = "Banded Row"
			Me.chkBandedRow.UseVisualStyleBackColor = True
			' 
			' chkBandedColumn
			' 
			Me.chkBandedColumn.AutoSize = True
			Me.chkBandedColumn.Location = New System.Drawing.Point(8, 141)
			Me.chkBandedColumn.Name = "chkBandedColumn"
			Me.chkBandedColumn.Size = New System.Drawing.Size(101, 17)
			Me.chkBandedColumn.TabIndex = 5
			Me.chkBandedColumn.Text = "Banded Column"
			Me.chkBandedColumn.UseVisualStyleBackColor = True
			' 
			' chkLastColumn
			' 
			Me.chkLastColumn.AutoSize = True
			Me.chkLastColumn.Location = New System.Drawing.Point(8, 118)
			Me.chkLastColumn.Name = "chkLastColumn"
			Me.chkLastColumn.Size = New System.Drawing.Size(84, 17)
			Me.chkLastColumn.TabIndex = 6
			Me.chkLastColumn.Text = "Last Column"
			Me.chkLastColumn.UseVisualStyleBackColor = True
			' 
			' chkFilterButton
			' 
			Me.chkFilterButton.AutoSize = True
			Me.chkFilterButton.Checked = True
			Me.chkFilterButton.CheckState = System.Windows.Forms.CheckState.Checked
			Me.chkFilterButton.Location = New System.Drawing.Point(8, 187)
			Me.chkFilterButton.Name = "chkFilterButton"
			Me.chkFilterButton.Size = New System.Drawing.Size(82, 17)
			Me.chkFilterButton.TabIndex = 7
			Me.chkFilterButton.Text = "Filter Button"
			Me.chkFilterButton.UseVisualStyleBackColor = True
			' 
			' comboStyle
			' 
			Me.comboStyle.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.comboStyle.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.comboStyle.FormattingEnabled = True
			Me.comboStyle.Location = New System.Drawing.Point(8, 244)
			Me.comboStyle.Name = "comboStyle"
			Me.comboStyle.Size = New System.Drawing.Size(138, 21)
			Me.comboStyle.TabIndex = 1
			' 
			' label2
			' 
			Me.label2.AutoSize = True
			Me.label2.Location = New System.Drawing.Point(5, 228)
			Me.label2.Name = "label2"
			Me.label2.Size = New System.Drawing.Size(72, 13)
			Me.label2.TabIndex = 8
			Me.label2.Text = "Built-in Styles:"
			' 
			' TableStyles
			' 
			Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
			Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
			Me.Name = "TableStyles"
			Me.Size = New System.Drawing.Size(673, 487)
			Me.pnlMain.ResumeLayout(False)
			Me.pnlControls.ResumeLayout(False)
			Me.pnlControls.PerformLayout()
			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
		Private chkLastColumn As System.Windows.Forms.CheckBox
		Private chkBandedColumn As System.Windows.Forms.CheckBox
		Private chkBandedRow As System.Windows.Forms.CheckBox
		Private chkTotalRow As System.Windows.Forms.CheckBox
		Private chkFirstColumn As System.Windows.Forms.CheckBox
		Private chkHeaderRow As System.Windows.Forms.CheckBox
		Private label1 As System.Windows.Forms.Label
		Private chkFilterButton As System.Windows.Forms.CheckBox
		Private label2 As System.Windows.Forms.Label
		Private comboStyle As System.Windows.Forms.ComboBox
	End Class
End Namespace
