private void BackgroundWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
try
{
if (e.Error != null)
{
SccmExceptionDialog.ShowDialog(this, e.Error, "Error");
}
else
{
Initialized = true;
}
}
finally
{
if (sender as SmsBackgroundWorker == backgroundWorker)
{
backgroundWorker.Dispose();
backgroundWorker = null;
UseWaitCursor = false;
listViewCollections.IsLoading = false;
listViewCollections.UpdateColumnWidth(columnHeaderCollection);
}
}
}
/// <summary>
/// This event is fired when all results have been received from the above query.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
void worker_QueryProcessorCompleted(object sender, RunWorkerCompletedEventArgs e)
{
SmsBackgroundWorker worker = sender as SmsBackgroundWorker;
System.Diagnostics.Debug.Assert(worker != null, "Completion event send from unexpected sender");
worker.Dispose();
}
private void BackgroundWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
try
{
if (e.Error != null)
{
using (SccmExceptionDialog sccmExceptionDialog = new SccmExceptionDialog(e.Error))
{
sccmExceptionDialog.ShowDialog();
}
}
else if (e.Cancelled)
{
ConnectionManagerBase.SmsTraceSource.TraceEvent(TraceEventType.Information, 1, "User canceled");
}
else
{
Initialized = true;
}
}
finally
{
if (sender as SmsBackgroundWorker == backgroundWorker)
{
backgroundWorker.Dispose();
backgroundWorker = null;
dataGridViewApplications.Sort(columnName, ListSortDirection.Ascending);
UseWaitCursor = false;
}
}
}
private void BackgroundWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
try
{
if (e.Error != null)
{
SccmExceptionDialog.ShowDialog(this, e.Error, "Error");
}
else
{
Initialized = true;
}
}
finally
{
if (sender as SmsBackgroundWorker == backgroundWorker)
{
backgroundWorker.Dispose();
backgroundWorker = null;
UseWaitCursor = false;
dataGridViewUpdates.Sort(columnTitle, ListSortDirection.Ascending);
Utility.UpdateDataGridViewColumnsSize(dataGridViewUpdates, columnTitle);
}
}
}
private void BackgroundWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
try
{
if (e.Error != null)
{
SccmExceptionDialog.ShowDialog(this, e.Error, "Error");
}
else
{
Initialized = true;
}
}
finally
{
if (sender as SmsBackgroundWorker == smsBackgroundWorker)
{
smsBackgroundWorker.Dispose();
smsBackgroundWorker = null;
dataGridViewCollections.Sort(columnCollection, ListSortDirection.Ascending);
UseWaitCursor = false;
labelCount.Text = dataGridViewCollections.Rows.Count.ToString();
}
}
}
private void BackgroundWorkerQueryMachine_QueryProcessorCompleted(object sender, RunWorkerCompletedEventArgs e)
{
try
{
if (e.Error != null)
{
SccmExceptionDialog.ShowDialog(this, e.Error, "Error");
}
else if (e.Cancelled)
{
if (listViewSelectedResources.Items.Count > 0)
{
listViewSelectedResources.Items[0].Selected = true;
listViewSelectedResources.Items[0].Focused = true;
}
}
else if (listViewSelectedResources.Items.Count > 0)
{
listViewSelectedResources.Items[0].Selected = true;
listViewSelectedResources.Items[0].Focused = true;
}
}
finally
{
backgroundWorkerQueryMachine.Dispose();
backgroundWorkerQueryMachine = null;
UseWaitCursor = false;
buttonSearch.Focus();
buttonSearch.Text = "Search";
searchCompleteTime = DateTime.Now.Ticks;
controlsInspector.InspectAll();
UtilitiesClass.UpdateListViewColumnsSize(listViewSelectedResources, columnMachineName);
}
}
/// <summary>
/// Dig into the relationships of collections
/// </summary>
/// <param name="CollectionID"></param>
private void GetNestedCollection(string CollectionID)
{
SmsBackgroundWorker worker = new SmsBackgroundWorker();
worker.QueryProcessorObjectReady += new EventHandler <QueryProcessorObjectEventArgs>(worker_QueryProcessorObjectReady);
worker.QueryProcessorCompleted += new EventHandler <RunWorkerCompletedEventArgs>(worker_QueryProcessorCompleted);
string queryToRun = string.Format(CultureInfo.InvariantCulture, "SELECT SMS_CollectionDependencies.*,SMS_Collection.Name FROM SMS_CollectionDependencies INNER JOIN SMS_Collection ON SMS_CollectionDependencies.DependentCollectionID = SMS_Collection.CollectionID WHERE RelationshipType = '2' AND SourceCollectionID='{0}'", PropertyManager.ConnectionManager.EscapeQueryString(CollectionID, ConnectionManagerBase.EscapeQuoteType.SingleQuote));
QueryProcessor.ProcessQuery(worker, queryToRun);
}
public override void InitializePageControl()
{
base.InitializePageControl();
dataGridViewApplications.Rows.Clear();
ControlsInspector.AddControl(dataGridViewApplications, new ControlDataStateEvaluator(ValidateSelectedApplications), "Select an application");
string query = string.Format("SELECT * FROM SMS_Application WHERE IsLatest = 1 AND IsExpired = 1 AND HasContent = 1");
backgroundWorker = new SmsBackgroundWorker();
backgroundWorker.QueryProcessorCompleted += new EventHandler <RunWorkerCompletedEventArgs>(BackgroundWorker_RunWorkerCompleted);
backgroundWorker.QueryProcessorObjectsReady += new EventHandler <QueryProcessorObjectsEventArgs>(BackgroundWorker_QueryProcessorObjectsReady);
UseWaitCursor = true;
QueryProcessor.ProcessQuery(backgroundWorker, query);
}
public override void InitializePageControl()
{
base.InitializePageControl();
listViewCollections.UpdateColumnWidth(columnHeaderCollection);
listViewCollections.Items.Clear();
listViewCollections.IsLoading = true;
string query = string.Format("SELECT SMS_Collection.* FROM SMS_FullCollectionMembership, SMS_Collection where ResourceID = '{0}' and SMS_FullCollectionMembership.CollectionID = SMS_Collection.CollectionID", PropertyManager["ResourceID"].IntegerValue);
backgroundWorker = new SmsBackgroundWorker();
backgroundWorker.QueryProcessorCompleted += new EventHandler <RunWorkerCompletedEventArgs>(BackgroundWorker_RunWorkerCompleted);
backgroundWorker.QueryProcessorObjectsReady += new EventHandler <QueryProcessorObjectsEventArgs>(BackgroundWorker_QueryProcessorObjectsReady);
ConnectionManagerBase.SmsTraceSource.TraceEvent(TraceEventType.Information, 1, "InitializePageControl");
UseWaitCursor = true;
QueryProcessor.ProcessQuery(backgroundWorker, query);
}
public override void InitializePageControl()
{
base.InitializePageControl();
dataGridViewUpdates.Rows.Clear();
dataGridViewUpdates.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
ControlsInspector.AddControl(dataGridViewUpdates, new ControlDataStateEvaluator(ValidateSelectedUpdatesPackages), "Select updates to remove");
string query = string.Format("SELECT SU.CI_ID,SU.LocalizedDisplayName,SU.IsExpired,SU.IsSuperseded,SU.ArticleID FROM SMS_SoftwareUpdate AS SU JOIN SMS_CIRelation AS CIR ON SU.CI_ID = CIR.ToCIID WHERE CIR.RelationType = 1 AND (SU.IsExpired = 1 OR SU.IsSuperseded = 1)");
backgroundWorker = new SmsBackgroundWorker();
backgroundWorker.QueryProcessorCompleted += new EventHandler <RunWorkerCompletedEventArgs>(BackgroundWorker_RunWorkerCompleted);
backgroundWorker.QueryProcessorObjectsReady += new EventHandler <QueryProcessorObjectsEventArgs>(BackgroundWorker_QueryProcessorObjectsReady);
UseWaitCursor = true;
QueryProcessor.ProcessQuery(backgroundWorker, query);
}
public override void InitializePageControl()
{
base.InitializePageControl();
dataGridViewCollections.Rows.Clear();
dataGridViewCollections.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
ControlsInspector.AddControl(dataGridViewCollections, new ControlDataStateEvaluator(ValidateSelectedCollections), "Select collections to disable");
string query = string.Format("SELECT * FROM SMS_Collection WHERE RefreshType IN (4,6) AND CollectionType = 2 AND CollectionID NOT LIKE 'SMS%'");
smsBackgroundWorker = new SmsBackgroundWorker();
smsBackgroundWorker.QueryProcessorCompleted += new EventHandler <RunWorkerCompletedEventArgs>(BackgroundWorker_RunWorkerCompleted);
smsBackgroundWorker.QueryProcessorObjectsReady += new EventHandler <QueryProcessorObjectsEventArgs>(BackgroundWorker_QueryProcessorObjectsReady);
UseWaitCursor = true;
QueryProcessor.ProcessQuery(smsBackgroundWorker, query);
}
private void ButtonSURefresh_Click(object sender, EventArgs e)
{
listViewWindows.UpdateColumnWidth(columnHeaderWindows);
listViewWindows.Items.Clear();
listViewWindows.IsLoading = true;
listViewUpcomingWindows.UpdateColumnWidth(columnHeaderUpcomingTime);
listViewUpcomingWindows.Items.Clear();
listViewUpcomingWindows.IsLoading = true;
string query = string.Format("SELECT SMS_Collection.* FROM SMS_FullCollectionMembership, SMS_Collection where ResourceID = '{0}' and ServiceWindowsCount > 0 and SMS_FullCollectionMembership.CollectionID = SMS_Collection.CollectionID", PropertyManager["ResourceID"].IntegerValue);
backgroundWorker = new SmsBackgroundWorker();
backgroundWorker.QueryProcessorCompleted += new EventHandler <RunWorkerCompletedEventArgs>(BackgroundWorker_RunWorkerCompleted);
backgroundWorker.QueryProcessorObjectsReady += new EventHandler <QueryProcessorObjectsEventArgs>(BackgroundWorker_QueryProcessorObjectsReady);
ConnectionManagerBase.SmsTraceSource.TraceEvent(TraceEventType.Information, 1, "InitializePageControl");
UseWaitCursor = true;
QueryProcessor.ProcessQuery(backgroundWorker, query);
}
private void BackgroundWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
try
{
if (e.Error != null)
{
SccmExceptionDialog.ShowDialog(this, e.Error, "Error");
}
}
finally
{
if (sender as SmsBackgroundWorker == backgroundWorker)
{
backgroundWorker.Dispose();
backgroundWorker = null;
UseWaitCursor = false;
listViewWindows.IsLoading = false;
listViewUpcomingWindows.IsLoading = false;
listViewWindows.UpdateColumnWidth(columnHeaderWindows);
listViewUpcomingWindows.UpdateColumnWidth(columnHeaderUpcomingTime);
}
}
}
private void ButtonSearch_Click(object sender, EventArgs e)
{
if (searchCompleteTime > 0L && DateTime.Now.Ticks - searchCompleteTime < SystemInformation.DoubleClickTime * 5000L)
{
return;
}
if (backgroundWorkerQueryMachine != null && backgroundWorkerQueryMachine.IsBusy)
{
backgroundWorkerQueryMachine.CancelAsync();
UseWaitCursor = false;
}
else
{
if (string.IsNullOrWhiteSpace(textBoxSeachList.Text))
{
return;
}
List <string> resourceList = new List <string>();
foreach (string line in textBoxSeachList.Lines)
{
resourceList.Add(line);
}
string query = string.Format("SELECT * From SMS_R_System WHERE Name IN ('{0}') ORDER by Name", string.Join("','", resourceList));
backgroundWorkerQueryMachine = new SmsBackgroundWorker(20);
backgroundWorkerQueryMachine.QueryProcessorObjectsReady += new EventHandler <QueryProcessorObjectsEventArgs>(BackgroundWorkerQueryMachine_QueryProcessorObjectsEvent);
backgroundWorkerQueryMachine.QueryProcessorCompleted += new EventHandler <RunWorkerCompletedEventArgs>(BackgroundWorkerQueryMachine_QueryProcessorCompleted);
buttonSearch.Text = "Stop";
UseWaitCursor = true;
listViewSelectedResources.Items.Clear();
ConnectionManager.QueryProcessor.ProcessQuery(backgroundWorkerQueryMachine, query);
}
}
