public void LoadData()
{
var data = ProductOnMain.GetAdminProductsByType(Flag, 9);
switch (Flag)
{
case ProductOnMain.TypeFlag.Bestseller:
locName.Text = Resources.Resource.Admin_UserControls_MainPageProduct_Bestseller;
break;
case ProductOnMain.TypeFlag.New:
locName.Text = Resources.Resource.Admin_UserControls_MainPageProduct_New;
break;
case ProductOnMain.TypeFlag.Discount:
locName.Text = Resources.Resource.Admin_UserControls_MainPageProduct_Discount;
break;
}
if (data.Rows.Count > 0)
{
rMainProduct.DataSource = data;
rMainProduct.DataBind();
}
else
{
ProductsNoRecordsBlock.Visible = true;
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
popTree.UpdateTree(ProductOnMain.GetProductIdByType(_typeFlag));
if (grid.UpdatedRow != null && ValidationHelper.IsValidPositiveIntNumber(grid.UpdatedRow["ID"]) && ValidationHelper.IsValidPositiveIntNumber(grid.UpdatedRow["Sort"]))
{
var prodcutId = Convert.ToInt32(grid.UpdatedRow["ID"]);
var sortOrder = Convert.ToInt32(grid.UpdatedRow["Sort"]);
ProductOnMain.UpdateProductByType(prodcutId, sortOrder, _typeFlag);
}
DataTable data = _paging.PageItems;
while (data.Rows.Count < 1 && _paging.CurrentPageIndex > 1)
{
_paging.CurrentPageIndex--;
data = _paging.PageItems;
}
var clmn = new DataColumn("IsSelected", typeof(bool))
{
DefaultValue = _inverseSelection
};
data.Columns.Add(clmn);
if ((_selectionFilter != null) && (_selectionFilter.Values != null))
{
for (int i = 0; i <= data.Rows.Count - 1; i++)
{
int intIndex = i;
if (Array.Exists(_selectionFilter.Values, c => c == data.Rows[intIndex]["ID"].ToString()))
{
data.Rows[i]["IsSelected"] = !_inverseSelection;
}
}
}
if (data.Rows.Count < 1)
{
goToPage.Visible = false;
}
grid.DataSource = data;
grid.DataBind();
pageNumberer.PageCount = _paging.PageCount;
lblFound.Text = _paging.TotalRowsCount.ToString(CultureInfo.InvariantCulture);
if (!IsPostBack || _needReloadTree)
{
ibRecalculate.Attributes.Add("onmouseover", "this.src=\'images/broundarrow.gif\';");
tree.Nodes.Clear();
LoadRootCategories(tree.Nodes);
}
}
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteProduct")
{
if (_typeFlag == ProductOnMain.TypeFlag.None)
{
return;
}
ProductOnMain.DeleteProductByType(Convert.ToInt32(e.CommandArgument), _typeFlag);
}
}
protected void popTree_Selected(object sender, Admin_UserControls_PopupTreeView.TreeNodeSelectedArgs args)
{
if (_typeFlag == ProductOnMain.TypeFlag.None)
{
return;
}
foreach (var altId in args.SelectedValues)
{
ProductOnMain.AddProductByType(Convert.ToInt32(altId), _typeFlag);
}
popTree.UpdateTree(ProductOnMain.GetProductIdByType(_typeFlag));
}
protected void popTree_Selected(object sender, PopupTreeView.TreeNodeSelectedArgs args)
{
if (_typeFlag == ProductOnMain.TypeFlag.None)
{
return;
}
foreach (var altId in args.SelectedValues)
{
ProductOnMain.AddProductByType(SQLDataHelper.GetInt(altId), _typeFlag);
}
popTree.UpdateTree(ProductOnMain.GetProductIdByType(_typeFlag));
}
protected void lbDeleteSelected_Click(object sender, EventArgs e)
{
if ((_selectionFilter != null) && (_selectionFilter.Values != null))
{
if (!_inverseSelection)
{
foreach (var id in _selectionFilter.Values)
{
ProductOnMain.DeleteProductByType(Convert.ToInt32(id), _typeFlag);
}
}
else
{
var itemsIds = _paging.ItemsIds <int>("Product.ProductId as ID");
foreach (int id in itemsIds.Where(id => !_selectionFilter.Values.Contains(id.ToString(CultureInfo.InvariantCulture))))
{
ProductOnMain.DeleteProductByType(id, _typeFlag);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SettingsDesign.eMainPageMode currentMode = !Demo.IsDemoEnabled || !CommonHelper.GetCookieString("structure").IsNotEmpty()
? SettingsDesign.MainPageMode
: (SettingsDesign.eMainPageMode)Enum.Parse(typeof(SettingsDesign.eMainPageMode), CommonHelper.GetCookieString("structure"));
if (Mode != currentMode)
{
this.Visible = false;
return;
}
const byte itemsPerLine = 4;
const byte itemsPerLineThin = 3;
var countNew = ProductOnMain.GetProductCountByType(ProductOnMain.TypeFlag.New);
var countDiscount = ProductOnMain.GetProductCountByType(ProductOnMain.TypeFlag.Discount);
var countBestseller = ProductOnMain.GetProductCountByType(ProductOnMain.TypeFlag.Bestseller);
switch (Mode)
{
case SettingsDesign.eMainPageMode.Default:
mvMainPageProduct.SetActiveView(viewDefault);
if (countBestseller == 0)
{
ItemsCount = 3;
}
if (countNew == 0)
{
ItemsCount = ItemsCount == 2 ? 3 : 6;
}
if (countDiscount == 0)
{
ItemsCount = ItemsCount == 2 ? 3 : 6;
}
if (countBestseller > 0)
{
liBestsellers.Attributes.Add("class", "block width-for-" + ItemsCount);
lvBestSellers.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Bestseller, ItemsCount * SettingsDesign.CountLineOnMainPage);
lvBestSellers.DataBind();
}
else
{
liBestsellers.Visible = false;
}
if (countNew > 0)
{
liNew.Attributes.Add("class", "block width-for-" + ItemsCount);
lvNew.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.New, ItemsCount * SettingsDesign.CountLineOnMainPage);
lvNew.DataBind();
}
else
{
liNew.Visible = false;
}
if (countDiscount > 0)
{
liDiscount.Attributes.Add("class", "block block-last width-for-" + ItemsCount);
lvDiscount.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Discount, ItemsCount * SettingsDesign.CountLineOnMainPage);
lvDiscount.DataBind();
}
else
{
liDiscount.Visible = false;
}
break;
case SettingsDesign.eMainPageMode.TwoColumns:
mvMainPageProduct.SetActiveView(viewAlternative);
if (countBestseller > 0)
{
lvBestSellersAltervative.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Bestseller, itemsPerLine * SettingsDesign.CountLineOnMainPage);
lvBestSellersAltervative.DataBind();
}
else
{
pnlBest.Visible = false;
}
if (countNew > 0)
{
lvNewAlternative.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.New, itemsPerLine * SettingsDesign.CountLineOnMainPage);
lvNewAlternative.DataBind();
}
else
{
pnlNew.Visible = false;
}
if (countDiscount > 0)
{
lvDiscountAlternative.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Discount, itemsPerLine * SettingsDesign.CountLineOnMainPage);
lvDiscountAlternative.DataBind();
}
else
{
pnlDiscount.Visible = false;
}
break;
case SettingsDesign.eMainPageMode.ThreeColumns:
mvMainPageProduct.SetActiveView(viewAlternative);
if (countBestseller > 0)
{
lvBestSellersAltervative.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Bestseller, itemsPerLineThin * SettingsDesign.CountLineOnMainPage);
lvBestSellersAltervative.DataBind();
}
else
{
pnlBest.Visible = false;
}
if (countNew > 0)
{
lvNewAlternative.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.New, itemsPerLineThin * SettingsDesign.CountLineOnMainPage);
lvNewAlternative.DataBind();
}
else
{
pnlNew.Visible = false;
}
if (countDiscount > 0)
{
lvDiscountAlternative.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Discount, itemsPerLineThin * SettingsDesign.CountLineOnMainPage);
lvDiscountAlternative.DataBind();
}
else
{
pnlDiscount.Visible = false;
}
break;
default:
throw new NotImplementedException();
}
}
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();
}
private void AddNewContentInFooter()
{
SettingsDesign.eMainPageMode currentMode = !Demo.IsDemoEnabled || !CommonHelper.GetCookieString("structure").IsNotEmpty()
? SettingsDesign.MainPageMode
: (SettingsDesign.eMainPageMode)Enum.Parse(typeof(SettingsDesign.eMainPageMode), CommonHelper.GetCookieString("structure"));
if (SettingsDesign.Template == TemplateService.DefaultTemplateId && Mode != currentMode)
{
this.Visible = false;
return;
}
LoadModules();
var countNew = ProductOnMain.GetProductCountByType(ProductOnMain.TypeFlag.New);
var countDiscount = ProductOnMain.GetProductCountByType(ProductOnMain.TypeFlag.Discount);
var countBestseller = ProductOnMain.GetProductCountByType(ProductOnMain.TypeFlag.Bestseller);
var countRecomended = ProductOnMain.GetProductCountByType(ProductOnMain.TypeFlag.Recomended);
switch (Mode)
{
case SettingsDesign.eMainPageMode.Default:
mvMainPageProduct.SetActiveView(viewDefault);
int ItemsCount = 3;
if (countBestseller == 0)
{
ItemsCount = 3;
}
if (countNew == 0)
{
ItemsCount = ItemsCount == 2 ? 3 : 6;
}
if (countDiscount == 0)
{
ItemsCount = ItemsCount == 2 ? 3 : 6;
}
if (countRecomended == 0)
{
ItemsCount = ItemsCount == 2 ? 3 : 6;
}
if (countBestseller > 0)
{
liBestsellers.Attributes.Add("class", "block width-for-" + ItemsCount); //SettingsDesign.CountLineOnMainPage);
//lvBestSellers.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Bestseller, ItemCountInRow);
lvBestSellers.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Bestseller, 12);
lvBestSellers.DataBind();
}
else
{
liBestsellers.Visible = false;
}
if (countNew > 0)
{
liNew.Attributes.Add("class", "block width-for-" + ItemsCount); //SettingsDesign.CountLineOnMainPage);
//lvNew.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.New, ItemCountInRow);
lvNew.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.New, 12);
lvNew.DataBind();
}
else
{
liNew.Visible = false;
}
if (countDiscount > 0)
{
liDiscount.Attributes.Add("class", "block block-last width-for-" + ItemsCount); //SettingsDesign.CountLineOnMainPage);
//lvDiscount.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.OnSale, ItemCountInRow);
lvDiscount.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.OnSale, 12);
lvDiscount.DataBind();
}
else
{
liDiscount.Visible = false;
}
if (countRecomended > 0)
{
liRecomended.Attributes.Add("class", "block width-for-" + ItemsCount); //SettingsDesign.CountLineOnMainPage);
//lvRecomended.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Recomended, ItemCountInRow);
lvRecomended.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Recomended, 12);
lvRecomended.DataBind();
}
else
{
liRecomended.Visible = false;
}
break;
case SettingsDesign.eMainPageMode.TwoColumns:
mvMainPageProduct.SetActiveView(viewDefault);
if (countBestseller > 0)
{
lvBestSellers.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Bestseller, ItemCountInRow);
lvBestSellers.DataBind();
}
else
{
pnlBest.Visible = false;
}
if (countNew > 0)
{
lvNewAlternative.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.New, ItemCountInRow);
lvNewAlternative.DataBind();
}
else
{
pnlNew.Visible = false;
}
if (countDiscount > 0)
{
lvDiscountAlternative.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Discount, ItemCountInRow);
lvDiscountAlternative.DataBind();
}
else
{
pnlDiscount.Visible = false;
}
if (countRecomended > 0)
{
lvRecomended.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Recomended, ItemCountInRow);
lvRecomended.DataBind();
}
else
{
pnlRecomended.Visible = false;
}
break;
case SettingsDesign.eMainPageMode.ThreeColumns:
mvMainPageProduct.SetActiveView(viewDefault);
if (countBestseller > 0)
{
lvBestSellers.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Bestseller, ItemCountInRow);
lvBestSellers.DataBind();
}
else
{
pnlBest.Visible = false;
}
if (countNew > 0)
{
lvNewAlternative.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.New, ItemCountInRow);
lvNewAlternative.DataBind();
}
else
{
pnlNew.Visible = false;
}
if (countDiscount > 0)
{
lvDiscountAlternative.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Discount, ItemCountInRow);
lvDiscountAlternative.DataBind();
}
else
{
pnlDiscount.Visible = false;
}
if (countRecomended > 0)
{
lvRecomended.DataSource = ProductOnMain.GetProductsByType(ProductOnMain.TypeFlag.Recomended, ItemCountInRow);
lvRecomended.DataBind();
}
else
{
pnlRecomended.Visible = false;
}
break;
default:
throw new NotImplementedException();
}
}
protected void Page_Load(object sender, EventArgs e)
{
_paging = new SqlPaging();
_paging.From("[Catalog].[Product]");
_paging.Inner_Join("[Catalog].[ProductExt] ON [Product].[ProductID] = [ProductExt].[ProductID]");
_paging.Left_Join("[Catalog].[Photo] ON [Photo].[PhotoId] = [ProductExt].[PhotoId]");
_paging.Left_Join("[Catalog].[Offer] ON [ProductExt].[OfferID] = [Offer].[OfferID]");
_paging.Left_Join("[Catalog].[ShoppingCart] ON [ShoppingCart].[OfferID] = [Offer].[OfferID] AND [ShoppingCart].[ShoppingCartType] = 3 AND [ShoppingCart].[CustomerID] = {0}", CustomerContext.CustomerId);
_paging.Left_Join("[Catalog].[Ratio] on Product.ProductId= Ratio.ProductID and Ratio.CustomerId=[ShoppingCart].[CustomerID]");
_paging.Select(
"[Product].[ProductID]",
"CountPhoto",
"Photo.PhotoId",
"PhotoName AS Photo",
"Photo.Description as PhotoDesc",
"BriefDescription",
"Product.ArtNo",
"Name",
"Recomended",
"Bestseller",
"New",
"OnSale",
"[Product].Discount",
"Offer.OfferID",
"MaxAvailable AS Amount",
"MinAmount",
"MaxAmount",
"Enabled",
"AllowPreOrder",
"Ratio",
"RatioID",
"ShoppingCartItemId",
"UrlPath",
"Offer.ColorID",
"null as AdditionalPhoto"
);
if (SettingsCatalog.ComplexFilter)
{
_paging.Select(
"Colors",
"NotSamePrices as MultiPrices",
"MinPrice as Price"
);
}
else
{
_paging.Select(
"null as Colors",
"0 as MultiPrices",
"Price"
);
}
if (string.IsNullOrEmpty(Request["type"]) || !Enum.TryParse(Request["type"], true, out _typeFlag) ||
_typeFlag == ProductOnMain.TypeFlag.None)
{
Error404();
}
switch (_typeFlag)
{
case ProductOnMain.TypeFlag.Bestseller:
PageName = Resource.Client_ProductList_AllBestSellers;
SetMeta(new MetaInfo(SettingsMain.ShopName + " - " + Resource.Client_Bestsellers_Header), string.Empty);
break;
case ProductOnMain.TypeFlag.New:
PageName = Resource.Client_ProductList_AllNew;
SetMeta(new MetaInfo(SettingsMain.ShopName + " - " + Resource.Client_New_Header), string.Empty);
break;
case ProductOnMain.TypeFlag.Discount:
PageName = Resource.Client_ProductList_AllDiscount;
SetMeta(new MetaInfo(SettingsMain.ShopName + " - " + Resource.Client_Discount_Header), string.Empty);
break;
case ProductOnMain.TypeFlag.OnSale:
PageName = Resource.Client_ProductList_OnSale;
SetMeta(new MetaInfo(SettingsMain.ShopName + " - " + Resource.Client_OnSale_Header), string.Empty);
break;
case ProductOnMain.TypeFlag.Recomended:
PageName = Resource.Client_ProductList_Recomended;
SetMeta(new MetaInfo(SettingsMain.ShopName + " - " + Resource.Client_Recomended_Header), string.Empty);
break;
}
ProductsCount = ProductOnMain.GetProductCountByType(_typeFlag);
pnlSort.Visible = ProductsCount > 0;
productView.Visible = ProductsCount > 0;
breadCrumbs.Items.AddRange(new BreadCrumbs[]
{
new BreadCrumbs()
{
Name = Resource.Client_MasterPage_MainPage,
Url = UrlService.GetAbsoluteLink("/")
},
new BreadCrumbs()
{
Name = PageName, Url = null
}
});
BuildSorting();
BuildFilter();
}