using GB5Shared.DTO.Framework.Login;
using SwDAL.DTO.QueryHistory;

namespace SwBLL.Query;

public interface ISwQueryBLL
{
    /// <summary>Executes an ad-hoc SELECT against the target identified by clientDbId (preferred
    /// — unambiguously identifies a registered ClientDatabase) or, failing that, by
    /// dbServerId+databaseName (a raw, possibly-unregistered database on that server).</summary>
    Task<IEnumerable<dynamic>> ExecuteAdHocQuery(
         string queryCode,
         Dictionary<string, object?> parameters,
          int dbServerId,
          string? databaseName,
         LoginDTO loginDTO,
         CancellationToken ct,
         int? savedQueryId = null,
         int? clientDbId = null);

    Task<string> GetQueryHistoryList(QueryHistoryListCriteria criteria, int pageOffset, int pageSize, LoginDTO login, CancellationToken ct);
}