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"); */ }