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();
}
