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

namespace SwDAL.CustomCode.UpgradePackage;

public interface IUpgradePackageDAL
{
    Task<UpgradePackageDTO?>                    GetById(int packageId, LoginDTO loginDTO, CancellationToken ct);
    Task<IEnumerable<UpgradePackageDdlDTO>>     GetDdlLines(int packageId, LoginDTO loginDTO, CancellationToken ct);
    Task<IEnumerable<UpgradePackageMetaDTO>>    GetMetaLines(int packageId, LoginDTO loginDTO, CancellationToken ct);
    Task<string>                                GetSelectListUpgradePackage(int first, int max, LoginDTO loginDTO);
    Task<IEnumerable<PackageChainItemDTO>>      GetProvisioningChain(int dbModelId, PackageScopeFilterDTO? scope, LoginDTO loginDTO, CancellationToken ct);
    Task<IEnumerable<LineageNodeDTO>>           GetLineage(int dbModelId, LoginDTO loginDTO, CancellationToken ct);

    Task<Result<string>> SaveUpgradePackage(UpgradePackageDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> UpdateUpgradePackage(UpgradePackageDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> ReplaceDdlLines(int packageId, IEnumerable<UpgradePackageDdlDTO> lines, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> ReplaceMetaLines(int packageId, IEnumerable<UpgradePackageMetaDTO> lines, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> DeleteUpgradePackage(int packageId, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
}