public static Statistic GetUserStatistic(int userId)
{
Statistic statistic;
connection.Open();
command = new SQLiteCommand("SELECT * FROM 'Statistic' WHERE user_id = @param1;", connection);
command.Parameters.Add(new SQLiteParameter("@param1", userId));
reader = command.ExecuteReader();
List <ExerciseResultInfo> results = new List <ExerciseResultInfo>();
ExerciseResultInfo resultInfo;
while (reader.Read())
{
int level = Convert.ToInt32(reader["level"]);
int exerciseId = Convert.ToInt32(reader["exercise_id"]);
int assesment = Convert.ToInt32(reader["assesment"]);
DateTime dateOfPassing = Convert.ToDateTime(reader["dateOfPass"]);
int speed = Convert.ToInt32(reader["speed"]);
int errors = Convert.ToInt32(reader["errors"]);
resultInfo = new ExerciseResultInfo(exerciseId, dateOfPassing, errors, assesment, speed);
results.Add(resultInfo);
}
statistic = new Statistic(userId, results);
connection.Close();
return(statistic);
}
public void addResult(ExerciseResultInfo result)
{
results.Add(result);
}
public void addResult(ExerciseResultInfo result){
results.Add(result);
}
public static Statistic GetUserStatistic(int userId)
{
Statistic statistic;
connection.Open();
command = new SQLiteCommand("SELECT * FROM 'Statistic' WHERE user_id = @param1;", connection);
command.Parameters.Add(new SQLiteParameter("@param1", userId));
reader = command.ExecuteReader();
List<ExerciseResultInfo> results = new List<ExerciseResultInfo>();
ExerciseResultInfo resultInfo;
while (reader.Read())
{
int level = Convert.ToInt32(reader["level"]);
int exerciseId = Convert.ToInt32(reader["exercise_id"]);
int assesment = Convert.ToInt32(reader["assesment"]);
DateTime dateOfPassing = Convert.ToDateTime(reader["dateOfPass"]);
int speed = Convert.ToInt32(reader["speed"]);
int errors = Convert.ToInt32(reader["errors"]);
resultInfo = new ExerciseResultInfo(exerciseId, dateOfPassing, errors, assesment, speed);
results.Add(resultInfo);
}
statistic = new Statistic(userId, results);
connection.Close();
return statistic;
}
