private void UpdateChart(ConfigData data) { DispatcherHelper.CheckBeginInvokeOnUI(() => { //trim extra data while (DataReadings.Count > MAXRECORDS) { DataReadings.RemoveAt(0); } DataReadings.Add(data); }); }
//public void Post([FromBody] string value) public void Post() { HttpRequest req = Request; //Represents the REST request StreamReader sr = new StreamReader(req.Body); //plain-text must get data from Request.Body string sensData = sr.ReadToEnd(); //Read entire Request.Body data stream DataReadings dataReadings = new DataReadings(); dataReadings = JsonConvert.DeserializeObject <DataReadings>(sensData); //Make connection to my database within SQL server on my laptop with a login SqlServerConnHelp sqlConnManager = new SqlServerConnHelp(); //Use to connect to server SqlConnection sqlConnection = sqlConnManager.GetConnection(@"DELL-SVR\SQLEXPRESS", "SensorData", "jdw", "asdf"); //Use to connect to my laptop //SqlConnection sqlConnection = sqlConnManager.GetConnection(@"LAPTOP-AD2UF7HI\SQLEXPRESS", "SensorData", "jdw", "asdf"); //Used to insert data into the first database *SensorData* //Insert data:: Insert Into Table (Column A, Column B) Values (Value A, Value B) string query = "Insert Into SensorData (UniqueID, Transmitter_ID, IP_Address) Values (@UniqueID, @Transmitter_ID, @IP_Address)"; SqlCommand cmd = new SqlCommand(query, sqlConnection); //Create a new command for database w/ string and connection IdGenerator idGen = new IdGenerator(); //Create auto generating variable string uid = idGen.GetRandomTransmissionId(); //Fill out command with parameters cmd.Parameters.AddWithValue("@UniqueID", uid); cmd.Parameters.AddWithValue("@Transmitter_ID", "1111-FFFF"); cmd.Parameters.AddWithValue("@IP_Address", idGen.GetRandomIPAddress()); //Send command to database cmd.ExecuteNonQuery(); //Used to insert data into the second database *SensorDataDetail* for (int i = 0; i < 3; i++) { query = "Insert Into SensorDataDetail (UniqueID, SensorNode, SensorValue) Values (@UniqueID, @SensorNode, @SensorValue)"; cmd = new SqlCommand(query, sqlConnection); cmd.Parameters.AddWithValue("@UniqueID", uid); //Fillout command with paramaters switch (i) { case 0: cmd.Parameters.AddWithValue("@SensorNode", "Temperature"); cmd.Parameters.AddWithValue("@SensorValue", dataReadings.Temperature.ToString()); break; case 1: cmd.Parameters.AddWithValue("@SensorNode", "Moisture"); cmd.Parameters.AddWithValue("@SensorValue", dataReadings.Moisture.ToString()); break; case 2: cmd.Parameters.AddWithValue("@SensorNode", "Luminosity"); cmd.Parameters.AddWithValue("@SensorValue", dataReadings.Luminosity.ToString()); break; } //Send command to database cmd.ExecuteNonQuery(); } cmd.Dispose(); //clean up sqlConnection.Close(); //close connection to database sqlConnection.Dispose(); //clean up }