3de0c366-588e-441c-9b4d-5a461afb89af Delivery Runs No Dependency true false 0 using FarPoint.Win.Spread.CellType; using System; using System.Collections.Generic; using System.Data.SqlClient; #region "SQL" /* CREATE TABLE Addin_DeliveryRuns ( RecID uniqueidentifier NOT NULL, RunNumber INT NOT NULL, Driver uniqueidentifier NOT NULL, Truck uniqueidentifier NOT NULL, Trailer uniqueidentifier NOT NULL, Region uniqueidentifier NOT NULL, DeliveryDate datetime2, IsDefault BIT NOT NULL, ItemNo INT NOT NULL, RowHash Timestamp -- TODO: Based on RecID=0 count down to RowHash, then find "is the column number in the select query of the RowHash column" line and update that number CONSTRAINT [PK_Addin_DeliveryRuns_RecID] PRIMARY KEY CLUSTERED ([RecID] ASC) ) GO CREATE UNIQUE INDEX [IX_Addin_DeliveryRuns_RunNumber] ON Addin_DeliveryRuns(RunNumber) GO INSERT INTO Addin_DeliveryRuns(RecID, RunNumber, Driver, Truck, Trailer, Region, DeliveryDate, IsDefault, ItemNo) SELECT NewID(), 1, 'B1B7AEED-537C-42DB-B877-3E3164264F00','0749E694-0400-4F18-8BF2-1373F5AD4C90','D3F0527F-CD7B-4379-9222-330F4B9D0C3F','547D6E8B-16E6-42DE-937B-A2D9AFC412AA', NULL, 1, 1 GO IF NOT EXISTS(SELECT TOP 1 * FROM SY_Forms WHERE ClassName = 'DeliveryRuns') INSERT INTO SY_Forms(ClassName, Description, FormType, HelpFileName, HelpPageName, AssemblyFullName) SELECT 'DeliveryRuns', 'Delivery Runs', 2, '', '', (SELECT TOP 1 RecID FROM SY_Plugin WHERE Name = 'HALS - Delivery Runs') GO INSERT INTO SY_FormsAbstractPermissions(RecID, SY_Forms_ClassName, Name, Description, ItemNo) SELECT NEWID(), 'DeliveryRuns', 'Load', 'Load of the form', 1 INSERT INTO SY_FormsAbstractPermissions(RecID, SY_Forms_ClassName, Name, Description, ItemNo) SELECT NEWID(), 'DeliveryRuns', 'Edit', 'Edit of the form', 2 GO usp_Jiwa_Grant_Application_Permissions 'JiwaUser' GO usp_Jiwa_Grant_Reporting_Permissions 'JiwaReports' GO */ #endregion #region "Business Logic" public class DeliveryRun : JiwaFinancials.Jiwa.JiwaApplication.JiwaCollectionItem<DeliveryRun> { private int _RunNumber; private string _Driver; private string _Truck; private string _Trailer; private string _Region; private DateTime? _DeliveryDate; private bool _IsDefault; private System.DateTime m_LastSavedDateTime; public DeliveryRunCollection DeliveryRunCollection { get { return (DeliveryRunCollection)Collection; } } public int RunNumber { get { return _RunNumber; } set { _RunNumber = value; NotifyPropertyChanged("RunNumber"); } } public string Driver { get { return _Driver; } set { _Driver = value; NotifyPropertyChanged("Driver"); } } public string Truck { get { return _Truck; } set { _Truck = value; NotifyPropertyChanged("Truck"); } } public string Trailer { get { return _Trailer; } set { _Trailer = value; NotifyPropertyChanged("Trailer"); } } public string Region { get { return _Region; } set { _Region = value; NotifyPropertyChanged("Region"); } } public DateTime? DeliveryDate { get { return _DeliveryDate; } set { _DeliveryDate = value; NotifyPropertyChanged("DeliveryDate"); } } public bool IsDefault { get { return _IsDefault; } set { _IsDefault = value; NotifyPropertyChanged("IsDefault"); if ((Collection != null) && Collection.Reading == false) { if (value == true) { foreach (DeliveryRun otherDeliveryRun in Collection) { if (!otherDeliveryRun.Equals(this)) { if (otherDeliveryRun.IsDefault == true) { otherDeliveryRun.SetIsDefault(false); } } } } else { // You can't set the IsDefault to false : you must set another to true. _IsDefault = true; NotifyPropertyChanged("IsDefault"); } } } } internal void SetIsDefault(bool NewValue) { _IsDefault = NewValue; NotifyPropertyChanged("IsDefault"); } protected override void iSave() { string Sql = null; SqlParameter SQLParam = default(SqlParameter); var db = Manager.Database; // Save lines if (DeleteFlag == false) { if (InsertFlag) { Sql = @"INSERT INTO Addin_DeliveryRuns (RecID, RunNumber, Driver, Truck, Trailer, Region, DeliveryDate, IsDefault, ItemNo) VALUES (@RecID, @RunNumber, @Driver, @Truck, @Trailer, @Region, @DeliveryDate, @IsDefault, @ItemNo)"; } else { Sql = @"UPDATE Addin_DeliveryRuns SET RunNumber = @RunNumber, Driver = @Driver, Truck = @Truck, Trailer = @Trailer, Region = @Region, DeliveryDate = @DeliveryDate, IsDefault = @IsDefault, ItemNo = @ItemNo WHERE RecID = @RecID AND RowHash = @RowHash"; } using (SqlCommand SQLCmd = new SqlCommand(Sql, db.SQLConnection, db.SQLTransaction)) { SQLCmd.CommandTimeout = db.DefaultCommandTimeout; SQLParam = new SqlParameter("@RecID", System.Data.SqlDbType.UniqueIdentifier); SQLParam.Value = new Guid(RecID); SQLCmd.Parameters.Add(SQLParam); SQLCmd.Parameters.Add(new SqlParameter("@RunNumber", System.Data.SqlDbType.Int) { Value = RunNumber }); SQLCmd.Parameters.Add(new SqlParameter("@Driver", System.Data.SqlDbType.NVarChar, 36) { Value = Driver }); SQLCmd.Parameters.Add(new SqlParameter("@Truck", System.Data.SqlDbType.NVarChar, 36) { Value = Truck }); SQLCmd.Parameters.Add(new SqlParameter("@Trailer", System.Data.SqlDbType.NVarChar, 36) { Value = Trailer }); SQLCmd.Parameters.Add(new SqlParameter("@Region", System.Data.SqlDbType.NVarChar, 36) { Value = Region }); SQLCmd.Parameters.Add(DeliveryDate != null ? new SqlParameter("@DeliveryDate", System.Data.SqlDbType.DateTime2) { Value = DeliveryDate } : new SqlParameter("@DeliveryDate", System.Data.SqlDbType.DateTime2) { Value = DBNull.Value }); SQLParam = new SqlParameter("@IsDefault", System.Data.SqlDbType.Bit); SQLParam.Value = IsDefault; SQLCmd.Parameters.Add(SQLParam); SQLParam = new SqlParameter("@ItemNo", System.Data.SqlDbType.Int); SQLParam.Value = ItemNo; SQLCmd.Parameters.Add(SQLParam); if (InsertFlag == false) { SQLParam = new SqlParameter("@RowHash", System.Data.SqlDbType.Timestamp); SQLParam.Value = RowHash; SQLCmd.Parameters.Add(SQLParam); } if (SQLCmd.ExecuteNonQuery() == 0) { throw new JiwaFinancials.Jiwa.JiwaApplication.Exceptions.ConcurrencyConflictException("unable to write to Addin_DeliveryRuns table"); } } } if (DeleteFlag) { Sql = "DELETE FROM Addin_DeliveryRuns WHERE RecID = @RecID AND RowHash = @RowHash"; using (SqlCommand SQLCmd = new SqlCommand(Sql, db.SQLConnection, db.SQLTransaction)) { SQLCmd.CommandTimeout = db.DefaultCommandTimeout; SQLParam = new SqlParameter("@RecID", System.Data.SqlDbType.Char); SQLParam.Value = RecID; SQLCmd.Parameters.Add(SQLParam); SQLParam = new SqlParameter("@RowHash", System.Data.SqlDbType.Timestamp); SQLParam.Value = RowHash; SQLCmd.Parameters.Add(SQLParam); if (SQLCmd.ExecuteNonQuery() == 0) { throw new JiwaFinancials.Jiwa.JiwaApplication.Exceptions.ConcurrencyConflictException("unable to delete from Addin_DeliveryRuns"); } } } } } public class DeliveryRunCollection : JiwaFinancials.Jiwa.JiwaApplication.BusinessLogic.ListMaintenance<DeliveryRun> { protected override void OnRemoving(DeliveryRun item) { if (item.IsDefault) { throw new Exception("Cannot remove the DeliveryRun - make another the default first."); } base.OnRemoving(item); } public override void Read() { string Sql = null; SqlDataReader SQLReader = null; bool oldReading = Reading; try { Reading = true; Clear(); var db = Manager.Database; Sql = @"SELECT RecID, RunNumber, Driver, Truck, Trailer, Region, DeliveryDate, IsDefault, ItemNo, RowHash FROM Addin_DeliveryRuns ORDER BY ItemNo "; using (SqlCommand SQLCmd = new SqlCommand(Sql, db.SQLConnection, db.SQLTransaction)) { SQLReader = SQLCmd.ExecuteReader(); while (SQLReader.Read() == true) { DeliveryRun DeliveryRun = Manager.CollectionItemFactory.CreateCollectionItem<DeliveryRun>(); DeliveryRun.RecID = db.Sanitise(SQLReader, "RecID").ToString(); DeliveryRun.RunNumber = int.Parse(db.Sanitise(SQLReader, "RunNumber").ToString()); DeliveryRun.Driver = db.Sanitise(SQLReader, "Driver").ToString(); DeliveryRun.Truck = db.Sanitise(SQLReader, "Truck").ToString(); DeliveryRun.Trailer = db.Sanitise(SQLReader, "Trailer").ToString(); DeliveryRun.Region = db.Sanitise(SQLReader, "Region").ToString(); var deliveryDate = db.Sanitise(SQLReader, "DeliveryDate"); DeliveryRun.DeliveryDate = deliveryDate == null ? (DateTime?)null : DateTime.Parse(deliveryDate.ToString()); DeliveryRun.IsDefault = (bool)db.Sanitise(SQLReader, "IsDefault"); DeliveryRun.ItemNo = int.Parse(db.Sanitise(SQLReader, "ItemNo").ToString()); DeliveryRun.RowHash = new byte[8]; SQLReader.GetBytes(9, 0, DeliveryRun.RowHash, 0, 8); // 9 is the column number in the select query of the RowHash column Add(DeliveryRun); } SQLReader.Close(); } base.OnRead(); } finally { Reading = oldReading; if ((SQLReader != null)) { SQLReader.Close(); } } } public DeliveryRunCollection() : base() { base.ClientClassName = "DeliveryRunCollection"; base.RecIDIsGUID = true; } public ComboBoxItemsAndItemData GetComboBoxItemsAndItemData(string key) { var rtn = new ComboBoxItemsAndItemData(); switch (key) { case "Driver": rtn.Add("B1B7AEED-537C-42DB-B877-3E3164264F00", "Jimmy Johns"); rtn.Add("DCA718A8-68BA-4F7A-B525-737A27AE4D92", "Johnny Jims"); break; case "Truck": rtn.Add("0749E694-0400-4F18-8BF2-1373F5AD4C90", "S000·CVH"); rtn.Add("FCDF32FC-678F-46E7-A522-599A6016F10A", "DH·00·HD"); break; case "Trailer": rtn.Add("D3F0527F-CD7B-4379-9222-330F4B9D0C3F", "K 00 ZW"); rtn.Add("FC8B307B-6223-4D72-8473-D6167C3E04E1", "CF·21·AA"); break; case "Region": rtn.Add("547D6E8B-16E6-42DE-937B-A2D9AFC412AA", "North"); rtn.Add("BB5D995A-1F37-442D-A2B8-C6DCB0CB7C6F", "Northwest"); break; } return rtn; } } public class ComboBoxItemsAndItemData { public string[] Items { get { return _items.ToArray(); } } public string[] ItemData { get { return _itemData.ToArray(); } } private List<string> _items = new List<string>(); private List<string> _itemData = new List<string>(); public void Add(string itemData, string item) { _itemData.Add(itemData); _items.Add(item); } } #endregion #region "User Interface" public class DeliveryRuns : JiwaFinancials.Jiwa.JiwaApplication.ListMaintenance.UserInterface<DeliveryRun, DeliveryRunCollection> { #region "Base class overrides" public override void Setup() { base.Setup(); AddHandlers(); SetupForm(); } public override void AddHandlers() { grdLines.ButtonClicked += grdLines_ButtonClicked; grdLines.Change += grdLines_Change; grdLines.RowDragMoveCompleted += grdLines_RowDragMoveCompleted; base.AddHandlers(); } #endregion #region "Setup" public void SetupForm() { SetupWindow(); SetupControls(); } private void SetupControls() { SetupLinesGrid(); } public void SetupLinesGrid() { var driver = BusinessLogic.GetComboBoxItemsAndItemData("Driver"); var truck = BusinessLogic.GetComboBoxItemsAndItemData("Truck"); var trailer = BusinessLogic.GetComboBoxItemsAndItemData("Trailer"); var region = BusinessLogic.GetComboBoxItemsAndItemData("Region"); grdLines.AddColumn("RecID", new FarPoint.Win.Spread.CellType.TextCellType(), "RecID", 10, false, false, true, true); grdLines.AddColumn("RunNumber", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaCurrencyCellType { DecimalPlaces = 0 }, "Run #", 10, false, true, true, false); grdLines.AddColumn("Driver", new ComboBoxCellType { Items = driver.Items, ItemData = driver.ItemData, EditorValue = EditorValue.ItemData }, "Driver", 10, false, true, true, false); grdLines.AddColumn("Truck", new ComboBoxCellType { Items = truck.Items, ItemData = truck.ItemData, EditorValue = EditorValue.ItemData }, "Truck", 10, false, true, true, false); grdLines.AddColumn("Trailer", new ComboBoxCellType { Items = trailer.Items, ItemData = trailer.ItemData, EditorValue = EditorValue.ItemData }, "Trailer", 10, false, true, true, false); grdLines.AddColumn("Region", new ComboBoxCellType { Items = region.Items, ItemData = region.ItemData, EditorValue = EditorValue.ItemData }, "Region", 10, false, true, true, false); grdLines.AddColumn("DeliveryDate", new FarPoint.Win.Spread.CellType.DateTimeCellType(), "Delivery Date", 20, false, true, true, false); grdLines.AddColumn("Default", new FarPoint.Win.Spread.CellType.CheckBoxCellType(), "Default", 10, false, true, true, false); grdLines.AddColumn("Bin", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaBinButtonCellType(Manager), "", 10, false, true, false, true); grdLines.SetupComplete(); grdLines.ActiveSheet.RowHeader.ColumnCount = 1; grdLines.ActiveSheet.RowHeaderVisible = true; grdLines.AllowRowMove = false; } #endregion #region "Control Event Handlers" #region "grdLines" private void grdLines_ButtonClicked(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e) { FarPoint.Win.Spread.Column column = grdLines.ActiveSheet.Columns[e.Column]; if (column.Tag.ToString() == "Bin") { BusinessLogic.Remove(BusinessLogic[grdLines.get_GridText("RecID", e.Row).ToString()]); } else if (column.Tag.ToString() == "Default") { if (grdLines.get_GridText("RecID", e.Row).ToString().Trim().Length > 0) { BusinessLogic[grdLines.get_GridText("RecID", e.Row).ToString()].IsDefault = System.Convert.ToBoolean(grdLines.get_GridText(column.Tag.ToString(), e.Row).ToString()); } } } private void grdLines_Change(object sender, FarPoint.Win.Spread.ChangeEventArgs e) { string Key = null; string ColID = grdLines.ActiveSheet.Columns[e.Column].Tag.ToString(); if (ColID == "RunNumber") { if (e.Row == grdLines.ActiveSheet.RowCount - 1) { DeliveryRun DeliveryRun = Manager.CollectionItemFactory.CreateCollectionItem<DeliveryRun>(); DeliveryRun.RunNumber = System.Convert.ToInt32(grdLines.get_GridText("RunNumber", e.Row).ToString()); BusinessLogic.Add(DeliveryRun); } else { Key = grdLines.get_GridText("RecID", e.Row).ToString(); BusinessLogic[Key].RunNumber = System.Convert.ToInt32(grdLines.get_GridText("RunNumber", e.Row).ToString()); } } else if (ColID == "Driver") { if (e.Row == grdLines.ActiveSheet.RowCount - 1) { DeliveryRun DeliveryRun = Manager.CollectionItemFactory.CreateCollectionItem<DeliveryRun>(); DeliveryRun.Driver = grdLines.ActiveSheet.Cells[e.Row, e.Column].Value.ToString(); BusinessLogic.Add(DeliveryRun); } else { Key = grdLines.get_GridText("RecID", e.Row).ToString(); BusinessLogic[Key].Driver = grdLines.ActiveSheet.Cells[e.Row, e.Column].Value.ToString(); } } else if (ColID == "Truck") { if (e.Row == grdLines.ActiveSheet.RowCount - 1) { DeliveryRun DeliveryRun = Manager.CollectionItemFactory.CreateCollectionItem<DeliveryRun>(); DeliveryRun.Truck = grdLines.get_GridText("Truck", e.Row).ToString(); BusinessLogic.Add(DeliveryRun); } else { Key = grdLines.get_GridText("RecID", e.Row).ToString(); BusinessLogic[Key].Truck = grdLines.get_GridText("Truck", e.Row).ToString(); } } else if (ColID == "Trailer") { if (e.Row == grdLines.ActiveSheet.RowCount - 1) { DeliveryRun DeliveryRun = Manager.CollectionItemFactory.CreateCollectionItem<DeliveryRun>(); DeliveryRun.Trailer = grdLines.get_GridText("Trailer", e.Row).ToString(); BusinessLogic.Add(DeliveryRun); } else { Key = grdLines.get_GridText("RecID", e.Row).ToString(); BusinessLogic[Key].Trailer = grdLines.get_GridText("Trailer", e.Row).ToString(); } } else if (ColID == "Region") { if (e.Row == grdLines.ActiveSheet.RowCount - 1) { DeliveryRun DeliveryRun = Manager.CollectionItemFactory.CreateCollectionItem<DeliveryRun>(); DeliveryRun.Region = grdLines.get_GridText("Region", e.Row).ToString(); BusinessLogic.Add(DeliveryRun); } else { Key = grdLines.get_GridText("RecID", e.Row).ToString(); BusinessLogic[Key].Region = grdLines.get_GridText("Region", e.Row).ToString(); } } else if (ColID == "DeliveryDate") { if (e.Row == grdLines.ActiveSheet.RowCount - 1) { DeliveryRun DeliveryRun = Manager.CollectionItemFactory.CreateCollectionItem<DeliveryRun>(); DeliveryRun.DeliveryDate = System.Convert.ToDateTime(grdLines.get_GridText("DeliveryDate", e.Row).ToString()); BusinessLogic.Add(DeliveryRun); } else { Key = grdLines.get_GridText("RecID", e.Row).ToString(); BusinessLogic[Key].DeliveryDate = System.Convert.ToDateTime(grdLines.get_GridText("DeliveryDate", e.Row).ToString()); } } } private void grdLines_RowDragMoveCompleted(object sender, FarPoint.Win.Spread.DragMoveCompletedEventArgs e) { for (int row = 0; row <= grdLines.ActiveSheet.RowCount - 1; row++) { string recID = grdLines.get_GridText("RecID", row).ToString(); if (recID.Trim().Length > 0) { BusinessLogic[recID].ItemNo = row + 1; } } } #endregion #endregion #region "Display" public override void DisplayLine(DeliveryRun item, int Row = -1) { if (Row == -1) { for (int MyLoop = 0; MyLoop <= grdLines.ActiveSheet.Rows.Count - 1; MyLoop++) { if (grdLines.get_GridText("RecID", MyLoop).ToString() == item.RecID) { Row = MyLoop; break; } } } if (Row != -1) { var colNums = new Dictionary<string, int>(); // copy col header tag into each cell tag. foreach (FarPoint.Win.Spread.Column column in grdLines.ActiveSheet.Columns) { grdLines.ActiveSheet.Cells[Row, column.Index].Tag = grdLines.ActiveSheet.ColumnHeader.Cells[1, column.Index].Tag; colNums.Add(grdLines.ActiveSheet.Columns[column.Index].Tag.ToString(), column.Index); } var driver = BusinessLogic.GetComboBoxItemsAndItemData("Driver"); var truck = BusinessLogic.GetComboBoxItemsAndItemData("Truck"); var trailer = BusinessLogic.GetComboBoxItemsAndItemData("Trailer"); var region = BusinessLogic.GetComboBoxItemsAndItemData("Region"); // This is based on code in JiwaFinancials.Jiwa.JiwaApplication.Notes.NoteGridController(); grdLines.ActiveSheet.Cells[Row, grdLines.ActiveSheet.Columns["Driver"].Index].CellType = new ComboBoxCellType() { Items = driver.Items, ItemData = driver.ItemData, EditorValue = EditorValue.ItemData, Editable = false }; grdLines.ActiveSheet.Cells[Row, grdLines.ActiveSheet.Columns["Truck"].Index].CellType = new ComboBoxCellType() { Items = truck.Items, ItemData = truck.ItemData, EditorValue = EditorValue.ItemData, Editable = false }; grdLines.ActiveSheet.Cells[Row, grdLines.ActiveSheet.Columns["Trailer"].Index].CellType = new ComboBoxCellType() { Items = trailer.Items, ItemData = trailer.ItemData, EditorValue = EditorValue.ItemData, Editable = false }; grdLines.ActiveSheet.Cells[Row, grdLines.ActiveSheet.Columns["Region"].Index].CellType = new ComboBoxCellType() { Items = region.Items, ItemData = region.ItemData, EditorValue = EditorValue.ItemData, Editable = false }; grdLines.set_GridText("RecID", Row, item.RecID); grdLines.set_GridText("RunNumber", Row, item.RunNumber); grdLines.set_GridText("Driver", Row, (object)item.Driver); //grdLines.ActiveSheet.Cells[Row, grdLines.ActiveSheet.GetColumnFromTag(null, "Driver").Index].Value = item.Driver; //grdLines.ActiveSheet.Cells[Row, colNums["Driver"]].Value = item.Driver; grdLines.set_GridText("Truck", Row, item.Truck); grdLines.set_GridText("Trailer", Row, item.Trailer); grdLines.set_GridText("Region", Row, item.Region); grdLines.set_GridText("DeliveryDate", Row, item.DeliveryDate); grdLines.set_GridText("Default", Row, item.IsDefault); grdLines.LockColumn(false, "Default", Row); grdLines.LockColumn(false, "Bin", Row); } } #endregion public DeliveryRuns() { this.Text = "Delivery Runs"; } } #endregion Report CSharp 22dbb6df-663f-4310-8e2c-e5e6041cbb2d JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaApplication.dll f4a09f6b-6147-4d8c-a867-75799a4523b5 mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll d8dd1fd9-f176-45dd-a2c1-cfc45d9835b9 System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll 82692379-e996-4201-986a-3185042b675d Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.VisualBasic.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualBasic\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll fc14c8e0-30a1-4544-90e9-7bfd0dfa49f8 System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Drawing.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll a5706f01-239f-4e1d-9c28-5aa8d3f7c056 JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaODBC.dll ef976e98-217c-453f-9457-34c68959c040 System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Data.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll 35b2ae97-1f76-4e1b-8d40-71eb29e92cb2 System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Xml.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll ec3d414c-76f9-4e9e-add4-17a09ddf46b8 System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Runtime.Serialization.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll b38380f5-74c6-48ec-a0a8-c068bf50e868 System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Windows.Forms.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll cc6d5829-25be-435f-bdc8-5364ffbdd768 JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaServiceModel.dll 83ecbe91-a6d4-4be1-8247-b6812ce402a3 Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.Misc.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.Misc.v13.1.dll 244d10c1-ed48-4e74-b5ef-0e57ed9cf64d Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinEditors.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinEditors.v13.1.dll 185efdb1-e443-462e-89ff-57d0d6c15192 Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.v13.1.dll 2832b410-ec21-417c-a64a-389d4e85b0d9 Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.Smo.dll f2bfb4cb-02b4-4edd-ad32-8aeb8bfa853b Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.ConnectionInfo.dll 906eaaf3-87f2-4d8a-a5eb-7e9953f5d2b9 Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinExplorerBar.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll 1c2d2183-e390-4071-a8bb-ca383d8619d4 Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTree.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinTree.v13.1.dll f86991e7-5b20-481a-90d2-c198069cc7e4 FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\FarPoint.Win.Spread.dll 20e58991-6332-45f5-808f-09ed77cf8336 Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTabControl.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinTabControl.v13.1.dll 50a2f49a-ae56-4cb5-a50b-8d830f4e5ce1 Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Shared.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Shared.v13.1.dll a03cb33d-cd89-45a3-a424-e82c0575d92b Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinToolbars.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinToolbars.v13.1.dll bae13a06-b7cd-4084-a604-949ff7982155 Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinStatusBar.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinStatusBar.v13.1.dll a6fc6587-cd0f-45af-9ef2-ce18a07c2b62 Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinSchedule.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinSchedule.v13.1.dll 8898f786-9f51-4e8c-8938-881f70eb2e7e Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinListView.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinListView.v13.1.dll aef1c159-1598-455c-8471-cb3ce39fe35d ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.dll b7013d4a-ea30-42de-80bf-b0b78f2a7027 EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\EntityFramework.dll 03884559-eae1-4c47-a597-c751d212f724 System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Core.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll 188f1de0-a8c7-40d6-a52e-43c2c4d76a3b ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.SyntaxEditor.WinForms.dll 1fe5b761-f737-4a76-9fb1-4a565e67d0e4 ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ZetaHtmlEditControl.dll 60c8ba05-a05f-4fe0-b144-4ed93c8b2f62 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll 12b062b0-4e0b-4d80-b10a-372ba5b7f654 JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaEncryption.dll 551a20b5-5d83-4a05-8b42-79264aa30200 Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGrid.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinGrid.v13.1.dll cc171305-8836-4c0f-8f90-67d8d78b4341 Microsoft.SqlServer.Dac, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.Dac.dll 9c4d0d48-03a7-4587-8ea2-830a0da0abbd CrystalDecisions.CrystalReports.Engine, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.CrystalReports.Engine.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.CrystalReports.Engine\13.0.3500.0__692fbea5521e1304\CrystalDecisions.CrystalReports.Engine.dll cd6e99d2-ec5e-4c76-b0bf-232340297c32 CrystalDecisions.Shared, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Shared.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Shared\13.0.3500.0__692fbea5521e1304\CrystalDecisions.Shared.dll 97ec6fff-aac2-440d-9a6d-82b5a587a6f5 CrystalDecisions.ReportAppServer.Controllers, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.Controllers.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.Controllers\13.0.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.Controllers.dll fc51a488-3412-4a6d-8b00-1d4a6fe0b3a4 Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.AppStylistSupport.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.AppStylistSupport.v13.1.dll 02d2581d-7f84-44d6-a105-11109850e72b JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaLib.dll 1eaac0c5-4253-4bd4-bfdc-0e31237bd427 Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.ApplicationInsights.dll 2b353cd4-bb59-4823-839e-85f2fc616c2e CrystalDecisions.Windows.Forms, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Windows.Forms.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.Windows.Forms\13.0.3500.0__692fbea5521e1304\CrystalDecisions.Windows.Forms.dll 80a1799d-8d53-4b3d-878b-ac6c8ada28b1 EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.SqlServer.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\EntityFramework.SqlServer.dll 4205704d-fb44-4f1d-b365-923ac944e1a8 ServiceStack.Text, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Text.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Text.dll 520f2374-412c-451d-976c-563fa42218b1 ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.Shared.WinForms.dll 0ab9d6d9-cd1a-4652-9f05-3f6eaffe07a7 System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Security.dll C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll 31f086ec-f87e-437e-a6a9-08439acfbcea FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\FarPoint.Win.dll 1f0d1754-b517-472b-ab71-50bfd6822e3b CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.ClientDoc.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.ClientDoc\13.0.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ClientDoc.dll 6c361b1e-d398-4b30-b05a-8808ae18e77e CrystalDecisions.ReportAppServer.ReportDefModel, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.ReportDefModel.dll C:\WINDOWS\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.ReportDefModel\13.0.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ReportDefModel.dll ed26487f-bd60-4056-8d9c-4322ba76e901 ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Interfaces.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Interfaces.dll b91b1439-e2b2-4212-942b-82eb3f367a12 ServiceStack.Server, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.Server.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Server.dll 10358785-f1ba-4904-8efd-76d048e3605b ServiceStack.OrmLite, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.OrmLite.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.OrmLite.dll 2ff2608d-0a6a-412b-955b-27bbffd74fb3 76E53CE7-1692-4492-88DD-299C2CEBD6DB 1 Default Plugin Document Type true DeliveryRuns Setup.sql 2023-04-20T11:37:07.5 ZZZZZZZZZZ0000000000 ZZZZZZZZZZ0000000000 Admin