BankingSystem/Repository/DAO/SendTransactionDao/SendTransactionRepo.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Repository.DAO.SendTransactionDao
{
    public class SendTransactionRepo : RemittanceDao,ISendTransactionRepo
    {
        public DataTable GetPayoutPartner(string user, string pCountry, string pMode)
        {
            string sql = "EXEC PROC_API_ROUTE_PARTNERS @flag='payout-partner'";
            sql += " , @CountryId = " + FilterString(pCountry);
            sql += " , @PaymentMethod = " + FilterString(pMode);
            sql += " , @user = " + FilterString(user);

            return ExecuteDataTable(sql);
        }
    }
}