public void SaveSettings(SiteSettings siteSettings) { var entity = new SiteConfigurationEntity(); entity.Id = SiteSettings.SiteSettingsId; entity.Version = ApplicationSettings.ProductVersion.ToString(); entity.Content = siteSettings.GetJson(); SaveOrUpdate <SiteConfigurationEntity>(entity); }
public SiteConfiguration GetSiteConfiguration(Guid siteId) { var siteconfiguration = _dbContext.SiteConfigurations.FirstOrDefault(sc => sc.SiteId == siteId); if (siteconfiguration != null) { siteconfiguration.Password = Decode(siteconfiguration.Password); } return(SiteConfigurationEntity.MapTo(siteconfiguration)); }
public async Task CreateSiteConfiguration(SiteConfiguration siteConfiguration) { if (_dbContext.SiteConfigurations.Any(sc => sc.SiteId == siteConfiguration.SiteId)) { throw new BadRequestException("SiteConfiguration already exists"); } siteConfiguration.Password = Encode(siteConfiguration.Password); _dbContext.SiteConfigurations.Add(SiteConfigurationEntity.MapFrom(siteConfiguration)); await _dbContext.SaveChangesAsync(); }
public void SiteConfigurationEntity_ObjectId_Should_Match_Id() { // Arrange SiteConfigurationEntity siteConfigEntity = new SiteConfigurationEntity(); siteConfigEntity.ObjectId = Guid.NewGuid(); // Act Guid objectId = siteConfigEntity.ObjectId; // Assert Assert.That(objectId, Is.EqualTo(siteConfigEntity.Id)); }
public void siteconfigurationentity_objectid_should_match_id() { // Arrange SiteConfigurationEntity siteConfigEntity = new SiteConfigurationEntity(); siteConfigEntity.ObjectId = Guid.NewGuid(); // Act Guid objectId = siteConfigEntity.ObjectId; // Assert Assert.That(objectId, Is.EqualTo(siteConfigEntity.Id)); }
public PluginSettings GetTextPluginSettings(Guid databaseId) { SiteConfigurationEntity entity = Queryable <SiteConfigurationEntity>() .FirstOrDefault(x => x.Id == databaseId); PluginSettings pluginSettings = null; if (entity != null) { pluginSettings = PluginSettings.LoadFromJson(entity.Content); } return(pluginSettings); }
public void SaveTextPluginSettings(TextPlugin plugin) { SiteConfigurationEntity entity = Queryable <SiteConfigurationEntity>() .FirstOrDefault(x => x.Id == plugin.DatabaseId); if (entity == null) { entity = new SiteConfigurationEntity(); } entity.Id = plugin.DatabaseId; entity.Version = plugin.Version; entity.Content = plugin.Settings.GetJson(); SaveOrUpdate <SiteConfigurationEntity>(entity); }
public SiteConfiguration GetSiteConfiguration() { var siteconfiguration = _dbContext.SiteConfigurations.FirstOrDefault(); if (siteconfiguration != null) { siteconfiguration.Password = Decode(siteconfiguration.Password); } if (siteconfiguration == null) { throw new BadRequestException("SiteConfiguration does not exist"); } return(SiteConfigurationEntity.MapTo(siteconfiguration)); }
public void SaveSiteSettings(SiteSettings preferences) { // Get the fresh db entity first SiteConfigurationEntity entity = Queryable <SiteConfigurationEntity>() .FirstOrDefault(x => x.Id == SiteSettings.SiteSettingsId); if (entity == null) { entity = new SiteConfigurationEntity(); } entity.Id = SiteSettings.SiteSettingsId; entity.Version = ApplicationSettings.ProductVersion.ToString(); entity.Content = preferences.GetJson(); SaveOrUpdate <SiteConfigurationEntity>(entity); }
public SiteSettings GetSiteSettings() { SiteConfigurationEntity entity = Queryable <SiteConfigurationEntity>() .FirstOrDefault(x => x.Id == SiteSettings.SiteSettingsId); SiteSettings siteSettings = new SiteSettings(); if (entity != null) { siteSettings = SiteSettings.LoadFromJson(entity.Content); } else { Log.Warn("MongoDB: No site settings could be found in the database, using a default SiteSettings"); } return(siteSettings); }
public Settings GetTextPluginSettings(Guid databaseId) { using (IDbConnection connection = _dbConnectionFactory.CreateConnection()) { connection.Open(); string sql = $"select * from {TableName} where id=@id"; SiteConfigurationEntity entity = connection.QueryFirstOrDefault <SiteConfigurationEntity>(sql, new { id = databaseId }); Settings pluginSettings = null; if (entity != null) { pluginSettings = Settings.LoadFromJson(entity.Content); } return(pluginSettings); } }
public void SaveSettings(SiteSettings siteSettings) { using (IDbConnection connection = _dbConnectionFactory.CreateConnection()) { connection.Open(); var entity = new SiteConfigurationEntity(); entity.Id = SiteSettings.SiteSettingsId; entity.Version = ApplicationSettings.ProductVersion; entity.Content = siteSettings.GetJson(); string sql = $"insert into {ConfigurationTableName} "; sql += "(id, version, content) "; sql += "values (@Id, @Version, @Content)"; connection.Execute(sql, entity); } }
public async Task <SiteConfiguration> SaveSiteConfiguration(SiteConfiguration siteConfiguration) { siteConfiguration.Password = Encode(siteConfiguration.Password); var entity = SiteConfigurationEntity.MapFrom(siteConfiguration); if (_dbContext.SiteConfigurations.Any(sc => sc.SiteId == siteConfiguration.SiteId)) { _dbContext.Entry(entity).State = Microsoft.EntityFrameworkCore.EntityState.Modified; } else { _dbContext.SiteConfigurations.Add(entity); } await _dbContext.SaveChangesAsync(); return(SiteConfigurationEntity.MapTo(entity)); }
public void SaveSiteSettings(SiteSettings siteSettings) { SiteConfigurationEntity entity = UnitOfWork.FindById<SiteConfigurationEntity>(SiteSettings.SiteSettingsId); if (entity == null || entity.Id == Guid.Empty) { entity = new SiteConfigurationEntity(); entity.Id = SiteSettings.SiteSettingsId; entity.Version = ApplicationSettings.ProductVersion.ToString(); entity.Content = siteSettings.GetJson(); UnitOfWork.Add(entity); } else { entity.Version = ApplicationSettings.ProductVersion.ToString(); entity.Content = siteSettings.GetJson(); } UnitOfWork.SaveChanges(); }
public void SaveSiteSettings(SiteSettings siteSettings) { using (IDbConnection connection = _dbConnectionFactory.CreateConnection()) { connection.Open(); string sql = $"select * from {TableName} where id=@id"; SiteConfigurationEntity entity = connection.QueryFirstOrDefault <SiteConfigurationEntity>(sql, new { id = SiteSettings.SiteSettingsId }); bool settingsExist = (entity != null); // SiteSettings is the JSON object, SiteConfigurationEntity is the database entity. // In ideal world you would have a SiteConfigurationEntity.SiteSettings instead of a text column. if (entity == null) { entity = new SiteConfigurationEntity(); } entity.Id = SiteSettings.SiteSettingsId; entity.Version = ApplicationSettings.ProductVersion; entity.Content = siteSettings.GetJson(); sql = ""; if (settingsExist) { sql = $"update {TableName} set "; sql += "version=@Version, content=@Content "; sql += "where id=@Id"; } else { sql = $"insert into {TableName} "; sql += "(id, version, content) "; sql += "values (@Id, @Version, @Content)"; } connection.Execute(sql, entity); } }
public SiteSettings GetSiteSettings() { using (IDbConnection connection = _dbConnectionFactory.CreateConnection()) { connection.Open(); string sql = $"select * from {TableName} where id=@id"; SiteConfigurationEntity entity = connection.QueryFirstOrDefault <SiteConfigurationEntity>(sql, new { id = SiteSettings.SiteSettingsId }); SiteSettings siteSettings = new SiteSettings(); if (entity != null) { siteSettings = SiteSettings.LoadFromJson(entity.Content); } else { Log.Warn("Dapper: No site settings could be found in the database, using a default SiteSettings"); } return(siteSettings); } }
public void SaveTextPluginSettings(TextPlugin plugin) { using (IDbConnection connection = _dbConnectionFactory.CreateConnection()) { connection.Open(); string sql = $"select * from {TableName} where id=@id"; SiteConfigurationEntity entity = connection.QueryFirstOrDefault <SiteConfigurationEntity>(sql, new { id = plugin.DatabaseId }); bool settingsExist = (entity != null); if (entity == null) { entity = new SiteConfigurationEntity(); } entity.Id = plugin.DatabaseId; entity.Version = ApplicationSettings.ProductVersion; entity.Content = plugin.Settings.GetJson(); sql = ""; if (settingsExist) { sql = $"update {TableName} set "; sql += "version=@Version, content=@Content "; sql += "where id=@Id"; } else { sql = $"insert into {TableName} "; sql += "(id, version, content) "; sql += "values (@Id, @Version, @Content)"; } connection.Execute(sql, entity); } }
public void SaveTextPluginSettings(TextPlugin plugin) { string version = plugin.Version; if (string.IsNullOrEmpty(version)) version = "1.0.0"; SiteConfigurationEntity entity = UnitOfWork.Find<SiteConfigurationEntity>() .FirstOrDefault(x => x.Id == plugin.DatabaseId); if (entity == null || entity.Id == Guid.Empty) { entity = new SiteConfigurationEntity(); entity.Id = plugin.DatabaseId; entity.Version = version; entity.Content = plugin.Settings.GetJson(); UnitOfWork.Add(entity); } else { entity.Version = version; entity.Content = plugin.Settings.GetJson(); } UnitOfWork.SaveChanges(); }