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