PUSH_JOB/SendMail/Repository/SendRepository.cs

using JMETxnPushScheduler.Business;
using JMETxnPushScheduler.DAO;
using System.Data;

namespace JMETxnPushScheduler.Repository
{
    public class SendRepository 
    {
        SwiftDao _dao = new SwiftDao();

        
        public DataTable GetMailDetails()
        {
                var sql = "EXEC proc_SendMail @flag = 'sendMial'";
                 
                 
            return _dao.ExecuteDataTable(sql);
        }
        public DataTable ErrorEmail()
        {
            var sql = "EXEC proc_SendMail @flag = 'error'";
           
            return _dao.ExecuteDataTable(sql);
        }
       

    }
}