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

namespace EntitlementDAL.Interfaces;

public interface IBetaClientDAL
{
    Task<IEnumerable<BetaClientDTO>> GetListAsync(LoginDTO login, CancellationToken ct);
    Task<IEnumerable<BetaClientDTO>> GetListByClientAsync(int clientId, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<string>> GetOpenProgramsAsync(DateTime now, LoginDTO login, CancellationToken ct);
    Task<bool> IsClientInProgramAsync(int clientId, string betaProgramName, DateTime now, LoginDTO login, CancellationToken ct);
    Task SaveAsync(BetaClientDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task DeleteAsync(int betaClientId, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task<IEnumerable<BetaClientDTO>> GetExpiredActiveAsync(DateTime now, LoginDTO login, CancellationToken ct);

    /// <summary>Finds a client's enrollment row for a program regardless of Status (Active or
    /// soft-deleted) — the unique key (ClientId, BetaProgramName) is not filtered by Status, so a
    /// prior opt-out's row must be found and reactivated on re-enrol, not duplicated.</summary>
    Task<BetaClientDTO?> GetByClientAndProgramAsync(int clientId, string betaProgramName, LoginDTO login, CancellationToken ct);
    Task ReactivateAsync(int betaClientId, DateTime validFrom, DateTime validUntil, LoginDTO login, DbTransaction tx, CancellationToken ct);
}