public GLTrasactionHeader CreateHeader(DateTime Initial_Date, string bachType, string Description)
{
var JRNHeader = new GLTrasactionHeader();
//var policyNumber = postingList.FirstOrDefault().CUSTNMBR.Trim();
try
{
JRNHeader.Adjustment_Transaction = 0;
JRNHeader.BACHNUMB = bachType.Trim() + Initial_Date.ToString("yyyyMMdd");
JRNHeader.DATELMTS = 0;
JRNHeader.Ledger_ID = 1;
JRNHeader.NOTETEXT = "";
JRNHeader.PRVDSLMT = 0;
JRNHeader.RATEEXPR = 0;
JRNHeader.RATEVARC = 0;
JRNHeader.REFRENCE = Description.Trim() + " " + Initial_Date.ToString("yyyy-MM-dd");
JRNHeader.RequesterTrx = 0;
JRNHeader.SERIES = 2;
JRNHeader.SQNCLINE = 0;
JRNHeader.TRXDATE = Initial_Date;
//JRNHeader.USERID = "Systemsflex";
return(JRNHeader);
}
catch (Exception)
{
throw;
}
}
public Response CreateJournal(GLTrasactionHeader header, GLTransactionDetail[] detail, string company)
{
Response response;
var gpServices = new GLTransactionClient();
response = gpServices.CreateGLTransaction(header, detail, company);
gpServices.Close();
return(response);
}
public Response TransactionCreate(GLTrasactionHeader Header, GLTransactionDetail[] Detail, string company)
{
Response response;
string transactionXML = string.Empty;
//var server = Properties.Settings.Default.SERVER.ToString();
string server = ConfigKey.ReadSetting("SERVER");
string CNX = "data source=" + server + ";initial catalog=" + company + ";integrated security=SSPI;persist security info=True;packet size=4096";
//string CNX = "data source=stsv-qa15;initial catalog=ELSIN;integrated security=SSPI;persist security info=True;packet size=4096";
var eConnect = new eConnectRequest();
GLTransactionType GLTranType = new GLTransactionType();
var getnext = new GetNextDocNumbers();
//getnext.RequireServiceProxy = false;
try
{
int jrnEntry = Convert.ToInt32(getnext.GetNextGLJournalEntryNumber(IncrementDecrement.Increment, CNX));
GLTranType.taGLTransactionHeaderInsert = SetTransactionValues(Header, jrnEntry);
GLTranType.taGLTransactionLineInsert_Items = SetDetailValues(Detail, jrnEntry);
transactionXML = SerializeGLTransacion(GLTranType);
response = eConnect.CreateGPTransaction(CNX, transactionXML);
return(response);
}
catch (eConnectException ex)
{
response = new Response();
response.SUCCESS = false;
response.MESSAGE = ex.Message;
response.STACK = ex.StackTrace;
if (ex.InnerException != null)
{
response.STACK += ex.InnerException.Message;
}
return(response);
}
catch (Exception ex)
{
response = new Response();
response.SUCCESS = false;
response.MESSAGE = ex.Message;
response.STACK = ex.StackTrace;
if (ex.InnerException != null)
{
response.STACK += ex.InnerException.Message;
}
return(response);
}
finally
{
//getnext.Dispose();
}
}
/// <summary>
///
/// </summary>
/// <param name="Header"></param>
/// <param name="jrnEntry"></param>
/// <returns></returns>
private taGLTransactionHeaderInsert SetTransactionValues(GLTrasactionHeader Header, int jrnEntry)
{
try
{
var glTrasactionInsert = new taGLTransactionHeaderInsert
{
BACHNUMB = Header.BACHNUMB,
JRNENTRY = jrnEntry,
REFRENCE = Header.REFRENCE,
TRXDATE = Header.TRXDATE.ToString("yyyy-MM-dd"),
TRXTYPE = Header.TRXTYPE,
SQNCLINE = Header.SQNCLINE.GetValueOrDefault(),
SERIES = Header.SERIES.GetValueOrDefault(),
CURNCYID = Header.CURNCYID,
XCHGRATE = Header.XCHGRATE.GetValueOrDefault(),
RATETPID = Header.RATETPID,
EXGTBDSC = Header.EXGTBDSC,
EXTBLSRC = Header.EXTBLSRC,
RATEEXPR = Header.RATEEXPR.GetValueOrDefault(),
RATEVARC = Header.RATEVARC.GetValueOrDefault(),
TRXDTDEF = Header.TRXDTDEF.GetValueOrDefault(),
PRVDSLMT = Header.PRVDSLMT.GetValueOrDefault(),
DATELMTS = Header.DATELMTS.GetValueOrDefault(),
RequesterTrx = Header.RequesterTrx.GetValueOrDefault(),
SOURCDOC = Header.SOURCDOC,
Ledger_ID = Header.Ledger_ID.GetValueOrDefault(),
USERID = Header.USERID,
Adjustment_Transaction = Header.Adjustment_Transaction.GetValueOrDefault(),
NOTETEXT = Header.NOTETEXT
};
if (Header.EXPNDATE != null)
{
glTrasactionInsert.EXPNDATE = Header.EXPNDATE.GetValueOrDefault().ToShortDateString();
}
if (Header.EXCHDATE != null)
{
glTrasactionInsert.EXCHDATE = Header.EXCHDATE.GetValueOrDefault().ToShortDateString();
}
return(glTrasactionInsert);
}
catch (Exception)
{
throw;
}
}
/// <summary>
///
/// </summary>
/// <param name="Header"></param>
/// <param name="Detail"></param>
/// <param name="company"></param>
/// <returns></returns>
public Response CreateGLTransaction(GLTrasactionHeader Header, GLTransactionDetail[] Detail, string company)
{
GLTransactionCreate createGLTransaction = new GLTransactionCreate();
return(createGLTransaction.TransactionCreate(Header, Detail, company));
}
