/// <summary>
/// Sets property
/// </summary>
/// <param name="name">String - property name</param>
/// <param name="value">String - property value</param>
private void set(String name, String value)
{
KeyValue kv = new KeyValue();
kv.Key = name;
kv.Value = value;
kv.Insert();//insert of update - see sql
}
/// <summary>
/// Read all positions
/// </summary>
/// <returns>list of positions</returns>
public static List<KeyValue> ReadAll()
{
List<KeyValue> configs = new List<KeyValue>();
try
{
String sql = String.Format(SQL.Config.ReadAll, SQL.General.Names.KeyValueTableName);
using (SQLiteConnection con = Manager.Instance.Connection)
{
con.Open();
using (SQLiteCommand cmd = new SQLiteCommand(sql, con))
{
using (SQLiteDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
KeyValue what = new KeyValue();
what.Id = rdr.GetInt32(0);
what.Key = rdr.GetString(1);
what.Value = rdr.GetString(2);
configs.Add(what);
}
}
}
con.Close();
}
}
catch (Exception ex)
{
Common.Log.Write(ex);
}
return configs;
}
/// <summary>
/// Gets property
/// </summary>
/// <param name="name">String - property name</param>
/// <returns>String - property value</returns>
private String get(String name)
{
if (!KeyValue.Exists(name))
{
return "";
}
else
{
KeyValue kv = new KeyValue();
kv.Key = name;
kv.Read();
return kv.Value;
}
}
