public TransactionDetailsResp TransactionDetails(
[FromBody] TransactionDetailsReq transactionDetailsReq)
{
if (CBNController.ValidateToken(this.Request.Headers.GetValues("Authorization").First <string>().ToString().Substring("Bearer ".Length).Trim()))
{
TransactionDetailsReq transactionDetailsReq1 = new TransactionDetailsReq()
{
StartDate = this.dateConvert(transactionDetailsReq.StartDate),
EndDate = this.dateConvert(transactionDetailsReq.EndDate),
AccountNo = transactionDetailsReq.AccountNo
};
this.logger.Info <TransactionDetailsReq>("Request {@value}", transactionDetailsReq);
CBNIntegration.Models.TransactionDetails[] array = this.cBNIntegrationData.TransactionDetails(transactionDetailsReq1).ToArray();
int length = array.Length;
TransactionDetailsResp transactionDetailsResp = new TransactionDetailsResp()
{
Status = this.success.ResponseCode,
Msg = this.success.ResponseMessage,
Result = array
};
this.logger.Info <TransactionDetailsResp>("Response {@value}", transactionDetailsResp);
return(transactionDetailsResp);
}
TransactionDetailsResp transactionDetailsResp1 = new TransactionDetailsResp()
{
Status = this.failed.ResponseCode,
Msg = this.failed.ResponseMessage
};
this.logger.Info <TransactionDetailsResp>("Response {@value}", transactionDetailsResp1);
return(transactionDetailsResp1);
}
public List <CBNIntegration.Models.TransactionDetails> TransactionDetails(
TransactionDetailsReq transactionDetailsReq)
{
try
{
using (OracleConnection cnn = new OracleConnection(this.connectionString))
{
cnn.Open();
string sql = string.Format(File.ReadAllText(Path.Combine(Directory.GetCurrentDirectory(), this.TransactionDetailsQry), Encoding.UTF8), (object)transactionDetailsReq.AccountNo, (object)transactionDetailsReq.StartDate, (object)transactionDetailsReq.EndDate);
List <CBNIntegration.Models.TransactionDetails> list = cnn.Query <CBNIntegration.Models.TransactionDetails>(sql).ToList <CBNIntegration.Models.TransactionDetails>();
cnn.Close();
return(list);
}
}
catch (Exception ex)
{
return(new List <CBNIntegration.Models.TransactionDetails>());
}
}
