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 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)
{
if (string.IsNullOrEmpty(Request["type"]) || !Enum.TryParse(Request["type"], true, out _typeFlag) || _typeFlag == ProductOnMain.TypeFlag.None)
{
Error404();
}
ProductsCount = ProductOnMain.GetProductCountByType(_typeFlag);
pnlSort.Visible = ProductsCount > 0;
productView.Visible = ProductsCount > 0;
filterBrand.CategoryId = 0;
filterBrand.InDepth = true;
filterBrand.WorkType = _typeFlag;
filterPrice.CategoryId = 0;
filterPrice.InDepth = true;
//changed by Evgeni for multiple price
defaultDS.TableName = "[Catalog].[Product] LEFT JOIN [Catalog].[Offer] ON [Product].[ProductID] = [Offer].[ProductID] AND [OfferListID] = 6 LEFT JOIN [Catalog].[Photo] ON [Product].[ProductID] = [Photo].[ObjId] And Type='Product' AND [Main] = 1 LEFT JOIN [Catalog].[ShoppingCart] ON [Catalog].[ShoppingCart].[EntityID] = [Catalog].[Product].[ProductID] AND [Catalog].[ShoppingCart].[ShoppingCartTypeId] = 3 AND [ShoppingCart].[CustomerID] = @CustomerId Left JOIN [Catalog].[Ratio] on Product.ProductId= Ratio.ProductID and Ratio.CustomerId=@CustomerId";
defaultDS.AddParamSql(new SqlParam {
ParamName = "@CustomerId", ParamValue = CustomerSession.CustomerId.ToString()
});
defaultDS.AddCondition("[Settings].[CountCategoriesByProduct](Product.ProductID) > 0");
defaultDS.Fields["HirecalEnabled"].Filter = new EqualFieldFilter {
Value = "1", ParamName = "@HirecalEnabled"
};
defaultDS.Fields["Enabled"].Filter = new EqualFieldFilter {
Value = "1", ParamName = "@Enabled"
};
if (_typeFlag == ProductOnMain.TypeFlag.Bestseller)
{
var filterB = new EqualFieldFilter {
ParamName = "@Bestseller", Value = "1"
};
defaultDS.Fields["Bestseller"].Filter = filterB;
defaultDS.Fields.Add(new KeyValuePair <string, Field>("SortBestseller", new Field {
Name = "SortBestseller as Sort"
}));
PageName = Resource.Client_ProductList_AllBestSellers;
SetMeta(new AdvantShop.SEO.MetaInfo(SettingsMain.ShopName + " - " + Resource.Client_Bestsellers_Header), string.Empty);
}
if (_typeFlag == ProductOnMain.TypeFlag.New)
{
var filterN = new EqualFieldFilter {
ParamName = "@New", Value = "1"
};
defaultDS.Fields["New"].Filter = filterN;
defaultDS.Fields.Add(new KeyValuePair <string, Field>("SortNew", new Field {
Name = "SortNew as Sort"
}));
PageName = Resource.Client_ProductList_AllNew;
SetMeta(new AdvantShop.SEO.MetaInfo(SettingsMain.ShopName + " - " + Resource.Client_New_Header), string.Empty);
}
if (_typeFlag == ProductOnMain.TypeFlag.Discount)
{
var filterN = new NotEqualFieldFilter()
{
ParamName = "@Discount", Value = "0"
};
defaultDS.Fields["Discount"].Filter = filterN;
defaultDS.Fields.Add(new KeyValuePair <string, Field>("SortDiscount", new Field {
Name = "SortDiscount as Sort"
}));
PageName = Resource.Client_ProductList_AllDiscount;
SetMeta(new AdvantShop.SEO.MetaInfo(SettingsMain.ShopName + " - " + Resource.Client_Discount_Header), string.Empty);
}
breadCrumbs.Items.AddRange(new BreadCrumbs[] { new BreadCrumbs()
{
Name = Resource.Client_MasterPage_MainPage, Url = UrlService.GetAbsoluteLink("/")
},
new BreadCrumbs()
{
Name = PageName, Url = null
} });
BuildSorting();
BuildFilter();
}