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