public static DepositInfo Account(Params request)
{
DepositInfo account = new DepositInfo();
request.WSDL = "DepositAccountAndCardDetail";
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count != 0)
{
account.AccountType = Utility.GetAccountType(data.Result[0][DepositAccountInquiryStatusResultKeyName.AccountType]);
account.ATMCardType = Utility.GetCardTypeByCardNo(data.Result[0][DepositAccountInquiryStatusResultKeyName.ATMCardNo]);
account.Name = data.Result[0][DepositAccountInquiryStatusResultKeyName.CustomerName];
account.AccountNumber = data.Result[0][DepositAccountInquiryStatusResultKeyName.AccountNo];
account.CardNumber = data.Result[0][DepositAccountInquiryStatusResultKeyName.ATMCardNo];
account.RelationType = data.Result[0][DepositAccountInquiryStatusResultKeyName.RelationType];
account.OwnerType = data.Result[0][DepositAccountInquiryStatusResultKeyName.OwnerType];
account.BranchHome = data.Result[0][DepositAccountInquiryStatusResultKeyName.Branch];
account.LastStatusKey = data.Result[0][DepositAccountInquiryStatusResultKeyName.Status];
//account.LastStatus = Utility.GetStringMap(14, 9, account.LastStatusKey);
account.LastStatus = Utility.GetStringMap(14, 1, account.LastStatusKey);
account.OpenDate = data.Result[0][DepositAccountInquiryStatusResultKeyName.OpenDate];
account.CloseDate = data.Result[0][DepositAccountInquiryStatusResultKeyName.CloseDate];
}
return(account);
}
public static List <CreditCardAutoPay> AutoPay(Params request)
{
List <CreditCardAutoPay> autopay = new List <CreditCardAutoPay>();
request.WSDL = "CCListAutoPayment";
ESBData data = EAI.RetrieveESBData(request);
int count = 0;
foreach (StringDictionary record in data.Result)
{
// Ignoring the Blank Records
if (string.IsNullOrEmpty(record[CreditCardAutoPayInquiryStatusResultKeyName.CustomerId]) &&
string.IsNullOrEmpty(record[CreditCardAutoPayInquiryStatusResultKeyName.MerchantName]))
{
continue;
}
autopay.Add(new CreditCardAutoPay()
{
Number = (++count).ToString(),
MerchantName = record[CreditCardAutoPayInquiryStatusResultKeyName.MerchantName],
CustomerNumber = record[CreditCardAutoPayInquiryStatusResultKeyName.CustomerId]
});
}
return(autopay);
}
private static void InvokeGetIBankInfoByATMNo(ref List <KlikBCAIndividuInfo> data, string atmNo)
{
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
ESBData information = new ESBData()
{
Result = new List <StringDictionary>()
};
param.WSDL = "ESBDBDelimiter";
param.RequestTransType = "GetIBankInfoByATMNo";
param.Parameter.Add("atmNo", atmNo);
information = EAI.RetrieveESBData(param);
if (information != null && information.Result.Count != 0)
{
Params paramTandem = new Params()
{
Parameter = new Dictionary <string, string>()
};
ESBData tandem = new ESBData()
{
Result = new List <StringDictionary>()
};
paramTandem.WSDL = "UserInternetBankingManagement";
paramTandem.RequestTransType = "GetTandemStatusIBankByUserId";
paramTandem.Parameter.Add("userId", information.Result[0]["custid"]);
tandem = EAI.RetrieveESBData(paramTandem);
BuildInternetBankingIndividualInquiryStatus(ref data, information, tandem, InternetBankingIndividualInquiryStatusResultKeyName.UpdatedByForEmail);
}
}
public static Deposit SpecificDeposit(Params request)
{
Deposit deposit = new Deposit();
string cisNo = request.Parameter["cisNo"];
string acctNo = request.Parameter["acctNo"];
if (string.IsNullOrEmpty(cisNo) || string.IsNullOrEmpty(acctNo))
{
return(deposit);
}
ESBData data = new ESBData()
{
Result = new List <StringDictionary>()
};
request.RequestTransType = "SearchSpecificDepositByCIS";
request.WSDL = "CustomerSpecificProductInquiry";
data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count != 0)
{
deposit.AccountNo = data.Result[0]["acctno"];
deposit.CardNo = data.Result[0]["cardnumber"];
deposit.OwnerTypeLabel = data.Result[0]["ownerdesc"];
deposit.RelationType = data.Result[0]["reldesc"];
}
return(deposit);
}
public static string RetrieveCreditCardType(string CreditCardNo)
{
string CardType = string.Empty;
try
{
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
param.RequestTransType = "GetAllRelatedCreditCardInOneCustNo";
param.Parameter.Add("cardNo", CreditCardNo);
param.WSDL = "AllRelatedDetail";
ESBData data = EAI.RetrieveESBData(param);
if (data.Result != null && data.Result.Count != 0)
{
foreach (StringDictionary entry in data.Result)
{
if (string.Compare(entry["cardNo"], CreditCardNo, StringComparison.InvariantCulture) == 0)
{
CardType = entry["cardType"];
break;
}
}
}
}
catch (Exception e)
{
}
return(CardType);
}
public static CreditCardInformation RetrieveCreditCardDetail(string CreditCardNo, string CreditCardType)
{
CreditCardInformation CCInformation = new CreditCardInformation();
if (!string.IsNullOrEmpty(CreditCardType) && !string.IsNullOrEmpty(CreditCardNo))
{
try
{
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
param.RequestTransType = "GetCreditCardDetailByCardNoAndCardType";
param.Parameter.Add("cardNo", CreditCardNo);
param.Parameter.Add("cardType", CreditCardType);
param.WSDL = "CCInformationDetail";
ESBData data = EAI.RetrieveESBData(param);
if (data.Result != null && data.Result.Count == 1)
{
CCInformation.CreditCardNo = CreditCardNo;
CCInformation.CustomerNo = data.Result[0]["custNo"];
CCInformation.CardType = CreditCardType;
CCInformation.CardholderName = data.Result[0]["cardHolderName"];
CCInformation.AvailableCredit = Formatter.GetParsedDouble(data.Result[0]["availCredit"], false);
}
}
catch (Exception e)
{
}
}
return(CCInformation);
}
public static DepositInfo ATMCard(Params request)
{
DepositInfo ATMCard = new DepositInfo();
request.WSDL = "DepositAccountAndCardDetail";
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count != 0)
{
ATMCard.AccountType = Utility.GetAccountType(data.Result[0][DepositATMCardInquiryStatusResultKeyName.AccountType]);
ATMCard.ATMCardType = Utility.GetCardTypeByCardNo(data.Result[0][DepositATMCardInquiryStatusResultKeyName.ATMCardNo]);
ATMCard.Name = data.Result[0][DepositATMCardInquiryStatusResultKeyName.CustomerName];
ATMCard.AccountNumber = data.Result[0][DepositATMCardInquiryStatusResultKeyName.AccountNo];
ATMCard.CardNumber = data.Result[0][DepositATMCardInquiryStatusResultKeyName.ATMCardNo];
ATMCard.RelationType = data.Result[0][DepositATMCardInquiryStatusResultKeyName.RelationType];
ATMCard.OwnerType = data.Result[0][DepositATMCardInquiryStatusResultKeyName.OwnerType];
ATMCard.WrongPinCounter = data.Result[0][DepositATMCardInquiryStatusResultKeyName.WongPinCounter];
ATMCard.UpdateByUserNumber = data.Result[0][DepositATMCardInquiryStatusResultKeyName.UpdateByUserNumber];
ATMCard.UpdateByUserGroup = data.Result[0][DepositATMCardInquiryStatusResultKeyName.UpdateByUserGroup];
ATMCard.LastStatusKey = data.Result[0][DepositATMCardInquiryStatusResultKeyName.Status];
//ATMCard.LastStatus = Utility.GetStringMap(14, 9, ATMCard.LastStatusKey);
ATMCard.LastStatus = Utility.GetStringMap(14, 1, ATMCard.LastStatusKey);
ATMCard.OpenDate = data.Result[0][DepositATMCardInquiryStatusResultKeyName.OpenDate];
ATMCard.UpdateDate = data.Result[0][DepositATMCardInquiryStatusResultKeyName.UpdateDateTime];
ATMCard.LastTransactionDate = data.Result[0][DepositATMCardInquiryStatusResultKeyName.LastTransactionDate];
}
return(ATMCard);
}
// comp_nm_in
public static List <Corporate> GetListCorporate(Params request)
{
List <Corporate> result = new List <Corporate>();
request.Parameter.Add("max_row_in", "10");
request.WSDL = "CallStoreProcedureDelimiter";
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count != 0)
{
int i = -1;
foreach (StringDictionary entry in data.Result)
{
if (!string.IsNullOrEmpty(entry["result"]))
{
continue;
}
else
{
Corporate model = new Corporate();
model.Id = i++;
model.CorporateId = entry["o_comp_cd"];
model.CorporateName = entry["o_comp_nm"];
model.Status = entry["o_status"];
result.Add(model);
}
}
}
return(result);
}
// corpId + uniqueKey || cardNo
public static CorporateCard CorporateCard(Params request)
{
CorporateCard model = null;
request.WSDL = "CorporateCardInquiry";
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count != 0)
{
model = new CorporateCard();
model.CardNumber = string.IsNullOrEmpty(data.Result[0]["cardnumber"]) ? "-" : data.Result[0]["cardnumber"];
model.CompanyName = string.IsNullOrEmpty(data.Result[0]["embossname"]) ? "-" : data.Result[0]["embossname"];
model.CorporateId = string.IsNullOrEmpty(data.Result[0]["corporateid"]) ? "-" : data.Result[0]["corporateid"];
model.AccountNumber = string.IsNullOrEmpty(data.Result[1]["accountnumber"]) ? "-" : Formatter.AccountNumber(data.Result[1]["accountnumber"]);
model.EmbossName = string.IsNullOrEmpty(data.Result[0]["customfield"]) ? "-" : data.Result[0]["customfield"];
model.CardHolder = string.IsNullOrEmpty(data.Result[0]["cardholder"]) ? "-" : data.Result[0]["cardholder"];
model.Phone = string.IsNullOrEmpty(data.Result[0]["phone"]) ? "-" : data.Result[0]["phone"];
model.IdNumber = string.IsNullOrEmpty(data.Result[0]["idnumber"]) ? "-" : data.Result[0]["idnumber"];
model.UniqueKey = string.IsNullOrEmpty(data.Result[0]["uniquekey"]) ? "-" : data.Result[0]["uniquekey"];
model.Email = string.IsNullOrEmpty(data.Result[0]["email"]) ? "-" : data.Result[0]["email"];
model.Status = string.IsNullOrEmpty(data.Result[0]["status"]) ? "-" : data.Result[0]["status"];
model.RecurringType = string.IsNullOrEmpty(data.Result[0]["reccurenttype"]) ? "-" : data.Result[0]["reccurenttype"];
model.RecurringPeriod = string.IsNullOrEmpty(data.Result[0]["reccurentperiod"]) ? "-" : data.Result[0]["reccurentperiod"];
model.CardType = string.IsNullOrEmpty(data.Result[0]["corporatetype"]) ? "-" : Utility.GetStringMap(18, 100, data.Result[0]["corporatetype"]);
model.StatusLabel = string.IsNullOrEmpty(data.Result[0]["status"]) ? "-" : Utility.GetStringMap(18, 1, data.Result[0]["status"]);
model.Limit = Utility.GetParsedDouble(data.Result[0]["limit"], false);
model.LimitExpiredDate = Utility.ParseExact(data.Result[0]["limitexpireddate"], "yyyyMMdd");
}
return(model);
}
private static StringDictionary RetrieveSMETokenInfo(string snToken)
{
StringDictionary tokenInfo = null;
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
param.RequestTransType = "GetSMETokenType";
param.Parameter.Add("snToken", snToken);
//param.WSDL = "ESBDBDelimiter";
ESBData data = new ESBData()
{
Result = new List <StringDictionary>()
};
data = EAI.RetrieveESBData(param);
if (data != null && data.Result.Count > 0)
{
ESBData records = new ESBData()
{
Result = new List <StringDictionary>()
};
Params paramToken = new Params()
{
Parameter = new Dictionary <string, string>()
};
string tokenType = null;
if (string.Compare("A", data.Result[0]["KdKeyBCA"], true, CultureInfo.CurrentUICulture) == 0)
{
tokenType = "A";
paramToken.RequestTransType = "GetSMETokenInfoActiveCard";
paramToken.Parameter.Add("snToken", snToken);
//paramToken.WSDL = "ESBDBDelimiter";
records = EAI.RetrieveESBData(paramToken);
}
else if (string.Compare("B", data.Result[0]["KdKeyBCA"], true, CultureInfo.CurrentUICulture) == 0)
{
tokenType = "V";
paramToken.RequestTransType = "GetSMETokenInfoVasco";
paramToken.Parameter.Add("snToken", snToken);
//paramToken.WSDL = "ESBDBDelimiter";
records = EAI.RetrieveESBData(paramToken);
}
if (records != null && records.Result.Count > 0)
{
// Adding that to the dictionary since, it is not part of the result set from ESB.
records.Result[0].Add("tokenType", tokenType);
tokenInfo = records.Result[0];
}
}
return(tokenInfo);
}
public static List <KlikBCABisnisInfo> KBB(Params request, Channel channel, string userId = null)
{
List <KlikBCABisnisInfo> kbb = new List <KlikBCABisnisInfo>();
request.WSDL = "ESBDBDelimiter";
ESBData data = EAI.RetrieveESBData(request);
userId = string.IsNullOrEmpty(userId)? channel.UserId : userId;
if (data != null && data.Result.Count != 0)
{
foreach (StringDictionary entry in data.Result)
{
KlikBCABisnisInfo model = new KlikBCABisnisInfo();
if (!string.IsNullOrEmpty(channel.CorpId) && !string.IsNullOrEmpty(userId))
{
model.CorpID = channel.CorpId;
model.UserID = userId;
DateTime?lastLoginDate = Utility.ParseExact(entry["last_login_dt"], "yyyy-MM-dd HH:mm:ss");
DateTime?registerDate = Utility.ParseExact(entry["registered_dt"], "yyyy-MM-dd HH:mm:ss");
model.UserName = entry["nm"];
model.UserID = userId;
model.CorpID = channel.CorpId;
model.LastLoginDate = lastLoginDate;
model.RegisterDate = registerDate;
model.LastStatusKey = entry["is_login"];
//model.LastStatus = Utility.GetStringMap(5, 4, entry["is_login"]);
model.LastStatus = Utility.GetStringMap(1, 1, model.LastStatusKey);
//kbb.LastStatus = new KeyValuePair<int, string>(Int32.Parse(entry["is_login"]), Utility.GetStringMap(5, 4, entry["is_login"]));
model.Email1 = entry["email1"];
model.Email2 = entry["email2"];
}
else if (!string.IsNullOrEmpty(channel.EmailAddress))
{
model.UserID = channel.UserId;
model.CorpID = entry["cd"];
model.CorpName = entry["nm"];
model.Email1 = entry["email1"];
model.Email2 = entry["email2"];
}
else if (!string.IsNullOrEmpty(channel.AccountNo))
{
model.CorpID = entry["corporate_code"];
model.CorpName = entry["corporate_name"];
model.Email1 = entry["corporate_email_address_1"];
model.Email2 = entry["corporate_email_address_2"];
model.AccountNo = entry["account_number"];
}
kbb.Add(model);
}
}
return(kbb);
}
public static List <CreditCardConnectionInfo> KBICreditCardConnection(Channel channel)
{
List <CreditCardConnectionInfo> creditcardconnection = new List <CreditCardConnectionInfo>();
ESBData data = new ESBData()
{
Result = new List <StringDictionary>()
};
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
if (!string.IsNullOrEmpty(channel.UserId))
{
param.RequestTransType = "GetCreditCardConnectionOnIBankByUserId";
param.Parameter.Add("userId", channel.UserId);
param.Parameter.Add("No_Kartu", "");
param.Parameter.Add("No_Rekening", "");
param.Parameter.Add("NewStatus", "AKT");
param.WSDL = "ESBDBDelimiter";
data = EAI.RetrieveESBData(param);
}
else if (!string.IsNullOrEmpty(channel.CustomerNo))
{
param.RequestTransType = "GetCreditCardConnectionOnIBankByCustCC";
param.Parameter.Add("KeyId", "");
param.Parameter.Add("No_Kartu", "");
param.Parameter.Add("custNo", channel.CustomerNo);
param.Parameter.Add("NewStatus", "AKT");
param.WSDL = "ESBDBDelimiter";
data = EAI.RetrieveESBData(param);
}
if (data != null && data.Result.Count != 0)
{
foreach (StringDictionary eachRecord in data.Result)
{
creditcardconnection.Add(new CreditCardConnectionInfo()
{
KeyId = eachRecord[ESBKeyValueName.CCConn_KeyId],
CustomerNoCreditCard = eachRecord[ESBKeyValueName.CCConn_CustomerNo],
AtmCardNo = eachRecord[ESBKeyValueName.CCConn_CardNo],
CustomerName = eachRecord[ESBKeyValueName.CCConn_CustomerName],
ConnectionType = eachRecord[ESBKeyValueName.CCConn_ConnectionType],
//ApplicationName = Utility.GetStringMap(7, 15, eachRecord[ESBKeyValueName.CCConn_ApplicationName]),
ApplicationName = Utility.GetStringMap(7, 12, eachRecord[ESBKeyValueName.CCConn_ApplicationName]),
ConnectionDate = Utility.ParseExact(eachRecord[ESBKeyValueName.CCConn_ConnectionDate], "MM/dd/yyyy hh:mm:ss tt"),
Id1 = eachRecord[ESBKeyValueName.CCConn_Id1],
Id2 = eachRecord[ESBKeyValueName.CCConn_Id2]
});
}
}
return(creditcardconnection);
}
private static StringDictionary RetrieveTokenInfo(string snToken)
{
StringDictionary tokenInfo = null;
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
param.RequestTransType = "GetTokenType";
param.Parameter.Add("sn_token", snToken);
param.WSDL = "ESBDBDelimiter";
ESBData data = EAI.RetrieveESBData(param);
if (data != null && data.Result.Count > 0)
{
ESBData records = null;
string tokenType = null;
if (string.Compare("A", data.Result[0]["kdkeybca"], true) == 0)
{
tokenType = "A";
Params paramRecordList = new Params()
{
Parameter = new Dictionary <string, string>()
};
paramRecordList.WSDL = "ESBDBDelimiter";
paramRecordList.RequestTransType = "GetTokenInfoActiveCard";
paramRecordList.Parameter.Add("sn_token", snToken);
paramRecordList.Parameter.Add("SN_Token", snToken);
records = EAI.RetrieveESBData(paramRecordList);
}
else if (string.Compare("B", data.Result[0]["kdkeybca"], true) == 0)
{
//snToken = "%" + snToken + "%";
tokenType = "V";
Params paramRecordList = new Params()
{
Parameter = new Dictionary <string, string>()
};
paramRecordList.WSDL = "ESBDBDelimiter";
paramRecordList.RequestTransType = "GetTokenInfoVasco";
paramRecordList.Parameter.Add("sn_token", snToken);
paramRecordList.Parameter.Add("SN_Token", snToken);
records = EAI.RetrieveESBData(paramRecordList);
}
if (records != null && records.Result.Count > 0)
{
records.Result[0].Add("tokenType", tokenType);
tokenInfo = records.Result[0];
}
}
return(tokenInfo);
}
public static AllChannelTransaction Mutasi(Params request, string isSuperAdmin = "N")
{
AllChannelTransaction transaction = new AllChannelTransaction();
try
{
transaction.RestrictedAccount = CheckRestrictedAccount(request.Parameter["acctNo"]);
if ((transaction.RestrictedAccount && "Y".Equals(isSuperAdmin)) || transaction.RestrictedAccount == false)
{
request.WSDL = "AccountStatementByDate";
ESBData data = EAI.RetrieveESBData(request);
if (data.Result != null && data.Result.Count > 0)
{
transaction.Name = data.Result[0][AllChannelTransactionResultKeyName.Name];
transaction.Currency = Utility.GetCurrency(data.Result[0][AllChannelTransactionResultKeyName.Currency]);
for (int ctr = 1; ctr < data.Result.Count; ctr++)
{
double amountValue;
double.TryParse(data.Result[ctr][AllChannelTransactionResultKeyName.Amount], out amountValue);
string transDate = data.Result[ctr][AllChannelTransactionResultKeyName.TransactionDate];
if (!string.IsNullOrEmpty(transDate))
{
string[] datePart = transDate.Split('/');
if (datePart.Length == 2)
{
string day = datePart[0].PadLeft(2, '0');
string month = datePart[1].PadLeft(2, '0');
transDate = day + "/" + month;
}
}
DateTime?transactionDate = Formatter.ParseExact(transDate, "dd/MM");
transaction.Transactions.Add(new ACTRX()
{
Number = ctr.ToString(CultureInfo.CurrentUICulture),
displayTransactionDate = transDate,
TransactionDate = transactionDate,
TransactionType = data.Result[ctr][AllChannelTransactionResultKeyName.TransactionType],
TransactionDescription = data.Result[ctr][AllChannelTransactionResultKeyName.Name] + " " + data.Result[ctr][AllChannelTransactionResultKeyName.Trailer],
Branch = data.Result[ctr][AllChannelTransactionResultKeyName.Branch],
Amount = Formatter.GetParsedDouble(data.Result[ctr][AllChannelTransactionResultKeyName.Amount], false)
});
}
}
}
}
catch (Exception e)
{
}
return(transaction);
}
public static CreditCardRetrieveMultipleStatementDate RetrieveCreditCardStatementDates(Params request)
{
CreditCardRetrieveMultipleStatementDate response = new CreditCardRetrieveMultipleStatementDate();
try
{
if (request.Parameter.ContainsKey("cardNo"))
{
string cardNo = request.Parameter["cardNo"];
CreditCardInformation information = RetrieveCreditCardDetail(cardNo, RetrieveCreditCardType(cardNo));
if (!string.IsNullOrEmpty(information.CustomerNo))
{
request.Parameter.Add("custNo", information.CustomerNo);
}
}
if (request.Parameter.ContainsKey("custNo"))
{
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
param.RequestTransType = "GetHistoryCreditCardTransaction";
param.Parameter.Add("custNo", request.Parameter["custNo"]);
param.WSDL = "CCStatementDateHistory";
ESBData data = EAI.RetrieveESBData(param);
if (data.Result != null && data.Result.Count != 0)
{
response.MinimumPayment = Formatter.GetParsedDouble(data.Result[0]["minPayment"], false);
response.Name = data.Result[0]["name1"];
response.Address1 = data.Result[0]["addr1"];
response.Address2 = data.Result[0]["addr2"];
response.City = data.Result[0]["city"];
}
foreach (StringDictionary eachRecord in data.Result)
{
if (eachRecord.ContainsKey("stateDate"))
{
response.Statements.Add(new CreditCardStatementInformation()
{
StatementDateInJulianFormat = eachRecord["stateDate"],
StatementDate = Formatter.ParseExact(eachRecord["stateDate"], "JY")
});
}
}
}
}
catch (Exception e)
{
}
return(response);
}
public static List <CreditCardApplicationStatus> Inquiry(Params request)
{
List <CreditCardApplicationStatus> records = new List <CreditCardApplicationStatus>();
try
{
request.WSDL = "ESBDBDelimiter";
ESBData data = EAI.RetrieveESBData(request);
if (data.Result != null && data.Result.Count > 0)
{
CreditCardApplicationStatus record = null;
foreach (StringDictionary entry in data.Result)
{
record = new CreditCardApplicationStatus();
DateTime?birthDate = Formatter.ParseExact(entry["dob"], "ddMMyyyy HH:mm:ss");
DateTime?approvedDate = Formatter.ParseExact(entry["date_approved"], "ddMMyyyy HH:mm:ss");
DateTime?canceledDate = Formatter.ParseExact(entry["date_cancelled"], "ddMMyyyy HH:mm:ss");
DateTime?createdDate = Formatter.ParseExact(entry["date_created"], "ddMMyyyy HH:mm:ss");
DateTime?receivedDate = Formatter.ParseExact(entry["date_received"], "ddMMyyyy HH:mm:ss");
DateTime?recommendedDate = Formatter.ParseExact(entry["date_recommended"], "ddMMyyyy HH:mm:ss");
DateTime?rejectDate = Formatter.ParseExact(entry["date_reject"], "ddMMyyyy HH:mm:ss");
DateTime?verifiedDate = Formatter.ParseExact(entry["date_verified"], "ddMMyyyy HH:mm:ss");
record.CustomerName = entry["fullname"];
record.BirthDate = Formatter.ToStringExact(birthDate, "dd/MM/yyyy HH:mm:ss");
record.Birthplace = entry["birth_place"];
record.CustomerNumber = entry["cust_no"];
record.ApplicationId = entry["app_id"];
record.ReferenceNo = entry["ref_no"];
record.Purpose = entry["purpose"];
record.Status = entry["status"];
record.CurrentHolder = entry["current_holder"];
record.OriginatingBranch = entry["originator_branch"];
record.Remark = entry["remark"];
record.SourceCode = entry["source_code"];
record.DateReceived = Formatter.ToStringExact(receivedDate, "dd/MM/yyyy HH:mm:ss");
record.DateCreated = Formatter.ToStringExact(createdDate, "dd/MM/yyyy HH:mm:ss");
record.DateRecommended = Formatter.ToStringExact(recommendedDate, "dd/MM/yyyy HH:mm:ss");
record.DateCanceled = Formatter.ToStringExact(canceledDate, "dd/MM/yyyy HH:mm:ss");
record.DateVerified = Formatter.ToStringExact(verifiedDate, "dd/MM/yyyy HH:mm:ss");
record.DateApproved = Formatter.ToStringExact(approvedDate, "dd/MM/yyyy HH:mm:ss");
record.DateReject = Formatter.ToStringExact(rejectDate, "dd/MM/yyyy HH:mm:ss");
record.Comment = entry["comment"];
record.Creator = entry["creator"];
records.Add(record);
}
}
}
catch (Exception e)
{
}
return(records);
}
public static void BuildInternetBankingIndividualInquiryStatus(ref List <KlikBCAIndividuInfo> data, ESBData information, ESBData tandem, string updateOfficerKeyName)
{
if (information != null && information.Result.Count != 0)
{
KlikBCAIndividuInfo klikbcaindividu = new KlikBCAIndividuInfo();
klikbcaindividu.UserID = information.Result[0][ESBKeyValueName.KBI_UserId];
klikbcaindividu.Name = information.Result[0][ESBKeyValueName.KBI_Name];
klikbcaindividu.AtmCardNo = information.Result[0][ESBKeyValueName.KBI_ATMCardNo];
klikbcaindividu.EmailAddress = information.Result[0][ESBKeyValueName.KBI_EmailAddress];
klikbcaindividu.RegistrationDate = Utility.ParseExact(information.Result[0][ESBKeyValueName.KBI_RegistrationDate], "MM/dd/yyyy hh:mm:ss tt");
klikbcaindividu.CreatedDate = Utility.ParseExact(information.Result[0][ESBKeyValueName.KBI_CreatedDate], "MM/dd/yyyy hh:mm:ss tt");
klikbcaindividu.LastLoginDate = Utility.ParseExact(information.Result[0][ESBKeyValueName.KBI_LastLoginDate], "MM/dd/yyyy hh:mm:ss tt");
klikbcaindividu.LastUpdateDate = Utility.ParseExact(information.Result[0][ESBKeyValueName.KBI_LastUpdateDate], "MM/dd/yyyy hh:mm:ss tt");
klikbcaindividu.UpdateBy = information.Result[0][ESBKeyValueName.KBI_UpdateBy];
klikbcaindividu.WrongPinCounter = information.Result[0][ESBKeyValueName.KBI_WrongPinCounter];
klikbcaindividu.BlockStatusKey = information.Result[0][ESBKeyValueName.KBI_BlockStatus];
klikbcaindividu.BlockStatus = Utility.GetStringMap(1, 1, klikbcaindividu.BlockStatusKey);
klikbcaindividu.UserIdIBankStatusKey = information.Result[0][ESBKeyValueName.KBI_UserIdStatus];
klikbcaindividu.UserIdIBankStatus = Utility.GetStringMap(1, 0, klikbcaindividu.UserIdIBankStatusKey);
klikbcaindividu.ChangePasswordCounter = information.Result[0][ESBKeyValueName.KBI_ChangePasswordCounter];
klikbcaindividu.Disclaimer = information.Result[0][ESBKeyValueName.KBI_Disclaimer];
klikbcaindividu.Language = Utility.GetStringMap(1, 10, information.Result[0][ESBKeyValueName.KBI_Language]);
klikbcaindividu.EmailStatus = information.Result[0][ESBKeyValueName.KBI_EmailStatus];
klikbcaindividu.ReferenceNo = information.Result[0][ESBKeyValueName.KBI_ReferenceNo];
Params reqmalware = new Params()
{
Parameter = new Dictionary <string, string>()
};
reqmalware.Parameter = new Dictionary <string, string>();
reqmalware.RequestTransType = "GetMalwareStatusByUserId";
reqmalware.Parameter.Add("cust_id", information.Result[0][ESBKeyValueName.KBI_UserId]);
reqmalware.WSDL = "CallStoreProcedure";
ESBData malware = EAI.RetrieveESBData(reqmalware);
if (malware.Result != null && malware.Result.Count != 0)
{
klikbcaindividu.MalwareStatusKey = malware.Result[0]["blockstatus"];
klikbcaindividu.MalwareStatus = Utility.GetStringMap(1, 9, klikbcaindividu.MalwareStatusKey);
klikbcaindividu.MalwareBlockedDate = malware.Result[0]["createddate"];
klikbcaindividu.MalwareLastUpdate = malware.Result[0]["lastupdate"];
}
if (tandem != null)
{
if (tandem.Result.Count != 0)
{
klikbcaindividu.TandemStatusKey = tandem.Result[0][ESBKeyValueName.KBI_TandemStatus];
klikbcaindividu.TandemStatus = Utility.GetStringMap(1, 4, klikbcaindividu.TandemStatusKey);
}
}
data.Add(klikbcaindividu);
}
}
public static Merchant Search(Params request)
{
Merchant merchant = new Merchant();
try
{
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
param.RequestTransType = "GetMerchantInfoByTerminalIdFromTandem";
param.Parameter.Add("merchantId", request.Parameter.ContainsKey("merchantId") ? request.Parameter["merchantId"].Trim() : string.Empty);
param.WSDL = "POSManagement";
ESBData tandem = EAI.RetrieveESBData(param);
if (tandem.Result != null && tandem.Result.Count > 0)
{
string retailerId = tandem.Result[0]["retailerId"];
if (retailerId.Length == 12)
{
request.Parameter = new Dictionary <string, string>();
request.Parameter.Add("merchantOrgn", "005");
request.Parameter.Add("merchantAcct", retailerId.Substring(3));
request.WSDL = "Merchant";
ESBData data = EAI.RetrieveESBData(request);
merchant.Account = data.Result[0]["acct"];
merchant.Name = data.Result[0]["idName"];
merchant.City = data.Result[0]["idCity"];
merchant.Address1 = data.Result[0]["address1"];
merchant.Address2 = data.Result[0]["address2"];
merchant.Address3 = data.Result[0]["address3"];
merchant.Address4 = data.Result[0]["address4"];
merchant.ZipCode = data.Result[0]["zipCode"];
merchant.TelephoneNo = data.Result[0]["phoneNmbr"];
merchant.MerchantName = data.Result[0]["merchantName"];
merchant.UserNumber = data.Result[0]["edUserNbr"];
merchant.TandemMerchantName = tandem.Result[0]["merchantname"];
merchant.RetailerId = tandem.Result[0]["retailerid"];
merchant.RetailerGroup = tandem.Result[0]["retailergroup"];
merchant.MerchantType = Utility.GetDisplayText("StatusMapper", "Merchant", "Jenis Merchant", tandem.Result[0]["merchanttype"]);
merchant.TerminalType = tandem.Result[0]["terminaltype"];
merchant.TerminalStatus = Utility.GetDisplayText("StatusMapper", "Merchant", "Terminal Status", tandem.Result[0]["terminalstatus"]);
merchant.TerminalId = param.Parameter["merchantId"];
}
}
}
catch (Exception e)
{
}
return(merchant);
}
public static ChangeStatusResult WriteToLog(Params request)
{
ChangeStatusResult result = new ChangeStatusResult();
request.WSDL = "ESBDBDelimiter";
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count != 0)
{
result.Status = (string.Compare(data.Result[0]["result"], "1", false, CultureInfo.InvariantCulture) == 0 || string.Compare(data.Result[0]["result"], "success", true, CultureInfo.InvariantCulture) == 0) ? ChangeStatusResultType.Success : ChangeStatusResultType.Failure;
}
return result;
}
public static ChangeStatusResult Token(Params request)
{
ChangeStatusResult result = new ChangeStatusResult();
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count != 0)
{
result.Status = data.Result[0]["status"] == "Success" ? ChangeStatusResultType.Success : ChangeStatusResultType.Failure;
result.UpdateTime = data.Result[0].ContainsKey("updateTime") ? data.Result[0]["updateTime"] : string.Empty;
}
return result;
}
public ChangeStatusResult TokenValidate(Params request)
{
ChangeStatusResult result = new ChangeStatusResult();
request.WSDL = "TokenAuthentication";
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count != 0)
{
result.Status = data.Result[0].ContainsKey("result") ? ChangeStatusResultType.Success : ChangeStatusResultType.Failure;
result.Result = data.Result[0].ContainsKey("result") ? data.Result[0]["result"] : data.Result[0]["reason"];
}
return result;
}
public static string AtmNoBCAByPhone(Params request)
{
string atmNo = null;
request.WSDL = "UserPhoneBankingInquiry";
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count > 0)
{
atmNo = data.Result[0]["atmno"];
}
return(atmNo);
}
public static List <MBCAInfo> MBLF(Params request)
{
List <MBCAInfo> mbca = new List <MBCAInfo>();
request.WSDL = "ESBDBDelimiter";
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count != 0)
{
foreach (StringDictionary entry in data.Result)
{
MBCAInfo model = new MBCAInfo();
if (!string.IsNullOrEmpty(entry["mb_custid"]))
{
model.MobileNo = entry["mb_custid"];
}
if (model.AtmNo == null)
{
model.AtmNo = entry["mb_cardnumber"];
}
model.CustomerName = entry["mb_custname"];
model.ActivationDate = Utility.ParseExact("mb_createddate", "MM/dd/yyyy hh:mm:ss tt");
model.LastTransactionDate = Utility.ParseExact(entry["mb_lastlogindate"], "MM/dd/yyyy hh:mm:ss tt");
model.LastUpdateDate = Utility.ParseExact(entry["mb_lastupdate"], "MM/dd/yyyy hh:mm:ss tt");
model.UpdateBy = entry["mb_updateofficer"];
model.WrongPinCounter = entry["mb_trlcnt"];
model.PinActivation = entry["mb_flagfin"];
model.ActivationFinDate = Utility.ParseExact(entry["mb_flagfindate"], "MM/dd/yyyy hh:mm:ss tt");
model.ActivationFin = entry["mb_userfin"];
model.BlockStatusKey = entry["mb_status"];
model.BlockStatus = Utility.GetStringMap(2, 1, model.BlockStatusKey);
model.ChangePinCounter = entry["mb_pswdchgflag"];
model.Disclaimer = entry["mb_agree"];
model.Language = Utility.GetStringMap(2, 10, entry["mb_language"]);
model.TandemCustomerName = entry["mblf_name"];
string blockstatus = entry["mblf_useridstatus"];
model.TandemBlockStatus = string.IsNullOrEmpty(blockstatus) ? string.Empty : Utility.GetStringMap(2, 1, blockstatus);
model.TandemCardNo = entry["mblf_crdnum"];
model.TandemRegistrationDate = Utility.ParseExact(entry["mblf_regdate"], "yyMMdd");
model.TandemRegistrationTime = Utility.ParseExact(entry["mblf_regtime"], "HHmmss");
model.TandemHpNo = entry["mblf_hpnum"];
mbca.Add(model);
}
}
return(mbca);
}
public static ChangeStatusResult ReleaseMalwareIB(Params request)
{
ChangeStatusResult result = new ChangeStatusResult();
request.WSDL = "CallStoreProcedure";
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count != 0)
{
result.Result = data.Result[0]["status"];
result.Status = data.Result[0]["status"] == "SUCCESS" ? ChangeStatusResultType.Success : ChangeStatusResultType.Failure;
}
return(result);
}
public static ChangeStatusResult CorporateCard(Params request)
{
ChangeStatusResult result = new ChangeStatusResult();
request.WSDL = "CorporateCardBlock";
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count != 0)
{
result.Status = data.Result[0]["BlockType"] == "B" ? ChangeStatusResultType.Success : ChangeStatusResultType.Failure;
result.Result = "Card Number : " + data.Result[0]["CardNumber"] + " - Block Type : " + data.Result[0]["BlockType"] + " - Reason Code : " + data.Result[0]["ReasonCode"];
}
return(result);
}
private static bool CheckRestrictedAccount(string AccountNo)
{
bool restricted = false;
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
param.RequestTransType = "GetAccountDetail";
param.Parameter.Add("acctNo", AccountNo);
param.WSDL = "AccountDetail";
ESBData data = EAI.RetrieveESBData(param);
if (data.Result != null && data.Result.Count > 0)
{
restricted = string.IsNullOrEmpty(data.Result[0]["miscStatus"]) ? false : data.Result[0]["miscStatus"] == "1" ? true : false;
}
return(restricted);
}
public static List <SMSTopUpInfo> SMSTopUp(Params request)
{
List <SMSTopUpInfo> smstopup = new List <SMSTopUpInfo>();
string mobileNo = null;
request.WSDL = "ESBDBDelimiter";
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count > 0)
{
foreach (StringDictionary entry in data.Result)
{
mobileNo = entry["custid"];
SMSTopUpRetrieveByMobileNumber(ref smstopup, mobileNo);
}
}
return(smstopup);
}
public static void SMSTopUpRetrieveByMobileNumber(ref List <SMSTopUpInfo> smstopup, string mobileNo)
{
if (mobileNo != null)
{
Params param = new Params()
{
Parameter = new Dictionary <string, string>()
};
param.WSDL = "ESBDBDelimiter";
param.RequestTransType = "GetTopUpInfoByMobileNo";
param.Parameter.Add("mobileNo", mobileNo);
ESBData data = EAI.RetrieveESBData(param);
if (data != null && data.Result.Count != 0)
{
foreach (StringDictionary entry in data.Result)
{
SMSTopUpInfo model = new SMSTopUpInfo();
DateTime?registrationDate = Utility.ParseExact(entry[ESBKeyValueName.SMSTopUp_RegistrationDate], "MM/dd/yyyy hh:mm:ss tt");
DateTime?lastRegistrationDate = Utility.ParseExact(entry[ESBKeyValueName.SMSTopUp_LastRegistrationDate], "MM/dd/yyyy hh:mm:ss tt");
DateTime?lastTransactionDate = Utility.ParseExact(entry[ESBKeyValueName.SMSTopUp_LastTransactionDate], "MM/dd/yyyy hh:mm:ss tt");
DateTime?updateDate = Utility.ParseExact(entry[ESBKeyValueName.SMSTopUp_UpdateDate], "MM/dd/yyyy hh:mm:ss tt");
model.AtmCardNo = entry[ESBKeyValueName.SMSTopUp_ATMCardNo];
model.CardholderName = entry[ESBKeyValueName.SMSTopUp_CardholderName];
model.MobileNumber = mobileNo;
model.RegistrationDate = registrationDate;
model.LastRegistrationDate = lastRegistrationDate;
model.LastTransactionDate = lastTransactionDate;
model.smsTopUpKey = entry[ESBKeyValueName.SMSTopUp_Status];
//model.smsTopUp = Utility.GetStringMap(3, 4, entry[ESBKeyValueName.SMSTopUp_Status]);
model.smsTopUp = Utility.GetStringMap(3, 1, model.smsTopUpKey);
model.CounterCodeAccess = entry[ESBKeyValueName.SMSTopUp_CounterCodeAccess];
model.ProviderCode = entry[ESBKeyValueName.SMSTopUp_ProviderCode];
model.UpdateOfficer = entry[ESBKeyValueName.SMSTopUp_UpdateOfficer];
model.UpdateDate = updateDate;
smstopup.Add(model);
}
}
}
}
public static List <SMSBCAInfo> SMSBCA(Params request)
{
List <SMSBCAInfo> smsbca = new List <SMSBCAInfo>();
string mobileNo = null;
request.WSDL = "ESBDBDelimiter";
ESBData data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count > 0)
{
foreach (StringDictionary entry in data.Result)
{
SMSBCAInfo model = new SMSBCAInfo();
DateTime? registrationDate = Utility.ParseExact(entry[ESBKeyValueName.SMSBCA_RegistrationDate], "yyyy/MM/dd HH:mm:ss");
DateTime? lastRegistrationDate = Utility.ParseExact(entry[ESBKeyValueName.SMSBCA_LastRegistrationDate], "yyyy/MM/dd HH:mm:ss");
DateTime? lastTransactionDate = Utility.ParseExact(entry[ESBKeyValueName.SMSBCA_LastTransactionDate], "yyyy/MM/dd HH:mm:ss");
DateTime? updateDate = Utility.ParseExact(entry[ESBKeyValueName.SMSBCA_UpdateDate], "yyyy/MM/dd HH:mm:ss");
if (!request.Parameter.ContainsKey("mobileNo"))
{
mobileNo = entry["custid"];
}
model.AccessCodeCounter = entry[ESBKeyValueName.SMSBCA_CounterCodeAccess];
model.AtmCardNo = request.Parameter.ContainsKey("atmNo") ? request.Parameter["atmNo"] : entry[ESBKeyValueName.SMSBCA_AtmCardNo];
model.CardOwnerName = entry[ESBKeyValueName.SMSBCA_CustomerName];
model.MobileNumber = mobileNo;
model.LastRegistrationDate = lastRegistrationDate;
model.LastTransactionDate = lastTransactionDate;
model.StatusKey = entry[ESBKeyValueName.SMSBCA_Status];
//model.Status = Utility.GetStringMap(6, 4, entry[ESBKeyValueName.SMSBCA_Status]);
model.Status = Utility.GetStringMap(6, 1, model.StatusKey);
model.RegistrationDate = registrationDate;
model.UpdateDate = updateDate;
model.UpdateOfficer = entry[ESBKeyValueName.SMSBCA_UpdateOfficer];
smsbca.Add(model);
}
}
return(smsbca);
}
public static CreditCard SpecificCreditCard(Params request)
{
CreditCard creditcard = new CreditCard();
string cisNo = request.Parameter["cisNo"];
string cardNo = request.Parameter["acctNo"];
if (string.IsNullOrEmpty(cisNo) || string.IsNullOrEmpty(cardNo))
{
return(creditcard);
}
ESBData data = new ESBData()
{
Result = new List <StringDictionary>()
};
request.RequestTransType = "SearchSpecificCreditCardByCIS";
request.WSDL = "CustomerSpecificProductInquiry";
data = EAI.RetrieveESBData(request);
if (data != null && data.Result.Count != 0)
{
for (int i = 0; i < data.Result.Count; i++)
{
if ((string.Compare(data.Result[i]["cardno"], cardNo, StringComparison.InvariantCulture) == 0) &&
(Convert.ToInt32(data.Result[i]["cctype"]) <= Convert.ToInt32(ConfigurationManager.AppSettings["MaxValidCCType"].ToString())))
{
creditcard.CreditCardCustomerNo = data.Result[0]["custno"];
creditcard.CreditCardNumber = data.Result[i]["cardno"];
creditcard.CardholderName = data.Result[i]["shortname"];
creditcard.CardType = data.Result[i]["ccdesc"];
creditcard.CCType = data.Result[i]["cctype"];
break;
}
}
}
return(creditcard);
}