private void loadCulturelist(string selectedCulture) { Culturelist.Items.Clear(); //add the "no-selection" culture at the top HyperCatalog.Business.CultureList CList = HyperCatalog.Shared.SessionState.User.Cultures; Culturelist.DataSource = CList; Culturelist.DataBind(); if (selectedCulture != null) { Culturelist.Items.FindByValue(selectedCulture).Selected = true; } }
private List<Culturelist> CreateListfromTranslation(Translations translations) { List<Culturelist> clist = new List<Culturelist>(); //Add model Culturelist listItem = new Culturelist(); listItem.TranslatedObject = translations.model; listItem.ObjectType = "Model"; listItem.Table = ""; listItem.OriginalName = translations.model.name; listItem.OriginalDescription = _modelTranslations.ReferenceCulture.model.name; listItem.TranslatedCaption = translations.model.translatedCaption; listItem.TranslatedDescription = translations.model.translatedDescription; clist.Add(listItem); //add tables foreach (Table tableRow in translations.model.tables ?? Enumerable.Empty<Table>()) { listItem = new Culturelist(); listItem.TranslatedObject = tableRow; listItem.ObjectType = "Table"; listItem.Table = tableRow.name; listItem.OriginalName = tableRow.name; ReferenceTable referenceTable = _modelTranslations.ReferenceCulture.model.tables.First(refTable => refTable.name == tableRow.name); listItem.OriginalDescription = referenceTable.description; listItem.TranslatedCaption = tableRow.translatedCaption; listItem.TranslatedDescription = tableRow.translatedDescription; clist.Add(listItem); //Add columns foreach (Column columnRow in tableRow.columns ?? Enumerable.Empty<Column>()) { listItem = new Culturelist(); listItem.TranslatedObject = columnRow; listItem.ObjectType = "Column"; listItem.Table = tableRow.name; ReferenceColumn referenceColumn = referenceTable.columns.First(refColumn => refColumn.name == columnRow.name); listItem.OriginalDescription = referenceColumn.description; listItem.OriginalDisplayFolder = referenceColumn.displayFolder; listItem.OriginalName = columnRow.name; listItem.TranslatedCaption = columnRow.translatedCaption; listItem.TranslatedDescription = columnRow.translatedDescription; listItem.TranslatedDisplayFolder = columnRow.translatedDisplayFolder; clist.Add(listItem); } foreach (Hierarchy hierarchyRow in tableRow.hierarchies ?? Enumerable.Empty<Hierarchy>()) { listItem = new Culturelist(); listItem.TranslatedObject = hierarchyRow; listItem.ObjectType = "Hierarchy"; listItem.Table = tableRow.name; ReferenceHierarchy referencehierarchy = referenceTable.hierarchies.First(refHierarchy=> refHierarchy.name == hierarchyRow.name); listItem.OriginalDescription = referencehierarchy.description; listItem.OriginalDisplayFolder = referencehierarchy.displayFolder; listItem.OriginalName = hierarchyRow.name; listItem.TranslatedCaption = hierarchyRow.translatedCaption; listItem.TranslatedDescription = hierarchyRow.translatedDescription; listItem.TranslatedDisplayFolder = hierarchyRow.translatedDisplayFolder; clist.Add(listItem); foreach (Level hierarchyLevelRow in hierarchyRow.levels ?? Enumerable.Empty<Level>()) { listItem = new Culturelist(); listItem.TranslatedObject = hierarchyLevelRow; listItem.ObjectType = "Hierarchylevel"; listItem.Table = tableRow.name; ReferenceLevel referenceHierarchyLevel = referencehierarchy.levels.First(refHierarchyLevel => refHierarchyLevel.name == hierarchyLevelRow.name); listItem.OriginalDescription = referenceHierarchyLevel.description; listItem.OriginalName = hierarchyLevelRow.name; listItem.TranslatedCaption = hierarchyLevelRow.translatedCaption; listItem.TranslatedDescription = hierarchyLevelRow.translatedDescription; clist.Add(listItem); } } foreach (Measure measureRow in tableRow.measures ?? Enumerable.Empty<Measure>()) { listItem = new Culturelist(); listItem.TranslatedObject = measureRow; listItem.ObjectType = "Measure"; listItem.Table = tableRow.name; ReferenceMeasure referenceMeasure = referenceTable.measures.First(refMeasure => refMeasure.name == measureRow.name); listItem.OriginalDescription = referenceMeasure.description; listItem.OriginalDisplayFolder = referenceMeasure.displayFolder; listItem.OriginalName = measureRow.name; listItem.TranslatedCaption = measureRow.translatedCaption; listItem.TranslatedDescription = measureRow.translatedDescription; listItem.TranslatedDisplayFolder = measureRow.translatedDisplayFolder; clist.Add(listItem); if (measureRow.kpi != null) { listItem = new Culturelist(); listItem.TranslatedObject = measureRow; listItem.ObjectType = "KPI"; listItem.Table = tableRow.name; listItem.OriginalDescription = referenceMeasure.kpi.description; listItem.OriginalDisplayFolder = referenceMeasure.kpi.displayFolder; listItem.OriginalName = measureRow.name; listItem.TranslatedCaption = string.Empty; listItem.TranslatedDescription = measureRow.kpi.translatedDescription; listItem.TranslatedDisplayFolder = measureRow.kpi.translatedDisplayFolder; clist.Add(listItem); } } } foreach (Perspective perspectiveRow in translations.model.perspectives ?? Enumerable.Empty<Perspective>()) { listItem = new Culturelist(); listItem.TranslatedObject = perspectiveRow; listItem.ObjectType = "Perspective"; listItem.Table = string.Empty; ReferencePerspective referencePerspective = _modelTranslations.ReferenceCulture.model.perspectives.First(refPerspective => refPerspective.name == perspectiveRow.name); listItem.OriginalDescription = referencePerspective.description; listItem.OriginalName = perspectiveRow.name; listItem.TranslatedCaption = perspectiveRow.translatedCaption; listItem.TranslatedDescription = perspectiveRow.translatedDescription; clist.Add(listItem); } return clist; }
private List <Culturelist> CreateListfromTranslation(Translations translations) { List <Culturelist> clist = new List <Culturelist>(); //Add model Culturelist listItem = new Culturelist(); listItem.TranslatedObject = translations.model; listItem.ObjectType = "Model"; listItem.Table = ""; listItem.OriginalName = translations.model.name; listItem.OriginalDescription = _modelTranslations.ReferenceCulture.model.name; listItem.TranslatedCaption = translations.model.translatedCaption; listItem.TranslatedDescription = translations.model.translatedDescription; clist.Add(listItem); //add tables foreach (Table tableRow in translations.model.tables ?? Enumerable.Empty <Table>()) { listItem = new Culturelist(); listItem.TranslatedObject = tableRow; listItem.ObjectType = "Table"; listItem.Table = tableRow.name; listItem.OriginalName = tableRow.name; ReferenceTable referenceTable = _modelTranslations.ReferenceCulture.model.tables.First(refTable => refTable.name == tableRow.name); listItem.OriginalDescription = referenceTable.description; listItem.TranslatedCaption = tableRow.translatedCaption; listItem.TranslatedDescription = tableRow.translatedDescription; clist.Add(listItem); //Add columns foreach (Column columnRow in tableRow.columns ?? Enumerable.Empty <Column>()) { listItem = new Culturelist(); listItem.TranslatedObject = columnRow; listItem.ObjectType = "Column"; listItem.Table = tableRow.name; ReferenceColumn referenceColumn = referenceTable.columns.First(refColumn => refColumn.name == columnRow.name); listItem.OriginalDescription = referenceColumn.description; listItem.OriginalDisplayFolder = referenceColumn.displayFolder; listItem.OriginalName = columnRow.name; listItem.TranslatedCaption = columnRow.translatedCaption; listItem.TranslatedDescription = columnRow.translatedDescription; listItem.TranslatedDisplayFolder = columnRow.translatedDisplayFolder; clist.Add(listItem); } foreach (Hierarchy hierarchyRow in tableRow.hierarchies ?? Enumerable.Empty <Hierarchy>()) { listItem = new Culturelist(); listItem.TranslatedObject = hierarchyRow; listItem.ObjectType = "Hierarchy"; listItem.Table = tableRow.name; ReferenceHierarchy referencehierarchy = referenceTable.hierarchies.First(refHierarchy => refHierarchy.name == hierarchyRow.name); listItem.OriginalDescription = referencehierarchy.description; listItem.OriginalDisplayFolder = referencehierarchy.displayFolder; listItem.OriginalName = hierarchyRow.name; listItem.TranslatedCaption = hierarchyRow.translatedCaption; listItem.TranslatedDescription = hierarchyRow.translatedDescription; listItem.TranslatedDisplayFolder = hierarchyRow.translatedDisplayFolder; clist.Add(listItem); foreach (Level hierarchyLevelRow in hierarchyRow.levels ?? Enumerable.Empty <Level>()) { listItem = new Culturelist(); listItem.TranslatedObject = hierarchyLevelRow; listItem.ObjectType = "Hierarchylevel"; listItem.Table = tableRow.name; ReferenceLevel referenceHierarchyLevel = referencehierarchy.levels.First(refHierarchyLevel => refHierarchyLevel.name == hierarchyLevelRow.name); listItem.OriginalDescription = referenceHierarchyLevel.description; listItem.OriginalName = hierarchyLevelRow.name; listItem.TranslatedCaption = hierarchyLevelRow.translatedCaption; listItem.TranslatedDescription = hierarchyLevelRow.translatedDescription; clist.Add(listItem); } } foreach (Measure measureRow in tableRow.measures ?? Enumerable.Empty <Measure>()) { listItem = new Culturelist(); listItem.TranslatedObject = measureRow; listItem.ObjectType = "Measure"; listItem.Table = tableRow.name; ReferenceMeasure referenceMeasure = referenceTable.measures.First(refMeasure => refMeasure.name == measureRow.name); listItem.OriginalDescription = referenceMeasure.description; listItem.OriginalDisplayFolder = referenceMeasure.displayFolder; listItem.OriginalName = measureRow.name; listItem.TranslatedCaption = measureRow.translatedCaption; listItem.TranslatedDescription = measureRow.translatedDescription; listItem.TranslatedDisplayFolder = measureRow.translatedDisplayFolder; clist.Add(listItem); if (measureRow.kpi != null) { listItem = new Culturelist(); listItem.TranslatedObject = measureRow; listItem.ObjectType = "KPI"; listItem.Table = tableRow.name; listItem.OriginalDescription = referenceMeasure.kpi.description; listItem.OriginalDisplayFolder = referenceMeasure.kpi.displayFolder; listItem.OriginalName = measureRow.name; listItem.TranslatedCaption = string.Empty; listItem.TranslatedDescription = measureRow.kpi.translatedDescription; listItem.TranslatedDisplayFolder = measureRow.kpi.translatedDisplayFolder; clist.Add(listItem); } } } foreach (Perspective perspectiveRow in translations.model.perspectives ?? Enumerable.Empty <Perspective>()) { listItem = new Culturelist(); listItem.TranslatedObject = perspectiveRow; listItem.ObjectType = "Perspective"; listItem.Table = string.Empty; ReferencePerspective referencePerspective = _modelTranslations.ReferenceCulture.model.perspectives.First(refPerspective => refPerspective.name == perspectiveRow.name); listItem.OriginalDescription = referencePerspective.description; listItem.OriginalName = perspectiveRow.name; listItem.TranslatedCaption = perspectiveRow.translatedCaption; listItem.TranslatedDescription = perspectiveRow.translatedDescription; clist.Add(listItem); } return(clist); }