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

namespace PayRollDAL.CustomeCode.Job
{
    public interface IJobDAL
    {
        Task<string> GetSelectListJob(int FirstNumber, int MaxResult, CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, bool IsCount = false);

        Task<JobDTO> GetJob(int JobId, LoginDTO LoginDTO);

        Task<int> SaveJob(JobDTO JobDTO, LoginDTO LoginDTO, DbTransaction DbTransaction);

        Task<int> UpdateJob(JobDTO JobDTO, LoginDTO LoginDTO, DbTransaction DbTransaction);

        Task<string> DeleteJob(int JobId, LoginDTO LoginDTO);

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

        /// <summary>Mirrors TimeSlipDAL.GetPeriodAsync — used by JobBLL's financial-period validation.</summary>
        Task<PeriodDTO?> GetPeriodAsync(int PeriodId, LoginDTO LoginDTO, DbTransaction DbTransaction);

        /// <summary>Looks up MEMPLOYEE by EmployeeId for the "must be an employee" save-time check.</summary>
        Task<JobEmployeeLookupDTO?> GetEmployeeForJobAsync(int EmployeeId, LoginDTO LoginDTO, DbTransaction DbTransaction);

        /// <summary>
        /// GB4 parity: EmployeeBLL.GetJOBDetailReport / EmployeeQueryBuilder.GET_EMPLOYEE_JOB_DETAIL.
        /// Wide paged job-opening report (TJOB + GCM masters + party/employee/department joins).
        /// </summary>
        Task<(List<JOBDetailReportDTO> Items, int Total)> GetJOBDetailReport(
            int firstNumber, int maxResult, CriteriaDTO criteriaDTO, LoginDTO loginDTO, CancellationToken ct);
    }
}