public void TestDepositMoneyToBankAccount()
        {
            DepositMoneyToBankAcountRQ request = new DepositMoneyToBankAcountRQ();
            request.moneyList = new List<Money>();
            var money = GetTestMoney();
            request.moneyList.Add(money);
            request.userAddressId = "india/mh/pune/kharadi/6bef105a11ee406a8189404653d0895f-1";

            request.bankAccountDetails = new DepositMoneyToBankAcountRQ.BankAccountDetails();
            request.bankAccountDetails.name = "Sujan";
            request.bankAccountDetails.accountNo = "00391160018340";
            request.bankAccountDetails.ifsc = "HDFC0000039";

            MadMoneyService madMoneyService = new MadMoneyService();

            var result = madMoneyService.DepositMoneyToBankAccount(request);

            Assert.IsTrue(result);
        }
        public void Store(DepositMoneyToBankAcountRQ request, int totalAmount)
        {
            string spName = "sp_RefundRequest_Insert";
            try
            {
                SqlCommand cmd = new SqlCommand(spName, CON);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@UserAddressId", request.userAddressId);
                cmd.Parameters.AddWithValue("@TotalAmount", totalAmount);
                cmd.Parameters.AddWithValue("@Name", request.bankAccountDetails.name);
                cmd.Parameters.AddWithValue("@AccountNo", request.bankAccountDetails.accountNo);
                cmd.Parameters.AddWithValue("@IFSC", request.bankAccountDetails.ifsc);
                CON.Open();
                cmd.ExecuteNonQuery();
            }
            catch (Exception e) { throw new Exception("Error while connecting database", e); }
            finally { if (CON != null)CON.Close(); }

            //store in Db
        }