public static string GetConnectionString(Models.Conexao conexao)
{
if (conexao.BancoDados == "Informix")
{
string database = "wpdhosp";
return($"Host={conexao.Ip}; " +
$"Service={conexao.Porta}; " +
$"Server={conexao.NomeServidor}; " +
$"Database={database}; " +
$"User Id={conexao.Usuario}; " +
$"Password={conexao.Senha}; ");
}
else
{
//"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=100.100.100.100)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=myservice.com)));User Id=scott;Password=tiger;"
return("Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)" +
$"(HOST={conexao.Ip})(PORT={conexao.Porta}))(CONNECT_DATA=(SERVICE_NAME={conexao.NomeServidor})));" +
$"User Id= {conexao.Usuario};Password= {conexao.Senha}; ");
}
}
/*public override async Task OnConnectedAsync()
* {
* //await Clients.Client(Context.ConnectionId).InvokeAsync("SetUsersOnline", await GetUsersOnline());
*
* await base.OnConnectedAsync();
* }*/
public async Task GetStatusDB(Guid id)
{
Models.Conexao conexao = _userRepository.Find(id);
if (conexao != null)
{
TestConnectionAssertion testConnectionAssertion = new TestConnectionAssertion(
conexao.Ip, conexao.Porta, conexao.NomeServidor,
conexao.Usuario, conexao.Senha
);
if (!testConnectionAssertion.Notifications.HasNotifications())
{
string connectionString = Utils.Connection.GetConnectionString(conexao);
string status = Utils.Connection.TestConnection(connectionString, _configuration["UrlStatusDb"]);
conexao.DataStatus = DateTime.Now;
conexao.Status = status;
_userRepository.Update(conexao);
await Clients.All.InvokeAsync("StatusDBResponse", conexao.Id, conexao.Status, conexao.DataStatus.ToString());
}
}
}
public ConexaoAssertion(Models.Conexao conexao, bool canIdNull = false) : base()
{
if (conexao == null)
{
throw new Exception("O parâmetro conexao não pode ser nulo [classe ConexaoAssertion]");
}
if (!canIdNull)
{
if (conexao.Id == Guid.Empty)
{
SetNofication("500", "O ID não pode ser nulo");
}
}
if (string.IsNullOrEmpty(conexao.NomeServidor))
{
SetNofication("500", "Informe o Nome");
}
/*if (!conexao.DataNascimento.HasValue)
* SetNofication("500", "Informe a Data de Nascimento");
*/
}
