public int GetNumberOfMsgBoxes() { BizTalkDBs bizTalkDBs = new BizTalkDBs(); try { int numberOfMsgBoxes; using (SqlConnection connection = new SqlConnection(string.Format(CONNECTIONSTRINGFORMAT, _database, _server))) { connection.Open(); SqlCommand command = new SqlCommand(ConfigurationManager.AppSettings["GetMsgBoxServersQuery"], connection); SqlDataReader reader = command.ExecuteReader(); reader.Read(); numberOfMsgBoxes = string.IsNullOrEmpty(reader["MSGBOXCOUNT"].ToString()) ? 1 : (int)reader["MSGBOXCOUNT"]; reader.Close(); } return(numberOfMsgBoxes); } catch { return(1); } }
private BizTalkDBs GetSqlServerNames() { BizTalkDBs bizTalkDBs = new BizTalkDBs(); try { using (SqlConnection connection = new SqlConnection(string.Format(CONNECTIONSTRINGFORMAT, _database, _server))) { connection.Open(); SqlCommand command = new SqlCommand(ConfigurationManager.AppSettings["GetSqlServersQuery"], connection); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (!string.IsNullOrEmpty(reader["TrackingDBServerName"].ToString())) { bizTalkDBs.TrackingDBServerName = reader["TrackingDBServerName"].ToString(); bizTalkDBs.TrackingDBServerNameComputerName = GetComputerName(bizTalkDBs.TrackingDBServerName); } if (!string.IsNullOrEmpty(reader["SubscriptionDBServerName"].ToString())) { bizTalkDBs.SubscriptionDBServerName = reader["SubscriptionDBServerName"].ToString(); bizTalkDBs.SubscriptionDBServerNameComputerName = GetComputerName(bizTalkDBs.SubscriptionDBServerName); } if (!string.IsNullOrEmpty(reader["BamDBServerName"].ToString())) { bizTalkDBs.BamDBServerName = reader["BamDBServerName"].ToString(); bizTalkDBs.BamDBServerNameComputerName = GetComputerName(bizTalkDBs.BamDBServerName); } if (!string.IsNullOrEmpty(reader["RuleEngineDBServerName"].ToString())) { bizTalkDBs.RuleEngineDBServerName = reader["RuleEngineDBServerName"].ToString(); bizTalkDBs.RuleEngineDBServerNameComputerName = GetComputerName(bizTalkDBs.RuleEngineDBServerName); } if (!string.IsNullOrEmpty(reader["BizTalkAdminGroup"].ToString())) { bizTalkDBs.BizTalkAdminGroup = reader["BizTalkAdminGroup"].ToString(); } } reader.Close(); } } catch (Exception ex) { throw new ApplicationException("Unable to find SQL Servers", ex); } return(bizTalkDBs); }
/// <summary> /// Queries the management database for all servers /// </summary> /// <param name="server"></param> /// <param name="mgmtDatabase"></param> /// <returns></returns> public List <Server> GetServers(string server, string mgmtDatabase) { List <Server> servers = new List <Server>(); BizTalkDBs bizTalkDBs = GetSqlServerNames(); this._btsAdmGroup = bizTalkDBs.BizTalkAdminGroup; if (servers.Count(s => s.Name == bizTalkDBs.SubscriptionDBServerNameComputerName) == 0) { servers.Add(new Server() { Name = bizTalkDBs.SubscriptionDBServerNameComputerName, Type = ServerType.SQL }); } //servers.Add(new Server() { Name = bizTalkDBs.BamDBServerNameComputerName, Type = ServerType.SQL }); //if (servers.Count(s => s.Name == bizTalkDBs.RuleEngineDBServerNameComputerName) == 0) // servers.Add(new Server() { Name = bizTalkDBs.RuleEngineDBServerNameComputerName, Type = ServerType.SQL }); //if (servers.Count(s => s.Name == bizTalkDBs.SubscriptionDBServerNameComputerName) == 0) // servers.Add(new Server() { Name = bizTalkDBs.SubscriptionDBServerNameComputerName, Type = ServerType.SQL }); //if (servers.Count(s => s.Name == bizTalkDBs.TrackingDBServerNameComputerName) == 0) // servers.Add(new Server() { Name = bizTalkDBs.TrackingDBServerNameComputerName, Type = ServerType.SQL }); foreach (string btsServer in GetApplicationServerNames()) { if (servers.Count(s => s.Name == btsServer && s.Type == ServerType.BIZTALK) == 0) { servers.Add(new Server() { Name = btsServer, Type = ServerType.BIZTALK }); } } return(servers); }