private void GetDataSource(object sender, RoutedEventArgs e) { if (JWTTokenHelper.IsTokenExpired(_accessToken)) { Message.Text = string.Format("{0} - Get Data Source error {1} No security tokens acquired or security tokens expired!" , DateTime.Now , Environment.NewLine); return; } try { var dataSource = _sharedFrameworkReader.GetDataSource(_accessToken); Message.Text = string.Format("{0} - Get Data Source ok {1}{2}" , DateTime.Now , Environment.NewLine , dataSource.ToString()); } catch (Exception ex) { Message.Text = string.Format("{0} - Get Data Source error {1}{2}" , DateTime.Now , Environment.NewLine , ex.Message); } }
public bool ConnectADONet(string accessToken, out string status) { CloseDBConnection(out status); try { ConnectionParameters connectionParameters = new ConnectionParameters(); connectionParameters.AppRoleName = ConnectivitySettings.AppRole; connectionParameters.AppRolePassword = CachedAppRolePassword; connectionParameters.UseSSL = true; var dataSource = _sharedFrameworkReader.GetDataSource(accessToken); connectionParameters.Server = dataSource.Database.Hostname; connectionParameters.Database = dataSource.Database.Databasename; connectionParameters.Port = Int32.Parse(dataSource.Database.Portnumber); DAL = DAL_ADOnet.Instance(connectionParameters); status = DAL.Connect(); status += "DataSource retrieved from Shared Framework Server settings: "; status += "\n\t Server: " + connectionParameters.Server; status += "\n\t Database name: " + connectionParameters.Database; status += "\n\t Port: " + connectionParameters.Port; return(Connected = true); } catch (Exception e) { FormatException(ref status, e); return(Connected = false); } }