//RPM_Sateesh protected void ddRegions_SelectedIndexChanged(object sender, System.EventArgs e) { #region Populate Languages Check box list using (HyperCatalog.Business.LanguageList languageList = HyperCatalog.Business.Language.GetAll("LanguageCode NOT IN (Select LanguageCode FROM Cultures WHERE CultureTypeId = 0) AND LanguageCode IN (SELECT LanguageCode FROM Cultures(NOLOCK) WHERE FallbackCode ='" + ddRegions.SelectedValue.ToString() + "')")) { languageList.Sort("Name"); cblLanguageScope.DataSource = languageList; cblLanguageScope.DataBind(); } #endregion }
private void UpdateDataView() { string sSql = string.Empty; webTab.Visible = false; string filter = txtFilter.Text; if (filter != string.Empty) { string cleanFilter = filter.Replace("'", "''").ToLower(); cleanFilter = cleanFilter.Replace("[", "[[]"); cleanFilter = cleanFilter.Replace("_", "[_]"); cleanFilter = cleanFilter.Replace("%", "[%]"); sSql += " LOWER(LanguageCode) like '%" + cleanFilter + "%'"; sSql += " OR LOWER(LanguageName) like '%" + cleanFilter + "%'"; } panelGrid.Visible = dg.Visible = true; lbSpacer.Text = ""; using (HyperCatalog.Business.LanguageList languages = HyperCatalog.Business.Language.GetAll(sSql)) { if (languages != null) { if (languages.Count > 0) { dg.DataSource = languages; Utils.InitGridSort(ref dg); dg.DataBind(); lbNoresults.Visible = false; dg.Visible = true; } else { if (txtFilter.Text.Length > 0) { lbNoresults.Text = "No record match your search (" + txtFilter.Text + ")"; } lbNoresults.Visible = true; dg.Visible = false; } lbTitle.Text = UITools.GetTranslation("languages list"); } } }
/// <summary> /// Display the selected expression properties /// </summary> /// <param name="selTermId">ExpressionId</param> void UpdateDataEdit(string selExpressionId) { SessionState.tmPageIndexExpression = dg.DisplayLayout.Pager.CurrentPageIndex.ToString(); panelgrid.Visible = false; webTab.EnableViewState = false; webTab.Tabs.GetTab(0).ContentPane.TargetUrl = "./TM/Expression_Properties.aspx?e=" + selExpressionId; if (selExpressionId == "-1") { #region New TM Expression webTab.Tabs.GetTab(1).ContentPane.TargetUrl = ""; webTab.Tabs[1].Visible = false; lbTitle.Text = "Expression: New"; #endregion } else { #region TM Expression selected using (TMExpression exp = TMExpression.GetByKey(Convert.ToInt32(selExpressionId))) { string expValue = exp.Value.ToString(); if (expValue.Length > 50) { expValue = expValue.Substring(0, 50) + "..."; } lbTitle.Text = "Expression: " + expValue; webTab.Tabs.GetTab(1).ContentPane.TargetUrl = "./TM/Expression_Translations.aspx?e=" + selExpressionId; #region Translation Count using (HyperCatalog.Business.LanguageList c = HyperCatalog.Business.Language.GetAll()) { int LanguagesCount = c.Count; int TranslationsCount = LanguagesCount - exp.TranslationsMissingCount; webTab.Tabs.GetTab(1).Text = "Translations (" + TranslationsCount.ToString() + "/" + LanguagesCount.ToString() + ")"; } #endregion #endregion } } webTab.Visible = true; }
private void UpdateDataEdit(string selTRScopeId) { cblLanguageScope.ClearSelection(); TRScope trScope = null; if (selTRScopeId.Length > 0) { trScope = TRScope.GetByKey(Convert.ToInt32(selTRScopeId)); } if (trScope == null) { lbTitle.Text = "TR Scope: New"; wneScopeId.Value = "-1"; PanelRegionDDL.Visible = true; PanelRegionReadonly.Visible = false; PanelId.Visible = false; //RPM_Sateesh using (HyperCatalog.Business.CultureList culturesList = HyperCatalog.Business.Culture.GetAll("CultureCode IN (SELECT DISTINCT FallbackCode FROM Cultures(NOLOCK) WHERE CountryCode IN (SELECT CountryCode FROM Countries(NOLOCK) WHERE PLCDrivenTranslation = 0))")) { culturesList.Sort("Name"); ddRegions.Items.Add("<-- Select a Region -->"); foreach (HyperCatalog.Business.Culture c in culturesList) { ddRegions.Items.Add(c.Code); } } //RPM_Sateesh UITools.HideToolBarButton(uwToolBarEdit, "Delete"); UITools.HideToolBarSeparator(uwToolBarEdit, "DeleteSep"); } else { lbTitle.Text = "TR Scope: " + trScope.Name; wneScopeId.Value = trScope.Id; PanelRegionDDL.Visible = false; PanelRegionReadonly.Visible = true; wteRegionCode.Value = trScope.RegionCode; txtName.Text = trScope.Name; txtComment.Text = trScope.Comment; PanelId.Visible = true; //RPM_Sateesh //ddRegions.Text = trScope.Name; //RPM_Sateesh lbTRScopeId.Visible = true; wneScopeId.Visible = true; wneScopeId.Enabled = false; using (HyperCatalog.Business.LanguageList languageList = HyperCatalog.Business.Language.GetAll("LanguageCode NOT IN (Select LanguageCode FROM Cultures WHERE CultureTypeId = 0) AND LanguageCode IN (SELECT LanguageCode FROM Cultures(NOLOCK) WHERE FallbackCode ='" + trScope.RegionCode + "')")) { languageList.Sort("Name"); cblLanguageScope.DataSource = languageList; cblLanguageScope.DataBind(); } foreach (HyperCatalog.Business.TRScopeLanguage cul in trScope.Languages) { foreach (ListItem item in cblLanguageScope.Items) { if (item.Value == cul.LanguageCode) { item.Selected = true; } } } } panelEdit.Visible = true; panelGrid.Visible = false; }