using GB5Shared.DTO.Framework.Login;
using QMSDAL.DTO;
using System.Data.Common;

namespace QMSDAL.CustomCode.PcsCardStage
{
    public interface IPcsCardStageDAL
    {
        Task<IEnumerable<PcsCardStageDTO>> GetByCardIdAsync(int pcsCardId, LoginDTO login, CancellationToken ct = default);

        Task<PcsCardStageDTO?> GetByIdAsync(int pcsCardStaeId, LoginDTO login, CancellationToken ct = default);

        Task InsertManyAsync(IEnumerable<PcsCardStageDTO> stages, LoginDTO login, DbTransaction tx, CancellationToken ct = default);

        Task OpenStageAsync(int pcsCardStaeId, int operatorId, LoginDTO login, DbTransaction tx, CancellationToken ct = default);

        Task SetChecklistLogIdAsync(int pcsCardStaeId, int checklistLogId, LoginDTO login, DbTransaction tx, CancellationToken ct = default);

        Task CompleteStageAsync(int pcsCardStaeId, int supervisorId, byte stageResult, string? remarks, LoginDTO login, DbTransaction tx, CancellationToken ct = default);

        Task SetNcrStatusAsync(int pcsCardStaeId, string description, LoginDTO login, DbTransaction tx, CancellationToken ct = default);

        Task SkipStageAsync(int pcsCardStaeId, int supervisorId, string reason, LoginDTO login, DbTransaction tx, CancellationToken ct = default);

        Task<int> GetCompletedCountAsync(int pcsCardId, LoginDTO login, CancellationToken ct = default);

        Task<PcsCardStageDTO?> GetNextPendingAsync(int pcsCardId, short afterStageno, LoginDTO login, CancellationToken ct = default);

        Task<IEnumerable<RoutingDetailForPcsDTO>> GetRoutingDetailForSkuAsync(int routingId, int routingVersionId, LoginDTO login, CancellationToken ct = default);
    }
}