public async Task <FundsTransferResponse> ValidateTransactionByRef(_StatusRequest _request)
{
FundsTransferResponse res = new FundsTransferResponse();
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(_appSettings.baseURL + _appSettings.peURL, content);
respCode = (int)result.StatusCode;
respMsg = result.ReasonPhrase;
resultContent = await result.Content.ReadAsStringAsync();
};
}
catch (TaskCanceledException tex)
{
respCode = (int)HttpStatusCode.RequestTimeout;
res = new FundsTransferResponse()
{
message = Constant.TIMEOUT_MSG,
status = Constant.TIMEOUT_STATUS
};
_logger.LogInformation($"{_request.transactionRef} : {tex.ToString()}");
}
catch (Exception ex)
{
respCode = (int)HttpStatusCode.InternalServerError;
res = new FundsTransferResponse()
{
message = ex.Message,
status = Constant.FAILED_STATUS
};
_logger.LogInformation($"{_request.transactionRef} : {ex.ToString()}");
}
if (!string.IsNullOrEmpty(resultContent))
{
res = JsonHelper.fromJson <FundsTransferResponse>(resultContent);
}
else
{
res.message = Constant.UKNOWN_MSG;
res.status = Constant.UKNOWN_STATUS;
}
return(res);
}
public async Task <FundsTransferResponse> ValidateTransactionByRef(string transactionRef)
{
FundsTransferResponse response = new FundsTransferResponse();
var oralConnect = new OracleConnection(_protector.Unprotect(_appSettings.FlexConnection));
using (oralConnect)
{
string query = $@"SELECT * FROM {_appSettings.FlexSchema}.ACTB_DAILY_LOG WHERE AUTH_STAT = ‘A’ AND TRN_REF_NO = :transactionRef";
var r = await oralConnect.QueryAsync <string>(query, new { transactionRef });
response.message = r.FirstOrDefault();
if (!string.IsNullOrWhiteSpace(response.message))
{
response.status = "true";
}
}
return(response);
}
