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);
}
}
