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