2577b8ed-b8cf-43a5-9e11-514126a55723 Attkey Add columns to Contacts Add extra column to Contacts. true false 0 Danny using Microsoft.VisualBasic; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Diagnostics; using JiwaFinancials.Jiwa; using System.Windows.Forms; using System.Data.SqlClient; using System.Drawing; using ServiceStack; using ServiceStack.DataAnnotations; using ServiceStack.Model; #region "FormPlugin" public class FormPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaFormPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid jiwaGrid; public void SetupBeforeHandlers(JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm JiwaForm, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } public void Setup(JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm JiwaForm, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { if (JiwaForm is JiwaFinancials.Jiwa.JiwaDebtorsUI.frmDebtor) { JiwaFinancials.Jiwa.JiwaDebtorsUI.frmDebtor debtorForm = (JiwaFinancials.Jiwa.JiwaDebtorsUI.frmDebtor)JiwaForm; jiwaGrid = debtorForm.grdContactNames; debtorForm.grdContactNames.AddColumn("UpdateDate",new FarPoint.Win.Spread.CellType.DateTimeCellType(), "Date Updated",10,false,true,true,false,20,false,false,0,false,false); debtorForm.grdContactNames.SetupComplete(); debtorForm.Debtor.SaveEnding += Attkey_ContactsSave; debtorForm.Debtor.ReadEnd += Attkey_ContactsRead; } } private void Attkey_ContactsSave(object sender, System.EventArgs e) { JiwaFinancials.Jiwa.JiwaDebtors.Debtor debtor = (JiwaFinancials.Jiwa.JiwaDebtors.Debtor)sender; string strSQL = ""; SqlParameter parameter = new SqlParameter(); JiwaFinancials.Jiwa.JiwaODBC.database database = debtor.Manager.Database; foreach(JiwaFinancials.Jiwa.JiwaDebtors.ContactName myContact in debtor.ContactNames) { //MessageBox.Show(myContact.InsertFlag.ToString() + " " + myContact.ChangeFlag.ToString() + " " + myContact.DeleteFlag.ToString()); if (!myContact.InsertFlag && !myContact.ChangeFlag && !myContact.DeleteFlag) { // strSQL = "DELETE FROM CN_ContactExtra WHERE ContactID = @ContactID"; // strSQL += "GO"; // strSQL = "INSERT INTO CN_ContactExtra VALUES (@ContactID, @UpdateDate)"; continue; } if (myContact.InsertFlag) { strSQL = "INSERT INTO CN_ContactExtra VALUES (@ContactID, @UpdateDate)"; } if (myContact.ChangeFlag && !myContact.InsertFlag) { strSQL = "UPDATE CN_ContactExtra SET DateUpdated = @UpdateDate WHERE ContactID = @ContactID "; } if (myContact.DeleteFlag) { strSQL = "DELETE FROM CN_ContactExtra WHERE ContactID = @ContactID"; } using (SqlCommand command = new SqlCommand(strSQL, database.SQLConnection, database.SQLTransaction)) { parameter = new SqlParameter("@ContactID", SqlDbType.Char); parameter.Value = myContact.RecID; command.Parameters.Add(parameter); parameter = new SqlParameter("@UpdateDate", SqlDbType.DateTime); parameter.Value = jiwaGrid.get_GridText("UpdateDate", myContact.ItemNo-1); command.Parameters.Add(parameter); if (database.ExecuteNonQuery(command) == 0) { string ErrorMessage = "Ah bugger!"; throw new JiwaFinancials.Jiwa.JiwaApplication.Exceptions.ConcurrencyConflictException(string.Concat(ErrorMessage)); } else { myContact.InsertFlag = false; myContact.ChangeFlag = false; } } } } private void Attkey_ContactsRead(object sender, System.EventArgs e) { JiwaFinancials.Jiwa.JiwaDebtors.Debtor debtor = (JiwaFinancials.Jiwa.JiwaDebtors.Debtor)sender; foreach(JiwaFinancials.Jiwa.JiwaDebtors.ContactName myContact in debtor.ContactNames) { string Sql = null; SqlDataReader SQLReader = null; SqlParameter SQLParam = null; try { var db = debtor.Manager.Database; Sql = "SELECT DateUpdated FROM CN_ContactExtra WHERE ContactID = @ContactID"; using (SqlCommand SQLCmd = new SqlCommand(Sql, db.SQLConnection, db.SQLTransaction)) { SQLCmd.CommandTimeout = debtor.Manager.Database.DefaultCommandTimeout; SQLParam = new SqlParameter("@ContactID", System.Data.SqlDbType.Char); SQLParam.Value = myContact.RecID; SQLCmd.Parameters.Add(SQLParam); SQLReader = SQLCmd.ExecuteReader(); while (SQLReader.Read() == true) { jiwaGrid.set_GridText("UpdateDate", myContact.ItemNo-1,db.Sanitise(SQLReader,"DateUpdated").ToString() ); } SQLReader.Close(); } } finally { if ((SQLReader != null)) { SQLReader.Close(); } } } } } #endregion #region "BusinessLogicPlugin" public class BusinessLogicPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogicPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void Setup(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic JiwaBusinessLogic, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion #region "ApplicationManagerPlugin" public class ApplicationManagerPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaApplicationManagerPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void Setup(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion #region "CustomFieldPlugin" public class CustomFieldPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void FormatCell(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } public void ReadData(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } public void ButtonClicked(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } } #endregion #region "LineCustomFieldPlugin" public class LineCustomFieldPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void FormatCell(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } public void ReadData(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } public void ButtonClicked(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } } #endregion #region "SystemSettingPlugin" public class SystemSettingPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaSystemSettingPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void FormatCell(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting) { } public void ReadData(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting) { } public void ButtonClicked(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting) { } } #endregion #region "ScheduledExecutionPlugin" public class ScheduledExecutionPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaScheduledExecutionPlugin { public void Execute(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin, JiwaFinancials.Jiwa.JiwaApplication.Schedule.Schedule Schedule) { lock (JiwaFinancials.Jiwa.JiwaApplication.Manager.CriticalSectionFlag) { // place processing code in here } } public void OnServiceStart(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } public void OnServiceStopping(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion Report CSharp cf4087af-2b08-4ffe-853d-f4b1eeac02e8 Debtor Maintenance JiwaFinancials.Jiwa.JiwaDebtorsUI.frmDebtor d10fa62d-72b9-406a-b378-9b5115e45065 JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaApplication.dll 9a8c1e96-51e6-452e-8685-41829ae078da mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll 039eb867-a3d4-4ed8-88f8-acebf8c745d2 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 bf27b3b0-fbd6-4c41-ae5a-03d79537e0c0 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 26617567-9052-40a4-8f86-24bbc0c46b59 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 4f273008-53e4-4e4a-b789-049aa0cb5fe7 JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaODBC.dll bd18b0f6-8bf2-4b2d-ac75-98e1e89bd55a 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 b6aa1634-e2bb-49a9-b677-80a8e0c56373 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 82400526-68df-4f07-b642-86b61a5747e0 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 91b7d846-3393-4b6c-ab02-d5b8acc54aac 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 a8cb9e08-bc60-4b9a-9380-6e151ea36e97 JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaServiceModel.dll 5bce2743-2351-46d9-8ec2-c5f1832f39cc 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.2.1\Infragistics4.Win.Misc.v13.1.dll 65279115-147b-49d6-b58a-3510aeb13e29 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.2.1\Infragistics4.Win.UltraWinEditors.v13.1.dll f4d2ef75-6ec2-453f-9245-a4fd1fdd090b 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.2.1\Infragistics4.Win.v13.1.dll 44a57411-b64f-4cdc-ad29-4c0eaa83d64b Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\Microsoft.SqlServer.Smo.dll 8bd94a2c-1b27-46ef-8d0c-8c1339ba54f7 Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\Microsoft.SqlServer.ConnectionInfo.dll f05a01ce-40e1-422c-bfb1-aba7b00d314c 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.2.1\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll 91898f3a-46f6-468d-ada1-59aa6840f22c 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.2.1\Infragistics4.Win.UltraWinTree.v13.1.dll d250986b-5c0e-4f40-aaf4-1dba3412540c FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\FarPoint.Win.Spread.dll ce87f79f-f866-4632-a9ed-e17fecccf38e 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.2.1\Infragistics4.Win.UltraWinTabControl.v13.1.dll 4b32543e-78e0-490f-a400-fa8fcd5b89f8 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.2.1\Infragistics4.Shared.v13.1.dll 8f3f2e50-f163-4e41-9c79-59d4a3c7ddac 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.2.1\Infragistics4.Win.UltraWinToolbars.v13.1.dll 62f57782-096d-42a3-b1ce-e6d8a2b6a13a 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.2.1\Infragistics4.Win.UltraWinStatusBar.v13.1.dll 390c7b73-c6ea-442a-92a1-cb2520176791 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.2.1\Infragistics4.Win.UltraWinSchedule.v13.1.dll bb228bad-94b1-46b8-9e9c-5f3a09cebad3 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.2.1\Infragistics4.Win.UltraWinListView.v13.1.dll 1fab4452-ee3c-4dba-94c2-80d4f8b04e6a ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ServiceStack.dll 73835241-4efb-4c1c-a292-291bfcc5c292 EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\EntityFramework.dll 3bf67d09-60f0-499b-a334-6e92fd64b9b5 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 d5347ffb-b7b2-43e9-8e02-19d7f5784acd ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ActiproSoftware.SyntaxEditor.WinForms.dll dd1cc5cc-65d1-46ec-b57a-2e027d939f60 ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ZetaHtmlEditControl.dll 072d1d4e-1879-4dc2-aa35-29fa5ef88889 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.2.1\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll 6749a9d0-0733-414f-ac3f-9daa1e823160 JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaEncryption.dll b25bf429-c6d7-41b5-b378-2f44ee90be83 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.2.1\Infragistics4.Win.UltraWinGrid.v13.1.dll e54273fa-1591-4d28-8506-370795337816 Microsoft.SqlServer.Dac, Version=15.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\Microsoft.SqlServer.Dac.dll 2e21023c-9b06-4395-b607-58ed0a0b11d5 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 78bdf769-81bf-49fe-80b4-036ead3fda8f 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 8bab0491-2ceb-434e-a685-dc0f69ea4230 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 e7722066-fb50-48a8-8a59-42f4fea4e71c 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.2.1\Infragistics4.Win.AppStylistSupport.v13.1.dll d5f1e447-5700-484d-945a-a4659607920f JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaLib.dll e1c29878-14cb-470e-b976-df951082654e Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\Microsoft.ApplicationInsights.dll 9609ee50-0b6d-47dc-9583-a98973e8589b 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 15476b60-539e-44a0-b318-012379b9d17e EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.SqlServer.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\EntityFramework.SqlServer.dll f8de7997-afc9-42d5-9913-fab2504cd6a9 ServiceStack.Text, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Text.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ServiceStack.Text.dll 1f7400f0-c6de-4277-8f12-4d7b6e670708 ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ActiproSoftware.Shared.WinForms.dll e6ffb632-c246-4399-9d61-6d4101347411 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 e59fca99-800d-428f-bc2c-8e2e30355e24 FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\FarPoint.Win.dll 80ce8e94-9a1b-4287-ba54-4d9b3c4c87ce 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 639e7040-e867-40b2-b40b-aa4087f5bab7 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 2823a297-6677-4f00-ad4f-7d05c7809d4d ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Interfaces.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ServiceStack.Interfaces.dll b013d470-6f64-44cd-a8de-eec2db48537e ServiceStack.Server, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.Server.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ServiceStack.Server.dll 153b1f19-c969-459f-8b77-4b1960aa8878 ServiceStack.OrmLite, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.OrmLite.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\ServiceStack.OrmLite.dll f4c3bb2c-4574-4bf3-a6b2-01ca2c7cc933 JiwaContactsUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaContactsUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaContactsUI.dll 135375af-904a-47b8-b418-f19501a2ba29 JiwaContacts, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaContacts.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaContacts.dll 0d31ed7a-5ca2-401e-9cf8-3d2b67b03e96 JiwaDebtors, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtors.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaDebtors.dll f2bd9758-eb1c-4b75-ac56-de22eda86dff JiwaCreditors, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaCreditors.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaCreditors.dll 49cb0cf4-02b0-44e7-a32f-a72e70444e49 JiwaDebtorsUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtorsUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaDebtorsUI.dll fc7b88cf-2e47-4b07-a3d7-a8574e10fb83 JiwaDebtorAdjustments, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtorAdjustments.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaDebtorAdjustments.dll bf4575cb-776b-464e-84ec-87499989b68c JiwaDebtorInvoices, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtorInvoices.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaDebtorInvoices.dll fd519598-74de-4535-8b7b-bbdb9d19a303 JiwaCashBookUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaCashBookUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaCashBookUI.dll 1add642a-9aa7-480a-8f02-a2cffa118d3a JiwaDebtorAdjustmentsUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtorAdjustmentsUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaDebtorAdjustmentsUI.dll 8f6e1c5f-5570-4c87-8863-90d81a1d8ba8 JiwaDebtorInvoicesUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtorInvoicesUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaDebtorInvoicesUI.dll 53e2c28f-c9be-4ab5-9671-5463a836e8a1 JiwaCashBook, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaCashBook.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaCashBook.dll 3ead1f82-838e-454b-86f3-bde25261b618 JiwaSalesUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaSalesUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaSalesUI.dll 0c8c98ca-5fcc-44ec-b911-a4a413b062ab JiwaInventoryUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaInventoryUI.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaInventoryUI.dll 03136d3b-9fae-41b0-b399-36657c923c7a JiwaInventory, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaInventory.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7.2.1\JiwaInventory.dll d944374c-d4f2-49c0-8457-1ff929672c63 BB6E534C-73E3-4706-851D-80FA3661375C 1 Default Plugin Document Type true extra table.txt contacst extra table. Run this in SQL 2022-10-26T14:21:39.427 ZZZZZZZZZZ0000000000 ZZZZZZZZZZ0000000000 Admin