public ListInternalAccountsResp ListInternalAccounts( [FromBody] ListInternalAccountsReq listInternalAccountsReq) { string AuthToken = this.Request.Headers.GetValues("Authorization").First <string>().ToString().Substring("Bearer ".Length).Trim(); ListInternalAccountsReq listInternalAccountsReq1 = new ListInternalAccountsReq() { LedgerCode = listInternalAccountsReq.LedgerCode }; if (CBNController.ValidateToken(AuthToken)) { this.logger.Info <ListInternalAccountsReq>("Request {@value}", listInternalAccountsReq1); CBNIntegration.Models.ListInternalAccounts[] array = this.cBNIntegrationData.ListInternalAccounts(listInternalAccountsReq1).ToArray(); int length = array.Length; ListInternalAccountsResp internalAccountsResp = new ListInternalAccountsResp() { Status = this.success.ResponseCode, Msg = this.success.ResponseMessage, Result = array }; this.logger.Info <ListInternalAccountsResp>("Response {@value}", internalAccountsResp); return(internalAccountsResp); } ListInternalAccountsResp internalAccountsResp1 = new ListInternalAccountsResp() { Status = this.failed.ResponseCode, Msg = this.failed.ResponseMessage }; this.logger.Info <ListInternalAccountsResp>("Response {@value}", internalAccountsResp1); return(internalAccountsResp1); }
public List <CBNIntegration.Models.ListInternalAccounts> ListInternalAccounts( ListInternalAccountsReq listInternalAccountsReq) { try { using (OracleConnection cnn = new OracleConnection(this.connectionString)) { cnn.Open(); string sql = string.Format(File.ReadAllText(Path.Combine(Directory.GetCurrentDirectory(), this.ListInternalAccountsQry), Encoding.UTF8), (object)listInternalAccountsReq.LedgerCode); List <CBNIntegration.Models.ListInternalAccounts> list = cnn.Query <CBNIntegration.Models.ListInternalAccounts>(sql).ToList <CBNIntegration.Models.ListInternalAccounts>(); cnn.Close(); return(list); } } catch (Exception ex) { return(new List <CBNIntegration.Models.ListInternalAccounts>()); } }