public IList<string> GetAllCultures()
{
var result = new List<string>();
using (var _dbContext = new ZakLydContext())
{
result = _dbContext.Culture.Select(c => c.CultureValue).ToList();
}
return result;
}
public IDictionary<string, string> GetAllConfigurations()
{
var result = new Dictionary<string, string>();
using (var _dbContext = new ZakLydContext())
{
result = _dbContext.Configuration.ToDictionary(k => k.ConfigurationKey, k => k.ConfigurationValue);
}
return result;
}
public IDictionary<string,string> GetConfigurationByFamilly(string family)
{
IQueryable<Configuration> queryResult;
using (var dbContext = new ZakLydContext())
{
queryResult =
dbContext.Configuration.Where(
c => c.ConfigurationKey.ToLower().StartsWith(family.ToLower()));
}
return queryResult.Any() ? queryResult.ToDictionary(c=>c.ConfigurationKey, c=> c.ConfigurationValue) : null;
}
public string GetConfigurationByKey(string key)
{
IQueryable<Configuration> queryResult;
using (var dbContext = new ZakLydContext())
{
queryResult =
dbContext.Configuration.Where(
c => c.ConfigurationKey.Equals(key, StringComparison.OrdinalIgnoreCase));
}
return queryResult.Any() ? queryResult.First().ConfigurationValue : string.Empty;
}
public IDictionary<string, string> GetLabelsByFamily(string familyLabel, string culture)
{
var result = new Dictionary<string, string>();
using (var _dbContext = new ZakLydContext())
{
result = _dbContext.LabelCulture
.Where(c => c.Culture.CultureValue == culture)
.Where(l => l.Lable.LabelKey.ToLower().StartsWith(familyLabel))
//.Select(l=> new { l.Lable.LabelKey, l.LabelValue })
.ToDictionary(k => k.Lable.LabelKey, k => k.LabelValue);
}
return result;
}