b40d2936-8783-4080-9179-e360013bd3f9 SQL Like true false 1 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; // Db 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) { // System.Diagnostics.Debugger.Launch(); // System.Diagnostics.Debugger.Break(); Plugin.PluginReferenceCollection.Read(); AppHost.RegisterService<CustomServices>(); AppHost.Routes.Add(typeof(GetInventoryItemsLikeNameRequest), "/Custom/PostInventoryItemsLikeNameRequest/", "GET", "Retrieves inventory with limited fields, end and start specified.", ""); } } #region "Requests" [ApiResponse(200, "Records retrieved OK")] [ApiResponse(401, "Not authenticated")] [ApiResponse(404, "Handler for Request not found")] public class GetInventoryItemsLikeNameRequest : IReturn<GetInventoryItemsLikeNameResponse> { public string ItemName { get; set; } } #endregion #region "Responses" [Serializable()] public class GetInventoryItemsLikeNameResponse { public List<MyCustomModel> Result {get;set;} } #endregion #region "Models" public class MyCustomModel { public DateTime LastSavedDateTime { get; set; } public string InventoryID { get; set; } public string PartNo { get; set; } public string Description { get; set; } public int Status { get; set; } public decimal DefaultPrice { get; set; } public decimal RRPPrice { get; set; } public string Aux2 { get; set; } public bool BackOrderable { get; set; } public decimal Price1 { get; set; } public decimal Price2 { get; set; } public decimal Price3 { get; set; } public decimal Price4 { get; set; } public decimal Price9 { get; set; } } #endregion #region "Services" public class CustomServices : Service { [Authenticate] public GetInventoryItemsLikeNameResponse Get(GetInventoryItemsLikeNameRequest request) { string query = @"SELECT main.LastSavedDateTime, main.InventoryID, main.PartNo, main.Description, main.Status, main.DefaultPrice, main.RRPPrice, main.Aux2, main.BackOrderable, price.InventoryID, price.Price1, price.Price2, price.Price3, price.Price4, price.Price9 FROM IN_Main main LEFT JOIN IN_SellingPrices price ON price.InventoryID=main.InventoryID WHERE main.Description LIKE @ItemName ORDER BY main.Description ;"; string sinput = "%" + request.ItemName + "%"; GetInventoryItemsLikeNameResponse response = new GetInventoryItemsLikeNameResponse(); response.Result = Db.SqlList<MyCustomModel>(query, new {ItemName = sinput}); return response; } } } #endregion Report CSharp 83c279a0-f2bb-4083-8e05-fce20e64b6a0 JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaApplication.dll 75e3d527-a537-4b66-8b36-c202482a8ca2 mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll 5f26f0d5-f9cf-4bbe-82c4-6da6a75ab478 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 9d09bece-a26d-4678-a8ee-b27d68496403 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 455513b3-3379-4b0c-964e-f719df2fe7dd 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 960ba4cd-ce72-41b9-93ca-9636b550147f JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaODBC.dll afcd1936-e88d-4d70-802f-8789b0592fbf 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 04bcc6de-cd4e-4f35-9466-12a6648015c5 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 8ccfbceb-e6d3-40e5-8231-1cf6bc9b6231 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 8014495e-4830-4a32-af56-23385b808e7d 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 e5db0d3e-16b2-4616-aa7b-5435adcaa942 JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaServiceModel.dll c9641ff9-fba4-46f3-8a15-cdde8063a694 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 81f5de15-d7fd-402a-b444-f7a2421e33a8 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 0785fb41-1cef-4686-935c-58da104361e6 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 2a68ee61-7567-4f73-b541-8b51dda289f3 Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.Smo.dll d06c2775-168d-4061-957a-0f10a5f3ee62 Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.ConnectionInfo.dll 29acc462-0acd-4682-aaf7-c48e25721aef Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinExplorerBar.v13.1.dll 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 f8725b45-e8cd-496b-8dd1-d8f9c338875f Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTree.v13.1.dll 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 a835f2fa-1547-4c3d-a841-6fc59f7b0b77 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 c311ec8b-74d2-4c8e-900d-ce1a55f63ebb 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 78c4ba95-e8ab-4743-848c-d1ab8d5f0487 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 8563d3bc-3867-42f7-ac23-a4bfa67d10e2 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 decef860-e8f7-4a61-8937-fcefcd8db61b 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 53f6cd0c-716a-4b4b-ab13-fc67e3498a67 Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinSchedule.v13.1.dll 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 5bff0987-eff8-44e9-8281-861e827ec1f6 Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinListView.v13.1.dll 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 15bac4be-e341-4c12-9514-ece7803ea59b ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.dll 390805a5-cf88-4ce9-8123-8fc00fbbde55 EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\EntityFramework.dll 8f479a57-a838-4914-80a5-dd0191d8b601 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 11b647af-4dd1-4170-9f39-236b8a3518a3 ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.SyntaxEditor.WinForms.dll e42b824a-6a78-4626-a97a-470dd89004fd ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\ZetaHtmlEditControl.dll db6bda7c-3c4d-49b9-b7b8-4b5b51bba9b3 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll 3d5088e7-626f-4bce-acca-fd8dda546dfe JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaEncryption.dll 8514e5c8-fb22-4b15-af85-9b6d5e4e8fb9 Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGrid.v13.1.dll 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 5f14b59a-6e0c-4d6c-bbb8-08b9948bb1e3 Microsoft.SqlServer.Dac, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.Dac.dll 7ae9761e-a6d0-4add-b200-19eaa012b883 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 1c9e2d04-b483-44ba-965f-ddd6679b8306 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 3b4b7bab-6a92-437a-b1a5-5580ad8ab770 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 64b5975f-bffe-4f71-a159-946a39605467 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 eb6d5e56-dd80-4fa6-8493-5f94fda63861 JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaLib.dll 279d5dba-2a7b-49de-ab1e-3f445160bec3 Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.ApplicationInsights.dll 234ab20b-b8dd-4cd7-88db-4a055bdcbc28 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 f83e0c0e-2f5b-4d9c-99f7-730a6b46caf2 EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.SqlServer.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\EntityFramework.SqlServer.dll 25baf53e-451b-4276-9ffb-efb990326c22 ServiceStack.Text, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Text.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Text.dll 1b866fe8-d200-4228-89c2-a6777c7a2460 ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.Shared.WinForms.dll bdce26fb-e7ff-4f44-91af-b83bdb5f04d3 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 9a716e64-ea17-4015-a5c0-e1dd2ae0cce1 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 52cac511-e7e4-4d37-8eac-0e8dcbfa50eb 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 b95e3fe8-dd47-4e9b-ad8f-ab796d8c7dee 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 77d7ca25-461f-4e77-8506-8967f38db1db ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Interfaces.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Interfaces.dll 1ec4c53f-f975-4071-9d88-9828cd28e52e ServiceStack.Server, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.Server.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Server.dll 1d115768-399d-47be-b987-8955bdd8826c ServiceStack.OrmLite, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.OrmLite.dll E:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.OrmLite.dll f1acc51b-e8d8-4ae5-8505-9fdb96df6418 7ddc7010-5098-4aaf-b518-9f93c64065af REST API Provides a REST HTTP endpoint with some routes. Jiwa Financials false 0