public static string GetSettings(string settings_group, string property) { string query = string.Format("SELECT val FROM settings WHERE property= '{0}' AND settings_group = '{1}'", property, settings_group); return(DBClient.ExecuteScalar(query).GetString()); }
public static bool SetSettings(string settings_group, string property, object value) { string query = string.Format("UPDATE settings SET val = '{0}' WHERE property= '{1}' AND settings_group = '{2}'", value.ToString(), property, settings_group); return(DBClient.ExecuteNonQuery(query) >= 0); }
public static bool HasSettings(string settings_group, string property) { string query = string.Format("SELECT COUNT(*) AS c FROM settings WHERE property= '{0}' AND settings_group = '{1}'", property, settings_group); return(DBClient.ExecuteScalar(query).GetString().ToInt(-1) > 0); }