public static NBackData getNBackToUpload(int log_id)
{
NBackData temp = null;
_dbc = new SqliteConnection(_constr);
_dbc.Open();
_dbcm = _dbc.CreateCommand();
sql = "SELECT * FROM nback_data WHERE log_id = " + log_id + ";";
_dbcm.CommandText = sql;
_idr = _dbcm.ExecuteReader();
if (_idr.Read())
{
temp = new NBackData();
temp.log_id = _idr.GetInt32(_idr.GetOrdinal("log_id"));
temp.mean_time = _idr.GetDouble(_idr.GetOrdinal("mean_time"));
temp.correct_count = _idr.GetInt32(_idr.GetOrdinal("correct_count"));
temp.n_count = _idr.GetInt32(_idr.GetOrdinal("n_count"));
temp.element_count = _idr.GetInt32(_idr.GetOrdinal("element_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 NBackData[] getLastNBack()
{
NBackData nbackData;
NBackData[] lastNBack = new NBackData[3];
int count = 0;
_dbc = new SqliteConnection(_constr);
_dbc.Open();
_dbcm = _dbc.CreateCommand();
sql = "SELECT N.log_id, N.mean_time, N.correct_count, N.n_count, N.element_count, N.trial_count " +
"FROM nback_data N, player_logs P " +
"WHERE P.game_progress = 'FINISHED' " +
"AND P.log_id = N.log_id " +
"ORDER BY N.log_id DESC; ";
_dbcm.CommandText = sql;
_idr = _dbcm.ExecuteReader();
while (_idr.Read() && count < 3)
{
nbackData = new NBackData();
nbackData.log_id = _idr.GetInt32(_idr.GetOrdinal("log_id"));
nbackData.mean_time = _idr.GetDouble(_idr.GetOrdinal("mean_time"));
nbackData.correct_count = _idr.GetInt32(_idr.GetOrdinal("correct_count"));
nbackData.n_count = _idr.GetInt32(_idr.GetOrdinal("n_count"));
nbackData.element_count = _idr.GetInt32(_idr.GetOrdinal("element_count"));
nbackData.trial_count = _idr.GetInt32(_idr.GetOrdinal("trial_count"));
lastNBack[count] = nbackData;
count++;
}
_idr.Close();
_idr = null;
_dbcm.Dispose();
_dbcm = null;
_dbc.Close();
_dbc = null;
return(lastNBack);
}
public NBackData getBestNBack()
{
NBackData bestNBack = null;
_dbc = new SqliteConnection(_constr);
_dbc.Open();
_dbcm = _dbc.CreateCommand();
sql = "SELECT N.log_id, N.mean_time, N.correct_count, N.n_count, N.element_count, N.trial_count " +
"FROM nback_data N, player_logs P " +
"WHERE P.game_progress = 'FINISHED' " +
"AND P.log_id = N.log_id " +
"AND N.correct_count != 0 " +
"ORDER BY N.n_count DESC, N.correct_count DESC, N.mean_time ASC LIMIT 1; ";
_dbcm.CommandText = sql;
_idr = _dbcm.ExecuteReader();
if (_idr.Read())
{
bestNBack = new NBackData();
bestNBack.log_id = _idr.GetInt32(_idr.GetOrdinal("log_id"));
bestNBack.mean_time = _idr.GetDouble(_idr.GetOrdinal("mean_time"));
bestNBack.correct_count = _idr.GetInt32(_idr.GetOrdinal("correct_count"));
bestNBack.n_count = _idr.GetInt32(_idr.GetOrdinal("n_count"));
bestNBack.element_count = _idr.GetInt32(_idr.GetOrdinal("element_count"));
bestNBack.trial_count = _idr.GetInt32(_idr.GetOrdinal("trial_count"));
}
_idr.Close();
_idr = null;
_dbcm.Dispose();
_dbcm = null;
_dbc.Close();
_dbc = null;
return(bestNBack);
}
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();
}
}
