protected override IList <Language> LoadFromDB()
{
using (INIGroupEntities db = new INIGroupEntities())
{
List <Language> languages = new List <Language>();
IQueryable <Language> dbLanguages = db.Languages.OrderBy(lng => lng.LanguageId);
foreach (var dbLanguage in dbLanguages)
{
languages.Add(new Language()
{
LanguageId = dbLanguage.LanguageId, Name = dbLanguage.Name
});
}
return(languages);
}
}
public static string GetLabel(string viewId, string elementId)
{
string imagesPath = WebConfigurationManager.AppSettings["imagesPath"];
if (HttpContext.Current.Session["lngId"] == null)
{
HttpContext.Current.Session["lngId"] = 6;
}
;
Dictionary <string, string> viewLabels;
if (labels.Data.ContainsKey(viewId))
{
viewLabels = labels.Data[viewId];
}
else
{
viewLabels = new Dictionary <string, string>();
INIGroupEntities db = new INIGroupEntities();
var dbLabels = db.Labels.Where(lb => lb.ViewId == viewId);
if (!dbLabels.Any())
{
throw new Exception("Invalid viewId");
}
foreach (var dbLabel in dbLabels)
{
if (viewId == "Index")
{
viewLabels.Add(dbLabel.ElementId + "_" + dbLabel.LanguageId, dbLabel.Text.Replace("../Content/", imagesPath));
}
else
{
viewLabels.Add(dbLabel.ElementId + "_" + dbLabel.LanguageId, dbLabel.Text);
}
}
}
string labelKey = elementId + "_" + HttpContext.Current.Session["lngId"];
if (!viewLabels.ContainsKey(labelKey) && (int)HttpContext.Current.Session["lngId"] != 6)
{
labelKey = elementId + "_1";
}
return(viewLabels[labelKey]);
}
