using System.Collections.Generic;
using System.Data.Common;
using System.Threading.Tasks;
using GB5Shared.DTO.Framework.Login;
using GoodBooks.PAY.PAYDAL.DTO.Loyalty;

namespace GoodBooks.PAY.PAYDAL.CustomCode.Loyalty
{
    /// <summary>
    /// Data-access contract for MLOYALTYTIER.
    /// </summary>
    public interface ILoyaltyTierDAL
    {
        /// <summary>
        /// Returns all tiers for a loyalty program, ordered by SLNO ascending.
        /// </summary>
        Task<IEnumerable<LoyaltyTierDTO>> GetTiersByProgram(int programId, LoginDTO login);

        /// <summary>
        /// Inserts a single tier row within the supplied transaction.
        /// Returns rows affected.
        /// </summary>
        Task<int> InsertLoyaltyTier(LoyaltyTierDTO dto, LoginDTO login, DbTransaction? tx);

        /// <summary>
        /// Returns the highest tier the customer qualifies for based on their lifetime points,
        /// or null if no tier threshold has been reached.
        /// Used during tier-upgrade evaluation after a new earn entry is posted.
        /// </summary>
        Task<LoyaltyTierDTO?> GetTierForPoints(int programId, decimal lifetimePoints, LoginDTO login);
    }
}