using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using PayRollDAL.DTO.Adjustment;
using PayrollDAL.DTO.Adjustment;
using System;
using System.Collections.Generic;
using System.Data.Common;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;

namespace PayRollDAL.CustomeCode.Adjustment
{
    public interface IAdjustmentDAL
    {
        Task<IList<AdjustmentReportDTO>> GetAdjustmentReportAsync(
            int firstNumber,
            int maxResult,
            CriteriaDTO criteriaDTO,
            LoginDTO loginDTO,
            bool isCount = false);

        Task<IList<AdjustmentPicklistDTO>> AdjustmentNumberSelectlist(
            int firstNumber,
            int maxResult,
            CriteriaDTO criteriaDTO,
            LoginDTO loginDTO,
            bool isCount = false);

        Task<AdjustmentEmployeeReportingInfoDTO?> GetEmployeeReportingInfo(int employeeId, LoginDTO loginDTO, DbTransaction? transaction = null);

        Task<(DateTime FromDate, DateTime ToDate)?> GetPeriodRange(int periodId, LoginDTO loginDTO, DbTransaction? transaction = null);

        Task<int> SaveAdjustment(AdjustmentDTO dto, LoginDTO loginDTO, DbTransaction? transaction = null);

        Task<int> UpdateAdjustment(AdjustmentDTO dto, LoginDTO loginDTO, DbTransaction? transaction = null);

        Task<int> SaveAdjustmentDetail(AdjustmentDetailDTO detail, LoginDTO loginDTO, DbTransaction? transaction = null);

        Task<int> DeleteAdjustmentDetails(int adjustmentId, LoginDTO loginDTO, DbTransaction? transaction = null);

        Task<AdjustmentDTO?> GetAdjustment(int adjustmentId, LoginDTO loginDTO, CancellationToken ct);

        /// <summary>GB4 parity: Reason lookup used in SaveAdjustment's EventLog text.</summary>
        Task<string?> GetReasonName(int reasonId, LoginDTO loginDTO, CancellationToken ct);

        Task<List<AdjustmentDetailDTO>> GetAdjustmentDetailsByHeader(int adjustmentId, LoginDTO loginDTO, CancellationToken ct);

        Task<int> DeleteAdjustment(int adjustmentId, LoginDTO loginDTO, DbTransaction? transaction = null);

        Task<List<AdjustmentImportDTO>> GetAdjustmentForImport(CriteriaDTO criteriaDTO, LoginDTO loginDTO, CancellationToken ct);
    }
}