a235ed76-079e-4a32-b777-3c671cd00317 REST API Get all inventory limited fields Get all inventory but limit fields to the bare essential. Just InventoryID and Description true false 0 Abu Web Commerce 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) { AppHost.RegisterService<CustomServices>(); AppHost.Routes.Add(typeof(InventoryLimitFieldsRequest), "/Custom/GetAllInventoryMinFields/{StartPosition}/{NumberRows}", "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 InventoryLimitFieldsRequest : IReturn<InventoryLimitFieldsResponse> { public int StartPosition { get; set; } public int NumberRows { get; set; } } #endregion #region "Responses" [Serializable()] public class InventoryLimitFieldsResponse : List<MyCustomModel> { } #endregion #region "Models" public class MyCustomModel { public string InventoryID { get; set; } public string PartNo { get; set; } public string Description { get; set; } public int Status { get; set; } public string Aux2 { get; set; } /*public DateTime LastSavedDateTime { get; set; } public decimal DefaultPrice { get; set; } public decimal RRPPrice { get; set; } public bool BackOrderable { get; set; } public DateTime ForwardPriceDate { get; set; } public decimal Price1 { get; set; } public decimal Price2 { get; set; } public decimal Price3 { get; set; } public decimal Price4 { get; set; } public decimal ForwardPrice1 { get; set; } public decimal ForwardPrice2 { get; set; } public decimal ForwardPrice3 { get; set; } public decimal ForwardPrice4 { get; set; } */ } #endregion #region "Services" public class CustomServices : Service { [Authenticate] public InventoryLimitFieldsResponse Get(InventoryLimitFieldsRequest request) { string query = @"SELECT main.InventoryID, main.PartNo, main.Description, main.Status, main.Aux2 FROM IN_Main main ORDER BY main.Description OFFSET @StartPosition ROWS FETCH NEXT @NumberRows ROWS ONLY;"; return Db.SqlList<MyCustomModel>(query, new { StartPosition = request.StartPosition, NumberRows = request.NumberRows}).ConvertTo<InventoryLimitFieldsResponse>(); } } #endregion } Report CSharp 44ca681d-0ea3-4ef7-82f0-366e2277d038 JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\Jiwa 7\JiwaApplication.dll bf8f9d56-f86d-45af-a496-833f199b8809 mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll 43dee852-fd31-41b7-a98c-c4dcf4369bd3 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 12c3d632-dae7-48c4-a140-e395b27f73d6 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 9d231889-8762-4976-ae9c-1931180d0aaa 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 c77af98b-3175-4392-9f44-ff2eb3ed4508 JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\Jiwa 7\JiwaODBC.dll 124feab8-8b1c-47ca-ae78-e293133d38b0 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 36f50396-ed6a-432b-b56f-4b03f55d4c47 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 ee56d566-52f4-40ed-985b-13cdf6209c3e 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 66539342-4c14-4aad-a209-9459497648d3 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 9530ebbe-a31a-46e8-82b7-8e2aa4776d35 JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\Jiwa 7\JiwaServiceModel.dll 8701f954-d5c9-4e7c-99fd-5620ea619855 Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.Misc.v13.1.dll C:\Jiwa 7\Infragistics4.Win.Misc.v13.1.dll 110a090b-5569-4b38-bb35-a7e3b515e696 Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinEditors.v13.1.dll C:\Jiwa 7\Infragistics4.Win.UltraWinEditors.v13.1.dll c50a0a47-1e2d-4ad4-8ab4-cc0b6c4803f6 Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.v13.1.dll C:\Jiwa 7\Infragistics4.Win.v13.1.dll 9beef8af-0da3-42d6-8ac0-f670a1a5805b Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll C:\Jiwa 7\Microsoft.SqlServer.Smo.dll a4efaf44-49be-400f-83e4-108e70a248a3 Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll C:\Jiwa 7\Microsoft.SqlServer.ConnectionInfo.dll 2ece7051-4d5a-4fa0-96f7-8ac895761495 Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinExplorerBar.v13.1.dll C:\Jiwa 7\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll da99c183-3d06-489a-8633-257bfa8f1810 Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTree.v13.1.dll C:\Jiwa 7\Infragistics4.Win.UltraWinTree.v13.1.dll 707977fc-bd9b-4b9e-9e95-219aed7d6402 FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\Jiwa 7\FarPoint.Win.Spread.dll 14c8d4fc-7f9a-49d0-b877-306bf845bad7 Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTabControl.v13.1.dll C:\Jiwa 7\Infragistics4.Win.UltraWinTabControl.v13.1.dll da127a99-a2ba-46dc-aae8-4c9c1c75ca15 Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Shared.v13.1.dll C:\Jiwa 7\Infragistics4.Shared.v13.1.dll 3cf389f7-249d-4ff4-a029-23b7f57f8dad Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinToolbars.v13.1.dll C:\Jiwa 7\Infragistics4.Win.UltraWinToolbars.v13.1.dll fb79a4be-1e39-4379-9006-227af6ab0e89 Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinStatusBar.v13.1.dll C:\Jiwa 7\Infragistics4.Win.UltraWinStatusBar.v13.1.dll ea45dee5-27e9-424d-8155-dc734e0707ba Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinSchedule.v13.1.dll C:\Jiwa 7\Infragistics4.Win.UltraWinSchedule.v13.1.dll 7b06694f-8491-4a96-a20f-eee5c8825397 Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinListView.v13.1.dll C:\Jiwa 7\Infragistics4.Win.UltraWinListView.v13.1.dll 77241724-0efb-45d7-96d0-65d7dfc8cb66 ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll C:\Jiwa 7\ServiceStack.dll 84c25a9d-d870-4c73-9d60-d27536ca11de EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.dll C:\Jiwa 7\EntityFramework.dll 6f346f05-056f-4599-94c0-6f5d6e5c2fc0 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 6d547edc-a760-4b8d-98c6-12d16bb1e35c ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll C:\Jiwa 7\ActiproSoftware.SyntaxEditor.WinForms.dll f83ae762-80b3-4787-bf6a-7d4f3f5337f6 ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll C:\Jiwa 7\ZetaHtmlEditControl.dll 98f75c81-d893-4b56-bb39-823a526a5029 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll C:\Jiwa 7\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll ed6e42b6-0ee4-4d05-ad38-6969666f1641 JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\Jiwa 7\JiwaEncryption.dll e01251e4-b940-4234-84c0-f45c54e016bb Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGrid.v13.1.dll C:\Jiwa 7\Infragistics4.Win.UltraWinGrid.v13.1.dll 774def02-9c47-4b99-932d-aafb7d5e8aff Microsoft.SqlServer.Dac, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll C:\Jiwa 7\Microsoft.SqlServer.Dac.dll 3b84fb56-975d-4476-ba9e-d5bc5a64aa98 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 796239bf-9157-4403-8015-88210e0ac4af 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 99f0ce61-b523-4e86-97e2-d4fc1e03a080 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 acd88246-cd2f-4f15-8ad7-b66abe850823 Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.AppStylistSupport.v13.1.dll C:\Jiwa 7\Infragistics4.Win.AppStylistSupport.v13.1.dll 2c432bad-d3c7-408d-a72c-0ae8cc0db041 JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\Jiwa 7\JiwaLib.dll 88f69a4b-353c-4152-8b39-c021b466f6d4 Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll C:\Jiwa 7\Microsoft.ApplicationInsights.dll 3577f629-5a99-4f58-be55-a7c71dd183a8 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 a367a4ed-aedb-4af1-8a6f-48f9ebf0fd76 EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 EntityFramework.SqlServer.dll C:\Jiwa 7\EntityFramework.SqlServer.dll c677c71e-1a5e-4957-a7e5-1809609db961 ServiceStack.Text, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Text.dll C:\Jiwa 7\ServiceStack.Text.dll 8e72c244-0b28-45ac-ba23-a72d7daff6f8 ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll C:\Jiwa 7\ActiproSoftware.Shared.WinForms.dll fe375b1c-1725-487a-b732-50bf74bf68bf 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 de29b22f-02eb-4b14-9959-35decb1c8d3f FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\Jiwa 7\FarPoint.Win.dll b445581b-b7aa-475e-87ce-a8aa1c8d1f01 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 5ee4d991-af9e-4103-ac8d-11adea00a769 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 80d61dbd-4bc8-442e-bc3c-b012e2881f70 System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Configuration.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll 92d8af0b-26e3-48fa-852d-553c5ea520e7 ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Interfaces.dll C:\Jiwa 7\ServiceStack.Interfaces.dll 4dfee0d2-8b40-4d13-a78b-8a6c5900dffa ServiceStack.Server, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.Server.dll C:\Jiwa 7\ServiceStack.Server.dll 5b590a14-5b62-4c25-8771-9f062ba91720 ServiceStack.OrmLite, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587 ServiceStack.OrmLite.dll C:\Jiwa 7\ServiceStack.OrmLite.dll