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