public async Task AddTransferRecipientAccount(CreateTransferRecipient transferRecipient)
        {
            await WithConnection2(async c =>
            {
                string sql = "INSERT INTO BankAccounts(Userid,account_number,account_bank)values(@userid,@account_number,@account_bank)";
                await c.ExecuteAsync(sql, new { @userid = 1, @account_number = transferRecipient.account_number, @account_bank = transferRecipient.code, })
                ;
            });

            //log
        }
        public async Task CreateTransferRecipientAccount(CreateTransferRecipient transferRecipient)
        {
            var TransferClientAccount = new { account_number = transferRecipient.account_number, account_bank = transferRecipient.account_bank, seckey = _configuration["flutterwave:Secret Key"] };

            _httpClient.DefaultRequestHeaders.Add("Accept", "application/json");
            var stringContent = new StringContent(JsonConvert.SerializeObject(TransferClientAccount), Encoding.UTF8,
                                                  "application/json");
            var httpresponse = await _httpClient.PostAsync("https://api.ravepay.co/v2/gpx/transfers/beneficiaries/create", stringContent);

            var response = JsonConvert.DeserializeObject <ResponseData>(await httpresponse.Content.ReadAsStringAsync());

            if (response.data.status == "successful")
            {
                await WithConnection2(async c =>
                {
                    string sql = $"update BankAccounts Set id = @id where  account_number = {transferRecipient.account_number}";
                    // await c.ExecuteAsync(sql,new {response.data.id});
                });
            }
            //log
        }