public async Task <AccountEnquiryResponse> GetAccountEnquiryByAccountNumber(AccountEnquiryRequest request)
{
AccountEnquiryResponse ar = new AccountEnquiryResponse();
var oralConnect = new OracleConnection(_protector.Unprotect(_appSettings.FlexConnection));
using (oralConnect)
{
string query = $@"SELECT LPAD(A.BRANCH_CODE,3,0) COD_CC_BRN, A.CUST_AC_NO COD_ACCT_NO, A.AC_DESC COD_ACCT_TITLE,
DECODE(C.ACCOUNT_CLASS,'222','S',C.ac_class_type) ACCOUNT_TYPE,
A.CCY NAM_CCY_SHORT, A.AC_OPEN_DATE DAT_ACCT_OPEN, A.CUST_NO COD_CUST,A.AC_STAT_NO_DR, A.AC_STAT_NO_CR,
A.AC_STAT_BLOCK, A.AC_STAT_STOP_PAY, A.AC_STAT_DORMANT, A.AC_STAT_FROZEN, A.ACCOUNT_CLASS COD_PROD,
A.AC_STAT_DE_POST,C.description ACCOUNTDESC, BR.branch_name BRANCH,A.RECORD_STAT,
A.ACY_AVL_BAL BAL_AVAILABLE, Y.DATE_OF_BIRTH,NVL(Y.TELEPHONE, Y.FAX) CUSTOMER_PHONENUMBER,DECODE(B.CUSTOMER_TYPE,'C','CORPORATE','I','INDIVIDUAL') CUSTOMER_CATEGORY
FROM {_appSettings.FlexSchema}.STTM_CUST_ACCOUNT A
INNER JOIN {_appSettings.FlexSchema}.STTM_CUSTOMER B ON B.CUSTOMER_NO = A.CUST_NO
LEFT OUTER JOIN {_appSettings.FlexSchema}.STTM_CUST_PERSONAL Y ON Y.CUSTOMER_NO = A.CUST_NO
LEFT OUTER JOIN {_appSettings.FlexSchema}.MITB_CLASS_MAPPING D ON D.UNIT_REF_NO = A.CUST_AC_NO
LEFT OUTER JOIN {_appSettings.FlexSchema}.STTM_CUST_CORPORATE Z ON Z.CUSTOMER_NO=A.CUST_NO
LEFT OUTER JOIN {_appSettings.FlexSchema}.STTM_ACCOUNT_CLASS C ON C.account_class = A.account_class
LEFT OUTER JOIN {_appSettings.FlexSchema}.STTM_BRANCH BR ON BR.branch_code = A.branch_code
WHERE A.CUST_AC_NO in (:accountNumber)";
var ars = await oralConnect.QueryAsync <AccountEnquiryResponse>(query, new { request.accountNumber });
ar = ars.FirstOrDefault();
}
return(ar);
}
public async Task <Tuple <Models.Response, Response> > GetAccountEnquiryByAccountNumber(AccountEnquiryRequest request)
{
AccountEnquiryResponse br = new AccountEnquiryResponse();
Response res = new Response();
string reqString; string respMsg = string.Empty; string resultContent = string.Empty;
int respCode = 0;
try
{
using (var client = new HttpClient())
{
reqString = JsonHelper.toJson(request);
var content = new StringContent(reqString, Encoding.UTF8, Constant.CONTENTTYPE);
var result = await client.PostAsync(_settings.baseURL + _settings.aeURL, content);
respCode = (int)result.StatusCode;
respMsg = result.ReasonPhrase;
resultContent = await result.Content.ReadAsStringAsync();
};
}
catch (Exception ex)
{
respCode = (int)HttpStatusCode.InternalServerError;
res = new Response()
{
message = ex.Message,
status = false
};
_logger.LogInformation($"{request.accountNumber} : {ex.ToString()}");
}
res.message = respMsg;
res.status = respCode == (int)HttpStatusCode.Created || respCode == (int)HttpStatusCode.OK;
if (!string.IsNullOrEmpty(resultContent))
{
if (!res.status)
{
res = JsonHelper.fromJson <Response>(resultContent);
}
else
{
br = JsonHelper.fromJson <AccountEnquiryResponse>(resultContent);
}
}
else
{
res = new Response()
{
message = Constant.UKNOWN_MSG,
status = false
};
}
return(new Tuple <Models.Response, Response>(GetAccountEnquiryResponse(br), res));
}
private Models.Response GetAccountEnquiryResponse(AccountEnquiryResponse ar)
{
return(new Models.Response()
{
accountStatusDormant = ar.ac_stat_dormant,
availableBalance = StringToDecimal(ar.bal_available),
codAccountNumber = ar.cod_acct_no,
codAccountTitle = ar.cod_acct_title,
codCcBrn = ar.cod_cc_brn,
dateAccountOpen = ar.dat_acct_open,
phoneNumber = ar.customer_phonenumber
});
}