protected void btnFilter_Click(object sender, EventArgs e)
{
//-----Selection filter
if (ddSelect.SelectedIndex != 0)
{
if (ddSelect.SelectedIndex == 2)
{
if (_selectionFilter != null)
{
_selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
}
else
{
_selectionFilter = null;
}
}
_paging.Fields["ID"].Filter = _selectionFilter;
}
else
{
_paging.Fields["ID"].Filter = _selectionFilter;
}
if (!string.IsNullOrEmpty(txtProductName.Text.Trim()))
{
var nfilter = new CompareFieldFilter {
Expression = txtProductName.Text, ParamName = "@ProductName"
};
_paging.Fields["ProductName"].Filter = nfilter;
}
else
{
_paging.Fields["ProductName"].Filter = null;
}
if (!string.IsNullOrEmpty(txtUserName.Text.Trim()))
{
var nfilter = new CompareFieldFilter {
Expression = txtUserName.Text, ParamName = "@FLName"
};
_paging.Fields["UserName"].Filter = nfilter;
}
else
{
_paging.Fields["UserName"].Filter = null;
}
if (!string.IsNullOrEmpty(txtEmail.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtEmail.Text, ParamName = "@Email"
};
_paging.Fields["Email"].Filter = nfilter;
}
else
{
_paging.Fields["Email"].Filter = null;
}
if (!string.IsNullOrEmpty(txtPhone.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtPhone.Text, ParamName = "@Phone"
};
_paging.Fields["Phone"].Filter = nfilter;
}
else
{
_paging.Fields["Phone"].Filter = null;
}
if (ddlIsComplete.SelectedIndex != 0)
{
var isCompleteFilter = new EqualFieldFilter {
ParamName = "@IsComplete"
};
if (ddlIsComplete.SelectedIndex == 1)
{
isCompleteFilter.Value = "1";
}
if (ddlIsComplete.SelectedIndex == 2)
{
isCompleteFilter.Value = "0";
}
_paging.Fields["IsComplete"].Filter = isCompleteFilter;
}
else
{
_paging.Fields["IsComplete"].Filter = null;
}
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Properties_ListPropreties);
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Catalog].[Property]",
ItemsPerPage = 20,
CurrentPageIndex = 1
};
_paging.AddFieldsRange(new[]
{
new Field {
Name = "PropertyID as ID", IsDistinct = true
},
new Field {
Name = "Name"
},
new Field {
Name = "UseInFilter"
},
new Field {
Name = "SortOrder", Sorting = SortDirection.Ascending
},
new Field {
Name = "(Select Count(ProductID) from Catalog.ProductPropertyValue Where [PropertyValueID] in ( SELECT [PropertyValueID] FROM [Catalog].[PropertyValue] WHERE [PropertyID] = [Property].PropertyID)) as ProductsCount"
},
});
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
pageNumberer.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString(CultureInfo.InvariantCulture);
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
}
}
}
protected void btnFilter_Click(object sender, EventArgs e)
{
//-----Selection filter
if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "0") != 0)
{
if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "2") == 0)
{
if (_selectionFilter != null)
{
_selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
}
else
{
_selectionFilter = null;
}
}
_paging.Fields["ID"].Filter = _selectionFilter;
}
else
{
_paging.Fields["ID"].Filter = null;
}
//----Name filter
if (!string.IsNullOrEmpty(txtName.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtName.Text, ParamName = "@Name"
};
_paging.Fields["Name"].Filter = nfilter;
}
else
{
_paging.Fields["Name"].Filter = null;
}
//----RegNumber filter
if (!string.IsNullOrEmpty(txtRegNumber.Text))
{
var nfilter = new CompareFieldFilter
{
Expression = txtRegNumber.Text,
ParamName = "@RegNumber"
};
_paging.Fields["RegNumber"].Filter = nfilter;
}
else
{
_paging.Fields["RegNumber"].Filter = null;
}
//----Country filter
if (ddlCountryFilter.SelectedIndex != 0)
{
var nfilter = new CompareFieldFilter
{
Expression = ddlCountryFilter.SelectedItem.Text,
ParamName = "@Country"
};
_paging.Fields["CountryName"].Filter = nfilter;
}
else
{
_paging.Fields["CountryName"].Filter = null;
}
//----Enabled filter
if (ddlEnabled.SelectedIndex != 0)
{
var efilter = new EqualFieldFilter {
ParamName = "@Enabled"
};
if (ddlEnabled.SelectedIndex == 1)
{
efilter.Value = "1";
}
if (ddlEnabled.SelectedIndex == 2)
{
efilter.Value = "0";
}
_paging.Fields["Enabled"].Filter = efilter;
}
else
{
_paging.Fields["Enabled"].Filter = null;
}
pageNumberer.CurrentPageIndex = 1;
}
//public event Action<object, PhotoMessageEventArgs> PhotoMessage;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
_paging = new SqlPaging {
TableName = "[Catalog].[Photo]", ItemsPerPage = 10
};
var f = new Field {
Name = "PhotoID as ID", IsDistinct = true, Filter = _selectionFilter
};
_paging.AddField(f);
f = new Field
{
Name = "ObjId",
Filter = new EqualFieldFilter
{
ParamName = "@ObjId",
Value = ProductID.ToString()
}
};
_paging.AddField(f);
f = new Field {
Name = "PhotoName"
};
_paging.AddField(f);
f = new Field {
Name = "Description"
};
_paging.AddField(f);
f = new Field {
Name = "PhotoSortOrder", Sorting = SortDirection.Ascending
};
_paging.AddField(f);
f = new Field {
Name = "Main"
};
_paging.AddField(f);
f = new Field {
Name = "convert(nvarchar, isnull(ColorID, 0)) as ColorID"
};
_paging.AddField(f);
f = new Field {
Name = "Type", NotInQuery = true, Filter = new EqualFieldFilter {
ParamName = "@Type", Value = PhotoType.Product.ToString()
}
};
_paging.AddField(f);
grid.ChangeHeaderImageUrl("arrowPhotoSortOrder", "~/admin/images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString();
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
//_InverseSelection = If(ids(0) = -1, True, False)
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, Resource.Admin_MasterPageAdminCatalog_Catalog);
if (string.IsNullOrEmpty(ModuleName))
{
Response.Redirect("ExportFeed.aspx?ModuleId=YandexMarket");
return;
}
if (!string.IsNullOrEmpty(Request["CatId"]))
{
Int32.TryParse(Request["CatId"], out _catId);
}
Category cat = CategoryService.GetCategory(_catId);
if (cat != null)
{
lblCategoryName.Text = cat.Name;
sn.BuildNavigationAdmin(_catId);
}
if (!Page.IsPostBack)
{
var flag = ExportFeedService.CheakCategoryHierical(ModuleName, _catId);
pnlCategorySet.Enabled = !flag;
chbFull.Checked = ExportFeedService.CheakCategory(ModuleName, _catId);
pnlData.Enabled = !chbFull.Checked && !flag;
}
PageSubheader.Visible = true;
ModuleNameLiteral.Text = ModuleName;
if (!IsPostBack)
{
var node2 = new TreeNode {
Text = SelectCategory(0, ModuleName, Resource.Admin_m_Category_Root), Value = "0", Selected = true, NavigateUrl = ExportFeedNew + "?moduleid=" + ModuleName
};
tree2.Nodes.Add(node2);
LoadChildCategories2(tree2.Nodes[0]);
_paging = new SqlPaging
{
TableName = "[Catalog].[Product] left JOIN [Catalog].[Offer] ON [Product].[ProductID] = [Offer].[ProductID] AND [OfferListId]=6 INNER JOIN Catalog.ProductCategories on ProductCategories.ProductId = [Product].[ProductID] and Main=1",
ItemsPerPage = 100
};
var f = new Field {
Name = "Product.ProductId as ID", IsDistinct = true
};
_paging.AddField(f);
f = new Field {
Name = "ArtNo"
};
_paging.AddField(f);
f = new Field {
Name = "Name"
};
_paging.AddField(f);
f = new Field {
Name = "(Select count(*) from Settings.ExportFeedSelectedProducts where ModuleName=@ModuleName and ExportFeedSelectedProducts.ProductID=Product.ProductId) as Cheaked"
};
_paging.AddField(f);
var pf = new EqualFieldFilter {
Value = _catId.ToString(), ParamName = "@Parent"
};
f = new Field {
Name = "CategoryId", Filter = pf
};
_paging.AddField(f);
f = new Field {
Name = "SortOrder", Sorting = SortDirection.Ascending
};
_paging.AddField(f);
_paging.AddParam(new SqlParam {
ParamName = "@ModuleName", ParamValue = ModuleName
});
_paging.ExtensionWhere = "and Offer.Price > 0 and (Offer.Amount > 0 or Product.OrderByRequest=1) and HirecalEnabled=1 and Enabled=1";
grid.ChangeHeaderImageUrl("arrowName", "images/arrowup.gif");
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString();
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_ColorsDictionary_Header));
MsgError();
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Catalog].[Color] left join Catalog.Photo on Photo.ObjId=Color.ColorID and type='color'",
ItemsPerPage = 20,
CurrentPageIndex = 1
};
_paging.AddFieldsRange(new[]
{
new Field {
Name = "Color.ColorID as ID", IsDistinct = true
},
new Field {
Name = "ColorName"
},
new Field {
Name = "ColorCode"
},
new Field {
Name = "PhotoName"
},
new Field {
Name = "SortOrder", Sorting = SortDirection.Ascending
}
});
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
pageNumberer.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString(CultureInfo.InvariantCulture);
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
}
}
}
protected void btnFilter_Click(object sender, EventArgs e)
{
//-----Selection filter
if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "0") != 0)
{
if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "2") == 0)
{
if (_selectionFilter != null)
{
_selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
}
else
{
_selectionFilter = null; //New InSetFieldFilter()
//_SelectionFilter.IncludeValues = True
}
}
_paging.Fields["ID"].Filter = _selectionFilter;
}
else
{
_paging.Fields["ID"].Filter = null;
}
//----Id filter
if (!string.IsNullOrEmpty(txtId.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtId.Text, ParamName = "@id"
};
_paging.Fields["ID"].Filter = nfilter;
}
else
{
_paging.Fields["ID"].Filter = null;
}
//---RedirectFrom filter
if (!string.IsNullOrEmpty(txtRedirectFrom.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtRedirectFrom.Text, ParamName = "@RedirectFrom"
};
_paging.Fields["RedirectFrom"].Filter = nfilter;
}
else
{
_paging.Fields["RedirectFrom"].Filter = null;
}
//---RedirectTo filter
if (!string.IsNullOrEmpty(txtRedirectTo.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtRedirectTo.Text, ParamName = "@RedirectTo"
};
_paging.Fields["RedirectTo"].Filter = nfilter;
}
else
{
_paging.Fields["RedirectTo"].Filter = null;
}
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_MailFormat_Header);
if (!IsPostBack)
{
_paging = new SqlPaging {
TableName = "Settings.MailFormat", ItemsPerPage = 10
};
var f = new Field {
Name = "MailFormatID as ID", IsDistinct = true
};
_paging.AddField(f);
f = new Field {
Name = "FormatName"
};
_paging.AddField(f);
f = new Field {
Name = "FormatType"
};
_paging.AddField(f);
f = new Field {
Name = "SortOrder", Sorting = SortDirection.Ascending
};
_paging.AddField(f);
f = new Field {
Name = "Enable"
};
_paging.AddField(f);
f = new Field {
Name = "AddDate"
};
_paging.AddField(f);
f = new Field {
Name = "ModifyDate"
};
_paging.AddField(f);
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblError.Text = string.Empty;
lblError.Visible = false;
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Properties_ListPropreties);
if (!IsPostBack)
{
_paging = new SqlPaging {
TableName = "[Settings].[NewsCategory]"
};
_paging.AddFieldsRange(new List <Field>
{
new Field {
Name = "NewsCategoryID as ID", IsDistinct = true
},
new Field {
Name = "Name"
},
new Field {
Name = "SortOrder", Sorting = SortDirection.Ascending
},
new Field {
Name = "UrlPath"
},
});
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString();
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
//_InverseSelection = If(ids(0) = -1, True, False)
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_CertificateAdmin_Header));
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Order].[Certificate] INNER JOIN [Order].[Order] ON [Order].[OrderID] = [Certificate].[OrderID] INNER JOIN [Order].[OrderCurrency] ON [OrderCurrency].[OrderID] = [Certificate].[OrderID]",
ItemsPerPage = 10
};
_paging.AddFieldsRange(new List <Field>
{
new Field
{
Name = "CertificateID as ID",
IsDistinct = true
},
new Field {
Name = "[Certificate].CertificateCode as CertificateCode"
},
new Field {
Name = "[Certificate].ApplyOrderNumber as ApplyOrderNumber"
},
new Field {
Name = "[Certificate].OrderId as OrderId"
},
new Field {
Name = "[Certificate].Sum as Sum"
},
new Field {
Name = "[Certificate].Used as Used"
},
new Field {
Name = "[Certificate].Enable as Enable"
},
new Field {
Name = "[Certificate].CreationDate as CreationDate", Sorting = SortDirection.Descending
},
//OrderCurrency
new Field {
Name = "[OrderCurrency].CurrencyValue as CurrencyValue"
},
new Field {
Name = "[OrderCurrency].CurrencyCode as CurrencyCode"
},
//Order
new Field {
Name = "[Order].PaymentDate as PaymentDate"
},
//new Field {Name = "[Order].PaymentDate is null as Paid"}
});
grid.ChangeHeaderImageUrl("arrowCreationDate", "images/arrowdown.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void btnFilter_Click(object sender, EventArgs e)
{
//-----Selection filter
if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "0") != 0)
{
if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "2") == 0)
{
if (_selectionFilter != null)
{
_selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
}
else
{
_selectionFilter = null; //New InSetFieldFilter()
//_SelectionFilter.IncludeValues = True
}
}
_paging.Fields["ID"].Filter = _selectionFilter;
}
else
{
_paging.Fields["ID"].Filter = null;
}
//----Name filter
_paging.Fields["FormatName"].Filter = !string.IsNullOrEmpty(txtName.Text) ? new CompareFieldFilter {
Expression = txtName.Text, ParamName = "@Name"
} : null;
//----Enabled filter
if (ddluseInFilter.SelectedIndex != 0)
{
var efilter = new EqualFieldFilter {
ParamName = "@Enable"
};
if (ddluseInFilter.SelectedIndex == 1)
{
efilter.Value = "1";
}
if (ddluseInFilter.SelectedIndex == 2)
{
efilter.Value = "0";
}
_paging.Fields["Enable"].Filter = efilter;
}
else
{
_paging.Fields["Enable"].Filter = null;
}
//----sort filter
_paging.Fields["SortOrder"].Filter = !string.IsNullOrEmpty(txtSortOrder.Text) ? new CompareFieldFilter {
Expression = txtSortOrder.Text, ParamName = "@sort"
} : null;
_paging.Fields["FormatType"].Filter = ddlFormatType.SelectedValue != "0"
? new EqualFieldFilter
{
ParamName = "@FormatType",
Value = ddlFormatType.SelectedValue
}
: null;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
}
protected void Page_Load(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(Request["countryid"]))
{
Response.Redirect("Country.aspx");
}
var country = CountryService.GetCountry(CountryId);
if (country == null)
{
Response.Redirect("Country.aspx");
}
else
{
lblHead.Text = country.Name;
hlBack.NavigateUrl = "Country.aspx";
hlAllCities.NavigateUrl = "Cities.aspx?countryid=" + country.CountryId;
}
if (!IsPostBack)
{
_paging = new SqlPaging {
TableName = "[Customers].[Region]", ItemsPerPage = 20
};
_paging.AddFieldsRange(
new List <Field>
{
new Field {
Name = "RegionID as ID", IsDistinct = true
},
new Field {
Name = "RegionName", Sorting = SortDirection.Ascending
},
new Field {
Name = "RegionCode"
},
new Field {
Name = "RegionSort"
},
new Field
{
Name = "CountryID",
Filter = new EqualFieldFilter()
{
ParamName = "@CounrtyID", Value = CountryId.ToString()
}
}
});
grid.ChangeHeaderImageUrl("arrowRegionName", "images/arrowup.gif");
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString(CultureInfo.InvariantCulture);
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
}
}
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resources.Resource.Admin_Regions_Header));
}
protected void btnFilter_Click(object sender, EventArgs e)
{
//-----Selection filter
if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "0") != 0)
{
if (String.CompareOrdinal(ddSelect.SelectedIndex.ToString(CultureInfo.InvariantCulture), "2") == 0)
{
if (_selectionFilter != null)
{
_selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
}
else
{
_selectionFilter = null;
}
}
_paging.Fields["ID"].Filter = _selectionFilter;
}
else
{
_paging.Fields["ID"].Filter = null;
}
//----Name filter
if (!string.IsNullOrEmpty(txtName.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtName.Text, ParamName = "@Name"
};
_paging.Fields["RegionName"].Filter = nfilter;
}
else
{
_paging.Fields["RegionName"].Filter = null;
}
//--RegionCode filter
if (!string.IsNullOrEmpty(txtRegNumber.Text))
{
var nfilter = new CompareFieldFilter
{
Expression = txtRegNumber.Text,
ParamName = "@RegionCode"
};
_paging.Fields["RegionCode"].Filter = nfilter;
}
else
{
_paging.Fields["RegionCode"].Filter = null;
}
//---RegionSort filter
if (!string.IsNullOrEmpty(txtRegSort.Text))
{
var nfilter = new CompareFieldFilter
{
Expression = txtRegSort.Text,
ParamName = "@RegionSort"
};
_paging.Fields["RegionSort"].Filter = nfilter;
}
else
{
_paging.Fields["RegionSort"].Filter = null;
}
pageNumberer.CurrentPageIndex = 1;
}
protected void Page_Load(object sender, EventArgs e)
{
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_OrderByRequest_Header));
if (!IsPostBack)
{
_paging = new SqlPaging {
TableName = "[Order].[OrderByRequest]", ItemsPerPage = 10
};
var f = new Field {
Name = "OrderByRequestID as ID", IsDistinct = true, Filter = _selectionFilter
};
_paging.AddField(f);
f = new Field {
Name = "ProductId"
};
_paging.AddField(f);
f = new Field {
Name = "ProductName"
};
_paging.AddField(f);
f = new Field {
Name = "UserName"
};
_paging.AddField(f);
f = new Field {
Name = "Email"
};
_paging.AddField(f);
f = new Field {
Name = "Phone"
};
_paging.AddField(f);
f = new Field {
Name = "IsComplete"
};
_paging.AddField(f);
f = new Field {
Name = "RequestDate", Sorting = SortDirection.Descending
};
_paging.AddField(f);
grid.ChangeHeaderImageUrl("arrowRequestDate", "images/arrowdown.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
int t;
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString(CultureInfo.InvariantCulture);
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
var strIds = Request.Form["SelectedIds"];
string[] ids;
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
var t = arrids[idx];
if (t != "-1")
{
ids[idx] = t;
}
else
{
_selectionFilter.IncludeValues = false;
}
}
_selectionFilter.Values = ids;
}
if (!IsPostBack)
{
// load modalpopup for contact
_paging = new SqlPaging {
TableName = "[Customers].[Customer]", ItemsPerPage = 10
};
var f = new Field {
Name = "CustomerID", IsDistinct = true
};
_paging.AddField(f);
f = new Field {
Name = "Email"
};
_paging.AddField(f);
f = new Field {
Name = "Firstname", Sorting = SortDirection.Ascending
};
_paging.AddField(f);
f = new Field {
Name = "Lastname"
};
_paging.AddField(f);
agvCustomers.ChangeHeaderImageUrl("arrowFirstname", UrlService.GetAdminAbsoluteLink("images/arrowup.gif"));
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
ViewState["Show"] = false;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
if (!string.IsNullOrEmpty(hfSelectedCustomer.Value))
{
SelectedCustomers = new List <Guid> {
new Guid(hfSelectedCustomer.Value)
};
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
btnAdd.OnClientClick = "javascript:open_window('m_ProductVideos.aspx?ProductID=" + ProductID + "',780,600);return false;";
if (!IsPostBack)
{
_paging = new SqlPaging {
TableName = "[Catalog].[ProductVideo]", ItemsPerPage = 10
};
var f = new Field {
Name = "ProductVideoID", IsDistinct = true, Filter = _selectionFilter
};
_paging.AddField(f);
f = new Field
{
Name = "ProductID",
Filter = new EqualFieldFilter
{
ParamName = "@productID",
Value = ProductID.ToString()
}
};
_paging.AddField(f);
f = new Field {
Name = "Name"
};
_paging.AddField(f);
f = new Field {
Name = "VideoSortOrder", Sorting = SortDirection.Ascending
};
_paging.AddField(f);
grid_video.ChangeHeaderImageUrl("arrowVideoSortOrder", "~/admin/images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIdsVideo"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = -1;
int.TryParse(arrids[idx], out t);
if (t != -1)
{
ids[idx] = t.ToString();
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
//_InverseSelection = If(ids(0) = -1, True, False)
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_CertificateAdmin_Header);
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Catalog].[Certificate]",
ItemsPerPage = 10
};
_paging.AddFieldsRange(new List <Field>
{
new Field
{
Name = "CertificateID as ID",
IsDistinct = true
},
new Field {
Name = "CertificateCode"
},
new Field {
Name = "OrderNumber"
},
new Field {
Name = "Type"
},
new Field {
Name = "Sum"
},
new Field {
Name = "Used"
},
new Field {
Name = "Paid"
},
new Field {
Name = "Enable"
},
new Field {
Name = "CurrencyValue"
},
new Field {
Name = "CurrencyCode"
},
new Field {
Name = "CreationDate", Sorting = SortDirection.Descending
},
});
grid.ChangeHeaderImageUrl("arrowCreationDate", "images/arrowdown.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void btnFilter_Click(object sender, EventArgs e)
{
//-----Selection filter
if (ddSelect.SelectedIndex != 0)
{
if (ddSelect.SelectedIndex == 2)
{
if (_selectionFilter != null)
{
_selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
}
else
{
_selectionFilter = null;
}
}
_paging.Fields["ID"].Filter = _selectionFilter;
}
else
{
_paging.Fields["ID"].Filter = _selectionFilter;
}
//----Name filter
if (!string.IsNullOrEmpty(txtUrlFilter.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtUrlFilter.Text, ParamName = "@URL"
};
_paging.Fields["URL"].Filter = nfilter;
}
else
{
_paging.Fields["URL"].Filter = null;
}
//----CurrencyValue filter
if (!string.IsNullOrEmpty(txtSortOrder.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtSortOrder.Text, ParamName = "@SortOrder"
};
_paging.Fields["SortOrder"].Filter = nfilter;
}
else
{
_paging.Fields["SortOrder"].Filter = null;
}
if (ddlEnabled.SelectedIndex != 0)
{
var eFilter = new EqualFieldFilter {
ParamName = "@Enabled"
};
if (ddlEnabled.SelectedIndex == 1)
{
eFilter.Value = "1";
}
if (ddlEnabled.SelectedIndex == 2)
{
eFilter.Value = "0";
}
_paging.Fields["Enabled"].Filter = eFilter;
}
else
{
_paging.Fields["Enabled"].Filter = null;
}
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
}
protected void Page_Load(object sender, EventArgs e)
{
Message.Visible = false;
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_OrderStatuses_OrderStatuses);
MsgErr(true);
if (!IsPostBack)
{
_paging = new SqlPaging {
TableName = "[Order].[OrderStatus]"
};
_paging.AddFieldsRange(
new Field("OrderStatusID as ID"),
new Field("StatusName")
{
Sorting = SortDirection.Ascending
},
new Field("IsDefault"),
new Field("Canceled"),
new Field("CommandID"));
grid.ChangeHeaderImageUrl("arrowStatusName", "images/arrowup.gif");
//pageNumberer.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
if (Request["productid"] != null)
{
_paging.Fields["ProductID"].Filter = new CompareFieldFilter
{
ParamName = "@ProductID",
Expression = Request["productid"]
};
}
}
else
{
_paging = (SqlPaging)ViewState["Paging"];
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw new Exception("Paging lost");
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
List <string> arrids = strIds.Trim().Split(' ').ToList();
if (arrids.Contains("-1"))
{
_inverseSelection = true;
arrids.Remove("-1");
}
int t;
_selectionFilter = new InSetFieldFilter
{
IncludeValues = !_inverseSelection,
Values = arrids.Where(id => int.TryParse(id, out t)).ToArray()
};
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Carousels_Header);
if (!IsPostBack)
{
_paging = new SqlPaging {
TableName = "[CMS].[Carousel] left join Catalog.Photo on Photo.ObjId=Carousel.CarouselID and Type=@Type", ItemsPerPage = 10
};
var f = new Field {
Name = "CarouselID as ID", IsDistinct = true, Filter = _selectionFilter
};
_paging.AddField(f);
f = new Field {
Name = "URL"
};
_paging.AddField(f);
f = new Field {
Name = "SortOrder", Sorting = SortDirection.Ascending
};
_paging.AddField(f);
f = new Field {
Name = "Enabled"
};
_paging.AddField(f);
f = new Field {
Name = "PhotoName"
};
_paging.AddField(f);
_paging.AddParam(new SqlParam {
ParamName = "@Type", ParamValue = PhotoType.Carousel.ToString()
});
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
txtSortedCarousel.Text = CarouselService.GetMaxSortOrder().ToString(CultureInfo.InvariantCulture);
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString();
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
//_InverseSelection = If(ids(0) = -1, True, False)
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
lblMes.Text = string.Empty;
SetMeta(string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, Resources.Resource.Admin_301Redirects_Header));
if (!IsPostBack)
{
chbEnabled301Redirect.Checked = AdvantShop.Configuration.SettingsSEO.Enabled301Redirects;
_paging = new SqlPaging {
TableName = "[Settings].[Redirect]", ItemsPerPage = 20
};
var f = new Field {
Name = "ID", IsDistinct = false, Sorting = SortDirection.Ascending
};
_paging.AddField(f);
f = new Field {
Name = "RedirectFrom"
};
_paging.AddField(f);
f = new Field {
Name = "RedirectTo"
};
_paging.AddField(f);
f = new Field {
Name = "ProductArtNo"
};
_paging.AddField(f);
grid.ChangeHeaderImageUrl("arrowID", "images/arrowup.gif");
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString();
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
//_InverseSelection = If(ids(0) = -1, True, False)
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Catalog].[ShoppingCart] as sc " +
"Left Join [Customers].[Customer] On [Customer].[CustomerID] = sc.[CustomerId]",
ExtensionWhere = "and [Customer].[CustomerID] is null",
ItemsPerPage = 30
};
_paging.AddFieldsRange(new List <Field>
{
new Field {
Name = "sc.[CustomerId]", IsDistinct = true
},
new Field {
Name = "ShoppingCartType"
},
new Field
{
Name = "(Select Top(1) OrderConfirmationData From [Order].[OrderConfirmation] " +
"Where [OrderConfirmation].[CustomerId] = sc.[CustomerId]) as OrderConfirmationData"
},
new Field
{
Name = "(Select Top(1) UpdatedOn From [Catalog].[ShoppingCart] " +
"Where [ShoppingCart].[CustomerId] = sc.[CustomerId] and ShoppingCartType = @CartType Order By UpdatedOn Desc) as LastUpdate",
Sorting = SortDirection.Descending
},
new Field
{
Name = "(Select SUM(Price * [ShoppingCart].[Amount]) " +
"From [Catalog].[ShoppingCart] " +
"Inner Join [Catalog].[Offer] On [Offer].[OfferID] = [ShoppingCart].[OfferId] " +
"Where [ShoppingCart].[CustomerID] = sc.CustomerId and ShoppingCartType = @CartType) As Sum"
},
new Field
{
Name = "(Select Count(*) From [Module].[AbandonedCartLetter] Where AbandonedCartLetter.CustomerId = sc.CustomerId) as SendingCount"
},
new Field
{
Name = "(Select Top(1)SendingDate From [Module].[AbandonedCartLetter] Where AbandonedCartLetter.CustomerId = sc.CustomerId Order By SendingDate Desc) as SendingDate"
},
});
_paging.Fields["ShoppingCartType"].Filter = new EqualFieldFilter()
{
ParamName = "@CartType",
Value = ((int)ShoppingCartType.ShoppingCart).ToString()
};
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
if (!IsPostBack)
{
ddlTemplate.Items.Clear();
ddlTemplate.Items.Add(new ListItem("не выбран", "-1"));
foreach (var template in AbandonedCartsService.GetTemplates())
{
ddlTemplate.Items.Add(new ListItem(template.Name, template.Id.ToString()));
}
}
}
protected void btnFilter_Click(object sender, EventArgs e)
{
//-----Selection filter
if (string.Compare(ddSelect.SelectedIndex.ToString(), "0") != 0)
{
if (string.Compare(ddSelect.SelectedIndex.ToString(), "2") == 0)
{
if (_selectionFilter != null)
{
_selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
}
else
{
_selectionFilter = null; //New InSetFieldFilter()
//_SelectionFilter.IncludeValues = True
}
}
_paging.Fields["ID"].Filter = _selectionFilter;
}
else
{
_paging.Fields["ID"].Filter = null;
}
if (!string.IsNullOrEmpty(txtArtNo.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtArtNo.Text, ParamName = "@ArtNo"
};
_paging.Fields["ArtNo"].Filter = nfilter;
}
else
{
_paging.Fields["Name"].Filter = null;
}
//----Name filter
if (!string.IsNullOrEmpty(txtName.Text))
{
var nfilter = new CompareFieldFilter {
Expression = txtName.Text, ParamName = "@Name"
};
_paging.Fields["Name"].Filter = nfilter;
}
else
{
_paging.Fields["Name"].Filter = null;
}
//---Sort filter
if (!string.IsNullOrEmpty(txtSort.Text))
{
var nfilter = new CompareFieldFilter
{
Expression = txtSort.Text,
ParamName = "@SortOrder"
};
_paging.Fields["SortOrder"].Filter = nfilter;
}
else
{
_paging.Fields["SortOrder"].Filter = null;
}
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Voting_Voting);
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[Voice].[VoiceTheme]",
ItemsPerPage = 10
};
_paging.AddFieldsRange(new List <Field>
{
new Field {
Name = "VoiceThemeID as ID", IsDistinct = true
},
new Field {
Name = "PsyID"
},
new Field {
Name = "Name", Sorting = SortDirection.Ascending
},
new Field {
Name = "IsDefault"
},
new Field {
Name = "IsHaveNullVoice"
},
new Field {
Name = "IsClose"
},
new Field {
Name = "DateAdded"
},
new Field {
Name = "DateModify"
},
new Field {
Name = "(SELECT COUNT(*) FROM [Voice].[Answer] WHERE [FKIDTheme] = VoiceThemeID) as AnswerCount"
}
});
grid.ChangeHeaderImageUrl("arrowName", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_CustomerGroup_Header));
if (!IsPostBack)
{
_paging = new SqlPaging {
TableName = "[Customers].[CustomerGroup]", ItemsPerPage = 10
};
var f = new Field {
Name = "CustomerGroupId as ID", IsDistinct = true, Filter = _selectionFilter
};
_paging.AddField(f);
f = new Field {
Name = "GroupName", Sorting = SortDirection.Ascending
};
_paging.AddField(f);
f = new Field {
Name = "GroupDiscount"
};
_paging.AddField(f);
grid.ChangeHeaderImageUrl("arrowGroupName", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString();
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
//_InverseSelection = If(ids(0) = -1, True, False)
}
}
}
protected void btnFilter_Click(object sender, EventArgs e)
{
//-----Selection filter
if (ddSelect.SelectedIndex != 0)
{
if (ddSelect.SelectedIndex == 2)
{
if (_selectionFilter != null)
{
_selectionFilter.IncludeValues = !_selectionFilter.IncludeValues;
}
else
{
_selectionFilter = null;
}
}
_paging.Fields["ID"].Filter = _selectionFilter;
}
else
{
_paging.Fields["ID"].Filter = null;
}
//----Email filter
_paging.Fields["Email"].Filter = !string.IsNullOrEmpty(txtEmail.Text)
? new CompareFieldFilter {
ParamName = "@Email", Expression = txtEmail.Text
}
: null;
//-- productName
_paging.Fields["Name"].Filter = !string.IsNullOrEmpty(txtName.Text)
? new CompareFieldFilter {
ParamName = "@Name", Expression = txtName.Text
}
: null;
//----Text filter
_paging.Fields["[Text]"].Filter = !string.IsNullOrEmpty(txtText.Text)
? new CompareFieldFilter {
ParamName = "@Text", Expression = txtText.Text
}
: null;
//----Checked filter
_paging.Fields["Checked"].Filter = ddlChecked.SelectedValue != "-1"
? new EqualFieldFilter {
ParamName = "@Checked", Value = ddlChecked.SelectedValue
}
: null;
//---AddDate filter
var dfilter = new DateTimeRangeFieldFilter {
ParamName = "@dateRewiews"
};
if (!string.IsNullOrEmpty(txtDateFrom.Text))
{
DateTime?d = default(DateTime?);
try
{
d = DateTime.Parse(txtDateFrom.Text);
}
catch (Exception ex)
{
//Debug.LogError(ex, sender, e);
Debug.LogError(ex);
}
if (d.HasValue)
{
var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 0, 0, 0, 0);
dfilter.From = dt;
}
}
if (!string.IsNullOrEmpty(txtDateTo.Text))
{
DateTime?d = default(DateTime?);
try
{
d = DateTime.Parse(txtDateTo.Text);
}
catch (Exception ex)
{
//Debug.LogError(ex, sender, e);
Debug.LogError(ex);
}
if (d.HasValue)
{
var dt = new DateTime(d.Value.Year, d.Value.Month, d.Value.Day, 23, 59, 59, 99);
dfilter.To = dt;
}
}
if (dfilter.From.HasValue | dfilter.To.HasValue)
{
_paging.Fields["AddDate"].Filter = dfilter;
}
else
{
_paging.Fields["AddDate"].Filter = null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_MenuManager_TopMenu);
Int32.TryParse(Request["menuid"], out _menuId);
_needReloadTree = Convert.ToBoolean(ViewState["updateTree"]);
hlEditCategory.Visible = _menuId > 0;
lblSeparator.Visible = _menuId > 0;
hlDeleteCategory.Visible = _menuId > 0;
if (!string.IsNullOrWhiteSpace(Request["type"]))
{
Enum.TryParse(Request["type"], true, out _menuType);
}
var menuitem = new AdvMenuItem();
switch (_menuType)
{
case MenuService.EMenuType.Top:
//_menuType = MenuService.EMenuType.Top;
menuitem = MenuService.GetMenuItemById(_menuId, _menuType);
lblHead.Text = menuitem == null
? Resource.Admin_MenuManager_TopMenu
: string.Format("{0} - {1}", Resource.Admin_MenuManager_TopMenu, menuitem.MenuItemName);
lblSubHead.Text = Resource.Admin_MenuManager_SubHeaderTop;
Page.Title = menuitem == null
? Resource.Admin_MenuManager_TopMenu
: string.Format("{0} - {1}", Resource.Admin_MenuManager_TopMenu, menuitem.MenuItemName);
break;
case MenuService.EMenuType.Bottom:
//_menuType = MenuService.EMenuType.Bottom;
menuitem = MenuService.GetMenuItemById(_menuId, _menuType);
lblHead.Text = menuitem == null
? Resource.Admin_MenuManager_BottomMenu
: string.Format("{0} - {1}", Resource.Admin_MenuManager_BottomMenu, menuitem.MenuItemName);
lblSubHead.Text = Resource.Admin_MenuManager_SubHeaderBottom;
Page.Title = menuitem == null
? Resource.Admin_MenuManager_BottomMenu
: string.Format("{0} - {1}", Resource.Admin_MenuManager_BottomMenu, menuitem.MenuItemName);
break;
}
btnAdd.OnClientClick = "open_window('m_Menu.aspx?MenuID=" + _menuId + "&mode=create&type=" + _menuType + "', 750, 640);return false;";
hlEditCategory.NavigateUrl = "javascript:open_window(\'m_Menu.aspx?MenuID=" + _menuId + "&mode=edit&type=" + _menuType + "\', 750, 640)";
ConfirmButtonExtenderCategory.ConfirmText =
string.Format(Resource.Admin_MasterPageAdminCatalog_MenuConfirmation, menuitem != null ? menuitem.MenuItemName : string.Empty);
if (!IsPostBack)
{
if (_menuType == MenuService.EMenuType.Top)
{
_paging = new SqlPaging
{
TableName = "[CMS].[MainMenu]",
ItemsPerPage = 10
};
}
else if (_menuType == MenuService.EMenuType.Bottom)
{
_paging = new SqlPaging
{
TableName = "[CMS].[BottomMenu]",
ItemsPerPage = 10
};
}
_paging.AddFieldsRange(new List <Field>
{
new Field
{
Name = "MenuItemID as ID",
IsDistinct = true
},
new Field {
Name = "MenuItemParentID"
},
new Field {
Name = "MenuItemName"
},
new Field {
Name = "Enabled"
},
new Field {
Name = "Blank"
},
new Field {
Name = "SortOrder", Sorting = SortDirection.Ascending
}
});
if (_menuId != 0)
{
var filter = new EqualFieldFilter {
ParamName = "@MenuItemParentID", Value = _menuId.ToString()
};
_paging.Fields["MenuItemParentID"].Filter = filter;
}
else
{
var filter = new NullFieldFilter {
ParamName = "@MenuItemParentID", Null = true
};
_paging.Fields["MenuItemParentID"].Filter = filter;
}
grid.ChangeHeaderImageUrl("arrowSortOrder", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.Where(id => id != "-1").ToArray();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
SetMeta(string.Format("{0} - {1}", SettingsMain.ShopName, Resource.Admin_Reviews_Reviews));
Message.Visible = false;
MsgErr(true);
if (!IsPostBack)
{
_paging = new SqlPaging
{
TableName = "[CMS].[Review]",
ItemsPerPage = 10
};
_paging.AddFieldsRange(
new Field {
Name = "ReviewId as ID", IsDistinct = true
},
new Field {
Name = "(Select Product.Name From Catalog.Product Where Product.ProductID = EntityId) as ProductName"
},
new Field {
Name = "(Select Top 1 PhotoName From Catalog.Photo Where ObjId = EntityId and Type = 'Product' Order by [Main] DESC) as ProductPhoto"
},
new Field {
Name = "Name"
},
new Field {
Name = "Email"
},
new Field {
Name = "AddDate", Sorting = SortDirection.Descending
},
new Field {
Name = "Checked"
},
new Field {
Name = "[Text]"
});
grid.ChangeHeaderImageUrl("arrowAddDate", "images/arrowdown.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
if (Request["ReviewId"] != null)
{
_paging.Fields["ReviewId"].Filter = new CompareFieldFilter
{
ParamName = "@ReviewId",
Expression = Request["ReviewId"]
};
}
}
else
{
_paging = (SqlPaging)ViewState["Paging"];
_paging.ItemsPerPage = SQLDataHelper.GetInt(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw new Exception("Paging lost");
}
var strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
List <string> arrids = strIds.Trim().Split(' ').ToList();
_selectionFilter = new InSetFieldFilter();
if (arrids.Contains("-1"))
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
arrids.Remove("-1");
}
else
{
_selectionFilter.IncludeValues = true;
}
_selectionFilter.Values = arrids.ToArray();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, Resources.Resource.Admin_Taxes_Header);
if (!IsPostBack)
{
_paging = new SqlPaging {
TableName = "[Catalog].[Tax] JOIN [Customers].[Country] ON [Tax].[CountryID] = [Country].[CountryID]", ItemsPerPage = 10
};
var f = new Field {
Name = "TaxID as ID", IsDistinct = true
};
_paging.AddField(f);
f = new Field {
Name = "Name", Sorting = SortDirection.Ascending
};
_paging.AddField(f);
f = new Field {
Name = "RegNumber"
};
_paging.AddField(f);
f = new Field {
Name = "Enabled"
};
_paging.AddField(f);
f = new Field {
Name = "[Tax].CountryID"
};
_paging.AddField(f);
f = new Field {
Name = "CountryName"
};
_paging.AddField(f);
grid.ChangeHeaderImageUrl("arrowName", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
string[] arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
int t = int.Parse(arrids[idx]);
if (t != -1)
{
ids[idx] = t.ToString(CultureInfo.InvariantCulture);
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = string.Format("{0} - {1}", AdvantShop.Configuration.SettingsMain.ShopName, Resources.Resource.Admin_Subscription_Header);
if (!IsPostBack)
{
_paging = new SqlPaging {
TableName = "[Customers].[Customer]", ItemsPerPage = 10
};
var f = new Field {
Name = "CustomerID as ID", IsDistinct = true, Filter = _selectionFilter
};
_paging.AddField(f);
//f = new Field { Name = "Login", Sorting = SortDirection.Ascending };
//_paging.AddField(f);
f = new Field {
Name = "FirstName"
};
_paging.AddField(f);
f = new Field {
Name = "LastName"
};
_paging.AddField(f);
f = new Field {
Name = "Subscribed4News"
};
_paging.AddField(f);
f = new Field {
Name = "Email", Sorting = SortDirection.Ascending
};
_paging.AddField(f);
f = new Field {
Name = "RegistrationDateTime"
};
_paging.AddField(f);
grid.ChangeHeaderImageUrl("arrowEmail", "images/arrowup.gif");
_paging.ItemsPerPage = 10;
pageNumberer.CurrentPageIndex = 1;
_paging.CurrentPageIndex = 1;
ViewState["Paging"] = _paging;
}
else
{
_paging = (SqlPaging)(ViewState["Paging"]);
_paging.ItemsPerPage = Convert.ToInt32(ddRowsPerPage.SelectedValue);
if (_paging == null)
{
throw (new Exception("Paging lost"));
}
string strIds = Request.Form["SelectedIds"];
if (!string.IsNullOrEmpty(strIds))
{
strIds = strIds.Trim();
var arrids = strIds.Split(' ');
var ids = new string[arrids.Length];
_selectionFilter = new InSetFieldFilter {
IncludeValues = true
};
for (int idx = 0; idx <= ids.Length - 1; idx++)
{
var t = arrids[idx];
if (t != "")
{
ids[idx] = t;
}
else
{
_selectionFilter.IncludeValues = false;
_inverseSelection = true;
}
}
_selectionFilter.Values = ids;
}
}
}
