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

namespace SwDAL.CustomCode.DbServer;

public interface IDbServerDAL
{
    Task<DbServerDTO?> GetById(int dbServerId, LoginDTO loginDTO, CancellationToken ct);
    Task<DbServerDTO?> GetByIdWithCredentials(int dbServerId, LoginDTO loginDTO, CancellationToken ct);
    Task<string> GetSelectListDbServer(int first, int max, LoginDTO loginDTO);

    Task<Result<string>> SaveDbServer(DbServerDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<Result<string>> UpdateDbServer(DbServerDTO dto, LoginDTO loginDTO, DbTransaction tx, CancellationToken ct);
    Task<int> DeleteDbServer(int dbServerId, LoginDTO loginDTO, DbTransaction tx, 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);
}