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