public async Task <IActionResult> getSensorDataCountByProjectId(List <int> projectId)
{
ResponseCtrMsg <List <KeyValuePair <int, int> > > response;
List <KeyValuePair <int, int> > sensorDataCountInfoList = new List <KeyValuePair <int, int> >();
foreach (var temp in projectId)
{
var result = await _context.TSensorData.Where(a => a.ProjectId == temp).CountAsync();
KeyValuePair <int, int> keyValuePair = new KeyValuePair <int, int>(temp, result);
sensorDataCountInfoList.Add(keyValuePair);
}
if (sensorDataCountInfoList.Count > 0)
{
response = new ResponseCtrMsg <List <KeyValuePair <int, int> > >(Enums.CtrResult.Success)
{
ResultObj = sensorDataCountInfoList
};
}
else
{
response = new ResponseCtrMsg <List <KeyValuePair <int, int> > >(Enums.CtrResult.Failure)
{
ResultObj = null
};
}
return(await Task.FromResult <IActionResult>(Ok(response)));
}
public async Task <IActionResult> getDeviceByProjectId(int projectId)
{
ResponseCtrMsg <List <TDevices> > response;
var result = await _context.TDevices.Where(a => a.ProjectId == projectId).ToListAsync();
if (result.Count > 0)
{
response = new ResponseCtrMsg <List <TDevices> >(Enums.CtrResult.Success)
{
ResultObj = result
};
}
else
{
response = new ResponseCtrMsg <List <TDevices> >(Enums.CtrResult.Failure)
{
ResultObj = null
};
}
return(await Task.FromResult <IActionResult>(Ok(response)));
}
public async Task <IActionResult> getDeviceDataRecord(string sensorTag, int deviceId, int count = 10)
{
ResponseCtrMsg <List <TSensorData> > response;
var result = await _context.TSensorData.Where(a => a.SensorTag == sensorTag && a.DeviceId == deviceId)
.OrderByDescending(a => a.CreateDate)
.Take(count).ToListAsync();
if (result.Count > 0)
{
response = new ResponseCtrMsg <List <TSensorData> >(Enums.CtrResult.Success)
{
ResultObj = result
};
}
else
{
response = new ResponseCtrMsg <List <TSensorData> >(Enums.CtrResult.Failure)
{
ResultObj = null
};
}
return(await Task.FromResult <IActionResult>(Ok(response)));
}
public async Task <IActionResult> getCurrentDeviceData(string sensorTag, int deviceId)
{
ResponseCtrMsg <TSensorData> response;
var result = await _context.TSensorData.Where(a => a.SensorTag == sensorTag && a.DeviceId == deviceId)
.OrderByDescending(a => a.CreateDate)
.FirstOrDefaultAsync();
if (result != null)
{
response = new ResponseCtrMsg <TSensorData>(Enums.CtrResult.Success)
{
ResultObj = result
};
}
else
{
response = new ResponseCtrMsg <TSensorData>(Enums.CtrResult.Failure)
{
ResultObj = null
};
}
return(Ok(response));
}
