using System.Data.Common;
using EntitlementDAL.DTOs;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.QueryExecutor;

namespace EntitlementDAL.Interfaces;

public interface IChangeRequestDAL
{
    Task<ChangeRequestDTO?> GetByIdAsync(int changeRequestId, LoginDTO login, CancellationToken ct);

    // clientId == -1 -> any client (admin inbox); requestStatus == -1 -> any status
    Task<PagedResult<ChangeRequestListDTO>> GetListPagedAsync(
        int clientId, int requestStatus, int offset, int pageSize, LoginDTO login, CancellationToken ct);

    Task SaveAsync(ChangeRequestDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);

    Task UpdateReviewAsync(
        int changeRequestId, byte requestStatus, int reviewedByUserId, string? reviewComments,
        LoginDTO login, DbTransaction tx, CancellationToken ct);
}