using AnalyticsDAL.DTO.AnalysisQuery;
using GB5Shared.DTO.Framework.Login;
using System.Data.Common;

namespace AnalyticsDAL.CustomCode.AnalysisQuery
{
    public interface IAnalysisQueryDAL
    {
        Task<string> GetAnalysisQuery(int analysisQueryId, LoginDTO login, CancellationToken ct);
        Task<string> GetSelectListAnalysisQuery(int analysisId, LoginDTO login, CancellationToken ct);
        Task<string> GetAnalysisFieldsForDesigner(int analysisId, int analysisQueryId, LoginDTO login, CancellationToken ct);

        /// <summary>When <paramref name="tx"/> is supplied, the caller owns the transaction's
        /// lifecycle (begin/commit/rollback/dispose) — this method only participates in it and
        /// does not commit/rollback/dispose it. When omitted, this method self-manages its own
        /// transaction exactly as before (back-compat default for existing callers).</summary>
        Task<string> SaveAnalysisQuery(AnalysisQueryDTO dto, LoginDTO login, bool isNew, CancellationToken ct, DbTransaction tx = null);
        Task<string> DeleteAnalysisQuery(int analysisQueryId, LoginDTO login, CancellationToken ct);

        /// <summary>Unscoped by TenantId — used only by DatasetResolver to reject DIRECT-type
        /// queries (see AnalysisQueryQB.GET_ANALYSISQUERY_TYPE_AND_ANALYSISID) and to find the
        /// owning AnalysisId. Returns null if the query doesn't exist.</summary>
        Task<AnalysisQueryTypeInfoDTO?> GetAnalysisQueryTypeInfo(int analysisQueryId, LoginDTO login, CancellationToken ct);

        /// <summary>BI engine's dimension/measure picker (BICatalogBLL's AnalysisQuery branch)
        /// — see AnalysisQueryQB.GET_BI_DIMENSIONS_FOR_QUERY/GET_BI_MEASURES_FOR_QUERY.</summary>
        Task<List<AnalysisQueryFieldPickerDTO>> GetBIDimensionsForQuery(int analysisQueryId, LoginDTO login, CancellationToken ct);
        Task<List<AnalysisQueryFieldPickerDTO>> GetBIMeasuresForQuery(int analysisQueryId, LoginDTO login, CancellationToken ct);
    }
}