public void UpdateNodeInfoToDBFromTemperatureDeviceSource(string id, double xVal, double yVal, string TemperatureSource, string HumiditySource,string name, Color colorValue, int airFlow, int nodeSizeValue)
{
string tableName = "tbl_" + selectedBuildingList[0].BuildingName + "_node_value";//currentNodeTableFromDB;
string databasePath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
string databaseFile = databasePath + @"\db_psychrometric_project.s3db";
string connString = @"Data Source=" + databaseFile + ";Version=3;";
using (SQLiteConnection connection = new SQLiteConnection(connString))
{
connection.Open();
string sql_string = "UPDATE " + tableName + " set xValue =@xVal , yValue=@yVal, temperature_source=@tempSource,humidity_source=@humSource ,name=@name, colorValue=@colorVal, airFlow=@airflow , nodeSize=@node_size_value ,lastUpdatedDate= @date where nodeID =@id";
SQLiteCommand command = new SQLiteCommand(sql_string, connection);
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@xVal", xVal.ToString());
command.Parameters.AddWithValue("@yVal", yVal.ToString());
// command.Parameters.AddWithValue("@source", source);
command.Parameters.AddWithValue("@tempSource", TemperatureSource);
command.Parameters.AddWithValue("@humSource", HumiditySource);
command.Parameters.AddWithValue("@name", name);
//command.Parameters.AddWithValue("@label", label);
command.Parameters.AddWithValue("@colorVal", ColorTranslator.ToHtml(colorValue));
//command.Parameters.AddWithValue("@text", showItemText);
command.Parameters.AddWithValue("@airflow", airFlow.ToString());
command.Parameters.AddWithValue("@node_size_value", nodeSizeValue);
command.Parameters.AddWithValue("@date", DateTime.Now); //This is the date presented at what time the update was performed
command.Parameters.AddWithValue("@id", id);
//MessageBox.Show("selected value = " + cb_station_names.SelectedItem.ToString());
command.ExecuteNonQuery();
}
}//--close of insertnodeinfotodb fxn