private void MakeVisibleInWsusConsole(IUpdate PublishedUpdate)
{
Logger.EnteringMethod();
SqlHelper sqlHelper = SqlHelper.GetInstance();
string sqlServerName = _wsus.GetSqlServerName();
string sqlDataBaseName = _wsus.GetSqlDataBaseName();
System.Version wsusVersion = _wsus.GetServerVersion();
if (PublishedUpdate == null)
{
return;
}
if (sqlServerName.Contains("MICROSOFT##SSEE") || sqlServerName.Contains("MICROSOFT##WID"))
{
if (wsusVersion.Major == 3)
{
sqlHelper.ServerName = @"\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query";
}
if (wsusVersion.Major == 6)
{
sqlHelper.ServerName = @"\\.\pipe\Microsoft##WID\tsql\query";
}
sqlHelper.DataBaseName = "SUSDB";
}
else
{
sqlHelper.ServerName = _wsus.GetSqlServerName();
sqlHelper.DataBaseName = _wsus.GetSqlDataBaseName();
}
Logger.Write(sqlHelper.ServerName);
Logger.Write(sqlHelper.DataBaseName);
if (sqlHelper.Connect(string.Empty, string.Empty))
{
Logger.Write("Connected to SQL.");
List <Guid> updateIDs = new List <Guid>();
updateIDs.Add(PublishedUpdate.Id.UpdateId);
UpdateCategoryCollection categories = PublishedUpdate.GetUpdateCategories();
foreach (IUpdateCategory category in categories)
{
if (!updateIDs.Contains(category.Id))
{
updateIDs.Add(category.Id);
}
if (category.ProhibitsSubcategories && !category.ProhibitsUpdates)
{
IUpdateCategory parentCategory = category.GetParentUpdateCategory();
if (!updateIDs.Contains(parentCategory.Id))
{
updateIDs.Add(parentCategory.Id);
}
}
}
sqlHelper.ShowUpdatesInConsole(updateIDs);
sqlHelper.Disconnect();
}
}
internal FrmUpdateWizard(Dictionary <Guid, Company> Companies, IUpdate updateToRevise)
{
Logger.EnteringMethod("FrmUpdateWizard");
InitializeComponent();
WsusWrapper _wsus = WsusWrapper.GetInstance();
Revising = true;
this.Sdp = _wsus.GetMetaData(updateToRevise);
this.Companies = Companies;
IUpdateCategory productCategory = updateToRevise.GetUpdateCategories()[0];
IUpdateCategory companyCategory = productCategory.GetParentUpdateCategory();
InitializeComponent(this.Companies, Companies[companyCategory.Id], Companies[companyCategory.Id].Products[productCategory.Id], Sdp);
}