using Dapper;
using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using PayRollDAL.DTO;
using PayRollDAL.DTO.PayProcess;
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.PayProcess
{
    public interface IPayProcessDAL
    {
        Task<List<PaySlipReportDTO>> GetPaySlipReport(int FirstNumber, int MaxResult, CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, bool Count = false, int Type = 0);

        Task<string> GetAdditionDeductionPicklist(int FirstNumber, int MaxResult, CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, bool IsCount = false);

        Task<string> GetPayProcessAddonPicklist(CriteriaDTO CriteriaDTO, LoginDTO LoginDTO);

        //Task<IList<PeriodDTO>> GetPeriodAsync(int workPeriodId, LoginDTO loginDTO, CancellationToken cancellationToken = default);

        //Task ExecuteValidTillDateLeaveAsync(DateTime periodFrom, DateTime periodTo, string ouId, LoginDTO loginDTO, CancellationToken cancellationToken = default);

        Task<IList<PeriodDTO>> GetPeriodAsync(
            int workPeriodId,
            LoginDTO loginDTO,
            CancellationToken cancellationToken = default);

        Task ExecuteLeaveStatusPreProcessingAsync(
            DateTime periodFrom,
            DateTime periodTo,
            string ouId,
            LoginDTO loginDTO,
            CancellationToken cancellationToken = default);

        Task<IList<LeaveStatusDTO>> GetLeaveStatusReportAsync(
    DateTime periodFrom,
    DateTime periodTo,
    string ouIds,
    int toIncludeDebitClass,
    LoginDTO loginDTO,
    int? employeeId = null,
    bool isScreenPeriod = false,
    int? departmentId = null,
    int? leaveTypeId = null,
    int? employeeTypeId = null,
    int? staffTypeId = null,
    int? payGroupId = null,
    CancellationToken cancellationToken = default);

        // ── PayProcessForSepration (GB4 spelling preserved for route/BLL-comment traceability) ──

        Task<int> GetSeparationDuplicateCount(int ouId, int payConfigurationId, int employeeId, LoginDTO loginDTO, DbTransaction transaction);

        Task UndoSeparationPayProcess(int ouId, int payConfigurationId, int employeeId, LoginDTO loginDTO, DbTransaction transaction);

        Task<int> InsertSeparationPayProcessHeader(
            int startNumber, int payPeriodId, int payConfigurationId, int ouId,
            decimal numberOfDays, int totalDays, DateTime fromDate, DateTime toDate, int weeklyOff, int employeeId,
            LoginDTO loginDTO, DbTransaction transaction);

        Task UpdateSeparationDailyAttendanceSum(int ouId, int payConfigurationId, int employeeId, LoginDTO loginDTO, DbTransaction transaction);

        Task<IList<(string Code, int ApplicableType, int Nature, int FieldDataType)>> GetFixedAdditionDeductionFields(LoginDTO loginDTO, DbTransaction transaction);

        Task<IList<(string Code, int ApplicableType, int Nature, int FieldDataType)>> GetVariableAdditionDeductionFields(LoginDTO loginDTO, DbTransaction transaction);

        Task<IList<string>> GetCreditLeaveCodes(LoginDTO loginDTO, DbTransaction transaction);

        Task InsertSeparationPayProcessAddon(
            int startNumber, int payConfigurationId, int ouId, DateTime fromDate, DateTime toDate, int employeeId,
            string dynamicColumns, string dynamicValues, LoginDTO loginDTO, DbTransaction transaction);

        Task<IList<(string Code, int Phase, int FormulaType, string Expression, string FunctionName, int DataType)>> GetFormulaFields(LoginDTO loginDTO, DbTransaction transaction);

        Task<int> GetMaxFormulaPhase(LoginDTO loginDTO, DbTransaction transaction);

        Task UpdatePayProcessAddonByFormula(int payPeriodId, int payConfigurationId, int employeeId, string strUpdate, LoginDTO loginDTO, DbTransaction transaction);

        Task UpdateTotalEarningDeduction(int payConfigurationId, int payPeriodId, int ouId, string totalEarningExpr, string totalDeductionExpr, string totalAdditionExpr, LoginDTO loginDTO, DbTransaction transaction);

        Task UpdateNetSalary(int payConfigurationId, int payPeriodId, int ouId, LoginDTO loginDTO, DbTransaction transaction);

        Task UpdateC2C(int payConfigurationId, int payPeriodId, int ouId, string replaceFieldsExpr, LoginDTO loginDTO, DbTransaction transaction);
    }
}