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

namespace TMSDAL.CustomCode.CertRenewalAlert
{
    /// <summary>
    /// DAL interface for LCERTRENEWALALERT.
    /// LOG table — Save and Read only. No Update. No Delete.
    /// </summary>
    public interface ICertRenewalAlertDAL
    {
        /// <summary>Returns a single alert log entry by its IDENTITY PK.</summary>
        Task<string> GetCertRenewalAlert(int lCertRenewalAlertId, LoginDTO loginDTO);

        /// <summary>Returns all alert log entries for a specific certificate.</summary>
        Task<string> GetCertRenewalAlertList(int trainingCertificateId, LoginDTO loginDTO);

        /// <summary>Returns a filtered selectlist — criteria driven via CriteriaBuilder.</summary>
        Task<string> GetSelectListCertRenewalAlert(CriteriaDTO criteriaDTO, LoginDTO loginDTO);

        /// <summary>
        /// Appends a new alert log entry. IDENTITY PK assigned by SQL Server.
        /// No AutoNumber required — do not call GetAutoNumber before this.
        /// </summary>
        Task<int> SaveCertRenewalAlert(CertRenewalAlertDTO dto, LoginDTO loginDTO);
    }
}