public static void Show(ColumnsModel columns, string context, Func<IList<string>> bindingSuggestions, Func<IList<ColumnDefinition>> automaticColumnsFetcher)
{
var dialog = new ColumnsEditorDialog()
{
DataContext = new ColumnsEditorDialogViewModel(columns, context, bindingSuggestions, automaticColumnsFetcher)
};
dialog.Show();
}
public static void Show(ColumnsModel columns, string context, Func <IList <string> > bindingSuggestions, Func <IList <ColumnDefinition> > automaticColumnsFetcher)
{
var dialog = new ColumnsEditorDialog
{
DataContext = new ColumnsEditorDialogViewModel(columns, context, bindingSuggestions, automaticColumnsFetcher)
};
dialog.Show();
}
public ColumnsEditorDialogViewModel(ColumnsModel columns, string context, Func <IList <string> > suggestedBindingLoader, Func <IList <ColumnDefinition> > automaticColumnsFetcher)
{
this.columns = columns;
this.context = context;
this.suggestedBindingLoader = suggestedBindingLoader;
this.automaticColumnsFetcher = automaticColumnsFetcher;
columnEditorViewModels = new ObservableCollection <ColumnEditorViewModel>(ColumnEditorViewModelsFromColumns(this.columns.Columns));
AddEmptyRow();
SuggestedBindings = new ObservableCollection <string>();
IsCustomChoice = columns.Source == ColumnsSource.User;
}
public ColumnsEditorDialogViewModel(ColumnsModel columns, string context, Func<IList<string>> suggestedBindingLoader, Func<IList<ColumnDefinition>> automaticColumnsFetcher)
{
this.columns = columns;
this.context = context;
this.suggestedBindingLoader = suggestedBindingLoader;
this.automaticColumnsFetcher = automaticColumnsFetcher;
columnEditorViewModels = new ObservableCollection<ColumnEditorViewModel>(ColumnEditorViewModelsFromColumns(this.columns.Columns));
AddEmptyRow();
SuggestedBindings = new ObservableCollection<string>();
IsCustomChoice = columns.Source == ColumnsSource.User;
}
private void UpdateColumnSet()
{
if (!IsLoaded || ApplicationModel.Database.Value == null)
{
return;
}
var columnsModel = PerDatabaseState.DocumentViewState.GetDocumentState(context);
if (columnsModel != null)
{
Columns = columnsModel;
}
else
{
Columns = new ColumnsModel();
PerDatabaseState.DocumentViewState.SetDocumentState(context, Columns);
TryLoadDefaultColumnSet();
}
}
private async Task ExecuteReport()
{
QueryErrorMessage.Value = "";
IsErrorVisible.Value = false;
if (string.IsNullOrEmpty(GroupByField.Value))
{
ApplicationModel.Current.Notifications.Add(new Notification("You must select a field to group by"));
return;
}
if (ValueCalculations.Count == 0)
{
ApplicationModel.Current.Notifications.Add(new Notification("You must add at least one Value"));
return;
}
var facets = new List<AggregationQuery>();
foreach (var value in ValueCalculations)
{
var facetForField = facets.FirstOrDefault(f => f.AggregationField == value.Field);
if (facetForField != null)
{
facetForField.Aggregation |= value.SummaryMode;
}
else
{
facets.Add(new AggregationQuery
{
Name = GroupByField.Value,
DisplayName = GroupByField.Value + "-" + value.Field,
AggregationField = value.Field,
Aggregation = value.SummaryMode
});
}
}
ResultColumns = null;
Results.Clear();
var cancelationTokenSource = new CancellationTokenSource();
var progressWindow = new ProgressWindow()
{
Title = "Preparing Report",
IsIndeterminate = false,
CanCancel = true
};
progressWindow.Closed += delegate { cancelationTokenSource.Cancel(); };
progressWindow.Show();
var queryStartTime = DateTime.UtcNow.Ticks;
try
{
var results = new List<KeyValuePair<string, FacetResult>>();
var hasMoreResults = true;
var fetchedResults = 0;
while (hasMoreResults)
{
var queryFacetsTask = DatabaseCommands.GetFacetsAsync(IndexName,
new IndexQuery() {Query = FilterDoc.Text},
AggregationQuery.GetFacets(facets),
fetchedResults, 256);
await TaskEx.WhenAny(
queryFacetsTask,
TaskEx.Delay(int.MaxValue, cancelationTokenSource.Token));
if (cancelationTokenSource.IsCancellationRequested)
{
return;
}
var facetResults = await queryFacetsTask;
results.AddRange(facetResults.Results);
fetchedResults += facetResults.Results.Select(r => r.Value.Values.Count).Max();
var remainingResults = facetResults.Results.Select(r => r.Value.RemainingTermsCount).Max();
var totalResults = fetchedResults + remainingResults;
progressWindow.Progress = (int) ((fetchedResults/(double) totalResults)*100);
hasMoreResults = remainingResults > 0;
}
var rowsByKey = new Dictionary<string, ReportRow>();
var rows = new List<ReportRow>();
foreach (var facetResult in results)
{
var calculatedField = facetResult.Key.Split('-')[1];
foreach (var facetValue in facetResult.Value.Values)
{
ReportRow result;
if (!rowsByKey.TryGetValue(facetValue.Range, out result))
{
result = new ReportRow {Key = facetValue.Range};
rowsByKey.Add(result.Key, result);
rows.Add(result);
}
foreach (
var valueCalculation in ValueCalculations.Where(v => v.Field == calculatedField))
{
var value = facetValue.GetAggregation(valueCalculation.SummaryMode);
if (value.HasValue)
{
result.Values.Add(valueCalculation.Header,
facetValue.GetAggregation(valueCalculation.SummaryMode) ?? 0);
}
}
}
}
var columns = new ColumnsModel();
columns.Columns.Add(new ColumnDefinition()
{
Header = "Key",
Binding = "Key"
});
columns.Columns.AddRange(
ValueCalculations.Select(
k => new ColumnDefinition() {Header = k.Header, Binding = "Values[" + k.Header + "]"}));
Results.AddRange(rows);
ResultColumns = columns;
var queryEndTime = DateTime.UtcNow.Ticks;
ExecutionElapsedTime.Value = new TimeSpan(queryEndTime - queryStartTime);
}
catch (AggregateException ex)
{
var badRequest = ex.ExtractSingleInnerException() as BadRequestException;
if (badRequest != null)
{
QueryErrorMessage.Value = badRequest.Message;
IsErrorVisible.Value = true;
}
else
{
throw;
}
}
catch (TaskCanceledException)
{
}
finally
{
// there's a bug in silverlight where if a ChildWindow gets closed too soon after it's opened, it leaves the UI
// disabled; so delay closing the window by a few milliseconds
TaskEx.Delay(TimeSpan.FromMilliseconds(350))
.ContinueOnSuccessInTheUIThread(progressWindow.Close);
}
}
public void SetDocumentState(string context, ColumnsModel columns)
{
documentViewState[context] = columns;
}
