using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using SwDAL.DTO.DdlScript;

namespace SwBLL.DdlScript;

public interface IDdlScriptBLL
{
    Task<DdlScriptDTO?>             GetById(int ddlScriptId, LoginDTO loginDTO, CancellationToken ct);
    Task<string>                    GetList(CriteriaDTO criteria, string? searchText, int pageOffset, int pageSize, LoginDTO loginDTO, CancellationToken ct = default);
    Task<string>                    GetSelectListDdlScript(int firstNumber, int maxResult, CriteriaDTO criteriaDTO, LoginDTO loginDTO);
    Task<IEnumerable<DdlScriptDTO>> GetByBranch(int branchId, LoginDTO loginDTO, CancellationToken ct);

    Task<string> Save(DdlScriptDTO dto, LoginDTO loginDTO, CancellationToken ct);
    Task<string> Delete(int ddlScriptId, LoginDTO loginDTO, CancellationToken ct);
    Task<string> ReviewDdlScript(int ddlScriptId, LoginDTO loginDTO, CancellationToken ct);
    Task<string> ApproveDdlScript(int ddlScriptId, int approvedById, LoginDTO loginDTO, CancellationToken ct);
    Task<string> LogExecutionAsync(int ddlScriptId, int clientDbId, byte status, string? errorMessage, LoginDTO loginDTO, CancellationToken ct);

    /// <summary>Tracker §37 Decision 2 — how many of the given DdlScriptIds already have an
    /// execution attempt logged for this ClientDbId. Used by ChangeRequestBLL.GetById to enrich
    /// a ClientProvisioning CR's status with ScriptsDone/ScriptsTotal for real-time progress
    /// reporting — never called for any other CR category.</summary>
    Task<int> CountExecutedScriptsAsync(int clientDbId, IEnumerable<int> ddlScriptIds, LoginDTO loginDTO, CancellationToken ct);
}