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

namespace PayRollDAL.CustomeCode.Punch
{
    public interface IPunchDAL
    {
        Task<int> SaveMissedPunch(PunchDTO dto, LoginDTO login, DbTransaction tx);
        Task<int> UpdateMissedPunch(PunchDTO dto, LoginDTO login, DbTransaction tx);

        #region MissingPunchInsert / MissingPunchInsertNew

        Task<string?> GetEmployeeTemporaryCardNumberAsync(int employeeId, LoginDTO login, CancellationToken ct = default);

        Task<IEnumerable<PunchDownloadDeviceLogDTO>> GetDeviceLogsFromPunchDbAsync(string fromDate, string toDate, string? employeeCode, LoginDTO punchDbLogin, CancellationToken ct = default);
        Task<int> DeleteDeviceLogFromPunchDbAsync(int id, LoginDTO punchDbLogin, DbTransaction tx, CancellationToken ct = default);
        Task<int> InsertDeviceLogFromPunchDbAsync(PunchDownloadDeviceLogDTO row, LoginDTO login, DbTransaction tx, CancellationToken ct = default);
        Task<int> DeleteTPunchBeforeInsertingAsync(int employeeId, string fromDate, string toDate, LoginDTO login, DbTransaction tx, CancellationToken ct = default);

        Task<IReadOnlyList<string>> FindPunchServerConnectionNamesAsync(string tableName, LoginDTO login, CancellationToken ct = default);
        Task<int> InsertMissingDeviceLogsFromLinkedServerAsync(int employeeId, string connectionName, string fromDate, string toDate, string tableName, LoginDTO login, DbTransaction tx, CancellationToken ct = default);
        Task<int> StageMissingPunchesToDeviceLogs2Async(int employeeId, string fromDate, string toDate, string tableName, LoginDTO login, DbTransaction tx, CancellationToken ct = default);

        #endregion
    }
}