Imports System.Drawing
Imports FarPoint.Win.Spread
Imports GrapeCity.Spreadsheet
Imports Spread.Common.Features.Spread.Common.Features.Sample
Namespace Features
    Public Class HistogramSparkline
        Inherits BaseSampleControl
        Private _rand As Random

        Public Sub New()
            InitializeComponent()
            Name = "Histogram"
            _rand = New Random()
            InitSpreadSheet(_fpSpread.ActiveSheet)
        End Sub

#Region "Private Methods"
        Private Sub InitSpreadSheet(ByVal sheetView As SheetView)
            Dim worksheet As IWorksheet = sheetView.AsWorksheet()
            worksheet.Cells("A1:G1").Merge()
            InitData(worksheet)
            worksheet.Cells("A1").Value = "Customer Wait Time (in seconds)"
            worksheet.Cells("A1").Font.ApplyFont(New GrapeCity.Spreadsheet.Font() With {
                .Name = "Arial",
                .Size = 17
            })

            worksheet.Cells("A1").VerticalAlignment = VerticalAlignment.Center
            worksheet.Rows("1").RowHeight = 30
            worksheet.Rows("2").RowHeight = 25
            worksheet.Rows("4").RowHeight = 250
            worksheet.Columns("B:G").ColumnWidth = 20
            Dim branch As Integer = 1

            For i As Integer = 0 To 7 - 1
                Dim column As Char = Convert.ToChar(65 + i)
                worksheet.Cells($"{column}2").Value = $"Branch {branch}"
                worksheet.Cells($"{column}2").HorizontalAlignment = HorizontalAlignment.Center
                worksheet.Cells($"{column}2").VerticalAlignment = VerticalAlignment.Center
                worksheet.Cells($"{column}2").Font.ApplyFont(New GrapeCity.Spreadsheet.Font() With {
                    .Name = "Arial",
                    .Size = 11,
                    .Bold = True
                })

                sheetView.Cells($"{column}2").ForeColor = System.Drawing.Color.White
                sheetView.Cells($"{column}2").BackColor = ColorTranslator.FromHtml("#82bc00")

                If i < 6 Then
                    worksheet.Cells($"{ChrW((65 + i + 1))}2").HorizontalAlignment = HorizontalAlignment.Center
                    worksheet.Cells($"{ChrW((65 + i + 1))}2").VerticalAlignment = VerticalAlignment.Center
                    worksheet.Cells($"{ChrW((65 + i + 1))}2").Font.ApplyFont(New GrapeCity.Spreadsheet.Font() With {
                    .Name = "Arial",
                    .Size = 11,
                    .Bold = True
                })
                    sheetView.Cells($"{ChrW((65 + i + 1))}2").ForeColor = System.Drawing.Color.White
                    sheetView.Cells($"{ChrW((65 + i + 1))}2").BackColor = ColorTranslator.FromHtml("#82bc00")
                End If

                worksheet.Columns($"{column}").ColumnWidth = 300
                worksheet.Cells($"{column}4").Formula2 = $"HISTOGRAMSPARKLINE({column}6:{column}50,TRUE,TRUE,10,1,""#DDDDDD"",""normal normal 8pt Calibri"", ""#000000"", ""#C0C0C0"")"
                i += 1
                branch += 1
            Next
        End Sub

        Private Sub InitData(ByVal sheet As IWorksheet)
            For row As Integer = 6 To 50

                For col As Integer = 65 To 72 - 1
                    Dim columnChar As Char = Convert.ToChar(col)
                    sheet.Cells($"{columnChar}{row}").Value = _rand.[Next](50, 100)
                    col += 1
                Next
            Next
        End Sub
#End Region
    End Class
End Namespace


'
'HistogramSparkline.Designer.vb
'


Namespace Features

    Partial Class HistogramSparkline

        'UserControl overrides dispose to clean up the component list.
        <System.Diagnostics.DebuggerNonUserCode()>
        Protected Overloads 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(HistogramSparkline))
            Me._fpSpread = New FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, CType(resources.GetObject("pnlMain.Controls"), Object))
            Me._fpSpread_Sheet1 = Me._fpSpread.GetSheet(0)
            Me.pnlMain.SuspendLayout()
            CType(Me._fpSpread, System.ComponentModel.ISupportInitialize).BeginInit()
            Me.SuspendLayout()
            '
            'pnlMain
            '
            Me.pnlMain.Controls.Add(Me._fpSpread)
            '
            '_fpSpread
            '
            Me._fpSpread.Dock = System.Windows.Forms.DockStyle.Fill
            Me._fpSpread.Font = New System.Drawing.Font("Calibri", 11.0!)
            Me._fpSpread.Location = New System.Drawing.Point(0, 0)
            Me._fpSpread.Name = "_fpSpread"
            Me._fpSpread.Size = New System.Drawing.Size(477, 487)
            Me._fpSpread.TabIndex = 0
            '
            'HistogramSparkline
            '
            Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
            Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
            Me.Name = "HistogramSparkline"
            Me.pnlMain.ResumeLayout(False)
            CType(Me._fpSpread, System.ComponentModel.ISupportInitialize).EndInit()
            Me.ResumeLayout(False)

        End Sub

        Friend WithEvents _fpSpread As FarPoint.Win.Spread.FpSpread
        Friend WithEvents _fpSpread_Sheet1 As FarPoint.Win.Spread.SheetView
    End Class
End Namespace
