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