1) In Administration/Modules/Categories.ascx add OnClientClick="setEvent();" to the save button
2) In Administration/Categories.aspx add this inside the <asp:Content> tag:
<input type="hidden" id="event" name="event" value="" />
<script language="javascript" type="text/javascript">
function setEvent() {
$get("event").value = "saveXML";
}
</script>
3) In Administration/Categories.aspx add this at the top of the page:
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%
try
{
if ((Page.IsPostBack) && (Request.Form["event"].ToString() == "saveXML"))
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["NopSqlConnection"].ConnectionString);
try
{
conn.Open();
DataTable dtCats = new DataTable("Categories");
string selectCategories = "SELECT CategoryID, Name, ParentCategoryID FROM Nop_Category WHERE (Published = 1) AND (Deleted = 0) ORDER BY Name";
SqlCommand cmd = new SqlCommand(selectCategories, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dtCats);
dtCats.WriteXml(Server.MapPath("~/categories.xml"));
}
catch (Exception ex)
{
LogManager.InsertLog(LogTypeEnum.Unknown, ex.Message, ex);
}
finally
{
conn.Close();
}
}
}
catch (Exception ex)
{
LogManager.InsertLog(LogTypeEnum.Unknown, ex.Message, ex);
}
%>
4) At the bottom of Modules/CategoryNavigation.ascx add this:
<asp:PlaceHolder ID="phSubMenus" runat="server">
<ajaxToolkit:HoverMenuExtender ID="HoverMenuExtender1" runat="server" TargetControlID="imgDropMenu"
PopDelay="500" PopupControlID="panelMenu" PopupPosition="Bottom">
</ajaxToolkit:HoverMenuExtender>
<asp:Panel ID="panelMenu" CssClass="panelMenu" runat="server">
<asp:Menu ID="catsMenu"
StaticHoverStyle-CssClass="catStaticHover"
DynamicHoverStyle-CssClass="catDynHover"
DynamicMenuItemStyle-CssClass="catDynMenuItem"
DynamicMenuStyle-CssClass="catDynMenu"
DynamicSelectedStyle-CssClass="catDynSelected"
StaticMenuItemStyle-CssClass="catStaticMenuItem"
StaticMenuStyle-CssClass="catStaticMenu"
StaticSelectedStyle-CssClass="catStaticSelected"
Orientation="Vertical"
DisappearAfter="500"
runat="server">
</asp:Menu>
</asp:Panel>
</asp:PlaceHolder>
Note: the panelMenu css class has to have visibility: hidden;
5) Add this at the top of Modules/CategoryNavigation.ascx
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<script runat="server">
protected override void OnPreRender(EventArgs e)
{
try
{
if (catsMenu.Items.Count == 0)
{
//create data table
DataTable dtMenu = new DataTable("Categories");
dtMenu.Columns.AddRange(
new DataColumn[] {
new DataColumn("CategoryID", typeof(int)),
new DataColumn("Name", typeof(string)),
new DataColumn("ParentCategoryID", typeof(int))
});
dtMenu.PrimaryKey = new DataColumn[] { dtMenu.Columns["CategoryID"] };
//load categories into data table
dtMenu.ReadXml(Server.MapPath("~/categories.xml"));
for (int i = 0; i < dtMenu.Rows.Count; i++)
{
if (dtMenu.Rows[i].Field<int>("ParentCategoryID") == 0)
{
string url = string.Format(SettingManager.GetSettingValue("SEO.Category.UrlRewriteFormat"), "http://www.myshopandsearch.com/", dtMenu.Rows[i].Field<int>("CategoryID"), SEOHelper.GetSEName(dtMenu.Rows[i].Field<string>("Name")));
MenuItem mi = new MenuItem(dtMenu.Rows[i].Field<string>("Name"), "", "", url);
catsMenu.Items.Add(mi);
for (int j = 0; j < dtMenu.Rows.Count; j++)
{
if (dtMenu.Rows[j].Field<int>("ParentCategoryID") == dtMenu.Rows[i].Field<int>("CategoryID"))
{
string subURL = string.Format(SettingManager.GetSettingValue("SEO.Category.UrlRewriteFormat"), "http://www.myshopandsearch.com/", dtMenu.Rows[j].Field<int>("CategoryID"), SEOHelper.GetSEName(dtMenu.Rows[j].Field<string>("Name")));
MenuItem subMI = new MenuItem(dtMenu.Rows[j].Field<string>("Name"), "", "", subURL);
mi.ChildItems.Add(subMI);
}
}
}
}
}
}
catch (Exception ex)
{
LogManager.InsertLog(LogTypeEnum.Unknown, ex.Message, ex);
}
base.OnInit(e);
}
</script>
You can experiment with this to get the levels to go as deep as you want.