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 MLOYALTYEARNCFG.
    /// </summary>
    public interface ILoyaltyEarnCfgDAL
    {
        /// <summary>
        /// Returns all currently active earn rules for a loyalty program.
        /// "Active" is defined by STATUS=1 and date range coverage — see LoyaltyEarnCfgQB for details.
        /// Results are ordered by RULETYPE DESC (highest specificity first).
        /// </summary>
        Task<IEnumerable<LoyaltyEarnCfgDTO>> GetEarnCfgsByProgram(int programId, LoginDTO login);

        /// <summary>
        /// Inserts a new earn rule within the supplied transaction.
        /// Returns rows affected.
        /// </summary>
        Task<int> InsertLoyaltyEarnCfg(LoyaltyEarnCfgDTO dto, LoginDTO login, DbTransaction? tx);

        /// <summary>
        /// Updates an existing earn rule within the supplied transaction.
        /// Returns rows affected.
        /// </summary>
        Task<int> UpdateLoyaltyEarnCfg(LoyaltyEarnCfgDTO dto, LoginDTO login, DbTransaction? tx);
    }
}