/// <summary>
/// Delete the TM expression
/// </summary>
private void BtnDelete()
{
using (t = TMExpression.GetByKey(expressionId))
{
if (t != null)
{
#region Delete result
if (t.Delete(HyperCatalog.Shared.SessionState.User.Id))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "clientScript", "<script>back();</script>");
}
else
{
lbMessage.Text = TMExpression.LastError;
lbMessage.CssClass = "hc_error";
lbMessage.Visible = true;
}
#endregion
}
else
{
lbMessage.Text = "Error: TM Expression can't be deleted - Expression not found";
lbMessage.CssClass = "hc_error";
lbMessage.Visible = true;
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
#region Check Capabilities
if ((SessionState.User.IsReadOnly) || (!SessionState.User.HasCapability(CapabilitiesEnum.MANAGE_TRANSLATION_MEMORY)))
{
uwToolbar.Items.FromKeyButton("Save").Enabled = false;
uwToolbar.Items.FromKeyButton("Delete").Enabled = false;
txtTMValue.Enabled = txtComment.Enabled = !SessionState.User.IsReadOnly;
}
#endregion
if (Request["e"] != null)
{
expressionId = Convert.ToInt64(Request["e"]);
if (!Page.IsPostBack)
{
try
{
using (t = TMExpression.GetByKey(expressionId))
{
ShowExpression();
}
}
catch
{
UITools.DenyAccess(DenyMode.Standard);
}
}
}
}
/// <summary>
/// Save the TM expression
/// </summary>
private void BtnSave()
{
if (t == null)
{
#region New TM Expression
t = new TMExpression(expressionId, txtTMValue.Text.Trim(), txtComment.Text.Trim(),
0, 0, SessionState.User.Id, DateTime.UtcNow, User.Identity.Name);
#endregion
}
else
{
#region Update TM Expression
t.UserId = SessionState.User.Id;
t.Value = txtTMValue.Text.Trim();
t.Comment = txtComment.Text.Trim();
#endregion
}
int r = t.Save();
#region Save result
if (r > 0)
{
lbMessage.Text = "Data saved";
lbMessage.CssClass = "hc_success";
lbMessage.Visible = true;
}
else
{
lbMessage.Text = TMExpression.LastError;
lbMessage.CssClass = "hc_error";
lbMessage.Visible = true;
}
#endregion
}
/// <summary>
/// Show the list of translations for the selected TM Expression
/// </summary>
private void ShowTMTranslations()
{
using (HCExpression = TMExpression.GetByKey(Convert.ToInt32(expressionId)))
{
int TranslationsCount = HCExpression.Translations.Count - HCExpression.TranslationsMissingCount;
UITools.RefreshTab(Page, "Translations", "'" + TranslationsCount.ToString() + "/" + HCExpression.Translations.Count.ToString() + "'");
using (TMExpressionTranslationList list = TMExpressionTranslation.GetAll(expressionId, string.Empty))
{
dg.DataSource = list;
Utils.InitGridSort(ref dg, false);
dg.DisplayLayout.CellClickActionDefault = CellClickAction.NotSet;
dg.DisplayLayout.ActivationObject.AllowActivation = false;
dg.DataBind();
}
}
}
/// <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;
}
/// <summary>
/// Display TM expressions
/// </summary>
private void UpdateDataView()
{
string search = txtFilter.Text;
TMExpressionsList _tm;
string sSql = String.Empty;
#region Definition Search
if (search != string.Empty) // Search on all expressions
{
string cleanSearch = search.Replace("'", "''").ToLower();
cleanSearch = search.Replace("[", "[[]");
cleanSearch = search.Replace("_", "[_]");
cleanSearch = search.Replace("%", "[%]");
if (cbMatch.Checked)
{
sSql += " Lower(TMExpressionValue) = '" + cleanSearch.ToLower() + "' ";
}
else
{
sSql += " Lower(TMExpressionValue) like '%" + cleanSearch.ToLower() + "%' ";
}
}
#endregion
using (HyperComponents.Data.dbAccess.Database dbObj = new HyperComponents.Data.dbAccess.Database(SessionState.CacheComponents["CRYSTAL_DB"].ConnectionString))
{
using (System.Data.SqlClient.SqlDataReader rs = dbObj.RunSPReturnRS("_TM_GetAll",
new System.Data.SqlClient.SqlParameter("@Filter", sSql),
new System.Data.SqlClient.SqlParameter("@Mode", 1),
new System.Data.SqlClient.SqlParameter("@Company", SessionState.CompanyName)))
{
#region No result
rs.Read();
int c = Convert.ToInt32(rs["ResultCount"]);
if (c == 0)
{
lbNoresults.Text = "No record match your search (" + txtFilter.Text + ")";
lbNoresults.Visible = lbMessage.Visible = true;
dg.Visible = false;
}
#endregion
#region Results
else
{
#region Too much results
if (c > Convert.ToInt32(SessionState.CacheParams["TMMaxRows"].Value))
{
lbNoresults.Text = "There are " + c.ToString() + " expressions found over " + SessionState.CacheParams["TMMaxRows"].Value + ", please refine your search.";
lbNoresults.Visible = lbMessage.Visible = true;
dg.Visible = false;
}
#endregion
#region Display results
else
{
using (_tm = TMExpression.GetAll(sSql))
{
dg.DataSource = _tm;
dg.Columns[1].HeaderText = "TM [" + _tm.Count.ToString() + " item(s) found]";
dg.Bands[0].ColHeadersVisible = Infragistics.WebUI.UltraWebGrid.ShowMarginInfo.Yes;
lbNoresults.Visible = lbMessage.Visible = false;
Utils.InitGridSort(ref dg);
dg.DataBind();
dg.Visible = true;
#region PageIndex session
if (SessionState.tmPageIndexExpression != string.Empty)
{
dg.DisplayLayout.Pager.CurrentPageIndex = Convert.ToInt32(SessionState.tmPageIndexExpression);
}
else
{
dg.DisplayLayout.Pager.CurrentPageIndex = 1;
SessionState.tmPageIndexExpression = string.Empty;
}
#endregion
}
}
#endregion
}
dg.Columns.FromKey("ModifyDate").Format = SessionState.User.FormatDate + ' ' + SessionState.User.FormatTime;
rs.Close();
#endregion
}
}
}
protected void Page_Load(object sender, System.EventArgs e)
{
#region Check Capabilities
if ((SessionState.User.IsReadOnly) || (!SessionState.User.HasCapability(CapabilitiesEnum.MANAGE_TRANSLATION_MEMORY)))
{
uwToolbar.Items.FromKeyButton("Save").Enabled = false;
uwToolbar.Items.FromKeyButton("Delete").Enabled = false;
}
#endregion
if (Request["e"] != null)
{
expressionId = Convert.ToInt64(Request["e"]);
languageCode = Request["l"];
if (!Page.IsPostBack)
{
try
{
using (HyperCatalog.Business.Language l = HyperCatalog.Business.Language.GetByKey(languageCode))
{
string languageName = l.Name;
lbLanguage.Text = "[" + languageCode + "] " + languageName;
}
using (TMExpression t = TMExpression.GetByKey(expressionId))
{
if (t != null)
{
txtTMExpressionValueMaster.Text = t.Value;
using (TMExpressionTranslation tt = TMExpressionTranslation.GetByKey(expressionId, languageCode))
{
if (tt == null)
{
#region New translation
uwToolbarTitle.Items.FromKeyLabel("Action").Text = "Creating";
hlCreator.Text = UITools.GetDisplayName(t.User.FullName);
hlCreator.NavigateUrl = "mailto:" + UITools.GetDisplayEmail(t.User.Email) + Server.HtmlEncode("?subject=TMTranslation[#" + t.Id.ToString() + " - " + t.LanguageCode + "]");;
lbOrganization.Text = t.User.OrgName;
lbOrganization.Visible = hlCreator.Text == t.User.FullName;
lbCreatedOn.Text = SessionState.User.FormatUtcDate(t.ModifyDate.Value, true, SessionState.User.FormatDate + ' ' + SessionState.User.FormatTime);
#endregion
}
else
{
#region Update translation
uwToolbarTitle.Items.FromKeyLabel("Action").Text = "Updating";
txtTMExpressionValue.Text = tt.Value;
hlCreator.Text = tt.User.FullName;
hlCreator.NavigateUrl = "mailto:" + UITools.GetDisplayEmail(tt.User.Email) + Server.HtmlEncode("?subject=TMExpressionTranslation");;
lbOrganization.Text = tt.User.OrgName;
lbCreatedOn.Text = SessionState.User.FormatUtcDate(tt.ModifyDate.Value, true, SessionState.User.FormatDate + ' ' + SessionState.User.FormatTime);
#endregion
}
}
}
else
{
Response.Write("<script>alert('An error occurred when retrieving translation expression [" + Request["t"] + "]' );window.close();</script>");
Response.End();
}
}
}
catch (Exception ex)
{
Response.Write("<script>alert('An error occurred when retrieving translation expression:" + ex.Message + " [" + Request["t"] + "]' );window.close();</script>");
Response.End();
}
}
}
}
