using System;
using System.Collections.Generic;
using System.Threading;
using System.Threading.Tasks;
using FrameworkDAL.DTO.SessionStore;

namespace FrameworkDAL.CustomCode.SessionStore
{
    public interface ISessionStoreDAL
    {
        /// <summary>
        /// Upserts a session row into MSESSIONSTORE in the GB5 system database.
        /// Inserts if the (SERVERCONFIGID, LOGINEVENTLOGID) pair does not exist;
        /// otherwise updates LASTLOGINUSEDTIME.
        /// </summary>
        Task UpsertSessionAsync(SessionStoreDTO dto, CancellationToken ct = default);

        /// <summary>
        /// Updates LASTLOGINUSEDTIME for an existing session (activity heartbeat).
        /// Checks session existence before updating to guard against phantom writes.
        /// </summary>
        Task UpdateSessionAsync(int serverConfigId, int loginEventLogId, DateTime lastUsedTime, CancellationToken ct = default);

        /// <summary>
        /// Deletes the session row from MSESSIONSTORE on logout.
        /// </summary>
        Task DeleteSessionAsync(int serverConfigId, int loginEventLogId, CancellationToken ct = default);

        /// <summary>
        /// Returns the count of session rows matching (SERVERCONFIGID, LOGINEVENTLOGID).
        /// </summary>
        Task<int> GetSessionCountAsync(int serverConfigId, int loginEventLogId, CancellationToken ct = default);

        /// <summary>
        /// Returns idle sessions that have exceeded the configured expiry window.
        /// Used by the auto-logout background job.
        /// </summary>
        Task<IEnumerable<UnusedSessionDTO>> GetUnusedSessionsAsync(int serverConfigId, int expiryMinutes, CancellationToken ct = default);

        /// <summary>
        /// Deletes stale session rows (older than todayDate or orphaned GB5ADMIN rows).
        /// </summary>
        Task DeleteOldSessionsAsync(DateTime todayDate, CancellationToken ct = default);
    }
}