/// <summary>
/// OnUpdate
/// </summary>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
protected override void OnUpdate(EventArgs e)
{
base.OnUpdate(e);
if (Page.IsValid) {
//Get Solutions
PortalsDB portals = new PortalsDB();
try {
PathField.Text = PathField.Text.Replace("/", string.Empty);
PathField.Text = PathField.Text.Replace("\\", string.Empty);
PathField.Text = PathField.Text.Replace(".", string.Empty);
if (!chkUseXMLTemplate.Checked) {
// Create portal the "old" way
int NewPortalID =
portals.CreatePortal(this.PortalSettings.PortalID, AliasField.Text, TitleField.Text, PathField.Text);
// Update custom settings in the database
EditTable.ObjectID = NewPortalID;
EditTable.UpdateControls();
} else {
bool createdOk = true;
int newPortalID = CreatePortal(out createdOk);
if (!createdOk) {
string aux = General.GetString("NEW_PORTAL_ERROR", "There was an error on creating the portal", this);
ErrorMessage.Visible = true;
ErrorMessage.Text = aux + "<br>";
return;
}
}
// Redirect back to calling page
RedirectBackToReferringPage();
} catch (Exception ex) {
string aux =
General.GetString("NEW_PORTAL_ERROR", "There was an error on creating the portal", this);
ErrorHandler.Publish(LogLevel.Error, aux, ex);
ErrorMessage.Visible = true;
ErrorMessage.Text = aux + "<br>";
}
}
}
/// <summary>
/// Initializes a new instance of the <see cref="PortalSettings"/> class.
/// The PortalSettings Constructor encapsulates all of the logic
/// necessary to obtain configuration settings necessary to render
/// a Portal Page view for a given request.<br/>
/// These Portal Settings are stored within a SQL database, and are
/// fetched below by calling the "GetPortalSettings" stored procedure.<br/>
/// This stored procedure returns values as SPROC output parameters,
/// and using three result sets.
/// </summary>
/// <param name="pageId">
/// The page id.
/// </param>
/// <param name="portalAlias">
/// The portal alias.
/// </param>
/// <remarks>
/// </remarks>
private PortalSettings(int pageId, string portalAlias)
{
this.ActivePage = new PageSettings();
this.DesktopPages = new List<PageStripDetails>();
this.ShowPages = true;
this.MobilePages = new ArrayList();
// Create Instance of Connection and Command Object
using (var connection = Config.SqlConnectionString)
using (var command = new SqlCommand("rb_GetPortalSettings", connection))
{
// Mark the Command as a SPROC
command.CommandType = CommandType.StoredProcedure;
// Add Parameters to SPROC
var parameterPortalAlias = new SqlParameter("@PortalAlias", SqlDbType.NVarChar, 128)
{
Value = portalAlias // Specify the Portal Alias Dynamically
};
command.Parameters.Add(parameterPortalAlias);
var parameterPageId = new SqlParameter(StringsAtPageId, SqlDbType.Int, 4) { Value = pageId };
command.Parameters.Add(parameterPageId);
var parameterPortalLanguage = new SqlParameter("@PortalLanguage", SqlDbType.NVarChar, 12)
{
Value = this.PortalContentLanguage.Name
};
command.Parameters.Add(parameterPortalLanguage);
// Add out parameters to Sproc
var parameterPortalId = new SqlParameter(StringsAtPortalId, SqlDbType.Int, 4)
{
Direction = ParameterDirection.Output
};
command.Parameters.Add(parameterPortalId);
var parameterPortalName = new SqlParameter("@PortalName", SqlDbType.NVarChar, 128)
{
Direction = ParameterDirection.Output
};
command.Parameters.Add(parameterPortalName);
var parameterPortalPath = new SqlParameter("@PortalPath", SqlDbType.NVarChar, 128)
{
Direction = ParameterDirection.Output
};
command.Parameters.Add(parameterPortalPath);
var parameterEditButton = new SqlParameter("@AlwaysShowEditButton", SqlDbType.Bit, 1)
{
Direction = ParameterDirection.Output
};
command.Parameters.Add(parameterEditButton);
var parameterPageName = new SqlParameter("@PageName", SqlDbType.NVarChar, 50)
{
Direction = ParameterDirection.Output
};
command.Parameters.Add(parameterPageName);
var parameterPageOrder = new SqlParameter("@PageOrder", SqlDbType.Int, 4)
{
Direction = ParameterDirection.Output
};
command.Parameters.Add(parameterPageOrder);
var parameterParentPageId = new SqlParameter("@ParentPageID", SqlDbType.Int, 4)
{
Direction = ParameterDirection.Output
};
command.Parameters.Add(parameterParentPageId);
var parameterMobilePageName = new SqlParameter("@MobilePageName", SqlDbType.NVarChar, 50)
{
Direction = ParameterDirection.Output
};
command.Parameters.Add(parameterMobilePageName);
var parameterAuthRoles = new SqlParameter("@AuthRoles", SqlDbType.NVarChar, 512)
{
Direction = ParameterDirection.Output
};
command.Parameters.Add(parameterAuthRoles);
var parameterShowMobile = new SqlParameter("@ShowMobile", SqlDbType.Bit, 1)
{
Direction = ParameterDirection.Output
};
command.Parameters.Add(parameterShowMobile);
SqlDataReader result;
try
{
// Open the database connection and execute the command
// try // jes1111
// {
connection.Open();
result = command.ExecuteReader(CommandBehavior.CloseConnection);
this.CurrentLayout = "Default";
// Read the first resultset -- Desktop Page Information
while (result.Read())
{
var tabDetails = new PageStripDetails
{
PageID = (int)result["PageID"],
ParentPageID = Int32.Parse("0" + result["ParentPageID"]),
PageName = (string)result["PageName"],
PageOrder = (int)result["PageOrder"],
PageLayout = this.CurrentLayout,
AuthorizedRoles = (string)result["AuthorizedRoles"]
};
this.PortalAlias = portalAlias;
// Update the AuthorizedRoles Variable
this.DesktopPages.Add(tabDetails);
}
if (this.DesktopPages.Count == 0)
{
return; // Abort load
// throw new Exception("The portal you requested has no Pages. PortalAlias: '" + portalAlias + "'", new HttpException(404, "Portal not found"));
}
// Read the second result -- Mobile Page Information
result.NextResult();
while (result.Read())
{
var tabDetails = new PageStripDetails
{
PageID = (int)result["PageID"],
PageName = (string)result["MobilePageName"],
PageLayout = this.CurrentLayout,
AuthorizedRoles = (string)result["AuthorizedRoles"]
};
this.MobilePages.Add(tabDetails);
}
// Read the third result -- Module Page Information
result.NextResult();
while (result.Read())
{
var m = new ModuleSettings
{
ModuleID = (int)result["ModuleID"],
ModuleDefID = (int)result["ModuleDefID"],
GuidID = (Guid)result["GeneralModDefID"],
PageID = (int)result["TabID"],
PaneName = (string)result["PaneName"],
ModuleTitle = (string)result["ModuleTitle"]
};
var value = result["AuthorizedEditRoles"];
m.AuthorizedEditRoles = !Convert.IsDBNull(value) ? (string)value : string.Empty;
value = result["AuthorizedViewRoles"];
m.AuthorizedViewRoles = !Convert.IsDBNull(value) ? (string)value : string.Empty;
value = result["AuthorizedAddRoles"];
m.AuthorizedAddRoles = !Convert.IsDBNull(value) ? (string)value : string.Empty;
value = result["AuthorizedDeleteRoles"];
m.AuthorizedDeleteRoles = !Convert.IsDBNull(value) ? (string)value : string.Empty;
value = result["AuthorizedPropertiesRoles"];
m.AuthorizedPropertiesRoles = !Convert.IsDBNull(value) ? (string)value : string.Empty;
// [email protected] (19/08/2004) Add support for move & delete module roles
value = result["AuthorizedMoveModuleRoles"];
m.AuthorizedMoveModuleRoles = !Convert.IsDBNull(value) ? (string)value : string.Empty;
value = result["AuthorizedDeleteModuleRoles"];
m.AuthorizedDeleteModuleRoles = !Convert.IsDBNull(value) ? (string)value : string.Empty;
// Change by [email protected]
// Date: 6/2/2003
value = result["AuthorizedPublishingRoles"];
m.AuthorizedPublishingRoles = !Convert.IsDBNull(value) ? (string)value : string.Empty;
value = result["SupportWorkflow"];
m.SupportWorkflow = !Convert.IsDBNull(value) ? (bool)value : false;
// Date: 27/2/2003
value = result["AuthorizedApproveRoles"];
m.AuthorizedApproveRoles = !Convert.IsDBNull(value) ? (string)value : string.Empty;
value = result["WorkflowState"];
m.WorkflowStatus = !Convert.IsDBNull(value)
? (WorkflowState)(0 + (byte)value)
: WorkflowState.Original;
// End Change [email protected]
// Start Change [email protected]
try
{
value = result["SupportCollapsable"];
}
catch
{
value = DBNull.Value;
}
m.SupportCollapsable = DBNull.Value != value ? (bool)value : false;
// End Change [email protected]
// Start Change [email protected]
try
{
value = result["ShowEveryWhere"];
}
catch
{
value = DBNull.Value;
}
m.ShowEveryWhere = DBNull.Value != value ? (bool)value : false;
// End Change [email protected]
m.CacheTime = int.Parse(result["CacheTime"].ToString());
m.ModuleOrder = int.Parse(result["ModuleOrder"].ToString());
value = result["ShowMobile"];
m.ShowMobile = !Convert.IsDBNull(value) ? (bool)value : false;
m.DesktopSrc = result["DesktopSrc"].ToString();
m.MobileSrc = result["MobileSrc"].ToString();
m.Admin = bool.Parse(result["Admin"].ToString());
this.ActivePage.Modules.Add(m);
}
// Now read Portal out params
result.NextResult();
this.PortalID = (int)parameterPortalId.Value;
this.PortalName = (string)parameterPortalName.Value;
// jes1111 - this.PortalTitle = ConfigurationSettings.AppSettings["PortalTitlePrefix"] + this.PortalName;
this.PortalTitle = String.Concat(Config.PortalTitlePrefix, this.PortalName);
// jes1111 - this.PortalPath = Settings.Path.WebPathCombine(ConfigurationSettings.AppSettings["PortalsDirectory"], (string) parameterPortalPath.Value);
this.PortalPath = Path.WebPathCombine(Config.PortalsDirectory, (string)parameterPortalPath.Value);
// jes1111 - this.PortalSecurePath = ConfigurationSettings.AppSettings["PortalSecureDirectory"]; // added Thierry (tiptopweb) 12 Apr 2003
this.PortalSecurePath = Config.PortalSecureDirectory;
this.ActivePage.PageID = pageId;
this.ActivePage.PageLayout = this.CurrentLayout;
this.ActivePage.ParentPageID = Int32.Parse("0" + parameterParentPageId.Value);
this.ActivePage.PageOrder = (int)parameterPageOrder.Value;
this.ActivePage.MobilePageName = (string)parameterMobilePageName.Value;
this.ActivePage.AuthorizedRoles = (string)parameterAuthRoles.Value;
this.ActivePage.PageName = (string)parameterPageName.Value;
this.ActivePage.ShowMobile = (bool)parameterShowMobile.Value;
this.ActivePage.PortalPath = this.PortalPath; // [email protected] for page custom layout
result.Close(); // by Manu, fixed bug 807858
// }
// catch (Exception ex)
// {
// HttpContext.Current.Response.Write("Failed rb_GetPortalSettings for " + pageID.ToString() + ", " + portalAlias + ":<br/>"+ex.Message);
// HttpContext.Current.Response.End();
// //Response.Redirect("~/app_support/ErrorNoPortal.aspx",true);
// }
}
catch (SqlException sqex)
{
var requestUri = HttpContext.Current.Request.Url;
throw new DatabaseUnreachableException("This may be a new db", sqex);
return;
}
finally
{
// by Manu fix close bug #2
if (connection.State == ConnectionState.Open)
{
connection.Close();
}
}
}
// Provide a valid tab id if it is missing
// 11-10-2011
// Changed to go to the first page that the user logged has permission to see
//if (this.ActivePage.PageID == 0)
//{
// this.ActivePage.PageID = ((PageStripDetails)this.DesktopPages[0]).PageID;
//}
// Go to get custom settings
if (!Directory.Exists(Path.ApplicationPhysicalPath + this.PortalFullPath))
{
var portals = new PortalsDB();
portals.CreatePortalPath(this.PortalAlias);
}
this.CustomSettings = GetPortalCustomSettings(this.PortalID, GetPortalBaseSettings(this.PortalPath));
// Initialize Theme
var themeManager = new ThemeManager(this.PortalPath);
// Default
themeManager.Load(this.CustomSettings["SITESETTINGS_THEME"].ToString());
this.CurrentThemeDefault = themeManager.CurrentTheme;
// Alternate
if (this.CustomSettings["SITESETTINGS_ALT_THEME"].ToString() == this.CurrentThemeDefault.Name)
{
this.CurrentThemeAlt = this.CurrentThemeDefault;
}
else
{
themeManager.Load(this.CustomSettings["SITESETTINGS_ALT_THEME"].ToString());
this.CurrentThemeAlt = themeManager.CurrentTheme;
}
// themeManager.Save(this.CustomSettings["SITESETTINGS_THEME"].ToString());
// Set layout
this.CurrentLayout = this.CustomSettings["SITESETTINGS_PAGE_LAYOUT"].ToString();
// Jes1111
// Generate DesktopPagesXml
// jes1111 - if (bool.Parse(ConfigurationSettings.AppSettings["PortalSettingDesktopPagesXml"]))
// if (Config.PortalSettingDesktopPagesXml)
// this.DesktopPagesXml = GetDesktopPagesXml();
}
/// <summary>
/// Gets the number of users currently accessing the application.
/// </summary>
/// <returns>
/// The number of users currently accessing the application.
/// </returns>
/// <remarks>
/// </remarks>
public override int GetNumberOfUsersOnline()
{
var totalNumberOfUsers = 0;
var portalsDb = new PortalsDB();
var dr = portalsDb.GetPortals();
try
{
while (dr.Read())
{
totalNumberOfUsers += GetNumberOfUsersOnline(dr["PortalAlias"].ToString());
}
}
finally
{
dr.Close(); // by Manu, fixed bug 807858
}
return totalNumberOfUsers;
}
/// <summary>
/// Creates the portal.
/// </summary>
/// <param name="templateID">The template ID.</param>
/// <param name="templateAlias">The template alias.</param>
/// <param name="portalAlias">The portal alias.</param>
/// <param name="portalName">Name of the portal.</param>
/// <param name="portalPath">The portal path.</param>
/// <returns></returns>
private int CreatePortal(int templateID, string templateAlias, string portalAlias, string portalName,
string portalPath)
{
int newPortalID;
PortalsDB portals = new PortalsDB();
PagesDB tabs = new PagesDB();
ModulesDB modules = new ModulesDB();
UsersDB users = new UsersDB();
// create an Array to stores modules ID and GUID for finding them later
ArrayList templateModules = new ArrayList();
moduleTemplate module;
// create an Array to stores tabs ID for finding them later
ArrayList templateTabs = new ArrayList();
tabTemplate tab;
// Create a new portal
newPortalID = portals.AddPortal(portalAlias, portalName, portalPath);
// Open the connection to the PortalTemplates Database
SqlConnection myConnection = GetConnection();
SqlConnection my2ndConnection = GetConnection();
SqlConnection my3rdConnection = GetConnection();
myConnection.Open();
my2ndConnection.Open();
my3rdConnection.Open();
// get module definitions and save them in the new portal
SqlDataReader myReader = GetTemplateModuleDefinitions(templateID, myConnection);
// Always call Read before accessing data.
while (myReader.Read()) {
module.id = (int)myReader["ModuleDefID"];
module.GuidID = GetGeneralModuleDefinitionByName(myReader["FriendlyName"].ToString(), my2ndConnection);
try {
// save module definitions in the new portal
modules.UpdateModuleDefinitions(module.GuidID, newPortalID, true);
// Save the modules into a list for finding them later
templateModules.Add(module);
} catch {
// tried to add a Module thas doesn´t exists in this implementation of the portal
}
}
myReader.Close();
// TODO: Is this still valid? Admin user will be created the first time the portal is accessed
//if (!Config.UseSingleUserBase)
//{
// // TODO: multiple portals still not supported
// Guid userID;
// // Create the "admin" User for the new portal
// string AdminEmail = "*****@*****.**";
// userID = users.AddUser("admin", AdminEmail, "admin", newPortalID);
// // Create a new row in a many to many table (userroles)
// // giving the "admins" role to the "admin" user
// users.AddUserRole("admin", userID);
//}
// Get all the Tabs in the Template Portal, store IDs in a list for finding them later
// and create the Tabs in the new Portal
myReader = GetTabsByPortal(templateID, myConnection);
// Always call Read before accessing data.
while (myReader.Read()) {
// Save the tabs into a list for finding them later
tab.oldID = (int)myReader["PageID"];
tab.newID =
tabs.AddPage(newPortalID, myReader["PageName"].ToString(),
Int32.Parse(myReader["PageOrder"].ToString()));
templateTabs.Add(tab);
}
myReader.Close();
//Clear SiteMaps Cache
AppleseedSiteMapProvider.ClearAllAppleseedSiteMapCaches();
// now I have to get them again to set up the ParentID for each Tab
myReader = GetTabsByPortal(templateID, myConnection);
// Always call Read before accessing data.
while (myReader.Read()) {
// Find the news TabID and ParentTabID
IEnumerator myEnumerator = templateTabs.GetEnumerator();
int newTabID = -1;
int newParentTabID = -1;
while (myEnumerator.MoveNext() && (newTabID == -1 || newParentTabID == -1)) {
tab = (tabTemplate)myEnumerator.Current;
if (tab.oldID == (int)myReader["PageID"])
newTabID = tab.newID;
if (tab.oldID == Int32.Parse("0" + myReader["ParentPageID"]))
newParentTabID = tab.newID;
}
if (newParentTabID == -1)
newParentTabID = 0;
// Update the Tab in the new portal
tabs.UpdatePage(newPortalID, newTabID, newParentTabID, myReader["PageName"].ToString(),
Int32.Parse(myReader["PageOrder"].ToString()), myReader["AuthorizedRoles"].ToString(),
myReader["MobilePageName"].ToString(), (bool)myReader["ShowMobile"]);
// Finally use GetPortalSettings to access each Tab and its Modules in the Template Portal
// and create them in the new Portal
SqlDataReader result;
try {
result = GetPageModules(Int32.Parse(myReader["PageID"].ToString()), my2ndConnection);
object myValue;
while (result.Read()) {
ModuleSettings m = new ModuleSettings();
m.ModuleID = (int)result["ModuleID"];
m.ModuleDefID = (int)result["ModuleDefID"];
m.PageID = newTabID;
m.PaneName = (string)result["PaneName"];
m.ModuleTitle = (string)result["ModuleTitle"];
myValue = result["AuthorizedEditRoles"];
m.AuthorizedEditRoles = !Convert.IsDBNull(myValue) ? (string)myValue : string.Empty;
myValue = result["AuthorizedViewRoles"];
m.AuthorizedViewRoles = !Convert.IsDBNull(myValue) ? (string)myValue : string.Empty;
myValue = result["AuthorizedAddRoles"];
m.AuthorizedAddRoles = !Convert.IsDBNull(myValue) ? (string)myValue : string.Empty;
myValue = result["AuthorizedDeleteRoles"];
m.AuthorizedDeleteRoles = !Convert.IsDBNull(myValue) ? (string)myValue : string.Empty;
myValue = result["AuthorizedPropertiesRoles"];
m.AuthorizedPropertiesRoles = !Convert.IsDBNull(myValue) ? (string)myValue : string.Empty;
myValue = result["AuthorizedMoveModuleRoles"];
m.AuthorizedMoveModuleRoles = !Convert.IsDBNull(myValue) ? (string)myValue : string.Empty;
myValue = result["AuthorizedDeleteModuleRoles"];
m.AuthorizedDeleteModuleRoles = !Convert.IsDBNull(myValue) ? (string)myValue : string.Empty;
myValue = result["AuthorizedPublishingRoles"];
m.AuthorizedPublishingRoles = !Convert.IsDBNull(myValue) ? (string)myValue : string.Empty;
myValue = result["SupportWorkflow"];
m.SupportWorkflow = !Convert.IsDBNull(myValue) ? (bool)myValue : false;
myValue = result["AuthorizedApproveRoles"];
m.AuthorizedApproveRoles = !Convert.IsDBNull(myValue) ? (string)myValue : string.Empty;
myValue = result["WorkflowState"];
m.WorkflowStatus = !Convert.IsDBNull(myValue)
? (WorkflowState)(0 + (byte)myValue)
: WorkflowState.Original;
try {
myValue = result["SupportCollapsable"];
} catch {
myValue = DBNull.Value;
}
m.SupportCollapsable = DBNull.Value != myValue ? (bool)myValue : false;
try {
myValue = result["ShowEveryWhere"];
} catch {
myValue = DBNull.Value;
}
m.ShowEveryWhere = DBNull.Value != myValue ? (bool)myValue : false;
m.CacheTime = int.Parse(result["CacheTime"].ToString());
m.ModuleOrder = int.Parse(result["ModuleOrder"].ToString());
myValue = result["ShowMobile"];
m.ShowMobile = !Convert.IsDBNull(myValue) ? (bool)myValue : false;
// Find the new ModuleDefID assigned to the module in the new portal
myEnumerator = templateModules.GetEnumerator();
int newModuleDefID = 0;
while (myEnumerator.MoveNext() && newModuleDefID == 0) {
module = (moduleTemplate)myEnumerator.Current;
if (module.id == m.ModuleDefID)
newModuleDefID = modules.GetModuleDefinitionByGuid(newPortalID, module.GuidID);
}
if (newModuleDefID > 0) {
// add the module to the new tab
int newModuleID = modules.AddModule(newTabID, m.ModuleOrder, m.PaneName, m.ModuleTitle,
newModuleDefID, m.CacheTime, m.AuthorizedEditRoles,
m.AuthorizedViewRoles,
m.AuthorizedAddRoles, m.AuthorizedDeleteRoles,
m.AuthorizedPropertiesRoles,
m.AuthorizedMoveModuleRoles,
m.AuthorizedDeleteModuleRoles,
m.ShowMobile, m.AuthorizedPublishingRoles,
m.SupportWorkflow,
m.ShowEveryWhere, m.SupportCollapsable);
// At the end, get all ModuleSettings and save them in the new module
SqlDataReader dr = GetModuleSettings(m.ModuleID, my3rdConnection);
while (dr.Read()) {
Framework.Site.Configuration.ModuleSettings.UpdateModuleSetting(newModuleID, dr["SettingName"].ToString(),
dr["SettingValue"].ToString());
}
dr.Close();
}
}
result.Close();
} catch {
// Error? ignore Tab ...
}
}
myReader.Close();
// Set the CustomSettings of the New Portal based in the Template Portal
myReader = GetPortalCustomSettings(templateID, myConnection);
// Always call Read before accessing data.
while (myReader.Read()) {
PortalSettings.UpdatePortalSetting(newPortalID, myReader["SettingName"].ToString(),
myReader["SettingValue"].ToString());
}
myReader.Close();
// close the conections
myConnection.Close();
myConnection.Dispose();
my2ndConnection.Close();
my2ndConnection.Dispose();
my3rdConnection.Close();
my3rdConnection.Dispose();
// Create paths
portals.CreatePortalPath(portalPath);
return newPortalID;
}
private int CreatePortal(out bool createdOk)
{
string fileName = ddlXMLTemplates.Text;
string portalAlias = AliasField.Text;
string portalName = TitleField.Text;
string portalPath = "/" + PathField.Text;
IPortalTemplateRepository repository = new PortalTemplateRepository();
IPortalTemplateServices services = PortalTemplateFactory.GetPortalTemplateServices(repository);
int newPortalID = 1;
createdOk = services.DeserializePortal(fileName, portalName, portalAlias, portalPath, PortalSettings.PortalFullPath, out newPortalID);
if (createdOk && !Config.UseSingleUserBase) {
string AdminEmail = "*****@*****.**";
// Create the stradmin User for the new portal
UsersDB User = new UsersDB();
// Create the "Admins" role for the new portal
Guid roleID = User.AddRole(portalAlias, "Admins");
Guid userID = User.AddUser("admin", AdminEmail, "admin", portalAlias);
// Create a new row in a many to many table (userroles)
// giving the "admins" role to the stradmin user
User.AddUserRole(roleID, userID, portalAlias);
PortalsDB portals = new PortalsDB();
portals.CreatePortalPath(portalPath);
}
return newPortalID;
}
private void LoadPortalList()
{
portals = new ArrayList();
PortalsDB portalsDb = new PortalsDB();
SqlDataReader dr = portalsDb.GetPortals();
try {
while (dr.Read()) {
PortalItem p = new PortalItem();
p.Name = dr["PortalName"].ToString();
p.Path = dr["PortalPath"].ToString();
p.ID = Convert.ToInt32(dr["PortalID"].ToString());
portals.Add(p);
}
} finally {
dr.Close(); //by Manu, fixed bug 807858
}
}
/// <summary>
/// OnDelete
/// </summary>
protected override void OnDelete()
{
if (portalList.SelectedIndex != -1) {
try {
// must delete from database too
PortalItem p = (PortalItem)portals[portalList.SelectedIndex];
PortalsDB portalsdb = new PortalsDB();
//Response.Write("Will delete " + p.Name);
portalsdb.DeletePortal(p.ID);
// remove item from list
portals.RemoveAt(portalList.SelectedIndex);
// rebind list
portalList.DataBind();
} catch (SqlException sqlex) {
string aux =
General.GetString("DELETE_PORTAL_ERROR", "There was an error on deleting the portal", this);
Appleseed.Framework.ErrorHandler.Publish(Appleseed.Framework.LogLevel.Error, aux, sqlex);
Controls.Add(new LiteralControl("<br><span class=NormalRed>" + aux + "<br>"));
}
}
base.OnDelete();
}
