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