protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_MenuManager_TopMenu);
Int32.TryParse(Request["menuid"], out _menuId);
_needReloadTree = Convert.ToBoolean(ViewState["updateTree"]);
hlEditCategory.Visible = _menuId > 0;
lblSeparator.Visible = _menuId > 0;
hlDeleteCategory.Visible = _menuId > 0;
if (!string.IsNullOrWhiteSpace(Request["type"]))
{
Enum.TryParse(Request["type"], true, out _menuType);
}
var menuitem = new AdvMenuItem();
switch (_menuType)
{
case MenuService.EMenuType.Top:
//_menuType = MenuService.EMenuType.Top;
menuitem = MenuService.GetMenuItemById(_menuId, _menuType);
lblHead.Text = menuitem == null
? Resource.Admin_MenuManager_TopMenu
: string.Format("{0} - {1}", Resource.Admin_MenuManager_TopMenu, menuitem.MenuItemName);
lblSubHead.Text = Resource.Admin_MenuManager_SubHeaderTop;
Page.Title = menuitem == null
? Resource.Admin_MenuManager_TopMenu
: string.Format("{0} - {1}", Resource.Admin_MenuManager_TopMenu, menuitem.MenuItemName);
break;
case MenuService.EMenuType.Bottom:
//_menuType = MenuService.EMenuType.Bottom;
menuitem = MenuService.GetMenuItemById(_menuId, _menuType);
lblHead.Text = menuitem == null
? Resource.Admin_MenuManager_BottomMenu
: string.Format("{0} - {1}", Resource.Admin_MenuManager_BottomMenu, menuitem.MenuItemName);
lblSubHead.Text = Resource.Admin_MenuManager_SubHeaderBottom;
Page.Title = menuitem == null
? Resource.Admin_MenuManager_BottomMenu
: string.Format("{0} - {1}", Resource.Admin_MenuManager_BottomMenu, menuitem.MenuItemName);
break;
}
btnAdd.OnClientClick = "open_window('m_Menu.aspx?MenuID=" + _menuId + "&mode=create&type=" + _menuType + "', 750, 640);return false;";
hlEditCategory.NavigateUrl = "javascript:open_window(\'m_Menu.aspx?MenuID=" + _menuId + "&mode=edit&type=" + _menuType + "\', 750, 640)";
ConfirmButtonExtenderCategory.ConfirmText =
string.Format(Resource.Admin_MasterPageAdminCatalog_MenuConfirmation, menuitem != null ? menuitem.MenuItemName : string.Empty);
if (!IsPostBack)
{
if (_menuType == MenuService.EMenuType.Top)
{
_paging = new SqlPaging
{
TableName = "[CMS].[MainMenu]",
ItemsPerPage = 10
};
}
else if (_menuType == MenuService.EMenuType.Bottom)
{
_paging = new SqlPaging
{
TableName = "[CMS].[BottomMenu]",
ItemsPerPage = 10
};
}
_paging.AddFieldsRange(new List <Field>
{
new Field
{
Name = "MenuItemID as ID",
IsDistinct = true
},
new Field {
Name = "MenuItemParentID"
},
new Field {
Name = "MenuItemName"
},
new Field {
Name = "Enabled"
},
new Field {
Name = "Blank"
},
new Field {
Name = "SortOrder", Sorting = SortDirection.Ascending
}
});
if (_menuId != 0)
{
var filter = new EqualFieldFilter {
ParamName = "@MenuItemParentID", Value = _menuId.ToString()
};
_paging.Fields["MenuItemParentID"].Filter = filter;
}
else
{
var filter = new NullFieldFilter {
ParamName = "@MenuItemParentID", Null = true
};
_paging.Fields["MenuItemParentID"].Filter = filter;
}
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_StaticPage_lblSubMain));
int.TryParse(Request["parentid"], out _parentPageId);
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[CMS].[StaticPage]",
ItemsPerPage = 10
};
_paging.AddFieldsRange(new List <Field>
{
new Field {
Name = "StaticPageID as ID", IsDistinct = true
},
new Field {
Name = "PageName"
},
new Field {
Name = "Enabled"
},
new Field {
Name = "ParentID"
},
new Field {
Name = "SortOrder", Sorting = SortDirection.Ascending
},
new Field {
Name = "ModifyDate"
}
});
if (_parentPageId != 0)
{
var ef = new EqualFieldFilter()
{
ParamName = "@ParentID",
Value = _parentPageId.ToString(CultureInfo.InvariantCulture)
};
_paging.Fields["ParentID"].Filter = ef;
}
else
{
var nf = new NullFieldFilter()
{
ParamName = "@ParentID",
Null = true
};
_paging.Fields["ParentID"].Filter = nf;
}
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void btnFilter_Click(object sender, EventArgs e)
{
//-----Selection filter
if (ddSelect.SelectedIndex != 0)
{
if (ddSelect.SelectedIndex == 2)
{
if (_selectionFilter != null)
{
_selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
}
else
{
_selectionFilter = null;
}
}
if (_selectionFilter != null)
{
_paging.Fields["ID"].Filter = _selectionFilter;
}
}
else
{
_paging.Fields["ID"].Filter = null;
}
//----Enabled filter
if (ddlEnabled.SelectedIndex != 0)
{
var efilter = new EqualFieldFilter {
ParamName = "@enabled"
};
if (ddlEnabled.SelectedIndex == 1)
{
efilter.Value = "1";
}
if (ddlEnabled.SelectedIndex == 2)
{
efilter.Value = "0";
}
_paging.Fields["Enabled"].Filter = efilter;
}
else
{
_paging.Fields["Enabled"].Filter = null;
}
//----Price filter
var priceFilter = new RangeFieldFilter {
ParamName = "@price"
};
int priceFrom;
priceFilter.From = int.TryParse(txtPriceFrom.Text, out priceFrom) ? priceFrom : 0;
int priceTo;
priceFilter.To = int.TryParse(txtPriceTo.Text, out priceTo) ? priceTo : int.MaxValue;
if (!string.IsNullOrEmpty(txtPriceFrom.Text) || !string.IsNullOrEmpty(txtPriceTo.Text))
{
_paging.Fields["Price"].Filter = priceFilter;
}
else
{
_paging.Fields["Price"].Filter = null;
}
//----Qty filter
var qtyFilter = new RangeFieldFilter {
ParamName = "@Amount"
};
int from;
qtyFilter.From = int.TryParse(txtQtyFrom.Text, out from) ? from : int.MinValue;
int to;
qtyFilter.To = int.TryParse(txtQtyTo.Text, out to) ? to : int.MaxValue;
if (!string.IsNullOrEmpty(txtQtyFrom.Text) || !string.IsNullOrEmpty(txtQtyTo.Text))
{
_paging.Fields["Amount"].Filter = qtyFilter;
}
else
{
_paging.Fields["Amount"].Filter = null;
}
//----SortOrder filter
var soFilter = new RangeFieldFilter {
ParamName = "@SortOrder"
};
try
{
soFilter.From = int.Parse(txtSortOrderFrom.Text);
}
catch (Exception)
{
soFilter.From = int.MinValue;
}
try
{
soFilter.To = int.Parse(txtSortOrderTo.Text);
}
catch (Exception)
{
soFilter.To = int.MaxValue;
}
if (ShowMethod == EShowMethod.Normal)
{
if (!string.IsNullOrEmpty(txtSortOrderFrom.Text) || !string.IsNullOrEmpty(txtSortOrderTo.Text))
{
_paging.Fields["ProductCategories.SortOrder"].Filter = soFilter;
}
else
{
_paging.Fields["ProductCategories.SortOrder"].Filter = null;
}
}
if (!string.IsNullOrEmpty(txtArtNo.Text))
{
var sfilter = new CompareFieldFilter {
Expression = txtArtNo.Text, ParamName = "@artno"
};
_paging.Fields["ArtNo"].Filter = sfilter;
}
else
{
_paging.Fields["ArtNo"].Filter = null;
}
//----Name filter
if (!string.IsNullOrEmpty(txtName.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtName.Text, ParamName = "@name"
};
_paging.Fields["Name"].Filter = nfilter;
}
else
{
_paging.Fields["Name"].Filter = null;
}
//---Photo filter
if (ddPhoto.SelectedIndex != 0)
{
var phfilter = new NullFieldFilter();
if (ddPhoto.SelectedIndex == 1)
{
phfilter.Null = false;
}
if (ddPhoto.SelectedIndex == 2)
{
phfilter.Null = true;
}
phfilter.ParamName = "@PhotoName";
_paging.Fields["PhotoName"].Filter = phfilter;
}
else
{
_paging.Fields["PhotoName"].Filter = null;
}
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
//lblFound.Text = _paging.TotalRowsCount.ToString();
//pnlFilterCount.Visible = true;
//pnlNormalCount.Visible = false;
}
