| 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();
}
