2577b8ed-b8cf-43a5-9e11-514126a55723 Attkey Add columns to Contacts Add extra column to Contacts. true false 0 Danny 2 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; #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; } 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; 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; debtorForm.grdContactNames.Change += grdContactNames_Change; } } private void Attkey_ContactsSave(object sender, System.EventArgs e) { JiwaFinancials.Jiwa.JiwaDebtors.Debtor debtor = (JiwaFinancials.Jiwa.JiwaDebtors.Debtor)sender; JiwaFinancials.Jiwa.JiwaDebtorsUI.frmDebtor debtorForm = (JiwaFinancials.Jiwa.JiwaDebtorsUI.frmDebtor)debtor.Client; 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 = debtorForm.grdContactNames.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; JiwaFinancials.Jiwa.JiwaDebtorsUI.frmDebtor debtorForm = (JiwaFinancials.Jiwa.JiwaDebtorsUI.frmDebtor)debtor.Client; 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) { debtorForm.grdContactNames.set_GridText("UpdateDate", myContact.ItemNo-1,db.Sanitise(SQLReader,"DateUpdated").ToString() ); } SQLReader.Close(); } } finally { if ((SQLReader != null)) { SQLReader.Close(); } } } } private void grdContactNames_Change(object sender, FarPoint.Win.Spread.ChangeEventArgs e) { JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid grdContactNames = (JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid)sender; FarPoint.Win.Spread.Column column = grdContactNames.ActiveSheet.Columns[e.Column]; if (column.Tag.ToString().ToLower() == "UpdateDate".ToLower()) { JiwaFinancials.Jiwa.JiwaDebtorsUI.frmDebtor debtorForm = (JiwaFinancials.Jiwa.JiwaDebtorsUI.frmDebtor)grdContactNames.FindForm(); // flag the contact record corresponding to this row in the grid as changed. This will bubble events up causing the form to light up the save tool on the ribbon. // We could also simply do a debtorForm.Debtor.NotifyPropertyChanged(""); But it is better to cause a NotifyPropertyChanged from the contact name which has changed, // as this ensures all the flags are set on the item, collection and so on - and plugins listening to the PropertyChanged of the contact names might one day want to // do something based on which property changed. string key = grdContactNames.get_GridText("Key", e.Row).ToString(); if (key.Trim().Length > 0) { JiwaFinancials.Jiwa.JiwaDebtors.ContactName contactName = debtorForm.Debtor.ContactNames[key]; contactName.NotifyPropertyChanged("UpdateDate"); } } } } #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:\VSTS\Jiwa 7\07.02.00\Built Files\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 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:\VSTS\Jiwa 7\07.02.00\Built Files\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 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:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.Misc.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\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:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinEditors.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\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:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.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:\Windows\assembly\GAC_MSIL\FarPoint.Win.Spread\8.35.20151.0__327c3516b1b18457\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:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinTabControl.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\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:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Shared.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\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:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinToolbars.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\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:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinStatusBar.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinStatusBar.v13.1.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 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:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.AppStylistSupport.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.AppStylistSupport.v13.1.dll d5f1e447-5700-484d-945a-a4659607920f JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaLib.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:\Windows\assembly\GAC_MSIL\FarPoint.Win\8.35.20151.0__327c3516b1b18457\FarPoint.Win.dll 0d31ed7a-5ca2-401e-9cf8-3d2b67b03e96 JiwaDebtors, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtors.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaDebtors.dll 49cb0cf4-02b0-44e7-a32f-a72e70444e49 JiwaDebtorsUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaDebtorsUI.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaDebtorsUI.dll d944374c-d4f2-49c0-8457-1ff929672c63 BB6E534C-73E3-4706-851D-80FA3661375C 1 Default Plugin Document Type true extra table.sql contacts extra table. Run this in SQL 2022-10-26T15:16:27.56 ZZZZZZZZZZ0000000000 ZZZZZZZZZZ0000000000 Admin