using System.Data.Common;
using GB5Shared.DTO.Framework.Login;
using GB5Shared.ResponseStandard;
using PIEDAL.DTO.Estimation;

namespace PIEDAL.CustomCode.Estimation;

public interface IPIEEstimationDAL
{
    // ── Rule reads ────────────────────────────────────────────────────────────
    Task<PIEEstimationRuleDTO?>                   GetPIEEstimationRuleAsync(Guid ruleId, LoginDTO login, CancellationToken ct);
    Task<IEnumerable<PIEEstimationRuleDTO>>       GetActiveRulesByModuleIdsAsync(Guid[] moduleIds, short engagementType, short complexityLevel, LoginDTO login, CancellationToken ct);

    // ── Snapshot reads ────────────────────────────────────────────────────────
    Task<PIEEstimationSnapshotDTO?>               GetSnapshotByEngagementAsync(string engagementRef, LoginDTO login, CancellationToken ct);

    // ── Rule writes ───────────────────────────────────────────────────────────
    Task<Result<string>> SavePIEEstimationRuleAsync(PIEEstimationRuleDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> UpdatePIEEstimationRuleAsync(PIEEstimationRuleDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> SoftDeletePIEEstimationRuleAsync(Guid ruleId, LoginDTO login, DbTransaction tx, CancellationToken ct);

    // ── Snapshot writes (insert-only) ─────────────────────────────────────────
    Task<Result<string>> InsertSnapshotAsync(PIEEstimationSnapshotDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
}