e46dba6e-8c6f-46ce-b012-cda0efef82ec REST API Custom Routes Example Extends the REST API by adding some more routes. Demonstrates how a simple plugin can add new routes without the need to re-write or copy the full REST API plugin.
add Debtor PartNo and Debtor Delivery Address Queries. 
See Documents for SQL Views
Also add to Group API permissions if Required true false 0 Jiwa Financials 7.2.1.0 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; using JiwaFinancials.Jiwa.JiwaServiceModel.Tables; using ServiceStack.Auth; using System.Linq; using ServiceStack.OrmLite; namespace JiwaFinancials.Jiwa.JiwaServiceModel { public class RESTAPIPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaRESTAPIPlugin { public void Configure(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin, ServiceStack.ServiceStackHost AppHost, Funq.Container Container, JiwaApplication.Manager JiwaApplicationManager) { AppHost.RegisterService<CustomServices>(); AppHost.Routes.Add(typeof(MyDebtorContactGetRequest), "/Debtors/{DebtorID}/MyContacts", "GET", "Retrieves a list of contacts for a debtor.", ""); AppHost.Routes.Add(typeof(MySearchRequest), "/Search/{SearchTerm}", "GET", "Performs a system wide search for a search term using a Jiwa stored procedure", ""); AppHost.Routes.Add(typeof(MyCustomSearchRequest), "/SearchCustom/{SearchTerm}", "GET", "Performs a system wide search for a search term using a stored procedure", ""); AppHost.Routes.Add(typeof(InventoryACCToolsExtendedQuery), "/Queries/InventoryACCDebtorPartNo/{StartPosition}/{NumberRows}", "GET", "Retrieves Debtor PartNo list for Accent Tools.", ""); AppHost.Routes.Add(typeof(DebtorDelACCToolsExtendedQuery), "/Queries/DebtorsACCDelAddress/{StartPosition}/{NumberRows}", "GET", "Retrieves Debtor Delivery Address list for Accent Tools.", ""); } } #region "Requests" [Serializable()] [ApiResponse(200, "Contacts read OK")] [ApiResponse(401, "Not authenticated")] [ApiResponse(404, "No debtor with the Account No. provided was found")] public class MyDebtorContactGetRequest : IReturn<MyDebtorContactGetResponse> { public string DebtorID { get; set; } } [Serializable()] [ApiResponse(200, "OK")] [ApiResponse(401, "Not authenticated")] [ApiResponse(404, "No results found")] public class MySearchRequest : IReturn<List<MySearchReult>> { public string SearchTerm { get; set; } } [Serializable()] [ApiResponse(200, "OK")] [ApiResponse(401, "Not authenticated")] [ApiResponse(404, "No results found")] public class MyCustomSearchRequest : IReturn<List<MySearchReult>> { public string SearchTerm { get; set; } } [Serializable()] [ApiResponse(200, "OK")] [ApiResponse(401, "Not authenticated")] [ApiResponse(404, "No results found")] public class InventoryACCToolsExtendedQuery : IReturn<List<ACCToolsItemList>> { public int StartPosition { get; set; } public int NumberRows { get; set; } } [Serializable()] [ApiResponse(200, "OK")] [ApiResponse(401, "Not authenticated")] [ApiResponse(404, "No results found")] public class DebtorDelACCToolsExtendedQuery : IReturn<List<ACCToolsDebDelList>> { public int StartPosition { get; set; } public int NumberRows { get; set; } } #endregion #region "Responses" [Serializable()] public class MyDebtorContactGetResponse { public List<CN_Contact> Contacts {get; set;} } [Serializable()] public class ACCToolsItemList : List<ACCToolsItems> { } [Serializable()] public class ACCToolsDebDelList : List<ACCToolsDebDelItems> { } // This class is holds the results from the stored procedure usp_JIWA_Search - one property for each column of the result set, with matching data types [Serializable()] public class MySearchReult { public string SourceID {get; set;} public string SourceType {get; set;} public string SourceDocumentNo {get; set;} public string PhysicalWarehouse {get; set;} public string LogicalWarehouse {get; set;} public string MatchedOn {get; set;} public string MatchValue {get; set;} public string SY_Forms_ClassName {get; set;} } #endregion #region "Models public class ACCToolsItems { public string InventoryID { get; set; } public string PartNo { get; set; } public string DebtorPartNo { get; set; } public string DebtorAccountNo { get; set; } } public class ACCToolsDebDelItems { public string DebtorID { get; set; } public string DeliveryID { get; set; } public string DebtorAccountNo { get; set; } public string Address1 { get; set; } public string Address2 { get; set; } public string Address3 { get; set; } public string Address4 { get; set; } public string PostCode { get; set; } public string DefaultItem { get; set; } } #endregion #region "Services" public class CustomServices : Service { [Authenticate] public MyDebtorContactGetResponse Get(MyDebtorContactGetRequest request) { var query = Db.From<CN_Contact>() .Join<CN_Contact, CN_Main>((contact, prospect) => prospect.DebtorID == contact.ProspectID) .Join<CN_Main, DB_Main>((prospect, debtor) => prospect.DebtorID == debtor.DebtorID && debtor.DebtorID == request.DebtorID); return new MyDebtorContactGetResponse() { Contacts = Db.Select(query) } ; } [Authenticate] public List<MySearchReult> Get(MySearchRequest request) { var storedProcedure = StoredProcedures.SPList.usp_JIWA_Search(Db, request.SearchTerm); return storedProcedure.ConvertToList<MySearchReult>(); } [Authenticate] public List<MySearchReult> Get(MyCustomSearchRequest request) { return Db.SqlList<MySearchReult>("EXEC usp_JIWA_Search @SearchTerm", new { SearchTerm = request.SearchTerm }); } [Authenticate] public ACCToolsItemList Get(InventoryACCToolsExtendedQuery request) { string query = @"select InventoryID,PartNo,DebtorPartNo,DebtorAccountNo from SS_DebtorPartNo ORDER BY PartNo OFFSET @StartPosition ROWS FETCH NEXT @NumberRows ROWS ONLY;"; return Db.SqlList<ACCToolsItems>(query, new { StartPosition = request.StartPosition, NumberRows = request.NumberRows}).ConvertTo<ACCToolsItemList>(); } [Authenticate] public ACCToolsDebDelList Get(DebtorDelACCToolsExtendedQuery request) { string query = @"select Debtorid,DeliveryID,DebtorAccountNo,Address1,Address2,Address3,Address4,PostCode,DefaultItem from SS_DebtorDeliveryAddress ORDER BY DebtorAccountNo,DeliveryID OFFSET @StartPosition ROWS FETCH NEXT @NumberRows ROWS ONLY;"; return Db.SqlList<ACCToolsDebDelItems>(query, new { StartPosition = request.StartPosition, NumberRows = request.NumberRows}).ConvertTo<ACCToolsDebDelList>(); } } #endregion } Report CSharp 62525f72-9cc2-4ec0-afd2-22e12c6a163f JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaApplication.dll e87b7f93-3e05-4824-8fff-07e7b5ffef96 mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll 7ee448ab-b587-4c31-a163-7bcf5ec492b7 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 b6d119f1-822f-4c1b-a6aa-438194261629 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 f470d875-4c02-4450-8f9f-e0d78aff890a 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 bcff06d0-2b92-4209-97f7-52c69245fe85 JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaODBC.dll 10449460-b170-44ac-9d06-51a6c3685958 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 c7bc7da3-6151-4e99-b0ab-4eb926ab4965 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 c8ac32f1-ccbc-42dc-a917-ddc8f6a106f5 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 22cb671f-a133-4988-b8dd-2420791f487a 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 bb9346d9-8896-4f85-bc8f-e9576c0240b8 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 174f9386-f0ca-4ce6-9cfc-9c93f4cfc74c 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 2da5dba4-fd2c-4e25-b368-34c4eaf03bf5 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 f4297bdb-4506-45a8-84dc-3bbcc9a86279 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 c17edc7b-8d6c-4a32-822c-595dfc317bc7 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 11a3ad09-ad2b-4316-bd20-7e0da3cfeb9d 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 9d4efdb8-8874-41e8-a24d-8811cae45ba1 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 68de1bdc-c2d1-4663-9e30-8edcc3cd3225 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 d66bfb24-27fb-40be-9ad2-f83a2d795ee9 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 bbffa7b0-c8c6-44da-945d-08a34d8ce8bd 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 65cf07fb-baed-4779-8cb4-501a5689e5e8 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 ad41e8d2-facc-4927-93f5-d22b7c2e8cf5 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 0daf0f03-79b0-47dd-ab87-6f351c9a6d51 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 be362d38-33b5-4427-add3-2b7d1fa2bea8 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 1d23ba90-f426-4444-ae17-58880b76b1ab ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.dll d165616d-7268-4ce3-b96a-9d29e714d7af 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 7fc0cd64-a6fb-443b-befa-8ba0ca35c7b3 ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ZetaHtmlEditControl.dll fa014f8c-ee91-498c-86b9-ad6a0152b210 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 cb19a086-381a-4781-8371-db2e6359db55 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 ab3bb92f-5640-47c0-b714-6f7352f8f4a7 JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaEncryption.dll 244101bf-a7db-4094-bad6-4826f03e2051 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 f29b4d1b-db93-4dd0-ac81-de3fd38aa6bf 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 ad5a1672-027b-4340-8be9-eb6b1e2e8547 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 baebbb10-c0e0-4fed-9cd3-d0ba6f241ae2 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 0892fdf6-4851-460a-80c2-0965f536f616 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 87a37f44-7d45-40b4-855d-0626b4002588 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 63ea532a-5dbe-422f-85cc-e3979777555a 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 02b86abb-3eb0-456c-bb83-04a823d80bd8 JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaLib.dll 89f08cf6-e744-4bfd-9c86-27d778c7e67e 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 3ed6854c-93f4-44e4-b152-71d65e4e1b64 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 88a92389-ea4a-48b8-ab0d-0038e9535352 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 8671372f-d542-4f17-ac57-1d9eb8b1db05 Microsoft.Office.Interop.Outlook, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c Microsoft.Office.Interop.Outlook.dll C:\Windows\assembly\GAC_MSIL\Microsoft.Office.Interop.Outlook\15.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Outlook.dll d3ea7066-ae08-421e-b92b-4089914696dc 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 611a6673-2eb0-4a98-97a6-9c59f591cfa8 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 27e2fc28-5677-4560-9bd3-3b2848897285 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 e69e2449-7453-4389-a362-b8549a3a1c58 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 398049a3-25e1-433a-b3cf-5c783bbd64c3 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 45e52d82-f59f-43cc-b00c-b3bd52edad30 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 f4452e03-5fa5-4054-bc66-253becc2e35d ServiceStack.OrmLite.SqlServer, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.OrmLite.SqlServer.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.OrmLite.SqlServer.dll a85d2793-cee9-4f34-8656-82ed004e93e7 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 b510ac86-8584-4567-ba4a-445fcb2b9102 System.Net, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Net.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Net\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Net.dll 6f112929-1546-460e-a802-eecd1b9d3672 JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaServiceModel.dll 5931b649-13f2-4150-9f76-73217f63ab27 536C8458-261A-42FD-A028-74F0536D4C42 1 Default Plugin Document Type true SS_DebtorDeliveryAddress.sql 2022-11-25T14:55:17.03 ZZZZZZZZZZ0000000000 ZZZZZZZZZZ0000000000 Admin