public void InsertingInputDataOfT3000ToPsychroDB(string panelID, string inputIndex,string inputDesc,string inputAM,string inputValue,string inputUnit,string inputRange,string inputCalibration,string inputCalSign,string inputFilter,string inputDecon,string inputJumper,string inputLabel )
{
string tableName = "tbl_" + selectedBuildingList[0].BuildingName + "_device"; // currentLineTableFromDB;
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();
//SQLiteDataReader reader = null;
string sql_string = "insert into " + tableName + " ( PanelID ,InputIndex ,InputDescription,InputAM ,InputValue,InputUnit,InputRange ,InputCalibration ,InputFilter ,InputJumper ,InputLabel ) VALUES( @PanelID ,@InputIndex ,@InputDescription,@InputAM , @InputValue ,@InputUnit,@InputRange ,@InputCalibration ,@InputFilter ,@InputJumper ,@InputLabel )";
SQLiteCommand command = new SQLiteCommand(sql_string, connection);
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("@PanelID", panelID);
command.Parameters.AddWithValue("@InputIndex", inputIndex);
command.Parameters.AddWithValue("@InputDescription",inputDesc);
command.Parameters.AddWithValue("@InputAM", inputAM);
command.Parameters.AddWithValue("@InputValue", inputValue);
command.Parameters.AddWithValue("@InputUnit", inputUnit);
command.Parameters.AddWithValue("@InputRange", inputRange);
command.Parameters.AddWithValue("@InputCalibration", inputCalibration);
command.Parameters.AddWithValue("@InputFilter", inputFilter);
command.Parameters.AddWithValue("@InputJumper", inputJumper);
command.Parameters.AddWithValue("@InputLabel", inputLabel);
command.ExecuteNonQuery();
}
}