private IEnumerable <SiteConfigurationRow> GetSiteConfigurationRows() { List <SiteConfigurationRow> configurationRows = new List <SiteConfigurationRow>(); // Turn the main SiteSettings into a row SiteSettings settings = _repository.GetSiteSettings(); SiteConfigurationRow row = new SiteConfigurationRow() { Id = SiteSettings.SiteSettingsId, Version = ApplicationSettings.FileVersion, Json = settings.GetJson() }; configurationRows.Add(row); // Turn all plugin settings into rows IEnumerable <TextPlugin> plugins = _pluginFactory.GetTextPlugins(); foreach (TextPlugin plugin in plugins) { row = new SiteConfigurationRow() { Id = plugin.DatabaseId, Version = plugin.Version, Json = plugin.GetSettingsJson() }; configurationRows.Add(row); } return(configurationRows); }
internal string GetSiteConfigurationInsertSql(SiteConfigurationRow row) { if (row == null) { return(""); } string sql = "INSERT INTO roadkill_siteconfiguration (id, version, content) VALUES ("; sql += string.Format("'{0}',", row.Id); sql += string.Format("'{0}',", row.Version); sql += string.Format("'{0}'", row.Json.ReplaceSingleQuotes()); sql += ");"; return(sql); }