public static Delete ( bool dbconOpened, string tableName, int uniqueID ) : void | ||
dbconOpened | bool | |
tableName | string | |
uniqueID | int | |
return | void |
private void on_delete_selected_row_clicked(object o, EventArgs args) { int uniqueID = UtilGtk.GetSelectedRowUniqueID( treeview_load, store_load, store_load_uniqueID_col); if (uniqueID > 0) { Sqlite.Delete(false, Constants.ExecuteAutoTable, uniqueID); store_load = UtilGtk.RemoveRow(treeview_load, store_load); button_next.Sensitive = false; } }
void on_button_accept_clicked(object o, EventArgs args) { //foreach all lines... extrac intervalTimesString TreeIter myIter; string timeString = ""; bool iterOk = store.GetIterFirst(out myIter); if (iterOk) { string equal = ""; //first iteration should not appear '=' do { timeString = timeString + equal + (string)treeview_subevents.Model.GetValue(myIter, 1); equal = "="; } while (store.IterNext(ref myIter)); } //calculate other variables needed for pulse creation myPulse.TotalPulsesNum = Util.GetNumberOfJumps(timeString, false); //don't need a GetNumberOfRuns, this works myPulse.TimesString = timeString; //save it deleting the old first for having the same uniqueID Sqlite.Delete(false, Constants.PulseTable, myPulse.UniqueID); myPulse.InsertAtDB(false, Constants.PulseTable); /* * SqlitePulse.Insert(myPulse.UniqueID.ToString(), * myPulse.PersonID, myPulse.SessionID, * myPulse.Type, myPulse.FixedPulse, totalPulsesNum, * timeString, myPulse.Description * ); */ //close the window RepairPulseWindowBox.repair_sub_event.Hide(); RepairPulseWindowBox = null; }
public static void DeleteAllStuff(string uniqueID) { Sqlite.Open(); //delete the session dbcmd.CommandText = "Delete FROM " + Constants.SessionTable + " WHERE uniqueID == " + uniqueID; dbcmd.ExecuteNonQuery(); //delete relations (existance) within persons and sessions in this session dbcmd.CommandText = "Delete FROM " + Constants.PersonSessionTable + " WHERE sessionID == " + uniqueID; dbcmd.ExecuteNonQuery(); Sqlite.deleteOrphanedPersons(); //delete normal jumps dbcmd.CommandText = "Delete FROM " + Constants.JumpTable + " WHERE sessionID == " + uniqueID; dbcmd.ExecuteNonQuery(); //delete repetitive jumps dbcmd.CommandText = "Delete FROM " + Constants.JumpRjTable + " WHERE sessionID == " + uniqueID; dbcmd.ExecuteNonQuery(); //delete normal runs dbcmd.CommandText = "Delete FROM " + Constants.RunTable + " WHERE sessionID == " + uniqueID; dbcmd.ExecuteNonQuery(); //delete intervallic runs dbcmd.CommandText = "Delete FROM " + Constants.RunIntervalTable + " WHERE sessionID == " + uniqueID; dbcmd.ExecuteNonQuery(); //delete reaction times dbcmd.CommandText = "Delete FROM " + Constants.ReactionTimeTable + " WHERE sessionID == " + uniqueID; dbcmd.ExecuteNonQuery(); //delete pulses dbcmd.CommandText = "Delete FROM " + Constants.PulseTable + " WHERE sessionID == " + uniqueID; dbcmd.ExecuteNonQuery(); //delete multiChronopic dbcmd.CommandText = "Delete FROM " + Constants.MultiChronopicTable + " WHERE sessionID == " + uniqueID; dbcmd.ExecuteNonQuery(); //delete from encoder start ------> //signals ArrayList encoderArray = SqliteEncoder.Select( true, -1, -1, Convert.ToInt32(uniqueID), Constants.EncoderGI.ALL, -1, "signal", EncoderSQL.Eccons.ALL, false, true); foreach (EncoderSQL eSQL in encoderArray) { Util.FileDelete(eSQL.GetFullURL(false)); //signal, don't convertPathToR if (eSQL.videoURL != "") { Util.FileDelete(eSQL.videoURL); //video } Sqlite.Delete(true, Constants.EncoderTable, Convert.ToInt32(eSQL.uniqueID)); } //curves encoderArray = SqliteEncoder.Select( true, -1, -1, Convert.ToInt32(uniqueID), Constants.EncoderGI.ALL, -1, "curve", EncoderSQL.Eccons.ALL, false, true); foreach (EncoderSQL eSQL in encoderArray) { Util.FileDelete(eSQL.GetFullURL(false)); //don't convertPathToR /* commented: curve has no video * if(eSQL.videoURL != "") * Util.FileDelete(eSQL.videoURL); */ Sqlite.Delete(true, Constants.EncoderTable, Convert.ToInt32(eSQL.uniqueID)); SqliteEncoder.DeleteSignalCurveWithCurveID(true, Convert.ToInt32(eSQL.uniqueID)); } //<------- delete from encoder end Sqlite.Close(); }
public static void DeletePersonFromSessionAndTests(string sessionID, string personID) { Sqlite.Open(); //1.- first delete in personSession77 at this session //delete relations (existance) within persons and sessions in this session dbcmd.CommandText = "Delete FROM " + Constants.PersonSessionTable + " WHERE sessionID == " + sessionID + " AND personID == " + personID; dbcmd.ExecuteNonQuery(); //2.- Now, it's not in this personSession77 in other sessions, delete if from DB //if person is not in other sessions, delete it from DB if (!PersonExistsInPS(true, Convert.ToInt32(personID))) { //this will open and close DB connection Delete(true, Constants.PersonTable, Convert.ToInt32(personID)); //delete photos if any if (File.Exists(Util.GetPhotoFileName(false, Convert.ToInt32(personID)))) { File.Delete(Util.GetPhotoFileName(false, Convert.ToInt32(personID))); } if (File.Exists(Util.GetPhotoFileName(true, Convert.ToInt32(personID)))) { File.Delete(Util.GetPhotoFileName(true, Convert.ToInt32(personID))); } } //3.- Delete tests //delete normal jumps dbcmd.CommandText = "Delete FROM jump WHERE sessionID == " + sessionID + " AND personID == " + personID; dbcmd.ExecuteNonQuery(); //delete repetitive jumps dbcmd.CommandText = "Delete FROM jumpRj WHERE sessionID == " + sessionID + " AND personID == " + personID; dbcmd.ExecuteNonQuery(); //delete normal runs dbcmd.CommandText = "Delete FROM run WHERE sessionID == " + sessionID + " AND personID == " + personID; dbcmd.ExecuteNonQuery(); //delete intervallic runs dbcmd.CommandText = "Delete FROM runInterval WHERE sessionID == " + sessionID + " AND personID == " + personID; dbcmd.ExecuteNonQuery(); //delete reaction times dbcmd.CommandText = "Delete FROM reactionTime WHERE sessionID == " + sessionID + " AND personID == " + personID; dbcmd.ExecuteNonQuery(); //delete pulses dbcmd.CommandText = "Delete FROM pulse WHERE sessionID == " + sessionID + " AND personID == " + personID; dbcmd.ExecuteNonQuery(); //delete multiChronopic dbcmd.CommandText = "Delete FROM multiChronopic WHERE sessionID == " + sessionID + " AND personID == " + personID; dbcmd.ExecuteNonQuery(); //delete from encoder dbcmd.CommandText = "Delete FROM " + Constants.EncoderTable + " WHERE sessionID == " + sessionID + " AND personID == " + personID; dbcmd.ExecuteNonQuery(); //delete encoder signal and curves (and it's videos) ArrayList encoderArray = SqliteEncoder.Select( true, -1, Convert.ToInt32(personID), Convert.ToInt32(sessionID), Constants.EncoderGI.ALL, -1, "signal", EncoderSQL.Eccons.ALL, false, true); foreach (EncoderSQL eSQL in encoderArray) { Util.FileDelete(eSQL.GetFullURL(false)); //signal, don't convertPathToR if (eSQL.future2 != "") { Util.FileDelete(eSQL.future2); //video } Sqlite.Delete(true, Constants.EncoderTable, Convert.ToInt32(eSQL.uniqueID)); } encoderArray = SqliteEncoder.Select( true, -1, Convert.ToInt32(personID), Convert.ToInt32(sessionID), Constants.EncoderGI.ALL, -1, "curve", EncoderSQL.Eccons.ALL, false, true); foreach (EncoderSQL eSQL in encoderArray) { Util.FileDelete(eSQL.GetFullURL(false)); //don't convertPathToR /* commented: curve has no video * if(eSQL.future2 != "") * Util.FileDelete(eSQL.future2); */ Sqlite.Delete(true, Constants.EncoderTable, Convert.ToInt32(eSQL.uniqueID)); SqliteEncoder.DeleteSignalCurveWithCurveID(true, Convert.ToInt32(eSQL.uniqueID)); } //4.- TODO: delete videos Sqlite.Close(); }