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