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

//namespace FrameworkDAL.CustomCode.SchedulerTaskGenerator
//{
//    public interface ISchedulerJobDAL
//    {
//        Task<List<SchedulerTaskDTO>> LoadActiveJobsAsync(LoginDTO login);
//        Task<List<SchedulerActionDTO>> LoadActionsByJobIdsAsync(
//            IEnumerable<int> jobIds,
//            LoginDTO login
//        );
//        Task UpdateLastRunAsync(int jobId, DateTime runOn, LoginDTO login);
//    }

//    public sealed class SchedulerJobDAL : ISchedulerJobDAL
//    {
//        private readonly IQueryExecutor _queryExecutor;

//        public SchedulerJobDAL(IQueryExecutor queryExecutor)
//        {
//            _queryExecutor = queryExecutor;
//        }

//        public async Task<List<SchedulerTaskDTO>> LoadActiveJobsAsync(LoginDTO login)
//        {
//            return (await _queryExecutor.QueryAsync<SchedulerTaskDTO>(
//                login,
//                SchedulerTaskGeneratorQB.LoadActiveJobs,
//                new { }
//            )).ToList();
//        }

//        public async Task<List<SchedulerActionDTO>> LoadActionsByJobIdsAsync(
//            IEnumerable<int> jobIds,
//            LoginDTO login)
//        {
//            return (await _queryExecutor.QueryAsync<SchedulerActionDTO>(
//                login,
//                SchedulerTaskGeneratorQB.LoadActionsByJobIds,
//                new { JobIds = jobIds }
//            )).ToList();
//        }

//        public async Task UpdateLastRunAsync(int jobId, DateTime runOn, LoginDTO login)
//        {
//            await _queryExecutor.ExecuteAsync(
//                login,
//                SchedulerTaskGeneratorQB.UpdateLastRun,
//                new { JobId = jobId, LastRunOn = runOn }
//            );
//        }
//    }

//}