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; } if (!string.IsNullOrEmpty(txtProductName.Text.Trim())) { var nfilter = new CompareFieldFilter { Expression = txtProductName.Text, ParamName = "@ProductName" }; _paging.Fields["ProductName"].Filter = nfilter; } else { _paging.Fields["ProductName"].Filter = null; } if (!string.IsNullOrEmpty(txtUserName.Text.Trim())) { var nfilter = new CompareFieldFilter { Expression = txtUserName.Text, ParamName = "@FLName" }; _paging.Fields["UserName"].Filter = nfilter; } else { _paging.Fields["UserName"].Filter = null; } if (!string.IsNullOrEmpty(txtEmail.Text)) { var nfilter = new CompareFieldFilter { Expression = txtEmail.Text, ParamName = "@Email" }; _paging.Fields["Email"].Filter = nfilter; } else { _paging.Fields["Email"].Filter = null; } if (!string.IsNullOrEmpty(txtPhone.Text)) { var nfilter = new CompareFieldFilter { Expression = txtPhone.Text, ParamName = "@Phone" }; _paging.Fields["Phone"].Filter = nfilter; } else { _paging.Fields["Phone"].Filter = null; } if (ddlIsComplete.SelectedIndex != 0) { var isCompleteFilter = new EqualFieldFilter { ParamName = "@IsComplete" }; if (ddlIsComplete.SelectedIndex == 1) { isCompleteFilter.Value = "1"; } if (ddlIsComplete.SelectedIndex == 2) { isCompleteFilter.Value = "0"; } _paging.Fields["IsComplete"].Filter = isCompleteFilter; } else { _paging.Fields["IsComplete"].Filter = null; } pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; }
protected void Page_Load(object sender, EventArgs e) { Page.Title = 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 = "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 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; }
//public event Action<object, PhotoMessageEventArgs> PhotoMessage; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[Photo]", ItemsPerPage = 10 }; var f = new Field { Name = "PhotoID as ID", IsDistinct = true, Filter = _selectionFilter }; _paging.AddField(f); f = new Field { Name = "ObjId", Filter = new EqualFieldFilter { ParamName = "@ObjId", Value = ProductID.ToString() } }; _paging.AddField(f); f = new Field { Name = "PhotoName" }; _paging.AddField(f); f = new Field { Name = "Description" }; _paging.AddField(f); f = new Field { Name = "PhotoSortOrder", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "Main" }; _paging.AddField(f); f = new Field { Name = "convert(nvarchar, isnull(ColorID, 0)) as ColorID" }; _paging.AddField(f); f = new Field { Name = "Type", NotInQuery = true, Filter = new EqualFieldFilter { ParamName = "@Type", Value = PhotoType.Product.ToString() } }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowPhotoSortOrder", "~/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["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) { Page.Title = 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 [OfferListId]=6 INNER JOIN Catalog.ProductCategories on ProductCategories.ProductId = [Product].[ProductID] and Main=1", ItemsPerPage = 100 }; var f = new Field { Name = "Product.ProductId as ID", IsDistinct = true }; _paging.AddField(f); f = new Field { Name = "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 { ParamName = "@ModuleName", ParamValue = ModuleName }); _paging.ExtensionWhere = "and Offer.Price > 0 and (Offer.Amount > 0 or Product.OrderByRequest=1) and HirecalEnabled=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 = 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(' '); 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_ColorsDictionary_Header)); MsgError(); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[Color] left join Catalog.Photo on Photo.ObjId=Color.ColorID and type='color'", ItemsPerPage = 20, CurrentPageIndex = 1 }; _paging.AddFieldsRange(new[] { new Field { Name = "Color.ColorID as ID", IsDistinct = true }, new Field { Name = "ColorName" }, new Field { Name = "ColorCode" }, new Field { Name = "PhotoName" }, 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 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; } //----Id filter if (!string.IsNullOrEmpty(txtId.Text)) { var nfilter = new CompareFieldFilter { Expression = txtId.Text, ParamName = "@id" }; _paging.Fields["ID"].Filter = nfilter; } else { _paging.Fields["ID"].Filter = null; } //---RedirectFrom filter if (!string.IsNullOrEmpty(txtRedirectFrom.Text)) { var nfilter = new CompareFieldFilter { Expression = txtRedirectFrom.Text, ParamName = "@RedirectFrom" }; _paging.Fields["RedirectFrom"].Filter = nfilter; } else { _paging.Fields["RedirectFrom"].Filter = null; } //---RedirectTo filter if (!string.IsNullOrEmpty(txtRedirectTo.Text)) { var nfilter = new CompareFieldFilter { Expression = txtRedirectTo.Text, ParamName = "@RedirectTo" }; _paging.Fields["RedirectTo"].Filter = nfilter; } else { _paging.Fields["RedirectTo"].Filter = null; } pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; }
protected void Page_Load(object sender, EventArgs e) { Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_MailFormat_Header); if (!IsPostBack) { _paging = new SqlPaging { TableName = "Settings.MailFormat", ItemsPerPage = 10 }; var f = new Field { Name = "MailFormatID as ID", IsDistinct = true }; _paging.AddField(f); f = new Field { Name = "FormatName" }; _paging.AddField(f); f = new Field { Name = "FormatType" }; _paging.AddField(f); f = new Field { Name = "SortOrder", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "Enable" }; _paging.AddField(f); f = new Field { Name = "AddDate" }; _paging.AddField(f); f = new Field { Name = "ModifyDate" }; _paging.AddField(f); _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(); 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 Page_Load(object sender, EventArgs e) { lblError.Text = string.Empty; lblError.Visible = false; Page.Title = 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 = 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(' '); 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) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_CertificateAdmin_Header)); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Order].[Certificate] INNER JOIN [Order].[Order] ON [Order].[OrderID] = [Certificate].[OrderID] INNER JOIN [Order].[OrderCurrency] ON [OrderCurrency].[OrderID] = [Certificate].[OrderID]", ItemsPerPage = 10 }; _paging.AddFieldsRange(new List <Field> { new Field { Name = "CertificateID as ID", IsDistinct = true }, new Field { Name = "[Certificate].CertificateCode as CertificateCode" }, new Field { Name = "[Certificate].ApplyOrderNumber as ApplyOrderNumber" }, new Field { Name = "[Certificate].OrderId as OrderId" }, new Field { Name = "[Certificate].Sum as Sum" }, new Field { Name = "[Certificate].Used as Used" }, new Field { Name = "[Certificate].Enable as Enable" }, new Field { Name = "[Certificate].CreationDate as CreationDate", Sorting = SortDirection.Descending }, //OrderCurrency new Field { Name = "[OrderCurrency].CurrencyValue as CurrencyValue" }, new Field { Name = "[OrderCurrency].CurrencyCode as CurrencyCode" }, //Order new Field { Name = "[Order].PaymentDate as PaymentDate" }, //new Field {Name = "[Order].PaymentDate is null as Paid"} }); grid.ChangeHeaderImageUrl("arrowCreationDate", "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 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 Page_Load(object sender, EventArgs e) { if (string.IsNullOrEmpty(Request["countryid"])) { Response.Redirect("Country.aspx"); } var country = CountryService.GetCountry(CountryId); if (country == null) { Response.Redirect("Country.aspx"); } else { lblHead.Text = country.Name; hlBack.NavigateUrl = "Country.aspx"; hlAllCities.NavigateUrl = "Cities.aspx?countryid=" + country.CountryId; } if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Customers].[Region]", ItemsPerPage = 20 }; _paging.AddFieldsRange( new List <Field> { new Field { Name = "RegionID as ID", IsDistinct = true }, new Field { Name = "RegionName", Sorting = SortDirection.Ascending }, new Field { Name = "RegionCode" }, new Field { Name = "RegionSort" }, new Field { Name = "CountryID", Filter = new EqualFieldFilter() { ParamName = "@CounrtyID", Value = CountryId.ToString() } } }); 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; } } SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resources.Resource.Admin_Regions_Header)); }
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["RegionName"].Filter = nfilter; } else { _paging.Fields["RegionName"].Filter = null; } //--RegionCode filter if (!string.IsNullOrEmpty(txtRegNumber.Text)) { var nfilter = new CompareFieldFilter { Expression = txtRegNumber.Text, ParamName = "@RegionCode" }; _paging.Fields["RegionCode"].Filter = nfilter; } else { _paging.Fields["RegionCode"].Filter = null; } //---RegionSort filter if (!string.IsNullOrEmpty(txtRegSort.Text)) { var nfilter = new CompareFieldFilter { Expression = txtRegSort.Text, ParamName = "@RegionSort" }; _paging.Fields["RegionSort"].Filter = nfilter; } else { _paging.Fields["RegionSort"].Filter = null; } pageNumberer.CurrentPageIndex = 1; }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_OrderByRequest_Header)); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Order].[OrderByRequest]", ItemsPerPage = 10 }; var f = new Field { Name = "OrderByRequestID as ID", IsDistinct = true, Filter = _selectionFilter }; _paging.AddField(f); f = new Field { Name = "ProductId" }; _paging.AddField(f); f = new Field { Name = "ProductName" }; _paging.AddField(f); f = new Field { Name = "UserName" }; _paging.AddField(f); f = new Field { Name = "Email" }; _paging.AddField(f); f = new Field { Name = "Phone" }; _paging.AddField(f); f = new Field { Name = "IsComplete" }; _paging.AddField(f); f = new Field { Name = "RequestDate", Sorting = SortDirection.Descending }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowRequestDate", "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(' '); var ids = new string[arrids.Length]; int t; _selectionFilter = new InSetFieldFilter { IncludeValues = true }; for (int idx = 0; idx <= ids.Length - 1; idx++) { 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) { var 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 = "[Customers].[Customer]", ItemsPerPage = 10 }; var f = new Field { Name = "CustomerID", IsDistinct = true }; _paging.AddField(f); f = new Field { Name = "Email" }; _paging.AddField(f); f = new Field { Name = "Firstname", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "Lastname" }; _paging.AddField(f); agvCustomers.ChangeHeaderImageUrl("arrowFirstname", UrlService.GetAdminAbsoluteLink("images/arrowup.gif")); pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; ViewState["Paging"] = _paging; ViewState["Show"] = false; } else { _paging = (SqlPaging)(ViewState["Paging"]); if (_paging == null) { throw (new Exception("Paging lost")); } if (!string.IsNullOrEmpty(hfSelectedCustomer.Value)) { SelectedCustomers = new List <Guid> { new Guid(hfSelectedCustomer.Value) }; } } }
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) { Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_CertificateAdmin_Header); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[Certificate]", ItemsPerPage = 10 }; _paging.AddFieldsRange(new List <Field> { new Field { Name = "CertificateID as ID", IsDistinct = true }, new Field { Name = "CertificateCode" }, new Field { Name = "OrderNumber" }, new Field { Name = "Type" }, new Field { Name = "Sum" }, new Field { Name = "Used" }, new Field { Name = "Paid" }, new Field { Name = "Enable" }, new Field { Name = "CurrencyValue" }, new Field { Name = "CurrencyCode" }, new Field { Name = "CreationDate", Sorting = SortDirection.Descending }, }); grid.ChangeHeaderImageUrl("arrowCreationDate", "images/arrowdown.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 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(txtUrlFilter.Text)) { var nfilter = new CompareFieldFilter { Expression = txtUrlFilter.Text, ParamName = "@URL" }; _paging.Fields["URL"].Filter = nfilter; } else { _paging.Fields["URL"].Filter = null; } //----CurrencyValue filter if (!string.IsNullOrEmpty(txtSortOrder.Text)) { var nfilter = new CompareFieldFilter { Expression = txtSortOrder.Text, ParamName = "@SortOrder" }; _paging.Fields["SortOrder"].Filter = nfilter; } else { _paging.Fields["SortOrder"].Filter = null; } 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; _paging.CurrentPageIndex = 1; }
protected void Page_Load(object sender, EventArgs e) { Message.Visible = false; Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_OrderStatuses_OrderStatuses); MsgErr(true); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Order].[OrderStatus]" }; _paging.AddFieldsRange( new Field("OrderStatusID as ID"), new Field("StatusName") { Sorting = SortDirection.Ascending }, new Field("IsDefault"), new Field("Canceled"), new Field("CommandID")); grid.ChangeHeaderImageUrl("arrowStatusName", "images/arrowup.gif"); //pageNumberer.CurrentPageIndex = 1; ViewState["Paging"] = _paging; if (Request["productid"] != null) { _paging.Fields["ProductID"].Filter = new CompareFieldFilter { ParamName = "@ProductID", Expression = Request["productid"] }; } } 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)) { List <string> arrids = strIds.Trim().Split(' ').ToList(); if (arrids.Contains("-1")) { _inverseSelection = true; arrids.Remove("-1"); } int t; _selectionFilter = new InSetFieldFilter { IncludeValues = !_inverseSelection, Values = arrids.Where(id => int.TryParse(id, out t)).ToArray() }; } } }
protected void Page_Load(object sender, EventArgs e) { Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Carousels_Header); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[CMS].[Carousel] left join Catalog.Photo on Photo.ObjId=Carousel.CarouselID and Type=@Type", ItemsPerPage = 10 }; var f = new Field { Name = "CarouselID as ID", IsDistinct = true, Filter = _selectionFilter }; _paging.AddField(f); f = new Field { Name = "URL" }; _paging.AddField(f); f = new Field { Name = "SortOrder", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "Enabled" }; _paging.AddField(f); f = new Field { Name = "PhotoName" }; _paging.AddField(f); _paging.AddParam(new SqlParam { ParamName = "@Type", ParamValue = PhotoType.Carousel.ToString() }); grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif"); _paging.ItemsPerPage = 10; pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; ViewState["Paging"] = _paging; txtSortedCarousel.Text = CarouselService.GetMaxSortOrder().ToString(CultureInfo.InvariantCulture); } 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(' '); 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) { lblMes.Text = string.Empty; SetMeta(string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, Resources.Resource.Admin_301Redirects_Header)); if (!IsPostBack) { chbEnabled301Redirect.Checked = AdvantShop.Configuration.SettingsSEO.Enabled301Redirects; _paging = new SqlPaging { TableName = "[Settings].[Redirect]", ItemsPerPage = 20 }; var f = new Field { Name = "ID", IsDistinct = false, Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "RedirectFrom" }; _paging.AddField(f); f = new Field { Name = "RedirectTo" }; _paging.AddField(f); f = new Field { Name = "ProductArtNo" }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowID", "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; //_InverseSelection = If(ids(0) = -1, True, False) } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[ShoppingCart] as sc " + "Left Join [Customers].[Customer] On [Customer].[CustomerID] = sc.[CustomerId]", ExtensionWhere = "and [Customer].[CustomerID] is null", ItemsPerPage = 30 }; _paging.AddFieldsRange(new List <Field> { new Field { Name = "sc.[CustomerId]", IsDistinct = true }, new Field { Name = "ShoppingCartType" }, new Field { Name = "(Select Top(1) OrderConfirmationData From [Order].[OrderConfirmation] " + "Where [OrderConfirmation].[CustomerId] = sc.[CustomerId]) as OrderConfirmationData" }, new Field { Name = "(Select Top(1) UpdatedOn From [Catalog].[ShoppingCart] " + "Where [ShoppingCart].[CustomerId] = sc.[CustomerId] and ShoppingCartType = @CartType Order By UpdatedOn Desc) as LastUpdate", Sorting = SortDirection.Descending }, new Field { Name = "(Select SUM(Price * [ShoppingCart].[Amount]) " + "From [Catalog].[ShoppingCart] " + "Inner Join [Catalog].[Offer] On [Offer].[OfferID] = [ShoppingCart].[OfferId] " + "Where [ShoppingCart].[CustomerID] = sc.CustomerId and ShoppingCartType = @CartType) As Sum" }, new Field { Name = "(Select Count(*) From [Module].[AbandonedCartLetter] Where AbandonedCartLetter.CustomerId = sc.CustomerId) as SendingCount" }, new Field { Name = "(Select Top(1)SendingDate From [Module].[AbandonedCartLetter] Where AbandonedCartLetter.CustomerId = sc.CustomerId Order By SendingDate Desc) as SendingDate" }, }); _paging.Fields["ShoppingCartType"].Filter = new EqualFieldFilter() { ParamName = "@CartType", Value = ((int)ShoppingCartType.ShoppingCart).ToString() }; pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; ViewState["Paging"] = _paging; } else { _paging = (SqlPaging)(ViewState["Paging"]); 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(); } } if (!IsPostBack) { ddlTemplate.Items.Clear(); ddlTemplate.Items.Add(new ListItem("не выбран", "-1")); foreach (var template in AbandonedCartsService.GetTemplates()) { ddlTemplate.Items.Add(new ListItem(template.Name, template.Id.ToString())); } } }
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; } if (!string.IsNullOrEmpty(txtArtNo.Text)) { var nfilter = new CompareFieldFilter { Expression = txtArtNo.Text, ParamName = "@ArtNo" }; _paging.Fields["ArtNo"].Filter = nfilter; } else { _paging.Fields["Name"].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; } //---Sort filter if (!string.IsNullOrEmpty(txtSort.Text)) { var nfilter = new CompareFieldFilter { Expression = txtSort.Text, ParamName = "@SortOrder" }; _paging.Fields["SortOrder"].Filter = nfilter; } else { _paging.Fields["SortOrder"].Filter = null; } pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; }
protected void Page_Load(object sender, EventArgs e) { Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Voting_Voting); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Voice].[VoiceTheme]", ItemsPerPage = 10 }; _paging.AddFieldsRange(new List <Field> { new Field { Name = "VoiceThemeID as ID", IsDistinct = true }, new Field { Name = "PsyID" }, new Field { Name = "Name", Sorting = SortDirection.Ascending }, new Field { Name = "IsDefault" }, new Field { Name = "IsHaveNullVoice" }, new Field { Name = "IsClose" }, new Field { Name = "DateAdded" }, new Field { Name = "DateModify" }, new Field { Name = "(SELECT COUNT(*) FROM [Voice].[Answer] WHERE [FKIDTheme] = VoiceThemeID) as AnswerCount" } }); 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 = 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(' '); _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_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 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; } //----Email filter _paging.Fields["Email"].Filter = !string.IsNullOrEmpty(txtEmail.Text) ? new CompareFieldFilter { ParamName = "@Email", Expression = txtEmail.Text } : null; //-- productName _paging.Fields["Name"].Filter = !string.IsNullOrEmpty(txtName.Text) ? new CompareFieldFilter { ParamName = "@Name", Expression = txtName.Text } : null; //----Text filter _paging.Fields["[Text]"].Filter = !string.IsNullOrEmpty(txtText.Text) ? new CompareFieldFilter { ParamName = "@Text", Expression = txtText.Text } : null; //----Checked filter _paging.Fields["Checked"].Filter = ddlChecked.SelectedValue != "-1" ? new EqualFieldFilter { ParamName = "@Checked", Value = ddlChecked.SelectedValue } : null; //---AddDate filter var dfilter = new DateTimeRangeFieldFilter { ParamName = "@dateRewiews" }; if (!string.IsNullOrEmpty(txtDateFrom.Text)) { DateTime?d = default(DateTime?); try { d = DateTime.Parse(txtDateFrom.Text); } catch (Exception ex) { //Debug.LogError(ex, sender, e); Debug.LogError(ex); } if (d.HasValue) { var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 0, 0, 0, 0); dfilter.From = dt; } } if (!string.IsNullOrEmpty(txtDateTo.Text)) { DateTime?d = default(DateTime?); try { d = DateTime.Parse(txtDateTo.Text); } catch (Exception ex) { //Debug.LogError(ex, sender, e); Debug.LogError(ex); } if (d.HasValue) { var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 23, 59, 59, 99); dfilter.To = dt; } } if (dfilter.From.HasValue | dfilter.To.HasValue) { _paging.Fields["AddDate"].Filter = dfilter; } else { _paging.Fields["AddDate"].Filter = null; } }
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_Reviews_Reviews)); Message.Visible = false; MsgErr(true); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[CMS].[Review]", ItemsPerPage = 10 }; _paging.AddFieldsRange( new Field { Name = "ReviewId as ID", IsDistinct = true }, new Field { Name = "(Select Product.Name From Catalog.Product Where Product.ProductID = EntityId) as ProductName" }, new Field { Name = "(Select Top 1 PhotoName From Catalog.Photo Where ObjId = EntityId and Type = 'Product' Order by [Main] DESC) as ProductPhoto" }, new Field { Name = "Name" }, new Field { Name = "Email" }, new Field { Name = "AddDate", Sorting = SortDirection.Descending }, new Field { Name = "Checked" }, new Field { Name = "[Text]" }); grid.ChangeHeaderImageUrl("arrowAddDate", "images/arrowdown.gif"); _paging.ItemsPerPage = 10; pageNumberer.CurrentPageIndex = 1; _paging.CurrentPageIndex = 1; ViewState["Paging"] = _paging; if (Request["ReviewId"] != null) { _paging.Fields["ReviewId"].Filter = new CompareFieldFilter { ParamName = "@ReviewId", Expression = Request["ReviewId"] }; } } 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)) { List <string> arrids = strIds.Trim().Split(' ').ToList(); _selectionFilter = new InSetFieldFilter(); if (arrids.Contains("-1")) { _selectionFilter.IncludeValues = false; _inverseSelection = true; arrids.Remove("-1"); } else { _selectionFilter.IncludeValues = true; } _selectionFilter.Values = arrids.ToArray(); } } }
protected void Page_Load(object sender, EventArgs e) { Page.Title = 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 = 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(' '); 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) { Page.Title = string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, Resources.Resource.Admin_Subscription_Header); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Customers].[Customer]", ItemsPerPage = 10 }; var f = new Field { Name = "CustomerID as ID", IsDistinct = true, Filter = _selectionFilter }; _paging.AddField(f); //f = new Field { Name = "Login", Sorting = SortDirection.Ascending }; //_paging.AddField(f); f = new Field { Name = "FirstName" }; _paging.AddField(f); f = new Field { Name = "LastName" }; _paging.AddField(f); f = new Field { Name = "Subscribed4News" }; _paging.AddField(f); f = new Field { Name = "Email", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "RegistrationDateTime" }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowEmail", "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(); 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 != "") { ids[idx] = t; } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; } } }