﻿Imports System.IO
Imports System.Windows.Forms
Imports GrapeCity.Spreadsheet
Imports GrapeCity.Spreadsheet.Drawing
Imports Spread.Common.Features.Spread.Common.Features.Sample

Partial Public Class CarInsuranceClaim
     Inherits BaseSampleControl

     Public Sub New()
          InitializeComponent()
          fpSpread1.Features.EnhancedShapeEngine = True
          fpSpread1.Features.RichClipboard = True
          Using s As New MemoryStream(ExcelTemplate.car_repair_excel)
               fpSpread1.OpenExcel(s, FarPoint.Excel.ExcelOpenFlags.DocumentCaching)
          End Using
          fpSpread1.ActiveSheet.RowCount = 43
          Dim workbook As IWorkbook = fpSpread1.AsWorkbook()
          For n As Integer = 0 To workbook.ActiveSheet.Shapes.Count - 1
               Dim shape As IShape = workbook.ActiveSheet.Shapes(n)
               shape.CanMove = Moving.None
               shape.CanRotate = False
               shape.CanSize = Sizing.None
               If shape.Name = "Picture 2" Then
                    Continue For
               End If
               AddHandler shape.Action, AddressOf Shape_Action
          Next
          BindProperties()
     End Sub

     Private Sub BindProperties()
          Dim workbook As IWorkbook = fpSpread1.AsWorkbook()
          Dim shapes As IShapes = workbook.Worksheets(0).Shapes
          shapes("Front").Bindings.Add("Left", "Sheet2!B2")
          shapes("Front").Bindings.Add("Top", "Sheet2!C2")
          shapes("Front").Bindings.Add("Width", "Sheet2!D2")
          shapes("Front").Bindings.Add("Height", "Sheet2!E2")
          shapes("Front").Bindings.Add("Line", "Sheet2!F2")
          shapes("Hood").Bindings.Add("Left", "Sheet2!B3")
          shapes("Hood").Bindings.Add("Top", "Sheet2!C3")
          shapes("Hood").Bindings.Add("Width", "Sheet2!D3")
          shapes("Hood").Bindings.Add("Height", "Sheet2!E3")
          shapes("Hood").Bindings.Add("Line", "Sheet2!F3")
          shapes("FrontWindshield").Bindings.Add("Left", "Sheet2!B4")
          shapes("FrontWindshield").Bindings.Add("Top", "Sheet2!C4")
          shapes("FrontWindshield").Bindings.Add("Width", "Sheet2!D4")
          shapes("FrontWindshield").Bindings.Add("Height", "Sheet2!E4")
          shapes("FrontWindshield").Bindings.Add("Line", "Sheet2!F4")
          shapes("Roof").Bindings.Add("Left", "Sheet2!B5")
          shapes("Roof").Bindings.Add("Top", "Sheet2!C5")
          shapes("Roof").Bindings.Add("Width", "Sheet2!D5")
          shapes("Roof").Bindings.Add("Height", "Sheet2!E5")
          shapes("Roof").Bindings.Add("Line", "Sheet2!F5")
          shapes("RearTop").Bindings.Add("Left", "Sheet2!B6")
          shapes("RearTop").Bindings.Add("Top", "Sheet2!C6")
          shapes("RearTop").Bindings.Add("Width", "Sheet2!D6")
          shapes("RearTop").Bindings.Add("Height", "Sheet2!E6")
          shapes("RearTop").Bindings.Add("Line", "Sheet2!F6")
          shapes("Rear").Bindings.Add("Left", "Sheet2!B7")
          shapes("Rear").Bindings.Add("Top", "Sheet2!C7")
          shapes("Rear").Bindings.Add("Width", "Sheet2!D7")
          shapes("Rear").Bindings.Add("Height", "Sheet2!E7")
          shapes("Rear").Bindings.Add("Line", "Sheet2!F7")
          shapes("LeftFront").Bindings.Add("Left", "Sheet2!B8")
          shapes("LeftFront").Bindings.Add("Top", "Sheet2!C8")
          shapes("LeftFront").Bindings.Add("Width", "Sheet2!D8")
          shapes("LeftFront").Bindings.Add("Height", "Sheet2!E8")
          shapes("LeftFront").Bindings.Add("Line", "Sheet2!F8")
          shapes("LeftFrontDoor").Bindings.Add("Left", "Sheet2!B9")
          shapes("LeftFrontDoor").Bindings.Add("Top", "Sheet2!C9")
          shapes("LeftFrontDoor").Bindings.Add("Width", "Sheet2!D9")
          shapes("LeftFrontDoor").Bindings.Add("Height", "Sheet2!E9")
          shapes("LeftFrontDoor").Bindings.Add("Line", "Sheet2!F9")
          shapes("LeftBackDoor").Bindings.Add("Left", "Sheet2!B10")
          shapes("LeftBackDoor").Bindings.Add("Top", "Sheet2!C10")
          shapes("LeftBackDoor").Bindings.Add("Width", "Sheet2!D10")
          shapes("LeftBackDoor").Bindings.Add("Height", "Sheet2!E10")
          shapes("LeftBackDoor").Bindings.Add("Line", "Sheet2!F10")
          shapes("LeftBack").Bindings.Add("Left", "Sheet2!B11")
          shapes("LeftBack").Bindings.Add("Top", "Sheet2!C11")
          shapes("LeftBack").Bindings.Add("Width", "Sheet2!D11")
          shapes("LeftBack").Bindings.Add("Height", "Sheet2!E11")
          shapes("LeftBack").Bindings.Add("Line", "Sheet2!F11")
          shapes("RightFront").Bindings.Add("Left", "Sheet2!B12")
          shapes("RightFront").Bindings.Add("Top", "Sheet2!C12")
          shapes("RightFront").Bindings.Add("Width", "Sheet2!D12")
          shapes("RightFront").Bindings.Add("Height", "Sheet2!E12")
          shapes("RightFront").Bindings.Add("Line", "Sheet2!F12")
          shapes("RightFrontDoor").Bindings.Add("Left", "Sheet2!B13")
          shapes("RightFrontDoor").Bindings.Add("Top", "Sheet2!C13")
          shapes("RightFrontDoor").Bindings.Add("Width", "Sheet2!D13")
          shapes("RightFrontDoor").Bindings.Add("Height", "Sheet2!E13")
          shapes("RightFrontDoor").Bindings.Add("Line", "Sheet2!F13")
          shapes("RightBackDoor").Bindings.Add("Left", "Sheet2!B14")
          shapes("RightBackDoor").Bindings.Add("Top", "Sheet2!C14")
          shapes("RightBackDoor").Bindings.Add("Width", "Sheet2!D14")
          shapes("RightBackDoor").Bindings.Add("Height", "Sheet2!E14")
          shapes("RightBackDoor").Bindings.Add("Line", "Sheet2!F14")
          shapes("RightBack").Bindings.Add("Left", "Sheet2!B15")
          shapes("RightBack").Bindings.Add("Top", "Sheet2!C15")
          shapes("RightBack").Bindings.Add("Width", "Sheet2!D15")
          shapes("RightBack").Bindings.Add("Height", "Sheet2!E15")
          shapes("RightBack").Bindings.Add("Line", "Sheet2!F15")
     End Sub
     Private Sub Shape_Action(sender As Object, e As ShapeEventArgs)
          Dim workbook As IWorkbook = fpSpread1.AsWorkbook()
          Dim worksheet As IWorksheet = workbook.ActiveSheet
          Dim shapes As IShapes = worksheet.Shapes
          If e.Shape IsNot Nothing Then
               Dim name As String = e.Shape.Name
               If e.Shape.Fill.Transparency = 0.99 Then
                    e.Shape.Fill.Transparency = 0.5
                    If name = "Front" OrElse name = "Rear" Then
                         shapes("BumperDamage").Fill.Transparency = 0.5
                    End If
                    If name = "Roof" Then
                         shapes("RoofDamage").Fill.Transparency = 0.5
                    End If
                    If name = "RoofDamage" Then
                         shapes("Roof").Fill.Transparency = 0.5
                    End If
                    If name = "HighSeverity" OrElse name = "MediumSeverity" OrElse name = "LowSeverity" Then
                         shapes("HighSeverity").Fill.Transparency = 0.99
                         shapes("MediumSeverity").Fill.Transparency = 0.99
                         shapes("LowSeverity").Fill.Transparency = 0.99
                         shapes(name).Fill.Transparency = 0.5
                    End If
               Else
                    e.Shape.Fill.Transparency = 0.99
                    If name = "Front" AndAlso shapes("Rear").Fill.Transparency = 0.99 Then
                         shapes("BumperDamage").Fill.Transparency = 0.99
                    End If
                    If name = "Rear" AndAlso shapes("Front").Fill.Transparency = 0.99 Then
                         shapes("BumperDamage").Fill.Transparency = 0.99
                    End If
                    If name = "Roof" Then
                         shapes("RoofDamage").Fill.Transparency = 0.99
                    End If
                    If name = "RoofDamage" Then
                         shapes("Roof").Fill.Transparency = 0.99
                    End If
               End If
          End If
     End Sub

     Private Sub SaveToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles saveToolStripMenuItem.Click
          Dim d As New SaveFileDialog With {
               .Filter = "Excel Macro-enabled Workbook (*.XLSM)|*.XLSM",
               .FilterIndex = 0,
               .Title = "Save File"
          }
          If d.ShowDialog() = DialogResult.OK Then
               fpSpread1.SaveExcel(d.FileName, FarPoint.Excel.ExcelSaveFlags.DocumentCaching Or FarPoint.Excel.ExcelSaveFlags.UseOOXMLFormat)
          End If
     End Sub

     Private Sub ExitToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles exitToolStripMenuItem.Click
          Dim form As Form = DirectCast(Me.TopLevelControl, System.Windows.Forms.Form)
          form.Close()
     End Sub
End Class

'
'CarInsuranceClaim.Designer.vb
'

<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()>
Partial Class CarInsuranceClaim
     ''' <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 "Windows Form 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()
          Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(CarInsuranceClaim))
          Me.menuStrip1 = New System.Windows.Forms.MenuStrip()
          Me.fileToolStripMenuItem = New System.Windows.Forms.ToolStripMenuItem()
          Me.saveToolStripMenuItem = New System.Windows.Forms.ToolStripMenuItem()
          Me.toolStripMenuItem1 = New System.Windows.Forms.ToolStripSeparator()
          Me.exitToolStripMenuItem = New System.Windows.Forms.ToolStripMenuItem()
          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.pnlMain.SuspendLayout()
          Me.menuStrip1.SuspendLayout()
          CType(Me.fpSpread1, System.ComponentModel.ISupportInitialize).BeginInit()
          Me.SuspendLayout()
          '
          'pnlMain
          '
          Me.pnlMain.Controls.Add(Me.fpSpread1)
          Me.pnlMain.Controls.Add(Me.menuStrip1)
          '
          'menuStrip1
          '
          Me.menuStrip1.Items.AddRange(New System.Windows.Forms.ToolStripItem() {Me.fileToolStripMenuItem})
          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 = 0
          Me.menuStrip1.Text = "menuStrip1"
          '
          'fileToolStripMenuItem
          '
          Me.fileToolStripMenuItem.DropDownItems.AddRange(New System.Windows.Forms.ToolStripItem() {Me.saveToolStripMenuItem, Me.toolStripMenuItem1, Me.exitToolStripMenuItem})
          Me.fileToolStripMenuItem.Name = "fileToolStripMenuItem"
          Me.fileToolStripMenuItem.Size = New System.Drawing.Size(37, 20)
          Me.fileToolStripMenuItem.Text = "&File"
          '
          'saveToolStripMenuItem
          '
          Me.saveToolStripMenuItem.Name = "saveToolStripMenuItem"
          Me.saveToolStripMenuItem.Size = New System.Drawing.Size(107, 22)
          Me.saveToolStripMenuItem.Text = "&Save..."
          '
          'toolStripMenuItem1
          '
          Me.toolStripMenuItem1.Name = "toolStripMenuItem1"
          Me.toolStripMenuItem1.Size = New System.Drawing.Size(104, 6)
          '
          'exitToolStripMenuItem
          '
          Me.exitToolStripMenuItem.Name = "exitToolStripMenuItem"
          Me.exitToolStripMenuItem.Size = New System.Drawing.Size(107, 22)
          Me.exitToolStripMenuItem.Text = "E&xit"
          '
          '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 = 1
          '
          'CarInsuranceClaim
          '
          Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
          Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
          Me.Name = "CarInsuranceClaim"
          Me.pnlMain.ResumeLayout(False)
          Me.pnlMain.PerformLayout()
          Me.menuStrip1.ResumeLayout(False)
          Me.menuStrip1.PerformLayout()
          CType(Me.fpSpread1, System.ComponentModel.ISupportInitialize).EndInit()
          Me.ResumeLayout(False)

     End Sub

#End Region

     Private menuStrip1 As System.Windows.Forms.MenuStrip
     Private fileToolStripMenuItem As System.Windows.Forms.ToolStripMenuItem
     Private WithEvents saveToolStripMenuItem As System.Windows.Forms.ToolStripMenuItem
     Private toolStripMenuItem1 As System.Windows.Forms.ToolStripSeparator
     Private WithEvents exitToolStripMenuItem As System.Windows.Forms.ToolStripMenuItem
     Private WithEvents fpSpread1 As FarPoint.Win.Spread.FpSpread
     Private WithEvents fpSpread1_Sheet1 As FarPoint.Win.Spread.SheetView
End Class
