public static GoNoGoData getGoNoGoToUpload(int log_id)
{
GoNoGoData temp = null;
_dbc = new SqliteConnection(_constr);
_dbc.Open();
_dbcm = _dbc.CreateCommand();
sql = "SELECT * FROM gonogo_data WHERE log_id = " + log_id + ";";
_dbcm.CommandText = sql;
_idr = _dbcm.ExecuteReader();
if (_idr.Read())
{
temp = new GoNoGoData();
temp.log_id = _idr.GetInt32(_idr.GetOrdinal("log_id"));
temp.correct_go_count = _idr.GetInt32(_idr.GetOrdinal("correct_go_count"));;
temp.correct_nogo_count = _idr.GetInt32(_idr.GetOrdinal("correct_nogo_count"));
temp.mean_time = _idr.GetDouble(_idr.GetOrdinal("mean_time"));
temp.go_count = _idr.GetInt32(_idr.GetOrdinal("go_count"));;
temp.trial_count = _idr.GetInt32(_idr.GetOrdinal("trial_count"));;
}
_idr.Close();
_idr = null;
_dbcm.Dispose();
_dbcm = null;
_dbc.Close();
_dbc = null;
return(temp);
}
public GoNoGoData getBestGoNoGo()
{
GoNoGoData bestGoNoGo = null;
_dbc = new SqliteConnection(_constr);
_dbc.Open();
_dbcm = _dbc.CreateCommand();
sql = "SELECT G.log_id, G.correct_go_count, G.correct_nogo_count, G.mean_time, G.go_count, G.trial_count " +
"FROM gonogo_data G, player_logs P " +
"WHERE P.game_progress = 'FINISHED' " +
"AND P.log_id = G.log_id " +
"AND(G.correct_go_count + G.correct_nogo_count) != 0 " +
"ORDER BY G.trial_count DESC, (G.correct_go_count + G.correct_nogo_count) DESC, G.mean_time ASC LIMIT 1; ";
_dbcm.CommandText = sql;
_idr = _dbcm.ExecuteReader();
if (_idr.Read())
{
bestGoNoGo = new GoNoGoData();
bestGoNoGo.log_id = _idr.GetInt32(_idr.GetOrdinal("log_id"));
bestGoNoGo.correct_go_count = _idr.GetInt32(_idr.GetOrdinal("correct_go_count"));;
bestGoNoGo.correct_nogo_count = _idr.GetInt32(_idr.GetOrdinal("correct_nogo_count"));
bestGoNoGo.mean_time = _idr.GetDouble(_idr.GetOrdinal("mean_time"));
bestGoNoGo.go_count = _idr.GetInt32(_idr.GetOrdinal("go_count"));;
bestGoNoGo.trial_count = _idr.GetInt32(_idr.GetOrdinal("trial_count"));;
}
_idr.Close();
_idr = null;
_dbcm.Dispose();
_dbcm = null;
_dbc.Close();
_dbc = null;
return(bestGoNoGo);
}
public void uploadPlayerLogs()
{
MySqlCommand cmd;
if (OpenConnection() == true)
{
List <PlayerLogs> uploadList = SQLiteDatabase.getLogsToUpload();
int player_id = SQLiteDatabase.getPlayer().player_id;
foreach (PlayerLogs log in uploadList)
{
string sql = "";
sql = "INSERT INTO player_logs (player_id, test_id, time_start, time_end) VALUES(" +
player_id + ", " +
log.test_id + ", '" +
log.time_start + "', '" +
log.time_end + "');";
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
sql = "SELECT LAST_INSERT_ID();";
cmd.CommandText = sql;
int last_log_id = Convert.ToInt32(cmd.ExecuteScalar());
switch (log.test_id)
{
case 1:
GoNoGoData temp1 = SQLiteDatabase.getGoNoGoToUpload(log.log_id);
sql = "INSERT INTO gonogo_data (log_id, correct_go_count, correct_nogo_count, mean_time, go_count, trial_count) VALUES (" +
last_log_id + ", " +
temp1.correct_go_count + ", " +
temp1.correct_nogo_count + ", " +
temp1.mean_time + ", " +
temp1.go_count + ", " +
temp1.trial_count + ");";
break;
case 2:
CorsiData temp2 = SQLiteDatabase.getCorsiToUpload(log.log_id);
sql = "INSERT INTO corsi_data (log_id, correct_trials, correct_length, seq_length, trial_count) VALUES (" +
last_log_id + ", " +
temp2.correct_trials + ", " +
temp2.correct_length + ", " +
temp2.seq_length + ", " +
temp2.trial_count + ");";
break;
case 3:
NBackData temp3 = SQLiteDatabase.getNBackToUpload(log.log_id);
sql = "INSERT INTO nback_data (log_id, mean_time, correct_count, n_count, element_count, trial_count) VALUES (" +
last_log_id + ", " +
temp3.mean_time + ", " +
temp3.correct_count + ", " +
temp3.n_count + ", " +
temp3.element_count + ", " +
temp3.trial_count + ");";
break;
case 4:
EriksenData temp4 = SQLiteDatabase.getEriksenToUpload(log.log_id);
sql = "INSERT INTO eriksen_data (log_id, correct_congruent, time_congruent, correct_incongruent, time_incongruent, congruent_count, trial_count) VALUES (" +
last_log_id + ", " +
temp4.correct_congruent + ", " +
temp4.time_congruent + ", " +
temp4.correct_incongruent + ", " +
temp4.time_incongruent + ", " +
temp4.congruent_count + ", " +
temp4.trial_count + ");";
break;
}
cmd = new MySqlCommand(sql, conn);
cmd.ExecuteNonQuery();
SQLiteDatabase.updateUploadedLog(log.log_id);
}
CloseConnection();
}
}
