//using FrameworkDAL.Query.MessageHub;
//using FrameworkDAL.Query.WhatsAppTemplate;
//using GB5Shared.DTO.Framework.Login;
//using GB5Shared.QueryExecutor;
//using GB5Shared.Validation;
//using System;
//using System.Collections.Generic;
//using System.Linq;
//using System.Text;
//using System.Threading.Tasks;

//namespace FrameworkDAL.CustomCode.WhatsAppTemplate
//{
//    public class WhatsAppTemplateDAL : IWhatsAppTemplateDAL
//    {
//        private readonly IQueryExecutor _QueryExecutor;
//        private readonly IValidation _Validation;

//        public WhatsAppTemplateDAL(IQueryExecutor queryExecutor, IValidation validation)
//        {
//            _QueryExecutor = queryExecutor;
//            _Validation = validation;
//        }
//        public async Task<string> GetVisitorPass(int EntityId, LoginDTO LoginDTO)
//        {
//            try
//            {
//                return await _QueryExecutor.QuerySingleAsync<string>(
//                    LoginDTO,
//                   WhatsAppTemplateQB.GET_VISITORPASS,
//                    new { EntityId }
//                );
//            }
//            catch (Exception ex)
//            {
//                string error = await _Validation.HandleException(ex, "Error while fetching MessageHub details.");
//                throw new Exception(error);
//            }
//        }
//}