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