private static void RetrieveCreditCardOutstandingTransactions(string creditCardNo, CreditCardOutstandingTransaction transaction) { try { Params param = new Params() { Parameter = new Dictionary <string, string>() }; param.RequestTransType = "GetUnsettleCreditCardTransactionByCardNo"; param.Parameter.Add("cardNo", creditCardNo); param.WSDL = "CCInquiryUnsettleTransaction"; ESBData data = EAI.RetrieveESBData(param); if (data.Result.Count > 1) { data.Result.RemoveAt(0); // Remove the first record as it contains the keys "cardNo" and "appCode" foreach (StringDictionary entry in data.Result) { transaction.Transactions.Add(new CreditCardTransaction() { CreditCardNo = creditCardNo, EffectiveDate = Formatter.ParseExact(entry[OutstandingCreditCardTransactionResultKeyName.EffectiveDate], "JY"), Description = entry[OutstandingCreditCardTransactionResultKeyName.Description], TransactionType = entry[OutstandingCreditCardTransactionResultKeyName.TransactionType], Source = entry[OutstandingCreditCardTransactionResultKeyName.Source].PadLeft(6, '0'), Days = Formatter.GetParsedNumeric(entry[OutstandingCreditCardTransactionResultKeyName.Days], false), Nominal = Formatter.GetParsedDouble(entry[OutstandingCreditCardTransactionResultKeyName.Nominal], false) }); } } } catch (Exception e) { } }
private void GetSegmentation(string cisno) { Params param = new Params() { Parameter = new Dictionary <string, string>() }; param.RequestTransType = "SearchCustInfoByCIS"; param.WSDL = "CustomerInformationInquiry"; param.Parameter.Add("cisNo", cisno); ESBData data = EAI.RetrieveESBData(param); string customersegmentation = string.Empty; if (data.Result != null) { foreach (StringDictionary entry in data.Result) { customersegmentation = string.IsNullOrEmpty(entry["customersegmentation"]) ? customersegmentation : entry["customersegmentation"]; } } if (!string.IsNullOrEmpty(customersegmentation)) { this.Membership = Utility.GetCustomerSegmentation(customersegmentation, "Membership"); this.Segmentation = Utility.GetCustomerSegmentation(customersegmentation, "Segmentation"); } }
public JsonResult GetAllCreditCardStatus(string _strCreditCards = null) { List <CreditCard> _creditCards = string.IsNullOrEmpty(_strCreditCards) ? new List <CreditCard>() : new JavaScriptSerializer().Deserialize <List <CreditCard> >(_strCreditCards); Params paramListCCbyCardNoCardType = new Params() { Parameter = new Dictionary <string, string>() }; paramListCCbyCardNoCardType.WSDL = "CCInformationDetail"; paramListCCbyCardNoCardType.RequestTransType = "GetCreditCardDetailByCardNoAndCardType"; List <CreditCard> modelCreditCard = new List <CreditCard>(); foreach (var record in _creditCards) { paramListCCbyCardNoCardType.Parameter.Remove("cardNo"); paramListCCbyCardNoCardType.Parameter.Remove("cardType"); paramListCCbyCardNoCardType.Parameter.Add("cardNo", record.CreditCardNumber); paramListCCbyCardNoCardType.Parameter.Add("cardType", record.CCType); ESBData searchResultCCbyCardNoCardType = EAI.RetrieveESBData(paramListCCbyCardNoCardType); if (searchResultCCbyCardNoCardType.Result != null && searchResultCCbyCardNoCardType.Result.Count != 0) { record.Status = Utility.GetStringMap(13, 1, searchResultCCbyCardNoCardType.Result[0][CreditCardInquiryStatusResultKeyName.BlockCode]); } else { record.Status = ""; } modelCreditCard.Add(record); } return(Json(modelCreditCard, JsonRequestBehavior.AllowGet)); }
public ActionResult EmailDelete() { string getType = Request["_type"]; string getNoReferensi = Request["_noReferensi"]; ViewBag.Type = "deleteEmail"; Params paramList = new Params() { Parameter = new Dictionary <string, string>() }; ESBData esbData = new ESBData() { Result = new List <StringDictionary>() }; Object[] data = new Object[1]; JSONResponse jsonResponse = new JSONResponse(); bool checkSpv = false; switch (getType) { case "inbox": checkSpv = RoleNPrivilege.checkEntityButtonByRoleID(new Guid(Session["RoleID"].ToString()), "EmailInbox", "Delete"); break; case "kirimEmail": checkSpv = RoleNPrivilege.checkEntityButtonByRoleID(new Guid(Session["RoleID"].ToString()), "EmailSend", "Delete"); break; } switch (checkSpv) { case true: paramList.RequestTransType = "DeleteEmailByRefNo"; paramList.Parameter.Add("PK_ID", getNoReferensi); paramList.WSDL = "ESBDBDelimiter"; esbData = EAI.RetrieveESBData(paramList); if (esbData != null && esbData.Result.Count != 0) { foreach (StringDictionary kvp in esbData.Result) { if (kvp.ContainsKey("result")) { jsonResponse.Value = new { Message = Resources.Email.EmailDeleteSuccess }; jsonResponse.Response = kvp["result"]; } } } break; } return(Json(jsonResponse)); }
public static BCAByPhoneTransaction BBP(Params request) { BCAByPhoneTransaction transaction = new BCAByPhoneTransaction(); ESBData data = EAI.RetrieveESBData(request); if (data.Result != null && data.Result.Count() > 0) { int idx = 0; foreach (StringDictionary entry in data.Result) { if (idx == 0) { transaction.NextPos = entry["nextPos"]; transaction.PrevPos = entry["prevPos"]; transaction.CurrPos = entry["currPos"]; } else { BBPTRX trx = new BBPTRX(); trx.CustomerID = entry["custidoraccnum"]; trx.TransactionDate = entry["localdate"]; trx.TransactionTime = entry["localtime"]; trx.TransactionDesc = entry["txndesc"]; trx.ResponseCode = entry["respcde"]; transaction.Transactions.Add(trx); } idx++; } } else { transaction.Msg = data.Message; } return(transaction); }
public static CreditCardCurrentTransaction CurrentTransactions(Params request) { CreditCardCurrentTransaction transaction = new CreditCardCurrentTransaction(); try { if (request != null) { if (request.Parameter.ContainsKey("cardNo")) { string cardNo = request.Parameter["cardNo"]; CreditCardInformation information = CreditCardService.RetrieveCreditCardDetail(cardNo, CreditCardService.RetrieveCreditCardType(cardNo)); transaction.CustomerNo = information.CustomerNo; transaction.CreditCards.Add(information); CreditCardCurrentTransaction currentTrx = RetrieveCreditCardCurrentTransactions(cardNo); foreach (CreditCardTransaction trx in currentTrx.Transactions) { transaction.Transactions.Add(trx); } } else if (request.Parameter.ContainsKey("custNo")) { // If a customer has multiple Credit Cards, the "Credit Card Customer No" is still the same for all the credit cards. Params param = new Params() { Parameter = new Dictionary <string, string>() }; param.RequestTransType = "GetAllRelatedCreditCardInOneCustNo"; param.Parameter.Add("custNo", request.Parameter["custNo"]); param.WSDL = "AllRelatedDetail"; ESBData data = EAI.RetrieveESBData(param); transaction.CustomerNo = request.Parameter["custNo"]; if (data.Result != null && data.Result.Count != 0) { // All related credit cards (from the service 'GetAllRelatedCreditCardInOneCustNo') are returned as a set of "cardType", "cardNo", "creditLinePerCard" foreach (StringDictionary entry in data.Result) { CreditCardInformation information = CreditCardService.RetrieveCreditCardDetail(entry["cardNo"], entry["cardType"]); transaction.CreditCards.Add(information); CreditCardCurrentTransaction currentTrx = RetrieveCreditCardCurrentTransactions(entry["cardNo"]); foreach (CreditCardTransaction trx in currentTrx.Transactions) { transaction.Transactions.Add(trx); } } } } } } catch (Exception e) { } return(transaction); }
private static CreditCardHistoricalTransaction RetrieveCreditCardHistoricalTransactions(string creditCardNo, string statementDate) { CreditCardHistoricalTransaction transaction = new CreditCardHistoricalTransaction(); try { Params param = new Params() { Parameter = new Dictionary <string, string>() }; param.RequestTransType = "GetHistoryCreditCardTransactionOnStateDate"; param.Parameter.Add("cardNo", creditCardNo); param.Parameter.Add("stateDate", statementDate); param.WSDL = "CCBillingStatementByStatementDate"; ESBData data = EAI.RetrieveESBData(param); if (data.Result.Count > 1) { int counter = 0; if (data.Result.Count > 0) { // The first record contains the keys "nbrDetail","length","appCode","card" int.TryParse(data.Result[0]["nbrDetail"], out counter); } for (int i = 1; i <= counter; i++) { StringDictionary eachTransaction = data.Result[i]; //if ("INTEREST".Equals(eachTransaction["desc"]) && Formatter.GetParsedDouble(eachTransaction["amount"], false) == 0.00) // continue; transaction.Transactions.Add(new CreditCardTransaction() { CreditCardNo = creditCardNo, TransactionDate = Formatter.ParseExact(eachTransaction["postDate"], "JY"), Description = eachTransaction["desc"], TransactionCode = eachTransaction["txnCode"], ReferenceNumber = string.IsNullOrEmpty(eachTransaction["refNmbr"]) ? string.Empty : eachTransaction["refNmbr"].PadLeft(11, '0'), Amount = Formatter.GetParsedDouble(eachTransaction["amount"], false), PreviousBalance = Formatter.GetParsedDouble(eachTransaction["prevBal"], false), }); } } } catch (Exception e) { } return(transaction); }
public static SMSTopUpTransaction SMSTopUp(Params request) { SMSTopUpTransaction transaction = new SMSTopUpTransaction(); Params param = new Params() { Parameter = new Dictionary <string, string>() }; try { param.RequestTransType = "GetTopUpTransactionByMobileNo"; param.Parameter.Add("FK_CustID", request.Parameter.ContainsKey("mobileNo") ? request.Parameter["mobileNo"].Trim() : string.Empty); param.Parameter.Add("StartDate", Formatter.ToStringExact(Convert.ToDateTime(request.Parameter["startDate"]), "MM/dd/yyyy")); param.Parameter.Add("EndDate", Formatter.ToStringExact(Convert.ToDateTime(request.Parameter["endDate"]).AddDays(1), "MM/dd/yyyy")); param.WSDL = "ESBDBDelimiter"; ESBData data = EAI.RetrieveESBData(param); if (data.Result != null && data.Result.Count > 0) { foreach (StringDictionary entry in data.Result) { SMSTopUpTRX trx = new SMSTopUpTRX(); DateTime? TransactionDate = Formatter.ParseExact(entry["createddate"], "MM/dd/yyyy hh:mm:ss tt"); trx.TransactionDate = TransactionDate; trx.RequestId = entry["billerid"]; trx.AtmCardNumber = entry["cardnumber"]; trx.AccountNumber = entry["acctidfrom"]; trx.ValueOfTransactions = Formatter.GetParsedNumeric(entry["amt"], false); trx.ResponseCode = Utility.GetDisplayText("TransactionAttributeMapping", "SMS Top Up", "Response Code", entry["srvrstatuscode"]); transaction.Transactions.Add(trx); } param.Parameter = new Dictionary <string, string>(); param.RequestTransType = "GetTopUpInfoByMobileNo"; param.Parameter.Add("CustId", request.Parameter.ContainsKey("mobileNo") ? request.Parameter["mobileNo"].Trim() : string.Empty); param.WSDL = "ESBDBDelimiter"; ESBData information = EAI.RetrieveESBData(param); if (information.Result != null && information.Result.Count > 0) { transaction.ATMCardNumber = information.Result[0]["cardnumber"]; transaction.ATMCardHolderName = information.Result[0]["custname"]; transaction.Status = Utility.GetStatusInfo(information.Result[0]["status"]); } } } catch (Exception e) { } return(transaction); }
public static CreditCardOutstandingTransaction OutstandingTransactions(Params request) { CreditCardOutstandingTransaction transaction = new CreditCardOutstandingTransaction(); try { if (request.Parameter.ContainsKey("cardNo")) { string cardNo = request.Parameter["cardNo"]; CreditCardInformation information = CreditCardService.RetrieveCreditCardDetail(cardNo, CreditCardService.RetrieveCreditCardType(cardNo)); transaction.CustomerNo = information.CustomerNo; transaction.CreditCards.Add(information); RetrieveCreditCardOutstandingTransactions(cardNo, transaction); } else if (request.Parameter.ContainsKey("custNo")) { Params param = new Params() { Parameter = new Dictionary <string, string>() }; param.RequestTransType = "GetAllRelatedCreditCardInOneCustNo"; param.Parameter.Add("custNo", request.Parameter["custNo"]); param.WSDL = "AllRelatedDetail"; ESBData cardData = EAI.RetrieveESBData(param); transaction.CustomerNo = request.Parameter["custNo"]; if (cardData.Result != null && cardData.Result.Count != 0) { foreach (StringDictionary entry in cardData.Result) { string cardno = entry["cardNo"]; if (!string.IsNullOrEmpty(cardno)) { CreditCardInformation information = CreditCardService.RetrieveCreditCardDetail(cardno, entry["cardType"]); transaction.CreditCards.Add(information); RetrieveCreditCardOutstandingTransactions(cardno, transaction); } } } } } catch (Exception e) { } return(transaction); }
private static CreditCardCurrentTransaction RetrieveCreditCardCurrentTransactions(string cardNo) { CreditCardCurrentTransaction transaction = new CreditCardCurrentTransaction(); try { Params param = new Params() { Parameter = new Dictionary <string, string>() }; param.RequestTransType = "GetCurrentCreditCardTransactionByCardNo"; param.Parameter.Add("cardNo", cardNo); param.WSDL = "CCInquiryTransactionDetail"; ESBData data = EAI.RetrieveESBData(param); if (data.Result.Count > 1) { data.Result.RemoveAt(0); // Remove the first record as it contains the keys "card", "number" and "appCode" foreach (StringDictionary entry in data.Result) { transaction.Transactions.Add(new CreditCardTransaction() { CreditCardNo = cardNo, PostingDate = Formatter.ParseExact(entry[CurrentCreditCardTransactionResultKeyName.PostingDate], "JY"), TransactionDate = Formatter.ParseExact(entry[CurrentCreditCardTransactionResultKeyName.TransactionDate], "JY"), Description = entry[CurrentCreditCardTransactionResultKeyName.Description], TransactionCode = entry[CurrentCreditCardTransactionResultKeyName.TransactionCode], MerchantCode = entry[CurrentCreditCardTransactionResultKeyName.MerchantCode], ReferenceNumber = entry[CurrentCreditCardTransactionResultKeyName.ReferenceNumber], Amount = Formatter.GetParsedDouble(entry[CurrentCreditCardTransactionResultKeyName.Amount], false) }); } } } catch (Exception e) { } return(transaction); }
public static List <DebitTransaction> Debit(Params request) { List <DebitTransaction> ResultList = new List <DebitTransaction>(); Params param = new Params() { Parameter = new Dictionary <string, string>() }; param.Parameter.Add("NUM", request.Parameter.ContainsKey("atmNo") ? request.Parameter["atmNo"].Trim() : string.Empty); param.Parameter.Add("StartDate", request.Parameter.ContainsKey("startDate") ? request.Parameter["startDate"].Trim() : string.Empty); param.Parameter.Add("EndDate", request.Parameter.ContainsKey("endDate") ? request.Parameter["endDate"].Trim() : string.Empty); param.Parameter.Add("CRD_LN", request.Parameter.ContainsKey("lnet") ? request.Parameter["lnet"].Trim() : string.Empty); param.Parameter.Add("CRD_FIID", request.Parameter.ContainsKey("fiid") ? request.Parameter["fiid"].Trim() : string.Empty); if (request.Parameter.ContainsKey("terminalId")) { param.RequestTransType = "GetDebitTransactionByATMNoWithTerminalID"; param.Parameter.Add("TERM_ID", request.Parameter["terminalId"].Trim().ToUpper()); } else { param.RequestTransType = "GetDebitTransactionByATMNo"; } param.WSDL = "ESBDBDelimiter"; try { ESBData data = EAI.RetrieveESBData(param); if (data.Result != null && data.Result.Count > 0) { int counter = 0; DebitTransaction record = null; foreach (var entry in data.Result) { record = new DebitTransaction(); DateTime?transactDate = Formatter.ParseExact(entry["tran_dat"], "yyyy-MM-dd HH:mm:ss"); DateTime?transactTime = Formatter.ParseExact(entry["tran_dat"], "yyyy-MM-dd HH:mm:ss"); double amountJumlah = 0; double.TryParse(entry["amt_1"], out amountJumlah); amountJumlah = amountJumlah / 100; double cashJumlahTunai = 0; double.TryParse(entry["amt_2"], out cashJumlahTunai); cashJumlahTunai = cashJumlahTunai / 100; counter++; record.Number = counter.ToString(); record.TransactionCode = entry["transcode"]; //record.TransactionDate = transactDate.ToString(); //record.TransactionTime = transactTime.ToString(); record.TransactionDate = entry["tran_dat"]; record.TransactionTime = entry["tran_dat"].Substring(11, 8); record.Amount = amountJumlah.ToString(); record.ResponseCode = entry["resp_cde"]; record.ApprovalCode = entry["apprv_cde"]; record.AtmCardNo = request.Parameter["atmNo"].Trim(); record.TerminalId = entry["term_term_id"]; record.CashAmount = cashJumlahTunai.ToString(); record.AccountNumber = entry["acct_num"]; record.Retailer = entry["retailer_id"]; record.TraceNo = entry["invoice_num"]; record.Batch = entry["batch_num"]; record.SequenceNo = entry["seq_num"]; record.CardType = entry["crd_typ"]; ResultList.Add(record); } } } catch (Exception e) { } return(ResultList); }
public static KBITransaction KBI(Params request) { KBITransaction transaction = new KBITransaction(); ESBData data = null; Params param = new Params() { Parameter = new Dictionary <string, string>() }; try { ESBData information = null; if (!(string.IsNullOrEmpty(request.RequestTransType)) && !("GetCreditCardLogIBankByUserId".Equals(request.RequestTransType))) { if (request.Parameter.ContainsKey("userId")) { param.RequestTransType = "GetIBankInfoByUserId"; param.Parameter.Add("CustId", request.Parameter["userId"]); param.WSDL = "ESBDBDelimiter"; information = EAI.RetrieveESBData(param); } if (request.Parameter.ContainsKey("atmNo")) { param.RequestTransType = "GetIBankInfoByATMNo"; param.Parameter.Add("CardNumber", request.Parameter["atmNo"]); param.WSDL = "ESBDBDelimiter"; information = EAI.RetrieveESBData(param); } if (information.Result.Count > 0 && !string.IsNullOrEmpty(information.Result[0]["custid"])) { transaction.UserId = information.Result[0]["custid"]; transaction.CardNumber = information.Result[0]["cardnumber"]; transaction.CustomerName = information.Result[0]["firstname"]; } } else if ("GetCreditCardLogIBankByUserId".Equals(request.RequestTransType)) { if (request.Parameter.ContainsKey("userId")) { param.RequestTransType = "GetCardNoByUserIdIBank"; param.Parameter.Add("KeyId", request.Parameter["userId"]); param.Parameter.Add("No_Kartu", string.Empty); param.Parameter.Add("No_Rekening", string.Empty); param.Parameter.Add("NewStatus", "AKT"); param.WSDL = "ESBDBDelimiter"; information = EAI.RetrieveESBData(param); transaction.UserId = request.Parameter["userId"]; transaction.CardNumber = information.Result[0]["no_kartu"]; transaction.CustomerName = information.Result[0]["firstname"]; } else if (request.Parameter.ContainsKey("atmNo")) { param.RequestTransType = "GetUserIdIBankByCardNo"; param.Parameter.Add("KeyId", string.Empty); param.Parameter.Add("No_Kartu", request.Parameter["atmNo"]); param.Parameter.Add("No_Rekening", string.Empty); param.Parameter.Add("NewStatus", "AKT"); param.WSDL = "ESBDBDelimiter"; information = EAI.RetrieveESBData(param); transaction.UserId = information.Result[0]["keyid"]; transaction.CardNumber = request.Parameter["atmNo"]; transaction.CustomerName = information.Result[0]["firstname"]; } } param.Parameter = new Dictionary <string, string>(); param.RequestTransType = request.RequestTransType; param.Parameter.Add("FK_CustID", transaction.UserId); switch (param.RequestTransType) { // ORAIBSELECTLOGTXNPAYMENTPURCHASEBYCUSTID case "GetIBTransactionByUserIdPayment": param.Parameter.Add("TxType", "PmtAddRq"); break; case "GetIBTransactionByUserIdPaymentECommerce": param.Parameter.Add("TxType", "EComAddRq"); break; case "GetIBTransactionByUserIdVirtualAcct": param.Parameter.Add("TxType", "XFerAddRq4"); break; case "GetIBTransactionByUserIdPurchase": param.Parameter.Add("TxType", "PchAddRq"); break; case "GetIBTransactionByUserIdTopUpWallet": param.Parameter.Add("TxType", "XFerAddRq5"); break; // ORAIBSELECTTXNHISTORYBYCUSTID case "GetIBTransactionByUserIdAcctInfo": param.Parameter.Add("Process1", "BalInqRq"); param.Parameter.Add("Process2", "DeptAcctStmtInqRq"); param.Parameter.Add("Process3", "InvInqRq"); param.Parameter.Add("Process4", "InvAcctStmtInqRq"); param.Parameter.Add("Process5", "InvAcctStmtInqRq2"); break; case "GetIBTransactionByUserIdConsumerCreditInfo": param.Parameter.Add("Process1", "LOANINQRQ"); param.Parameter.Add("Process2", "LOANHISTINQRQ"); param.Parameter.Add("Process3", ""); param.Parameter.Add("Process4", ""); param.Parameter.Add("Process5", ""); break; case "GetIBTransactionByUserIdInvesProductInfo": param.Parameter.Add("Process1", "REKSAINQRQ"); param.Parameter.Add("Process2", "REKSAINQRQ"); param.Parameter.Add("Process3", ""); param.Parameter.Add("Process4", ""); param.Parameter.Add("Process5", ""); break; case "GetCreditCardLogIBankByUserId": param.Parameter.Add("Process1", "REGBCACC"); param.Parameter.Add("Process2", "DELBCACC"); param.Parameter.Add("Process3", "CCSTMTINQRQ"); param.Parameter.Add("Process4", ""); param.Parameter.Add("Process5", ""); break; // ORAIBSELECTLOGTXNTRANSFERBYCUSTID case "GetIBTransactionByUserIdTransferBCA": param.Parameter.Add("TxType1", "XFerAddRq2"); param.Parameter.Add("TxType2", "XFerAddRq3"); param.Parameter.Add("EffDt1", "0"); param.Parameter.Add("EffDt2", "1"); param.Parameter.Add("EffDt3", ""); break; case "GetIBTransactionByUserIdTransferDomestic": param.Parameter.Add("TxType1", "XFerAddRq3"); param.Parameter.Add("TxType2", ""); param.Parameter.Add("EffDt1", "1"); param.Parameter.Add("EffDt2", ""); param.Parameter.Add("EffDt3", ""); break; case "GetIBTransactionByUserIdAKSesFundWithdrawal": param.Parameter.Add("TxType1", "FundWdrwRq"); param.Parameter.Add("TxType2", ""); param.Parameter.Add("EffDt1", "0"); param.Parameter.Add("EffDt2", ""); param.Parameter.Add("EffDt3", ""); break; // ORAIBSELECTTRANSFERTUNDABYCUSTIDANDTXTDATE case "GetIBTransactionByUserIdTransferBCAInputStatus": param.Parameter.Add("TxType", "XFerAddRq3"); param.Parameter.Add("Is_Domestic", "0"); break; case "GetIBTransactionByUserIdTransferDomesticInputStatus": param.Parameter.Add("TxType", "XFerAddRq3"); param.Parameter.Add("Is_Domestic", "1"); break; // ORAIBSELECTTRANSFERTUNDABYCUSTIDANDPROCESSDATE case "GetIBTransactionByUserIdTransferBCATxnStatus": param.Parameter.Add("TxType", "XFerAddRq3"); param.Parameter.Add("Is_Domestic", "0"); break; case "GetIBTransactionByUserIdTransferDomesticTxnStatus": param.Parameter.Add("TxType", "XFerAddRq3"); param.Parameter.Add("Is_Domestic", "1"); break; // ORAIBSELECTTRANSFERTOLAKBYCUSTIDANDTXNDATE case "GetIBTransactionByUserIdRejected": break; } param.Parameter.Add("StartDate", Formatter.ToStringExact(Convert.ToDateTime(request.Parameter["startDate"]), "MM/dd/yyyy")); param.Parameter.Add("EndDate", Formatter.ToStringExact(Convert.ToDateTime(request.Parameter["endDate"]).AddDays(1), "MM/dd/yyyy")); // ORAIBSELECTUSERSESSIONLOGBYCUSTID if ("GetIBTransactionByUserIdUserSession".Equals(param.RequestTransType)) { param.Parameter.Add("ChgFlag", ""); } param.WSDL = "ESBDBDelimiter"; data = EAI.RetrieveESBData(param); if (data.Result != null && data.Result.Count > 0) { KBITRX trx = null; foreach (StringDictionary entry in data.Result) { trx = new KBITRX(); string tandemStatusCode = string.Empty; string mdlwrStatusCode = string.Empty; switch (param.RequestTransType) { // ORAIBSELECTLOGTXNPAYMENTPURCHASEBYCUSTID case "GetIBTransactionByUserIdPayment": tandemStatusCode = entry["srvrstatuscode"]; DateTime?tandemDate = (tandemStatusCode == "0" || tandemStatusCode == "00" || tandemStatusCode == "97") ? Formatter.ParseExact(entry["tandemtxdate"], "ddMMyyHHmm") : Formatter.ParseExact(entry["tandemtxdate"], "MMddyyHHmm"); trx.MiddlewareDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); trx.TandemDate = tandemDate; trx.PaymentAccountNumber = entry["acctidfrom"]; trx.CustomerNumber = entry["billrefinfo"]; trx.Nominal = Formatter.GetParsedDouble(entry["amt"], false); trx.MiddlewareStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Middleware Status", entry["statuscode"]); trx.TandemStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Tandem Status", entry["srvrstatuscode"]); trx.TokenStatus = entry["flagtoken"]; trx.ReferenceNumber = entry["rqUID"]; trx.PaymentFor = entry["desceng"]; break; case "GetIBTransactionByUserIdPaymentECommerce": trx.MiddlewareDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); trx.TandemDate = Formatter.ParseExact(entry["tandemtxdate"], "ddMMyyHHmm"); trx.PaymentAccountNumber = entry["acctidfrom"]; trx.CustomerNumber = entry["billrefinfo"]; trx.Amount = Formatter.GetParsedDouble(entry["amt"], false); trx.MiddlewareStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Middleware Status", entry["statuscode"]); trx.TandemStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Tandem Status", entry["srvrstatuscode"]); trx.TokenStatus = entry["flagtoken"]; trx.ReferenceNumber = entry["rquid"]; trx.PaymentFor = entry["desceng"]; break; case "GetIBTransactionByUserIdVirtualAcct": double?forex = Formatter.GetParsedDouble(entry["currforex"], false); double forexValue = 0; if (forex.HasValue) { forexValue = forex.Value / 100; } trx.TransferDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); trx.InputDate = Formatter.ParseExact(entry["lateamt"], "yyyy-MM-dd H:mm:ss"); trx.TransactionType = entry["authidresponse"]; trx.SenderAccountNo = entry["acctidfrom"]; trx.TransferToAccount = entry["acctidto"]; trx.TransferToAccountName = entry["acctidtoname"]; trx.Currency = Utility.GetCurrency(entry["curr"]); trx.LateChargeAmount = entry["latechargeamt"]; trx.TransferAmount = Formatter.GetParsedDouble(entry["amt"], false); trx.Forex = forexValue; trx.AmountIDR = Formatter.GetParsedDouble(entry["amtidr"], false); trx.ToAccountType = Utility.GetCurrency(entry["accttypeto"]); trx.SendToSubject = entry["sendtosubject"]; trx.Status = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Middleware Status", entry["statuscode"]); trx.Reason = entry["errormessage"]; trx.Reference = entry["rquid"]; break; case "GetIBTransactionByUserIdPurchase": tandemStatusCode = entry["srvrStatusCode"]; trx.MiddlewareDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); trx.TandemDate = (tandemStatusCode == "0" || tandemStatusCode == "00" || tandemStatusCode == "97") ? Formatter.ParseExact(entry["tandemtxdate"], "ddMMyyHHmm") : Formatter.ParseExact(entry["tandemtxdate"], "MMddyyHHmm"); trx.AccountPaymentNumber = entry["acctidfrom"]; trx.PaymentFor = entry["desceng"]; trx.Nominal = Formatter.GetParsedDouble(entry["amt"], false); trx.MiddlewareStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Middleware Status", entry["statuscode"]); trx.TandemStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Tandem Status", entry["srvrstatuscode"]); trx.Token = entry["flagtoken"]; trx.ReferenceNumber = entry["rquid"]; break; case "GetIBTransactionByUserIdTopUpWallet": trx.TransactionDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); trx.FromAccountNumber = entry["acctidfrom"]; trx.ToAccountNoHp = entry["acctidto"]; trx.TransactionType = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Information Type", entry["txtype"]); trx.Amount = Formatter.GetParsedDouble(entry["amt"], false); trx.MiddlewareStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Middleware Status", entry["statuscode"]); trx.TandemStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Tandem Status", entry["srvrstatuscode"]); trx.FlagToken = entry["flagtoken"]; trx.ReferenceNumber = entry["rquid"]; trx.ToAccountName = entry["acctidtoname"]; trx.Currency = Utility.GetCurrency(entry["curr"]); trx.Description = entry["errormessage"]; break; // ORAIBSELECTTXNHISTORYBYCUSTID case "GetIBTransactionByUserIdAcctInfo": trx.MiddlewareDate = Formatter.ParseExact(entry["createddate"], "MM/dd/yyyy hh:mm:ss tt"); trx.InformationType = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Information Type", entry["process"]); trx.AccountNumber = entry["acctidfrom"]; trx.MiddlewareStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Middleware Status", entry["statuscode"]); trx.TandemStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Tandem Status", entry["srvrstatuscode"]); trx.ReferenceNumber = entry["rquid"]; break; case "GetIBTransactionByUserIdConsumerCreditInfo": trx.MiddlewareDate = Formatter.ParseExact(entry["createddate"], "MM/dd/yyyy hh:mm:ss tt"); trx.InformationType = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Information Type", entry["process"]); trx.AccountNumber = entry["acctidfrom"]; trx.MiddlewareStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Middleware Status", entry["statuscode"]); trx.TandemStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Tandem Status", entry["srvrstatuscode"]); trx.ReferenceNumber = entry["rquid"]; break; case "GetIBTransactionByUserIdInvesProductInfo": trx.MiddlewareDate = Formatter.ParseExact(entry["createddate"], "MM/dd/yyyy hh:mm:ss tt"); trx.InformationType = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Information Type", entry["process"]); trx.AccountNumber = entry["acctidfrom"]; trx.MiddlewareStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Middleware Status", entry["statuscode"]); trx.TandemStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Tandem Status", entry["srvrstatuscode"]); trx.ReferenceNumber = entry["rquid"]; break; case "GetCreditCardLogIBankByUserId": DateTime?middlewareDate = Formatter.ParseExact(entry["createddate"], "MM/dd/yyyy hh:mm:ss tt"); trx.MiddlewareDate = middlewareDate; trx.Process = Utility.GetDisplayText("TransactionAttributeMapping", "Kartu Kredit", "Transaction Type", entry["process"]); trx.FromAccountId = Formatter.GetParsedNumericLong(entry["acctidfrom"], false); trx.MiddlewareStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Middleware Status", entry["statuscode"]); trx.ReferenceNo = entry["rquid"]; break; // ORAIBSELECTLOGTXNTRANSFERBYCUSTID case "GetIBTransactionByUserIdTransferBCA": double?exchangeRate = Formatter.GetParsedDouble(entry["currforex"], false); if (exchangeRate.HasValue) { exchangeRate = exchangeRate.Value / 100; } trx.TransferDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); trx.InputDate = Formatter.ParseExact(entry["lateamt"], "yyyy-MM-dd HH:mm:ss"); trx.TransferType = entry["authidresponse"]; trx.FromAccountNumber = entry["acctidfrom"]; trx.ToAccountNumber = entry["acctidto"]; trx.ToAccountName = entry["acctidtoname"]; trx.MUTransaction = Utility.GetCurrency(entry["curr"]); trx.LateChargeAmount = entry["latechargeamt"]; trx.TransferNominal = Formatter.GetParsedDouble(entry["amt"], false); trx.ExchangeRate = exchangeRate; trx.ConversiNominal = Formatter.GetParsedDouble(entry["amtidr"], false); trx.MUFromAccountNumber = Utility.GetCurrency(entry["accttypeto"]); trx.News = entry["sendtosubject"]; trx.Status = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Middleware Status", entry["statuscode"]); trx.Cause = entry["errdesc"]; trx.ReferenceNumber = entry["rquid"]; break; case "GetIBTransactionByUserIdTransferDomestic": trx.InputDate = Formatter.ParseExact(entry["lateamt"], "yyyy-MM-dd HH:mm:ss"); trx.TransferDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); trx.TransferType = entry["authidresponse"]; trx.FromAccountNumber = entry["acctidfrom"]; trx.ToAccountNumber = entry["acctidto"]; trx.ToAccountName = entry["acctidtoname"]; trx.City = entry["dccustaddress"]; trx.Bank = entry["dcmerchantname"]; trx.Branch = entry["custname"]; trx.Citizen = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Citizen", entry["custstatus"]); trx.WNI = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "WNI", entry["custbranch"]); trx.Currency = Utility.GetCurrency(entry["curr"]); trx.TransferNominal = Formatter.GetParsedDouble(entry["amt"], false); trx.Cost = Formatter.GetParsedDouble(entry["feeamt"], false); trx.News = entry["sendtosubject"]; trx.TransferService = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Transfer Service", entry["feecur"]); trx.Status = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Middleware Status", entry["statuscode"]); trx.Reason = entry["errdesc"]; trx.ReferenceNumber = entry["rquid"]; break; case "GetIBTransactionByUserIdAKSesFundWithdrawal": trx.TransactionDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); trx.FromAccountNumber = entry["acctidfrom"]; trx.UserId = transaction.UserId; trx.CustomerName = entry["custname"]; trx.Email = entry["sendtoaddr"]; trx.TransactionType = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Information Type", entry["txtype"]); trx.BillerId = entry["billerid"]; trx.BillerRefInfo = entry["billrefinfo"]; trx.Currency = Utility.GetCurrency(entry["curr"]); trx.Amount = Formatter.GetParsedDouble(entry["amt"], false); trx.Reason = entry["errdesc"]; trx.ReferenceNumber = entry["rquid"]; trx.MiddlewareStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Middleware Status", entry["statuscode"]); trx.TandemStatus = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "KlikBCA Individual", "Tandem Status", entry["srvrstatuscode"]); break; // ORAIBSELECTTRANSFERTUNDABYCUSTIDANDTXTDATE case "GetIBTransactionByUserIdTransferBCAInputStatus": trx.InputDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); trx.TransferDate = Formatter.ParseExact(entry["xfer_process_dt"], "MM/dd/yyyy hh:mm:ss tt"); trx.TransferType = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Transfer Type", entry["xfer_type"]); trx.Periodic = entry["xfer_desc"]; trx.ExpiredDate = Formatter.ParseExact(entry["xfer_expire_dt"], "MM/dd/yyyy hh:mm:ss tt"); trx.AccountSendersNumber = entry["acctidfrom"]; trx.ToAccountNumber = entry["acctidto"]; trx.ToAccountName = entry["acctidtoname"]; trx.Currency = Utility.GetCurrency(entry["curr"]); trx.TransferNominal = Formatter.GetParsedDouble(entry["amt"], false); trx.News = entry["sendToSubject"]; trx.Status = entry["xfer_status"]; break; case "GetIBTransactionByUserIdTransferDomesticInputStatus": trx.InputDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); trx.TransferDate = Formatter.ParseExact(entry["xfer_process_dt"], "MM/dd/yyyy hh:mm:ss tt"); trx.TransferType = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Transfer Type", entry["xfer_type"]); trx.FromAccountNumber = entry["acctidfrom"]; trx.ToAccountNumber = entry["acctidto"]; trx.ToAccountName = entry["acctidtoname"]; trx.City = entry["bank_city"]; trx.Branch = entry["bank_br_nm"]; trx.Bank = entry["bank_nm"]; trx.Citizen = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Citizen", entry["status_pend"]); trx.WNI = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "WNI", entry["status_wn"]); trx.Currency = Utility.GetCurrency(entry["curr"]); trx.NominalTransfers = Formatter.GetParsedDouble(entry["amt"], false); trx.Fee = Formatter.GetParsedDouble(entry["fee_amt"], false); trx.News = entry["sendtosubject"]; trx.ServiceTransfer = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Transfer Service", entry["is_llg"]); trx.Status = entry["xfer_status"]; break; // ORAIBSELECTTRANSFERTUNDABYCUSTIDANDPROCESSDATE case "GetIBTransactionByUserIdTransferBCATxnStatus": trx.InputDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); trx.TransferDate = Formatter.ParseExact(entry["xfer_process_dt"], "MM/dd/yyyy hh:mm:ss tt"); trx.TransferType = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Transfer Type", entry["xfer_type"]); trx.Periodic = entry["xfer_desc"]; //trx.ExpiredDate = Formatter.ParseExact(entry["xfer_expire_dt"], "yyyy-MM-dd hh:mm:ss tt"); string[] xdate = entry["xfer_expire_dt"].Split(' '); string[] dtx = xdate[0].Split('-'); string expired_dt = dtx[1] + "/" + dtx[2] + "/" + dtx[0] + " " + "12:00:00 PM"; trx.ExpiredDate = Formatter.ParseExact(expired_dt, "MM/dd/yyyy hh:mm:ss tt"); trx.AccountSendersNumber = entry["acctidfrom"]; trx.ToAccountNumber = entry["acctidto"]; trx.ToAccountName = entry["acctidtoname"]; trx.Currency = Utility.GetCurrency(entry["curr"]); trx.TransferNominal = Formatter.GetParsedDouble(entry["amt"], false); trx.News = entry["sendtosubject"]; trx.Status = entry["xfer_status"]; break; case "GetIBTransactionByUserIdTransferDomesticTxnStatus": trx.InputDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); trx.TransferDate = Formatter.ParseExact(entry["xfer_expire_dt"], "yyyy-MM-dd H:mm:ss"); trx.TransferType = entry["xfer_type"]; trx.FromAccountNumber = entry["acctidfrom"]; trx.ToAccountNumber = entry["acctidto"]; trx.ToAccountName = entry["acctidtoname"]; trx.City = entry["bank_city"]; trx.Bank = entry["bank_nm"]; trx.Branch = entry["bank_br_nm"]; trx.Citizen = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Citizen", entry["status_pend"]); trx.WNI = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "WNI", entry["status_wn"]); trx.Currency = Utility.GetCurrency(entry["curr"]); trx.NominalTransfers = Formatter.GetParsedDouble(entry["amt"], false); trx.Fee = Formatter.GetParsedDouble(entry["fee_amt"], false); trx.News = entry["sendtosubject"]; trx.ServiceTransfer = Utility.GetDisplayText("TransactionAttributeMapping", "KlikBCA Individual", "Transfer Service", entry["is_llg"]); trx.Status = entry["xfer_status"]; break; // ORAIBSELECTTRANSFERTOLAKBYCUSTIDANDTXNDATE case "GetIBTransactionByUserIdRejected": trx.InputDate = Formatter.ParseExact(entry["xfer_posting_dt"], "MM/dd/yyyy hh:mm:ss t"); trx.TransferDate = Formatter.ParseExact(entry["tanggal_transaksi"], "MM/dd/yyyy hh:mm:ss tt"); trx.PPUNumber = entry["nomor_ppu"]; trx.FromAccountNumber = entry["nomor_rek_pengirim"]; trx.ToAccountNumber = entry["nomor_rek_penerima"]; trx.ToAccountName = entry["nama_penerima"]; trx.City = entry["bank_city"]; trx.Bank = entry["bank_name"]; trx.NominalTransfers = Formatter.GetParsedDouble(entry["nominal"], false); trx.Reason = entry["alasan_penolakan"]; break; // ORAIBSELECTUSERSESSIONLOGBYCUSTID case "GetIBTransactionByUserIdUserSession": DateTime?createdDate = Formatter.ParseExact(entry["created_date"], "MM/dd/yyyy hh:mm:ss tt"); DateTime?signOnDate = Formatter.ParseExact(entry["signon_time"], "MM/dd/yyyy hh:mm:ss tt"); DateTime?signOffDate = Formatter.ParseExact(entry["signoff_time"], "MM/dd/yyyy hh:mm:ss tt"); trx.Number = entry["pk_id"]; trx.TransactionDate = createdDate; trx.SignOnDate = signOnDate; trx.SignOffDate = signOffDate; break; } transaction.Transactions.Add(trx); } } } catch (Exception e) { } return(transaction); }
public JsonResult LoadGrid(string sidx, string sord, int rows, int page = 1) { string getType = Request["_type"]; string getVal = Request["_val"]; string getTujuan = "%" + Request["_tujuan"] + "%"; string getStartDate = Request["_startDate"]; string getEndDate = Request["_endDate"]; DateTime sd; if (!DateTime.TryParse(getStartDate, out sd)) { // handle parse failure } else { getStartDate = sd.ToString("MM/dd/yyyy HH:mm:ss"); } if (!DateTime.TryParse(getEndDate, out sd)) { // handle parse failure } else { getEndDate = sd.DayMax().ToString("MM/dd/yyyy HH:mm:ss"); } Params paramList = new Params() { Parameter = new Dictionary <string, string>() }; ESBData esbData = new ESBData() { Result = new List <StringDictionary>() }; Object[] data = new Object[1]; int pageSize = 0; int totalRecords = 0; int totalPages = 0; bool checkSpv = RoleNPrivilege.checkEntityButtonByRoleID(new Guid(Session["RoleID"].ToString()), "EmailInbox", "SPV"); switch (checkSpv) { case true: paramList.RequestTransType = "InqReceivedEmailforSPV"; paramList.Parameter.Add("UserLoc1", "INBX"); paramList.Parameter.Add("UserLoc2", " "); paramList.Parameter.Add("StartDate", getStartDate); paramList.Parameter.Add("EndDate", getEndDate); paramList.Parameter.Add("CustId", getTujuan); break; case false: string dateString, format; DateTime result; CultureInfo provider = CultureInfo.InvariantCulture; // Parse date-only value with invariant culture. format = "MM/dd/yyyy HH:mm:ss"; // h for 12 hour format, HH dor 24 hour format try { result = DateTime.ParseExact(getStartDate, format, provider); getStartDate = result.ToString("MM/dd/yyyy"); result = DateTime.ParseExact(getEndDate, format, provider); getEndDate = result.AddDays(1).ToString("MM/dd/yyyy"); } catch (FormatException) { //Console.WriteLine("{0} is not in the correct format.", dateString); } paramList.RequestTransType = "InqReceivedEmailforOPR"; paramList.Parameter.Add("AgentId", Session["DomainUserName"].ToString()); paramList.Parameter.Add("UserLoc1", "INBX"); paramList.Parameter.Add("UserLoc2", " "); paramList.Parameter.Add("StartDate", getStartDate.Substring(0, 10)); paramList.Parameter.Add("EndDate", getEndDate.Substring(0, 10)); paramList.Parameter.Add("CustId", getTujuan); break; } paramList.WSDL = "ESBDBDelimiter"; List <EmailOutbox> listEmailOutboxs = new List <EmailOutbox>(); esbData = EAI.RetrieveESBData(paramList); if (esbData != null && esbData.Result.Count != 0) { foreach (StringDictionary kvp in esbData.Result) { EmailOutbox model = new EmailOutbox(); model.Id = kvp[EmailOutboxMapping.refNo]; model.NoReferensi = kvp[EmailOutboxMapping.refNo]; model.Tujuan = kvp[EmailOutboxMapping.custId]; model.Subject = kvp[EmailOutboxMapping.subject]; model.SpvAppv = kvp[EmailOutboxMapping.supervisorId]; model.StatusTerakhir = kvp[EmailOutboxMapping.agentSpvLoc]; model.Tanggal = kvp[EmailOutboxMapping.createdDate]; string dateString, format; DateTime result; CultureInfo provider = CultureInfo.InvariantCulture; // Parse date-only value with invariant culture. dateString = model.Tanggal; format = "M/d/yyyy h:mm:ss tt"; // h for 12 hour format, HH dor 24 hour format try { result = DateTime.ParseExact(dateString, format, provider); Console.WriteLine("{0} converts to {1}.", dateString, result.ToString()); model.Tanggal = result.ToString("dd/MM/yyyy HH:mm:ss"); } catch (FormatException) { Console.WriteLine("{0} is not in the correct format.", dateString); } listEmailOutboxs.Add(model); } } else { //ViewBag.Message = esbData.Message; } var tempOutbox = listEmailOutboxs .Select(x => new { Id = x.Id, NoReferensi = x.NoReferensi, Tujuan = x.Tujuan, Subject = x.Subject, Tanggal = x.Tanggal, SpvAppv = x.SpvAppv, StatusTerakhir = x.StatusTerakhir }).AsQueryable(); pageSize = rows; totalRecords = tempOutbox.Count(); totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize); tempOutbox = tempOutbox.OrderBy(sidx + " " + sord).Skip((page - 1) * pageSize).Take(pageSize); data = tempOutbox.ToArray(); var recordCount = totalRecords; JSONTable jTable = new JSONTable(); jTable.total = totalPages; jTable.page = page; jTable.records = recordCount; jTable.rows = data; return(Json(jTable, JsonRequestBehavior.AllowGet)); }
public static SMSBCATransaction SMSBCA(Params request) { SMSBCATransaction transaction = new SMSBCATransaction(); Params param = new Params() { Parameter = new Dictionary <string, string>() }; try { param.RequestTransType = request.RequestTransType; param.Parameter.Add("CustId", request.Parameter.ContainsKey("mobileNo") ? request.Parameter["mobileNo"].Trim() : string.Empty); param.Parameter.Add("StartDate", Formatter.ToStringExact(Convert.ToDateTime(request.Parameter["startDate"]), "MM/dd/yyyy")); param.Parameter.Add("EndDate", Formatter.ToStringExact(Convert.ToDateTime(request.Parameter["endDate"]).AddDays(1), "MM/dd/yyyy")); param.Parameter.Add("Proses", "GetSMSTransactionInfoSaldo".Equals(param.RequestTransType) ? "SMSBAccGetBalanceRq" : "GetSMSTransactionInfoMutasi".Equals(param.RequestTransType) ? "SMSBAcctStmtRq" : "GetSMSTransactionInfoCoupon".Equals(param.RequestTransType) ? "SMSBInqCouponRq" : "GetSMSTransactionInfoPayment".Equals(param.RequestTransType) ? "SMSBLPGRQ" : string.Empty); param.WSDL = "ESBDBDelimiter"; ESBData data = EAI.RetrieveESBData(param); if (data.Result != null && data.Result.Count > 0) { foreach (StringDictionary entry in data.Result) { DateTime? transactionDate = Convert.ToDateTime(entry["createddate"]); string status = entry["srvrstatuscode"]; SMSBCATRX trx = new SMSBCATRX(); trx.TransactionDate = transactionDate; trx.AccountNumber = entry["acctidfrom"]; trx.TransactionType = Utility.GetDisplayText("TransactionAttributeMapping", "SMS BCA", "Transaction Type", entry["process"]); trx.ResponseCode = Utility.GetDisplayText("TransactionAttributeMapping", "SMS BCA", "Response Code", status); trx.Amount = Formatter.GetParsedDouble(entry["amt"], false); /* Payment Menu * 07 12 2016 - LPG * Tanggal Transaksi createddate TransactionDate * No Rekening acctidfrom AccountNumber * No Referensi refcode ReferenceNumber * Jenis Transaksi process -company_name TransactionType + string * Nominal (IDR) amt Amount * Status srvrstatuscode - rquid ResponseCode + string * Pembayar billerid Biller * Penerima authidresponse [0] Receiver * Jumlah authidresponse [1] Total * Informasi Lain authidresponse [2] Other */ if ("GetSMSTransactionInfoPayment".Equals(param.RequestTransType)) { trx.ReferenceNumber = entry["refcode"]; trx.TransactionType += " - " + entry["company_name"]; trx.ResponseCode += " - " + entry["rquid"]; trx.Biller = entry["billerid"]; string[] authidresp = entry["authidresponse"].Split('|'); if (authidresp.Length == 3) { trx.Receiver = authidresp[0]; trx.Total = authidresp[1]; trx.Other = authidresp[2].Length == 8 ? Utility.FormatDateAuth(authidresp[2]) : authidresp[2]; } } transaction.Transactions.Add(trx); } param.Parameter = new Dictionary <string, string>(); param.RequestTransType = "GetSMSBankingInfoByMobileNo"; param.Parameter.Add("CustId", request.Parameter.ContainsKey("mobileNo") ? request.Parameter["mobileNo"].Trim() : string.Empty); param.WSDL = "ESBDBDelimiter"; ESBData information = EAI.RetrieveESBData(param); if (information.Result != null && information.Result.Count > 0) { transaction.ATMCardHolderName = information.Result[0]["custname"]; transaction.ATMCardNumber = information.Result[0]["cardnumber"]; transaction.Status = Utility.GetStatusInfo(information.Result[0]["status"]); } } } catch (Exception e) { } return(transaction); }
public ActionResult SingleView(Guid id) { bool hasAccess = RoleNPrivilege.HasAccess(new Guid(Session["RoleID"].ToString()), "Customer"); int gridMaxRows = Convert.ToInt32(ConfigurationManager.AppSettings["GridMaxRows"].ToString()); ViewBag.GridMaxRows = gridMaxRows; if (hasAccess) { Customer model = db.customer.Find(id); List <CreditCard> creditcardList = new List <CreditCard>(); List <Deposit> depositList = new List <Deposit>(); List <Loan> loanList = new List <Loan>(); List <Channel> channelList = new List <Channel>(); List <KeyValuePair <int, string> > results = new List <KeyValuePair <int, string> >(); Params paramProductList = new Params() { Parameter = new Dictionary <string, string>() }; Params paramChannelList = new Params() { Parameter = new Dictionary <string, string>() }; DBServices dbservices = new DBServices(); paramProductList.WSDL = "CustomerProductListInquiry"; if (string.IsNullOrEmpty(model.CISNumber) || model.CISNumber.StartsWith("C", true, CultureInfo.InvariantCulture) //|| customer.GenderCode == 200000 // commented for a while ) { paramProductList.RequestTransType = "SearchAllProductsByCustCC"; paramProductList.Parameter.Add("custNo", model.CreditCardCustomerNo); } else { paramProductList.RequestTransType = "SearchAllProductsByCIS"; paramProductList.Parameter.Add("cisNo", model.CISNumber); } ESBData esbProduct = new ESBData() { Result = new List <StringDictionary>() }; esbProduct = EAI.RetrieveESBData(paramProductList); if (esbProduct.Result != null && esbProduct.Result.Count() > 0) { dbservices.GetProducts(model, esbProduct.Result, null, out creditcardList, out depositList, out loanList); } else { ViewBag.Message = esbProduct.Message; } paramChannelList.WSDL = "CustomerChannelListInquiry"; if (string.IsNullOrEmpty(model.CISNumber) || model.CISNumber.StartsWith("C", true, CultureInfo.InvariantCulture)) { paramChannelList.RequestTransType = "SearchAllChannelsByCustCC"; paramChannelList.Parameter.Add("cisNo", ""); paramChannelList.Parameter.Add("custNo", model.CreditCardCustomerNo); } else { paramChannelList.RequestTransType = "SearchAllChannelsByCIS"; paramChannelList.Parameter.Add("cisNo", model.CISNumber); paramChannelList.Parameter.Add("custNo", ""); } ESBData esbChannel = EAI.RetrieveESBData(paramChannelList); if (esbChannel.Result != null && esbChannel.Result.Count() > 0) { dbservices.GetChannel(model, esbChannel.Result, out channelList); } else { ViewBag.Message = esbChannel.Message; } // DEPOSIT var modelDeposit = (from x in depositList select new { Id = x.Id, CustomerId = x.CustomerId, CustomerIdName = x.CustomerIdName, AccountNo = x.AccountNo, AccountTypeIdCode = x.AccountTypeIdCode, AccountTypeIdName = x.AccountTypeIdName, CardNo = x.CardNo, CardTypeIdName = x.CardTypeIdName, OwnerTypeLabel = x.OwnerTypeLabel, RelationType = x.RelationType, RelationshipWith = x.RelationshipWith }); // CREDIT CARD var modelCreditCard = (from x in creditcardList group x by x.Id into y select new { Id = y.Key, CreditCardNumber = y.Select(z => z.CreditCardNumber).FirstOrDefault(), CardholderName = y.Select(z => z.CardholderName).FirstOrDefault(), CardType = y.Select(z => z.CardType).FirstOrDefault(), CCType = y.Select(z => z.CCType).FirstOrDefault(), CreditCardCustomerNo = y.Select(z => z.CreditCardCustomerNo).FirstOrDefault(), CustomerId = y.Select(z => z.CustomerId).FirstOrDefault(), CustomerIdName = y.Select(z => z.CustomerIdName).FirstOrDefault(), Status = y.Select(z => z.Status).FirstOrDefault() }); // LOAN var modelLoan = loanList .OrderBy(x => x.AccountNo) .ThenBy(x => x.LoanTypeIdCode) .ThenBy(x => x.LoanNumber); // CHANNEL var modelChannel = channelList .OrderBy(x => x.ChannelType) .ThenBy(x => x.Id); ViewBag.DepositModel = modelDeposit; ViewBag.DepositModelCount = modelDeposit.Count(); if (ViewBag.DepositModelCount > gridMaxRows) { ViewBag.DepositModel = modelDeposit.Take(gridMaxRows); } ViewBag.CreditCardModel = modelCreditCard; ViewBag.CreditCardModelCount = modelCreditCard.Count(); if (ViewBag.CreditCardModelCount > gridMaxRows) { ViewBag.CreditCardModel = modelCreditCard.Take(gridMaxRows); } ViewBag.LoanModel = modelLoan; ViewBag.LoanModelCount = modelLoan.Count(); if (ViewBag.LoanModelCount > gridMaxRows) { ViewBag.LoanModel = modelLoan.Take(gridMaxRows); } ViewBag.ChannelModel = modelChannel; ViewBag.ChannelModelCount = modelChannel.Count(); ViewBag.CustomerId = model.CustomerID; ViewBag.CustomerIdName = model.FullName; ViewBag.CISNumber = model.CISNumber; ViewBag.hasAccess = 1; } else { ViewBag.hasAccess = 0; } return(View()); }
public static MBCATransaction MBCA(Params request) { MBCATransaction transaction = new MBCATransaction(); Params param = new Params() { Parameter = new Dictionary <string, string>() }; string dateFormat = string.Empty; try { param.RequestTransType = request.RequestTransType; dateFormat = "GetMBTransactionOTP".Equals(param.RequestTransType) ? "dd-MM-yyyy" : "MM/dd/yyyy"; param.Parameter.Add("GetMBTransactionOTP".Equals(param.RequestTransType) ? "CustomerID" : "FK_CustID", request.Parameter.ContainsKey("mobileNo") ? request.Parameter["mobileNo"].Trim() : string.Empty); if ("GetMBTransactionMCommerce".Equals(param.RequestTransType) || "GetMBTransactionMPayment".Equals(param.RequestTransType)) { param.Parameter.Add("TxType", "MBAccExecPaymentRq"); } if ("GetMBTransactionMTransfer".Equals(param.RequestTransType)) { param.Parameter.Add("TxType1", "MBAccXFerExecRq"); param.Parameter.Add("TxType2", "MBAccGetCustomerInfo"); } if ("GetMBTransactionMInfo".Equals(param.RequestTransType)) { // MBGetInfoCC - Info KK param.Parameter.Add("Process1", "MBAccGetBalanceRq"); // Info Saldo param.Parameter.Add("Process2", "MBAcctStmtRq"); // Mutasi Rekening param.Parameter.Add("Process3", "MBGetAcctStmtCCRq"); // Info Transaksi KK param.Parameter.Add("Process4", "MBGetBalanceCCR"); // Info Saldo KK param.Parameter.Add("Process5", "MBGetBalanceDepR"); // Info Deposito param.Parameter.Add("Process6", "MBGetBalReksaDanaRq "); // Info Saldo Reksadana param.Parameter.Add("Process7", "MBGetBankCod"); // Info Kode Bank param.Parameter.Add("Process8", "MBGetCompCod"); // Info Kode Perusahaan param.Parameter.Add("Process9", "MBGetExChgRateRq"); // Info Kurs param.Parameter.Add("Process10", "MBGetKreditKonsumerRq"); // Info Kredit Konsumer param.Parameter.Add("Process11", "MBGetNABReksaDanaRq "); // Info NAB Reksadana param.Parameter.Add("Process12", "MBInqCouponR"); // Info Kupon param.Parameter.Add("Process13", "MBIntRateDepIDRRq"); // Info Suku Bunga Deposito Rupiah param.Parameter.Add("Process14", "MBIntRateDepValRq"); // Info Suku Bunga Deposito Valas param.Parameter.Add("Process15", "MBIntRateSavingRq"); // Info Suku Bunga Tabungan param.Parameter.Add("Process16", "MBRDNAcctStmtRq"); // Saldo RDN param.Parameter.Add("Process17", "MBRDNGetBalanceRq"); // Info Mutasi RDN param.Parameter.Add("Process18", "MBVerPIN"); // Verifikasi PIN } if ("GetMBTransactionMAdmin".Equals(param.RequestTransType)) { param.Parameter.Add("Proses1", "MBBlockATMCardRq"); // Blokir Kartu ATM param.Parameter.Add("Proses2", "MBBlockCCRq"); // Kartu Kredit param.Parameter.Add("Proses3", "MBCCActivationConnectionRq"); // Koneksi KK setelah Aktivasi param.Parameter.Add("Proses4", "MBCCActivationRq"); // Aktivasi Kartu Kredit param.Parameter.Add("Proses5", "MBChangePINRq"); // Ganti PIN param.Parameter.Add("Proses6", "MBDelBCACCRq"); // Hapus KK param.Parameter.Add("Proses7", "MBDelPaymentListRq"); // Hapus Daftar Pembayaran param.Parameter.Add("Proses8", "MBDelSAKUListRq"); // Daftar Transfer Sakuku param.Parameter.Add("Proses9", "MBDelTranferListRq"); // Hapus Daftar Transfer Antar Rek param.Parameter.Add("Proses10", "MBDelTranferSwitchingListRq"); // Daftar Transfer Antar Bank param.Parameter.Add("Proses11", "MBDelVAListRq"); // Hapus Daftar Transfer VA param.Parameter.Add("Proses12", "MBLoginBlockATMCardRq"); // Login Blokir Kartu ATM param.Parameter.Add("Proses13", "MBPINCCActivationRq"); // PIN Kartu Kredit param.Parameter.Add("Proses14", "MBRegBCACCRq"); // Registrasi KK param.Parameter.Add("Proses15", "ActivationRq"); // Aktivasi param.Parameter.Add("Proses16", ""); param.Parameter.Add("Proses17", ""); param.Parameter.Add("Proses18", ""); } param.Parameter.Add("StartDate", Formatter.ToStringExact(Convert.ToDateTime(request.Parameter["startDate"]), dateFormat)); param.Parameter.Add("EndDate", Formatter.ToStringExact(Convert.ToDateTime(request.Parameter["endDate"]).AddDays(1), dateFormat)); if ("GetMBTransactionMCommerce".Equals(param.RequestTransType)) { param.Parameter.Add("PaidType", "PURCHASE"); } if ("GetMBTransactionMPayment".Equals(param.RequestTransType)) { param.Parameter.Add("PaidType", "PAYMENT"); } param.WSDL = "GetMBTransactionOTP".Equals(param.RequestTransType) ? "OTPCashOut" : "ESBDBDelimiter"; ESBData data = EAI.RetrieveESBData(param); if (data.Result != null && data.Result.Count > 0) { foreach (StringDictionary entry in data.Result) { DateTime?middlewareDate = Formatter.ParseExact(entry["txt_date"], "MM/dd/yyyy hh:mm:ss tt"); DateTime?tandemDate = Formatter.ParseExact(entry["tandemtxdate"], "ddMMHHmmss"); switch (param.RequestTransType) { case "GetMBTransactionMCommerce": transaction.Transactions.Add(new MBTRX() { MiddlewareDate = Formatter.ToStringExact(middlewareDate, "dd/MM/yyyy HH:mm:ss"), TandemDate = Formatter.ToStringExact(tandemDate, "dd/MM HH:mm:ss"), ATMCardNumber = entry["cardacctid"], AccountNumber = entry["acctidfrom"], CustomerNumber = entry["billreffinfo"], PaymentType = entry["desceng"], Nominal = Formatter.GetParsedDouble(entry["amt"], false), Status = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "M-BCA", "Middleware Status", entry["statuscode"]), DescCode = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "M-BCA", "Tandem Status", entry["srvrstatuscode"]), Information = entry["dccustaddress"], ReferenceNumber = entry["refcode"] }); break; case "GetMBTransactionMPayment": transaction.Transactions.Add(new MBTRX() { MiddlewareDate = Formatter.ToStringExact(middlewareDate, "dd/MM/yyyy HH:mm:ss"), TandemDate = Formatter.ToStringExact(tandemDate, "dd/MM HH:mm:ss"), ATMCardNumber = entry["cardacctid"], PaymentAccountNumber = entry["acctidfrom"], CustomerNumber = entry["billreffinfo"], PaymentFor = entry["desceng"], Nominal = Formatter.GetParsedDouble(entry["amt"], false), Status = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "M-BCA", "Middleware Status", entry["statuscode"]), DescCode = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "M-BCA", "Tandem Status", entry["srvrstatuscode"]), Information = entry["dccustaddress"], ReferenceNumber = entry["refcode"] }); break; case "GetMBTransactionMTransfer": string reqId = string.IsNullOrEmpty(entry["rquid"]) ? string.Empty : entry["rquid"]; string billerAccountId = string.IsNullOrEmpty(entry["billeracctid"]) ? string.Empty : entry["billeracctid"]; string statusCode = entry["statuscode"]; double?kurs = 0; double?amount = 0; double?amountForx = 0; string currency = Utility.GetCurrency(entry["curr"]); if (statusCode == "00" && !string.IsNullOrEmpty(entry["forexrateamt"])) { kurs = Formatter.GetParsedDouble(entry["forexrateamt"], false); } if (((statusCode != "00" && currency == "360") || statusCode == "00") && !string.IsNullOrEmpty(entry["amtidr"])) { amount = Formatter.GetParsedDouble(entry["amtidr"], false); } if (((statusCode != "00" && currency == "360") || statusCode == "00") && !string.IsNullOrEmpty(entry["amtforex"])) { amountForx = Formatter.GetParsedDouble(entry["amtforex"], false); } transaction.Transactions.Add(new MBTRX() { MiddlewareDate = Formatter.ToStringExact(middlewareDate, "dd/MM/yyyy HH:mm:ss"), TandemDate = Formatter.ToStringExact(tandemDate, "dd/MM HH:mm:ss"), ATMCardNumber = entry["cardacctid"], AccountSendersNumber = entry["acctidfrom"], CodeAndBankName = billerAccountId + reqId, ToAccountNumber = entry["acctidto"], ToAccountMU = Utility.GetCurrency(entry["acctcurrto"]), ToAccountName = entry["acctidtoname"], Currency = currency, Amount = amount, AmountForex = amountForx, ExchangesRate = kurs, Status = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "M-BCA", "Middleware Status", entry["statuscode"]), DescCode = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "M-BCA", "Tandem Status", entry["srvrstatuscode"]), Information = entry["dccustaddress"], ReferenceNumber = entry["refcode"] }); break; case "GetMBTransactionMInfo": middlewareDate = Formatter.ParseExact(entry["createddate"], "MM/dd/yyyy hh:mm:ss tt"); transaction.Transactions.Add(new MBTRX() { MiddlewareDate = Formatter.ToStringExact(middlewareDate, "dd/MM/yyyy HH:mm:ss"), TransactionType = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "M-BCA", "Transaction Type", entry["process"]), ATMCardNumber = entry["cardnumber"], AccountNumber = entry["acctidfrom"], CustomerName = entry["custname"], Status = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "M-BCA", "Middleware Status", entry["statuscode"]), DescCode = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "M-BCA", "Tandem Status", entry["srvrstatuscode"]), Information = entry["rquid"] }); break; case "GetMBTransactionMAdmin": middlewareDate = Formatter.ParseExact(entry["createddate"], "MM/dd/yyyy hh:mm:ss tt"); transaction.Transactions.Add(new MBTRX() { MiddlewareDate = Formatter.ToStringExact(middlewareDate, "MM/dd/yyyy HH:mm:ss"), AdminType = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "M-BCA", "Admin Type", entry["process"]), ATMCardNumber = entry["cardnumber"], CustomerName = entry["custname"], Status = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "M-BCA", "Middleware Status", entry["statuscode"]), DescCode = Utility.GetMiddlewareTandemStatus("TransactionAttributeMapping", "M-BCA", "Tandem Status", entry["srvrstatuscode"]), Information = entry["rquid"] }); break; case "GetMBTransactionOTP": transaction.Transactions.Add(new MBTRX() { MiddlewareDate = entry["CreatedDate"], Status = entry["Status"], ATMCardNumber = entry["CardNumber"], TandemDate = entry["TransactionDate"], AccountNumber = entry["AccountNumber"], Amount = Formatter.GetParsedDouble(entry["Amount"], false) }); break; } } param.Parameter = new Dictionary <string, string>(); param.RequestTransType = "GetMBankInfoByMobileNo"; param.Parameter.Add("CustId", request.Parameter.ContainsKey("mobileNo") ? request.Parameter["mobileNo"].Trim() : string.Empty); param.WSDL = "ESBDBDelimiter"; ESBData information = EAI.RetrieveESBData(param); if (information.Result != null && information.Result.Count > 0) { transaction.ATMCardNumber = information.Result[0]["cardnumber"]; transaction.CustomerName = information.Result[0]["custname"]; transaction.Status = Utility.GetStatusInfo(information.Result[0]["status"]); param.Parameter = new Dictionary <string, string>(); param.RequestTransType = "GetTandemStatusMBank"; param.Parameter.Add("atmNo", information.Result[0]["cardnumber"]); param.Parameter.Add("mobileNo", request.Parameter["mobileNo"]); param.WSDL = "MBManagement"; ESBData tandem = EAI.RetrieveESBData(param); transaction.HandPhoneNumberOnTandem = tandem.Result[0][MobileBankingTandemInquiryStatusResultKeyName.MobileNo]; transaction.CustomerNameTandem = tandem.Result[0][MobileBankingTandemInquiryStatusResultKeyName.CustomerName]; transaction.StatusTandem = Utility.GetStatusInfo(tandem.Result[0][MobileBankingTandemInquiryStatusResultKeyName.UserIdStatus]); } } } catch (Exception e) { } return(transaction); }
public static List <ATMTransaction> ATM(Params request) { List <ATMTransaction> ResultList = new List <ATMTransaction>(); Params param = new Params() { Parameter = new Dictionary <string, string>() }; param.Parameter.Add("NUM", request.Parameter.ContainsKey("atmNo") ? request.Parameter["atmNo"].Trim() : string.Empty); param.Parameter.Add("StartDate", request.Parameter.ContainsKey("startDate") ? request.Parameter["startDate"].Trim() : string.Empty); param.Parameter.Add("EndDate", request.Parameter.ContainsKey("endDate") ? request.Parameter["endDate"].Trim() : string.Empty); param.Parameter.Add("CRD_LN", request.Parameter.ContainsKey("lnet") ? request.Parameter["lnet"].Trim() : string.Empty); param.Parameter.Add("CRD_FIID", request.Parameter.ContainsKey("fiid") ? request.Parameter["fiid"].Trim() : string.Empty); if (request.Parameter.ContainsKey("terminalId")) { param.RequestTransType = "GetATMTransactionByATMNoWithTerminalID"; param.Parameter.Add("TERM_ID", request.Parameter["terminalId"].Trim().ToUpper()); } else { param.RequestTransType = "GetATMTransactionByATMNo"; } param.WSDL = "ESBDBDelimiter"; try { ESBData data = EAI.RetrieveESBData(param); if (data.Result != null && data.Result.Count > 0) { int counter = 0; ATMTransaction record = null; foreach (var entry in data.Result) { record = new ATMTransaction(); //DateTime? transactionDate = Formatter.ParseExact(entry["tran_dat"], "yyyy-MM-dd HH:mm:ss"); //string a = Formatter.ToStringExact(DateTime.ParseExact(entry["tran_dat"], "dd/MM/yyyy hh:mm:ss", null), "dd/MM hh:mm"); //DateTime dt = DateTime.ParseExact(entry["tran_dat"], "dd MM yyyy hh:mm:ss", null); //string s = dt.ToString("dd-MM hh:mm"); double amountValue = 0; double.TryParse(entry["amt_1"], out amountValue); amountValue = amountValue / 100; string rateEsb = entry["crncy_conv_rate"]; double rateValue = 0; if (!string.IsNullOrEmpty(rateEsb)) { double nValue = 0; double.TryParse(rateEsb.Substring(0, 1), out nValue); double.TryParse(rateEsb.Remove(0, 1), out rateValue); rateValue = rateValue / Math.Pow(10, nValue); } double conversionAmount = 0; double.TryParse(entry["crncy_conv_amt"], out conversionAmount); conversionAmount = conversionAmount / 100; double transactionAmount = 0; double.TryParse(entry["amt_2"], out transactionAmount); transactionAmount = transactionAmount / 100; string currency = entry["from_crncy_cde"]; counter++; record.Number = counter.ToString(); record.TransactionCode = entry["tran_cde"]; //record.TransactionDate = transactionDate.ToString(); record.TransactionDate = entry["tran_dat"]; record.Amount1 = amountValue.ToString(); record.ResponseCode = entry["respcode"]; record.ResponseDescription = entry["respdesc"]; record.TransactionDescription = entry["trandesc"]; //record.Currency = entry["from_crncy_cde"]; record.Currency = entry["orig_crncy_cde"]; record.Terminal = entry["term_id"]; record.Rate = rateValue.ToString(); record.ConversionAmount = GetConversionAmount(entry, conversionAmount); record.Amount2 = GetConversionAmount(entry, transactionAmount); record.FromAccount = entry["from_acct_acct_num"]; record.ToAccount = entry["to_acct_acct_num"]; record.PayeeCode = entry["payee_code"]; record.PayeeNumber = entry["bill_acct_num"]; record.SequenceNumber = entry["seq_num"]; ResultList.Add(record); } } } catch (Exception e) { } return(ResultList); }
private void InsertUpdateCustAddress(Customer customer, StringDictionary esbCust) { CRMDb db = new CRMDb(); List <CustomerAddress> addressList = new List <CustomerAddress>(); List <KeyValuePair <int, string> > results = new List <KeyValuePair <int, string> >(); /* [CustomerIndicator] can either be 0, 1 or 2. * 0: The customer has Credit Card & Deposit * ALL address types will be returned * 1: The customer has Deposit Only * Home and Mailing Address will be returned * 2: The customer has Credit Card Only * Billing, Office and Other Address will be returned */ bool isCorporate = (customer.GenderCode == 200000); switch (esbCust["customerIndicator"]) { case "0": // The customer has Credit Card and Deposit addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeHome), esbCust)); // ContactAddressType = Home addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeOffice), esbCust)); // ContactAddressType = Office addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeMailing), esbCust)); // ContactAddressType = Mailing if (!isCorporate) { Params paramList = new Params() { Parameter = new Dictionary <string, string>() }; paramList.RequestTransType = "GetCreditCardAddressesByCisNo"; paramList.Parameter.Add("cisNo", customer.CISNumber); paramList.WSDL = "CCAddressDetail"; ESBData addresses = new ESBData() { Result = new List <StringDictionary>() }; addresses = EAI.RetrieveESBData(paramList); foreach (StringDictionary address in addresses.Result) { addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeBilling), address)); // ContactAddressType = Billing addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeOther), address)); // ContactAddressType = Other } } else { addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeBilling), esbCust)); // ContactAddressType = Billing addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeOther), esbCust)); // ContactAddressType = Other } break; case "1": // The customer has Deposit Card only addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeOffice), esbCust)); // ContactAddressType = Office addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeHome), esbCust)); // ContactAddressType = Home addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeMailing), esbCust)); // ContactAddressType = Mailing break; case "2": // The customer has Credit Card only // Change for fixing the customer search defect which has a cis number "00000000000". if (esbCust["custno"] == "00000000000" || isCorporate) { addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeHome), esbCust)); // ContactAddressType = Home addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeOffice), esbCust)); // ContactAddressType = Office addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeMailing), esbCust)); // ContactAddressType = Mailing addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeBilling), esbCust)); // ContactAddressType = Billing addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeOther), esbCust)); // ContactAddressType = Other } else { Params paramList = new Params() { Parameter = new Dictionary <string, string>() }; paramList.RequestTransType = "GetCreditCardAddressesByCisNo"; paramList.Parameter.Add("cisNo", customer.CISNumber); paramList.WSDL = "CCAddressDetail"; ESBData addresses = EAI.RetrieveESBData(paramList); foreach (StringDictionary address in addresses.Result) { addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeBilling), address)); // ContactAddressType = Billing addressList.Add(RetrieveAddress(int.Parse(Resources.Customer.ContactAddressTypeOther), address)); // ContactAddressType = Other } } break; } // Push CustAddress to DB // ---------------------- KeyValuePair <int, string> result = new KeyValuePair <int, string>(); result = db.CustomerAddress_Delete(customer); if (result.Key == 0) // deleteCustAddress successful, then insertCustAddresses { KeyValuePair <int, string> res = new KeyValuePair <int, string>(); int i = 3; int addrType = (customer.CISNumber.StartsWith("C_") ? 200000 : 1); bool insert = false; foreach (CustomerAddress address in addressList) { if (!(address.Line1 == "" && address.Line2 == "" && address.Line3 == "" && address.City == "" && address.Country == "" && address.StateOrProvince == "" && address.PostalCode == "")) { address.CustomerAddressId = Guid.NewGuid(); address.ParentId = customer.CustomerID; address.AddressNumber = i; address.CreatedBy = customer.ModifiedBy; address.ModifiedBy = customer.ModifiedBy; address.CreditCardCustomerNo = customer.CreditCardCustomerNo; res = db.CustomerAddress_Insert(address); i += 1; if ((address.AddressTypeCode == addrType) && !insert) { address.CustomerAddressId = Guid.NewGuid(); address.AddressNumber = 1; res = db.CustomerAddress_Insert(address); insert = true; } } } results.Add(res); } }
public JsonResult EmailDetail() { string getType = Request["_type"]; string getVal = Request["_val"]; string getFilter = Request["_filter"]; Params paramList = new Params() { Parameter = new Dictionary <string, string>() }; ESBData esbData = new ESBData() { Result = new List <StringDictionary>() }; Object[] data = new Object[1]; JSONResponse jsonResponse = new JSONResponse(); switch (getType) { case "inboxFindByPKID": paramList.RequestTransType = "InqSendedEmailDetailByRefNo"; paramList.Parameter.Add("RefNo", getVal); paramList.WSDL = "ESBDBDelimiter"; List <EmailInboxByRefNo> listEmailInboxsByPKID = new List <EmailInboxByRefNo>(); esbData = EAI.RetrieveESBData(paramList); if (esbData != null && esbData.Result.Count != 0) { foreach (StringDictionary kvp in esbData.Result) { EmailInboxByRefNo model = new EmailInboxByRefNo(); if (kvp.ContainsKey("refNo")) { model.Id = kvp[EmailInboxByRefNoMapping.refNo]; model.NoReferensi = kvp[EmailInboxByRefNoMapping.refNo]; } else { model.Id = getVal; model.NoReferensi = getVal; } if (kvp.ContainsKey("agentFlag")) { model.StatusTerakhir = kvp[EmailInboxByRefNoMapping.agentFlag]; } if (kvp.ContainsKey("agentId")) { model.AgentId = kvp[EmailInboxByRefNoMapping.agentId]; } model.Pengirim = kvp[EmailInboxByRefNoMapping.custId]; model.Subject = kvp[EmailInboxByRefNoMapping.subject]; model.Tanggal = kvp[EmailInboxByRefNoMapping.createdDate]; string dateString, format; DateTime result; CultureInfo provider = CultureInfo.InvariantCulture; // Parse date-only value with invariant culture. dateString = model.Tanggal; format = "M/d/yyyy h:mm:ss tt"; // h for 12 hour format, HH dor 24 hour format try { result = DateTime.ParseExact(dateString, format, provider); Console.WriteLine("{0} converts to {1}.", dateString, result.ToString()); model.Tanggal = result.ToString("dd/MM/yyyy HH:mm:ss"); } catch (FormatException) { Console.WriteLine("{0} is not in the correct format.", dateString); } model.Content = kvp[EmailInboxByRefNoMapping.content]; listEmailInboxsByPKID.Add(model); } } var temp = listEmailInboxsByPKID .Select(x => new { Id = x.Id, NoReferensi = x.NoReferensi, Pengirim = x.Pengirim, Subject = x.Subject, Tanggal = x.Tanggal, StatusTerakhir = x.StatusTerakhir, Content = x.Content, AgentId = x.AgentId, Tujuan = Session["DomainUserName"].ToString(), TujuanFullName = Session["Fullname"].ToString() }); data = temp.ToArray(); jsonResponse.Data = data; break; } return(Json(jsonResponse)); }
public ActionResult EmailSendDraft() { string getType = Request["_type"]; string getVal = Request["_val"]; string getAgentID = Request["_pengirim"]; string getCustID = Request["_tujuan"]; string getSubject = Request["_subject"]; string getContent = Request["_isiBerita"]; string getNoReferensi = Request["_noReferensi"]; string getUserLoc = ""; string getUserFlag = ""; string getAgentSpvLoc = "WTAP"; string getAgentFlag = "READ"; string getSupervisorID = ""; string getDateTimeAgent = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss"); string getDateTimeUser = ""; ViewBag.Type = "sendEmail"; Params paramList = new Params() { Parameter = new Dictionary <string, string>() }; ESBData esbData = new ESBData() { Result = new List <StringDictionary>() }; Object[] data = new Object[1]; JSONResponse jsonResponse = new JSONResponse(); bool checkSpv = false; switch (getType) { case "kirimEmail": checkSpv = RoleNPrivilege.checkEntityButtonByRoleID(new Guid(Session["RoleID"].ToString()), "EmailSend", "SPV"); break; case "inbox": checkSpv = RoleNPrivilege.checkEntityButtonByRoleID(new Guid(Session["RoleID"].ToString()), "EmailInbox", "SPV"); break; case "outbox": checkSpv = RoleNPrivilege.checkEntityButtonByRoleID(new Guid(Session["RoleID"].ToString()), "EmailOutbox", "SPV"); break; } switch (checkSpv) { case true: paramList.RequestTransType = "SendDraftEmail"; paramList.Parameter.Add("UserLoc", getUserLoc); paramList.Parameter.Add("UserFlag", getUserFlag); paramList.Parameter.Add("AgentSpvLoc", getAgentSpvLoc); paramList.Parameter.Add("SupervisorID", getSupervisorID); paramList.Parameter.Add("Content", getContent); paramList.Parameter.Add("DateTimeAgent", getDateTimeAgent); paramList.Parameter.Add("PK_ID", getNoReferensi); paramList.WSDL = "ESBDBDelimiter"; esbData = EAI.RetrieveESBData(paramList); if (esbData != null && esbData.Result.Count != 0) { foreach (StringDictionary kvp in esbData.Result) { if (kvp.ContainsKey("result")) { jsonResponse.Value = new { Message = Resources.Email.EmailSendSuccess }; jsonResponse.Response = kvp["result"]; } } } break; case false: paramList.RequestTransType = "SendDraftEmail"; paramList.Parameter.Add("UserLoc", getUserLoc); paramList.Parameter.Add("UserFlag", getUserFlag); paramList.Parameter.Add("AgentSpvLoc", getAgentSpvLoc); paramList.Parameter.Add("SupervisorID", getSupervisorID); paramList.Parameter.Add("Content", getContent); paramList.Parameter.Add("DateTimeAgent", getDateTimeAgent); paramList.Parameter.Add("PK_ID", getNoReferensi); paramList.WSDL = "ESBDBDelimiter"; esbData = EAI.RetrieveESBData(paramList); if (esbData != null && esbData.Result.Count != 0) { foreach (StringDictionary kvp in esbData.Result) { if (kvp.ContainsKey("result")) { jsonResponse.Value = new { Message = Resources.Email.EmailSendSuccess }; jsonResponse.Response = kvp["result"]; } } } break; } return(Json(jsonResponse)); }