protected void cmdEditPage_Click(object sender, EventArgs e)
{
pnlSelectPage.Visible = false;
pnlEditPage.Visible = true;
txtPageName.Text = string.Empty;
txtViewOrder.Text = "100";
EnhancedHtmlDB ehdb = new EnhancedHtmlDB();
SqlDataReader dr = ehdb.GetSinglePage(int.Parse(lstPages.SelectedItem.Value), WorkFlowVersion.Staging);
try
{
if (dr.Read())
{
txtPageName.Text = ((string)dr["Title"]);
txtViewOrder.Text = dr["ViewOrder"].ToString();
foreach (ListItem li in listLanguages.Items)
{
li.Selected = li.Value.Equals(dr["CultureCode"].ToString());
}
DesktopText.Text = Server.HtmlDecode(((string)dr["DesktopHtml"]));
}
}
finally
{
dr.Close();
}
if (DesktopText.Text.StartsWith(tokenModule))
{
kindOfContent.SelectedIndex = 1;
int module = int.Parse(DesktopText.Text.Substring(tokenModule.Length));
foreach (ListItem li in listModules.Items)
{
if (int.Parse(li.Value) == module)
{
li.Selected = true;
}
}
}
else if (DesktopText.Text.StartsWith(tokenPortalModule))
{
kindOfContent.SelectedIndex = 2;
int module = int.Parse(DesktopText.Text.Substring(tokenPortalModule.Length));
foreach (ListItem li in listAllModules.Items)
{
if (int.Parse(li.Value) == module)
{
li.Selected = true;
}
}
}
else
{
kindOfContent.SelectedIndex = 0;
}
kindOfContents_Click(sender, e);
}
protected void cmdDeletePage_Click(object sender, EventArgs e)
{
if ((lstPages.SelectedItem.Value != null) && (lstPages.SelectedItem.Value != "-1"))
{
EnhancedHtmlDB tdb1 = new EnhancedHtmlDB();
tdb1.DeletePage(int.Parse(this.lstPages.SelectedItem.Value));
if (lstPages.Items.Count > 0)
{
lstPages.SelectedIndex = 0;
cmdEditPage.Enabled = true;
cmdDeletePage.Enabled = true;
}
else
{
lstPages.SelectedIndex = -1;
cmdEditPage.Enabled = false;
cmdDeletePage.Enabled = false;
}
Response.Redirect(Request.Url.ToString(), true);
}
}
private DataTable giveMePages(bool addInvariantCulture)
{
bool selected = false;
int selectedPage = -1;
if (!(pageID == null))
{
selectedPage = int.Parse(pageID);
}
DataTable tabla = new DataTable("LocalizedPages");
tabla.Columns.Add(new DataColumn("ItemID", typeof(string)));
tabla.Columns.Add(new DataColumn("Title", typeof(string)));
tabla.Columns.Add(new DataColumn("DesktopHtml", typeof(string)));
EnhancedHtmlDB ehdb = new EnhancedHtmlDB();
using (SqlDataReader dr = ehdb.GetLocalizedPages(ModuleID, portalSettings.PortalUILanguage.LCID, Version))
{
while (dr.Read())
{
addPageRow(tabla, dr["ItemID"].ToString(), (string)dr["Title"], (string)dr["DesktopHtml"]);
if (int.Parse(dr["ItemID"].ToString()) == selectedPage)
{
selected = true;
}
}
if (tabla.Rows.Count == 0)
{
if (portalSettings.PortalUILanguage.Parent.LCID != System.Globalization.CultureInfo.InvariantCulture.LCID)
{
using (SqlDataReader dr1 = ehdb.GetLocalizedPages(ModuleID, portalSettings.PortalUILanguage.Parent.LCID, Version))
{
while (dr1.Read())
{
addPageRow(tabla, dr1["ItemID"].ToString(), (string)dr1["Title"], (string)dr1["DesktopHtml"]);
if (int.Parse(dr1["ItemID"].ToString()) == selectedPage)
{
selected = true;
}
}
}
}
}
if (addInvariantCulture || tabla.Rows.Count == 0)
{
using (SqlDataReader dr2 = ehdb.GetLocalizedPages(ModuleID, System.Globalization.CultureInfo.InvariantCulture.LCID, Version))
{
while (dr2.Read())
{
addPageRow(tabla, dr2["ItemID"].ToString(), (string)dr2["Title"], (string)dr2["DesktopHtml"]);
if (int.Parse(dr2["ItemID"].ToString()) == selectedPage)
{
selected = true;
}
}
}
}
}
if (!selected)
{
pageID = null;
}
return(tabla);
}
protected void cmdPageUpdate_Click(object sender, EventArgs e)
{
string titlePage = txtPageName.Text;
if (((titlePage == null) || (titlePage.Length < 1)) || (titlePage.Trim().Length < 1))
{
titlePage = "Page";
}
string orderView = txtViewOrder.Text;
int order = 0;
try
{
order = int.Parse(orderView);
}
catch
{
}
if (order < 1)
{
orderView = "100";
txtViewOrder.Text = orderView;
order = 100;
}
string text = string.Empty;
int i;
switch (kindOfContent.SelectedValue)
{
case "Editor":
text = Server.HtmlEncode(DesktopText.Text);
if (text.StartsWith(tokenModule) || text.StartsWith(tokenPortalModule))
{
text = string.Empty;
}
break;
case "Module":
i = int.Parse(listModules.SelectedValue);
if (i == 0 || i == this.ModuleID)
{
return; // Cannot select this module
}
text = tokenModule + listModules.SelectedValue;
break;
case "Portal":
i = int.Parse(listAllModules.SelectedValue);
if (i == 0 || i == this.ModuleID)
{
return; // Cannot select this module
}
text = tokenPortalModule + listAllModules.SelectedValue;
break;
}
string user = PortalSettings.CurrentUser.Identity.Email;
EnhancedHtmlDB tdb1 = new EnhancedHtmlDB();
if (lstPages.SelectedIndex >= 0)
{
int itemID = int.Parse(lstPages.SelectedItem.Value);
tdb1.UpdatePage(ModuleID, itemID, user, titlePage, order, int.Parse(listLanguages.SelectedItem.Value), text);
}
else
{
tdb1.AddPage(ModuleID, 0, user, titlePage, order, int.Parse(listLanguages.SelectedItem.Value), text);
}
pnlSelectPage.Visible = true;
pnlEditPage.Visible = false;
montaLista();
}
private void montaLista()
{
bool showAllPages = (int.Parse(lstLanguages.SelectedItem.Value) < 1);
CultureInfo[] listaLang = LanguageSwitcher.GetLanguageList(true);
EnhancedHtmlDB ehdb = new EnhancedHtmlDB();
SqlDataReader dr;
lstPages.Items.Clear();
if (showAllPages)
{
dr = ehdb.GetAllPages(ModuleID, WorkFlowVersion.Staging);
}
else
{
dr = ehdb.GetLocalizedPages(ModuleID, int.Parse(lstLanguages.SelectedItem.Value), WorkFlowVersion.Staging);
}
try
{
while (dr.Read())
{
if (showAllPages)
{
int ccode = int.Parse(dr["CultureCode"].ToString());
string texto = string.Empty;
foreach (CultureInfo ci in listaLang)
{
if (ccode == ci.LCID)
{
texto = ci.DisplayName;
}
}
if (texto != string.Empty)
{
lstPages.Items.Add(new ListItem((string)dr["Title"] + " (" + texto + ")", dr["ItemID"].ToString()));
}
}
else
{
lstPages.Items.Add(new ListItem((string)dr["Title"], dr["ItemID"].ToString()));
}
}
}
finally
{
dr.Close();
}
if (lstPages.Items.Count > 0)
{
lstPages.SelectedIndex = 0;
cmdEditPage.Enabled = true;
cmdDeletePage.Enabled = true;
}
else
{
cmdEditPage.Enabled = false;
cmdDeletePage.Enabled = false;
}
}
