using System.Data.Common;
using EntitlementDAL.DTOs;
using GB5Shared.DTO.Framework.Login;

namespace EntitlementDAL.Interfaces;

public interface IDemoDAL
{
    Task<DemoVariantDTO?> GetVariantByIdAsync(int demoVariantId, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<DemoVariantDTO>> GetVariantListAsync(LoginDTO login, CancellationToken ct);
    Task SaveVariantAsync(DemoVariantDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task UpdateVariantAsync(DemoVariantDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);

    Task<DemoPoolInstanceDTO?> GetPoolInstanceByIdAsync(int demoPoolInstanceId, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<DemoPoolInstanceDTO>> GetPoolInstancesByVariantAsync(int demoVariantId, LoginDTO login, CancellationToken ct);
    Task<DemoPoolInstanceDTO?> GetOneAvailablePoolInstanceAsync(int demoVariantId, LoginDTO login, CancellationToken ct);
    Task SavePoolInstanceAsync(DemoPoolInstanceDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task UpdatePoolInstanceAsync(DemoPoolInstanceDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task UpdatePoolInstanceStateAsync(int demoPoolInstanceId, byte poolState, LoginDTO login, DbTransaction tx, CancellationToken ct);

    /// <summary>Optimistic claim — only actually flips the row if it's still Available at write
    /// time. Returns true iff this call is the one that won the race.</summary>
    Task<bool> TryClaimPoolInstanceAsync(int demoPoolInstanceId, LoginDTO login, DbTransaction tx, CancellationToken ct);

    Task<DemoSessionDTO?> GetSessionByIdAsync(int demoSessionId, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<DemoSessionDTO>> GetSessionListByOwnerAsync(int ownerUserId, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<DemoSessionDTO>> GetSessionsApproachingExpiryAsync(DateTime warningThreshold, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<DemoSessionDTO>> GetExpiredSessionsAsync(DateTime now, LoginDTO login, CancellationToken ct);
    Task SaveSessionAsync(DemoSessionDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task<int> RequestExtensionAsync(int demoSessionId, DateTime requestedOn, string? comment, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task<int> ApproveExtensionAsync(int demoSessionId, DateTime newExpiresOn, int approvedById, DateTime approvedOn, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task<int> RejectExtensionAsync(int demoSessionId, int rejectedById, DateTime rejectedOn, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task<int> MarkWarningIssuedAsync(int demoSessionId, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task<int> MarkExpiredAsync(int demoSessionId, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task<int> MarkTornDownAsync(int demoSessionId, LoginDTO login, DbTransaction tx, CancellationToken ct);

    Task InsertSessionEventAsync(DemoSessionEventDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task<IEnumerable<DemoSessionEventDTO>> GetSessionEventsAsync(int demoSessionId, LoginDTO login, CancellationToken ct);

    /// <summary>Tracker §49 Decision 9 — one row per ClientId, captured at registration.</summary>
    Task<DemoPreferenceDTO?> GetPreferenceByClientIdAsync(int clientId, LoginDTO login, CancellationToken ct);
    Task SavePreferenceAsync(DemoPreferenceDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
}