protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // load modalpopup for contact _paging = new SqlPaging { TableName = "[Catalog].[Category]", ItemsPerPage = 10 }; var f = new Field { Name = "CategoryID", IsDistinct = true }; _paging.AddField(f); f = new Field { Name = "Name", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "Products_Count" }; _paging.AddField(f); agvCategory.ChangeHeaderImageUrl("arrowName", "../images/arrowup.gif"); _paging.ItemsPerPage = 10; 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")); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[Brand]", ItemsPerPage = 10 }; var f = new Field { Name = "BrandID", IsDistinct = true }; _paging.AddField(f); f = new Field { Name = "BrandName", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "(Select Count(ProductID) from Catalog.Product Where Product.BrandID=Brand.BrandID) as ProductsCount" }; _paging.AddField(f); agvBrand.ChangeHeaderImageUrl("arrowBrandName", "../images/arrowup.gif"); _paging.ItemsPerPage = 10; 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")); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // load modalpopup for contact _paging = new SqlPaging { TableName = "[Settings].[News]", ItemsPerPage = 10 }; var f = new Field { Name = "NewsID", IsDistinct = true }; _paging.AddField(f); f = new Field { Name = "Title" }; _paging.AddField(f); f = new Field { Name = "AddingDate", Sorting = SortDirection.Descending }; _paging.AddField(f); agvNews.ChangeHeaderImageUrl("arrowAddingDate", "../images/arrowdown.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 LoadOrders(int orderStatusId = 0, int page = 1) { lvOrderStatuses.DataBind(); _paging = new SqlPaging { TableName = @"[Order].[Order] INNER JOIN [Order].[OrderCustomer] ON [Order].[OrderID] = [OrderCustomer].[OrderID] INNER JOIN [Order].[OrderCurrency] ON [Order].[OrderID] = [OrderCurrency].[OrderID] INNER JOIN [Order].[OrderStatus] ON [Order].[OrderStatusID] = [OrderStatus].[OrderStatusID]" }; var f = new Field { Name = "[Order].[OrderID]" }; _paging.AddField(f); f = new Field { Name = "LastName + ' ' + FirstName as CustomerName" }; _paging.AddField(f); f = new Field { Name = "[Order].[OrderStatusID]" }; if (orderStatusId != 0) { f.Filter = new EqualFieldFilter { ParamName = "@OrderStatusID", Value = orderStatusId.ToString() }; } _paging.AddField(f); f = new Field { Name = "[Order].[OrderDate]", Sorting = SortDirection.Descending }; _paging.AddField(f); f = new Field { Name = "[Order].[Sum]" }; _paging.AddField(f); f = new Field { Name = "[Order].[PaymentDate]" }; _paging.AddField(f); f = new Field { Name = "[OrderCurrency].[CurrencyCode]" }; _paging.AddField(f); f = new Field { Name = "[OrderCurrency].[CurrencyValue]" }; _paging.AddField(f); f = new Field { Name = "[OrderStatus].[Color]" }; _paging.AddField(f); _paging.ItemsPerPage = 10; _paging.CurrentPageIndex = page; pageNumberer.PageCount = _paging.PageCount; pageNumberer.CurrentPageIndex = _paging.CurrentPageIndex; ViewState["Paging"] = _paging; }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Currencies_Header)); if (!IsPostBack) { chkAutoUpdateEnabled.Checked = SettingsMain.EnableAutoUpdateCurrencies; _paging = new SqlPaging { TableName = "[Catalog].[Currency]", ItemsPerPage = 10 }; var f = new Field { Name = "CurrencyID as ID", IsDistinct = true, Filter = _selectionFilter }; _paging.AddField(f); f = new Field { Name = "Name", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "Code" }; _paging.AddField(f); f = new Field { Name = "CurrencyValue" }; _paging.AddField(f); f = new Field { Name = "CurrencyISO3" }; _paging.AddField(f); f = new Field { Name = "CurrencyNumIso3" }; _paging.AddField(f); f = new Field { Name = "IsCodeBefore" }; _paging.AddField(f); f = new Field { Name = "PriceFormat" }; _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(); } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; //_InverseSelection = If(ids(0) = -1, True, False) } } }
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; } } }
//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) { if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[Brand]", ItemsPerPage = 10 }; var f = new Field { Name = "BrandID", IsDistinct = true }; _paging.AddField(f); f = new Field { Name = "BrandName", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "(Select Count(ProductID) from Catalog.Product Where Product.BrandID=Brand.BrandID) as ProductsCount" }; _paging.AddField(f); agvBrand.ChangeHeaderImageUrl("arrowBrandName", "../images/arrowup.gif"); _paging.ItemsPerPage = 10; 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")); } } }
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; } } }
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; hlDeleteCategory.Attributes["data-confirm"] = 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] and [Offer].[Main] = 1 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 = "[Settings].[ArtNoToString](Product.ProductID) as ArtNo", Sorting = ShowMethod != EShowMethod.Normal ? SortDirection.Ascending : (SortDirection?)null }, new Field { Name = "Product.ArtNo as ProductArtNo" }, 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 = "(Select count (offerid) from catalog.Offer where Offer.ProductID=Product.productID) as OffersCount" }, 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"], true); 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 }; 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; default: _inverseSelection = true; break; } } _selectionFilter.Values = ids.Distinct().Where(item => item != null).ToArray(); } } }
protected void Page_Load(object sender, EventArgs e) { SetMeta(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 { ParameterName = "@Type", Value = 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 = 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) { 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) { SetMeta(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); f = new Field { Name = "Description" }; _paging.AddField(f); _paging.AddParam(new SqlParam { ParameterName = "@Type", Value = 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 = 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) { bool categoryIdIsNum = false; int categoryId = -1; if (!string.IsNullOrEmpty(Request["newscategoryid"]) && Int32.TryParse(Request["newscategoryid"], out categoryId)) { categoryIdIsNum = categoryId != -1; } _paging = new SqlPaging { TableName = "Settings.News left join Catalog.Photo on Photo.objId=News.NewsID and Type=@Type", ItemsPerPage = SettingsNews.NewsPerPage }; _paging.AddField(new Field { Name = "NewsID" }); _paging.AddField(new Field { Name = "AddingDate", Sorting = SortDirection.Descending }); _paging.AddField(new Field { Name = "Title" }); _paging.AddField(new Field { Name = "PhotoName as Picture" }); _paging.AddField(new Field { Name = "TextToPublication" }); _paging.AddField(new Field { Name = "TextToEmail" }); _paging.AddField(new Field { Name = "TextAnnotation" }); _paging.AddField(new Field { Name = "UrlPath" }); _paging.AddParam(new SqlParam { ParameterName = "@Type", Value = PhotoType.News.ToString() }); if (categoryIdIsNum) { var f = new Field { Name = "NewsCategoryID", NotInQuery = true }; var filter = new EqualFieldFilter { ParamName = "@NewsCategoryID", Value = categoryId.ToString(CultureInfo.InvariantCulture) }; f.Filter = filter; _paging.AddField(f); } var category = NewsService.GetNewsCategoryById(categoryId); if (category != null) { ucBreadCrumbs.Items = new List <BreadCrumbs> { new BreadCrumbs { Name = Resources.Resource.Client_News_News, Url = UrlService.GetAbsoluteLink("news") }, new BreadCrumbs { Name = category.Name, Url = UrlService.GetLink(ParamType.NewsCategory, category.UrlPath, category.NewsCategoryID) } }; } else { ucBreadCrumbs.Visible = false; } MetaInfo meta = new MetaInfo { Type = MetaType.News, Title = SettingsNews.NewsMetaTitle, MetaKeywords = SettingsNews.NewsMetaKeywords, MetaDescription = SettingsNews.NewsMetaDescription, H1 = SettingsNews.NewsMetaH1 }; if (category != null && category.Meta != null) { meta = category.Meta; } meta = SetMeta(meta, category != null ? category.Name: string.Empty, page: paging.CurrentPage); header.Text = category != null ? meta.H1 : Resource.Client_News_News; if (GoogleTagManager.Enabled) { var tagManager = ((AdvantShopMasterPage)Master).TagManager; tagManager.PageType = GoogleTagManager.ePageType.info; } }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_m_CategorySortOrder_Title)); divSave.Visible = false; grid.ResetToDefaultValueOnRowEditCancel = false; if (!IsPostBack) { var root = new TreeNode { Text = Resource.Admin_m_CategorySortOrder_Root, Value = @"0", Selected = true }; tree.Nodes.Add(root); LoadChildCategories(tree.Nodes[0]); } if (!IsPostBack) { _paging = new SqlPaging { TableName = "Catalog.Category" }; var f = new Field { Name = "CategoryID", IsDistinct = true }; var ifilter = new NotEqualFieldFilter { Value = "0", ParamName = "@id" }; f.Filter = ifilter; _paging.AddField(f); f = new Field { Name = "Name" }; _paging.AddField(f); f = new Field { Name = "SortOrder", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "ParentCategory" }; var pfilter = new EqualFieldFilter { Value = hfParent.Value, ParamName = "@CategoryID" }; f.Filter = pfilter; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif"); _paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue); 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")); } } }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", 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 = "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 = 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++) { var t = arrids[idx]; if (t != "") { ids[idx] = t; } 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_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) { 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; } } }
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) { 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) { 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) { 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) } } }
//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 = "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 = 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) { 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) { 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}", 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 Page_Load(object sender, EventArgs e) { MsgErr(true); Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_CustomerSearch_SubHeader); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Customers].[Customer]", ItemsPerPage = 10 }; var f = new Field { Name = "CustomerID as ID", 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); f = new Field { Name = "CustomerGroupId" }; _paging.AddField(f); //Changed By Evgeni f = new Field { Name = "RegistrationDateTime", Sorting = SortDirection.Descending }; _paging.AddField(f); f = new Field { Name = "CustomerRole" }; _paging.AddField(f); if (CustomerSession.CurrentCustomer.CustomerRole == Role.Moderator) { _paging.Fields["CustomerRole"].Filter = new EqualFieldFilter { ParamName = "@CustomerRole", Value = ((int)Role.User).ToString() }; } //Changed by Evgeni advCustomers.ChangeHeaderImageUrl("arrowRegistrationDateTime", "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")); } 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) { 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) { if (!IsPostBack) { ViewState["statusFilters"] = OrderService.GetOrderStatuses(false).Keys.ToList <string>(); var paging = new SqlPaging { TableName = "[Order].[Order] left join [Order].[OrderCustomer] on [Order].[OrderID] = [OrderCustomer].[OrderID] inner join [Order].[OrderCurrency] on [Order].[OrderID] = [OrderCurrency].[OrderID]" }; var f = new Field { Name = "[Order].[OrderID]" }; paging.AddField(f); f = new Field { Name = "LastName + ' ' + FirstName as CustomerName" }; paging.AddField(f); f = new Field { Name = "OrderStatusID", Sorting = SortDirection.Ascending }; paging.AddField(f); f = new Field { Name = "OrderDate", Sorting = SortDirection.Descending }; paging.AddField(f); f = new Field { Name = "Sum" }; paging.AddField(f); f = new Field { Name = "TaxCost" }; paging.AddField(f); f = new Field { Name = "ShippingCost" }; paging.AddField(f); f = new Field { Name = "OrderDiscount" }; paging.AddField(f); f = new Field { Name = "CurrencyCode" }; paging.AddField(f); f = new Field { Name = "CurrencyValue" }; paging.AddField(f); paging.ItemsPerPage = RowsPerPage; paging.CurrentPageIndex = 1; lbPagePrev.Enabled = false; var pageCount = paging.PageCount; lbPageNext.Enabled = paging.CurrentPageIndex != pageCount; for (int i = 1; i <= pageCount; i++) { ddlPage.Items.Add(new ListItem(i.ToString(), i.ToString())); } Paging = paging; } else { CalendarExtender1.SelectedDate = null; CalendarExtender2.SelectedDate = null; } }
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); //_typeFlag = (ProductOnMain.TypeFlag)Enum.Parse(typeof(ProductOnMain.TypeFlag), Request["type"], true); } } switch (_typeFlag) { case ProductOnMain.TypeFlag.Bestseller: lblHead.Text = Resources.Resource.Admin_UserControls_MainPageProduct_Bestseller; break; case ProductOnMain.TypeFlag.New: lblHead.Text = Resources.Resource.Admin_UserControls_MainPageProduct_New; break; case ProductOnMain.TypeFlag.Discount: lblHead.Text = Resources.Resource.Admin_UserControls_MainPageProduct_Discount; break; } MainPageProductNew.LoadData(); MainPageProductOnSale.LoadData(); MainPageProductBestseller.LoadData(); Page.Title = string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, "None"); 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 = 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 btnDownload_Click(object sender, EventArgs e) { if (CommonStatistic.IsRun) { lError.Visible = true; lError.Text = Resource.Admin_Restrict_Action_In_demo; return; } var paging = new SqlPaging { TableName = "[Order].[Order]" }; paging.AddField(new Field { Name = "*" }); if (chkStatus.Checked) { paging.AddField(new Field { Name = "OrderStatusID", NotInQuery = true, Filter = new EqualFieldFilter { ParamName = "@OrderStatusID", Value = ddlStatus.SelectedValue } }); } if (chkDate.Checked) { var filter = new DateTimeRangeFieldFilter { ParamName = "@RDate" }; var dateFrom = txtDateFrom.Text.TryParseDateTime(); filter.From = dateFrom != DateTime.MinValue ? dateFrom : new DateTime(2000, 1, 1); var dateTo = txtDateTo.Text.TryParseDateTime(); filter.To = dateTo != DateTime.MinValue ? dateTo.AddDays(1) : new DateTime(3000, 1, 1); paging.AddField(new Field { Name = "OrderDate", NotInQuery = true, Filter = filter }); } var ordersCount = paging.TotalRowsCount; if (ordersCount == 0) { return; } CommonStatistic.Init(); CommonStatistic.IsRun = true; CommonStatistic.CurrentProcess = Request.Url.PathAndQuery; CommonStatistic.CurrentProcessName = Resource.Admin_ExportOrdersExcel_DownloadOrders; CommonStatistic.TotalRow = ordersCount; linkCancel.Visible = true; OutDiv.Visible = true; btnDownload.Visible = false; pnSearch.Visible = false; try { // Directory if (!Directory.Exists(_strFilePath)) { Directory.CreateDirectory(_strFilePath); } CommonStatistic.StartNew(() => Save(paging)); } catch (Exception ex) { Debug.LogError(ex); lError.Text = ex.Message; lError.Visible = true; CommonStatistic.IsRun = false; } }
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) { SetMeta(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 = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue); if (_paging == null) { throw (new Exception("Paging lost")); } string strIds = Request.Form["SelectedIds"]; if (!string.IsNullOrEmpty(strIds)) { strIds = strIds.Trim(); var arrids = strIds.Split(' '); _selectionFilter = new InSetFieldFilter(); if (arrids.Contains("-1")) { _selectionFilter.IncludeValues = false; _inverseSelection = true; } else { _selectionFilter.IncludeValues = true; } _selectionFilter.Values = arrids.Where(id => id != "-1").ToArray(); } } }
protected void Page_Load(object sender, EventArgs e) { SetMeta(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 = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue); if (_paging == null) { throw (new Exception("Paging lost")); } string strIds = Request.Form["SelectedIds"]; if (!string.IsNullOrEmpty(strIds)) { strIds = strIds.Trim(); var arrids = strIds.Split(' '); _selectionFilter = new InSetFieldFilter(); if (arrids.Contains("-1")) { _selectionFilter.IncludeValues = false; _inverseSelection = true; } else { _selectionFilter.IncludeValues = true; } _selectionFilter.Values = arrids.Where(id => id != "-1").ToArray(); } } }
protected void Page_Load(object sender, EventArgs e) { MsgErr(true); SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_CustomerSearch_SubHeader)); if (!Page.IsPostBack) { //Check item count for region dropDownList ddlCustomerRole.Items.AddRange(Roles.ToArray()); ddlCustomerRole.Items.Insert(0, new ListItem(Resource.Admin_Catalog_Any, "-1")); } if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Customers].[Customer]", ItemsPerPage = 10 }; var f = new Field { Name = "CustomerID as ID", 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); f = new Field { Name = "CustomerGroupId" }; _paging.AddField(f); f = new Field { Name = "RegistrationDateTime" }; _paging.AddField(f); f = new Field { Name = "CustomerRole" }; _paging.AddField(f); if (CustomerContext.CurrentCustomer.CustomerRole == Role.Moderator) { // we cant create filter by 2 fields // result: WHERE CustomerRole = 0 or CustomerId = @rCustomerId var fieldName = "CustomerRole = " + ((int)Role.User).ToString() + " or CustomerId"; _paging.AddField(new Field(fieldName) { NotInQuery = true, Filter = new EqualFieldFilter() { ParamName = "@rCustomerId", Value = CustomerContext.CurrentCustomer.Id.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) { 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 Page_Load(object sender, EventArgs e) { 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) { 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 = Convert.ToInt32(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_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 = 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) { 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) { Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Subscription_Header); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[dbo].[SubscribeDeactivateReason]", ItemsPerPage = 10 }; var f = new Field { Name = "ID", IsDistinct = true, Filter = _selectionFilter }; _paging.AddField(f); f = new Field { Name = "MessageText" }; _paging.AddField(f); f = new Field { Name = "AddDate", Sorting = SortDirection.Descending }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowAddDate", "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")); } 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++) { 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_Taxes_Header)); var cats = new List<Category> { CategoryService.GetCategory(0) }; Category[] rootCategories = cats.ToArray(); CatalogDataTreeViewForTaxes.RootCategories = rootCategories; var taxIdStr = Request["taxid"]; if (string.IsNullOrEmpty(taxIdStr)) { Response.Redirect("Taxes.aspx", true); return; } int taxId; if (!Int32.TryParse(taxIdStr, out taxId)) { Response.Redirect("Taxes.aspx", true); return; } CurrentTax = TaxServices.GetTax(taxId); Title = CurrentTax.Name; if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[TaxRegionRate] JOIN [Customers].[Region] ON [TaxRegionRate].[RegionID] = [Region].[RegionID]", ItemsPerPage = 10 }; var f = new Field { Name = "TaxID" }; var ff = new EqualFieldFilter { ParamName = "@TaxID", Value = CurrentTax.TaxId.ToString(CultureInfo.InvariantCulture) }; f.Filter = ff; _paging.AddField(f); f = new Field { Name = "RegionName", Sorting = SortDirection.Ascending }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowName", f.Sorting == SortDirection.Ascending ? "images/arrowup.gif" : "images/arrowdown.gif"); f = new Field { Name = "RegionRate" }; _paging.AddField(f); f = new Field { Name = "[Catalog].[TaxRegionRate].RegionID as RegionID" }; _paging.AddField(f); _paging.CurrentPageIndex = 1; ViewState["Paging"] = _paging; ddlDependsOnAddress.Items.Add(new ListItem(Resources.Resource.Admin_Taxes_DefaultAddress, ((int)TypeRateDepends.Default).ToString(CultureInfo.InvariantCulture))); ddlDependsOnAddress.Items.Add(new ListItem(Resources.Resource.Admin_Taxes_ShippingAddress, ((int)TypeRateDepends.ByShippingAddress).ToString(CultureInfo.InvariantCulture))); ddlDependsOnAddress.Items.Add(new ListItem(Resources.Resource.Admin_Taxes_BillingAddress, ((int)TypeRateDepends.ByBillingAddress).ToString(CultureInfo.InvariantCulture))); ddlDependsOnAddress.SelectedValue = ((int)CurrentTax.DependsOnAddress).ToString(CultureInfo.InvariantCulture); ddlRateType.Items.Add(new ListItem(Resources.Resource.Admin_Taxes_Fixed, ((int)RateType.LumpSum).ToString(CultureInfo.InvariantCulture))); ddlRateType.Items.Add(new ListItem(Resources.Resource.Admin_Taxes_Proportional, ((int)RateType.Proportional).ToString(CultureInfo.InvariantCulture))); ddlRateType.SelectedValue = ((int)CurrentTax.Type).ToString(CultureInfo.InvariantCulture); ddlCountry.DataSource = CountryService.GetAllCountries(); DataBind(); ddlCountry.SelectedValue = CurrentTax.CountryID.ToString(CultureInfo.InvariantCulture); ddlCountry_SelectedIndexChanged(ddlCountry, e); chkEnabled.Checked = CurrentTax.Enabled; } else { _paging = (SqlPaging)ViewState["Paging"]; } }
protected void btnDownload_Click(object sender, EventArgs e) { if (CommonStatistic.IsRun) { lError.Visible = true; lError.Text = Resource.Admin_Restrict_Action_In_demo; return; } var paging = new SqlPaging { TableName = "[Order].[Order]" }; paging.AddField(new Field { Name = "*" }); if (chkStatus.Checked) { paging.AddField(new Field { Name = "OrderStatusID", NotInQuery = true, Filter = new EqualFieldFilter { ParamName = "@OrderStatusID", Value = ddlStatus.SelectedValue } }); } if (chkDate.Checked) { var filter = new DateTimeRangeFieldFilter { ParamName = "@RDate" }; var dateFrom = txtDateFrom.Text.TryParseDateTime(); if (dateFrom != DateTime.MinValue) filter.From = dateFrom; var dateTo = txtDateTo.Text.TryParseDateTime(); if (dateTo != DateTime.MinValue) filter.To = dateTo.AddDays(1) ; paging.AddField(new Field { Name = "OrderDate", NotInQuery = true, Filter = filter }); } var ordersCount = paging.TotalRowsCount; if (ordersCount == 0) return; CommonStatistic.Init(); CommonStatistic.IsRun = true; CommonStatistic.CurrentProcess = Request.Url.PathAndQuery; CommonStatistic.CurrentProcessName = Resource.Admin_ExportOrdersExcel_DownloadOrders; CommonStatistic.TotalRow = ordersCount; linkCancel.Visible = true; OutDiv.Visible = true; btnDownload.Visible = false; pnSearch.Visible = false; try { // Directory if (!Directory.Exists(_strFilePath)) Directory.CreateDirectory(_strFilePath); var tr = new Thread(Save); CommonStatistic.ThreadImport = tr; tr.Start(paging); } catch (Exception ex) { //Debug.LogError(ex, sender, e); Debug.LogError(ex); lError.Text = ex.Message; lError.Visible = true; CommonStatistic.IsRun = false; } }
protected void Page_Load(object sender, EventArgs e) { bool categoryIdIsNum = false; int categoryId = -1; if (!string.IsNullOrEmpty(Request["newscategoryid"]) && Int32.TryParse(Request["newscategoryid"], out categoryId)) { categoryIdIsNum = categoryId != -1; } _paging = new SqlPaging { TableName = "Settings.News left join Catalog.Photo on Photo.objId=News.NewsID and Type=@Type", ItemsPerPage = SettingsNews.NewsPerPage }; _paging.AddField(new Field { Name = "NewsID" }); _paging.AddField(new Field { Name = "AddingDate", Sorting = SortDirection.Descending }); _paging.AddField(new Field { Name = "Title" }); _paging.AddField(new Field { Name = "PhotoName as Picture" }); _paging.AddField(new Field { Name = "TextToPublication" }); _paging.AddField(new Field { Name = "TextToEmail" }); _paging.AddField(new Field { Name = "TextAnnotation" }); _paging.AddField(new Field { Name = "UrlPath" }); _paging.AddParam(new SqlParam { ParamName = "@Type", ParamValue = PhotoType.News.ToString() }); if (categoryIdIsNum) { var f = new Field { Name = "NewsCategoryID", NotInQuery = true }; var filter = new EqualFieldFilter { ParamName = "@NewsCategoryID", Value = categoryId.ToString(CultureInfo.InvariantCulture) }; f.Filter = filter; _paging.AddField(f); } // MetaInfo ------------------------------------------------ MetaInfo nmeta = null; if ((SettingsNews.NewsMetaTitle != null) || (SettingsNews.NewsMetaKeywords != null) || (SettingsNews.NewsMetaDescription != null)) { nmeta = new MetaInfo { Type = MetaType.News, Title = (string.IsNullOrEmpty(SettingsNews.NewsMetaTitle)) ? null : SettingsMain.ShopName + " - " + SettingsNews.NewsMetaTitle, MetaKeywords = (string.IsNullOrEmpty(SettingsNews.NewsMetaKeywords)) ? null : SettingsNews.NewsMetaKeywords, MetaDescription = (string.IsNullOrEmpty(SettingsNews.NewsMetaDescription)) ? null : SettingsNews.NewsMetaDescription }; } // MetaInfo ------------------------------------------------ var category = NewsService.GetNewsCategoryById(categoryId); header.Text = category != null?string.Format("{0} / {1}", Resources.Resource.Client_News_News, category.Name) : Resources.Resource.Client_News_News; if (category != null) { ucBreadCrumbs.Items = new List <BreadCrumbs> { new BreadCrumbs { Name = Resources.Resource.Client_News_News, Url = UrlService.GetAbsoluteLink("news") }, new BreadCrumbs { Name = category.Name, Url = UrlService.GetLink(ParamType.NewsCategory, category.UrlPath, category.NewsCategoryID) } }; nmeta = new MetaInfo { Title = SettingsMain.ShopName + " - " + category.Name, MetaDescription = SettingsNews.NewsMetaKeywords, MetaKeywords = SettingsNews.NewsMetaDescription, Type = MetaType.News }; } else { ucBreadCrumbs.Visible = false; } SetMeta(nmeta, string.Empty); }
protected void Page_Load(object sender, EventArgs e) { divSave.Visible = false; grid.ResetToDefaultValueOnRowEditCancel = false; Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_m_CategorySortOrder_Title); if (!IsPostBack) { var root = new TreeNode { Text = Resource.Admin_m_CategorySortOrder_Root, Value = @"0", Selected = true }; tree.Nodes.Add(root); LoadChildCategories(tree.Nodes[0]); } if (!IsPostBack) { _paging = new SqlPaging { TableName = "Catalog.Category" }; var f = new Field { Name = "CategoryID", IsDistinct = true }; var ifilter = new NotEqualFieldFilter { Value = "0", ParamName = "@id" }; f.Filter = ifilter; _paging.AddField(f); f = new Field { Name = "Name" }; _paging.AddField(f); f = new Field { Name = "SortOrder", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "ParentCategory" }; var pfilter = new EqualFieldFilter { Value = hfParent.Value, ParamName = "@CategoryID" }; f.Filter = pfilter; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif"); _paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue); 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")); } } }
protected void Page_Load(object sender, EventArgs e) { var cats = new List <Category> { CategoryService.GetCategory(0) }; Category[] rootCategories = cats.ToArray(); CatalogDataTreeViewForTaxes.RootCategories = rootCategories; var taxIdStr = Request["taxid"]; if (string.IsNullOrEmpty(taxIdStr)) { Response.Redirect("Taxes.aspx", true); return; } int taxId; if (!Int32.TryParse(taxIdStr, out taxId)) { Response.Redirect("Taxes.aspx", true); return; } CurrentTax = TaxServices.GetTax(taxId); Title = CurrentTax.Name; if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Catalog].[TaxRegionRate] JOIN [Customers].[Region] ON [TaxRegionRate].[RegionID] = [Region].[RegionID]", ItemsPerPage = 10 }; var f = new Field { Name = "TaxID" }; var ff = new EqualFieldFilter { ParamName = "@TaxID", Value = CurrentTax.TaxId.ToString(CultureInfo.InvariantCulture) }; f.Filter = ff; _paging.AddField(f); f = new Field { Name = "RegionName", Sorting = SortDirection.Ascending }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowName", f.Sorting == SortDirection.Ascending ? "images/arrowup.gif" : "images/arrowdown.gif"); f = new Field { Name = "RegionRate" }; _paging.AddField(f); f = new Field { Name = "[Catalog].[TaxRegionRate].RegionID as RegionID" }; _paging.AddField(f); _paging.CurrentPageIndex = 1; ViewState["Paging"] = _paging; ddlDependsOnAddress.Items.Add(new ListItem(Resources.Resource.Admin_Taxes_DefaultAddress, ((int)TypeRateDepends.Default).ToString(CultureInfo.InvariantCulture))); ddlDependsOnAddress.Items.Add(new ListItem(Resources.Resource.Admin_Taxes_ShippingAddress, ((int)TypeRateDepends.ByShippingAddress).ToString(CultureInfo.InvariantCulture))); ddlDependsOnAddress.Items.Add(new ListItem(Resources.Resource.Admin_Taxes_BillingAddress, ((int)TypeRateDepends.ByBillingAddress).ToString(CultureInfo.InvariantCulture))); ddlDependsOnAddress.SelectedValue = ((int)CurrentTax.DependsOnAddress).ToString(CultureInfo.InvariantCulture); ddlRateType.Items.Add(new ListItem(Resources.Resource.Admin_Taxes_Fixed, ((int)RateType.LumpSum).ToString(CultureInfo.InvariantCulture))); ddlRateType.Items.Add(new ListItem(Resources.Resource.Admin_Taxes_Proportional, ((int)RateType.Proportional).ToString(CultureInfo.InvariantCulture))); ddlRateType.SelectedValue = ((int)CurrentTax.Type).ToString(CultureInfo.InvariantCulture); ddlCountry.DataSource = CountryService.GetAllCountries(); DataBind(); ddlCountry.SelectedValue = CurrentTax.CountryID.ToString(CultureInfo.InvariantCulture); ddlCountry_SelectedIndexChanged(ddlCountry, e); chkEnabled.Checked = CurrentTax.Enabled; } else { _paging = (SqlPaging)ViewState["Paging"]; } }
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) { 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" }; _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) { Page.Title = string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, Resources.Resource.Admin_MasterPageAdminCatalog_Catalog); if (string.IsNullOrEmpty(Request["regionid"])) { Response.Redirect("Country.aspx"); } Region region = RegionService.GetRegion(Convert.ToInt32(RegionID)); if (region == null) { Response.Redirect("Country.aspx"); } else { lblHead.Text = region.Name; hlBack.NavigateUrl = "Regions.aspx?CountryId=" + region.CountryID; hlBack.Text = Resources.Resource.Admin_Cities_BackToRegions; } if (!IsPostBack) { _paging = new SqlPaging { TableName = "[Customers].[City]", ItemsPerPage = 20 }; var f = new Field { Name = "CityID as ID", IsDistinct = true }; _paging.AddField(f); f = new Field { Name = "CityName", Sorting = SortDirection.Ascending }; _paging.AddField(f); f = new Field { Name = "CitySort" }; _paging.AddField(f); f = new Field { Name = "RegionID", Filter = new EqualFieldFilter() { ParamName = "@RegionID", Value = RegionID.ToString() } }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowCityName", "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) { bool categoryIdIsNum = false; int categoryId = -1; if (!string.IsNullOrEmpty(Request["newscategoryid"]) && Int32.TryParse(Request["newscategoryid"], out categoryId)) { categoryIdIsNum = categoryId != -1; } _paging = new SqlPaging { TableName = "Settings.News left join Catalog.Photo on Photo.objId=News.NewsID and Type=@Type", ItemsPerPage = SettingsNews.NewsPerPage }; _paging.AddField(new Field { Name = "NewsID" }); _paging.AddField(new Field { Name = "AddingDate", Sorting = SortDirection.Descending }); _paging.AddField(new Field { Name = "Title" }); _paging.AddField(new Field { Name = "PhotoName as Picture" }); _paging.AddField(new Field { Name = "TextToPublication" }); _paging.AddField(new Field { Name = "TextToEmail" }); _paging.AddField(new Field { Name = "TextAnnotation" }); _paging.AddField(new Field { Name = "UrlPath" }); _paging.AddParam(new SqlParam { ParameterName = "@Type", Value = PhotoType.News.ToString() }); if (categoryIdIsNum) { var f = new Field { Name = "NewsCategoryID", NotInQuery = true }; var filter = new EqualFieldFilter { ParamName = "@NewsCategoryID", Value = categoryId.ToString(CultureInfo.InvariantCulture) }; f.Filter = filter; _paging.AddField(f); } MetaInfo nmeta = new MetaInfo { Type = MetaType.News, Title = SettingsNews.NewsMetaTitle, MetaKeywords = SettingsNews.NewsMetaKeywords, MetaDescription = SettingsNews.NewsMetaDescription, H1 = SettingsNews.NewsMetaH1 }; var category = NewsService.GetNewsCategoryById(categoryId); header.Text = category != null ? string.Format("{0} / {1}", Resource.Client_News_News, category.Name) : Resource.Client_News_News; if (paging.CurrentPage > 1) { header.Text = header.Text + Resource.Client_Catalog_PageIs + paging.CurrentPage; } if (category != null) { ucBreadCrumbs.Items = new List<BreadCrumbs> { new BreadCrumbs { Name = Resource.Client_News_News, Url = UrlService.GetAbsoluteLink("news") }, new BreadCrumbs { Name = category.Name, Url = UrlService.GetLink(ParamType.NewsCategory, category.UrlPath, category.NewsCategoryID) } }; } else { ucBreadCrumbs.Visible = false; } if (paging.CurrentPage > 1) { nmeta.Title += Resource.Client_Catalog_PageIs + paging.CurrentPage; nmeta.MetaDescription += Resource.Client_Catalog_PageIs + paging.CurrentPage; } SetMeta(nmeta, string.Empty); }
protected void Page_Load(object sender, EventArgs e) { SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Subscription_Header)); if (!IsPostBack) { _paging = new SqlPaging { TableName = "[dbo].[SubscribeDeactivateReason]", ItemsPerPage = 10 }; var f = new Field { Name = "ID", IsDistinct = true, Filter = _selectionFilter }; _paging.AddField(f); f = new Field { Name = "MessageText" }; _paging.AddField(f); f = new Field { Name = "AddDate", Sorting = SortDirection.Descending }; _paging.AddField(f); grid.ChangeHeaderImageUrl("arrowAddDate", "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")); } 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++) { int t = int.Parse(arrids[idx]); if (t != -1) { ids[idx] = t.ToString(CultureInfo.InvariantCulture); } else { _selectionFilter.IncludeValues = false; _inverseSelection = true; } } _selectionFilter.Values = ids; } } }