using System.Data;
using GB5Shared.DTO.Framework.Login;
using SwDAL.DTO.DdlScript;
using GB5Shared.ResponseStandard;
using System.Data.Common;

namespace SwDAL.CustomCode.DdlScript;

public interface IDdlScriptDAL
{
    Task<DdlScriptDTO?>                  GetById(int ddlScriptId, LoginDTO loginDTO, CancellationToken ct);
    Task<IEnumerable<DdlScriptDTO>>      GetByBranch(int branchId, LoginDTO loginDTO, CancellationToken ct);
    Task<string>                         GetSelectListDdlScript(int first, int max, LoginDTO loginDTO);
    Task<bool>                           ExistsInExecutions(int ddlScriptId, LoginDTO loginDTO);

    Task<Result<string>> SaveDdlScript(DdlScriptDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> UpdateDdlScript(DdlScriptDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> DeleteDdlScript(int ddlScriptId, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> UpdateScriptStatus(int ddlScriptId, byte newStatus, byte requiredCurrentStatus, int approvedById, DateTime? approvedOn, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
}