public PendingDebitResp PendingDebit([FromBody] PendingDebitReq pendingDebitReq) { HttpRequestHeaders headers = this.Request.Headers; PendingDebitReq pendingDebitReq1 = new PendingDebitReq() { AccountNo = pendingDebitReq.AccountNo }; if (CBNController.ValidateToken(headers.GetValues("Authorization").First <string>().ToString().Substring("Bearer ".Length).Trim())) { this.logger.Info <PendingDebitReq>("Request {@value}", pendingDebitReq); CBNIntegration.Models.PendingDebit[] array = this.cBNIntegrationData.PendingDebit(pendingDebitReq1).ToArray(); int length = array.Length; PendingDebitResp pendingDebitResp = new PendingDebitResp() { Status = this.success.ResponseCode, Msg = this.success.ResponseMessage, Result = array }; this.logger.Info <PendingDebitResp>("Response {@value}", pendingDebitResp); return(pendingDebitResp); } PendingDebitResp pendingDebitResp1 = new PendingDebitResp() { Status = this.failed.ResponseCode, Msg = this.failed.ResponseMessage }; this.logger.Info <PendingDebitResp>("Response {@value}", pendingDebitResp1); return(pendingDebitResp1); }
public List <CBNIntegration.Models.PendingDebit> PendingDebit( PendingDebitReq pendingDebitReq) { try { using (OracleConnection cnn = new OracleConnection(this.connectionString)) { cnn.Open(); string sql = string.Format(File.ReadAllText(Path.Combine(Directory.GetCurrentDirectory(), this.PendingDebitQry), Encoding.UTF8), (object)pendingDebitReq.AccountNo); List <CBNIntegration.Models.PendingDebit> list = cnn.Query <CBNIntegration.Models.PendingDebit>(sql).ToList <CBNIntegration.Models.PendingDebit>(); cnn.Close(); return(list); } } catch (Exception ex) { return(new List <CBNIntegration.Models.PendingDebit>()); } }