using System.Collections.Generic;
using System.Data.Common;
using System.Threading;
using System.Threading.Tasks;
using GB5Shared.GOP.GBQueryExecutor.DTOs;
using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;

namespace GB5Shared.GOP.GBQueryExecutor
{
    public interface IGBQueryExecutorDAL
    {
        // ── Execution read-only ───────────────────────────────────────
        Task<GBConfiguredQueryDTO?> GetConfiguredQueryByCode(string queryCode, LoginDTO loginDTO);
        Task<GBConfiguredQueryDTO?> GetConfiguredQueryById(int configuredQueryId, LoginDTO loginDTO);
        Task<GBQueryIntentProfileDTO?> GetIntentProfileById(int intentProfileId, LoginDTO loginDTO);
        Task<GBQueryIntentProfileDTO?> GetIntentProfileByCode(string intentCode, LoginDTO loginDTO);
        Task MarkQueryValidated(int configuredQueryId, LoginDTO loginDTO, CancellationToken ct = default);
        Task LogExecution(GBQueryExecutionLogDTO logDto, LoginDTO loginDTO);

        // ── Management CRUD ───────────────────────────────────────────
        // tx is optional (default null) so BaseEntityAppService<GBConfiguredQueryDTO>.ExecuteSaveAsync
        // can supply the transaction it opened — existing non-transactional callers are unaffected.
        Task<int> SaveConfiguredQuery(GBConfiguredQueryDTO dto, LoginDTO loginDTO, DbTransaction? tx = null, CancellationToken ct = default);
        Task UpdateConfiguredQuery(GBConfiguredQueryDTO dto, LoginDTO loginDTO, DbTransaction? tx = null, CancellationToken ct = default);
        Task DeleteConfiguredQuery(int configuredQueryId, LoginDTO loginDTO, CancellationToken ct = default);
        Task<IEnumerable<GBConfiguredQueryDTO>> GetConfiguredQueryList(LoginDTO loginDTO, CancellationToken ct = default);
        Task<IEnumerable<GBQueryIntentProfileDTO>> GetSelectListIntentProfiles(CriteriaDTO criteriaDTO, LoginDTO loginDTO, CancellationToken ct = default);
        Task<IEnumerable<GBConfiguredQueryDTO>> GetSelectListConfiguredQuery(CriteriaDTO criteriaDTO, LoginDTO loginDTO, CancellationToken ct = default);
    }
}