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