/// <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;
}
}
public DataService(string connectionString, ILogger <DataService> logger)
{
Context = new Context.DbContext(connectionString);
Logger = logger;
}
