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