using GB5Shared.DTO.Framework.Login;
using System;
using System.Data.Common;
using System.Threading;
using System.Threading.Tasks;

namespace FrameworkDAL.CustomCode.Archive
{
    public interface IEventLogArchiveDAL
    {
        /// <summary>
        /// Copies TEVENTLOG rows older than <paramref name="cutoffDate"/> to TEVENTLOG_ARCHIVE.
        /// Must be called inside an open transaction — the caller commits/rolls back.
        /// </summary>
        Task MoveToArchiveAsync(DateTime cutoffDate, LoginDTO login, DbTransaction tx, CancellationToken ct = default);

        /// <summary>
        /// Deletes TEVENTLOG rows older than <paramref name="cutoffDate"/>.
        /// Call AFTER <see cref="MoveToArchiveAsync"/> succeeds, inside the same transaction.
        /// </summary>
        Task DeleteHotRowsAsync(DateTime cutoffDate, LoginDTO login, DbTransaction tx, CancellationToken ct = default);

        /// <summary>Returns hot and archive row counts for logging/health-check.</summary>
        Task<(int HotCount, int ArchiveCount)> GetStatsAsync(LoginDTO login, CancellationToken ct = default);
    }
}