﻿Imports System.Collections.Generic
Imports System.ComponentModel
Imports System.Drawing
Imports System.Data
Imports System.Linq
Imports System.Text
Imports System.Threading.Tasks
Imports System.Windows.Forms

Imports GrapeCity.Win.Spread.InputMan.CellType
Imports Spread.Common.DataStore
Imports FarPoint.Win.Spread
Imports GrapeCity.Win.Spread.InputMan.CellType.Fields
Imports Spread.Common.Features.Spread.Common.Features.Sample
Imports FarPoint.Win.Spread.CellType

Namespace Features
    Partial Public Class GCInputManDemo
        Inherits BaseSampleControl
        Public Sub New()
            InitializeComponent()
            Name = "New MESCIUS InputMan"
            spread.ActiveSheet = spread.Sheets(0)

            'Initialize Sheets
            InitTextBoxSheetView()
            InitComboBoxSheetView()
            InitDateTimeSheetView()
            InitNumberSheetView()
            InitMaskCellSheetView()
            InitCharMaskCellSheetView()
            InitTimeSpanCellSheetView()
        End Sub
        Private Sub InitTextBoxSheetView()
            'Initialize Data
            sViewTextBox.DataSource = New DataService().AccessDataSource.GetNWINDData("Customers")

            sViewTextBox.Rows.[Default].Height = 25
            sViewTextBox.Columns(1).Font = New Font(FontFamily.GenericMonospace, 8, FontStyle.Italic)

            Dim autoCompleteStringCollection As New AutoCompleteStringCollection()
            Dim suggestionList As String() = ("Benjamin,Bruce,Cheryl,Daniel,Dave,Eric,Hana,Harol," & "Henry,Jane,Jessica,John,Julia,Kathy,Lance,Laura,Mark,Marry," & "Meggie,Mike,Naomi,Paul,Peter,Roger,Rose,Ruth,Ryan,Shirley," & "Tan,Thomas,Tony, Varun,$1234, VND1234, 12345 %,13 %," & "02/19/1991,Sunday, August 08, 2007,Saturday, March 09, 1997," & "February,0901234567,0953336650").Split(","c)

            autoCompleteStringCollection.AddRange(suggestionList)

            Dim cTypeAutoComplete As CellType.ICellType = New GcTextBoxCellType() With {
                 .AutoCompleteMode = AutoCompleteMode.SuggestAppend,
                 .AutoCompleteSource = AutoCompleteSource.CustomSource,
                 .AutoCompleteCustomSource = autoCompleteStringCollection
            }

            sViewTextBox.Columns(1).CellType = cTypeAutoComplete
            sViewTextBox.ColumnHeader.Cells(0, 1).Note = "AutoComplete Column"
            sViewTextBox.ColumnHeader.Cells(0, 1).NoteStyle = NoteStyle.StickyNote
        End Sub
        Private Sub InitComboBoxSheetView()
            sViewComboBox.DataSource = New DataService().AccessDataSource.GetNWINDData("Orders")

            sViewComboBox.DataAutoSizeColumns = False
            sViewComboBox.Columns.[Default].Width = 90
            sViewComboBox.Rows.[Default].Height = 25

            Dim dataSet As DataSet = New DataService().AccessDataSource.GetNWINDData("Order Details")

            Dim cTypeComboBox As ICellType = New GcComboBoxCellType() With {
                 .DataSource = dataSet,
                 .DataMember = dataSet.Tables(0).TableName
            }
            sViewComboBox.Columns(0).CellType = cTypeComboBox

        End Sub
        Private Sub InitDateTimeSheetView()
            Dim cTypeDateTime As New GcDateTimeCellType()
            cTypeDateTime.DropDown.ShowShadow = True
            cTypeDateTime.Fields.Clear()

            cTypeDateTime.Fields.AddRange(New DateFieldInfo() {New DateYearFieldInfo(), New DateLiteralFieldInfo() With {
                 .Text = "-"
            }, New DateMonthFieldInfo(), New DateLiteralFieldInfo() With {
                 .Text = "-"
            }, New DateDayFieldInfo(), New DateLiteralFieldInfo() With {
                 .Text = " "
            },
                New DateHourFieldInfo(), New DateLiteralFieldInfo() With {
                 .Text = ":"
            }, New DateMinuteFieldInfo(), New DateLiteralFieldInfo() With {
                 .Text = ":"
            }, New DateSecondFieldInfo()})
            sViewDateTime.Columns(3).CellType = cTypeDateTime

            Dim maskCell As New GcDateTimeCellType()
            maskCell.DropDown.ShowShadow = True
            maskCell.PromptChar = "#"c
            sViewDateTime.Columns(4).CellType = maskCell

            sViewDateTime.AutoGenerateColumns = False

            sViewDateTime.DataSource = New DataService().AccessDataSource.GetNWINDData("Orders")
            sViewDateTime.BindDataColumn(0, "OrderID")
            sViewDateTime.BindDataColumn(1, "CustomerID")
            sViewDateTime.BindDataColumn(2, "EmployeeID")
            sViewDateTime.BindDataColumn(3, "OrderDate")
            sViewDateTime.Columns.Add(4, 1)
            sViewDateTime.Columns(4).Label = "Required"

            sViewDateTime.DataAutoSizeColumns = False
            sViewDateTime.Columns.[Default].Width = 90
            sViewDateTime.Rows.[Default].Height = 25

            For column As Integer = 3 To 4
                sViewDateTime.Columns(column).Width = 150
            Next
        End Sub
        Private Sub InitNumberSheetView()
            sViewNumber.AutoGenerateColumns = False
            sViewNumber.DataAutoSizeColumns = False
            sViewNumber.Columns.[Default].Width = 110
            sViewNumber.Rows.[Default].Height = 25

            Dim gcNumberCell As New GcNumberCellType()
            gcNumberCell.DropDown.ShowShadow = True
            gcNumberCell.Fields.IntegerPart.MinDigits = 2

            Dim gcNullText As New GcNumberCellType()
            gcNullText.DropDown.ShowShadow = True
            gcNullText.Fields.SignSuffix.NegativePattern = ""
            gcNullText.AlternateText.Null.Text = "Null Value"
            gcNullText.AlternateText.Zero.Text = "Zero"
            gcNullText.Fields.IntegerPart.MinDigits = 2

            sViewNumber.DataSource = New DataService().AccessDataSource.GetNWINDData("Products")

            sViewNumber.BindDataColumn(0, "ProductID")
            sViewNumber.BindDataColumn(1, "ProductName")
            sViewNumber.BindDataColumn(2, "UnitsInStock")
            sViewNumber.BindDataColumn(3, "UnitsOnOrder")
            sViewNumber.BindDataColumn(4, "ReorderLevel")

            sViewNumber.Columns(2).CellType = gcNumberCell
            sViewNumber.Columns(3).CellType = gcNullText
        End Sub
        Private Sub InitMaskCellSheetView()
            sViewMask.DataAutoSizeColumns = False
            sViewMask.Columns.[Default].Width = 90
            sViewMask.Rows.[Default].Height = 25
            For column As Integer = 1 To 3
                sViewMask.Columns(column).Width = 150
            Next

            Dim maskPattern As New GcMaskCellType()
            maskPattern.Fields.AddRange("℡ \D{3}-\D{4}-\D{4}")
            maskPattern.RecommendedValue = "17155557788"
            maskPattern.ShowRecommendedValue = True

            sViewMask.AutoGenerateColumns = False
            sViewMask.DataSource = New DataService().AccessDataSource.GetNWINDData("Customers")
            sViewMask.BindDataColumn(0, "CustomerID")
            sViewMask.BindDataColumn(1, "ContactName")
            sViewMask.BindDataColumn(2, "ContactTitle")
            sViewMask.BindDataColumn(3, "Address")
            sViewMask.BindDataColumn(4, "City")
            sViewMask.Columns(5).Label = "Phone"

            sViewMask.Columns(5).CellType = maskPattern
            sViewMask.Columns(5).Width = 110
        End Sub
        Private Sub InitCharMaskCellSheetView()
            sViewCharMask.DataAutoSizeColumns = False
            sViewCharMask.Columns.[Default].Width = 90
            sViewCharMask.Rows.[Default].Height = 25

            Dim gcCharMaskCell As New GcCharMaskCellType()

            Dim inputBoxMaskCell As New InputBoxInfo() With {
                 .AutoSize = False,
                 .Size = New Size(17, 20)
            }
            inputBoxMaskCell.Border.SetAllLines(Color.Black, LineStyle.[Single])

            Dim charBoxMaskCell = gcCharMaskCell.CharBoxes
            charBoxMaskCell.Clear()
            charBoxMaskCell.Add(inputBoxMaskCell, 5)

            sViewCharMask.DataSource = New DataService().AccessDataSource.GetNWINDData("Customers")
            sViewCharMask.Columns(0).CellType = gcCharMaskCell
            sViewCharMask.Columns(0).Font = New Font(FontFamily.GenericSansSerif, 8, FontStyle.Italic)
        End Sub
        Private Sub InitTimeSpanCellSheetView()
            sViewTimeSpan.AutoGenerateColumns = False
            sViewTimeSpan.DataAutoSizeColumns = False
            sViewTimeSpan.Columns.[Default].Width = 90
            sViewTimeSpan.Rows.[Default].Height = 25

            Dim gcTimeSpanCell As New GcTimeSpanCellType() With {
                 .ShowRecommendedValue = True
            }
            gcTimeSpanCell.Fields.Clear()
            gcTimeSpanCell.Fields.AddRange(New TimeSpanFieldInfo() {New TimeSpanSignFieldInfo("", "-"), New TimeSpanDayFieldInfo(2), New TimeSpanLiteralFieldInfo(":"), New TimeSpanHourFieldInfo(2), New TimeSpanLiteralFieldInfo(":"), New TimeSpanMinuteFieldInfo(2),
                New TimeSpanLiteralFieldInfo(":"), New TimeSpanSecondFieldInfo(2)})

            gcTimeSpanCell.DisplayFields.AddRange(New TimeSpanDisplayFieldInfo() {New TimeSpanSignDisplayFieldInfo("", "-"), New TimeSpanDayDisplayFieldInfo(2), New TimeSpanLiteralDisplayFieldInfo(":"), New TimeSpanHourDisplayFieldInfo(2), New TimeSpanLiteralDisplayFieldInfo(":"), New TimeSpanMinuteDisplayFieldInfo(2),
                New TimeSpanLiteralDisplayFieldInfo(":"), New TimeSpanSecondDisplayFieldInfo(2)})
            sViewTimeSpan.DataSource = New DataService().AccessDataSource.GetNWINDData("Orders")

            sViewTimeSpan.BindDataColumn(0, "OrderID")
            sViewTimeSpan.BindDataColumn(1, "ShipVia")
            sViewTimeSpan.BindDataColumn(2, "ShipCountry")
            sViewTimeSpan.BindDataColumn(3, "OrderDate")
            sViewTimeSpan.BindDataColumn(4, "RequiredDate")
            sViewTimeSpan.ColumnCount += 1
            sViewTimeSpan.Columns(5).Label = "Buffer"
            sViewTimeSpan.Columns(5).CellType = gcTimeSpanCell
            For r As Integer = 0 To sViewTimeSpan.RowCount - 1
                sViewTimeSpan.Cells(r, 5).Value = CType(sViewTimeSpan.Cells(r, 4).Value, DateTime) - CType(sViewTimeSpan.Cells(r, 3).Value, DateTime)
            Next
        End Sub
        Private Function GetMappedData(selectColumn As String, orderColumn As String, tableName As String) As String()
            Dim data = New DataService().AccessDataSource.GetNWINDDataComplete(String.Format("SELECT DISTINCT {0},{2} FROM `{1}` ORDER BY {2} ASC", selectColumn, tableName, orderColumn))
            Dim dataItem As String = ""
            For Each item As DataRow In data.Tables(0).Rows
                dataItem += Convert.ToString(item(0)) & "|"
            Next
            Return dataItem.TrimEnd("|"c).Split("|"c)
        End Function
    End Class
End Namespace

'
'
'

Namespace Features
	Partial Class GCInputManDemo
		''' <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 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.spread = New FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None)
			Me.sViewCharMask = New FarPoint.Win.Spread.SheetView()
			Me.sViewComboBox = New FarPoint.Win.Spread.SheetView()
			Me.sViewDateTime = New FarPoint.Win.Spread.SheetView()
			Me.sViewMask = New FarPoint.Win.Spread.SheetView()
			Me.sViewNumber = New FarPoint.Win.Spread.SheetView()
			Me.sViewTextBox = New FarPoint.Win.Spread.SheetView()
			Me.sViewTimeSpan = New FarPoint.Win.Spread.SheetView()
			Me.pnlMain.SuspendLayout()
			DirectCast(Me.spread, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.sViewCharMask, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.sViewComboBox, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.sViewDateTime, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.sViewMask, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.sViewNumber, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.sViewTextBox, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.sViewTimeSpan, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.SuspendLayout()
			' 
			' pnlMain
			' 
			Me.pnlMain.Controls.Add(Me.spread)
			' 
			' spread
			' 
			Me.spread.AccessibleDescription = "spread, FieldsEditorControl, Row 0, Column 0"
			Me.spread.Dock = System.Windows.Forms.DockStyle.Fill
			Me.spread.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded
			Me.spread.Location = New System.Drawing.Point(0, 0)
			Me.spread.Name = "spread"
			Me.spread.Sheets.AddRange(New FarPoint.Win.Spread.SheetView() {Me.sViewCharMask, Me.sViewComboBox, Me.sViewDateTime, Me.sViewMask, Me.sViewNumber, Me.sViewTextBox, _
				Me.sViewTimeSpan})
			Me.spread.Size = New System.Drawing.Size(477, 487)
			Me.spread.TabIndex = 0
			Me.spread.ActiveSheetIndex = 3
			' 
			' gcCharMask
			' 
			Me.sViewCharMask.Reset()
			Me.sViewCharMask.SheetName = "GCCharMask"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.sViewCharMask.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.sViewCharMask.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' gcComboBox
			' 
			Me.sViewComboBox.Reset()
			Me.sViewComboBox.SheetName = "GCComboBox"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.sViewComboBox.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.sViewComboBox.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' gcDateTime
			' 
			Me.sViewDateTime.Reset()
			Me.sViewDateTime.SheetName = "GCDateTime"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.sViewDateTime.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.sViewDateTime.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' gcMask
			' 
			Me.sViewMask.Reset()
			Me.sViewMask.SheetName = "GCMask"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.sViewMask.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.sViewMask.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' gcNumber
			' 
			Me.sViewNumber.Reset()
			Me.sViewNumber.SheetName = "GCNumber"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.sViewNumber.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.sViewNumber.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' gcTextBox
			' 
			Me.sViewTextBox.Reset()
			Me.sViewTextBox.SheetName = "GCTextBox"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.sViewTextBox.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.sViewTextBox.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' gcTimeSpan
			' 
			Me.sViewTimeSpan.Reset()
			Me.sViewTimeSpan.SheetName = "GCTimeSpan"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.sViewTimeSpan.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.sViewTimeSpan.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' GCInputManCellType
			' 
			Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
			Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
			Me.Name = "GCInputManCellType"
			Me.pnlMain.ResumeLayout(False)
			DirectCast(Me.spread, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.sViewCharMask, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.sViewComboBox, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.sViewDateTime, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.sViewMask, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.sViewNumber, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.sViewTextBox, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.sViewTimeSpan, System.ComponentModel.ISupportInitialize).EndInit()
			Me.ResumeLayout(False)

		End Sub

		#End Region

		Private spread As FarPoint.Win.Spread.FpSpread
		Private sViewCharMask As FarPoint.Win.Spread.SheetView
		Private sViewComboBox As FarPoint.Win.Spread.SheetView
		Private sViewDateTime As FarPoint.Win.Spread.SheetView
		Private sViewMask As FarPoint.Win.Spread.SheetView
		Private sViewNumber As FarPoint.Win.Spread.SheetView
		Private sViewTextBox As FarPoint.Win.Spread.SheetView
		Private sViewTimeSpan As FarPoint.Win.Spread.SheetView
	End Class
End Namespace
