using ECPDAL.Correspondence.DTOs;
using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.QueryExecutor;

namespace ECPDAL.Correspondence.Interfaces;

public interface ICorrespondenceDAL
{
    Task<CorrespondenceDTO?>      GetCorrespondenceAsync(int correspondenceId, LoginDTO login, CancellationToken ct);
    Task<List<CorrespondenceDTO>> GetCorrespondenceHistoryAsync(int objectTypeId, int objectId, LoginDTO login, CancellationToken ct);

    /// <summary>Tenant-wide, paged, CriteriaDTO-filterable list -- see
    /// CorrespondenceDAL.ApplyCorrespondenceListCriteria/GetCorrespondenceColumnForField for the
    /// supported FieldName set (Direction, Mode, ActionStatus, CorrespondenceTypeId,
    /// ObjectTypeId, ObjectId, CreatedOn, SentOn).</summary>
    Task<PagedResult<CorrespondenceDTO>> GetCorrespondenceListAsync(
        CriteriaDTO? criteriaDTO, int pageNumber, int pageSize, LoginDTO login, CancellationToken ct);

    Task<int>                    SaveCorrespondenceAsync(CorrespondenceDTO dto, LoginDTO login, CancellationToken ct);
    Task                         UpdateActionStatusAsync(int correspondenceId, byte actionStatus, DateTime? sentOn, int modifiedById, LoginDTO login, CancellationToken ct);

    /// <summary>Updates editable routing/scheduling fields. Returns false if no row matched
    /// (not found, wrong tenant, or stale Version — caller should surface a conflict/not-found).</summary>
    Task<bool>                   UpdateCorrespondenceAsync(UpdateCorrespondenceDTO dto, int modifiedById, LoginDTO login, CancellationToken ct);

    /// <summary>Soft-deletes (STATUS=2). Returns false if no active row matched.</summary>
    Task<bool>                   DeleteCorrespondenceAsync(int correspondenceId, int modifiedById, LoginDTO login, CancellationToken ct);
}