public static void deleteBenchmark(Benchmark benchmark) { executeSql("" + "DELETE FROM " + "`" + tableName + "` " + "WHERE " + "`" + field_disciplineId + " = " + benchmark.Discipline.DisciplineId + " " + "AND `" + field_ageFrom + "` = " + benchmark.AgeFrom + " " + "AND `" + field_ageUntil + "` = " + benchmark.AgeUntil + " " + "AND `" + field_gender + "` = '" + benchmark.Gender + "' " + "AND `" + field_rank + "` = '" + benchmark.Rank + "' " + "LIMIT 1" ); }
public static List<Benchmark> getBenchmarksByDiscipline(Discipline discipline) { List<Dictionary<string, object>> results = querySql("" + "SELECT " + "`" + field_ageFrom + "`, " + "`" + field_ageUntil + "`, " + "`" + field_gender + "`, " + "`" + field_rank + "`, " + "`" + field_benchmark + "` " + "FROM " + "`" + tableName + "` " + "WHERE " + "`" + field_disciplineId + "` = " + discipline.DisciplineId ); List<Benchmark> benchmarks = new List<Benchmark>(); foreach (var row in results) { Benchmark benchmark = new Benchmark( discipline, Convert.ToInt32(row[field_ageFrom]), Convert.ToInt32(row[field_ageUntil]), Convert.ToChar(row[field_gender]), Convert.ToString(row[field_rank]), Convert.ToDouble(row[field_benchmark]) ); benchmarks.Add(benchmark); } return benchmarks; }
public static void updateBenchmark(Benchmark benchmark) { executeSql("" + "UPDATE " + "`" + tableName + "` " + "SET " + "`" + field_benchmark + "` = " + benchmark.BenchmarkValue + " " + "WHERE " + "`" + field_disciplineId + " = " + benchmark.Discipline.DisciplineId + " " + "AND `" + field_ageFrom + "` = " + benchmark.AgeFrom + " " + "AND `" + field_ageUntil + "` = " + benchmark.AgeUntil + " " + "AND `" + field_gender + "` = '" + benchmark.Gender + "' " + "AND `" + field_rank + "` = '" + benchmark.Rank + "'" ); }
public static Benchmark getBenchmarkByPrimaryKey( Discipline discipline, int ageFrom, int ageUntil, char gender, string rank ) { Dictionary<string, object> result = querySingleSql("" + "SELECT " + "`" + field_ageFrom + "`, " + "`" + field_ageUntil + "`, " + "`" + field_gender + "`, " + "`" + field_rank + "`, " + "`" + field_benchmark + "` " + "FROM " + "`" + tableName + "` " + "WHERE " + "`" + field_disciplineId + "` = " + discipline.DisciplineId + " " + "AND `" + field_ageFrom + "` = " + ageFrom + " " + "AND `" + field_ageUntil + "` = " + ageUntil + " " + "AND `" + field_gender + "` = '" + gender + "' " + "AND `" + field_rank + "` = '" + rank + "'" ); if (result == null) { return null; } Benchmark benchmark = new Benchmark( discipline, Convert.ToInt32(result[field_ageFrom]), Convert.ToInt32(result[field_ageUntil]), Convert.ToChar(result[field_gender]), Convert.ToString(result[field_rank]), Convert.ToDouble(result[field_benchmark]) ); return benchmark; }