public Models.Setting SaveSetting(string key, string value)
{
if (key.IsNullOrEmpty())
{
return(null);
}
if (settings != null)
{
// 更新
var oldOne = settings.FirstOrDefault(s => string.Equals(key, s.Key));
if (oldOne != null)
{
if (!string.Equals(value, oldOne.Value))
{
oldOne.Value = value;
settingRepository.Update(oldOne);
}
return(oldOne);
}
}
// 新增
var newSetting = new Models.Setting();
newSetting.Key = key;
newSetting.Value = value;
var id = settingRepository.Insert(newSetting);
newSetting.AutoId = id;
settings.Add(newSetting);
return(newSetting);
}
public Models.Setting SaveSetting(Models.Setting setting)
{
if (setting == null)
{
return(null);
}
if (settings != null)
{
// 更新
var oldOne = settings.FirstOrDefault(s => string.Equals(setting.Key, s.Key));
if (oldOne != null)
{
setting.AutoId = oldOne.AutoId;
if (!string.Equals(setting.Value, oldOne.Value))
{
settingRepository.Update(setting);
settings.Remove(oldOne);
settings.Add(setting);
}
return(setting);
}
}
// 新增
var id = settingRepository.Insert(setting);
setting.AutoId = id;
settings.Add(setting);
return(setting);
}
internal static ObservableCollection <Models.Setting> GetAllSettings()
{
string comm = "SELECT * FROM setting";
ObservableCollection <Models.Setting> result = new ObservableCollection <Models.Setting>();
using (SQLiteConnection conn = new SQLiteConnection(stringConnection))
{
SQLiteCommand command = new SQLiteCommand(conn);
command.CommandText = comm;
conn.Open();
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Models.Setting setting = new Models.Setting();
setting.ID = reader.GetInt32(0);
setting.Name = reader.GetString(1);
setting.ValueSetting = reader.GetString(2);
result.Add(setting);
}
}
conn.Close();
}
return(result);
}
public ActionResult Delete(int Id)
{
Models.Setting foundSetting = db.Settings.FirstOrDefault(s => s.Id == Id);
if (foundSetting != null)
{
db.Settings.Remove(foundSetting);
db.SaveChanges();
}
else
{
return(HttpNotFound());
}
return(RedirectToAction("Index", "Setting"));
}
public ActionResult EditAction(Models.Setting sentSetting)
{
Models.Setting foundSetting = db.Settings.FirstOrDefault(s => s.Id == sentSetting.Id);
foundSetting.Photo = sentSetting.Photo;
foundSetting.FullName = sentSetting.FullName;
foundSetting.Job = sentSetting.Job;
foundSetting.PrevJob = sentSetting.PrevJob;
foundSetting.Education = sentSetting.Education;
foundSetting.AboutText = sentSetting.AboutText;
foundSetting.Birthday = sentSetting.Birthday;
foundSetting.Marital = sentSetting.Marital;
foundSetting.Nationality = sentSetting.Nationality;
foundSetting.Skype = sentSetting.Skype;
foundSetting.Phone = sentSetting.Phone;
foundSetting.Email = sentSetting.Email;
db.SaveChanges();
return(RedirectToAction("Index", "Setting"));
}
private void SetSetting <T>(string section, string name, T value)
{
var valueString = (string?)Convert.ChangeType(value, TypeCode.String);
if (string.IsNullOrWhiteSpace(valueString))
{
_cache.TryRemove(section + CACHE_NAME_SEPARATOR + name, out object _);
}
else
{
_cache.AddOrUpdate(section + CACHE_NAME_SEPARATOR + name, value !, (key, oldValue) => value !);
}
using (var scope = _provider.CreateScope())
using (var dbContext = scope.ServiceProvider.GetRequiredService <ApplicationDbContext>())
{
var setting = dbContext.Settings.FirstOrDefault(s => s.Section == section.ToLowerInvariant() && s.Name == name.ToLowerInvariant());
if (setting != null)
{
if (!string.IsNullOrWhiteSpace(valueString))
{
setting.Value = valueString;
dbContext.Settings.Update(setting);
}
else
{
dbContext.Settings.Remove(setting);
}
}
else if (!string.IsNullOrWhiteSpace(valueString))
{
setting = new Models.Setting {
Id = Guid.NewGuid(), Section = section.ToLowerInvariant(), Name = name.ToLowerInvariant(), Value = valueString
};
dbContext.Settings.Add(setting);
}
dbContext.SaveChanges();
}
}
public ActionResult Setting(Guid?id, FormCollection collection)
{
try
{
if (id != null)
{
var settings = db.Settings.Find(id);
settings.value = collection[TM.Common.Config.sub_key.form_use_label];
}
else
{
var settings = new Models.Setting();
settings.id = Guid.NewGuid();
settings.moduleKey = Common.Auth.getUser().id.ToString();
settings.subKey = TM.Common.Config.sub_key.form_use_label;
settings.value = collection[TM.Common.Config.sub_key.form_use_label];
db.Settings.Add(settings);
}
db.SaveChanges();
this.success("Cập nhật thông tin thành công");
}
catch (Exception ex) { this.danger("Cập nhật thông tin thất bại"); }
return(RedirectToAction("Setting"));
}
public Settings(Models.Setting settings)
{
this.DataContext = settings;
InitializeComponent();
}
public ActionResult CreateAction(Models.Setting newSetting)
{
db.Settings.Add(newSetting);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// 保存设置
/// </summary>
/// <param name="model"></param>
public static void SaveSetting(Models.Setting model)
{
var json = Newtonsoft.Json.JsonConvert.SerializeObject(model);
SaveJson("Setting", json);
}
protected override void OnStartup(StartupEventArgs e)
{
Models.Setting setting = Models.Setting.setting;
Views.Settings settingView = new Settings(setting);
settingView.ShowDialog();
}