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

namespace PayRollDAL.CustomeCode.Periodic
{
    // Migration scope: SavePeriodic (single-record) only — see PeriodicQB.cs header note.
    public interface IPeriodicDAL
    {
        // Migration scope: SavePeriodic (single-record) only — see PeriodicQB.cs header note.
       
            Task<int> GetMainSubTypeId(int employeeId, int ouId, int payPeriodId, LoginDTO loginDTO, DbTransaction? transaction = null);
            Task<int> GetMMDetailId(int payPeriodId, int employeeId, string? partyCode, string? partyBranchCode, string? workTypeCode, LoginDTO loginDTO, DbTransaction? transaction = null);
            Task<OverTimeEmployeeReportingInfoDTO?> GetEmployeeReportingInfo(int employeeId, LoginDTO loginDTO, DbTransaction? transaction = null);
            Task<int> SavePeriodic(PeriodicDTO periodicDTO, LoginDTO loginDTO, DbTransaction? transaction = null);
            Task<int> UpdatePeriodic(PeriodicDTO periodicDTO, LoginDTO loginDTO, DbTransaction? transaction = null);
            Task<IEnumerable<PeriodicDTO>> GetPeriodicList(CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, CancellationToken ct = default);

            // ADD THESE VALIDATION METHODS
            Task<bool> ValidatePayGroupId(int payGroupId, LoginDTO loginDTO);
            Task<bool> ValidatePayPeriodId(int payPeriodId, LoginDTO loginDTO);
            Task<bool> ValidateEmployeeId(int employeeId, LoginDTO loginDTO);
            Task<bool> ValidateOUId(int ouId, LoginDTO loginDTO);
        

        // ── GetPeriodic (Periodic.svc/GetPeriodic) ──────────────────────────────────────
        // Mirrors GB4 PeriodicDAL.GetPeriodicDetails. IsPartialProcessRequired / mandatory
        // PayConfig check / sort-flag resolution all live in PeriodicBLL — see PeriodicBLL.GetPeriodic.
        Task<int?> GetPayConfigurationIsPartialProcessRequired(int payConfigurationId, LoginDTO loginDTO, CancellationToken ct = default);

        Task<(List<PeriodicDTO> Items, int Total)> GetPeriodicStandard(
            int payPeriodId, int firstNumber, int maxResult, string orderByClause,
            CriteriaDTO criteriaDTO, LoginDTO loginDTO, CancellationToken ct = default);

        Task<(List<PeriodicDTO> Items, int Total)> GetPeriodicNew(
            int payPeriodId, int firstNumber, int maxResult,
            CriteriaDTO criteriaDTO, LoginDTO loginDTO, CancellationToken ct = default);

        // ── PeriodicServiceBasedExport (Periodic.svc/Periodic/Service/Based/Export) ─────────
        // Mirrors GB4 DumpPerodicServiceBased.PeriodicServiceBasedExport — see PeriodicDAL for
        // the single-query collapse of GB4's temp-table + second-SELECT sequence.
        Task<List<PeriodicDTO>> GetPeriodicServiceBasedExport(
            int payPeriodId, CriteriaDTO criteriaDTO, LoginDTO loginDTO, CancellationToken ct = default);

        Task<List<string>> GetPeriodicAddonExportFieldNames(int entityId, LoginDTO loginDTO, CancellationToken ct = default);

        Task<IEnumerable<dynamic>> GetPeriodicServiceBasedExportAddonValues(
            int payPeriodId, string addonColumns, LoginDTO loginDTO, CancellationToken ct = default);

        // ADD THESE VALIDATION METHODS
       

        // ── LoadPeriodic (bulk generation) — see PeriodicQB.BuildLoadPeriodic header note ──
        Task<DateTime?> GetPayPeriodToDate(int payPeriodId, LoginDTO loginDTO, DbTransaction? transaction = null);
        Task<IEnumerable<PeriodicAddonFieldDefaultDTO>> GetPeriodicAddonFieldDefaults(LoginDTO loginDTO, DbTransaction? transaction = null);
        Task<int> LoadPeriodic(
            int payPeriodId, int payConfigurationId, int autoId, DateTime toDate,
            string fieldNameList, string fieldValueList, LoginDTO loginDTO, DbTransaction? transaction = null);
    }

}