/// <summary>
/// Gets actual connection.
/// </summary>
/// <param name="database">.</param>
/// <remarks>Asim Naeem, 7/20/2017.</remarks>
internal void GetActualConnection(int database)
{
try
{
using (List <WDDBConfig> .Enumerator enumerator = GetDatabaseConfig(database).GetEnumerator())
{
while (enumerator.MoveNext())
{
WDDBConfig current = enumerator.Current;
if (current.ActiveFlag)
{
Connections connections = new Connections(current.ServerName, current.DatabaseName, dummyId, dummyPasswd);
try
{
WD.DataAccess.Context.DbContext dbContext = new Context.DbContext(new Connect()
{
DbProvider = current.dbProvider, ConnectionString = connections.ConnectionString()
});
DataTable dataTable = dbContext.ICommands.ExecuteDataTable("SELECT USER_ID, PASSWD FROM SECURITY_TBL");
if ((dataTable.Rows.Count == 0))
{
current.Userid = dummyId;
current.Password = dummyPasswd;
}
else
{
current.Userid = HelperUtility.Decrypt(dataTable.Rows[0]["USER_ID"].ToString());
current.Password = HelperUtility.Decrypt(dataTable.Rows[0]["PASSWD"].ToString());
}
dbContext = null;
this.connectionString = new Connections(current.ServerName, current.DatabaseName, current.Userid, current.Password).ConnectionString();
this.dbProvider = current.dbProvider;
}
catch
{
//throw;
}
}
else
{
current.Userid = string.Empty;
current.Password = string.Empty;
}
}
}
}
catch
{
throw;
}
}
/// <summary>
/// Sets a connection.
/// </summary>
/// <param name="database">.</param>
/// <remarks>Asim Naeem, 7/20/2017.</remarks>
internal void SetActualConnection(int database)
{
try
{
using (List <WDDBConfig> .Enumerator enumerator = GetDatabaseConfig(database).GetEnumerator())
{
while (enumerator.MoveNext())
{
WDDBConfig current = enumerator.Current;
current.ErrorMessages = string.Empty;
if (current.ActiveFlag && (current.Userid != null) && (current.Userid.Trim().Length > 0))
{
try
{
Connections connection = (current.Userid.Trim().Length == 0) ? new Connections(current.ServerName, current.DatabaseName) : new Connections(current.ServerName, current.DatabaseName, current.Userid, current.Password);
this.connectionString = connection.ConnectionString();
this.dbProvider = current.dbProvider;
this.ICommands = new DbContext(new Connect()
{
ConnectionString = this.connectionString, DbProvider = this.dbProvider
}, this.BXConfig, this.TXConfig).ICommands;
break;
}
catch (Exception exc)
{
ILogger.Fatal(exc);
throw;
}
}
}
}
}
catch
{
throw;
}
}
