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