using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using TMSDAL.DTO.CertRenewalAlert;

namespace TMSDAL.CustomCode.Certificate
{
    public interface ITrainingCertificateDAL
    {
        Task<TrainingCertificateDTO?> GetCertificate(int TrainingCertificateId, LoginDTO loginDTO);
        Task<string> GetCertificateListByEmployee( LoginDTO loginDTO);
        Task<int> SaveCertificate(TrainingCertificateDTO dto, LoginDTO loginDTO);
        Task<int> RevokeCertificate(int TrainingCertificateId, string reason, int revokedById, LoginDTO loginDTO);
        Task LogCertRenewalAlert(CertRenewalAlertDTO dto, LoginDTO loginDTO);
        Task<string> GetSelectList(CriteriaDTO criteriaDTO, LoginDTO login, CancellationToken ct);
        Task<int> UpdateCertificate(TrainingCertificateDTO dto, LoginDTO loginDTO);
        Task SaveCertificateBulk(IEnumerable<TrainingCertificateDTO> records, LoginDTO loginDTO);
        Task UpdateCertificateBulk(IEnumerable<TrainingCertificateDTO> records, LoginDTO loginDTO);
        Task<int> MarkCertRenewed(int trainingCertificateId, LoginDTO loginDTO);

        // Public, cross-tenant lookup — mirrors FlsRespondentDAL.GetByTokenAsync's precedent.
        // Caller passes a fresh LoginDTO { ClientId = 0, UserId = -1 }, not the real tenant login.
        Task<CertificateVerificationDTO?> GetCertificateByVerificationToken(string verificationToken, LoginDTO loginDTO, CancellationToken ct);
        Task<int> SetVerificationTokenAndSignatory(int trainingCertificateId, string verificationToken, int signatoryId, LoginDTO loginDTO, CancellationToken ct);
        Task<int> SaveCertificateSignature(TrainingCertificateSignatureDTO dto, LoginDTO loginDTO, CancellationToken ct);
        Task<int> GetAttachmentIdByCertificate(int trainingCertificateId, LoginDTO loginDTO, CancellationToken ct);
        Task<AttachmentStorageInfoDTO?> GetAttachmentStorageInfo(int attachmentId, LoginDTO loginDTO, CancellationToken ct);
    }
}