﻿<?xml version="1.0" encoding="utf-16"?>
<JiwaDocument xmlns:jiwa="http://www.jiwa.com.au/xml/schemas" Type="JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin">
  <RecID>feb297a6-761f-43ef-b490-d2b86f5cb08d</RecID>
  <Name>Inventory Import Notes - Update existing VB.NET</Name>
  <Description>Extends the inventory CSV import to include Notes.&amp;#13;&amp;#10;&amp;#13;&amp;#10;Modified from the standard plugin to update notes if an existing note with the same note type is found, otherwise then it is added as a new note.</Description>
  <IsEnabled>true</IsEnabled>
  <IsIsolatedToOwnAppDomain>false</IsIsolatedToOwnAppDomain>
  <ExecutionOrder>0</ExecutionOrder>
  <Author>Jiwa Financials</Author>
  <Version />
  <Code>
Imports Microsoft.VisualBasic
Imports System
Imports System.Collections
Imports System.Collections.Generic
Imports System.Data
Imports System.Diagnostics
Imports JiwaFinancials.Jiwa
Imports System.Windows.Forms
Imports System.Data.SqlClient
Imports System.Drawing
Imports System.Linq

Public Class FormPlugin
    Inherits System.MarshalByRefObject
    Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaFormPlugin

    Public Overrides Function InitializeLifetimeService() As Object
        Return Nothing
    End Function

    Public Sub SetupBeforeHandlers(ByVal JiwaForm As JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm, ByVal Plugin As JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaFormPlugin.SetupBeforeHandlers
    End Sub

    Public Sub Setup(ByVal JiwaForm As JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm, ByVal Plugin As JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaFormPlugin.Setup
    End Sub
End Class

Public Class BusinessLogicPlugin
    Inherits System.MarshalByRefObject
    Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogicPlugin

    Public Overrides Function InitializeLifetimeService() As Object
        Return Nothing
    End Function

    Public Sub Setup(ByVal JiwaBusinessLogic As JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic, ByVal Plugin As JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogicPlugin.Setup
        If TypeOf JiwaBusinessLogic Is JiwaFinancials.Jiwa.JiwaInventory.Import.InventoryImport Then
            Dim inventoryImport As JiwaFinancials.Jiwa.JiwaInventory.Import.InventoryImport = CType(JiwaBusinessLogic, JiwaFinancials.Jiwa.JiwaInventory.Import.InventoryImport)
            AppendProperties(inventoryImport.DestinationProperties)
            AddHandler inventoryImport.DestinationProperties.ReadEnd, AddressOf DestinationProperties_ReadEnd
        End If
    End Sub

    Private Sub DestinationProperties_ReadEnd(ByVal sender As Object, ByVal e As System.EventArgs)
        Dim destinationPropertyCollection As JiwaFinancials.Jiwa.JiwaInventory.Import.DestinationPropertyCollection = CType(sender, JiwaFinancials.Jiwa.JiwaInventory.Import.DestinationPropertyCollection)
        AppendProperties(destinationPropertyCollection)
    End Sub

    Private Sub AppendProperties(ByVal destinationPropertyCollection As JiwaFinancials.Jiwa.JiwaInventory.Import.DestinationPropertyCollection)
        destinationPropertyCollection.Add(New JiwaFinancials.Jiwa.JiwaInventory.Import.DestinationProperty("Inventory.Note.NoteType", "Inventory Note Type", Function(ByVal inventory As JiwaFinancials.Jiwa.JiwaInventory.Inventory, ByVal value As String, ByVal rowData As String, ByVal row As String(), ByVal rowNo As Integer, ByVal mapping As JiwaFinancials.Jiwa.JiwaInventory.Import.Mapping)
            SetNoteInfo(inventory, value, rowData, row, rowNo, mapping)
        End Function, New String() {"InventoryNoteType", "Inventory Note Type", "NoteType", "Note Type"}))
        destinationPropertyCollection.Add(New JiwaFinancials.Jiwa.JiwaInventory.Import.DestinationProperty("Inventory.Note.NoteText", "Inventory Note Text", Function(ByVal inventory As JiwaFinancials.Jiwa.JiwaInventory.Inventory, ByVal value As String, ByVal rowData As String, ByVal row As String(), ByVal rowNo As Integer, ByVal mapping As JiwaFinancials.Jiwa.JiwaInventory.Import.Mapping)
            SetNoteInfo(inventory, value, rowData, row, rowNo, mapping)
        End Function, New String() {"InventoryNoteText", "Inventory Note Text", "NoteText", "Note Text", "Note"}))
    End Sub

    Private Sub SetNoteInfo(ByRef Inventory As JiwaFinancials.Jiwa.JiwaInventory.Inventory, ByVal Value As String, ByVal RowData As String, ByVal Row As String(), ByVal RowNo As Integer, ByVal Mapping As JiwaFinancials.Jiwa.JiwaInventory.Import.Mapping)
        Dim noteTypeDescription As String = ""
        Dim noteText As String = ""
        Dim myLoop As Integer = 1
        For Each cell As String In Row
            Select Case Mapping.MappingCollection(myLoop).DestinationProperty.RecID
                Case "Inventory.Note.NoteType"
                    noteTypeDescription = cell.Trim()
                    Mapping.MappingCollection(myLoop).HasBeenSet = True
                Case "Inventory.Note.NoteText"
                    noteText = cell.Trim()
                    Mapping.MappingCollection(myLoop).HasBeenSet = True
            End Select

            myLoop += 1
        Next

        Dim noteType As JiwaFinancials.Jiwa.JiwaApplication.Notes.NoteType = Nothing
        If noteTypeDescription.Trim().Length &gt; 0 Then
            Dim found As Boolean = False
            For Each existingNoteType As JiwaFinancials.Jiwa.JiwaApplication.Notes.NoteType In Inventory.Notes.NoteTypeCollection
                If existingNoteType.Description.ToUpper() = noteTypeDescription.ToUpper() Then
                    noteType = existingNoteType
                    found = True
                    Exit For
                End If
            Next

            If found = False Then
                Throw New Exception(String.Format("Note Type '{0}' not found", noteTypeDescription))
            End If
        End If

        Dim existingNote As JiwaFinancials.Jiwa.JiwaApplication.Notes.Note = Inventory.Notes.Cast(Of JiwaFinancials.Jiwa.JiwaApplication.Notes.Note)().FirstOrDefault(Function(x) noteType IsNot Nothing AndAlso x.NoteType.RecID = noteType.RecID)
        If existingNote Is Nothing Then
            Dim note As JiwaFinancials.Jiwa.JiwaApplication.Notes.Note = New JiwaFinancials.Jiwa.JiwaApplication.Notes.Note()
            If noteType IsNot Nothing Then
                note.NoteType = noteType
            End If

            note.NoteText = noteText
            Inventory.Notes.Add(note)
        Else
            existingNote.NoteText = noteText
        End If
    End Sub
End Class

Public Class ApplicationManagerPlugin
    Inherits System.MarshalByRefObject
    Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaApplicationManagerPlugin

    Public Overrides Function InitializeLifetimeService() As Object
        Return Nothing
    End Function

    Public Sub Setup(ByVal Plugin As JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaApplicationManagerPlugin.Setup
    End Sub
End Class

Public Class CustomFieldPlugin
    Inherits System.MarshalByRefObject
    Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldPlugin

    Public Overrides Function InitializeLifetimeService() As Object
        Return Nothing
    End Function

    Public Sub FormatCell(ByVal BusinessLogicHost As JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal HostObject As JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues, ByVal CustomField As JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldPlugin.FormatCell
    End Sub

    Public Sub ReadData(ByVal BusinessLogicHost As JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm, ByVal Row As Integer, ByVal HostObject As JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues, ByVal CustomField As JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldPlugin.ReadData
    End Sub

    Public Sub ButtonClicked(ByVal BusinessLogicHost As JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal HostObject As JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues, ByVal CustomField As JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldPlugin.ButtonClicked
    End Sub
End Class

Public Class LineCustomFieldPlugin
    Inherits System.MarshalByRefObject
    Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldPlugin

    Public Overrides Function InitializeLifetimeService() As Object
        Return Nothing
    End Function

    Public Sub FormatCell(ByVal BusinessLogicHost As JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal HostItem As JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues, ByVal CustomField As JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldPlugin.FormatCell
    End Sub

    Public Sub ReadData(ByVal BusinessLogicHost As JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm, ByVal Row As Integer, ByVal HostItem As JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues, ByVal CustomField As JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldPlugin.ReadData
    End Sub

    Public Sub ButtonClicked(ByVal BusinessLogicHost As JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal HostItem As JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues, ByVal CustomField As JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField, ByVal CustomFieldValue As JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldPlugin.ButtonClicked
    End Sub
End Class

Public Class SystemSettingPlugin
    Inherits System.MarshalByRefObject
    Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaSystemSettingPlugin

    Public Overrides Function InitializeLifetimeService() As Object
        Return Nothing
    End Function

    Public Sub FormatCell(ByVal BusinessLogicHost As JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal SystemSetting As JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaSystemSettingPlugin.FormatCell
    End Sub

    Public Sub ReadData(ByVal BusinessLogicHost As JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm, ByVal Row As Integer, ByVal SystemSetting As JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaSystemSettingPlugin.ReadData
    End Sub

    Public Sub ButtonClicked(ByVal BusinessLogicHost As JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic, ByVal GridObject As JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid, ByVal FormObject As JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm, ByVal Col As Integer, ByVal Row As Integer, ByVal SystemSetting As JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaSystemSettingPlugin.ButtonClicked
    End Sub
End Class

Public Class ScheduledExecutionPlugin
    Inherits System.MarshalByRefObject
    Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaScheduledExecutionPlugin

    Public Sub Execute(ByVal Plugin As JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin, ByVal Schedule As JiwaFinancials.Jiwa.JiwaApplication.Schedule.Schedule) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaScheduledExecutionPlugin.Execute
    End Sub

    Public Sub OnServiceStart(ByVal Plugin As JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaScheduledExecutionPlugin.OnServiceStart
    End Sub

    Public Sub OnServiceStopping(ByVal Plugin As JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin) Implements JiwaFinancials.Jiwa.JiwaApplication.IJiwaScheduledExecutionPlugin.OnServiceStopping
    End Sub
End Class

'=======================================================
'Service provided by Telerik (www.telerik.com)
'Conversion powered by Refactoring Essentials.
'Twitter: @telerik
'Facebook: facebook.com/telerik
'=======================================================
</Code>
  <ExceptionPolicy>Report</ExceptionPolicy>
  <Language>VisualBasic</Language>
  <BusinessLogicCollection>
    <BusinessLogic>
      <RecID>ccbce909-7295-4343-a968-bdd74715d649</RecID>
      <Description>Inventory Import</Description>
      <ClassName>JiwaFinancials.Jiwa.JiwaInventory.Import.InventoryImport</ClassName>
      <Assembly>JiwaInventory, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c</Assembly>
    </BusinessLogic>
  </BusinessLogicCollection>
  <ReferenceCollection>
    <Reference>
      <RecID>665ce708-05ce-46d8-ad98-73eeb1fc65ff</RecID>
      <AssemblyFullName>JiwaApplication, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c</AssemblyFullName>
      <AssemblyName>JiwaApplication.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\JiwaApplication.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>bd5f9f28-a4e8-46fc-b980-05354d47c25b</RecID>
      <AssemblyFullName>mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</AssemblyFullName>
      <AssemblyName>mscorlib.dll</AssemblyName>
      <AssemblyLocation>C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>c9fdbd5c-a88b-4b7c-956c-d38eb563337e</RecID>
      <AssemblyFullName>System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</AssemblyFullName>
      <AssemblyName>System.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>e0b4c068-36d1-46d3-85e8-3bf5f6dc0489</RecID>
      <AssemblyFullName>Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</AssemblyFullName>
      <AssemblyName>Microsoft.VisualBasic.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualBasic\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>160a3b85-f575-4d9b-a6cd-60341c18a6a3</RecID>
      <AssemblyFullName>System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</AssemblyFullName>
      <AssemblyName>System.Drawing.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>1cba0a2f-65d8-4278-8f88-c6c639b770dc</RecID>
      <AssemblyFullName>System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</AssemblyFullName>
      <AssemblyName>System.Data.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>7d8c6e76-f855-46f3-95ab-5c69a1348e6a</RecID>
      <AssemblyFullName>JiwaODBC, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c</AssemblyFullName>
      <AssemblyName>JiwaODBC.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\JiwaODBC.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>7a7e8781-e5e8-4935-9e67-e7114b04ee43</RecID>
      <AssemblyFullName>System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</AssemblyFullName>
      <AssemblyName>System.Xml.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>de66b958-1a3b-44b9-93aa-ed72291df817</RecID>
      <AssemblyFullName>System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</AssemblyFullName>
      <AssemblyName>System.Runtime.Serialization.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>57d22308-4e24-499c-bc09-3acb497f7742</RecID>
      <AssemblyFullName>Microsoft.SqlServer.Smo, Version=13.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</AssemblyFullName>
      <AssemblyName>Microsoft.SqlServer.Smo.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\Microsoft.SqlServer.Smo.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>f20f3147-f984-45c4-87fd-c7b85aa4e785</RecID>
      <AssemblyFullName>Microsoft.SqlServer.ConnectionInfo, Version=13.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91</AssemblyFullName>
      <AssemblyName>Microsoft.SqlServer.ConnectionInfo.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\Microsoft.SqlServer.ConnectionInfo.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>f503a600-db2b-4f1f-9d58-b6065f0d7dc7</RecID>
      <AssemblyFullName>System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</AssemblyFullName>
      <AssemblyName>System.Windows.Forms.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>e6fb500f-ecdd-47a2-a0b9-d68f490727b4</RecID>
      <AssemblyFullName>Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Win.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>83873eef-b9cb-4e54-be8e-1729002a52ee</RecID>
      <AssemblyFullName>Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Win.Misc.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.Misc.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.Misc.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>d53f4281-13bb-4323-bc38-07a8220afe7b</RecID>
      <AssemblyFullName>Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Win.UltraWinEditors.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinEditors.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinEditors.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>0aa7e178-38d1-4e6c-8d80-565efca5dbae</RecID>
      <AssemblyFullName>Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Win.UltraWinExplorerBar.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinExplorerBar.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>0d330f8c-94f7-429e-a3a4-eb4cef0031f2</RecID>
      <AssemblyFullName>Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Win.UltraWinTree.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinTree.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinTree.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>a10a2689-956e-4d42-bc06-eef173f51c38</RecID>
      <AssemblyFullName>FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457</AssemblyFullName>
      <AssemblyName>FarPoint.Win.Spread.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\assembly\GAC_MSIL\FarPoint.Win.Spread\8.35.20151.0__327c3516b1b18457\FarPoint.Win.Spread.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>048bd1a5-772f-47a4-abeb-833ce87c91bd</RecID>
      <AssemblyFullName>Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Win.UltraWinTabControl.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinTabControl.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinTabControl.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>e408ed58-4c20-4c6c-bdb1-6c9073f1fc6b</RecID>
      <AssemblyFullName>Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Win.UltraWinToolbars.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinToolbars.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinToolbars.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>d2f5828d-ec4b-4a89-a851-70015405028d</RecID>
      <AssemblyFullName>Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Win.UltraWinStatusBar.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinStatusBar.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinStatusBar.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>ed196361-2959-4986-a1d3-2d28cf08dcb2</RecID>
      <AssemblyFullName>Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Win.UltraWinSchedule.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinSchedule.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinSchedule.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>568de6f5-c573-40a1-b963-b34dbc6923f0</RecID>
      <AssemblyFullName>Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Win.UltraWinListView.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinListView.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinListView.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>b5e25626-b7bd-41c7-b633-8a6f6c3499ff</RecID>
      <AssemblyFullName>ServiceStack, Version=4.0.0.0, Culture=neutral, PublicKeyToken=e06fbc6124f57c43</AssemblyFullName>
      <AssemblyName>ServiceStack.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\ServiceStack.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>c9505ab0-cf83-49c9-83f1-11396aa25c55</RecID>
      <AssemblyFullName>ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763</AssemblyFullName>
      <AssemblyName>ActiproSoftware.SyntaxEditor.WinForms.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.WinForms.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>c04f88d9-92ec-413e-a91f-b4b3b617c47d</RecID>
      <AssemblyFullName>ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0</AssemblyFullName>
      <AssemblyName>ZetaHtmlEditControl.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\ZetaHtmlEditControl.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>5fddd70f-a0b3-4338-87d5-0e60c153f9ff</RecID>
      <AssemblyFullName>ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763</AssemblyFullName>
      <AssemblyName>ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>32467449-4e1b-43e0-a9a7-5bb38d48637d</RecID>
      <AssemblyFullName>JiwaEncryption, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c</AssemblyFullName>
      <AssemblyName>JiwaEncryption.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\JiwaEncryption.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>1a2c5bb8-d6b9-42b8-b137-adef08816585</RecID>
      <AssemblyFullName>System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</AssemblyFullName>
      <AssemblyName>System.Security.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>03c2a4c7-cd01-48c1-97ce-2616c66f6383</RecID>
      <AssemblyFullName>Microsoft.SqlServer.Dac, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a</AssemblyFullName>
      <AssemblyName>Microsoft.SqlServer.Dac.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\Microsoft.SqlServer.Dac.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>72176f53-709e-4456-8cf9-af8b4a062f98</RecID>
      <AssemblyFullName>CrystalDecisions.CrystalReports.Engine, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304</AssemblyFullName>
      <AssemblyName>CrystalDecisions.CrystalReports.Engine.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.CrystalReports.Engine\13.0.3500.0__692fbea5521e1304\CrystalDecisions.CrystalReports.Engine.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>1fa0cbd7-0ed1-47f0-b45e-8bf4a51f0561</RecID>
      <AssemblyFullName>CrystalDecisions.Shared, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304</AssemblyFullName>
      <AssemblyName>CrystalDecisions.Shared.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Shared\13.0.3500.0__692fbea5521e1304\CrystalDecisions.Shared.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>fba39708-c770-406b-92f3-81a47c7cd6a7</RecID>
      <AssemblyFullName>System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</AssemblyFullName>
      <AssemblyName>System.Core.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>72aee815-f1a9-45bf-8c55-f703c3b885dc</RecID>
      <AssemblyFullName>Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Win.AppStylistSupport.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.AppStylistSupport.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.AppStylistSupport.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>a20e8223-d535-4327-bbfa-fe97136ac407</RecID>
      <AssemblyFullName>JiwaLib, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c</AssemblyFullName>
      <AssemblyName>JiwaLib.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\JiwaLib.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>10fc391f-b96d-4e85-8631-212ab6cd26a7</RecID>
      <AssemblyFullName>Microsoft.ApplicationInsights, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35</AssemblyFullName>
      <AssemblyName>Microsoft.ApplicationInsights.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\Microsoft.ApplicationInsights.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>1d384f81-1650-41fb-b3bc-ec22727ecb5b</RecID>
      <AssemblyFullName>CrystalDecisions.Windows.Forms, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304</AssemblyFullName>
      <AssemblyName>CrystalDecisions.Windows.Forms.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Windows.Forms\13.0.3500.0__692fbea5521e1304\CrystalDecisions.Windows.Forms.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>1de8bb18-c4bf-4bf4-9526-73204c339100</RecID>
      <AssemblyFullName>Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Win.UltraWinGrid.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinGrid.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinGrid.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>43104fc6-7a9c-4ad1-a336-bff1519c1bb7</RecID>
      <AssemblyFullName>Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb</AssemblyFullName>
      <AssemblyName>Infragistics4.Shared.v13.1.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Shared.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Shared.v13.1.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>925e4497-5b88-4e6e-bc3e-9c6474dc6b5e</RecID>
      <AssemblyFullName>Microsoft.Office.Interop.Outlook, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c</AssemblyFullName>
      <AssemblyName>Microsoft.Office.Interop.Outlook.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\assembly\GAC_MSIL\Microsoft.Office.Interop.Outlook\15.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Outlook.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>b544ecfd-fd59-479e-8ec7-aed08a2618e6</RecID>
      <AssemblyFullName>ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763</AssemblyFullName>
      <AssemblyName>ActiproSoftware.Shared.WinForms.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\assembly\GAC_MSIL\ActiproSoftware.Shared.WinForms\16.1.330.0__c27e062d3c1a4763\ActiproSoftware.Shared.WinForms.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>11accdaa-de37-4247-8869-586374a760b9</RecID>
      <AssemblyFullName>FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457</AssemblyFullName>
      <AssemblyName>FarPoint.Win.dll</AssemblyName>
      <AssemblyLocation>C:\WINDOWS\assembly\GAC_MSIL\FarPoint.Win\8.35.20151.0__327c3516b1b18457\FarPoint.Win.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>303b2419-4823-4a73-9703-d7f9cd5ed416</RecID>
      <AssemblyFullName>ServiceStack.Interfaces, Version=4.0.0.0, Culture=neutral, PublicKeyToken=e06fbc6124f57c43</AssemblyFullName>
      <AssemblyName>ServiceStack.Interfaces.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\ServiceStack.Interfaces.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>e5f64af0-4f52-4892-b717-9309b8deee51</RecID>
      <AssemblyFullName>ServiceStack.Server, Version = 4.0.0.0, Culture = neutral, PublicKeyToken = e06fbc6124f57c43</AssemblyFullName>
      <AssemblyName>ServiceStack.Server.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\ServiceStack.Server.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>490fd479-5ef8-4b40-87b0-0cfa4cb9e2b7</RecID>
      <AssemblyFullName>ServiceStack.OrmLite, Version = 4.0.0.0, Culture = neutral, PublicKeyToken = e06fbc6124f57c43</AssemblyFullName>
      <AssemblyName>ServiceStack.OrmLite.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\ServiceStack.OrmLite.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>d8b0dd6e-f110-4013-aebb-3b66ca706c93</RecID>
      <AssemblyFullName>JiwaInventory, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c</AssemblyFullName>
      <AssemblyName>JiwaInventory.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\JiwaInventory.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>b74c3c1e-6f5b-4f82-9ead-3f33feebe7f2</RecID>
      <AssemblyFullName>JiwaJournalSets, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c</AssemblyFullName>
      <AssemblyName>JiwaJournalSets.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\JiwaJournalSets.dll</AssemblyLocation>
    </Reference>
    <Reference>
      <RecID>5468e5b9-8395-4f5b-a428-913133ee7880</RecID>
      <AssemblyFullName>LumenWorks.Framework.IO, Version=7.0.175.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c</AssemblyFullName>
      <AssemblyName>LumenWorks.Framework.IO.dll</AssemblyName>
      <AssemblyLocation>C:\VSTS\7.00.175\Built Files\LumenWorks.Framework.IO.dll</AssemblyLocation>
    </Reference>
  </ReferenceCollection>
</JiwaDocument>