// GET: api/Incumbent public IEnumerable<BsonDocument> Get() { var svc = new Akron.Data.DataService(); var queryDoc = new QueryDocument(); var queryGroup = new GroupDefinition(); var qb = new QueryBuilder(); qb.SelectedSlicers.Add(new DimensionDefinition { Column = new DataColumnMetadata { ColumnName = "Year" }, IsDefault = true }); qb.SelectedSlicers.Add(new DimensionDefinition { Column = new DataColumnMetadata { ColumnName = "org_type" } }); qb.SelectedMeasures = new List<MeasureDefinition> { new MeasureDefinition { Column = new DataColumnMetadata {ColumnName = "Base_Pay"}, IsDefault = true, Operation = AggregateOperations.Average } }; var qd = qb.ToQueryDocument(); qd.CollectionName = "incumbent"; qd.DataSource = "hra"; qd.DataSourceLocation = "mongodb://localhost:27017"; var result = svc.GetData(qd); return result; }
public List<BsonDocument> GetSeries(QueryBuilder builder) { //year column is default; builder.SelectedSlicers.Insert(0, builder.AvailableSlicers.Single(x => x.IsDefault)); //add default org type if (builder.SelectedSlicers.Count == 1) builder.SelectedSlicers.Add( builder.AvailableSlicers.SingleOrDefault(x => x.Column.ColumnName == "Job_Family")); builder.SelectedMeasures = new List<MeasureDefinition> {builder.AvailableMeasures.Single(x => x.IsDefault)}; var qd = builder.ToSeriesQueryDocument(); qd.CollectionName = "incumbent"; qd.DataSource = "hra"; qd.DataSourceLocation = "mongodb://localhost:27017"; var service = new DataService(); var result = service.GetData(qd); return result; }
public List<BsonDocument> QueryData(QueryBuilder builder) { var qd = builder.ToQueryDocument(); qd.CollectionName = "incumbent"; qd.DataSource = "hra"; qd.DataSourceLocation = "mongodb://localhost:27017"; var service = new DataService(); return service.GetData(qd); }