protected void wBtnReplace_Click(object sender, Infragistics.WebUI.WebDataInput.ButtonEventArgs e)
{
if (ddlScopes.SelectedIndex > 0)
{
for (int i = 0; i < cblLanguageScope.Items.Count; i++)
{
cblLanguageScope.Items[i].Selected = false;
}
TRScope scope = TRScope.GetByKey(Convert.ToInt32(ddlScopes.SelectedValue));
if (scope != null)
{
foreach (TRScopeLanguage l in scope.Languages)
{
for (int i = 0; i < cblLanguageScope.Items.Count; i++)
{
if (cblLanguageScope.Items[i].Value == l.LanguageCode)
{
cblLanguageScope.Items[i].Selected = true;
}
}
}
}
ddlScopes.SelectedIndex = 0;
}
}
private void Delete()
{
TRScope trScope = TRScope.GetByKey(wneScopeId.ValueInt);
if (trScope != null)
{
if (trScope.Delete(HyperCatalog.Shared.SessionState.User.Id))
{
lbError.Visible = false;
lbError.Text = string.Empty;
panelEdit.Visible = false;
panelGrid.Visible = true;
UpdateDataView();
}
else
{
lbError.CssClass = "hc_error";
lbError.Text = "Error: " + TRScope.LastError;
lbError.Visible = true;
}
}
else
{ // Already deleted
UpdateDataView();
}
}
private void UpdateDataView()
{
#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 NOT IN (Select LanguageCode FROM Cultures L, Countries C WHERE L.CountryCode = C.CountryCode AND L.CultureTypeId = 2 AND C.PLCDrivenTranslation=1)"))
//{
// languageList.Sort("Name");
// cblLanguageScope.DataSource = languageList;
// cblLanguageScope.DataBind();
//}
#endregion
string sSql = string.Empty;
string filter = txtFilter.Text;
if (filter != string.Empty)
{
string cleanFilter = filter.Replace("'", "''").ToLower();
sSql = " LOWER(ScopeName) like '%" + cleanFilter + "%' ";
sSql += " OR LOWER(ScopeComment) like '%" + cleanFilter + "%' ";
}
using (TRScopeList trScopes = TRScope.GetAll(sSql))
{
trScopes.Sort("Name");
dg.DataSource = trScopes;
Utils.InitGridSort(ref dg);
dg.DataBind();
if (trScopes.Count == 0)
{
lbTitle.Text = "No Language Scopes in the System";
}
else
{
lbTitle.Text = "Language Scopes list";
}
}
panelGrid.Visible = true;
}
private void InitItem()
{
#region Populate Languages Check box list
string filter = "LanguageCode <> dbo.GetLanguageCode('" + HyperCatalog.Shared.SessionState.Culture.Code + "') AND LanguageCode NOT IN (SELECT LanguageCode FROM Cultures Cu, Countries C WHERE Cu.CountryCode = C.CountryCode AND C.PLCDrivenTranslation = 1)";
cblLanguageScope.DataSource = HyperCatalog.Business.Language.GetByCulture(HyperCatalog.Shared.SessionState.Culture.Code, filter);
cblLanguageScope.DataBind();
#endregion
#region Populate Scopes combo box
if (cblLanguageScope.Items.Count > 0)
{
//Modified by Sateesh for Language Scope Management (PCF: ACQ 3.6) - 27/05/2009
using (TRScopeList trScopeAll = TRScope.GetAll("RegionCode = '" + SessionState.Culture.Code + "'"))
{
ddlScopes.DataSource = trScopeAll;
ddlScopes.DataBind();
ddlScopes.Items.Insert(0, new ListItem("---> Please make your choice <---", string.Empty));
panelScopeTitle.Visible = true;
panelScopeLanguages.Visible = true;
}
//Modified by Sateesh for Language Scope Management (PCF: ACQ 3.6) - 27/05/2009
}
else
{
panelScopeTitle.Visible = false;
panelScopeLanguages.Visible = false;
}
#endregion
//Modified by Prabhu for ACQ 3.0 (PCF1: Regional Project Management)-- 18/May/09
SessionState.CurrentItem.RegionCode = SessionState.Culture.Code;
if (Item.Milestones.InheritedItem != null)
{
SessionState.CurrentItem.Milestones.InheritedItem.RegionCode = SessionState.Culture.Code;
}
Enabled = true;
//Modified by Prabhu for ACQ 3.0 (PCF1: Regional Project Management)-- 22/Jul/09
//Fix for QC 2765 - UAT: Beginning of Regionalization Date when setting a new project does not default to today's date
// SET BOR date same as BOP for new Projects
wdBop.Value = wdEoa.Value = DateTime.Now;
wdEov.Value = wdBot.Value = wdEot.Value = null;
if (Item != null && Item.Milestones != null && Item.Milestones.BeginningOfRegionalization.HasValue)
{
panelScopeLanguages.Visible = panelScopeTitle.Visible = Item.TranslationMode == TRClassTranslationMode.Standard;
wdBop.Value = Item.Milestones.CreationDate;
//wdBop.Value = Item.CreateDate.Value;
if (Item.Milestones.InheritedItem != null && Item.Milestones.InheritedItem.Milestones.CreationDate.HasValue)
{
wdBop.Value = Item.Milestones.InheritedItem.Milestones.CreationDate.Value;
}
if (Item.Milestones.BeginningOfRegionalization != null)
{
wdEoa.Value = Item.Milestones.BeginningOfRegionalization.Value;
}
if (Item.Milestones.EndOfRegionalization != null)
{
wdEov.Value = Item.Milestones.EndOfRegionalization.Value;
}
if (Item.Milestones.BeginningOfTranslation != null)
{
wdBot.Value = Item.Milestones.BeginningOfTranslation.Value;
}
if (Item.Milestones.EndOfTranslation != null)
{
wdEot.Value = Item.Milestones.EndOfTranslation.Value;
}
cblLanguageScope.ClearSelection();
foreach (HyperCatalog.Business.Language cul in Item.Translations)
{
foreach (ListItem item in cblLanguageScope.Items)
{
if (item.Value == cul.Code)
{
item.Selected = true;
}
}
}
if (Item.Milestones.Inherited)
{
// Propose to the user to create its own project.
// In the meantime, disable everything
Enabled = false;
lnkOverride.Visible = true;
}
}
else
{
wdBop.Value = DateTime.UtcNow;
}
// if it is not region, then user cannot modify master publishing date, beginning of project,
// end of translation, beginning of localization and end of localization
//Modified by Prabhu for ACQ 3.0 (PCF1: Regional Project Management)-- 26/May/09 -- check
//if (HyperCatalog.Shared.SessionState.Culture.Type != HyperCatalog.Business.CultureType.Master)
if (HyperCatalog.Shared.SessionState.Culture.Type != HyperCatalog.Business.CultureType.Regionale)
{
panelBOP.Visible = panelEOT.Visible = false;
wdEoa.Enabled = ddlScopes.Enabled = lnkOverride.Visible = wBtnAdd.Enabled = wBtnReplace.Enabled = false;
if (HyperCatalog.Shared.SessionState.Culture.Type == HyperCatalog.Business.CultureType.Locale)
{
cblLanguageScope.Enabled = false;
}
}
if (cblLanguageScope.Items.Count == 0)
{
//Modified by Prabhu for ACQ 3.0 (PCF1: Regional Project Management)-- 26/May/09 -- check
panelScopeLanguages.Visible = panelScopeTitle.Visible = false;
}
if (Item != null && Item.IsMinimizedByCulture(SessionState.Culture.Code))
{
wdEoa.Enabled = wdBop.Enabled = wdEot.Enabled = wdEov.Enabled = wdBot.Enabled =
ddlScopes.Enabled = lnkOverride.Visible = wBtnAdd.Enabled = wBtnReplace.Enabled = cblLanguageScope.Enabled = false;
}
// Item is a roll, then scope of language is disable
//if (Item != null && Item.IsRoll)
//{
// ddlScopes.Enabled = cblLanguageScope.Enabled = panelScopeLanguages.Enabled = false;
// wBtnAdd.Enabled = wBtnReplace.Enabled = false;
//}
}
private void Save()
{
lbError.Text = string.Empty;
TRScope trScope = null;
if (PanelId.Visible)
{
//Update
trScope = TRScope.GetByKey(wneScopeId.ValueInt);
trScope.Name = txtName.Text;
trScope.Comment = txtComment.Text;
}
else
{
//Add
if (ddRegions.SelectedValue.ToString() != "<-- Select a Region -->")
{
trScope = new TRScope(-1, ddRegions.SelectedValue.ToString(), txtName.Text, txtComment.Text, HyperCatalog.Shared.SessionState.User.Id, DateTime.UtcNow);
}
UITools.HideToolBarButton(uwToolBarEdit, "Delete");
UITools.HideToolBarSeparator(uwToolBarEdit, "DeleteSep");
}
if (trScope != null)
{
trScope.Languages.Clear();
foreach (ListItem obj in cblLanguageScope.Items)
{
if (obj.Selected)
{
trScope.Languages.Add(new TRScopeLanguage(trScope.Id, obj.Value));
}
}
if (trScope.Languages.Count == 0)
{
lbError.CssClass = "hc_error";
lbError.Text = "Error: you must choose at least ONE language";
lbError.Visible = true;
}
else
{
if (trScope.Save(HyperCatalog.Shared.SessionState.User.Id))
{
wneScopeId.Value = trScope.Id;
wneScopeId.Text = trScope.Id.ToString();
PanelId.Visible = true;
PanelRegionDDL.Visible = false;
PanelRegionReadonly.Visible = true;
wteRegionCode.Value = trScope.RegionCode;
wteRegionCode.Text = trScope.RegionCode.ToString();
UITools.ShowToolBarButton(uwToolBarEdit, "Delete");
UITools.ShowToolBarSeparator(uwToolBarEdit, "DeleteSep");
lbError.Text = "Data saved!";
lbError.CssClass = "hc_success";
lbError.Visible = true;
}
else
{
lbError.CssClass = "hc_error";
lbError.Text = "Error: " + TRScope.LastError;
lbError.Visible = true;
}
}
}
else
{
if (ddRegions.SelectedValue.ToString() == "<-- Select a Region -->")
{
lbError.CssClass = "hc_error";
lbError.Text = "Error: Scope could not be created, please make sure that the u Selected a Region.";
lbError.Visible = true;
}
else
{
lbError.CssClass = "hc_error";
lbError.Text = "Error: Scope could not be created, please make sure that the name is not already in use.";
lbError.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;
}
