using System.Collections.Generic;
using System.Threading;
using System.Threading.Tasks;
using FrameworkDAL.DTO.MetaReport;
using GB5Shared.DTO.Framework.Login;

namespace FrameworkDAL.CustomCode.MetaReport
{
    public interface IMetaReportDAL
    {
        Task<MetaReportDTO?> GetMetaReport(int metaReportId, LoginDTO loginDTO, CancellationToken ct);
        Task<List<MetaReportListItemDTO>> GetMetaReportList(LoginDTO loginDTO, CancellationToken ct);
        Task<List<MetaReportVariantDTO>> GetVariantsByMetaReportId(int metaReportId, LoginDTO loginDTO, CancellationToken ct);
        Task<List<MetaReportAspectDTO>> GetAspectsByMetaReportId(int metaReportId, LoginDTO loginDTO, CancellationToken ct);
        Task<List<MetaReportAspectOptionDTO>> GetOptionsByAspectIds(IEnumerable<int> aspectIds, LoginDTO loginDTO, CancellationToken ct);

        /// <summary>Returns raw OptionId/VariantId link rows — the BLL groups them per option.</summary>
        Task<List<MetaReportOptionVariantLinkDTO>> GetApplicableVariantsByOptionIds(IEnumerable<int> optionIds, LoginDTO loginDTO, CancellationToken ct);

        /// <summary>Full transactional save of one MetaReport's entire aggregate — the row itself
        /// plus a diff-based reconcile of its Variants, Aspects, and each Aspect's Options, plus a
        /// full replace of every surviving/new option's MMETAREPORTOPTIONVARIANT applicability
        /// links. Every child collection is resent whole by the caller (BLL), matching this
        /// codebase's established diff-save convention (SkillProcessStageMapDAL.Save,
        /// MenuGroupDAL.SaveMenuGroupDetail) — see MetaReportDAL.SaveMetaReportDefinition's own
        /// remarks for the exact statement ordering and why it's FK-safe.</summary>
        Task SaveMetaReportDefinition(MetaReportDTO dto, bool isNewMetaReport, LoginDTO loginDTO, CancellationToken ct);

        Task DeleteMetaReport(int metaReportId, LoginDTO loginDTO, CancellationToken ct);
    }
}