Imports System.Data
Imports Spread.Common.DataStore
Imports FarPoint.Win.Spread
Imports FarPoint.Win.Spread.Data
Imports FarPoint.Win.Spread.DrawingSpace
Imports FarPoint.Win.Spread.Model
Imports Spread.Common.Features.Spread.Common.Features.Sample

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

        Public Sub New()
            InitializeComponent()

            Name = "Camera Shapes"
            _dataSource = New DataService().AccessDataSource

            InitSpreadSheet(FpSpread.ActiveSheet)

            AddHandler txtRow.TextChanged, AddressOf TextBox_TextChanged
            AddHandler txtColumn.TextChanged, AddressOf TextBox_TextChanged
            AddHandler FpSpread.SelectionChanged, AddressOf FpSpread_SelectionChanged
            AddHandler btnAddShape.Click, AddressOf BtnAddShape_Click

            AddHandler FpSpread.ShapeActivated, AddressOf FpSpread_ShapeActivated
        End Sub

        Private Sub InitSpreadSheet(sheet As SheetView)
            sheet.SetMultipleRowHeights(0, sheet.RowCount, 20)

            Dim table As DataTable = _dataSource.GetDataFrom("fpWine.mdb", "select ProductID, VendorID, Product, Description," & "Price, QtyInStock from Products").Tables(0)
            Dim adapter As New SpreadDataBindingAdapter()
            adapter.DataAutoCellTypes = True
            adapter.DataSource = table
            adapter.MapperInfo = New MapperInfo(0, 0, table.Rows.Count, table.Columns.Count)
            adapter.Spread = FpSpread
            adapter.SheetName = FpSpread.ActiveSheet.SheetName
            adapter.FillSpreadDataByDataSource()

            For col As Integer = 0 To table.Columns.Count - 1
                sheet.Columns(col).Label = table.Columns(col).ColumnName
            Next

            sheet.Columns(2).Width = 120
            sheet.Columns(3).Width = 300
            sheet.Columns(4).Width = 80
            sheet.Columns(5).Width = 100
        End Sub

        Private Function ValidateInput() As Boolean
            If Not FpSpread.ActiveSheet.GetSelection(0).IsValidRange(FpSpread.ActiveSheet) Then
                Return False
            End If

            Dim val As Integer = -1
            If Not Integer.TryParse(txtRow.Text, val) OrElse Not Integer.TryParse(txtColumn.Text, val) Then
                Return False
            End If

            Return True
        End Function

#Region "Event handlers"
        Private Sub FpSpread_ShapeActivated(sender As Object, e As EventArgs)
            Dim shape As PSShape = TryCast(FpSpread.ActiveWindowlessObject, PSShape)
            shape.ForeColor = System.Drawing.Color.Beige
        End Sub

        Private Sub BtnAddShape_Click(sender As Object, e As EventArgs)
            Dim cellRange As CellRange = FpSpread.ActiveSheet.GetSelection(0)
            Dim shape As New SpreadCameraShape(FpSpread.ActiveSheet, cellRange)

            Dim row As Integer = Integer.Parse(txtRow.Text)
            Dim col As Integer = Integer.Parse(txtColumn.Text)
            FpSpread.ActiveSheet.AddShape(shape, row, col)
        End Sub

        Private Sub FpSpread_SelectionChanged(sender As Object, e As SelectionChangedEventArgs)
            btnAddShape.Enabled = ValidateInput()
        End Sub

        Private Sub TextBox_TextChanged(sender As Object, e As EventArgs)
            btnAddShape.Enabled = ValidateInput()
        End Sub
#End Region
    End Class
End Namespace

'
'CameraShapes.Designer.vb
'

Namespace Features
    Partial Class CameraShapes
        ''' <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.label2 = New System.Windows.Forms.Label()
            Me.label3 = New System.Windows.Forms.Label()
            Me.txtRow = New System.Windows.Forms.TextBox()
            Me.txtColumn = New System.Windows.Forms.TextBox()
            Me.btnAddShape = New System.Windows.Forms.Button()
            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)
            ' 
            ' pnlControls
            ' 
            Me.pnlControls.Controls.Add(Me.btnAddShape)
            Me.pnlControls.Controls.Add(Me.txtColumn)
            Me.pnlControls.Controls.Add(Me.txtRow)
            Me.pnlControls.Controls.Add(Me.label3)
            Me.pnlControls.Controls.Add(Me.label2)
            Me.pnlControls.Controls.Add(Me.label1)
            ' 
            ' 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.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
            ' 
            ' label1
            ' 
            Me.label1.Dock = System.Windows.Forms.DockStyle.Top
            Me.label1.Font = New System.Drawing.Font("Segoe UI", 9.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CByte(0))
            Me.label1.Location = New System.Drawing.Point(0, 0)
            Me.label1.Name = "label1"
            Me.label1.Size = New System.Drawing.Size(157, 42)
            Me.label1.TabIndex = 0
            Me.label1.Text = "Select a range of cells and set destination position for the Camera Shape"
            ' 
            ' label2
            ' 
            Me.label2.AutoSize = True
            Me.label2.Location = New System.Drawing.Point(5, 57)
            Me.label2.Name = "label2"
            Me.label2.Size = New System.Drawing.Size(32, 13)
            Me.label2.TabIndex = 1
            Me.label2.Text = "Row:"
            ' 
            ' label3
            ' 
            Me.label3.AutoSize = True
            Me.label3.Location = New System.Drawing.Point(5, 83)
            Me.label3.Name = "label3"
            Me.label3.Size = New System.Drawing.Size(45, 13)
            Me.label3.TabIndex = 2
            Me.label3.Text = "Column:"
            ' 
            ' txtRow
            ' 
            Me.txtRow.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
            Me.txtRow.Location = New System.Drawing.Point(59, 54)
            Me.txtRow.Name = "txtRow"
            Me.txtRow.Size = New System.Drawing.Size(86, 20)
            Me.txtRow.TabIndex = 3
            ' 
            ' txtColumn
            ' 
            Me.txtColumn.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
            Me.txtColumn.Location = New System.Drawing.Point(59, 80)
            Me.txtColumn.Name = "txtColumn"
            Me.txtColumn.Size = New System.Drawing.Size(86, 20)
            Me.txtColumn.TabIndex = 4
            ' 
            ' btnAddShape
            ' 
            Me.btnAddShape.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
            Me.btnAddShape.Enabled = False
            Me.btnAddShape.Location = New System.Drawing.Point(22, 113)
            Me.btnAddShape.Name = "btnAddShape"
            Me.btnAddShape.Size = New System.Drawing.Size(118, 26)
            Me.btnAddShape.TabIndex = 5
            Me.btnAddShape.Text = "Add Camera Shape"
            Me.btnAddShape.UseVisualStyleBackColor = True
            ' 
            ' CameraShapes
            ' 
            Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0F, 13.0F)
            Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
            Me.Name = "CameraShapes"
            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 label1 As System.Windows.Forms.Label
        Private btnAddShape As System.Windows.Forms.Button
        Private txtColumn As System.Windows.Forms.TextBox
        Private txtRow As System.Windows.Forms.TextBox
        Private label3 As System.Windows.Forms.Label
        Private label2 As System.Windows.Forms.Label
    End Class
End Namespace
