public void SaveSiteSettings(SiteSettingsDTO dto)
{
var sql = "UPDATE SiteSettings SET `Value`=@val WHERE `Key`=@key";
_dbConnection.Execute(sql, new { val = dto.SiteCSS, key = SiteSettingKeyConst.SiteCSS });
_dbConnection.Execute(sql, new { val = dto.SiteTemplateId?.ToString(), key = SiteSettingKeyConst.SiteTemplateId });
}
public IActionResult SiteSettings(SiteSettingsDTO dto)
{
_systemManager.SaveSiteSettings(dto);
var settings = _systemManager.GetSiteSettings();
return(View(settings));
}
public bool Insert(SiteSettingsDTO siteSettings)
{
return(_sitesettingsRepository.Add(new SiteSettings()
{
FieldName = siteSettings.FieldName,
FieldValue = siteSettings.FieldValue
}));
}
public bool Update(SiteSettingsDTO siteSettings)
{
var entity = _sitesettingsRepository.First(x => x.Id == siteSettings.Id);
if (entity != null)
{
entity.FieldName = siteSettings.FieldName;
entity.FieldValue = siteSettings.FieldValue;
return(_sitesettingsRepository.Update(entity));
}
else
{
return(false);
}
}
public void SaveSiteSettings(SiteSettingsDTO dto)
{
var sql = "UPDATE SiteSettings SET `Value`=@val WHERE `Key`=@key";
_dbHelper.ExecuteNonQuery(sql, new List <MySqlParameter>()
{
new MySqlParameter {
ParameterName = "@val", MySqlDbType = MySqlDbType.VarChar, Value = dto.SiteCSS
},
new MySqlParameter {
ParameterName = "@key", MySqlDbType = MySqlDbType.VarChar, Value = SiteSettingKeyConst.SiteCSS
}
}.ToArray());
_dbHelper.ExecuteNonQuery(sql, new List <MySqlParameter>()
{
new MySqlParameter {
ParameterName = "@val", MySqlDbType = MySqlDbType.VarChar, Value = dto.SiteTemplateId?.ToString()
},
new MySqlParameter {
ParameterName = "@key", MySqlDbType = MySqlDbType.VarChar, Value = SiteSettingKeyConst.SiteTemplateId
}
}.ToArray());
}
public void SaveSiteSettings(SiteSettingsDTO dto)
{
_unitOfWork.SiteRepository.SaveSiteSettings(dto);
_unitOfWork.Commit();
}
