public DahsboardDataParameters(DashboardDataInput input)
{
DimensionColumns = new List <DimensionColumn>();
MeasureColumns = new List <MeasureColumn>();
foreach (var inputDimension in input.Dimensions)
{
DimensionColumn dim = JsonConvert.DeserializeObject <DimensionColumn>(inputDimension);
DimensionColumns.Add(dim);
}
foreach (var inputMeasure in input.Measures)
{
MeasureColumn mis = JsonConvert.DeserializeObject <MeasureColumn>(inputMeasure);
MeasureColumns.Add(mis);
}
}
public async Task <IEnumerable <IDictionary <string, object> > > GetData2(DashboardDataInput input)
{
QueryGenerator queryBuilder = new QueryGenerator(connectionString);
queryBuilder.TableName = "Vehicles";
var dashboardDataParameters = new DahsboardDataParameters(input);
List <DimensionColumn> dims = new List <DimensionColumn>();
dims.AddRange(dashboardDataParameters.DimensionColumns);
queryBuilder.Dimensions = dims;
List <MeasureColumn> measures = new List <MeasureColumn>();
measures.AddRange(dashboardDataParameters.MeasureColumns);
queryBuilder.Measures = measures;
var results = queryBuilder.GetGroupedData();
return(results);
}
