/// <summary> /// Gets the settings from the db and maps. /// </summary> /// <returns></returns> private GigyaDsSettingsContainer Load(int id) { var db = UmbracoContext.Current.Application.DatabaseContext.Database; var results = db.Fetch <GigyaUmbracoModuleDsSettings>(string.Format("SELECT * FROM gigya_ds_settings WHERE Id IN (-1, {0})", id)); if (!results.Any()) { return(null); } var mappings = db.Fetch <GigyaUmbracoDsMapping>(string.Format("SELECT * FROM gigya_ds_mapping WHERE DsSettingId IN (-1, {0})", id)); var model = new GigyaDsSettingsContainer { Sites = new List <GigyaDsSettings>(results.Count) }; foreach (var result in results) { GigyaDsSettings mappedSetting = Map(mappings, result); model.Sites.Add(mappedSetting); } return(model); }
/// <summary> /// Gets the settings from the db and maps. /// </summary> /// <returns></returns> private GigyaDsSettingsContainer Load(Guid id) { using (var context = GigyaDSContext.Get()) { var settings = context.Settings.Where(i => i.SiteId == id || i.SiteId == Guid.Empty).Select(Map).ToList(); var model = new GigyaDsSettingsContainer { Sites = settings }; return(model); } }