using AnalyticsDAL.DTO.DataSource;
using GB5Shared.DTO.Framework.Login;

namespace AnalyticsDAL.CustomCode.DataSource
{
    public interface IDataSourceDAL
    {
        Task<string> GetDataSource(int dataSourceId, LoginDTO login, CancellationToken ct);
        Task<string> GetSelectListDataSource(LoginDTO login, CancellationToken ct);
        Task<int> SaveDataSource(DataSourceDTO dto, LoginDTO login, CancellationToken ct);
        Task UpdateDataSource(DataSourceDTO dto, LoginDTO login, CancellationToken ct);
        Task UpdateValidationStatus(int dataSourceId, byte isValidated, LoginDTO login, CancellationToken ct);
        Task DeleteDataSource(int dataSourceId, LoginDTO login, CancellationToken ct);
        Task<bool> IsDuplicateCode(string code, int excludeId, LoginDTO login, CancellationToken ct);

        /// <summary>Unscoped by TenantId — returns null if the data source doesn't exist. Used only by the ownership visibility guard.</summary>
        Task<int?> GetDataSourceTenantId(int dataSourceId, LoginDTO login, CancellationToken ct);

        /// <summary>Unscoped by TenantId — resolves the shared "GB5_SELF_HOST" MDATASOURCE row
        /// by code (see DataSourceQB.GET_DATASOURCE_ID_BY_CODE). Returns null if not seeded yet.</summary>
        Task<int?> GetDataSourceIdByCode(string dataSourceCode, LoginDTO login, CancellationToken ct);
    }
}