using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.QueryExecutor;
using MMDAL.DTO.StockReservation;
using System.Data;
using System.Data.Common;

namespace MMDAL.CustomCode.StockReservation;

public interface IStockReservationDAL
{
    Task<string> GetReservationAsync(
        int stockReservationId,
        LoginDTO loginDTO);
    Task<PagedResult<StockReservationListDTO>> GetReservationListAsync(
        int ouId, byte? statusFilter, int? itemId,
        int page, int size,
        LoginDTO loginDTO, CancellationToken ct);
    Task<StockReservationDTO?> GetReservationDtoAsync(
        int stockReservationId, LoginDTO loginDTO, CancellationToken ct);

    Task<IEnumerable<StockReservationListDTO>> GetReservationsByMrpRunAsync(
        int mrpRunId, LoginDTO loginDTO, CancellationToken ct);

    Task<IEnumerable<StoreAvailabilityDTO>> GetStockAvailabilityAsync(
        int ouId, int itemId, int skuId, LoginDTO loginDTO, CancellationToken ct);

    Task<int> CheckDuplicateActiveAsync(
        int forObjectHeaderId, int forObjectId, int itemId, int skuId,
        LoginDTO loginDTO, CancellationToken ct);

    Task<int> InsertReservationAsync(
    StockReservationDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task UpdateReservationNumberAsync(
    int stockReservationId, string reservationNumber,
    LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<int> IncrementStockReservedAsync(
        int ouId, int itemId, int skuId, int storeId, decimal quantity,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<int> DecrementStockReservedAsync(
        int ouId, int itemId, int skuId, int storeId, decimal quantity,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<int> DecrementPipelinePendingAsync(
        int fromAllotedAllocationId, decimal quantity,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<int> IncrementPipelinePendingAsync(
        int fromAllotedAllocationId, decimal quantity,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<int> ReleaseReservationAsync(
        int stockReservationId, short version, string reason,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<int> ReduceReservedQuantityAsync(
        int stockReservationId, short version, decimal releaseQuantity,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task SaveFreeTrackAsync(
        int newId, string reservationNumber,
        StockReservationFreeTrackDTO dto,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<int> MarkReassignedAsync(
        int stockReservationId, short version,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<int> ConfirmTentativeByMrpRunAsync(
        int mrpRunId, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<int> ConfirmOneTentativeAsync(
        int stockReservationId, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<int> UpdateIssuedQuantityAsync(
        int stockReservationId, decimal issuedQty,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<int> MarkSubconOutAsync(
        StockReservationSubconDTO dto,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<int> MarkSubconReturnedAsync(
        int stockReservationId, short version, decimal actualReturnedQty,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task InsertReassignmentLogAsync(
        ReassignmentLogDTO dto, int newLogId,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<IEnumerable<ReassignmentLogDTO>> GetReassignmentLogAsync(
        int stockReservationId, LoginDTO loginDTO, CancellationToken ct);

    Task<IEnumerable<SubconTrackingReportDTO>> GetSubconTrackingAsync(
        int ouId, LoginDTO loginDTO, CancellationToken ct);

    Task BulkInsertReservationsAsync(
        IEnumerable<StockReservationDTO> reservations,
        LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<string> GetSelectListStockReservation(
    int FirstNumber,
    int MaxResult,
    CriteriaDTO criteriaDTO,
    LoginDTO loginDTO,
    bool IsCount = false);
}