public static void SetValue(string category, string section, string key, object value) { var db = new ResourcesModelContainer(); db.Settings.MergeOption = System.Data.Objects.MergeOption.OverwriteChanges; var item = db.Settings.FirstOrDefault(x => x.CultureCode == "en" & x.Category == category & x.Section == section & x.KeyName == key); if (item == null) { item = new Setting(); item.Category = category; item.Section = section; item.KeyName = key; db.Settings.AddObject(item); } item.KeyValue = value.ToString(); if (value == null) { item.KeyType = ""; } else { item.KeyType = value.GetType().Name; } db.SaveChanges(); }
public static string GetValue(string category, string section, string key) { var db = new ResourcesModelContainer(); db.Settings.MergeOption = System.Data.Objects.MergeOption.OverwriteChanges; var item = db.Settings.FirstOrDefault(x => x.CultureCode == "en" & x.Category == category & x.Section == section & x.KeyName == key); return(item == null ? null : item.KeyValue); }
public static List <Setting> GetTransforms(string culture, string category, string section) { culture = culture ?? ""; category = category ?? ""; section = section ?? ""; var db = new ResourcesModelContainer(); var query = from item in db.Settings where ((culture == string.Empty) || item.CultureCode == culture) && ((category == string.Empty) || item.Category == category) && ((section == string.Empty) || item.Section == section) orderby item.KeyName select item; return(query.ToList()); }