/* SQLデータベース受信用
public string Get()
{
var uriStr = APP_URL_MOBILE_SERVICES + "/tables/SensorLog";
var response = getToMobileServices(uriStr);
return "success; " + response.Content.ToString();
}*/
/* SQLデータベース送信用
public string Get(string device_id)
{
try
{
if (device_id == "empty_test")
{
SensorLog emptySensorLog = new SensorLog(device_id);
insertSensorLog(emptySensorLog);
return "empty stored";
}
var queryPairs = this.Request.GetQueryNameValuePairs();
SensorLog sensorLog = new SensorLog(device_id)
{
Pressure = double.Parse(queryPairs.First(q => q.Key == "pressure").Value),
Humidity = double.Parse(queryPairs.First(q => q.Key == "humidity").Value),
Temperature = double.Parse(queryPairs.First(q => q.Key == "temperature").Value),
MagnetoX = int.Parse(queryPairs.First(q => q.Key == "magneto_x").Value),
MagnetoY = int.Parse(queryPairs.First(q => q.Key == "magneto_y").Value),
MagnetoZ = int.Parse(queryPairs.First(q => q.Key == "magneto_z").Value),
AccelerationX = int.Parse(queryPairs.First(q => q.Key == "acceleration_x").Value),
AccelerationY = int.Parse(queryPairs.First(q => q.Key == "acceleration_y").Value),
AccelerationZ = int.Parse(queryPairs.First(q => q.Key == "acceleration_z").Value),
GyroX = int.Parse(queryPairs.First(q => q.Key == "gyro_x").Value),
GyroY = int.Parse(queryPairs.First(q => q.Key == "gyro_y").Value),
GyroZ = int.Parse(queryPairs.First(q => q.Key == "gyro_z").Value)
};
//insertSensorLog(sensorLog);
return "stored; " + sendDataToMobileService(sensorLog);
}
catch (Exception ex)
{
return "error; " + ex.ToString();
}
}*/
private string sendDataToMobileService(SensorLog sensorLog)
{
var uriStr = APP_URL_MOBILE_SERVICES + "tables/SensorLog"
+ "?deviceId=" + sensorLog.DeviceId
+ "&pressure=" + sensorLog.Pressure
+ "&humidity=" + sensorLog.Humidity
+ "&temperature=" + sensorLog.Temperature
+ "&magneto_x=" + sensorLog.MagnetoX
+ "&magneto_y=" + sensorLog.MagnetoY
+ "&magneto_z=" + sensorLog.MagnetoZ
+ "&acceleration_x=" + sensorLog.AccelerationX
+ "&acceleration_y=" + sensorLog.AccelerationY
+ "&acceleration_z=" + sensorLog.AccelerationZ
+ "&gyro_x=" + sensorLog.GyroX
+ "&gyro_y=" + sensorLog.GyroY
+ "&gyro_z=" + sensorLog.GyroZ;
var result = postToMobileServices(uriStr);
return result.ToString();
}
private void insertSensorLog(SensorLog sensorLog)
{
string storeCS = CloudConfigurationManager.GetSetting("StorageConnectionString");
CloudStorageAccount storageAccound = CloudStorageAccount.Parse(storeCS);
CloudTableClient tableClient = storageAccound.CreateCloudTableClient();
CloudTable sensorLogTable = tableClient.GetTableReference("SensorLog");
sensorLogTable.CreateIfNotExistsAsync().Wait();
sensorLogTable.ExecuteAsync(TableOperation.Insert(sensorLog)).Wait();
this.StatusCode(HttpStatusCode.OK);
}
