using GB5Shared.DTO.Framework.Criteria;
using GB5Shared.DTO.Framework.Login;
using SwBLL.Provisioning;
using SwDAL.DTO.DbServer;

namespace SwBLL.DbServer;

public interface IDbServerBLL
{
    Task<DbServerDTO?> GetById(int dbServerId, LoginDTO loginDTO, CancellationToken ct);
    /// <summary>Returns DTO including DbUsername/DbPassword — for provisioning/DML use only. Never expose via SL.</summary>
    Task<DbServerDTO?> GetByIdWithCredentials(int dbServerId, LoginDTO loginDTO, CancellationToken ct);
    Task<string> GetList(CriteriaDTO criteria, string? searchText, int pageOffset, int pageSize, LoginDTO loginDTO, CancellationToken ct = default);
    Task<string> GetSelectListDbServer(int firstNumber, int maxResult, CriteriaDTO criteriaDTO, LoginDTO loginDTO);
    Task<string> Save(DbServerDTO dto, LoginDTO loginDTO, CancellationToken ct);
    Task<string> Delete(int dbServerId, LoginDTO loginDTO, CancellationToken ct);

    /// <summary>Introspects the schema of a remote database connected via the given DbServer.</summary>
    Task<IEnumerable<RemoteDbObjectDTO>> GetServerObjectsAsync(
        int dbServerId, string databaseName, LoginDTO loginDTO, CancellationToken ct);
    Task<string> GetListDBServer(CriteriaDTO criteriaDTO, LoginDTO login, CancellationToken ct);
    Task<List<DbServerDTO>> GetServerHostNameList(LoginDTO loginDTO, CancellationToken ct);
    Task<List<DbServerDTO>> GetDatabaseListByHostName(string hostName, LoginDTO loginDTO, CancellationToken ct);

}