protected void btnChangeGroup_Click(object sender, EventArgs e)
{
int?groupId = hfgroupId.Value.TryParseInt() != 0
? hfgroupId.Value.TryParseInt()
: default(int?);
if ((_selectionFilter != null) && (_selectionFilter.Values != null))
{
if (!_inverseSelection)
{
foreach (var id in _selectionFilter.Values)
{
PropertyService.UpdateGroup(Convert.ToInt32(id), groupId);
}
}
else
{
var itemsIds = _paging.ItemsIds <int>("PropertyID as ID");
foreach (var id in itemsIds.Where(id => !_selectionFilter.Values.Contains(id.ToString())))
{
PropertyService.UpdateGroup(id, groupId);
}
}
_selectionFilter = null;
hfgroupId.Value = "";
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
}
}
protected void Page_Load(object sender, EventArgs e)
{
_paging = new SqlPaging {
TableName = "[Customers].[Customer]"
};
_paging.AddFieldsRange(new List <Field>
{
new Field {
Name = "CustomerID as ID", IsDistinct = true
},
new Field {
Name = "EMail"
},
new Field {
Name = "FirstName"
},
new Field {
Name = "LastName"
},
new Field {
Name = "CustomerRole"
},
});
}
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]"
};
_paging.AddFieldsRange(new Field[]
{
new Field {
Name = "[Order].[OrderID]"
},
new Field {
Name = "[Order].[OrderStatusID]"
},
new Field {
Name = "LastName + ' ' + FirstName as CustomerName"
},
new Field {
Name = "[Order].[OrderDate]", Sorting = SortDirection.Descending
},
new Field {
Name = "[Order].[Sum]"
},
new Field {
Name = "[Order].[PaymentDate]"
},
new Field {
Name = "[OrderCurrency].[CurrencyCode]"
},
new Field {
Name = "[OrderCurrency].[CurrencyValue]"
},
new Field {
Name = "[OrderStatus].[Color]"
}
});
if (orderStatusId != 0)
{
_paging.Fields["[Order].[OrderStatusID]"].Filter = new EqualFieldFilter {
ParamName = "@OrderStatusID", Value = orderStatusId.ToString()
};
}
_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)
{
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_OfferLists_Header);
if (!IsPostBack)
{
_paging = new SqlPaging {
TableName = "[Catalog].[OffersList]", ItemsPerPage = 10
};
_paging.AddFieldsRange(new[]
{
new Field
{
Name = "OfferListID as ID", IsDistinct = true, Filter = _selectionFilter
},
new Field {
Name = "Name", Sorting = SortDirection.Ascending
}
});
grid.ChangeHeaderImageUrl("arrowName", "~/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))
{
List <string> arrids = strIds.Trim().Split(' ').ToList();
if (arrids.Contains("-1"))
{
_inverseSelection = true;
arrids.Remove("-1");
}
int t;
_selectionFilter = new InSetFieldFilter
{
IncludeValues = !_inverseSelection,
Values = arrids.Where(id => int.TryParse(id, out t)).ToArray()
};
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
StatusId = Request["orderstatusid"].TryParseInt();
if (!IsPostBack)
{
LoadOrders(StatusId, Request["page"].TryParseInt(1));
lblTotalOrdersCount.Text = StatisticService.GetOrdersCount().ToString();
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
}
}
protected void Page_Load(object sender, EventArgs e)
{
_paging = new SqlPaging {TableName = "[Customers].[Customer]"};
_paging.AddFieldsRange(new List<Field>
{
new Field {Name = "CustomerID as ID", IsDistinct = true},
new Field {Name = "EMail"},
new Field {Name = "FirstName"},
new Field {Name = "LastName"},
new Field {Name = "CustomerRole"},
});
}
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)
{
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_MasterPageAdmin_SEO_redirects);
if (!IsPostBack)
{
_Paging = new SqlPaging
{
TableName = "[Settings].[Redirect]",
ItemsPerPage = 1000
};
_Paging.AddFieldsRange(
new List <Field>
{
new Field {
Name = "ID", IsDistinct = true
},
new Field {
Name = "RedirectFrom"
},
new Field {
Name = "RedirectTo"
}
});
_Paging.ItemsPerPage = 1000;
_Paging.CurrentPageIndex = 1;
ViewState["Paging"] = _Paging;
}
else
{
_Paging = (SqlPaging)(ViewState["Paging"]);
_Paging.ItemsPerPage = 1000;
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_MasterPageAdmin_SEO_redirects);
if (!IsPostBack)
{
_Paging = new SqlPaging
{
TableName = "[Settings].[Redirect]",
ItemsPerPage = 1000
};
_Paging.AddFieldsRange(
new List<Field>
{
new Field {Name = "ID", IsDistinct = true},
new Field {Name = "RedirectFrom"},
new Field {Name = "RedirectTo"}
});
_Paging.ItemsPerPage = 1000;
_Paging.CurrentPageIndex = 1;
ViewState["Paging"] = _Paging;
}
else
{
_Paging = (SqlPaging)(ViewState["Paging"]);
_Paging.ItemsPerPage = 1000;
if (_Paging == null)
{
throw (new Exception("Paging lost"));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = @"[Order].[Order]
INNER JOIN [Order].[OrderStatus] ON [Order].[OrderStatusID] = [OrderStatus].[OrderStatusID]
INNER JOIN [Order].[OrderCurrency] ON [Order].[OrderID] = [OrderCurrency].[OrderID]
INNER JOIN [Order].[OrderCustomer] ON [Order].[OrderID] = [OrderCustomer].[OrderID]
INNER JOIN [Order].[ShippingMethod] ON [Order].[ShippingMethodID] = [ShippingMethod].[ShippingMethodID]
INNER JOIN [Order].[PaymentMethod] ON [Order].[PaymentMethodID] = [PaymentMethod].[PaymentMethodID]",
ItemsPerPage = 10,
CurrentPageIndex = 1
};
_paging.AddFieldsRange(new[]
{
new Field {Name = "[Order].OrderID", Sorting=SortDirection.Ascending },
new Field {Name = "[Order].OrderDiscount"},
new Field {Name = "[OrderStatus].StatusName"},
new Field {Name = "[OrderStatus].OrderStatusID"}, // , NotInQuery =true
new Field {Name = "[Order].Sum"},
new Field {Name = "[Order].OrderDate"},
new Field {Name = "[Order].ShippingMethod.Name as ShippingMethod"},
new Field {Name = "[Order].PaymentMethod.Name as PaymentMethod"},
new Field {Name = "[OrderCustomer].FirstName"},
new Field {Name = "[OrderCustomer].LastName"},
new Field {Name = "[OrderCustomer].CustomerID"},
new Field {Name = "[OrderCurrency].CurrencyCode"},
new Field {Name = "[OrderCurrency].CurrencyValue"}
});
_paging.Fields["[OrderCustomer].CustomerID"].Filter = string.IsNullOrEmpty(Request["customerid"]) ? null : new CompareFieldFilter { Expression = Request["customerid"], ParamName = "@CustomerID" };
//grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
pageNumberer.CurrentPageIndex = 1;
ViewState["CustomerOrderHistoryAdminPaging"] = _paging;
ddlOrderStatus.Items.Clear();
ddlOrderStatus.Items.Add(new ListItem(Resource.Admin_Catalog_Any, "-1"));
foreach (var status in OrderService.GetOrderStatuses())
{
ddlOrderStatus.Items.Add(status.StatusName);
}
}
else
{
_paging = (SqlPaging)(ViewState["CustomerOrderHistoryAdminPaging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
}
}
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)
{
MsgErr(true);
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_CustomerSearch_SubHeader));
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Customers].[Customer]", ItemsPerPage = 10
};
_paging.AddFieldsRange(new List<Field>
{
new Field { Name = "CustomerID as ID", IsDistinct = true },
new Field { Name = "Email" },
new Field { Name = "Firstname", Sorting = SortDirection.Ascending },
new Field { Name = "Lastname" },
new Field { Name = "CustomerGroupId" },
new Field { Name = "RegistrationDateTime" },
new Field { Name = "CustomerRole" },
new Field { Name = "PriceType" }
});
if (CustomerSession.CurrentCustomer.CustomerRole == Role.Moderator)
{
_paging.Fields["CustomerRole"].Filter = new EqualFieldFilter { ParamName = "@CustomerRole", Value = ((int)Role.User).ToString() };
}
advCustomers.ChangeHeaderImageUrl("arrowFirstname", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
if (Request["search"].IsNotEmpty())
{
var customer = CustomerService.GetCustomerByEmail(Request["search"]);
if (customer != null)
{
Response.Redirect("ViewCustomer.aspx?customerID=" + customer.Id);
return;
}
if (Request["search"].Contains("@"))
{
txtSearchEmail.Text = Request["search"];
}
else
{
txtSearchLastname.Text = Request["search"];
}
btnFilter_Click(null, null);
}
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
var strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
var ids = new string[arrids.Length ];
_selectionFilter = new InSetFieldFilter { IncludeValues = true };
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
var t = arrids[idx];
if (t != "-1")
{
ids[idx] = t;
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblError.Text = string.Empty;
lblError.Visible = false;
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Properties_ListPropreties));
if (!IsPostBack)
{
_paging = new SqlPaging { TableName = "[Settings].[NewsCategory]" };
_paging.AddFieldsRange(new List<Field>
{
new Field {Name = "NewsCategoryID as ID", IsDistinct = true},
new Field {Name = "Name"},
new Field {Name = "SortOrder", Sorting = SortDirection.Ascending},
new Field {Name = "UrlPath"},
});
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter { IncludeValues = true };
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString();
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
//_InverseSelection = If(ids(0) = -1, True, False)
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
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)
{
MsgErr(true);
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_OrderSearch_SubHeader);
if (!IsPostBack)
{
FillStatusFilter();
FillPaymentMethodFilter();
FillShippingMethodFilter();
_paging = new SqlPaging
{
TableName =
@"[Order].[Order]
JOIN [Order].[OrderCustomer] ON [Order].[OrderID]=[OrderCustomer].[OrderID]
LEFT JOIN [Order].[OrderStatus] ON [OrderStatus].[OrderStatusID]=[Order].[OrderStatusID]
JOIN [Order].[OrderCurrency] ON [Order].[OrderID] = [OrderCurrency].[OrderID]
JOIN [Order].[OrderContact] ON [Order].[BillingContactID] = [OrderContact].[OrderContactID]
LEFT JOIN [Order].[PaymentMethod] ON [Order].[PaymentMethodID] = [Order].[PaymentMethod].[PaymentMethodID]
LEFT JOIN [Order].[ShippingMethod] ON [Order].[ShippingMethodID] = [Order].[ShippingMethod].ShippingMethodID",
ItemsPerPage = 10
};
_paging.AddFieldsRange(
new Field("[Order].OrderID as ID")
{
IsDistinct = true, Sorting = SortDirection.Descending
},
new Field("StatusName"),
new Field("PaymentDate"),
new Field("PaymentMethodName"),
new Field("ShippingMethodName"),
new Field("FirstName + ' ' + LastName as BuyerName"),
new Field("OrderContact.Name as BillingName"),
new Field("PaymentMethod.Name as PaymentMethod"),
new Field("ShippingMethod.Name as ShippingMethod"),
new Field("Sum"),
new Field("OrderDate"),
new Field("CurrencyValue"),
new Field("CurrencyCode"),
new Field("CustomerID"));
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
grid.ChangeHeaderImageUrl("arrowOrderID", "images/arrowdown.gif");
if (Request["filter"] != null)
{
if (Request["filter"] == "lastmonth")
{
txtDateFrom.Text = DateTime.Now.Date.AddDays(-1).ToString("dd.MM.yyyy");
txtDateTo.Text = DateTime.Now.Date.AddMonths(1).ToString("dd.MM.yyyy");
}
if (Request["filter"] == "today")
{
txtDateFrom.Text = DateTime.Now.Date.ToString("dd.MM.yyyy");
txtDateTo.Text = DateTime.Now.Date.ToString("dd.MM.yyyy");
}
if (Request["filter"] == "yesterday")
{
txtDateFrom.Text = DateTime.Now.Date.AddDays(-1).ToString("dd.MM.yyyy");
txtDateTo.Text = DateTime.Now.Date.AddDays(-1).ToString("dd.MM.yyyy");
}
btnFilter_Click(sender, e);
}
ddlStatus.DataBind();
}
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.Replace(" ", "") != "-1")
{
ids[idx] = t;
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
}
}
if (!IsPostBack && !string.IsNullOrEmpty(Request["status"]))
{
ddlStatusName.SelectedValue = Request["status"].ToLower();
btnFilter_Click(new object(), new EventArgs());
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetMeta(string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, Resources.Resource.Admin_Regions_Header));
if (string.IsNullOrEmpty(Request["countryid"]))
{
Response.Redirect("Country.aspx");
}
Country country = CountryService.GetCountry(SQLDataHelper.GetInt(CountryID));
if (country == null)
Response.Redirect("Country.aspx");
else
{
lblHead.Text = country.Name;
hlBack.NavigateUrl = "Country.aspx";
hlBack.Text = Resources.Resource.Admin_Cities_BackToCoutries;
}
if (!IsPostBack)
{
_paging = new SqlPaging { TableName = "[Customers].[Region]", ItemsPerPage = 20 };
var f = new Field { Name = "RegionID as ID", IsDistinct = true };
_paging.AddField(f);
f = new Field { Name = "RegionName", Sorting = SortDirection.Ascending };
_paging.AddField(f);
f = new Field { Name = "RegionCode" };
_paging.AddField(f);
f = new Field { Name = "RegionSort" };
_paging.AddField(f);
f = new Field() { Name = "CountryID", Filter = new EqualFieldFilter() { ParamName = "@CounrtyID", Value = CountryID.ToString() } };
_paging.AddField(f);
grid.ChangeHeaderImageUrl("arrowRegionName", "images/arrowup.gif");
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
var ids = new string[arrids.Length ];
_selectionFilter = new InSetFieldFilter { IncludeValues = true };
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString(CultureInfo.InvariantCulture);
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_PageParts_StaticBlocks));
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[CMS].[StaticBlock]",
ItemsPerPage = 50
};
_paging.AddFieldsRange(new List <Field>
{
new Field {
Name = "StaticBlockID as ID", IsDistinct = true
},
new Field {
Name = "[Key]", Sorting = SortDirection.Ascending
},
new Field {
Name = "InnerName"
},
new Field {
Name = "Added"
},
new Field {
Name = "Modified"
},
new Field {
Name = "Enabled"
}
});
grid.ChangeHeaderImageUrl("arrowKey", "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(' ');
_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)
{
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 (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = @"[Order].[Order]
INNER JOIN [Order].[OrderStatus] ON [Order].[OrderStatusID] = [OrderStatus].[OrderStatusID]
INNER JOIN [Order].[OrderCurrency] ON [Order].[OrderID] = [OrderCurrency].[OrderID]
INNER JOIN [Order].[OrderCustomer] ON [Order].[OrderID] = [OrderCustomer].[OrderID]
LEFT JOIN [Order].[ShippingMethod] ON [Order].[ShippingMethodID] = [ShippingMethod].[ShippingMethodID]
LEFT JOIN [Order].[PaymentMethod] ON [Order].[PaymentMethodID] = [PaymentMethod].[PaymentMethodID]",
ItemsPerPage = 10,
CurrentPageIndex = 1
};
_paging.AddFieldsRange(new[]
{
new Field {
Name = "[Order].OrderID", Sorting = SortDirection.Ascending
},
new Field {
Name = "[Order].OrderDiscount"
},
new Field {
Name = "[OrderStatus].StatusName"
},
new Field {
Name = "[OrderStatus].OrderStatusID"
}, // , NotInQuery =true
new Field {
Name = "[Order].Sum"
},
new Field {
Name = "[Order].OrderDate", Sorting = SortDirection.Descending
},
new Field {
Name = "[Order].ShippingMethod.Name as ShippingMethod"
},
new Field {
Name = "[Order].PaymentMethod.Name as PaymentMethod"
},
new Field {
Name = "[OrderCustomer].FirstName"
},
new Field {
Name = "[OrderCustomer].LastName"
},
new Field {
Name = "[OrderCustomer].CustomerID"
},
new Field {
Name = "[OrderCurrency].CurrencyCode"
},
new Field {
Name = "[OrderCurrency].CurrencyValue"
}
});
_paging.Fields["[OrderCustomer].CustomerID"].Filter = string.IsNullOrEmpty(Request["customerid"]) ? null : new CompareFieldFilter {
Expression = Request["customerid"], ParamName = "@CustomerID"
};
//grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
pageNumberer.CurrentPageIndex = 1;
ViewState["CustomerOrderHistoryAdminPaging"] = _paging;
ddlOrderStatus.Items.Clear();
ddlOrderStatus.Items.Add(new ListItem(Resource.Admin_Catalog_Any, "-1"));
foreach (var status in OrderService.GetOrderStatuses())
{
ddlOrderStatus.Items.Add(status.StatusName);
}
}
else
{
_paging = (SqlPaging)(ViewState["CustomerOrderHistoryAdminPaging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
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)
{
_priceField = CustomerSession.CurrentCustomer.PriceType.ToString();
_paging = new SqlPaging
{
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] " +
"LEFT JOIN [Catalog].[ShoppingCart] ON [Catalog].[ShoppingCart].[OfferID] = [Catalog].[Offer].[OfferID] AND [Catalog].[ShoppingCart].[ShoppingCartType] = 3 AND [ShoppingCart].[CustomerID] = @CustomerId " +
"Left JOIN [Catalog].[Ratio] on Product.ProductId= Ratio.ProductID and Ratio.CustomerId=@CustomerId " +
"LEFT JOIN [Customers].[LastPrice] ON [LastPrice].[ProductId] = [Product].[ProductId] AND [LastPrice].[CustomerId] = @CustomerId"
};
_paging.AddFieldsRange(
new List<Field>
{
new Field {Name = "[Product].[ProductID]", IsDistinct = true},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select Count(PhotoName) From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type) ELSE (Select Count(PhotoName) From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type) END) AS CountPhoto"},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select TOP(1) PhotoName From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type Order By main desc, [Photo].[PhotoSortOrder]) ELSE (Select TOP(1) PhotoName From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type AND [Photo].[Main] = 1) END) AS Photo"},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select TOP(1) [Photo].[Description] From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type Order By main desc, [Photo].[PhotoSortOrder]) ELSE (Select TOP(1) [Photo].[Description] From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type AND [Photo].[Main] = 1) END) AS PhotoDesc"},
new Field {Name = "[ProductCategories].[CategoryID]", NotInQuery=true},
new Field {Name = "BriefDescription"},
new Field {Name = "Product.ArtNo"},
new Field {Name = "Name"},
new Field {Name = "Recomended"},
new Field {Name = "Bestseller"},
new Field {Name = "New"},
new Field {Name = "OnSale"},
new Field {Name = "Discount"},
new Field {Name = "Offer.Main", NotInQuery=true},
new Field {Name = "Offer.OfferID"},
new Field {Name = "Offer.Amount"},
new Field {Name = "(CASE WHEN Offer.Amount=0 OR Offer.Amount < IsNull(MinAmount,0) THEN 0 ELSE 1 END) as TempAmountSort", Sorting=SortDirection.Descending},
new Field {Name = "MinAmount"},
new Field {Name = "MaxAmount"},
new Field {Name = "Multiplicity"},
new Field {Name = "Enabled"},
new Field {Name = "AllowPreOrder"},
new Field {Name = "Ratio"},
new Field {Name = "RatioID"},
new Field {Name = "DateModified"},
new Field {Name = "ShoppingCartItemId"},
new Field {Name = "UrlPath"},
new Field {Name = "[ShoppingCart].[CustomerID]", NotInQuery=true},
new Field {Name = "BrandID", NotInQuery=true},
new Field {Name = "Offer.ProductID as Size_ProductID", NotInQuery=true},
new Field {Name = "Offer.ProductID as Color_ProductID", NotInQuery=true},
new Field {Name = "Offer.ProductID as Price_ProductID", NotInQuery=true},
new Field {Name = "Offer.ColorID"},
new Field {Name = "CategoryEnabled", NotInQuery=true},
new Field {Name = "null as AdditionalPhoto"}
});
if (SettingsCatalog.ComplexFilter)
{
_paging.AddFieldsRange(new List<Field>
{
new Field {Name = "(select [Settings].[ProductColorsToString]([Product].[ProductID])) as Colors"},
new Field {Name = string.Format("(select max ({0}) - min ({0}) from catalog.offer where offer.productid=product.productid) as MultiPrices", _priceField)},
new Field {Name = string.Format("(select min ({0}) from catalog.offer where offer.productid=product.productid) as Price", _priceField)},
});
}
else
{
_paging.AddFieldsRange(new List<Field>
{
new Field {Name = "null as Colors"},
new Field {Name = "0 as MultiPrices"},
new Field
{
Name = SettingsCatalog.UseLastPrice
? string.Format("(CASE WHEN ProductPrice IS NULL THEN {0} ELSE ProductPrice END) as Price", _priceField)
: string.Format("{0} as Price", _priceField)
},
});
}
_paging.AddParam(new SqlParam { ParameterName = "@CustomerId", Value = CustomerSession.CustomerId.ToString() });
_paging.AddParam(new SqlParam { ParameterName = "@Type", Value = PhotoType.Product.ToString() });
BuildSorting();
BuildFilter();
var nmeta = new MetaInfo(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Client_Search_AdvancedSearch));
SetMeta(nmeta, string.Empty, page:paging.CurrentPage);
txtName.Focus();
}
protected void Page_Load(object sender, EventArgs e)
{
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_MenuManager_TopMenu));
Int32.TryParse(Request["menuid"], out _menuId);
_needReloadTree = SQLDataHelper.GetBoolean(ViewState["updateTree"]);
hlEditCategory.Visible = _menuId > 0;
lblSeparator.Visible = _menuId > 0;
hlDeleteCategory.Visible = _menuId > 0;
if (!string.IsNullOrWhiteSpace(Request["type"]))
Enum.TryParse(Request["type"], true, out _menuType);
var menuitem = new AdvMenuItem();
switch (_menuType)
{
case MenuService.EMenuType.Top:
menuitem = MenuService.GetMenuItemById(_menuId, _menuType);
lblHead.Text = menuitem == null
? Resource.Admin_MenuManager_TopMenu
: string.Format("{0} - {1}", Resource.Admin_MenuManager_TopMenu, menuitem.MenuItemName);
lblSubHead.Text = Resource.Admin_MenuManager_SubHeaderTop;
Page.Title = menuitem == null
? Resource.Admin_MenuManager_TopMenu
: string.Format("{0} - {1}", Resource.Admin_MenuManager_TopMenu, menuitem.MenuItemName);
break;
case MenuService.EMenuType.Bottom:
menuitem = MenuService.GetMenuItemById(_menuId, _menuType);
lblHead.Text = menuitem == null
? Resource.Admin_MenuManager_BottomMenu
: string.Format("{0} - {1}", Resource.Admin_MenuManager_BottomMenu, menuitem.MenuItemName);
lblSubHead.Text = Resource.Admin_MenuManager_SubHeaderBottom;
Page.Title = menuitem == null
? Resource.Admin_MenuManager_BottomMenu
: string.Format("{0} - {1}", Resource.Admin_MenuManager_BottomMenu, menuitem.MenuItemName);
break;
}
btnAdd.OnClientClick = "open_window('m_Menu.aspx?MenuID=" + _menuId + "&mode=create&type=" + _menuType + "', 750, 640);return false;";
hlEditCategory.NavigateUrl = "javascript:open_window(\'m_Menu.aspx?MenuID=" + _menuId + "&mode=edit&type=" + _menuType + "\', 750, 640)";
ConfirmButtonExtenderCategory.ConfirmText =
string.Format(Resource.Admin_MasterPageAdminCatalog_MenuConfirmation, menuitem != null ? menuitem.MenuItemName : string.Empty);
if (!IsPostBack)
{
switch (_menuType)
{
case MenuService.EMenuType.Top:
_paging = new SqlPaging
{
TableName = "[CMS].[MainMenu]",
ItemsPerPage = 10
};
break;
case MenuService.EMenuType.Bottom:
_paging = new SqlPaging
{
TableName = "[CMS].[BottomMenu]",
ItemsPerPage = 10
};
break;
}
_paging.AddFieldsRange(new List<Field>
{
new Field
{
Name = "MenuItemID as ID",
IsDistinct = true
},
new Field {Name = "MenuItemParentID" },
new Field {Name = "MenuItemName"},
new Field {Name = "Enabled"},
new Field {Name = "Blank"},
new Field {Name = "SortOrder",Sorting = SortDirection.Ascending}
});
if (_menuId != 0)
{
var filter = new EqualFieldFilter { ParamName = "@MenuItemParentID", Value = _menuId.ToString() };
_paging.Fields["MenuItemParentID"].Filter = filter;
}
else
{
var filter = new NullFieldFilter { ParamName = "@MenuItemParentID", Null = true };
_paging.Fields["MenuItemParentID"].Filter = filter;
}
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["theme"] == null)
{
Response.Redirect("Voting.aspx");
}
lblHead.Text = VoiceService.GetVotingName(ThemeId);
Page.Title = string.Format("{0} - {1} - {2}", SettingsMain.ShopName, lblHead.Text, lblSubHead.Text);
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Voice].[Answer]",
ItemsPerPage = 10
};
_paging.AddFieldsRange(new List <Field>
{
new Field {
Name = "AnswerID as ID", IsDistinct = true
},
new Field {
Name = "Name"
},
new Field {
Name = "CountVoice"
},
new Field {
Name = "Sort", Sorting = SortDirection.Ascending
},
new Field {
Name = "IsVisible"
},
new Field {
Name = "DateAdded"
},
new Field {
Name = "DateModify"
},
new Field
{
Name = "FKIDTheme",
Filter = new EqualFieldFilter {
ParamName = "@Theme", Value = ThemeId.ToString()
}
}
});
grid.ChangeHeaderImageUrl("arrowSort", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Catalog].[ShoppingCart] as sc " +
"Inner Join [Customers].[Customer] On sc.[CustomerId] = [Customer].[CustomerID] ",
ItemsPerPage = 30,
};
_paging.AddFieldsRange(new List <Field>
{
new Field {
Name = "sc.[CustomerId]", IsDistinct = true
},
new Field {
Name = "ShoppingCartType"
},
new Field
{
Name = "(Select top(1) Email From [Customers].[Customer] " +
"Where [Customer].[CustomerID] = sc.CustomerId) as Email"
},
new Field
{
Name = "(Select top(1) UpdatedOn From [Catalog].[ShoppingCart] " +
"Where [ShoppingCart].[CustomerID] = sc.CustomerId and ShoppingCartType = @CartType Order By UpdatedOn Desc) as LastUpdate",
Sorting = SortDirection.Descending
},
new Field
{
Name = "(Select SUM(Price * [ShoppingCart].[Amount]) " +
"From [Catalog].[ShoppingCart] " +
"Inner Join [Catalog].[Offer] On [Offer].[OfferID] = [ShoppingCart].[OfferId] " +
"Where [ShoppingCart].[CustomerID] = sc.CustomerId and ShoppingCartType = @CartType) As Sum"
},
new Field
{
Name = "(Select Count(*) From [Module].[AbandonedCartLetter] " +
"Where AbandonedCartLetter.CustomerId = sc.CustomerId) as SendingCount"
},
new Field
{
Name = "(Select Top(1)SendingDate From [Module].[AbandonedCartLetter] " +
"Where AbandonedCartLetter.CustomerId = sc.CustomerId Order By SendingDate Desc) as SendingDate"
},
});
_paging.Fields["ShoppingCartType"].Filter = new EqualFieldFilter()
{
ParamName = "@CartType",
Value = ((int)ShoppingCartType.ShoppingCart).ToString()
};
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
if (!IsPostBack)
{
ddlTemplate.Items.Clear();
ddlTemplate.Items.Add(new ListItem("не выбран", "-1"));
foreach (var template in AbandonedCartsService.GetTemplates())
{
ddlTemplate.Items.Add(new ListItem(template.Name, template.Id.ToString()));
}
}
}
protected void 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_SizesDictionary_Header));
MsgError();
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Catalog].[Size]",
ItemsPerPage = 20,
CurrentPageIndex = 1
};
_paging.AddFieldsRange(new[]
{
new Field {Name = "SizeID as ID", IsDistinct = true},
new Field {Name = "SizeName"},
new Field {Name = "SortOrder", Sorting = SortDirection.Ascending}
});
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
pageNumberer.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter { IncludeValues = true };
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString(CultureInfo.InvariantCulture);
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Coupons_Header));
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Catalog].[Coupon]",
ItemsPerPage = 10
};
_paging.AddFieldsRange(new List<Field>
{
new Field
{
Name = "CouponID as ID",
IsDistinct = true
},
new Field {Name = "Code"},
new Field {Name = "Type"},
new Field {Name = "Value"},
new Field {Name = "AddingDate", Sorting = SortDirection.Descending},
new Field {Name = "ExpirationDate"},
new Field {Name = "PossibleUses"},
new Field {Name = "ActualUses"},
new Field {Name = "Enabled"},
new Field {Name = "MinimalOrderPrice"},
});
grid.ChangeHeaderImageUrl("arrowAddingDate", "images/arrowdown.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
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 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_StaticPage_lblSubMain));
int.TryParse(Request["parentid"], out _parentPageId);
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[CMS].[StaticPage]",
ItemsPerPage = 10
};
_paging.AddFieldsRange(new List <Field>
{
new Field {
Name = "StaticPageID as ID", IsDistinct = true
},
new Field {
Name = "PageName"
},
new Field {
Name = "Enabled"
},
new Field {
Name = "ParentID"
},
new Field {
Name = "SortOrder", Sorting = SortDirection.Ascending
},
new Field {
Name = "ModifyDate"
}
});
if (_parentPageId != 0)
{
var ef = new EqualFieldFilter()
{
ParamName = "@ParentID",
Value = _parentPageId.ToString(CultureInfo.InvariantCulture)
};
_paging.Fields["ParentID"].Filter = ef;
}
else
{
var nf = new NullFieldFilter()
{
ParamName = "@ParentID",
Null = true
};
_paging.Fields["ParentID"].Filter = nf;
}
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
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)
{
if (Request["theme"] == null)
{
Response.Redirect("Voting.aspx");
}
lblHead.Text = VoiceService.GetVotingName(ThemeId);
SetMeta(string.Format("{0} - {1} - {2}", SettingsMain.ShopName, lblHead.Text, lblSubHead.Text));
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Voice].[Answer]",
ItemsPerPage = 10
};
_paging.AddFieldsRange(new List<Field>
{
new Field {Name = "AnswerID as ID", IsDistinct = true},
new Field {Name = "Name"},
new Field {Name = "CountVoice"},
new Field {Name = "Sort", Sorting = SortDirection.Ascending},
new Field {Name = "IsVisible"},
new Field {Name = "DateAdded"},
new Field {Name = "DateModify"},
new Field
{
Name = "FKIDTheme",
Filter = new EqualFieldFilter {ParamName = "@Theme", Value = ThemeId.ToString()}
}
});
grid.ChangeHeaderImageUrl("arrowSort", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
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)
{
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)
{
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)
{
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 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)
{
_paging = new SqlPaging
{
TableName =
"[Catalog].[Product] LEFT JOIN [Catalog].[Offer] ON [Product].[ProductID] = [Offer].[ProductID] inner join Catalog.ProductCategories on ProductCategories.ProductId = [Product].[ProductID] Left JOIN [Catalog].[ProductPropertyValue] ON [Product].[ProductID] = [ProductPropertyValue].[ProductID] LEFT JOIN [Catalog].[ShoppingCart] ON [Catalog].[ShoppingCart].[OfferID] = [Catalog].[Offer].[OfferID] AND [Catalog].[ShoppingCart].[ShoppingCartType] = 3 AND [ShoppingCart].[CustomerID] = @CustomerId Left JOIN [Catalog].[Ratio] on Product.ProductId= Ratio.ProductID and Ratio.CustomerId=@CustomerId"
};
_paging.AddFieldsRange(
new List<Field>
{
new Field {Name = "[Product].[ProductID]", IsDistinct = true},
//new Field {Name = "PhotoName AS Photo"},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select Count(PhotoName) From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type) ELSE (Select Count(PhotoName) From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type) END) AS CountPhoto"},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select TOP(1) PhotoName From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type Order By main desc, [Photo].[PhotoSortOrder]) ELSE (Select TOP(1) PhotoName From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type AND [Photo].[Main] = 1) END) AS Photo"},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select TOP(1) [Photo].[Description] From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type Order By main desc, [Photo].[PhotoSortOrder]) ELSE (Select TOP(1) [Photo].[Description] From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type AND [Photo].[Main] = 1) END) AS PhotoDesc"},
new Field {Name = "(select [Settings].[ProductColorsToString]([Product].[ProductID])) as Colors"},
//new Field {Name = "[Photo].[Description] AS PhotoDesc"},
new Field {Name = "[ProductCategories].[CategoryID]", NotInQuery=true},
new Field {Name = "BriefDescription"},
new Field {Name = "Product.ArtNo"},
new Field {Name = "Name"},
new Field {Name = "(CASE WHEN Price=0 THEN 0 ELSE 1 END) as TempSort", Sorting=SortDirection.Descending},
new Field {Name = "Recomended"},
new Field {Name = "Bestseller"},
new Field {Name = "New"},
new Field {Name = "OnSale"},
new Field {Name = "Discount"},
new Field {Name = "Offer.Main", NotInQuery=true},
new Field {Name = "Offer.OfferID"},
new Field {Name = "Offer.Amount"},
new Field {Name = "(CASE WHEN Offer.Amount=0 OR Offer.Amount < IsNull(MinAmount,0) THEN 0 ELSE 1 END) as TempAmountSort", Sorting=SortDirection.Descending},
new Field {Name = "MinAmount"},
new Field {Name = "MaxAmount"},
new Field {Name = "Enabled"},
new Field {Name = "AllowPreOrder"},
new Field {Name = "Ratio"},
new Field {Name = "RatioID"},
new Field {Name = "DateModified"},
new Field {Name = "ShoppingCartItemId"},
new Field {Name = "UrlPath"},
new Field {Name = "[ProductCategories].[SortOrder]"},
new Field {Name = "[ShoppingCart].[CustomerID]", NotInQuery=true},
new Field {Name = "BrandID", NotInQuery=true},
new Field {Name = "Offer.ProductID as Size_ProductID", NotInQuery=true},
new Field {Name = "Offer.ProductID as Color_ProductID", NotInQuery=true},
new Field {Name = "Offer.ProductID as Price_ProductID", NotInQuery=true},
new Field {Name = "Offer.ColorID"},
new Field {Name = "CategoryEnabled", NotInQuery=true},
});
if (SettingsCatalog.ComplexFilter)
{
_paging.AddFieldsRange(new List<Field>
{
new Field {Name = "(select max (price) - min (price) from catalog.offer where offer.productid=product.productid) as MultiPrices"},
new Field {Name = "(select min (price) from catalog.offer where offer.productid=product.productid) as Price"},
});
}
else
{
_paging.AddFieldsRange(new List<Field>
{
new Field {Name = "0 as MultiPrices"},
new Field {Name = "Price"},
});
}
_paging.AddParam(new SqlParam { ParameterName = "@CustomerId", Value = CustomerSession.CustomerId.ToString() });
_paging.AddParam(new SqlParam { ParameterName = "@Type", Value = PhotoType.Product.ToString() });
if (string.IsNullOrEmpty(Request["categoryid"]) || !Int32.TryParse(Request["categoryid"], out _categoryId))
{
_categoryId = 0;
var sbMainPage = StaticBlockService.GetPagePartByKeyWithCache("MainPageSocial");
if (sbMainPage != null && sbMainPage.Enabled)
MainPageText = sbMainPage.Content;
}
if (!string.IsNullOrEmpty(MainPageText))
{
SetMeta(null, string.Empty);
return;
}
category = CategoryService.GetCategory(_categoryId);
if (category == null || category.Enabled == false || category.ParentsEnabled == false)
{
Error404();
return;
}
ProductsCount = category.GetProductCount();
categoryView.CategoryID = _categoryId;
categoryView.Visible = true;
pnlSort.Visible = ProductsCount > 0;
productView.Visible = ProductsCount > 0;
lblCategoryName.Text = _categoryId != 0 ? category.Name : Resource.Client_MasterPage_Catalog;
//lblCategoryDescription.Text = category.Description;
//imgCategoryImage.ImageUrl = string.IsNullOrEmpty(category.Picture) ? "" : string.Format("{0}", ImageFolders.GetImageCategoryPath(false, category.Picture));
breadCrumbs.Items =
CategoryService.GetParentCategories(_categoryId).Select(parent => new BreadCrumbs
{
Name = parent.Name,
Url = "social/catalogsocial.aspx?categoryid=" + parent.CategoryId
}).Reverse().ToList();
breadCrumbs.Items.Insert(0, new BreadCrumbs
{
Name = Resource.Client_MasterPage_MainPage,
Url = UrlService.GetAbsoluteLink("social/catalogsocial.aspx")
});
SetMeta(category.Meta, category.Name);
if (category.DisplayChildProducts)
{
var cfilter = new InChildCategoriesFieldFilter
{
CategoryId = _categoryId.ToString(),
ParamName = "@CategoryID"
};
_paging.Fields["[ProductCategories].[CategoryID]"].Filter = cfilter;
}
else
{
var cfilter = new EqualFieldFilter { Value = _categoryId.ToString(), ParamName = "@catalog" };
_paging.Fields["[ProductCategories].[CategoryID]"].Filter = cfilter;
}
_paging.Fields["Enabled"].Filter = new EqualFieldFilter { Value = "1", ParamName = "@enabled" }; ;
_paging.Fields["CategoryEnabled"].Filter = new EqualFieldFilter { Value = "1", ParamName = "@CategoryEnabled" };
var logicalFilter = new LogicalFilter { ParamName = "@Main", HideInCustomData = true };
logicalFilter.AddFilter(new EqualFieldFilter { Value = "1", ParamName = "@Main1", HideInCustomData = true });
logicalFilter.AddLogicalOperation("OR");
logicalFilter.AddFilter(new NullFieldFilter { Null = true, ParamName = "@Main2", HideInCustomData = true });
_paging.Fields["Offer.Main"].Filter = logicalFilter;
BuildSorting();
}
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 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)
{
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resources.Resource.Admin_Brands_Header));
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Catalog].[Brand] left join Catalog.Photo on Photo.ObjId = Brand.BrandID and Type = @Type ",
ItemsPerPage = 10
};
_paging.AddFieldsRange(new List<Field>
{
new Field
{
Name = "BrandID as ID",
IsDistinct = true
},
new Field {Name = "ProductsCount", SelectExpression="(Select Count(ProductID) from Catalog.Product Where Product.BrandID=Brand.BrandID) as ProductsCount"},
new Field {Name = "PhotoName as BrandLogo"},
new Field {Name = "Enabled"},
new Field {Name = "SortOrder", Sorting = SortDirection.Ascending},
new Field {Name = "BrandName", Sorting=SortDirection.Ascending}
});
_paging.AddParam(new SqlParam { Value = PhotoType.Brand.ToString(), ParameterName = "@Type" });
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_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)
{
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)
{
_paging = new SqlPaging
{
TableName =
"[Catalog].[Product] 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 inner join Catalog.ProductCategories on ProductCategories.ProductId = [Product].[ProductID] Left JOIN [Catalog].[ProductPropertyValue] ON [Product].[ProductID] = [ProductPropertyValue].[ProductID] LEFT JOIN [Catalog].[ShoppingCart] ON [Catalog].[ShoppingCart].[OfferId] = [Catalog].[Offer].[OfferID] AND [Catalog].[ShoppingCart].[ShoppingCartType] = 3 AND [ShoppingCart].[CustomerID] = @CustomerId Left JOIN [Catalog].[Ratio] on Product.ProductId= Ratio.ProductID and Ratio.CustomerId=@CustomerId"
};
_paging.AddParam(new SqlParam { ParameterName = "@CustomerId", Value = CustomerSession.CustomerId.ToString() });
_paging.AddParam(new SqlParam { ParameterName = "@Type", Value = PhotoType.Product.ToString() });
_paging.AddFieldsRange(
new List<Field>
{
new Field {Name = "[Product].[ProductID]", IsDistinct = true},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select Count(PhotoName) From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type) ELSE (Select Count(PhotoName) From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type) END) AS CountPhoto"},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select TOP(1) PhotoName From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type Order By main desc, [Photo].[PhotoSortOrder]) ELSE (Select TOP(1) PhotoName From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type AND [Photo].[Main] = 1) END) AS Photo"},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select TOP(1) [Photo].[Description] From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type Order By main desc, [Photo].[PhotoSortOrder]) ELSE (Select TOP(1) [Photo].[Description] From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type AND [Photo].[Main] = 1) END) AS PhotoDesc"},
new Field {Name = "[ProductCategories].[CategoryID]", NotInQuery=true},
new Field {Name = "BriefDescription"},
new Field {Name = "Product.ArtNo"},
new Field {Name = "Name"},
new Field {Name = "Recomended"},
new Field {Name = "Bestseller"},
new Field {Name = "New"},
new Field {Name = "OnSale"},
new Field {Name = "Discount"},
new Field {Name = "Offer.Main", NotInQuery=true},
new Field {Name = "Offer.OfferID"},
new Field {Name = "Offer.Amount"},
new Field {Name = "(CASE WHEN Offer.Amount=0 OR Offer.Amount < IsNull(MinAmount,0) THEN 0 ELSE 1 END) as TempAmountSort", Sorting=SortDirection.Descending},
new Field {Name = "MinAmount"},
new Field {Name = "MaxAmount"},
new Field {Name = "Enabled"},
new Field {Name = "AllowPreOrder"},
new Field {Name = "Ratio"},
new Field {Name = "RatioID"},
new Field {Name = "DateModified"},
new Field {Name = "ShoppingCartItemId"},
new Field {Name = "UrlPath"},
new Field {Name = "[ShoppingCart].[CustomerID]", NotInQuery=true},
new Field {Name = "BrandID", NotInQuery=true},
new Field {Name = "Offer.ProductID as Size_ProductID", NotInQuery=true},
new Field {Name = "Offer.ProductID as Color_ProductID", NotInQuery=true},
new Field {Name = "Offer.ProductID as Price_ProductID", NotInQuery=true},
new Field {Name = "Offer.ColorID"},
new Field {Name = "CategoryEnabled", NotInQuery=true},
new Field {Name = "null as AdditionalPhoto"}
});
if (SettingsCatalog.ComplexFilter)
{
_paging.AddFieldsRange(new List<Field>
{
new Field {Name = "(select [Settings].[ProductColorsToString]([Product].[ProductID])) as Colors"},
new Field {Name = "(select max (price) - min (price) from catalog.offer where offer.productid=product.productid) as MultiPrices"},
new Field {Name = "(select min (price) from catalog.offer where offer.productid=product.productid) as Price"},
});
}
else
{
_paging.AddFieldsRange(new List<Field>
{
new Field {Name = "null as Colors"},
new Field {Name = "0 as MultiPrices"},
new Field {Name = "Price"},
});
}
_paging.Fields["[Product].[ProductID]"].Filter = new CountProductInCategory();
_paging.Fields["Enabled"].Filter = new EqualFieldFilter { ParamName = "@enabled", Value = "1" };
_paging.Fields["CategoryEnabled"].Filter = new EqualFieldFilter { ParamName = "@CategoryEnabled", Value = "1" };
BuildSorting();
BuildFilter();
SetMeta(null, string.Empty);
txtName.Focus();
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Coupons_Header);
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Catalog].[Coupon]",
ItemsPerPage = 10
};
_paging.AddFieldsRange(new List <Field>
{
new Field
{
Name = "CouponID as ID",
IsDistinct = true
},
new Field {
Name = "Code"
},
new Field {
Name = "Type"
},
new Field {
Name = "Value"
},
new Field {
Name = "AddingDate", Sorting = SortDirection.Descending
},
new Field {
Name = "ExpirationDate"
},
new Field {
Name = "PossibleUses"
},
new Field {
Name = "ActualUses"
},
new Field {
Name = "Enabled"
},
new Field {
Name = "MinimalOrderPrice"
},
});
grid.ChangeHeaderImageUrl("arrowAddingDate", "images/arrowdown.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
StatusId = Request["orderstatusid"].TryParseInt();
if (!IsPostBack)
{
LoadOrders(StatusId, Request["page"].TryParseInt(1));
lblTotalOrdersCount.Text = StatisticService.GetOrdersCount().ToString();
}
else
{
_paging = (SqlPaging) (ViewState["Paging"]);
}
}
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)
{
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"));
}
}
}
//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)
{
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_NewsAdmin_Header));
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Settings].[News]",
ItemsPerPage = 20
};
_paging.AddFieldsRange(new List <Field>
{
new Field
{
Name = "NewsID as ID",
IsDistinct = true
},
new Field {
Name = "Title"
},
new Field {
Name = "ShowOnMainPage"
},
new Field {
Name = "NewsCategoryID"
},
new Field {
Name = "AddingDate", Sorting = SortDirection.Descending
}
});
grid.ChangeHeaderImageUrl("arrowAddingDate", "images/arrowdown.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(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
var modules = AttachedModules.GetModules <ISendMails>();
foreach (var moduleType in modules)
{
var moduleObject = (ISendMails)Activator.CreateInstance(moduleType, null);
if (ModulesRepository.IsActiveModule(moduleObject.ModuleStringId))
{
CanSendNews = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(Request["categoryid"]) || !Int32.TryParse(Request["categoryid"], out _categoryId))
{
Error404();
}
Category = CategoryService.GetCategory(_categoryId);
if (Category == null || Category.Enabled == false || Category.ParentsEnabled == false)
{
Error404();
return;
}
Indepth = Request["indepth"] == "1" || Category.DisplayChildProducts;
_priceField = CustomerSession.CurrentCustomer.PriceType.ToString();
_paging = new SqlPaging
{
TableName =
"[Catalog].[Product] " +
"LEFT JOIN [Catalog].[Offer] ON [Product].[ProductID] = [Offer].[ProductID] " +
"inner join Catalog.ProductCategories on ProductCategories.ProductId = [Product].[ProductID] " +
"Left JOIN [Catalog].[ProductPropertyValue] ON [Product].[ProductID] = [ProductPropertyValue].[ProductID] " +
"LEFT JOIN [Catalog].[ShoppingCart] ON [Catalog].[ShoppingCart].[OfferID] = [Catalog].[Offer].[OfferID] AND [Catalog].[ShoppingCart].[ShoppingCartType] = 3 AND [ShoppingCart].[CustomerID] = @CustomerId " +
"Left JOIN [Catalog].[Ratio] on Product.ProductId= Ratio.ProductID and Ratio.CustomerId=@CustomerId " +
"LEFT JOIN [Customers].[LastPrice] ON [LastPrice].[ProductId] = [Product].[ProductId] AND [LastPrice].[CustomerId] = @CustomerId"
};
_paging.AddFieldsRange(
new List<Field>
{
new Field {Name = "[Product].[ProductID]", IsDistinct = true},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select Count(PhotoName) From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type) ELSE (Select Count(PhotoName) From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type) END) AS CountPhoto"},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select TOP(1) PhotoName From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type Order By main desc, [Photo].[PhotoSortOrder]) ELSE (Select TOP(1) PhotoName From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type AND [Photo].[Main] = 1) END) AS Photo"},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select TOP(1) [Photo].[Description] From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type Order By main desc, [Photo].[PhotoSortOrder]) ELSE (Select TOP(1) [Photo].[Description] From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type AND [Photo].[Main] = 1) END) AS PhotoDesc"},
new Field {Name = "[ProductCategories].[CategoryID]", NotInQuery=true},
new Field {Name = "BriefDescription"},
new Field {Name = "Product.ArtNo"},
new Field {Name = "Name"},
new Field {Name = string.Format("(CASE WHEN {0}=0 THEN 0 ELSE 1 END) as TempSort", _priceField), Sorting=SortDirection.Descending},
new Field {Name = "Recomended"},
new Field {Name = "Bestseller"},
new Field {Name = "New"},
new Field {Name = "OnSale"},
new Field {Name = "Discount"},
new Field {Name = "Offer.Main", NotInQuery=true},
new Field {Name = "Offer.OfferID"},
new Field {Name = "(Select Max(Offer.Amount) from catalog.Offer Where ProductId=[Product].[ProductID]) as Amount"},
new Field {Name = "(CASE WHEN (Select Max(Offer.Amount) from catalog.Offer Where ProductId=[Product].[ProductID]) <= 0 OR (Select Max(Offer.Amount) from catalog.Offer Where ProductId=[Product].[ProductID]) < IsNull(MinAmount,0) THEN 0 ELSE 1 END) as TempAmountSort", Sorting=SortDirection.Descending},
new Field {Name = "MinAmount"},
new Field {Name = "MaxAmount"},
new Field {Name = "Multiplicity"},
new Field {Name = "Enabled"},
new Field {Name = "AllowPreOrder"},
new Field {Name = "Ratio"},
new Field {Name = "RatioID"},
new Field {Name = "DateModified"},
new Field {Name = "ShoppingCartItemId"},
new Field {Name = "UrlPath"},
new Field {Name = !Indepth ? "[ProductCategories].[SortOrder]" : "0 as SortOrder"},
new Field {Name = "[ShoppingCart].[CustomerID]", NotInQuery=true},
new Field {Name = "BrandID", NotInQuery=true},
new Field {Name = "Offer.ProductID as Size_ProductID", NotInQuery=true},
new Field {Name = "Offer.ProductID as Color_ProductID", NotInQuery=true},
new Field {Name = "Offer.ProductID as Price_ProductID", NotInQuery=true},
new Field {Name = "Offer.ColorID"},
new Field {Name = "CategoryEnabled", NotInQuery=true},
});
if (SettingsCatalog.ComplexFilter)
{
_paging.AddFieldsRange(new List<Field>
{
new Field {Name = "(select [Settings].[ProductColorsToString]([Product].[ProductID])) as Colors"},
new Field {Name = string.Format("(select max ({0}) - min ({0}) from catalog.offer where offer.productid=product.productid) as MultiPrices", _priceField)},
new Field {Name = string.Format("(select min ({0}) from catalog.offer where offer.productid=product.productid) as Price", _priceField)},
});
}
else
{
_paging.AddFieldsRange(new List<Field>
{
new Field {Name = "null as Colors"},
new Field {Name = "0 as MultiPrices"},
new Field
{
Name = SettingsCatalog.UseLastPrice
? string.Format("(CASE WHEN ProductPrice IS NULL THEN {0} ELSE ProductPrice END) as Price", _priceField)
: string.Format("{0} as Price", _priceField)
},
});
}
_paging.AddParam(new SqlParam { ParameterName = "@CustomerId", Value = CustomerSession.CustomerId.ToString() });
_paging.AddParam(new SqlParam { ParameterName = "@Type", Value = PhotoType.Product.ToString() });
ProductsCount = Indepth ? Category.TotalProductsCount : Category.GetProductCount();
categoryView.CategoryID = _categoryId;
categoryView.Visible = Category.DisplayStyle == "True" || ProductsCount == 0;
pnlSort.Visible = ProductsCount > 0;
productView.Visible = ProductsCount > 0;
catalogView.CategoryID = _categoryId;
filterProperty.CategoryId = _categoryId;
filterBrand.CategoryId = _categoryId;
filterBrand.InDepth = Indepth;
filterSize.CategoryId = _categoryId;
filterSize.InDepth = Indepth;
filterColor.CategoryId = _categoryId;
filterColor.InDepth = Indepth;
filterPrice.CategoryId = _categoryId;
filterPrice.InDepth = Indepth;
filterPrice.PriceType = CustomerSession.CurrentCustomer.PriceType;
lblCategoryName.Text = _categoryId != 0 ? Category.Name : Resource.Client_MasterPage_Catalog;
breadCrumbs.Items =
CategoryService.GetParentCategories(_categoryId).Select(parent => new BreadCrumbs
{
Name = parent.Name,
Url = UrlService.GetLink(ParamType.Category, parent.UrlPath, parent.CategoryId)
}).Reverse().ToList();
breadCrumbs.Items.Insert(0, new BreadCrumbs
{
Name = Resource.Client_MasterPage_MainPage,
Url = UrlService.GetAbsoluteLink("/")
});
var categoryMeta = SetMeta(Category.Meta, Category.Name, page: paging.CurrentPage);
lblCategoryName.Text = categoryMeta.H1;
if (Category.DisplayChildProducts || Indepth)
{
var cfilter = new InChildCategoriesFieldFilter
{
CategoryId = _categoryId.ToString(),
ParamName = "@CategoryID"
};
_paging.Fields["[ProductCategories].[CategoryID]"].Filter = cfilter;
}
else
{
var cfilter = new EqualFieldFilter { Value = _categoryId.ToString(), ParamName = "@catalog" };
_paging.Fields["[ProductCategories].[CategoryID]"].Filter = cfilter;
}
_paging.Fields["Enabled"].Filter = new EqualFieldFilter { Value = "1", ParamName = "@enabled" };
_paging.Fields["CategoryEnabled"].Filter = new EqualFieldFilter { Value = "1", ParamName = "@CategoryEnabled" };
var logicalFilter = new LogicalFilter{ ParamName = "@Main", HideInCustomData = true };
logicalFilter.AddFilter(new EqualFieldFilter {Value = "1", ParamName = "@Main1", HideInCustomData = true});
logicalFilter.AddLogicalOperation("OR");
logicalFilter.AddFilter(new NullFieldFilter { Null = true, ParamName = "@Main2", HideInCustomData = true });
_paging.Fields["Offer.Main"].Filter = logicalFilter;
BuildSorting();
BuildFilter();
}
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)
{
_paging = new SqlPaging
{
TableName =
"[Catalog].[Product] LEFT JOIN [Catalog].[Offer] ON [Product].[ProductID] = [Offer].[ProductID] inner join Catalog.ProductCategories on ProductCategories.ProductId = [Product].[ProductID] Left JOIN [Catalog].[ProductPropertyValue] ON [Product].[ProductID] = [ProductPropertyValue].[ProductID] LEFT JOIN [Catalog].[ShoppingCart] ON [Catalog].[ShoppingCart].[OfferID] = [Catalog].[Offer].[OfferID] AND [Catalog].[ShoppingCart].[ShoppingCartType] = 3 AND [ShoppingCart].[CustomerID] = @CustomerId Left JOIN [Catalog].[Ratio] on Product.ProductId= Ratio.ProductID and Ratio.CustomerId=@CustomerId"
};
_paging.AddFieldsRange(
new List <Field>
{
new Field {
Name = "[Product].[ProductID]", IsDistinct = true
},
//new Field {Name = "PhotoName AS Photo"},
new Field {
Name = "(CASE WHEN Offer.ColorID is not null THEN (Select Count(PhotoName) From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type) ELSE (Select Count(PhotoName) From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type) END) AS CountPhoto"
},
new Field {
Name = "(CASE WHEN Offer.ColorID is not null THEN (Select TOP(1) PhotoName From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type Order By main desc, [Photo].[PhotoSortOrder]) ELSE (Select TOP(1) PhotoName From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type AND [Photo].[Main] = 1) END) AS Photo"
},
new Field {
Name = "(CASE WHEN Offer.ColorID is not null THEN (Select TOP(1) [Photo].[Description] From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type Order By main desc, [Photo].[PhotoSortOrder]) ELSE (Select TOP(1) [Photo].[Description] From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type AND [Photo].[Main] = 1) END) AS PhotoDesc"
},
new Field {
Name = "(select [Settings].[ProductColorsToString]([Product].[ProductID])) as Colors"
},
//new Field {Name = "[Photo].[Description] AS PhotoDesc"},
new Field {
Name = "[ProductCategories].[CategoryID]", NotInQuery = true
},
new Field {
Name = "BriefDescription"
},
new Field {
Name = "Product.ArtNo"
},
new Field {
Name = "Name"
},
new Field {
Name = "(CASE WHEN Price=0 THEN 0 ELSE 1 END) as TempSort", Sorting = SortDirection.Descending
},
new Field {
Name = "Recomended"
},
new Field {
Name = "Bestseller"
},
new Field {
Name = "New"
},
new Field {
Name = "OnSale"
},
new Field {
Name = "Discount"
},
new Field {
Name = "Offer.Main", NotInQuery = true
},
new Field {
Name = "Offer.OfferID"
},
new Field {
Name = "Offer.Amount"
},
new Field {
Name = "(CASE WHEN Offer.Amount=0 OR Offer.Amount < IsNull(MinAmount,0) THEN 0 ELSE 1 END) as TempAmountSort", Sorting = SortDirection.Descending
},
new Field {
Name = "MinAmount"
},
new Field {
Name = "MaxAmount"
},
new Field {
Name = "Enabled"
},
new Field {
Name = "AllowPreOrder"
},
new Field {
Name = "Ratio"
},
new Field {
Name = "RatioID"
},
new Field {
Name = "DateModified"
},
new Field {
Name = "ShoppingCartItemId"
},
new Field {
Name = "UrlPath"
},
new Field {
Name = "[ProductCategories].[SortOrder]"
},
new Field {
Name = "[ShoppingCart].[CustomerID]", NotInQuery = true
},
new Field {
Name = "BrandID", NotInQuery = true
},
new Field {
Name = "Offer.ProductID as Size_ProductID", NotInQuery = true
},
new Field {
Name = "Offer.ProductID as Color_ProductID", NotInQuery = true
},
new Field {
Name = "Offer.ProductID as Price_ProductID", NotInQuery = true
},
new Field {
Name = "Offer.ColorID"
},
new Field {
Name = "CategoryEnabled", NotInQuery = true
},
});
if (SettingsCatalog.ComplexFilter)
{
_paging.AddFieldsRange(new List <Field>
{
new Field {
Name = "(select max (price) - min (price) from catalog.offer where offer.productid=product.productid) as MultiPrices"
},
new Field {
Name = "(select min (price) from catalog.offer where offer.productid=product.productid) as Price"
},
});
}
else
{
_paging.AddFieldsRange(new List <Field>
{
new Field {
Name = "0 as MultiPrices"
},
new Field {
Name = "Price"
},
});
}
_paging.AddParam(new SqlParam {
ParameterName = "@CustomerId", Value = CustomerContext.CustomerId.ToString()
});
_paging.AddParam(new SqlParam {
ParameterName = "@Type", Value = PhotoType.Product.ToString()
});
if (string.IsNullOrEmpty(Request["categoryid"]) || !Int32.TryParse(Request["categoryid"], out _categoryId))
{
_categoryId = 0;
var sbMainPage = StaticBlockService.GetPagePartByKeyWithCache("MainPageSocial");
if (sbMainPage != null && sbMainPage.Enabled)
{
MainPageText = sbMainPage.Content;
}
}
if (!string.IsNullOrEmpty(MainPageText))
{
SetMeta(null, string.Empty);
return;
}
category = CategoryService.GetCategory(_categoryId);
if (category == null || category.Enabled == false || category.ParentsEnabled == false)
{
Error404();
return;
}
ProductsCount = category.GetProductCount();
categoryView.CategoryID = _categoryId;
categoryView.Visible = true;
pnlSort.Visible = ProductsCount > 0;
productView.Visible = ProductsCount > 0;
lblCategoryName.Text = _categoryId != 0 ? category.Name : Resource.Client_MasterPage_Catalog;
//lblCategoryDescription.Text = category.Description;
//imgCategoryImage.ImageUrl = string.IsNullOrEmpty(category.Picture) ? "" : string.Format("{0}", ImageFolders.GetImageCategoryPath(false, category.Picture));
breadCrumbs.Items =
CategoryService.GetParentCategories(_categoryId).Select(parent => new BreadCrumbs
{
Name = parent.Name,
Url = "social/catalogsocial.aspx?categoryid=" + parent.CategoryId
}).Reverse().ToList();
breadCrumbs.Items.Insert(0, new BreadCrumbs
{
Name = Resource.Client_MasterPage_MainPage,
Url = UrlService.GetAbsoluteLink("social/catalogsocial.aspx")
});
SetMeta(category.Meta, category.Name);
if (category.DisplayChildProducts)
{
var cfilter = new InChildCategoriesFieldFilter
{
CategoryId = _categoryId.ToString(),
ParamName = "@CategoryID"
};
_paging.Fields["[ProductCategories].[CategoryID]"].Filter = cfilter;
}
else
{
var cfilter = new EqualFieldFilter {
Value = _categoryId.ToString(), ParamName = "@catalog"
};
_paging.Fields["[ProductCategories].[CategoryID]"].Filter = cfilter;
}
_paging.Fields["Enabled"].Filter = new EqualFieldFilter {
Value = "1", ParamName = "@enabled"
};;
_paging.Fields["CategoryEnabled"].Filter = new EqualFieldFilter {
Value = "1", ParamName = "@CategoryEnabled"
};
var logicalFilter = new LogicalFilter {
ParamName = "@Main", HideInCustomData = true
};
logicalFilter.AddFilter(new EqualFieldFilter {
Value = "1", ParamName = "@Main1", HideInCustomData = true
});
logicalFilter.AddLogicalOperation("OR");
logicalFilter.AddFilter(new NullFieldFilter {
Null = true, ParamName = "@Main2", HideInCustomData = true
});
_paging.Fields["Offer.Main"].Filter = logicalFilter;
BuildSorting();
}
protected void Page_Load(object sender, EventArgs e)
{
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resources.Resource.Admin_Brands_Header));
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Catalog].[Brand] left join Catalog.Photo on Photo.ObjId = Brand.BrandID and Type = @Type ",
ItemsPerPage = 10
};
_paging.AddFieldsRange(new List <Field>
{
new Field
{
Name = "BrandID as ID",
IsDistinct = true
},
new Field {
Name = "ProductsCount", SelectExpression = "(Select Count(ProductID) from Catalog.Product Where Product.BrandID=Brand.BrandID) as ProductsCount"
},
new Field {
Name = "PhotoName as BrandLogo"
},
new Field {
Name = "Enabled"
},
new Field {
Name = "SortOrder", Sorting = SortDirection.Ascending
},
new Field {
Name = "BrandName", Sorting = SortDirection.Ascending
}
});
_paging.AddParam(new SqlParam {
Value = PhotoType.Brand.ToString(), ParameterName = "@Type"
});
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
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)
{
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)
{
_priceField = CustomerSession.CurrentCustomer.PriceType.ToString();
_paging = new SqlPaging
{
TableName =
"[Catalog].[Product] " +
"LEFT JOIN [Catalog].[Offer] ON [Product].[ProductID] = [Offer].[ProductID] and [Offer].Main = 1 " +
"LEFT JOIN [Catalog].[ShoppingCart] ON [Catalog].[ShoppingCart].[OfferID] = [Catalog].[Offer].[OfferID] AND [Catalog].[ShoppingCart].[ShoppingCartType] = 3 AND [ShoppingCart].[CustomerID] = @CustomerId " +
"Left JOIN [Catalog].[Ratio] on Product.ProductId= Ratio.ProductID and Ratio.CustomerId=@CustomerId " +
"LEFT JOIN [Customers].[LastPrice] ON [LastPrice].[ProductId] = [Product].[ProductId] AND [LastPrice].[CustomerId] = @CustomerId"
};
_paging.AddFieldsRange(
new List<Field>()
{
new Field {Name = "[Product].[ProductID] as ProductID", IsDistinct = true},
new Field {Name = "null AS AdditionalPhoto"},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select Count(PhotoName) From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type) ELSE (Select Count(PhotoName) From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type) END) AS CountPhoto"},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select TOP(1) PhotoName From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type Order By main desc, [Photo].[PhotoSortOrder]) ELSE (Select TOP(1) PhotoName From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type AND [Photo].[Main] = 1) END) AS Photo"},
new Field {Name = "(CASE WHEN Offer.ColorID is not null THEN (Select TOP(1) [Photo].[Description] From [Catalog].[Photo] WHERE ([Photo].ColorID = Offer.ColorID or [Photo].ColorID is null) and [Product].[ProductID] = [Photo].[ObjId] and Type=@Type Order By main desc, [Photo].[PhotoSortOrder]) ELSE (Select TOP(1) [Photo].[Description] From [Catalog].[Photo] WHERE [Product].[ProductID] = [Photo].[ObjId] and Type=@Type AND [Photo].[Main] = 1) END) AS PhotoDesc"},
new Field {Name = "BriefDescription"},
new Field {Name = "Product.ArtNo"},
new Field {Name = "Name"},
new Field
{
Name = SettingsCatalog.UseLastPrice
? string.Format("(CASE WHEN ProductPrice IS NULL THEN {0} ELSE ProductPrice END) as Price", _priceField)
: string.Format("{0} as Price", _priceField)
},
new Field {Name = string.Format("{0} - {0}*discount/100 as discountPrice", _priceField), NotInQuery = true},
new Field {Name = "0 as MultiPrices"},
new Field {Name = "Recomended"},
new Field {Name = "New"},
new Field {Name = "Bestseller"},
new Field {Name = "OnSale"},
new Field {Name = "Discount"},
new Field {Name = "UrlPath"},
new Field {Name = "[Offer].Amount"},
new Field {Name = "Offer.Main", NotInQuery = true},
new Field {Name = "Offer.OfferID"},
new Field {Name = "MinAmount"},
new Field {Name = "MaxAmount"},
new Field {Name = "Multiplicity"},
new Field {Name = "Enabled"},
new Field {Name = "ShoppingCartItemId"},
new Field {Name = "AllowPreOrder"},
new Field {Name = "Ratio"},
new Field {Name = "RatioID"},
new Field {Name = "DateModified"},
new Field {Name = "[ShoppingCart].[CustomerID]", NotInQuery = true},
new Field {Name = "BrandID", NotInQuery = true},
new Field {Name = "CategoryEnabled", NotInQuery = true},
new Field {Name = "Offer.ColorID as ColorID"},
new Field
{
Name = "(select [Settings].[ProductColorsToString]([Product].[ProductID])) as Colors"
}
});
_paging.AddParam(new SqlParam { ParameterName = "@CustomerId", Value = CustomerSession.CustomerId.ToString() });
_paging.AddParam(new SqlParam { ParameterName = "@Type", Value = PhotoType.Product.ToString() });
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;
_paging.Fields["CategoryEnabled"].Filter = new EqualFieldFilter
{
Value = "1",
ParamName = "@CategoryEnabled"
};
_paging.Fields["Enabled"].Filter = new EqualFieldFilter {Value = "1", ParamName = "@Enabled"};
if (_typeFlag == ProductOnMain.TypeFlag.Bestseller)
{
var filterB = new EqualFieldFilter {ParamName = "@Bestseller", Value = "1"};
_paging.Fields["Bestseller"].Filter = filterB;
_paging.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"};
_paging.Fields["New"].Filter = filterN;
_paging.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"};
_paging.Fields["Discount"].Filter = filterN;
_paging.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();
}
