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