private void GenerateQuery() { QueryEditor.ReadOnly = false; CommonFunctionality.ResetChecks(); try { var cic = (CohortIdentificationConfiguration)DatabaseObject; var builder = new CohortQueryBuilder(cic, null); if (!btnUseCache.Checked && cic.QueryCachingServer_ID.HasValue) { builder.CacheServer = null; } QueryEditor.Text = builder.SQL; CommonFunctionality.ScintillaGoRed(QueryEditor, false); } catch (Exception ex) { QueryEditor.Text = "Could not build Sql:" + ex.Message; CommonFunctionality.ScintillaGoRed(QueryEditor, true); CommonFunctionality.Fatal("Failed to build query", ex); } QueryEditor.ReadOnly = true; }
private void btnFetch_Click(object sender, EventArgs e) { //execution is already underway if (taskDiscoverState != null && !taskDiscoverState.IsCompleted) { return; } CommonFunctionality.ResetChecks(); _btnFetchData.Enabled = false; pbLoading.Visible = true; taskDiscoverState = Task.Run(() => DiscoverStates()).ContinueWith(UpdateStatesUI, TaskScheduler.FromCurrentSynchronizationContext()); }
public void GenerateChart() { CommonFunctionality.ResetChecks(); var allCatalogues = _collection.GetCatalogues(); Dictionary <Catalogue, Dictionary <DateTime, ArchivalPeriodicityCount> > cataloguesToAdd = new Dictionary <Catalogue, Dictionary <DateTime, ArchivalPeriodicityCount> >(); DQERepository dqeRepository; try { dqeRepository = new DQERepository(_activator.RepositoryLocator.CatalogueRepository); } catch (NotSupportedException e) { CommonFunctionality.Fatal("Failed to get DQE Repository", e); return; } foreach (var cata in allCatalogues.OrderBy(c => c.Name)) { var eval = dqeRepository.GetMostRecentEvaluationFor(cata); Dictionary <DateTime, ArchivalPeriodicityCount> dictionary = null; if (eval != null) { dictionary = PeriodicityState.GetPeriodicityCountsForEvaluation(eval); } cataloguesToAdd.Add(cata, dictionary); } //every month seen in every dataset ever var buckets = GetBuckets(cataloguesToAdd); racewayRenderArea.AddTracks(_activator, cataloguesToAdd, buckets, _collection.IgnoreRows); racewayRenderArea.Refresh(); this.Invalidate(); }
private void RefreshUIFromDatabase() { CommonFunctionality.ResetChecks(); try { if (bLoading) { return; } //only allow reordering when all are visible or only internal are visible otherwise user could select core only and do a reorder leaving supplemental columns as freaky orphans all down at the bottom fo the SQL! bLoading = true; List <ExtractionInformation> extractionInformations = GetSelectedExtractionInformations(); //add the available filters SetupAvailableFilters(extractionInformations); //generate SQL -- only make it readonly after setting the .Text otherwise it ignores the .Text setting even though it is programatical QueryPreview.ReadOnly = false; var collection = GetCollection(extractionInformations); QueryPreview.Text = collection.GetSql(); CommonFunctionality.ScintillaGoRed(QueryPreview, false); QueryPreview.ReadOnly = true; } catch (Exception ex) { CommonFunctionality.ScintillaGoRed(QueryPreview, ex); CommonFunctionality.Fatal(ex.Message, ex); } finally { bLoading = false; } }
private void RefreshUIFromDatabase() { CommonFunctionality.ResetChecks(); try { if (bLoading) { return; } //only allow reordering when all are visible or only internal are visible otherwise user could select core only and do a reorder leaving supplemental columns as freaky orphans all down at the bottom fo the SQL! bLoading = true; List <ExtractionInformation> extractionInformations = new List <ExtractionInformation>(); if (rbInternal.Checked) { extractionInformations.AddRange(_catalogue.GetAllExtractionInformation(ExtractionCategory.Internal)); } else { //always add the project specific ones extractionInformations.AddRange(_catalogue.GetAllExtractionInformation(ExtractionCategory.ProjectSpecific)); extractionInformations.AddRange(_catalogue.GetAllExtractionInformation(ExtractionCategory.Core)); if (rbSupplemental.Checked || rbSpecialApproval.Checked) { extractionInformations.AddRange(_catalogue.GetAllExtractionInformation(ExtractionCategory.Supplemental)); } if (rbSpecialApproval.Checked) { extractionInformations.AddRange(_catalogue.GetAllExtractionInformation(ExtractionCategory.SpecialApprovalRequired)); } } //sort by Default Order extractionInformations.Sort(); //add to listbox olvExtractionInformations.ClearObjects(); olvExtractionInformations.AddObjects(extractionInformations.ToArray()); //add the available filters var filters = extractionInformations.SelectMany(ei => ei.ExtractionFilters).ToArray(); //remove deleted ones if (olvFilters.Objects != null) { foreach (ExtractionFilter f in olvFilters.Objects.Cast <ExtractionFilter>().Except(filters).ToArray()) { olvFilters.RemoveObject(f); } } //add new ones foreach (ExtractionFilter f in filters) { if (olvFilters.IndexOf(f) == -1) { olvFilters.AddObject(f); } } //generate SQL -- only make it readonly after setting the .Text otherwise it ignores the .Text setting even though it is programatical QueryPreview.ReadOnly = false; QueryPreview.Text = GenerateExtractionSQLForCatalogue(extractionInformations.ToArray()); CommonFunctionality.ScintillaGoRed(QueryPreview, false); QueryPreview.ReadOnly = true; } catch (Exception ex) { CommonFunctionality.ScintillaGoRed(QueryPreview, ex); CommonFunctionality.Fatal(ex.Message, ex); } finally { bLoading = false; } }