82999ffa-2d4b-43f6-9768-2eccf9443db2
REST API Export Invoice and Statement
Extends the REST API by allowing for the exporting of invoices and statements to pdf and other formats. Note you need to set the system settings and restart the web api first.
true
false
0
Stuart Barnes
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;
using System.Data;
using System.Data.Common;
using ServiceStack.DataAnnotations;
using System.Runtime.Serialization;
#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)
{
System.Data.SqlClient.SqlParameter SQLParam = null;
System.Data.SqlClient.SqlDataReader SQLReader = null;
if (SystemSetting.IDKey == "SRep" || SystemSetting.IDKey == "SRep" || SystemSetting.IDKey == "IRep") {
if (SystemSetting.Contents.Trim().Length > 0)
{
string SQL = "";
var db = BusinessLogicHost.Manager.Database;
try
{
SQL = @"SELECT SY_ReportSection.Name+' \ ' + SY_Report.FileName as DisplayName FROM SY_Report JOIN SY_ReportSection ON SY_Report.SY_ReportSection_RecID = SY_ReportSection.RecID
where SY_Report.RecID = @RecID ";
using (SqlCommand SQLCmd = new SqlCommand(SQL, db.SQLConnection, db.SQLTransaction))
{
SQLParam = new SqlParameter("@RecID", System.Data.SqlDbType.Char);
SQLParam.Value = SystemSetting.Contents;
SQLCmd.Parameters.Add(SQLParam);
SQLReader = db.ExecuteReader(SQLCmd);
if (SQLReader.Read() == true)
{
SystemSetting.DisplayContents = string.Format("{0}", db.Sanitise(SQLReader, "DisplayName"));
}
}
SQLReader.Close();
} finally {
if ((SQLReader != null))
{
SQLReader.Close();
}
}
}
if (SystemSetting.IDKey == "SProc" || SystemSetting.IDKey == "IProc") {
if (SystemSetting.Contents.Trim().Length > 0)
{
string SQL = "";
var db = BusinessLogicHost.Manager.Database;
try
{
SQL = @"Select [NAME] from sysobjects where type = 'P' and category = 0 and [NAME]
= @RecID ";
using (SqlCommand SQLCmd = new SqlCommand(SQL, db.SQLConnection, db.SQLTransaction))
{
SQLParam = new SqlParameter("@RecID", System.Data.SqlDbType.Char);
SQLParam.Value = SystemSetting.Contents;
SQLCmd.Parameters.Add(SQLParam);
SQLReader = db.ExecuteReader(SQLCmd);
if (SQLReader.Read() == true)
{
SystemSetting.DisplayContents = string.Format("{0}", db.Sanitise(SQLReader, "NAME"));
}
}
SQLReader.Close();
} finally {
if ((SQLReader != null))
{
SQLReader.Close();
}
}
}
}
}
}
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)
{
System.Data.SqlClient.SqlParameter SQLParam = null;
System.Data.SqlClient.SqlDataReader SQLReader = null;
if (SystemSetting.IDKey == "SRep" || SystemSetting.IDKey == "SRep" || SystemSetting.IDKey == "IRep" )
{
var search = BusinessLogicHost.Manager.Search;
search.Clear();
search.CurrentOption = 1;
JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.clsSearch.SearchModes searchMode = JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.clsSearch.SearchModes.jswReports;
search.SetDefaultSearch(ref searchMode);
search.UsePinBoard = false;
if (search.Show(FormObject.Form) == System.Windows.Forms.DialogResult.OK)
{
if (search.Results.Count > 0)
{
var idField = (JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.Field)search.get_Fields(1);
SystemSetting.Contents = idField.FieldValue.ToString();
var TitleField = (JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.Field)search.get_Fields(2);
var FileNameField = (JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.Field)search.get_Fields(3);
SystemSetting.DisplayContents = String.Format("{0} / {1}", TitleField.FieldValue.ToString(), FileNameField.FieldValue.ToString());
}
else
{
throw new JiwaFinancials.Jiwa.JiwaApplication.Exceptions.ClientCancelledException();
}
}
else
{
throw new JiwaFinancials.Jiwa.JiwaApplication.Exceptions.ClientCancelledException();
}
}
if (SystemSetting.IDKey == "IProc" || SystemSetting.IDKey == "SProc")
{
var search = BusinessLogicHost.Manager.Search;
search.Clear();
search.CurrentOption = 1;
JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.clsSearch.SearchModes searchMode = JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.clsSearch.SearchModes.jswStoredProcedures;
search.SetDefaultSearch(ref searchMode);
search.UsePinBoard = false;
if (search.Show(FormObject.Form) == System.Windows.Forms.DialogResult.OK)
{
if (search.Results.Count > 0)
{
var idField = (JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.Field)search.get_Fields(1);
SystemSetting.Contents = idField.FieldValue.ToString();
// var TitleField = (JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.Field)search.get_Fields(2);
// var FileNameField = (JiwaFinancials.Jiwa.JiwaApplication.JiwaSearch.Field)search.get_Fields(3);
//
SystemSetting.DisplayContents = idField.FieldValue.ToString();
}
else
{
throw new JiwaFinancials.Jiwa.JiwaApplication.Exceptions.ClientCancelledException();
}
}
else
{
throw new JiwaFinancials.Jiwa.JiwaApplication.Exceptions.ClientCancelledException();
}
}
}
}
#endregion
namespace JiwaFinancials.Jiwa.JiwaServiceModel
{
public class RESTAPIPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaRESTAPIPlugin
{
public static string PluginName;
public static string StatementReportID;
public static string InvoiceReportID;
public static string StatementProc;
public static string InvoiceProc;
public void Configure(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin, ServiceStack.ServiceStackHost AppHost, Funq.Container Container, JiwaApplication.Manager JiwaApplicationManager)
{
Plugin.PluginReferenceCollection.Read();
AppDomain.CurrentDomain.AssemblyResolve += delegate(object sender, System.ResolveEventArgs args) { return AssemblyResolve(sender, args, Plugin); };
System.Reflection.AssemblyName aName = new System.Reflection.AssemblyName(System.Reflection.Assembly.GetExecutingAssembly().GetName().FullName);
PluginName = aName.Name;
StatementReportID = JiwaApplicationManager.Database.ReadSysData(PluginName, "SRep", "0").ToString();
InvoiceReportID = JiwaApplicationManager.Database.ReadSysData(PluginName, "IRep", "0").ToString();
StatementProc = JiwaApplicationManager.Database.ReadSysData(PluginName, "SProc", "0").ToString();
InvoiceProc = JiwaApplicationManager.Database.ReadSysData(PluginName, "IProc", "0").ToString();
bool PDFExport = bool.Parse(JiwaApplicationManager.Database.ReadSysData(PluginName, "PDFExport", "0").ToString());
bool GExport = bool.Parse(JiwaApplicationManager.Database.ReadSysData(PluginName, "GExport", "0").ToString());
bool SExport = bool.Parse(JiwaApplicationManager.Database.ReadSysData(PluginName, "SExport", "0").ToString());
bool IExport = bool.Parse(JiwaApplicationManager.Database.ReadSysData(PluginName, "IExport", "0").ToString());
AppHost.RegisterService<ExporterService>();
if(SExport && GExport)
{
AppHost.Routes.Add(typeof(StatementGetRequest), "/Export/Statement", "GET", "Get the debtor statement as raw data", "");
}
if(SExport && PDFExport)
{
AppHost.Routes.Add(typeof(StatementPDFGetRequest), "/ExportPDF/StatementPDF", "GET", "Get the debtor statement as pdf", "");
}
if(IExport && GExport)
{
AppHost.Routes.Add(typeof(InvoiceGetRequest), "/Export/Invoice", "GET", "Get the debtor invoice as raw data", "");
}
if(IExport && PDFExport)
{
AppHost.Routes.Add(typeof(InvoicePDFGetRequest), "/ExportPDF/InvoicePDF", "GET", "Get the debtor invoice as pdf", "");
}
}
public System.Reflection.Assembly AssemblyResolve(object sender, System.ResolveEventArgs args, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin)
{
// If the requested assembly is a reference to another plugin, then we need to attempt to resolve the assembly ourselves
foreach(JiwaApplication.Plugin.PluginReference pluginReference in Plugin.PluginReferenceCollection)
{
if (String.Format("{0}, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null", pluginReference.Name) == args.Name)
return System.Reflection.Assembly.LoadFile(pluginReference.Plugin.RuntimeFileName);
}
return null;
}
}
#region "Requests"
[Serializable()]
[ApiResponse(200, "Statement read OK")]
[ApiResponse(401, "Not authenticated")]
[ApiResponse(404, "No Statement was found")]
public class StatementGetRequest : IReturn<StatementGetResponse>
{
}
[Serializable()]
[ApiResponse(200, "Statement read OK")]
[ApiResponse(401, "Not authenticated")]
[ApiResponse(404, "No Statement was found")]
public class StatementPDFGetRequest : IReturn<ServiceStack.Web.IHttpResult>
{
}
[Serializable()]
[ApiResponse(200, "Statement read OK")]
[ApiResponse(401, "Not authenticated")]
[ApiResponse(404, "No Statement was found")]
public class InvoiceGetRequest : IReturn<InvoiceGetResponse>
{
public string InvoiceNo { get; set; }
public int HistoryNo { get; set; }
}
[Serializable()]
[ApiResponse(200, "Statement read OK")]
[ApiResponse(401, "Not authenticated")]
[ApiResponse(404, "No Statement was found")]
public class InvoicePDFGetRequest : IReturn<ServiceStack.Web.IHttpResult>
{
public string InvoiceNo { get; set; }
public int HistoryNo { get; set; }
}
#endregion
#region "Responses"
[Serializable()]
[DataContract]
public class StatementGetResponse
{
[DataMember]
public string DebtorID { get; set; }
[DataMember]
public string DebtorAccountNo { get; set; }
[DataMember]
public string DebtorName { get; set; }
[DataMember]
public string Address1 { get; set; }
[DataMember]
public string Address2 { get; set; }
[DataMember]
public string Address3 { get; set; }
[DataMember]
public string Address4 { get; set; }
[DataMember]
public string PostCode { get; set; }
[DataMember]
public string ABN { get; set; }
[DataMember]
public decimal CurrentBalance { get; set; }
[DataMember]
public decimal Period1Balance { get; set; }
[DataMember]
public decimal Period2Balance { get; set; }
[DataMember]
public decimal Period3Balance { get; set; }
[DataMember]
public decimal TotalBalance { get; set; }
[DataMember]
public string PeriodType { get; set; }
[DataMember]
public bool Parent { get; set; }
[DataMember]
public string TransID { get; set; }
[DataMember]
public string InvRemitNo { get; set; }
[DataMember]
public DateTime TransactionDate { get; set; }
[DataMember]
public string Reference { get; set; }
[DataMember]
public string Remark { get; set; }
[DataMember]
public string TransactionType { get; set; }
[DataMember]
public decimal Amount { get; set; }
[DataMember]
public decimal DebitAmount { get; set; }
[DataMember]
public decimal CreditAmount { get; set; }
[DataMember]
public decimal AllocatedAmount { get; set; }
[DataMember]
public bool DebitCredit { get; set; }
[DataMember]
public decimal TransactionBalance { get; set; }
[DataMember]
public int PeriodNo { get; set; }
[DataMember]
public int MoneyDecimalPlaces { get; set; }
}
[Serializable()]
[DataContract]
public class InvoiceGetResponse
{
[DataMember]
public string InvoiceLineID { get; set; }
[DataMember]
public short? LineNum { get; set; }
[DataMember]
public string LineType { get; set; }
[DataMember]
public string PartNo { get; set; }
[DataMember]
public decimal? QuantityThisDelivery { get; set; }
[DataMember]
public string StyleCode { get; set; }
[DataMember]
public string StyleID { get; set; }
[DataMember]
public string Comment { get; set; }
[DataMember]
public string PartDescription { get; set; }
[DataMember]
public decimal? AvgPriceEachExGST { get; set; }
[DataMember]
public decimal? AvgPriceEachIncGST { get; set; }
[DataMember]
public decimal? PriceTotalExGST { get; set; }
[DataMember]
public decimal? PriceTotalIncGST { get; set; }
[DataMember]
public string StyleDescription { get; set; }
[DataMember]
public string InvoiceNo { get; set; }
[DataMember]
public short? HistoryNo { get; set; }
[DataMember]
public string CompanyName { get; set; }
[DataMember]
public string CompanyABN { get; set; }
[DataMember]
public string CompanyAddress1 { get; set; }
[DataMember]
public string CompanyAddress2 { get; set; }
[DataMember]
public string CompanyAddress3 { get; set; }
[DataMember]
public string CompanyAddress4 { get; set; }
[DataMember]
public string CompanyPhone { get; set; }
[DataMember]
public string CompanyFax { get; set; }
[DataMember]
public string CompanyEmail { get; set; }
[DataMember]
public string CompanyWebsite { get; set; }
[DataMember]
public string CustomerName { get; set; }
[DataMember]
public string CustomerAddress1 { get; set; }
[DataMember]
public string CustomerAddress2 { get; set; }
[DataMember]
public string CustomerAddress3 { get; set; }
[DataMember]
public string CustomerAddress4 { get; set; }
[DataMember]
public string CustomerPostCode { get; set; }
[DataMember]
public string CustomerABN { get; set; }
[DataMember]
public string OrderNo { get; set; }
[DataMember]
public string AccountNo { get; set; }
[DataMember]
public string TaxExemptNo { get; set; }
[DataMember]
public string CourierDetails { get; set; }
[DataMember]
public string SOReference { get; set; }
[DataMember]
public string SalesPerson { get; set; }
[DataMember]
public DateTime? RecordDate { get; set; }
[DataMember]
public string DelContactName { get; set; }
[DataMember]
public string DeliveryAddress1 { get; set; }
[DataMember]
public string DeliveryAddress2 { get; set; }
[DataMember]
public string DeliveryAddress3 { get; set; }
[DataMember]
public string DeliveryAddress4 { get; set; }
[DataMember]
public string DeliveryPostCode { get; set; }
[DataMember]
public string DeliveryAddressCountry { get; set; }
[DataMember]
public decimal? SubTotalIncGST { get; set; }
[DataMember]
public decimal? Cart1IncGST { get; set; }
[DataMember]
public decimal? Cart2IncGST { get; set; }
[DataMember]
public decimal? Cart3IncGST { get; set; }
[DataMember]
public decimal? InvoiceTotalIncGST { get; set; }
[DataMember]
public string Notes { get; set; }
[DataMember]
public bool? CreditNote { get; set; }
[DataMember]
public short? QuantityDecimalPlaces { get; set; }
[DataMember]
public byte? MoneyDecimalPlaces { get; set; }
[DataMember]
public decimal? SubTotalExGST { get; set; }
[DataMember]
public decimal? Cart1ExGST { get; set; }
[DataMember]
public decimal? Cart2ExGST { get; set; }
[DataMember]
public decimal? Cart3ExGST { get; set; }
[DataMember]
public decimal? InvoiceTotalExGST { get; set; }
[DataMember]
public decimal? LineGSTAmount { get; set; }
[DataMember]
public decimal? SubTotalGST { get; set; }
[DataMember]
public decimal? Cart1GST { get; set; }
[DataMember]
public decimal? Cart2GST { get; set; }
[DataMember]
public decimal? Cart3GST { get; set; }
[DataMember]
public decimal? InvoiceTotalGST { get; set; }
[DataMember]
public byte? KitHeader { get; set; }
[DataMember]
public byte? KitComponent { get; set; }
[DataMember]
public decimal? ItemTaxToCharge { get; set; }
[DataMember]
public decimal? QuantityOrdered { get; set; }
[DataMember]
public decimal? QuantityOnBackOrder { get; set; }
[DataMember]
public string Units { get; set; }
[DataMember]
public string KitLineID { get; set; }
[DataMember]
public decimal? QuantityPreviousDelivery { get; set; }
[DataMember]
public bool? UseSerialNo { get; set; }
[DataMember]
public decimal? TotalAmountPaid { get; set; }
[DataMember]
public decimal? TotalAmountTendered { get; set; }
[DataMember]
public string InvoiceID { get; set; }
[DataMember]
public string CashSaleName { get; set; }
[DataMember]
public string CashSaleCompany { get; set; }
[DataMember]
public string CashSaleAddress1 { get; set; }
[DataMember]
public string CashSaleAddress2 { get; set; }
[DataMember]
public string CashSaleAddress3 { get; set; }
[DataMember]
public string CashSaleAddress4 { get; set; }
[DataMember]
public string CashSalePostcode { get; set; }
[DataMember]
public string CashSalePhone { get; set; }
[DataMember]
public string CashSaleFax { get; set; }
[DataMember]
public string CashSaleContactName { get; set; }
[DataMember]
public decimal? OrderedPriceTotalExGST { get; set; }
[DataMember]
public decimal? OrderedPriceTotalIncGST { get; set; }
[DataMember]
public decimal? SubTotalOrderedIncGST { get; set; }
[DataMember]
public decimal? OrderedInvoiceTotalIncGST { get; set; }
[DataMember]
public decimal? LineOrderedGSTAmount { get; set; }
[DataMember]
public decimal? SubTotalOrderedGST { get; set; }
[DataMember]
public short? PeriodType { get; set; }
[DataMember]
public short? TermsDays { get; set; }
[DataMember]
public short? TermsType { get; set; }
[DataMember]
public decimal? QtyThisDelUom { get; set; }
[DataMember]
public string UomName { get; set; }
[DataMember]
public string UomPartNo { get; set; }
[DataMember]
public decimal? QtyOrderedUom { get; set; }
[DataMember]
public decimal? QtyBackOrdUom { get; set; }
[DataMember]
public decimal? ItemPriceUom { get; set; }
[DataMember]
public decimal? ItemPriceIncGSTUom { get; set; }
[DataMember]
public DateTime? ExpectedDeliveryDate { get; set; }
[DataMember]
public decimal? SubTotalOrderedExGST { get; set; }
[DataMember]
public decimal? OrderedInvoiceTotalExGST { get; set; }
[DataMember]
public decimal? OrderedInvoiceTotalGST { get; set; }
[DataMember]
public string AltAccountNo { get; set; }
[DataMember]
public DateTime? ForwardOrderDate { get; set; }
[DataMember]
public DateTime? ScheduledDate { get; set; }
[DataMember]
public decimal? OrderedCartage1ExTax { get; set; }
[DataMember]
public decimal? OrderedCartage2ExTax { get; set; }
[DataMember]
public decimal? OrderedCartage3ExTax { get; set; }
[DataMember]
public decimal? OrderedCartage1Tax { get; set; }
[DataMember]
public decimal? OrderedCartage2Tax { get; set; }
[DataMember]
public decimal? OrderedCartage3Tax { get; set; }
[DataMember]
public decimal? OrderedCartage1IncTax { get; set; }
[DataMember]
public decimal? OrderedCartage2IncTax { get; set; }
[DataMember]
public decimal? OrderedCartage3IncTax { get; set; }
}
#endregion
#region "Services"
public class ExporterService : Service
{
private JiwaServiceModel.Tables.v_APIKey GetApiKey(string apiKey)
{
return this.Db.Single(this.Db.From<JiwaServiceModel.Tables.v_APIKey>().Where(x => x.KeyValue == apiKey));
}
private JiwaServiceModel.Tables.DB_Main GetDBMain(string DebtorID)
{
return this.Db.Single(this.Db.From<JiwaServiceModel.Tables.DB_Main>().Where(x => x.DebtorID == DebtorID));
}
private JiwaServiceModel.Tables.SO_History GetSOHist(string DebtorID, string InvNo, int HistoryNo)
{
//return this.Db.Single(this.Db.From<JiwaServiceModel.Tables.DB_Main>().Where(x => x.DebtorID == DebtorID));
var query = Db.From<SO_History>()
.Join<SO_History, SO_Main>((History, Main) =>( History.InvoiceID == Main.InvoiceID) && (Main.DebtorID == DebtorID && History.HistoryNo == HistoryNo) && (Main.InvoiceNo == InvNo) );
List<JiwaFinancials.Jiwa.JiwaServiceModel.Tables.SO_History> result = (Db.Select<JiwaFinancials.Jiwa.JiwaServiceModel.Tables.SO_History>(query));
if(result == null || result.Count == 0)
{
return null;
}
return result.FirstOrDefault();
}
[Authenticate]
public List<InvoiceGetResponse> Get(InvoiceGetRequest request)
{
//System.Diagnostics.Debugger.Launch();
JiwaApplication.Manager manager = this.SessionAs<JiwaAuthUserSession>().Manager;
string DebtorID = "";
string DebtorAcc = "";
string HistoryID = "";
if(manager.Database.APIKey_Type == "Debtor" )
{
JiwaServiceModel.Tables.v_APIKey vapikey = GetApiKey(manager.Database.APIKey_KeyValue);
if(vapikey == null || vapikey.Name == "")
{
throw new Exception("API Key is not for debtor.");
}
JiwaServiceModel.Tables.DB_Main dbMain = GetDBMain(vapikey.PrincipalID);
if(dbMain == null)
{
throw new Exception("No debtor found.");
}
DebtorID = dbMain.DebtorID;
JiwaServiceModel.Tables.SO_History hist = GetSOHist(DebtorID, request.InvoiceNo, request.HistoryNo);
if(hist == null)
{
throw new Exception("No invoice found for debtor.");
}
HistoryID = hist.InvoiceHistoryID;
Db.SetCommandTimeout(600);
return StoredProcedures.SPList.usp_Jiwa_Invoices_Invoice(Db, HistoryID).ConvertToList<InvoiceGetResponse>();
}
else
{
throw new Exception("API Key is not for a debtor.");
}
return new List<InvoiceGetResponse>();
}
[Authenticate]
public ServiceStack.Web.IHttpResult Get(InvoicePDFGetRequest request)
{
//System.Diagnostics.Debugger.Launch();
JiwaApplication.Manager manager = this.SessionAs<JiwaAuthUserSession>().Manager;
string DebtorID = "";
string DebtorAcc = "";
string HistoryID = "";
if(manager.Database.APIKey_Type == "Debtor" )
{
JiwaServiceModel.Tables.v_APIKey vapikey = GetApiKey(manager.Database.APIKey_KeyValue);
if(vapikey == null || vapikey.Name == "")
{
throw new Exception("API Key is not for debtor.");
}
JiwaServiceModel.Tables.DB_Main dbMain = GetDBMain(vapikey.PrincipalID);
if(dbMain == null)
{
throw new Exception("No debtor found.");
}
DebtorID = dbMain.DebtorID;
JiwaServiceModel.Tables.SO_History hist = GetSOHist(DebtorID, request.InvoiceNo, request.HistoryNo);
if(hist == null)
{
throw new Exception("No invoice found for debtor.");
}
HistoryID = hist.InvoiceHistoryID;
//Db.SetCommandTimeout(600);
//return StoredProcedures.SPList.usp_Jiwa_Invoices_Invoice(Db, HistoryID).ConvertToList<InvoiceGetResponse>();
using (ReportsServices rs = base.ResolveService<ReportsServices>())
{
ReportsPDFGETRequest pdfreq = new ReportsPDFGETRequest();
pdfreq.ReportID = RESTAPIPlugin.InvoiceReportID;
pdfreq.ReportParameters = new List<ReportParameter>();
pdfreq.AsAttachment = true;
pdfreq.ReportParameters.Add(new ReportParameter(){Name = "Pass_SP_InvoiceHistoryID", Value = HistoryID});
return rs.Get(pdfreq);
}
}
else
{
throw new Exception("API Key is not for a debtor.");
}
return new HttpResult("Failed wrong api key type", System.Net.HttpStatusCode.BadRequest);
}
[Authenticate]
public List<StatementGetResponse> Get(StatementGetRequest request)
{
//System.Diagnostics.Debugger.Launch();
JiwaApplication.Manager manager = this.SessionAs<JiwaAuthUserSession>().Manager;
string DebtorID = "";
string DebtorAcc = "";
if(manager.Database.APIKey_Type == "Debtor" )
{
JiwaServiceModel.Tables.v_APIKey vapikey = GetApiKey(manager.Database.APIKey_KeyValue);
if(vapikey == null || vapikey.Name == "")
{
throw new Exception("API Key is not for debtor.");
}
JiwaServiceModel.Tables.DB_Main dbMain = GetDBMain(vapikey.PrincipalID);
if(dbMain == null)
{
throw new Exception("No debtor found.");
}
DebtorID = dbMain.DebtorID;
DebtorAcc = dbMain.AccountNo;
Db.SetCommandTimeout(600);
return StoredProcedures.SPList.usp_JIWA_Debtors_StatementsAsAt(Db, DebtorAcc,DebtorAcc, DateTime.Now).ConvertToList<StatementGetResponse>();
}
else
{
throw new Exception("API Key is not for a debtor.");
}
return new List<StatementGetResponse>();
}
[Authenticate]
public ServiceStack.Web.IHttpResult Get(StatementPDFGetRequest request)
{
//System.Diagnostics.Debugger.Launch();
JiwaApplication.Manager manager = this.SessionAs<JiwaAuthUserSession>().Manager;
string DebtorID = "";
string DebtorAcc = "";
if(manager.Database.APIKey_Type == "Debtor" )
{
JiwaServiceModel.Tables.v_APIKey vapikey = GetApiKey(manager.Database.APIKey_KeyValue);
if(vapikey == null || vapikey.Name == "")
{
throw new Exception("API Key is not for debtor.");
}
JiwaServiceModel.Tables.DB_Main dbMain = GetDBMain(vapikey.PrincipalID);
if(dbMain == null)
{
throw new Exception("No debtor found.");
}
DebtorID = dbMain.DebtorID;
DebtorAcc = dbMain.AccountNo;
//Db.SetCommandTimeout(600);
//return StoredProcedures.SPList.usp_JIWA_Debtors_StatementsAsAt(Db, DebtorAcc,DebtorAcc, DateTime.Now).ConvertToList<StatementGetResponse>();
using (ReportsServices rs = base.ResolveService<ReportsServices>())
{
ReportsPDFGETRequest pdfreq = new ReportsPDFGETRequest();
pdfreq.ReportID = RESTAPIPlugin.StatementReportID;
pdfreq.ReportParameters = new List<ReportParameter>();
pdfreq.AsAttachment = true;
pdfreq.ReportParameters.Add(new ReportParameter(){Name = "Pass_SP_StartingDebtorAccountNo", Value = DebtorAcc});
pdfreq.ReportParameters.Add(new ReportParameter(){Name = "Pass_SP_EndingDebtorAccountNo", Value = DebtorAcc});
pdfreq.ReportParameters.Add(new ReportParameter(){Name = "Pass_SP_AsAtDate", Value = DateTime.Now.ToString()});
return rs.Get(pdfreq);
}
}
else
{
throw new Exception("API Key is not for a debtor.");
}
return new HttpResult("Failed wrong api key type", System.Net.HttpStatusCode.BadRequest);
}
}
#endregion
}
namespace JiwaFinancials.Jiwa.JiwaServiceModel.StoredProcedures
{
public static partial class SPList
{
private static DbParameter CreateNewParameter(DbCommand dbCommand, string paramName, object paramValue, ParameterDirection paramDirection, DbType paramType)
{
DbParameter param = dbCommand.CreateParameter();
param.Direction = paramDirection;
param.DbType = paramType;
param.ParameterName = paramName;
param.Value = paramValue ?? DBNull.Value;
return param;
}
public static OrmLiteSPStatement usp_JIWA_Debtors_StatementsAsAt(this IDbConnection db, string @sP_StartingDebtorAccountNo = null, string @sP_EndingDebtorAccountNo = null, DateTime? @sP_AsAtDate = null)
{
var dbCmd = (DbCommand)OrmLiteConfig.ExecFilter.CreateCommand(db).ToDbCommand();
// dbCmd.CommandText = "usp_JIWA_Debtors_StatementsAsAt";
dbCmd.CommandText = RESTAPIPlugin.StatementProc;
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(CreateNewParameter(dbCmd,"SP_StartingDebtorAccountNo",@sP_StartingDebtorAccountNo,ParameterDirection.Input,DbType.AnsiString));
dbCmd.Parameters.Add(CreateNewParameter(dbCmd,"SP_EndingDebtorAccountNo",@sP_EndingDebtorAccountNo,ParameterDirection.Input,DbType.AnsiString));
dbCmd.Parameters.Add(CreateNewParameter(dbCmd,"SP_AsAtDate",@sP_AsAtDate,ParameterDirection.Input,DbType.DateTime));
dbCmd.Parameters.Add(CreateNewParameter(dbCmd,"__ReturnValue",0,ParameterDirection.ReturnValue,DbType.Int32));
return new OrmLiteSPStatement(db, dbCmd);
}
public static OrmLiteSPStatement usp_Jiwa_Invoices_Invoice(this IDbConnection db, string @sP_InvoiceHistoryID = null)
{
var dbCmd = (DbCommand)OrmLiteConfig.ExecFilter.CreateCommand(db).ToDbCommand();
//dbCmd.CommandText = "usp_Jiwa_Invoices_Invoice";
dbCmd.CommandText = RESTAPIPlugin.InvoiceProc;
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(CreateNewParameter(dbCmd,"SP_InvoiceHistoryID",@sP_InvoiceHistoryID,ParameterDirection.Input,DbType.String));
dbCmd.Parameters.Add(CreateNewParameter(dbCmd,"__ReturnValue",0,ParameterDirection.ReturnValue,DbType.Int32));
return new OrmLiteSPStatement(db, dbCmd);
}
}
}
Report
CSharp
503e2764-c816-4af3-b684-89acc7b42b7f
JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaApplication.dll
E:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaApplication.dll
77532399-32e4-430a-96b8-c490be8f3670
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
mscorlib.dll
C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll
d1029685-430f-4ac7-b054-44fcebb3db6e
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
80411a13-c06b-47d2-85ab-d777f04580b8
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
73ea5bb9-0b18-4580-9dd5-5f0dc7bd5f79
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
36b45e8e-a940-41d1-b83f-b3c607941186
JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaODBC.dll
E:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaODBC.dll
4bd67c06-4ce9-4ef3-9568-801018dcacc6
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
6e8bbb9c-de8c-4228-99cc-d951dc063812
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
87b4d77c-a9e5-4405-b09f-a826590d11cd
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
e4bcf4e2-afc9-4f92-9eec-048b5d8b8a07
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
a6ed9539-a0c6-4d4f-a03b-9c1ad8b3a694
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
a5ca4d7c-32e6-4515-825a-0bca47bd6dd2
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
491a08c1-565b-4486-8480-6d88caa53af1
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
7ea07c57-4ad3-4320-a72b-342d9c1a54c4
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
56b0af21-e3e0-4a53-b352-479ecd18269f
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
5304e270-a6ff-4755-839f-d95c28d5b8e7
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
ab07dc87-aa3a-4759-becb-c1d6c3516d7c
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
8721b0a0-ba4d-4a95-b83a-60fdb4c01ae6
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
d8a086de-6d76-4b06-93a0-25dae964273a
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
6a3c2838-a19f-4ca1-a0e2-ab6f10026941
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
35122810-e831-406a-a143-45576879881a
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
296a043d-0825-47e1-961f-2e7c5eb4674e
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
14567ac0-9dbd-4124-a763-12bb34ee9d34
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
15d80987-877a-4afc-89cd-1618e2f725b1
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
7bf671c8-15de-41d8-8189-1744d18a5e65
ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587
ServiceStack.dll
E:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.dll
66d90239-533d-43dd-8e05-aa6cbdd6d65c
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
11fd375b-1c6b-4e83-b3c1-8bccffa6a35d
ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0
ZetaHtmlEditControl.dll
E:\Program Files (x86)\Jiwa Financials\Jiwa 7\ZetaHtmlEditControl.dll
4d7920fe-0498-4921-991e-0b6a15cb5f26
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
cf91e7e0-67c4-44bb-84dd-828ffd00fc01
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
e211ad4a-569e-492f-b67a-a8be3bb78d9e
JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaEncryption.dll
E:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaEncryption.dll
b9c3643d-5861-45cf-9fce-f60fd0ccb93b
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
408ce911-ed44-4a9b-8c71-310ec9fa91ae
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
7cb501ac-d1cc-4f72-8b2d-0ca70a5e9608
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
4b853dc5-8d35-4e8f-8e7a-268d435edc45
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
80f8e919-86ad-4e91-99ba-d1945ebf28b2
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
67668a0a-c405-4dc6-be16-ad18f0499b11
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
d793257a-5267-4c60-bd6a-43546f79863c
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
d2f3cdad-1371-45be-b33f-b19e7825527c
JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaLib.dll
E:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaLib.dll
21951da5-f4fc-4cfb-921f-fc97e3e948b3
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
bed5b8b8-f9c8-4e1c-8614-b89d6d47cd59
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
46d72c64-69e0-4c49-8279-43dc222d5930
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
34da9199-42dd-41c3-83ee-56ceaac13cf2
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
c290c0b2-b1d8-42bd-b710-f357c34d524f
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
a3f6c11c-4f2f-47ca-a57c-0710d98a538c
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
081bc8f2-f221-4022-a0ac-c25e3cb9b7d7
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
58505eef-3fd9-4c59-a427-37f74db035df
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
e1f39e59-3dee-49df-bdd6-dddb8547f948
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
643f3260-f9d5-4ade-a022-2e9a223c56bd
ServiceStack.OrmLite.SqlServer, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587
ServiceStack.OrmLite.SqlServer.dll
E:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.OrmLite.SqlServer.dll
67902a2c-e442-4bfc-9198-cd865dbe01d3
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
0c6d8245-c571-403b-a1cf-44876e1a620f
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
7f173096-0dec-40e5-99a9-03780eec6250
JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaServiceModel.dll
E:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaServiceModel.dll
1283637b60734084bb4d
IProc
Stored Procedure for Invoices
1
Lookup
usp_Jiwa_Invoices_Invoice
usp_Jiwa_Invoices_Invoice
e276f9023ce24b04ab26
IRep
Invoice Report
2
Lookup
8ce38d28-d320-4b82-9038-8cf2b1880ca4
8ce38d28-d320-4b82-9038-8cf2b1880ca4
95dc21897dc54dc7b78f
SProc
Stored Procedure for Statements
3
Lookup
usp_JIWA_Debtors_StatementsAsAt
usp_JIWA_Debtors_StatementsAsAt
332edf7b38664b709575
SRep
Statement Report
4
Lookup
843535cf-9d8f-4950-beb0-70d6ed44a527
843535cf-9d8f-4950-beb0-70d6ed44a527
1f038460621f40e09fbf
PDFExport
Allow PDF Export
5
Checkbox
True
True
57a6153ad7504cdba2dc
GExport
Allow General Export to csv and XML
6
Checkbox
True
True
8c364281fae445dcaf90
SExport
Allow Statement Export
7
Checkbox
True
True
9a8e83bd21e04068b870
IExport
Allow Invoice Export
8
Checkbox
True
True
cfd292a8-b28a-46de-a9b1-299a0fce4805
7ddc7010-5098-4aaf-b518-9f93c64065af
REST API
Provides a REST HTTP endpoint with some routes.
Jiwa Financials
false
0