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

namespace PIEDAL.CustomCode.Proposal;

public interface IPIEProposalDAL
{
    // ── Reads ─────────────────────────────────────────────────────────────────
    Task<PIELearningProposalDTO?>                 GetPIEProposalAsync(Guid proposalId, LoginDTO login, CancellationToken ct);

    // ── Writes ────────────────────────────────────────────────────────────────
    Task<Result<string>> InsertPIEProposalAsync(PIELearningProposalDTO dto, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> ReviewPIEProposalAsync(PIEReviewProposalDTO dto, int reviewedBy, LoginDTO login, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> DeletePIEProposalAsync(Guid proposalId, LoginDTO login, DbTransaction tx, CancellationToken ct);
}