public TableRowsApiResultModel GetLabelData(PspDbMeasurement pspDbMeasurement, int fromTime, int toTime) { // get the label details from the sqlite context string sql = $"select {pspDbMeasurement.PspTimeCol}, {pspDbMeasurement.PspValCol} from {pspDbMeasurement.PspTable} where {pspDbMeasurement.EntityCol}='{pspDbMeasurement.EntityVal}' AND ({pspDbMeasurement.PspTimeCol} BETWEEN {fromTime} AND {toTime}) ORDER BY {pspDbMeasurement.PspTimeCol} ASC"; return(GetDbTableRows(sql)); //todo handle if sqlStr attribute of pspDbMeasurement is not null }
public TableRowsApiResultModel Get([BindRequired, FromQuery] string label, [BindRequired, FromQuery] int from_time, [BindRequired, FromQuery] int to_time) { PspDbHelper helper = new PspDbHelper { ConnStr = Configuration["dbinfo:ConnectionString"] }; //return helper.GetDbTableRows("select * from DIM_CONDUCTOR"); try { PspDbMeasurement pspDbMeasurement = _AppDbContext.PspDbMeasurements.Single(m => m.Label == label); return(helper.GetLabelData(pspDbMeasurement, from_time, to_time)); } catch (Exception e) { Console.WriteLine(e.Message); return(new TableRowsApiResultModel()); } }