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

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

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

        // ── SaveOverTime ─────────────────────────────────────────────────────────────
        Task<int> SaveOverTime(OverTimeDTO overTimeDTO, LoginDTO loginDTO, DbTransaction? transaction = null);
        Task<int> UpdateOverTime(OverTimeDTO overTimeDTO, LoginDTO loginDTO, DbTransaction? transaction = null);
        Task<int> SaveOverTimeDetail(OverTimeDetailDTO detailDTO, LoginDTO loginDTO, DbTransaction? transaction = null);
        Task<int> DeleteOverTimeDetails(int overTimeId, LoginDTO loginDTO, DbTransaction? transaction = null);

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

        /// <summary>
        /// Looks up Z_DEPTWISEOUWISEHEAD (addon table that may not exist in every
        /// deployment). Returns -1 when not found or the table does not exist —
        /// mirrors GB4's try/catch swallow-and-continue behaviour.
        /// </summary>
        Task<int> GetOuWiseDepartmentWiseHeadId(int ouId, int departmentId, LoginDTO loginDTO, DbTransaction? transaction = null);

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

        Task<OverTimeDetailDTO?> CheckDuplicateOverTimeEntry(int employeeId, DateTime forTheDate, LoginDTO loginDTO, DbTransaction? transaction = null);

        // ── Get / Delete ─────────────────────────────────────────────────────────────
        Task<OverTimeDTO?> GetOverTime(int overTimeId, LoginDTO loginDTO);
        Task<List<OverTimeDetailDTO>> GetOverTimeDetailsByHeader(int overTimeId, LoginDTO loginDTO);
        Task<int> DeleteOverTime(int overTimeId, LoginDTO loginDTO, DbTransaction? transaction = null);

        // ── LoadOvertimeRecords ──────────────────────────────────────────────────────
        Task<List<OverTimeDTO>> LoadOvertimeRecords(CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, CancellationToken ct = default);

        // ── LoadDailyAttendanceDataToOverTime ────────────────────────────────────────
        Task<List<LoadOverTimeFromDailyAttendanceDTO>> LoadDailyAttendanceDataToOverTime(
            int FirstNumber, int MaxResult, CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, CancellationToken ct = default);

        // ── PostAutoOverTime support ─────────────────────────────────────────────────
        Task<int?> GetBizTypeForOverTime(int ouId, int periodId, LoginDTO loginDTO, DbTransaction? transaction = null);
        Task<List<OverTimeDetailDTO>> GetEmployeesWithOvertime(int ouId, DateTime attendanceDate, LoginDTO loginDTO, DbTransaction? transaction = null);
        Task DeleteAutoPostedOverTime(int ouId, int periodId, DateTime attendanceDate, LoginDTO loginDTO, DbTransaction? transaction = null);
    }
}