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

namespace SwDAL.CustomCode.MetadataSync;

public interface IMetadataSyncDAL
{
    Task<MetadataSyncDTO?>  GetById(int metaVersionId, LoginDTO loginDTO, CancellationToken ct);
    Task<string>            GetSelectListMetadataSync(int first, int max, LoginDTO loginDTO);

    Task<Result<string>> SaveMetadataSync(MetadataSyncDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> UpdateMetadataSync(MetadataSyncDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> UpdateStatus(int metaVersionId, byte status, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> DeleteMetadataSync(int metaVersionId, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);

    Task<IEnumerable<MetadataChangeDTO>> GetChanges(int metaVersionId, LoginDTO loginDTO, CancellationToken ct);
    Task<Result<string>> InsertChange(MetadataChangeDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> DeleteChange(int metaVersionId, string tableName, string columnName, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> DeleteAllChanges(int metaVersionId, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
}