Imports System
Imports System.Collections.Generic
Imports System.Drawing
Imports System.Data
Imports System.Windows.Forms
Imports FarPoint.Win.Spread
Imports GrapeCity.Spreadsheet
Imports GrapeCity.Spreadsheet.Slicers
Imports GrapeCity.Spreadsheet.Drawing
Imports FarPoint.Win.Spread.Data
Imports Spread.Common.DataStore
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Spread.Slicers.Features
  Public Class Introduction
    Inherits BaseSampleControl
    Public Sub New()
      InitializeComponent()
      InitStylesMenuItems()

      Dim dataSource As AccessDataSource = New DataService().AccessDataSource
      Dim dataTable As DataTable = dataSource.GetNWINDData("Suppliers").Tables(0)

      'Reduce table size for fit layout
      If (dataTable.Rows.Count > 10) Then
        Do While dataTable.Rows.Count > 10
          dataTable.Rows.RemoveAt(dataTable.Rows.Count - 1)
        Loop
        dataTable.AcceptChanges()
      End If

      Dim adapter As New SpreadDataBindingAdapter()
      adapter.Spread = fpSpread1
      adapter.SheetName = "Sheet1"
      adapter.DataSource = dataTable
      adapter.MapperInfo = New MapperInfo(1, 0, 30, dataTable.Columns.Count)
      adapter.FillSpreadDataByDataSource()

      'code for table
      Dim size As Single
      Dim col As Integer = 0
      For Each column As DataColumn In dataTable.Columns
        fpSpread1.Sheets(0).Cells(0, col).Text = (column.Caption)
        size = fpSpread1.Sheets(0).Columns(col).GetPreferredWidth()
        fpSpread1.Sheets(0).Columns(col).Width = size
        col += 1
      Next


      fpSpread1.Features.RichClipboard = True
      fpSpread1.Features.EnhancedShapeEngine = True



      Dim workbook As IWorkbook = fpSpread1.AsWorkbook()

      Dim worksheet As IWorksheet = workbook.Worksheets(0)

      Dim table As ITable = worksheet.Range("A1:L11").CreateTable(True)

      Dim cache As ISlicerCache = workbook.SlicerCaches.Add(table, 8, "Country")
      Dim slicer As ISlicer = cache.Slicers.Add(worksheet, "Country", "Country", 100, 220, 250, 200)


      ' apply built-in style "Dark5"
      slicer.Style = workbook.TableStyles(BuiltInSlicerStyles.SlicerStyleDark5)
      ' make that menu item appear "checked"
      Dim item As ToolStripMenuItem = DirectCast(styleToolStripMenuItem.DropDownItems("Dark5"), ToolStripMenuItem)
      item.Checked = True

      fpSpread1.ActiveSheet.Columns(6).Visible = False
      fpSpread1.ActiveSheet.Columns(10, 11).Visible = False
      ' activate the worksheet and select the slicer shape
      worksheet.Activate()

      worksheet.Slicers(0).Shape.[Select]()
      AddHandler workbook.WorkbookSet.UIManager.ShapeChanged, AddressOf UIManager_ShapeChanged
    End Sub

    Private Sub EnableSlicerMenuItems(enable As Boolean)
      removeToolStripMenuItem.Enabled = enable
      styleToolStripMenuItem.Enabled = enable
      settingsToolStripMenuItem.Enabled = enable
    End Sub

    Private Sub SetSlicerStyleSelected(shape As IShape)
      Dim workbook As IWorkbook = fpSpread1.AsWorkbook()
      Dim worksheet As IWorksheet = workbook.ActiveSheet
      For Each item As ToolStripMenuItem In styleToolStripMenuItem.DropDownItems
        item.Checked = False
      Next
      For n As Integer = 0 To worksheet.Slicers.Count - 1
        Dim slicer As ISlicer = worksheet.Slicers(n)
        If slicer.Shape Is shape AndAlso slicer.Style.BuiltIn Then
          Dim name As String = slicer.Style.Name.Substring(11, slicer.Style.Name.Length - 11)
          Dim item As ToolStripMenuItem = TryCast(styleToolStripMenuItem.DropDownItems(name), ToolStripMenuItem)
          If item IsNot Nothing Then
            item.Checked = True
          End If
        End If
      Next
    End Sub

    Private Sub UIManager_ShapeChanged(sender As Object, e As ShapeEventArgs)
      If e.Type = ShapeChangeType.Selection Then
        Dim shape As IShape = e.Shape
        If shape IsNot Nothing AndAlso shape.Type = ShapeType.Slicer AndAlso shape.Selected Then
          EnableSlicerMenuItems(True)
        Else
          For Each s As IShape In e.Shapes
            If s.Type = ShapeType.Slicer Then
              If s.Selected Then
                EnableSlicerMenuItems(True)
                SetSlicerStyleSelected(s)
                Exit For
              Else
                EnableSlicerMenuItems(False)
              End If
            End If
          Next
        End If
      End If
    End Sub

    Private Sub InitStylesMenuItems()
      styleToolStripMenuItem.DropDownItems.Add("Light1", Resource1.Light1, AddressOf slicerBuiltInStyle_Click).Name = "Light1"
      styleToolStripMenuItem.DropDownItems.Add("Light2", Resource1.Light2, AddressOf slicerBuiltInStyle_Click).Name = "Light2"
      styleToolStripMenuItem.DropDownItems.Add("Light3", Resource1.Light3, AddressOf slicerBuiltInStyle_Click).Name = "Light3"
      styleToolStripMenuItem.DropDownItems.Add("Light4", Resource1.Light4, AddressOf slicerBuiltInStyle_Click).Name = "Light4"
      styleToolStripMenuItem.DropDownItems.Add("Light5", Resource1.Light5, AddressOf slicerBuiltInStyle_Click).Name = "Light5"
      styleToolStripMenuItem.DropDownItems.Add("Light6", Resource1.Light6, AddressOf slicerBuiltInStyle_Click).Name = "Light6"
      styleToolStripMenuItem.DropDownItems.Add("Other1", Resource1.Other1, AddressOf slicerBuiltInStyle_Click).Name = "Other1"
      styleToolStripMenuItem.DropDownItems.Add("Other2", Resource1.Other2, AddressOf slicerBuiltInStyle_Click).Name = "Other1"
      styleToolStripMenuItem.DropDownItems.Add("Dark1", Resource1.Dark1, AddressOf slicerBuiltInStyle_Click).Name = "Dark1"
      styleToolStripMenuItem.DropDownItems.Add("Dark2", Resource1.Dark2, AddressOf slicerBuiltInStyle_Click).Name = "Dark2"
      styleToolStripMenuItem.DropDownItems.Add("Dark3", Resource1.Dark3, AddressOf slicerBuiltInStyle_Click).Name = "Dark3"
      styleToolStripMenuItem.DropDownItems.Add("Dark4", Resource1.Dark4, AddressOf slicerBuiltInStyle_Click).Name = "Dark4"
      styleToolStripMenuItem.DropDownItems.Add("Dark5", Resource1.Dark5, AddressOf slicerBuiltInStyle_Click).Name = "Dark5"
      styleToolStripMenuItem.DropDownItems.Add("Dark6", Resource1.Dark6, AddressOf slicerBuiltInStyle_Click).Name = "Dark6"
    End Sub

    Private Sub slicerBuiltInStyle_Click(sender As Object, e As EventArgs)
      Dim workbook As IWorkbook = fpSpread1.AsWorkbook()
      Dim style As ITableStyle = workbook.TableStyles(CInt(GetType(BuiltInSlicerStyles).GetEnumValues().GetValue(styleToolStripMenuItem.DropDownItems.IndexOf(DirectCast(sender, ToolStripItem)))))
      Dim slicers As ISlicers = workbook.ActiveSheet.Slicers
      Dim count As Integer = slicers.Count
      For i As Integer = 0 To count - 1
        If slicers(i).Shape.Selected Then
          slicers(i).Style = style
        End If
      Next
    End Sub

    Private Sub SettingsToolStripMenuItem_Click(sender As Object, e As EventArgs)
      Dim workbook As IWorkbook = fpSpread1.AsWorkbook()
      Dim worksheet As IWorksheet = workbook.Worksheets(0)
      Dim selectedSlicers As New List(Of ISlicer)()
      Dim slicers As ISlicers = workbook.ActiveSheet.Slicers
      Dim count As Integer = slicers.Count
      For i As Integer = 0 To count - 1
        If slicers(i).Shape.Selected Then
          selectedSlicers.Add(slicers(i))
        End If
      Next
      Dim form As New SlicerSettingsForm(selectedSlicers.ToArray(), workbook)
      form.ShowDialog()
    End Sub

    Private Sub FpSpread1_LeaveCell(sender As Object, e As LeaveCellEventArgs)
      Dim workbook As IWorkbook = fpSpread1.AsWorkbook()
      Dim worksheet As IWorksheet = workbook.ActiveSheet
      For iTable As Integer = 0 To worksheet.Tables.Count - 1
        Dim table As ITable = worksheet.Tables(iTable)
        If table.Range.Row <= e.Row AndAlso e.Row <= table.Range.Row2 AndAlso table.Range.Column <= e.Column AndAlso e.Column <= table.Range.Column2 Then
          addToolStripMenuItem.Enabled = False
        End If
      Next
    End Sub

    Private Sub FpSpread1_EnterCell(sender As Object, e As EnterCellEventArgs)
      Dim workbook As IWorkbook = fpSpread1.AsWorkbook()
      Dim worksheet As IWorksheet = workbook.ActiveSheet
      For iTable As Integer = 0 To worksheet.Tables.Count - 1
        Dim table As ITable = worksheet.Tables(iTable)
        If table.Range.Row <= e.Row AndAlso e.Row <= table.Range.Row2 AndAlso table.Range.Column <= e.Column AndAlso e.Column <= table.Range.Column2 Then
          addToolStripMenuItem.Enabled = True
          Exit For
        End If
      Next
    End Sub

    Private Sub AddToolStripMenuItem_Click(sender As Object, e As EventArgs)
      Dim row As Integer = fpSpread1.ActiveSheet.ActiveRowIndex
      Dim column As Integer = fpSpread1.ActiveSheet.ActiveColumnIndex
      Dim workbook As IWorkbook = fpSpread1.AsWorkbook()
      Dim worksheet As IWorksheet = workbook.ActiveSheet
      Dim table As ITable = Nothing

      For iTable As Integer = 0 To worksheet.Tables.Count - 1
        table = worksheet.Tables(iTable)
        If table.Range.Row <= row AndAlso row <= table.Range.Row2 AndAlso table.Range.Column <= column AndAlso column <= table.Range.Column2 Then
          Exit For
        End If
      Next
      If table Is Nothing Then
        Return
      End If
      Dim dlg As New SlicerInsertForm(table, New Point(25, 25))
      dlg.ShowDialog(Me)
    End Sub

    Private Sub RemoveToolStripMenuItem_Click(sender As Object, e As EventArgs)
      Dim workbook As IWorkbook = fpSpread1.AsWorkbook()
      Dim worksheet As IWorksheet = workbook.Worksheets(0)
      Dim selectedSlicers As New List(Of ISlicer)()
      Dim slicers As ISlicers = workbook.ActiveSheet.Slicers
      Dim count As Integer = slicers.Count
      For i As Integer = 0 To count - 1
        If slicers(i).Shape.Selected Then
          selectedSlicers.Add(slicers(i))
        End If
      Next
      For Each slicer As ISlicer In selectedSlicers
        slicer.Delete()
      Next
    End Sub
  End Class
End Namespace

'
'Introduction.Designer.vb
'

Namespace Spread.Slicers.Features
  <Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()>
  Partial Class Introduction
    'UserControl overrides dispose to clean up the component list.
    <System.Diagnostics.DebuggerNonUserCode()>
    Protected Shadows Sub Dispose(ByVal disposing As Boolean)
      Try
        If disposing AndAlso components IsNot Nothing Then
          components.Dispose()
        End If
      Finally
        MyBase.Dispose(disposing)
      End Try
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    <System.Diagnostics.DebuggerStepThrough()>
    Private Sub InitializeComponent()
      Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(Introduction))
      Me.fpSpread1 = New FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, CType(resources.GetObject("pnlMain.Controls"), Object))
      Me.fpSpread1_Sheet1 = Me.fpSpread1.GetSheet(0)
      Me.menuStrip1 = New System.Windows.Forms.MenuStrip()
      Me.slicerToolStripMenuItem = New System.Windows.Forms.ToolStripMenuItem()
      Me.addToolStripMenuItem = New System.Windows.Forms.ToolStripMenuItem()
      Me.removeToolStripMenuItem = New System.Windows.Forms.ToolStripMenuItem()
      Me.toolStripMenuItem1 = New System.Windows.Forms.ToolStripSeparator()
      Me.styleToolStripMenuItem = New System.Windows.Forms.ToolStripMenuItem()
      Me.settingsToolStripMenuItem = New System.Windows.Forms.ToolStripMenuItem()
      Me.pnlMain.SuspendLayout()
      CType(Me.fpSpread1, System.ComponentModel.ISupportInitialize).BeginInit()
      Me.menuStrip1.SuspendLayout()
      Me.SuspendLayout()
      '
      'pnlMain
      '
      Me.pnlMain.Controls.Add(Me.fpSpread1)
      Me.pnlMain.Controls.Add(Me.menuStrip1)
      '
      'fpSpread1
      '
      Me.fpSpread1.AccessibleDescription = "fpSpread1, Sheet1, Row 0, Column 0"
      Me.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill
      Me.fpSpread1.Font = New System.Drawing.Font("Calibri", 11.0!)
      Me.fpSpread1.Location = New System.Drawing.Point(0, 24)
      Me.fpSpread1.Name = "fpSpread1"
      Me.fpSpread1.Size = New System.Drawing.Size(477, 463)
      Me.fpSpread1.TabIndex = 2
      '
      'menuStrip1
      '
      Me.menuStrip1.Items.AddRange(New System.Windows.Forms.ToolStripItem() {Me.slicerToolStripMenuItem})
      Me.menuStrip1.Location = New System.Drawing.Point(0, 0)
      Me.menuStrip1.Name = "menuStrip1"
      Me.menuStrip1.Size = New System.Drawing.Size(477, 24)
      Me.menuStrip1.TabIndex = 3
      Me.menuStrip1.Text = "menuStrip1"
      '
      'slicerToolStripMenuItem
      '
      Me.slicerToolStripMenuItem.DropDownItems.AddRange(New System.Windows.Forms.ToolStripItem() {Me.addToolStripMenuItem, Me.removeToolStripMenuItem, Me.toolStripMenuItem1, Me.styleToolStripMenuItem, Me.settingsToolStripMenuItem})
      Me.slicerToolStripMenuItem.Name = "slicerToolStripMenuItem"
      Me.slicerToolStripMenuItem.Size = New System.Drawing.Size(47, 20)
      Me.slicerToolStripMenuItem.Text = "Slicer"
      '
      'addToolStripMenuItem
      '
      Me.addToolStripMenuItem.Name = "addToolStripMenuItem"
      Me.addToolStripMenuItem.Size = New System.Drawing.Size(125, 22)
      Me.addToolStripMenuItem.Text = "Insert..."
      AddHandler Me.addToolStripMenuItem.Click, New System.EventHandler(AddressOf Me.AddToolStripMenuItem_Click)
      '
      'removeToolStripMenuItem
      '
      Me.removeToolStripMenuItem.Name = "removeToolStripMenuItem"
      Me.removeToolStripMenuItem.Size = New System.Drawing.Size(125, 22)
      Me.removeToolStripMenuItem.Text = "Remove"
      AddHandler Me.removeToolStripMenuItem.Click, New System.EventHandler(AddressOf Me.RemoveToolStripMenuItem_Click)
      '
      'toolStripMenuItem1
      '
      Me.toolStripMenuItem1.Name = "toolStripMenuItem1"
      Me.toolStripMenuItem1.Size = New System.Drawing.Size(122, 6)
      '
      'styleToolStripMenuItem
      '
      Me.styleToolStripMenuItem.Name = "styleToolStripMenuItem"
      Me.styleToolStripMenuItem.Size = New System.Drawing.Size(125, 22)
      Me.styleToolStripMenuItem.Text = "Style"
      '
      'settingsToolStripMenuItem
      '
      Me.settingsToolStripMenuItem.Name = "settingsToolStripMenuItem"
      Me.settingsToolStripMenuItem.Size = New System.Drawing.Size(125, 22)
      Me.settingsToolStripMenuItem.Text = "Settings..."
      AddHandler Me.settingsToolStripMenuItem.Click, New System.EventHandler(AddressOf Me.SettingsToolStripMenuItem_Click)
      '
      'Introduction
      '
      Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
      Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
      Me.Name = "Introduction"
      Me.pnlMain.ResumeLayout(False)
      Me.pnlMain.PerformLayout()
      CType(Me.fpSpread1, System.ComponentModel.ISupportInitialize).EndInit()
      Me.menuStrip1.ResumeLayout(False)
      Me.menuStrip1.PerformLayout()
      Me.ResumeLayout(False)

    End Sub

    Private WithEvents fpSpread1 As FarPoint.Win.Spread.FpSpread
    Private WithEvents menuStrip1 As System.Windows.Forms.MenuStrip
    Private WithEvents slicerToolStripMenuItem As System.Windows.Forms.ToolStripMenuItem
    Private WithEvents addToolStripMenuItem As System.Windows.Forms.ToolStripMenuItem
    Private WithEvents removeToolStripMenuItem As System.Windows.Forms.ToolStripMenuItem
    Private WithEvents toolStripMenuItem1 As System.Windows.Forms.ToolStripSeparator
    Private WithEvents styleToolStripMenuItem As System.Windows.Forms.ToolStripMenuItem
    Private WithEvents settingsToolStripMenuItem As System.Windows.Forms.ToolStripMenuItem
    Friend WithEvents fpSpread1_Sheet1 As FarPoint.Win.Spread.SheetView
  End Class
End Namespace
