using System.Data.Common;
using GB5Shared.DTO.Framework.Login;
using GoodBooks.PAY.PAYDAL.DTO.Cashback;

namespace GoodBooks.PAY.PAYDAL.CustomCode.Cashback
{
    public interface ICashbackLedgerDAL
    {
        Task<string> GetCashbackLedger(int cashbackLedgerId, LoginDTO login);
        Task<string> GetCashbackLedgerList(int customerId, int pageOffset, int pageSize, LoginDTO login);

        /// <summary>Unpaginated — one order's cashback rows are naturally few.</summary>
        Task<string> GetCashbackLedgerListByOrder(int payOrderId, LoginDTO login);

        /// <summary>
        /// Fetches the next batch of up to 50 pending cashback rows whose
        /// ScheduledPayoutOn has passed. Used by the CashbackPayoutJob.
        /// </summary>
        Task<IEnumerable<CashbackLedgerDTO>> GetPendingPayouts(LoginDTO login);

        /// <summary>Inserts a new cashback ledger row within the given transaction.</summary>
        Task<int> SaveCashbackLedger(CashbackLedgerDTO dto, LoginDTO login, DbTransaction? tx);

        /// <summary>Updates payout status, retry count, and optional failure reason/voucher ID.</summary>
        Task<int> UpdatePayoutStatus(CashbackLedgerDTO dto, LoginDTO login);
    }
}