public static int Insert(bool dbconOpened, string tableName, string uniqueID, int personID, int sessionID, string type, double fixedPulse, int totalPulsesNum, string timeString, string description, int simulated)
{
if(! dbconOpened)
Sqlite.Open();
if(uniqueID == "-1")
uniqueID = "NULL";
dbcmd.CommandText = "INSERT INTO " + tableName +
" (uniqueID, personID, sessionID, type, fixedPulse, totalPulsesNum, timeString, description, simulated)" +
" VALUES (" + uniqueID + ", " + personID + ", " + sessionID + ", \"" + type + "\", "
+ Util.ConvertToPoint(fixedPulse) + ", " + totalPulsesNum + ", \""
+ timeString + "\", \"" + description + "\", " + simulated + ")" ;
LogB.SQL(dbcmd.CommandText.ToString());
dbcmd.ExecuteNonQuery();
//int myLast = dbcon.LastInsertRowId;
//http://stackoverflow.com/questions/4341178/getting-the-last-insert-id-with-sqlite-net-in-c
string myString = @"select last_insert_rowid()";
dbcmd.CommandText = myString;
int myLast = Convert.ToInt32(dbcmd.ExecuteScalar()); // Need to type-cast since `ExecuteScalar` returns an object.
if(! dbconOpened)
Sqlite.Close();
return myLast;
}