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