/// <summary> /// Добавление опции в БД /// </summary> /// <param name="athlete"></param> public void AddOption(Option option) { using (SQLiteCommand cmd = connection.CreateCommand()) { Dictionary<String, String> data = new Dictionary<string, string>(); data.Add("name", option.name.ToString()); data.Add("value", option.value.ToString()); bool ok = Insert(cmd, TABLE_OPTIONS, data); if (!ok) throw new Exception("Не удалось записать опцию!"); } }
/// <summary> /// Возвращает время окончания тренировки по умолчанию /// </summary> /// <returns></returns> public string GetDefaultWorkoutsEndDate() { List<Workout> result = new List<Workout>(); using (SQLiteCommand command = connection.CreateCommand()) { command.CommandText = "SELECT * FROM " + TABLE_OPTIONS + " op " + " WHERE op.id == '" + OPTION_DEFAULT_END_TIME_ID + "'"; DbDataReader reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Option op = new Option(reader); if (op != null) return op.value; } } } return ""; }