public JsonResult UpdateStatusJurnalTT([FromBody] MaintainStatusJurnalTT model)
{
bool blnResult = false;
string ErrMsg = "";
blnResult = cls.ReksaUpdateStatusJurnalTT(model, out ErrMsg);
ErrMsg = ErrMsg.Replace("ReksaUpdateStatusJurnalTT - Core .Net SqlClient Data Provider\n", "");
return(Json(new { blnResult, ErrMsg }));
}
private bool TransactionTT(string TranBranch, string BillId, DataTable dtDataTT, string strGuid, string strTTGuid, out string strErrorMsg, out string strResult)
{
string StatusTT;
bool bSuccess = true;
strErrorMsg = "";
strResult = "";
StatusTT = dtDataTT.Rows[0]["StatusJurnal"].ToString();
//lakukan jurnal, jika status sudah berhasil/suspect tidak dijurnal ulang
//lakukan jurnal transaksi TT
if ((StatusTT != "1") && (StatusTT != "3"))
{
string strBankRef = dtDataTT.Rows[0]["BankRef"].ToString();
string strClientRef = dtDataTT.Rows[0]["ClientRef"].ToString();
string strValueDate = dtDataTT.Rows[0]["ValueDate"].ToString();
string strRemittingCcy = dtDataTT.Rows[0]["RemittingCcy"].ToString();
decimal dcRemittingAmt = decimal.Parse(dtDataTT.Rows[0]["RemittingAmt"].ToString());
string strDebitAccountCcy = dtDataTT.Rows[0]["DebitAccountCcy"].ToString();
string strDebittingAcctNo = dtDataTT.Rows[0]["DebittingAcctNo"].ToString();
string strApplicantName = dtDataTT.Rows[0]["ApplicantName"].ToString();
string strBeneficiaryName = dtDataTT.Rows[0]["BeneficiaryName"].ToString();
string strBeneAcctNo = dtDataTT.Rows[0]["BeneAcctNo"].ToString();
string strBeneAddr1 = dtDataTT.Rows[0]["BeneAddr1"].ToString();
string strBeneAddr2 = dtDataTT.Rows[0]["BeneAddr2"].ToString();
string strBeneAddr3 = dtDataTT.Rows[0]["BeneAddr3"].ToString();
string strBeneBankSwiftId = dtDataTT.Rows[0]["BeneBankSwiftId"].ToString();
string strBeneBankName = dtDataTT.Rows[0]["BeneBankName"].ToString();
string strBeneBankAddr1 = dtDataTT.Rows[0]["BeneBankAddr1"].ToString();
string strBeneBankAddr2 = dtDataTT.Rows[0]["BeneBankAddr2"].ToString();
string strBeneBankAddr3 = dtDataTT.Rows[0]["BeneBankAddr3"].ToString();
string strIntBankSwiftId = dtDataTT.Rows[0]["IntBankSwiftId"].ToString();
string strIntBankName = dtDataTT.Rows[0]["IntBankName"].ToString();
string strIntBankAddr1 = dtDataTT.Rows[0]["IntBankAddr1"].ToString();
string strIntBankAddr2 = dtDataTT.Rows[0]["IntBankAddr2"].ToString();
string strIntBankAddr3 = dtDataTT.Rows[0]["IntBankAddr3"].ToString();
string strDescription = dtDataTT.Rows[0]["PayDetail1"].ToString() + ' ' + dtDataTT.Rows[0]["PayDetail2"].ToString();
string strSenderRecvInfo1 = dtDataTT.Rows[0]["SenderRecvInfo1"].ToString();
string strSenderRecvInfo2 = dtDataTT.Rows[0]["SenderRecvInfo2"].ToString();
string strSenderRecvInfo3 = dtDataTT.Rows[0]["SenderRecvInfo3"].ToString();
string strDetailsOfCharges = dtDataTT.Rows[0]["DetailsOfCharges"].ToString();
string strOrderingCustAddr1 = dtDataTT.Rows[0]["OrderingCustAddr1"].ToString();
string strOrderingCustAddr2 = dtDataTT.Rows[0]["OrderingCustAddr2"].ToString();
string strOrderingCustAddr3 = dtDataTT.Rows[0]["OrderingCustAddr3"].ToString();
string strSenderRecvInfo4 = dtDataTT.Rows[0]["SenderRecvInfo4"].ToString();
string strSenderRecvInfo5 = dtDataTT.Rows[0]["SenderRecvInfo5"].ToString();
string strSenderRecvInfo6 = dtDataTT.Rows[0]["SenderRecvInfo6"].ToString();
string strResident = dtDataTT.Rows[0]["Resident"].ToString();
string strRemitterCountryOfResidentCode = dtDataTT.Rows[0]["RemitterCountryOfResidentCode"].ToString();
string strRemitterCategory = dtDataTT.Rows[0]["RemitterCategory"].ToString();
string strBeneficiaryCountryOfResidentCode = dtDataTT.Rows[0]["BeneficiaryCountryOfResidentCode"].ToString();
string strBeneficiaryCategory = dtDataTT.Rows[0]["BeneficiaryCategory"].ToString();
string strBeneficiaryAffiliationStatus = dtDataTT.Rows[0]["BeneficiaryAffiliationStatus"].ToString();
string strPaymentPurpose = dtDataTT.Rows[0]["PaymentPurpose"].ToString();
decimal TTBuy = decimal.Parse(dtDataTT.Rows[0]["TTBuy"].ToString());
decimal TTSell = decimal.Parse(dtDataTT.Rows[0]["TTSell"].ToString());
decimal BNBuy = decimal.Parse(dtDataTT.Rows[0]["BNBuy"].ToString());
decimal BNSell = decimal.Parse(dtDataTT.Rows[0]["BNSell"].ToString());
decimal NostroFee = decimal.Parse(dtDataTT.Rows[0]["NostroFee"].ToString());
decimal TaxFee = decimal.Parse(dtDataTT.Rows[0]["TaxFee"].ToString());
decimal FullAmountFee = decimal.Parse(dtDataTT.Rows[0]["FullAmountFee"].ToString());
decimal TransferFee = decimal.Parse(dtDataTT.Rows[0]["TransferFee"].ToString());
decimal ProvFee = decimal.Parse(dtDataTT.Rows[0]["ProvFee"].ToString());
decimal DebittingAmountWithoutFee = decimal.Parse(dtDataTT.Rows[0]["DebittingAmountWithoutFee"].ToString());
string strCIFNumber = dtDataTT.Rows[0]["CIFNumber"].ToString();
string strNostroBICCode = dtDataTT.Rows[0]["NostroBICCode"].ToString();
string strDebittingAccountFee = dtDataTT.Rows[0]["DebittingAccountFee"].ToString();
string strFeeCurrencyCode = dtDataTT.Rows[0]["FeeCurrencyCode"].ToString();
string strLogDesc = "Online Journal TT on authorization - Bill Id : " + BillId.ToString() + " - Debit Account No : " + strDebittingAcctNo + " - Credit Account No : " + strBeneAcctNo;
//Perlu Maintain ke Core Banking
// bSuccess = this._clsCoreBankMessaging.CallTransactionTTOrdering(
//this.ClQ, intNIK
//, strLogDesc, strGuid, strBankRef, strClientRef, strValueDate, strRemittingCcy, dcRemittingAmt
//, strDebitAccountCcy, strDebittingAcctNo, strApplicantName, strBeneficiaryName, strBeneAcctNo
//, strBeneAddr1, strBeneAddr2, strBeneAddr3, strBeneBankSwiftId, strBeneBankName, strBeneBankAddr1
//, strBeneBankAddr2, strBeneBankAddr3, strIntBankSwiftId, strIntBankName, strIntBankAddr1, strIntBankAddr2
//, strIntBankAddr3, strDescription, strSenderRecvInfo1, strSenderRecvInfo2, strSenderRecvInfo3, strDetailsOfCharges
//, strOrderingCustAddr1, strOrderingCustAddr2, strOrderingCustAddr3, strSenderRecvInfo4
//, strSenderRecvInfo5, strSenderRecvInfo6, strResident, strRemitterCountryOfResidentCode
//, strRemitterCategory, strBeneficiaryCountryOfResidentCode, strBeneficiaryCategory
//, strBeneficiaryAffiliationStatus, strPaymentPurpose, TTBuy, TTSell, BNBuy, BNSell, NostroFee
//, TaxFee, FullAmountFee, TransferFee, ProvFee, DebittingAmountWithoutFee, Branch
//, strCIFNumber, strNostroBICCode, strDebittingAccountFee, strFeeCurrencyCode
//, out strResult
//, out strErrorMsg);
if (strErrorMsg != "")
{
bSuccess = false;
}
MaintainStatusJurnalTT model = new MaintainStatusJurnalTT();
int intBillId;
int.TryParse(BillId, out intBillId);
model.BillId = intBillId;
model.TTGuid = strTTGuid;
model.Guid = strGuid;
model.JenisJurnal = "TT";
model.CreditAccount = strBeneAcctNo;
model.CreditCurrency = strRemittingCcy;
model.CreditAmount = dcRemittingAmt;
model.DebitAccount = strDebittingAcctNo;
model.DebitCurrency = strDebitAccountCcy;
model.DebitAmount = DebittingAmountWithoutFee;
model.TTBuy = TTBuy;
model.TTSell = TTSell;
model.BNBuy = BNBuy;
model.BNSell = BNSell;
model.FeeFullAmount = FullAmountFee;
model.FeeCurrency = strFeeCurrencyCode;
model.DebittingAccountFee = strDebittingAccountFee;
model.Status = bSuccess;
model.ErrorMsg = strErrorMsg;
model.TranBranch = TranBranch;
cls.ReksaUpdateStatusJurnalTT(model, out strErrorMsg);
}
return(bSuccess);
}
private bool TransactionGLvsGNC(int NIK, string Branch, string BillId, DataTable dtDataPB, string strGuid, string strTTGuid, out string strErrorMsg)
{
string StatusPB;
bool bSuccess = true;
strErrorMsg = "";
StatusPB = dtDataPB.Rows[0]["StatusJurnal"].ToString();
MaintainStatusJurnalTT model = new MaintainStatusJurnalTT();
//lakukan jurnal, jika status sudah berhasil/suspect tidak dijurnal ulang
//lakukan jurnal GL vs GNC via trancode 7092
if ((StatusPB != "1") && (StatusPB != "3"))
{
string strTransactionBranch = Branch;
string strEffectiveDate = dtDataPB.Rows[0]["EffectiveDate"].ToString();
decimal dcChargeAmount = 0;
decimal dcChargeRate = 0;
string strChargesCurrency = "";
string strBranchCodeDebitting = dtDataPB.Rows[0]["BranchCodeDebitting"].ToString();
string strBranchCodeCreditting = dtDataPB.Rows[0]["BranchCodeCrediting"].ToString();
string strRemark1 = dtDataPB.Rows[0]["Remark1"].ToString();
string strRemark2 = "";
string strRemark3 = "";
string strDealNoCredit = "";
string strDealNoDebit = "";
string strSIBSTranCode = "7092";
string strSupervisorId = NIK.ToString();
string strLogDesc = "Online Journal GL vs GNC on authorization - Bill Id : " + BillId.ToString() + " - Debit Account No : " + model.DebitAccount + " - Credit Account No : " + model.CreditAccount;
int intBillId;
int.TryParse(BillId, out intBillId);
model.BillId = intBillId;
model.TTGuid = strTTGuid;
model.Guid = strGuid;
model.JenisJurnal = "PB";
model.CreditAccount = dtDataPB.Rows[0]["CredittingAccount"].ToString();
model.CreditCurrency = dtDataPB.Rows[0]["CredittingCurrency"].ToString();
model.CreditAmount = decimal.Parse(dtDataPB.Rows[0]["CredittingAmount"].ToString());
model.DebitAccount = dtDataPB.Rows[0]["DebittingAccount"].ToString();
model.DebitCurrency = dtDataPB.Rows[0]["DebittingCurrency"].ToString();
model.DebitAmount = decimal.Parse(dtDataPB.Rows[0]["DebittingAmount"].ToString());
model.TTBuy = decimal.Parse(dtDataPB.Rows[0]["TTBuy"].ToString());
model.TTSell = decimal.Parse(dtDataPB.Rows[0]["TTSell"].ToString());
model.BNBuy = decimal.Parse(dtDataPB.Rows[0]["TTBuy"].ToString());
model.BNSell = decimal.Parse(dtDataPB.Rows[0]["TTSell"].ToString());
model.FeeFullAmount = 0;
model.FeeCurrency = "";
model.DebittingAccountFee = "";
model.Status = bSuccess;
model.ErrorMsg = strErrorMsg;
model.TranBranch = Branch;
//bSuccess = this._clsCoreBankMessaging.TransactionOverbooking7092(
//this.ClQ, NIK
//, strLogDesc, strGuid, strTransactionBranch, strEffectiveDate
//, model.DebitAccount, model.DebitAmount, model.CreditAccount
//, model.CreditAmount, model.TTBuy, model.TTSell
//, dcChargeAmount, dcChargeRate, model.DebitCurrency
//, model.CreditCurrency, strChargesCurrency
//, strBranchCodeDebitting, strBranchCodeCreditting
//, strRemark1, strRemark2, strRemark3, strDealNoCredit
//, strDealNoDebit, strSIBSTranCode, strSupervisorId
//, out strErrorMsg);
if (strErrorMsg != "")
{
bSuccess = false;
}
bSuccess = cls.ReksaUpdateStatusJurnalTT(model, out strErrorMsg);
}
return(bSuccess);
}
