using System.Collections.Generic;
using System.Data.Common;
using System.Threading;
using System.Threading.Tasks;
using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using PayRollDAL.DTO.PayRevision;

namespace PayRollDAL.CustomeCode.PayRevision
{
    public interface IPayRevisionDAL
    {
        Task<PayRevisionDTO> GetPayRevision(int PayRevisionId, LoginDTO LoginDTO, CancellationToken ct = default);
        Task<string> GetSelectListPayRevision(int FirstNumber, int MaxResult, CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, CancellationToken ct = default);
        Task<int> SavePayRevision(PayRevisionDTO PayRevisionDTO, LoginDTO LoginDTO, DbTransaction trans, CancellationToken ct = default);
        Task<int> UpdatePayRevision(PayRevisionDTO PayRevisionDTO, LoginDTO LoginDTO, DbTransaction trans, CancellationToken ct = default);
        Task<string> DeletePayRevision(int PayRevisionId, LoginDTO LoginDTO, DbTransaction trans, CancellationToken ct = default);
        Task<IEnumerable<PayRevisionDTO>> GetPayRevisionList(CriteriaDTO criteriaDTO, LoginDTO LoginDTO, CancellationToken ct = default);

        // ? Add these methods
        Task<int> SavePayRevisionAddon(long payRevisionId, string feAddon, LoginDTO LoginDTO, DbTransaction trans, CancellationToken ct = default);
        Task DeletePayRevisionAddon(int PayRevisionId, LoginDTO LoginDTO, DbTransaction trans, CancellationToken ct = default);
       
        Task<int> CheckPayProcessExists(int PayRevisionId, LoginDTO LoginDTO, CancellationToken ct = default);
        Task<List<PayRevisionDTO>> GetPreviousRevisionByScope(PayRevisionDTO dto, LoginDTO LoginDTO, DbTransaction trans, CancellationToken ct = default);
        Task UpdatePreviousRevision(int PayRevisionId, DateOnly effectiveTo, LoginDTO LoginDTO, DbTransaction trans, CancellationToken ct = default);
        Task<int> CheckNewerRevisionExists(PayRevisionDTO dto, LoginDTO LoginDTO, DbTransaction trans, CancellationToken ct = default);
        Task<PayRevisionDTO?> GetPredecessorRevision(PayRevisionDTO dto, LoginDTO LoginDTO, DbTransaction trans, CancellationToken ct = default);
        Task RestorePreviousRevision(int PayRevisionId, LoginDTO LoginDTO, DbTransaction trans, CancellationToken ct = default);
        Task<List<PayRevisionDTO>> GetPayRevisionByField(string FieldName, int FieldId, int Nature, LoginDTO LoginDTO, int OUId, CancellationToken ct = default);
        Task<List<PayRevisionDTO>> ArrearCheck(List<PayRevisionDTO> PayRevisionDTOs, LoginDTO LoginDTO, CancellationToken ct = default);

        Task<IEnumerable<TempPayRevisionDTO>> GetSelectListPayRevisionEmployee(
     int BizTransactionTypeId,
     int Applicable,
     int Nature,
     string PayRevisionPayRevisionNumber,
     string EmployeeCode,
     string EmployeeName,
     LoginDTO LoginDTO);
    }
}