using System.Data.Common;
using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using PayRollDAL.DTO.TLeave;

namespace PayRollDAL.CustomeCode.TLeave
{
    public interface ITLeaveDAL
    {
        Task<int> SaveTLeave(TLeaveDTO tLeaveDTO, LoginDTO loginDTO, DbTransaction? transaction = null);
        Task<int> UpdateTLeave(TLeaveDTO tLeaveDTO, LoginDTO loginDTO, DbTransaction? transaction = null);
        Task<int> SaveTLeaveDetail(TLeaveDetailDTO detailDTO, LoginDTO loginDTO, DbTransaction? transaction = null);
        Task<int> DeleteTLeaveDetails(int tLeaveId, LoginDTO loginDTO, DbTransaction? transaction = null);
        Task<int> DeleteTLeave(int tLeaveId, LoginDTO loginDTO, DbTransaction? transaction = null);
        Task<int> UpdateTLeaveStatus(int tLeaveId, byte status, LoginDTO loginDTO, DbTransaction? transaction = null);
        Task<TLeaveDTO?> GetTLeave(int tLeaveId, LoginDTO loginDTO);
        Task<List<TLeaveDetailDTO>> GetTLeaveDetailsByLeave(int tLeaveId, LoginDTO loginDTO);
        Task<IEnumerable<TLeavePicklistDTO>> CheckDuplicateLeaveDates(int employeeId, DateOnly leaveDate, int excludeTLeaveId, LoginDTO loginDTO);
        Task<byte?> GetLeaveTypeById(int leaveTypeId, LoginDTO loginDTO);
        Task<string> GetSelectListTLeave(int FirstNumber, int MaxResult, CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, bool IsCount = false);
        Task<string> GetTLeaveDetails(int FirstNumber, int MaxResult, CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, bool Count = false);
        Task<List<TotalTakenLeaveDTO>> GetTotalLeaveTaken(int FirstNumber, int MaxResult, CriteriaDTO CriteriaDTO, LoginDTO LoginDTO, bool IsCount = false);

        // ── Leave Credit / Debit Posting ────────────────────────────────────────────
        Task<int> CountEligibleEmployeesForPosting(TLeaveDTO dto, LoginDTO loginDTO);
        Task<int> InsertTLeaveHeaderForPosting(TLeaveDTO dto, int tLeaveId, LoginDTO loginDTO, DbTransaction transaction);
        Task<int> InsertTLeaveDetailForPosting(TLeaveDTO dto, int tLeaveId, int detailStartId, LoginDTO loginDTO, DbTransaction transaction);
        Task<List<TLeaveDetailDTO>> GetLeaveBalanceForMakeZero(TLeaveDTO dto, LoginDTO loginDTO);
        Task<int> BulkInsertTLeaveDetailForMakeZero(IEnumerable<TLeaveDetailDTO> details, LoginDTO loginDTO, DbTransaction transaction);
    }
}