using System.Threading.Tasks;
using GB5Shared.DTO.Framework.Login;
using GoodBooks.PAY.PAYDAL.DTO.Webhook;

namespace GoodBooks.PAY.PAYDAL.CustomCode.Webhook
{
    /// <summary>
    /// Data-access contract for TPAYWEBHOOKEVENT.
    /// Insert is IDENTITY-based (returns new PK).
    /// Updates are restricted to status columns only — this is a log table.
    /// </summary>
    public interface IPayWebhookEventDAL
    {
        /// <summary>
        /// Persists an incoming raw webhook event immediately.
        /// Returns the IDENTITY-generated PAYWEBHOOKEVENTID.
        /// </summary>
        Task<int> InsertWebhookEvent(PayWebhookEventDTO dto, LoginDTO login);

        /// <summary>
        /// Updates the SIGNATUREVALID column for an existing event.
        /// Returns rows affected (should be 1).
        /// </summary>
        Task<int> UpdateSignatureValid(int webhookEventId, byte signatureValid, LoginDTO login);

        /// <summary>
        /// Marks the event as processed (or failed) and records the processing error if any.
        /// Returns rows affected (should be 1).
        /// </summary>
        Task<int> UpdateProcessed(int webhookEventId, byte isProcessed, string? error, LoginDTO login);

        /// <summary>
        /// Returns true if an event with the given idempotency key has already been
        /// successfully processed (ISPROCESSED=1) for the specified gateway.
        /// </summary>
        Task<bool> CheckIdempotency(string idempotencyKey, int payGatewayId, LoginDTO login);

        /// <summary>
        /// Returns a paged JSON list of webhook events for admin review.
        /// Supports optional filtering by ISPROCESSED and PAYGATEWAYID.
        /// </summary>
        Task<string> GetWebhookEventList(int pageOffset, int pageSize, LoginDTO login);
    }
}