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