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