protected void btnFilter_Click(object sender, EventArgs e) { //-----Selection filter if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "0") != 0) { if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "2") == 0) { if (_selectionFilter != null) { _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues; } else { _selectionFilter = null; } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].Filter = null; } //----Name filter _paging.Fields["PageName"].Filter = !string.IsNullOrEmpty(txtPageName.Text) ? new CompareFieldFilter { Expression = txtPageName.Text, ParamName = "@PageName" } : null; _paging.Fields["SortOrder"].Filter = !string.IsNullOrEmpty(txtSortOrder.Text) ? new CompareFieldFilter { Expression = txtSortOrder.Text, ParamName = "@SortOrder" } : null; _paging.Fields["Enabled"].Filter = (ddlEnabled.SelectedValue != "any") ? new EqualFieldFilter { ParamName = "@Enabled", Value = ddlEnabled.SelectedValue } : null; pageNumberer.CurrentPageIndex = 1; }
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; //New InSetFieldFilter() //_SelectionFilter.IncludeValues = True } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].Filter = null; } //----UserName filter if (!string.IsNullOrEmpty(txtUserName.Text)) { var userfilter = new CompareFieldFilter { ParamName = "@PriceRange", Expression = txtUserName.Text }; _paging.Fields["PriceRange"].Filter = userfilter; } else { _paging.Fields["PriceRange"].Filter = null; } //----Text filter if (!string.IsNullOrEmpty(txtText.Text)) { var textFilter = new CompareFieldFilter { ParamName = "@PercentDiscount", Expression = txtText.Text }; _paging.Fields["PercentDiscount"].Filter = textFilter; } else { _paging.Fields["PercentDiscount"].Filter = null; } pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; }
protected void btnFilter_Click(object sender, EventArgs e) { //-----Selection filter if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "0") != 0) { if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "2") == 0) { if (_selectionFilter != null) { _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues; } else { _selectionFilter = null; //New InSetFieldFilter() //_SelectionFilter.IncludeValues = True } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].Filter = null; } //----Name filter _paging.Fields["FormatName"].Filter = !string.IsNullOrEmpty(txtName.Text) ? new CompareFieldFilter { Expression = txtName.Text, ParamName = "@Name" } : null; //----Enabled filter if (ddluseInFilter.SelectedIndex != 0) { var efilter = new EqualFieldFilter { ParamName = "@Enable" }; if (ddluseInFilter.SelectedIndex == 1) { efilter.Value = "1"; } if (ddluseInFilter.SelectedIndex == 2) { efilter.Value = "0"; } _paging.Fields["Enable"].Filter = efilter; } else { _paging.Fields["Enable"].Filter = null; } //----sort filter _paging.Fields["SortOrder"].Filter = !string.IsNullOrEmpty(txtSortOrder.Text) ? new CompareFieldFilter { Expression = txtSortOrder.Text, ParamName = "@sort" } : null; _paging.Fields["FormatType"].Filter = ddlFormatType.SelectedValue != "0" ? new EqualFieldFilter { ParamName = "@FormatType", Value = ddlFormatType.SelectedValue } : null; pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; }
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; } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].Filter = null; } //----UserName filter _paging.Fields["StatusName"].Filter = !string.IsNullOrEmpty(txtStatusName.Text) ? new CompareFieldFilter { ParamName = "@StatusName", Expression = txtStatusName.Text } : null; //----CommandID filter _paging.Fields["CommandID"].Filter = ddlCommandIDFilter.SelectedValue != "any" ? new EqualFieldFilter { ParamName = "@CommandID", Value = ddlCommandIDFilter.SelectedValue } : null; _paging.Fields["IsDefault"].Filter = ddlIsDefaultFilter.SelectedValue != "any" ? new EqualFieldFilter { ParamName = "@IsDefault", Value = ddlIsDefaultFilter.SelectedValue } : null; _paging.Fields["IsCanceled"].Filter = ddlCanceledFilter.SelectedValue != "any" ? new EqualFieldFilter { ParamName = "@IsDefault", Value = ddlCanceledFilter.SelectedValue } : null; pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; }
protected void btnFilter_Click(object sender, EventArgs e) { //-----Selection filter if (string.Compare(ddSelect.SelectedIndex.ToString(), "0") != 0) { if (string.Compare(ddSelect.SelectedIndex.ToString(), "2") == 0) { if (_selectionFilter != null) { _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues; } else { _selectionFilter = null; //New InSetFieldFilter() //_SelectionFilter.IncludeValues = True } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].Filter = null; } //----Name filter if (!string.IsNullOrEmpty(txtName.Text)) { var nfilter = new CompareFieldFilter { Expression = txtName.Text, ParamName = "@Name" }; _paging.Fields["CityName"].Filter = nfilter; } else { _paging.Fields["CityName"].Filter = null; } //---RegionSort filter if (!string.IsNullOrEmpty(txtRegSort.Text)) { var nfilter = new CompareFieldFilter { Expression = txtRegSort.Text, ParamName = "@CitySort" }; _paging.Fields["CitySort"].Filter = nfilter; } else { _paging.Fields["CitySort"].Filter = null; } pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; }
protected void btnFilter_Click(object sender, EventArgs e) { //-----Selection filter if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "0") != 0) { if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "2") == 0) { if (_selectionFilter != null) { _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues; } else { _selectionFilter = null; } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].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; } if (!string.IsNullOrEmpty(txtSortOrder.Text)) { var nfilter = new CompareFieldFilter { Expression = txtSortOrder.Text.TryParseInt().ToString(), ParamName = "@Sort" }; _paging.Fields["Sort"].Filter = nfilter; } else { _paging.Fields["Sort"].Filter = null; } pageNumberer.CurrentPageIndex = 1; }
protected void btnFilter_Click(object sender, EventArgs e) { //-----Selection filter if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "0") != 0) { if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "2") == 0) { if (_selectionFilter != null) { _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues; } else { _selectionFilter = null; //New InSetFieldFilter() //_SelectionFilter.IncludeValues = True } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].Filter = null; } //----Name filter _paging.Fields["Name"].Filter = !string.IsNullOrEmpty(txtName.Text) ? new CompareFieldFilter { Expression = txtName.Text, ParamName = "@Name" } : null; _paging.Fields["UrlPath"].Filter = !string.IsNullOrEmpty(txtUrlPath.Text) ? new CompareFieldFilter { Expression = txtName.Text, ParamName = "@UrlPath" } : null; _paging.Fields["SortOrder"].Filter = !string.IsNullOrEmpty(txtSort.Text) ? new EqualFieldFilter { Value = txtSort.Text, ParamName = "@Sort" } : null; pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; }
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; } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].Filter = _selectionFilter; } //----Name filter if (!string.IsNullOrEmpty(txtGroupName.Text)) { var nfilter = new CompareFieldFilter { Expression = txtGroupName.Text, ParamName = "@GroupName" }; _paging.Fields["GroupName"].Filter = nfilter; } else { _paging.Fields["GroupName"].Filter = null; } pageNumberer.CurrentPageIndex = 1; pageNumberer.CurrentPageIndex = 1; }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_CustomerGroup_Header)); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Customers].[CustomerGroup]", ItemsPerPage = 10 }; var f = new Field { Name = "CustomerGroupId as ID", IsDistinct = true, Filter = _selectionFilter }; _paging.AddField(f); f = new Field { Name = "GroupName", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "GroupDiscount" }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowGroupName", "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(); string[] arrids = strIds.Split(' '); var ids = new string[arrids.Length ]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { int t = int.Parse(arrids[idx]); if (t != -1) { ids[idx] = t.ToString(); } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; //_InverseSelection = If(ids(0) = -1, True, False) } } }
protected void Page_Load(object sender, EventArgs e) { if (Request["theme"] == null) { Response.Redirect("Voting.aspx"); } lblHead.Text = VoiceService.GetVotingName(ThemeId); SetMeta(string.Format("{0} - {1} - {2}", SettingsMain.ShopName, lblHead.Text, lblSubHead.Text)); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Voice].[Answer]", ItemsPerPage = 10 }; _paging.AddFieldsRange(new List<Field> { new Field {Name = "AnswerID as ID", IsDistinct = true}, new Field {Name = "Name"}, new Field {Name = "CountVoice"}, new Field {Name = "Sort", Sorting = SortDirection.Ascending}, new Field {Name = "IsVisible"}, new Field {Name = "DateAdded"}, new Field {Name = "DateModify"}, new Field { Name = "FKIDTheme", Filter = new EqualFieldFilter {ParamName = "@Theme", Value = ThemeId.ToString()} } }); grid.ChangeHeaderImageUrl("arrowSort", "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(); 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(); } } }
private void BuildFilter() { if (!string.IsNullOrEmpty(Request["pricefrom"]) || !string.IsNullOrEmpty(Request["priceto"])) { int pricefrom = Request["pricefrom"].TryParseInt(0); int priceto = Request["priceto"].TryParseInt(int.MaxValue); filterPrice.CurValMin = pricefrom; filterPrice.CurValMax = priceto; _paging.Fields["discountPrice"].Filter = new RangeFieldFilter { ParamName = "@priceRange", From = pricefrom*CurrencyService.CurrentCurrency.Value, To = priceto*CurrencyService.CurrentCurrency.Value }; _paging.Fields["Price"].Filter = new NotEqualFieldFilter {ParamName = "@price", Value = "0"}; } else { filterPrice.CurValMin = 0; filterPrice.CurValMax = int.MaxValue; } if (!string.IsNullOrEmpty(Request["brand"])) { int id = 0; var brandIds = (from b in Request["brand"].Split(',') where int.TryParse(b, out id) select id).ToList(); filterBrand.SelectedBrandIDs = brandIds; var isf = new InSetFieldFilter { IncludeValues = true, ParamName = "@brands", Values = brandIds.Select(brandid => brandid.ToString()).ToArray() }; _paging.Fields["BrandID"].Filter = isf; filterBrand.SelectedBrandIDs = brandIds; } else { filterBrand.SelectedBrandIDs = new List<int>(); } }
protected void btnFilter_Click(object sender, EventArgs e) { //-----Selection filter if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "0") != 0) { if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "2") == 0) { if (_selectionFilter != null) { _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues; } else { _selectionFilter = null; } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].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; } //----RegNumber filter if (!string.IsNullOrEmpty(txtRegNumber.Text)) { var nfilter = new CompareFieldFilter { Expression = txtRegNumber.Text, ParamName = "@RegNumber" }; _paging.Fields["RegNumber"].Filter = nfilter; } else { _paging.Fields["RegNumber"].Filter = null; } //----Country filter if (ddlCountryFilter.SelectedIndex != 0) { var nfilter = new CompareFieldFilter { Expression = ddlCountryFilter.SelectedItem.Text, ParamName = "@Country" }; _paging.Fields["CountryName"].Filter = nfilter; } else { _paging.Fields["CountryName"].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; } pageNumberer.CurrentPageIndex = 1; }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Coupons_Header)); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[Coupon]", ItemsPerPage = 10 }; _paging.AddFieldsRange(new List<Field> { new Field { Name = "CouponID as ID", IsDistinct = true }, new Field {Name = "Code"}, new Field {Name = "Type"}, new Field {Name = "Value"}, new Field {Name = "AddingDate", Sorting = SortDirection.Descending}, new Field {Name = "ExpirationDate"}, new Field {Name = "PossibleUses"}, new Field {Name = "ActualUses"}, new Field {Name = "Enabled"}, new Field {Name = "MinimalOrderPrice"}, }); grid.ChangeHeaderImageUrl("arrowAddingDate", "images/arrowdown.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(); 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}", AdvantShop.Configuration.SettingsMain.ShopName, Resource.Admin_MasterPageAdminCatalog_Catalog)); if (string.IsNullOrEmpty(ModuleName)) { Response.Redirect("ExportFeed.aspx?ModuleId=YandexMarket"); return; } if (!string.IsNullOrEmpty(Request["CatId"])) { Int32.TryParse(Request["CatId"], out _catId); } Category cat = CategoryService.GetCategory(_catId); if (cat != null) { lblCategoryName.Text = cat.Name; sn.BuildNavigationAdmin(_catId); } if (!Page.IsPostBack) { var flag = ExportFeedService.CheakCategoryHierical(ModuleName, _catId); pnlCategorySet.Enabled = !flag; chbFull.Checked = ExportFeedService.CheakCategory(ModuleName, _catId); pnlData.Enabled = !chbFull.Checked && !flag; } PageSubheader.Visible = true; ModuleNameLiteral.Text = ModuleName; if (!IsPostBack) { var node2 = new TreeNode { Text = SelectCategory(0, ModuleName, Resource.Admin_m_Category_Root), Value = "0", Selected = true, NavigateUrl = ExportFeedNew + "?moduleid=" + ModuleName }; tree2.Nodes.Add(node2); LoadChildCategories2(tree2.Nodes[0]); _paging = new SqlPaging { TableName = "[Catalog].[Product] left JOIN [Catalog].[Offer] ON [Product].[ProductID] = [Offer].[ProductID] AND [Offer].Main=1 INNER JOIN Catalog.ProductCategories on ProductCategories.ProductId = [Product].[ProductID] and ProductCategories.Main=1", ItemsPerPage = 100 }; var f = new Field { Name = "Product.ProductId as ID", IsDistinct = true }; _paging.AddField(f); f = new Field { Name = "Product.ArtNo" }; _paging.AddField(f); f = new Field { Name = "Name" }; _paging.AddField(f); f = new Field { Name = "(Select count(*) from Settings.ExportFeedSelectedProducts where ModuleName=@ModuleName and ExportFeedSelectedProducts.ProductID=Product.ProductId) as Cheaked" }; _paging.AddField(f); var pf = new EqualFieldFilter { Value = _catId.ToString(), ParamName = "@Parent" }; f = new Field { Name = "CategoryId", Filter = pf }; _paging.AddField(f); f = new Field { Name = "SortOrder", Sorting = SortDirection.Ascending }; _paging.AddField(f); _paging.AddParam(new SqlParam { ParameterName = "@ModuleName", Value = ModuleName }); _paging.ExtensionWhere = "and Offer.Price > 0 and (Offer.Amount > 0 or Product.AllowPreorder=1) and CategoryEnabled=1 and Enabled=1"; grid.ChangeHeaderImageUrl("arrowName", "images/arrowup.gif"); 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(); string[] arrids = strIds.Split(' '); var ids = new string[arrids.Length]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { int t = int.Parse(arrids[idx]); if (t != -1) { ids[idx] = t.ToString(); } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; } } }
protected void btnFilter_Click(object sender, EventArgs e) { if (ddSelect.SelectedIndex != 0) { if (ddSelect.SelectedIndex == 2) { if (_selectionFilter != null) { _selectionFilter.IncludeValues = !_selectionFilter.IncludeValues; } else { _selectionFilter = null; } } _paging.Fields["ID"].Filter = _selectionFilter; } else { _paging.Fields["ID"].Filter = null; } //----Firstname filter if (!string.IsNullOrEmpty(txtSearchFirstName.Text)) { var nfilter = new CompareFieldFilter { Expression = txtSearchFirstName.Text, ParamName = "@firstname" }; _paging.Fields["Firstname"].Filter = nfilter; } else { _paging.Fields["Firstname"].Filter = null; } //----lastname filter if (!string.IsNullOrEmpty(txtSearchLastname.Text)) { var nfilter = new CompareFieldFilter { Expression = txtSearchLastname.Text, ParamName = "@lastname" }; _paging.Fields["Lastname"].Filter = nfilter; } else { _paging.Fields["Lastname"].Filter = null; } //----email filter if (!string.IsNullOrEmpty(txtSearchEmail.Text)) { var nfilter = new CompareFieldFilter { Expression = txtSearchEmail.Text, ParamName = "@email" }; _paging.Fields["Email"].Filter = nfilter; } else { _paging.Fields["Email"].Filter = null; } //----RegDate filter if (!string.IsNullOrEmpty(txtDateFrom.Text) || !string.IsNullOrEmpty(txtDateTo.Text)) { var nfilter = new DateTimeRangeFieldFilter(); try { nfilter.From = DateTime.Parse(txtDateFrom.Text); } catch (Exception) { nfilter.From = DateTime.Parse("01.01.1900"); } try { nfilter.To = DateTime.Parse(txtDateTo.Text); } catch (Exception) { nfilter.To = DateTime.MaxValue; } nfilter.ParamName = "@RegistrationDateTime"; _paging.Fields["RegistrationDateTime"].Filter = nfilter; } else { _paging.Fields["RegistrationDateTime"].Filter = null; } _paging.Fields["CustomerGroupId"].Filter = ddlCustomerGroup.SelectedValue != "0" ? new EqualFieldFilter { ParamName = "@CustomerGroupId", Value = ddlCustomerGroup.SelectedValue } : null; _paging.Fields["PriceType"].Filter = ddlPriceTypes.SelectedValue != "0" ? new EqualFieldFilter { ParamName = "@PriceType", Value = ddlPriceTypes.SelectedValue } : null; pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; }
protected void Page_Load(object sender, EventArgs e) { MsgErr(true); SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_CustomerSearch_SubHeader)); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Customers].[Customer]", ItemsPerPage = 10 }; _paging.AddFieldsRange(new List<Field> { new Field { Name = "CustomerID as ID", IsDistinct = true }, new Field { Name = "Email" }, new Field { Name = "Firstname", Sorting = SortDirection.Ascending }, new Field { Name = "Lastname" }, new Field { Name = "CustomerGroupId" }, new Field { Name = "RegistrationDateTime" }, new Field { Name = "CustomerRole" }, new Field { Name = "PriceType" } }); if (CustomerSession.CurrentCustomer.CustomerRole == Role.Moderator) { _paging.Fields["CustomerRole"].Filter = new EqualFieldFilter { ParamName = "@CustomerRole", Value = ((int)Role.User).ToString() }; } advCustomers.ChangeHeaderImageUrl("arrowFirstname", "images/arrowup.gif"); _paging.ItemsPerPage = 10; pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; ViewState["Paging"] = _paging; if (Request["search"].IsNotEmpty()) { var customer = CustomerService.GetCustomerByEmail(Request["search"]); if (customer != null) { Response.Redirect("ViewCustomer.aspx?customerID=" + customer.Id); return; } if (Request["search"].Contains("@")) { txtSearchEmail.Text = Request["search"]; } else { txtSearchLastname.Text = Request["search"]; } btnFilter_Click(null, null); } } else { _paging = (SqlPaging)(ViewState["Paging"]); _paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue); if (_paging == null) { throw (new Exception("Paging lost")); } var strIds = Request.Form["SelectedIds"]; if (!string.IsNullOrEmpty(strIds)) { strIds = strIds.Trim(); var arrids = strIds.Split(' '); var ids = new string[arrids.Length ]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { var t = arrids[idx]; if (t != "-1") { ids[idx] = t; } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; } } }
protected void Page_Load(object sender, EventArgs e) { Message.Visible = false; MsgErr(true); SetMeta(string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, Resource.Admin_Discount_PriceRange_SubHeader)); if (!IsPostBack) { chkModuleEnabled.Checked = AdvantShop.Configuration.SettingsOrderConfirmation.EnableDiscountModule; } if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Order].[OrderPriceDiscount]", ItemsPerPage = 10 }; var f = new Field { Name = "OrderPriceDiscountID as ID" }; //f.IsDistinct = True _paging.AddField(f); f = new Field { Name = "PriceRange", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "PercentDiscount" }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowPriceRange", "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(); string[] arrids = strIds.Split(' '); var ids = new string[arrids.Length]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { string t = arrids[idx]; if (t != "-1") { ids[idx] = t; } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; } } }
protected void Page_Load(object sender, EventArgs e) { lblError.Text = string.Empty; lblError.Visible = false; SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Properties_ListPropreties)); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Settings].[NewsCategory]" }; _paging.AddFieldsRange(new List<Field> { new Field {Name = "NewsCategoryID as ID", IsDistinct = true}, new Field {Name = "Name"}, new Field {Name = "SortOrder", Sorting = SortDirection.Ascending}, new Field {Name = "UrlPath"}, }); 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(); string[] arrids = strIds.Split(' '); var ids = new string[arrids.Length]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { int t = int.Parse(arrids[idx]); if (t != -1) { ids[idx] = t.ToString(); } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; //_InverseSelection = If(ids(0) = -1, True, False) } } }
protected void Page_Load(object sender, EventArgs e) { btnAdd.OnClientClick = "javascript:open_window('m_ProductVideos.aspx?ProductID=" + ProductID + "',780,600);return false;"; if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[ProductVideo]", ItemsPerPage = 10 }; var f = new Field { Name = "ProductVideoID", IsDistinct = true, Filter = _selectionFilter }; _paging.AddField(f); f = new Field { Name = "ProductID", Filter = new EqualFieldFilter { ParamName = "@productID", Value = ProductID.ToString() } }; _paging.AddField(f); f = new Field { Name = "Name" }; _paging.AddField(f); f = new Field { Name = "VideoSortOrder", Sorting = SortDirection.Ascending }; _paging.AddField(f); grid_video.ChangeHeaderImageUrl("arrowVideoSortOrder", "~/admin/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["SelectedIdsVideo"]; if (!string.IsNullOrEmpty(strIds)) { strIds = strIds.Trim(); string[] arrids = strIds.Split(' '); var ids = new string[arrids.Length ]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { int t = -1; int.TryParse(arrids[idx], out t); if (t != -1) { ids[idx] = t.ToString(); } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; //_InverseSelection = If(ids(0) = -1, True, False) } } }
protected void Page_Load(object sender, EventArgs e) { string strIds = String.Empty; if(!Page.IsPostBack) { if (SelectedProducts != null && SelectedProducts.Count != 0) { prevSelected = SelectedProducts.Select(s => s.ToString()).Aggregate( (prev, next) => prev.ToString() + " " + next.ToString()); strIds = prevSelected; } } else { strIds = Request.Form["SelectedIds"]; } string[] ids; if (!string.IsNullOrEmpty(strIds)) { strIds = strIds.Trim(); var arrids = strIds.Split(' '); ids = new string[arrids.Length ]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { var t = arrids[idx]; if (t != "-1") { ids[idx] = t; } else { _selectionFilter.IncludeValues = false; } } _selectionFilter.Values = ids; } if (!IsPostBack) { // load modalpopup for contact _paging = new SqlPaging { TableName = "[Catalog].[Product]", ItemsPerPage = 10 }; var f = new Field { Name = "ProductID", IsDistinct = true }; _paging.AddField(f); f = new Field { Name = "ArtNo", Sorting = SortDirection.Ascending}; _paging.AddField(f); f = new Field { Name = "Name" }; _paging.AddField(f); agvProducts.ChangeHeaderImageUrl("arrowArtNo", "../images/arrowup.gif"); _paging.ItemsPerPage = 10; pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; ViewState["Paging"] = _paging; } else { _paging = (SqlPaging)(ViewState["Paging"]); if (_paging == null) { throw (new Exception("Paging lost")); } } }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_MasterPageAdminCatalog_Catalog)); Category cat = null; if (!string.IsNullOrEmpty(Request["categoryid"])) { if (Request["categoryid"].ToLower().Equals("WithoutCategory".ToLower())) { ShowMethod = EShowMethod.OnlyWithoutCategories; } else if (Request["categoryid"].ToLower().Equals("InCategories".ToLower())) { ShowMethod = EShowMethod.OnlyInCategories; } else if (Request["categoryid"].ToLower().Equals("AllProducts".ToLower())) { ShowMethod = EShowMethod.AllProducts; } else { ShowMethod = EShowMethod.Normal; int.TryParse(Request["categoryid"], out CategoryId); cat = CategoryService.GetCategory(CategoryId); adminCategoryView.CategoryID = CategoryId; } } else { CategoryId = 0; ShowMethod = EShowMethod.Normal; } if (cat == null) { CategoryId = 0; if (ShowMethod == EShowMethod.Normal) { ShowMethod = EShowMethod.AllProducts; ShowMethod = EShowMethod.Normal; } } else { CategoryId = cat.CategoryId; lblCategoryName.Text = cat.Name; ConfirmButtonExtenderCategory.ConfirmText = string.Format(Resource.Admin_MasterPageAdminCatalog_Confirmation, cat.Name); } hlEditCategory.NavigateUrl = "javascript:open_window(\'m_Category.aspx?CategoryID=" + CategoryId + "&mode=edit\', 750, 640)"; if (!IsPostBack) { var node2 = new TreeNode { Text = Resource.Admin_m_Category_Root, Value = "0", Selected = true }; tree2.Nodes.Add(node2); LoadChildCategories2(tree2.Nodes[0]); _paging = new SqlPaging() { ItemsPerPage = 10, }; switch (ShowMethod) { case EShowMethod.AllProducts: lblCategoryName.Text = Resource.Admin_Catalog_AllProducts; _paging.TableName = "[Catalog].[Product] left JOIN [Catalog].[Offer] ON [Product].[ProductID] = [Offer].[ProductID] and [Offer].[Main] = 1 LEFT JOIN [Catalog].[Photo] ON [Product].[ProductID] = [Photo].[ObjId] and Type='Product' AND [Photo].[Main] = 1 LEFT JOIN [Catalog].[ProductCategories] ON [Catalog].[ProductCategories].[ProductID] = [Product].[ProductID]"; break; case EShowMethod.OnlyInCategories: lblCategoryName.Text = Resource.Admin_Catalog_AllProductsInCategories; _paging.TableName = "[Catalog].[Product] left JOIN [Catalog].[Offer] ON [Product].[ProductID] = [Offer].[ProductID] and [Offer].[Main] = 1 LEFT JOIN [Catalog].[Photo] ON [Product].[ProductID] = [Photo].[ObjId] and Type='Product' AND [Photo].[Main] = 1 inner JOIN [Catalog].[ProductCategories] ON [Catalog].[ProductCategories].[ProductID] = [Product].[ProductID]"; break; case EShowMethod.OnlyWithoutCategories: lblCategoryName.Text = Resource.Admin_Catalog_AllProductsWithoutCategories; _paging.TableName = "[Catalog].[Product] inner join (select ProductId from Catalog.Product where ProductId not in(Select ProductId from Catalog.ProductCategories)) as tmp on tmp.ProductId=[Product].[ProductID] Left JOIN [Catalog].[Offer] ON [Product].[ProductID] = [Offer].[ProductID] LEFT JOIN [Catalog].[Photo] ON [Product].[ProductID] = [Photo].[ObjId] and Type='Product' AND [Photo].[Main] = 1"; break; case EShowMethod.Normal: _paging.TableName = "[Catalog].[Product] left JOIN [Catalog].[Offer] ON [Product].[ProductID] = [Offer].[ProductID] and [Offer].[Main] = 1 LEFT JOIN [Catalog].[Photo] ON [Product].[ProductID] = [Photo].[ObjId] and Type='Product' AND [Photo].[Main] = 1 INNER JOIN Catalog.ProductCategories on ProductCategories.ProductId = [Product].[ProductID]"; break; } _paging.AddFieldsRange(new List<Field>() { new Field {Name = "Product.ProductID as ID", IsDistinct = true}, new Field {Name = "Product.ArtNo", Sorting = ShowMethod!= EShowMethod.Normal ? SortDirection.Ascending : (SortDirection?)null}, new Field {Name = "PhotoName"}, new Field {Name = "(Select Count(ProductID) From Catalog.ProductCategories Where ProductID=Product.ProductID) as ProductCategoriesCount"}, new Field {Name = "BriefDescription"}, new Field {Name = "Name"}, new Field {Name = "Price"}, new Field {Name = "(Select sum (Amount) from catalog.Offer where Offer.ProductID=Product.productID) as Amount"}, new Field {Name = "Enabled"}, new Field { Name = ShowMethod == EShowMethod.Normal ? "ProductCategories.SortOrder" : "-1 as SortOrder", Sorting = SortDirection.Ascending }, new Field {Name = "Offer.ColorID", NotInQuery = true}, new Field {Name = "Offer.SizeID", NotInQuery = true} }); if (ShowMethod == EShowMethod.Normal) { _paging.AddField(new Field { Name = "ProductCategories.CategoryID", NotInQuery = true, Filter = new EqualFieldFilter { Value = CategoryId.ToString(), ParamName = "@CategoryID" } }); grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif"); } else { grid.ChangeHeaderImageUrl("arrowArtNo", "images/arrowup.gif"); } pageNumberer.CurrentPageIndex = 1; pnlProducts.Visible = CategoryId != 0 || ShowMethod != EShowMethod.Normal; productsHeader.Visible = ShowMethod == EShowMethod.Normal; adminCategoryView.Visible = ShowMethod == EShowMethod.Normal; grid.Columns[9].Visible = ShowMethod == EShowMethod.Normal; _paging.CurrentPageIndex = 1; ViewState["Paging"] = _paging; if (Request["search"].IsNotEmpty()) { var product = ProductService.GetProduct(Request["search"]); if (product != null) { Response.Redirect("Product.aspx?productID=" + product.ID); return; } if ( ProductService.GetProductsCount("where name like '%' + @search + '%'", new SqlParameter("@search", Request["search"])) > ProductService.GetProductsCount("where artno like '%' + @search + '%'", new SqlParameter("@search", Request["search"]))) { txtName.Text = Request["search"]; } else { txtArtNo.Text = Request["search"]; } btnFilter_Click(null, null); } if (Request["colorId"].IsNotEmpty()) { var color = ColorService.GetColor(Request["colorId"].TryParseInt()); if (color != null) { lblCategoryName.Text += string.Format(" {0}: {1}", Resource.Admin_Catalog_Color, color.ColorName); _paging.Fields["Offer.ColorID"].Filter = new EqualFieldFilter { ParamName = "@colorId", Value = Request["colorId"] }; } } if (Request["sizeid"].IsNotEmpty()) { var size = SizeService.GetSize(Request["sizeid"].TryParseInt()); if (size != null) { lblCategoryName.Text += string.Format(" {0}: {1}", Resource.Admin_Catalog_Size, size.SizeName); _paging.Fields["Offer.SizeID"].Filter = new EqualFieldFilter { ParamName = "@sizeId", Value = Request["sizeId"] }; } } } 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(' '); var ids = new string[arrids.Length]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; _selectionFilterCategories = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { string t = arrids[idx]; var idParts = t.Split('_'); switch (idParts[0]) { case "Product": if (idParts[1] != "-1") { ids[idx] = idParts[1]; } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } break; case "Category": if (idParts[1] != "-1") { _selectedCategories.Add(idParts[1]); } else { _selectionFilterCategories.IncludeValues = false; _inverseSelection = true; } break; default: _inverseSelection = true; break; } } _selectionFilter.Values = ids.Distinct().Where(item => item != null).ToArray(); _selectionFilterCategories.Values = _selectedCategories.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; } } //----Id filter if (!string.IsNullOrEmpty(txtArtNo.Text)) { var sfilter = new CompareFieldFilter { Expression = txtArtNo.Text, ParamName = "@artno" }; _paging.Fields["Product.ArtNo"].Filter = sfilter; } else { _paging.Fields["Product.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; }
private void BuildFilter() { if (!string.IsNullOrEmpty(Request["pricefrom"]) || !string.IsNullOrEmpty(Request["priceto"])) { int pricefrom = Request["pricefrom"].TryParseInt(0); int priceto = Request["priceto"].TryParseInt(int.MaxValue); filterPrice.CurValMin = pricefrom; filterPrice.CurValMax = priceto; _paging.Fields["Price_ProductID"].Filter = new PriceFieldFilter { ParamName = "@priceRange", From = pricefrom * CurrencyService.CurrentCurrency.Value, To = priceto * CurrencyService.CurrentCurrency.Value, CategoryId = _categoryId, GetSubCategoryes = Indepth }; } else { filterPrice.CurValMin = 0; filterPrice.CurValMax = int.MaxValue; } if (!string.IsNullOrEmpty(Request["prop"])) { var valIDs = new Dictionary<int, List<int>>(); var selectedPropertyIDs = new List<int>(); var filterCollection = Request["prop"].Split('-'); int key = 1; foreach (var val in filterCollection) { var tempListIds = new List<int>(); foreach (int id in val.Split(',').Select(item => item.TryParseInt()).Where(id => id != 0)) { tempListIds.Add(id); selectedPropertyIDs.Add(id); } valIDs.Add(key, tempListIds); key++; } if (valIDs.Count != 0) { var lfilter = new PropertyFieldFilter { ListFilter = valIDs, ParamName = "@prop", CategoryId = Category.CategoryId, GetSubCategoryes = Category.DisplayChildProducts }; _paging.Fields["[Product].[ProductID]"].Filter = lfilter; } filterProperty.SelectedPropertyIDs = selectedPropertyIDs; } else { filterProperty.SelectedPropertyIDs = new List<int>(); } if (!string.IsNullOrEmpty(Request["brand"])) { var brandIds = Request["brand"].Split(',').Select(item => item.TryParseInt()).Where(id => id != 0).ToList(); filterBrand.SelectedBrandIDs = brandIds; var isf = new InSetFieldFilter { IncludeValues = true, ParamName = "@brands", Values = brandIds.Select(brandid => brandid.ToString()).ToArray() }; _paging.Fields["BrandID"].Filter = isf; } else { filterBrand.SelectedBrandIDs = new List<int>(); } if (!string.IsNullOrEmpty(Request["size"])) { var sizeIds = Request["size"].Split(',').Select(item => item.TryParseInt()).Where(id => id != 0).ToList(); filterSize.SelectedSizesIDs = sizeIds; _paging.Fields["Size_ProductID"].Filter = new SizeFieldFilter { CategoryId = _categoryId, ParamName = "@size", ListFilter = sizeIds, GetSubCategoryes = Indepth }; } else { filterSize.SelectedSizesIDs = new List<int>(); } if (!string.IsNullOrEmpty(Request["color"])) { var colorIds = Request["color"].Split(',').Select(item => item.TryParseInt()).Where(id => id != 0).ToList(); filterColor.SelectedColorsIDs = colorIds; _paging.Fields["Color_ProductID"].Filter = new ColorFieldFilter { CategoryId = _categoryId, ParamName = "@color", ListFilter = colorIds, GetSubCategoryes = Indepth }; if (SettingsCatalog.ComplexFilter) { _paging.AddField(new Field { Name = string.Format( "(select Top 1 PhotoName from catalog.Photo inner join catalog.offer on Photo.objid=offer.productid and Type='product'" + " where offer.productid=product.productid and Photo.ColorID in({0}) order by Photo.PhotoSortOrder, Photo.Main)" + " as AdditionalPhoto", colorIds.AggregateString(',')) }); } else { _paging.AddField(new Field { Name = "null as AdditionalPhoto" }); } } else { filterColor.SelectedColorsIDs = new List<int>(); _paging.AddField(new Field { Name = "null as AdditionalPhoto" }); } }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resources.Resource.Admin_Brands_Header)); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[Brand] left join Catalog.Photo on Photo.ObjId = Brand.BrandID and Type = @Type ", ItemsPerPage = 10 }; _paging.AddFieldsRange(new List<Field> { new Field { Name = "BrandID as ID", IsDistinct = true }, new Field {Name = "ProductsCount", SelectExpression="(Select Count(ProductID) from Catalog.Product Where Product.BrandID=Brand.BrandID) as ProductsCount"}, new Field {Name = "PhotoName as BrandLogo"}, new Field {Name = "Enabled"}, new Field {Name = "SortOrder", Sorting = SortDirection.Ascending}, new Field {Name = "BrandName", Sorting=SortDirection.Ascending} }); _paging.AddParam(new SqlParam { Value = PhotoType.Brand.ToString(), ParameterName = "@Type" }); 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(); 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_SizesDictionary_Header)); MsgError(); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[Size]", ItemsPerPage = 20, CurrentPageIndex = 1 }; _paging.AddFieldsRange(new[] { new Field {Name = "SizeID as ID", IsDistinct = true}, new Field {Name = "SizeName"}, new Field {Name = "SortOrder", Sorting = SortDirection.Ascending} }); grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif"); pageNumberer.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(' '); var ids = new string[arrids.Length]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { int t = int.Parse(arrids[idx]); if (t != -1) { ids[idx] = t.ToString(CultureInfo.InvariantCulture); } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; } } }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Properties_ListPropreties)); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[Property]", ItemsPerPage = 20, CurrentPageIndex = 1 }; _paging.AddFieldsRange(new[] { new Field {Name = "PropertyID as ID", IsDistinct = true}, new Field {Name = "Name"}, new Field {Name = "UseInFilter"}, new Field {Name = "Expanded"}, new Field {Name = "SortOrder", Sorting = SortDirection.Ascending}, new Field {Name = "(Select Count(ProductID) from Catalog.ProductPropertyValue Where [PropertyValueID] in ( SELECT [PropertyValueID] FROM [Catalog].[PropertyValue] WHERE [PropertyID] = [Property].PropertyID)) as ProductsCount"}, }); grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif"); pageNumberer.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(); var arrids = strIds.Split(' '); var ids = new string[arrids.Length]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { int t = int.Parse(arrids[idx]); if (t != -1) { ids[idx] = t.ToString(CultureInfo.InvariantCulture); } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; } } }
protected void Page_Load(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request["type"])) { if (!string.IsNullOrEmpty(Request["type"])) { Enum.TryParse(Request["type"], true, out _typeFlag); } } switch (_typeFlag) { case ProductOnMain.TypeFlag.Bestseller: lblHead.Text = Resource.Admin_UserControls_MainPageProduct_Bestseller; break; case ProductOnMain.TypeFlag.New: lblHead.Text = Resource.Admin_UserControls_MainPageProduct_New; break; case ProductOnMain.TypeFlag.Discount: lblHead.Text = Resource.Admin_UserControls_MainPageProduct_Discount; break; } SetMeta(string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, lblHead.Text)); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[Product]", ItemsPerPage = 20 }; var f = new Field { Name = "Product.ProductId as ID" }; _paging.AddField(f); f = new Field { Name = "ArtNo" }; _paging.AddField(f); f = new Field { Name = "Name" }; _paging.AddField(f); if (_typeFlag == ProductOnMain.TypeFlag.Bestseller) { f = new Field { Name = "Bestseller" }; var filterB = new EqualFieldFilter { ParamName = "@Bestseller", Value = "1" }; f.Filter = filterB; _paging.AddField(f); _paging.AddField(new Field { Name = "SortBestseller as Sort", Sorting = SortDirection.Ascending }); } if (_typeFlag == ProductOnMain.TypeFlag.New) { f = new Field { Name = "New" }; var filterN = new EqualFieldFilter { ParamName = "@New", Value = "1" }; f.Filter = filterN; _paging.AddField(f); _paging.AddField(new Field { Name = "SortNew as Sort", Sorting = SortDirection.Ascending }); } if (_typeFlag == ProductOnMain.TypeFlag.Discount) { f = new Field { Name = "Discount" }; var filterN = new NotEqualFieldFilter() { ParamName = "@Discount", Value = "0" }; f.Filter = filterN; _paging.AddField(f); _paging.AddField(new Field { Name = "SortDiscount as Sort", Sorting = SortDirection.Ascending }); btnAddProduct.Visible = false; } grid.ChangeHeaderImageUrl("arrowSort", "images/arrowup.gif"); _paging.ItemsPerPage = 20; 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(); string[] arrids = strIds.Split(' '); var ids = new string[arrids.Length ]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { int t = int.Parse(arrids[idx]); if (t != -1) { ids[idx] = t.ToString(); } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; } } }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_MenuManager_TopMenu)); Int32.TryParse(Request["menuid"], out _menuId); _needReloadTree = SQLDataHelper.GetBoolean(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: 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: 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) { switch (_menuType) { case MenuService.EMenuType.Top: _paging = new SqlPaging { TableName = "[CMS].[MainMenu]", ItemsPerPage = 10 }; break; case MenuService.EMenuType.Bottom: _paging = new SqlPaging { TableName = "[CMS].[BottomMenu]", ItemsPerPage = 10 }; break; } _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 = SQLDataHelper.GetInt(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}", AdvantShop.Configuration.SettingsMain.ShopName, Resources.Resource.Admin_Regions_Header)); if (string.IsNullOrEmpty(Request["countryid"])) { Response.Redirect("Country.aspx"); } Country country = CountryService.GetCountry(SQLDataHelper.GetInt(CountryID)); if (country == null) Response.Redirect("Country.aspx"); else { lblHead.Text = country.Name; hlBack.NavigateUrl = "Country.aspx"; hlBack.Text = Resources.Resource.Admin_Cities_BackToCoutries; } if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Customers].[Region]", ItemsPerPage = 20 }; var f = new Field { Name = "RegionID as ID", IsDistinct = true }; _paging.AddField(f); f = new Field { Name = "RegionName", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "RegionCode" }; _paging.AddField(f); f = new Field { Name = "RegionSort" }; _paging.AddField(f); f = new Field() { Name = "CountryID", Filter = new EqualFieldFilter() { ParamName = "@CounrtyID", Value = CountryID.ToString() } }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowRegionName", "images/arrowup.gif"); 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(' '); var ids = new string[arrids.Length ]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { int t = int.Parse(arrids[idx]); if (t != -1) { ids[idx] = t.ToString(CultureInfo.InvariantCulture); } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; } } }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, Resources.Resource.Admin_Taxes_Header)); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[Tax] JOIN [Customers].[Country] ON [Tax].[CountryID] = [Country].[CountryID]", ItemsPerPage = 10 }; var f = new Field { Name = "TaxID as ID", IsDistinct = true }; _paging.AddField(f); f = new Field { Name = "Name", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "RegNumber" }; _paging.AddField(f); f = new Field { Name = "Enabled" }; _paging.AddField(f); f = new Field { Name = "[Tax].CountryID" }; _paging.AddField(f); f = new Field { Name = "CountryName" }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowName", "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(); string[] arrids = strIds.Split(' '); var ids = new string[arrids.Length]; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { int t = int.Parse(arrids[idx]); if (t != -1) { ids[idx] = t.ToString(CultureInfo.InvariantCulture); } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; } } }