using System.Data.Common;
using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using CRMSalesDAL.DTO.LeadScoringConfig;

namespace CRMSalesDAL.CustomCode.LeadScoringConfig;

public interface ILeadScoringConfigDAL
{
    Task<string> GetLeadScoringConfig(int leadScoringConfigId, LoginDTO loginDTO, CancellationToken ct);

    /// <summary>Latest active row, or null if none exists yet — used by LeadScoringBLL to read
    /// the configured weights.</summary>
    Task<LeadScoringConfigDTO?> GetLatestLeadScoringConfig(LoginDTO loginDTO, CancellationToken ct);

    Task<string> GetSelectListLeadScoringConfig(CriteriaDTO criteriaDTO, LoginDTO loginDTO, CancellationToken ct);

    // Transactional write overloads — called from BaseEntityAppService.ExecuteSaveAsync's
    // persistFunc so the save participates in the single pipeline transaction.
    Task<int> SaveLeadScoringConfig(LeadScoringConfigDTO leadScoringConfigDTO, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<int> UpdateLeadScoringConfig(LeadScoringConfigDTO leadScoringConfigDTO, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<string> DeleteLeadScoringConfig(int leadScoringConfigId, LoginDTO loginDTO, CancellationToken ct);
}