using System;
using System.Collections.Generic;
using System.Data.Common;
using System.Threading;
using System.Threading.Tasks;
using GB5Shared.DTO.ECM;
using GB5Shared.DTO.Framework.Login;

namespace GB5Shared.FileUpload
{
    public interface IAttachmentDAL
    {
        Task<int>                    SaveAttachment      (TAttachmentDTO     Dto, LoginDTO LoginDTO, DbTransaction Transaction);
        Task<TAttachmentDTO?>        GetAttachment       (int AttachmentId,  LoginDTO LoginDTO);
        Task<AttachmentListDTO?>     GetAttachmentDetail (int AttachmentId,  LoginDTO LoginDTO);
        Task<IEnumerable<AttachmentListDTO>> ListAttachments          (int ObjectId, int ObjectTypeId, LoginDTO LoginDTO);
        Task<IEnumerable<AttachmentListDTO>> ListAttachmentsByObjectId         (int ObjectId,                              LoginDTO LoginDTO);
        Task<IEnumerable<AttachmentListDTO>> ListAttachmentsByHeaderAndObjectId(int ObjectHeaderId, int ObjectId,          LoginDTO LoginDTO);
        Task<string>                 UpdateAttachment (AttachmentUpdateDTO Dto, LoginDTO LoginDTO, DbTransaction Transaction);
        Task<string>                 DeleteAttachment (int AttachmentId,       LoginDTO LoginDTO, DbTransaction Transaction);

        // ── Attachment resolution (pre-save upload correlation) ───────
        Task BulkResolveObjectIdAsync      (IEnumerable<LevelAttachmentMap> mappings,
                                            LoginDTO login, DbTransaction tx, CancellationToken ct);
        Task<IEnumerable<TAttachmentDTO>>  GetOrphanedAttachmentsAsync
                                           (DateTime olderThan, int batchSize, LoginDTO login, CancellationToken ct);
        Task DeleteAttachmentsAsync        (IEnumerable<int> attachmentIds,
                                            LoginDTO login, DbTransaction tx, CancellationToken ct);

        Task<IEnumerable<AttachmentListDTO>>ListAttachmentsByHeaderAndObjectHeaderTypeId(int ObjectHeaderTypeId, int ObjectHeaderId, LoginDTO LoginDTO);
        Task<string> UpdateAttachmentObjectId(AttachmentUpdateDTO Dto, LoginDTO LoginDTO, DbTransaction Transaction);
    }
}