private static ObjectBaseHash _GetServerCollection(string Ident_Domain, string UID_Profile, NodeType nodeType) { ISqlFormatter isql = clsMain.Instance.CurrentConnection.Connection.SqlFormatter; SqlExecutor cSQL = clsMain.Instance.CurrentConnection.Connection.CreateSqlExecutor(clsMain.Instance.CurrentConnection.PublicKey); ObjectBaseHash colServers = new ObjectBaseHash(); ObjectServer oServer = null; string strSQL = ""; switch (nodeType) { case NodeType.AppProfile: strSQL = clsMain.Instance.CurrentConnection.Connection.SqlStrings["ApplicationProfileServer"]; break; case NodeType.DrvProfile: strSQL = clsMain.Instance.CurrentConnection.Connection.SqlStrings["DriverProfileServer"]; break; case NodeType.MacType: strSQL = clsMain.Instance.CurrentConnection.Connection.SqlStrings["MachineTypeServer"]; break; } // replace the Domain-Variable strSQL = strSQL.Replace("@Ident_Domain", isql.FormatValue(Ident_Domain, ValType.String, true)); // replace UID_Profile strSQL = strSQL.Replace("@UID_Profile", isql.FormatValue(UID_Profile, ValType.String, true)); // and now do it... using (IDataReader rData = new CachedDataReader(cSQL.SqlExecute(strSQL))) { while (rData.Read()) { // create a server-object oServer = new ObjectServer(rData); // and add to our Hash colServers.Add(oServer, "UID_ApplicationServer"); } } return(colServers); }
private ObjectBaseHash _GetServerOfDomin(string parentDomain) { ISqlFormatter isql = clsMain.Instance.CurrentConnection.Connection.SqlFormatter; SqlExecutor cSQL = clsMain.Instance.CurrentConnection.Connection.CreateSqlExecutor(clsMain.Instance.CurrentConnection.PublicKey); string strSQL; ObjectBaseHash colServers = new ObjectBaseHash(); ObjectServer2 objServer; try { // get the gigantic SQL-Statement strSQL = clsMain.Instance.CurrentConnection.Connection.SqlStrings["ApplicationServer"]; // replace the Domain-Variable strSQL = strSQL.Replace("@Ident_DomainRD", isql.FormatValue(parentDomain, ValType.String)); using (IDataReader rData = new CachedDataReader(cSQL.SqlExecute(strSQL))) { while (rData.Read()) { // create a new Serverobject objServer = new ObjectServer2(rData); // appand to our list colServers.Add(objServer, "UID_ApplicationServer"); } } } catch (Exception ex) { ExceptionDialog.Show(this.ParentForm, ex); } return(colServers); }