protected void ItemGrid_Select(object sender, BXSelectEventArgs e)
{
List<PromoRuleWrapper> list = new List<PromoRuleWrapper>();
BXFilter f = new BXFilter(ItemFilter.CurrentFilter, BXPromoRule.Fields);
BXSelect s = new BXSelect(
BXSelectFieldPreparationMode.Normal,
BXPromoRule.Fields.Id,
BXPromoRule.Fields.Name,
BXPromoRule.Fields.CreatedUtc,
BXPromoRule.Fields.LastModifiedUtc,
BXPromoRule.Fields.LastAppliedUtc,
BXPromoRule.Fields.Active,
BXPromoRule.Fields.BoundEntityTypeId,
BXPromoRule.Fields.XmlId
);
BXPromoRuleCollection col = BXPromoRule.GetList(
f,
new BXOrderBy(BXPromoRule.Fields, string.IsNullOrEmpty(e.SortExpression) ? "Id" : e.SortExpression),
s,
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder
);
foreach (BXPromoRule item in col)
list.Add(new PromoRuleWrapper(item, this));
e.Data = list;
}
protected void ItemGrid_Select(object sender, BXSelectEventArgs e)
{
if (!BXPrincipal.Current.IsCanOperate(BXBlog.Operations.AdminManagement))
return;
List<BlogCategoryWrapper> list = new List<BlogCategoryWrapper>();
BXFilter f = new BXFilter(ItemFilter.CurrentFilter, BXBlogCategory.Fields);
BXSelect s = new BXSelect(BXSelectFieldPreparationMode.Normal,
BXBlogCategory.Fields.Id,
BXBlogCategory.Fields.Name,
BXBlogCategory.Fields.Sites.Site.ID,
BXBlogCategory.Fields.Sites.Site.Name,
BXBlogCategory.Fields.Sort
);
BXBlogCategoryCollection blogCategoryList = BXBlogCategory.GetList(
f,
new BXOrderBy(BXBlogCategory.Fields, string.IsNullOrEmpty(e.SortExpression) ? "Id" : e.SortExpression),
s,
null,
BXTextEncoder.EmptyTextEncoder
);
foreach (BXBlogCategory blogCategory in blogCategoryList)
list.Add(new BlogCategoryWrapper(blogCategory, this));
e.Data = list;
}
protected void ItemGrid_Select(object sender, BXSelectEventArgs e)
{
if (!BXPrincipal.Current.IsCanOperate(BXAdvertisingModule.Operations.SpaceManagement))
return;
List<AdvertisingSpaceWrapper> list = new List<AdvertisingSpaceWrapper>();
BXFilter f = new BXFilter(ItemFilter.CurrentFilter, BXAdvertisingSpace.Fields);
BXSelect s = new BXSelect(
BXSelectFieldPreparationMode.Normal,
BXAdvertisingSpace.Fields.Id,
BXAdvertisingSpace.Fields.Name,
BXAdvertisingSpace.Fields.Description,
BXAdvertisingSpace.Fields.Active,
BXAdvertisingSpace.Fields.DateCreated,
BXAdvertisingSpace.Fields.DateLastModified
);
BXAdvertisingSpaceCollection advSpaceList = BXAdvertisingSpace.GetList(
f,
new BXOrderBy(BXAdvertisingSpace.Fields, string.IsNullOrEmpty(e.SortExpression) ? "Id" : e.SortExpression),
s,
null,
BXTextEncoder.EmptyTextEncoder
);
foreach (BXAdvertisingSpace advSpace in advSpaceList)
list.Add(new AdvertisingSpaceWrapper(advSpace, this));
e.Data = list;
}
protected void ItemGrid_Select(object sender, BXSelectEventArgs e)
{
//if (!BXPrincipal.Current.IsCanOperate(""))
// return;
List<RatingWrapper> list = new List<RatingWrapper>();
BXFilter f = new BXFilter(ItemFilter.CurrentFilter, BXRating.Fields);
BXSelect s = new BXSelect(
BXSelectFieldPreparationMode.Normal,
BXRating.Fields.Id,
BXRating.Fields.Name,
BXRating.Fields.Created,
BXRating.Fields.LastModified,
BXRating.Fields.LastCalculated,
BXRating.Fields.IsUnderCalculation,
BXRating.Fields.Active,
BXRating.Fields.BoundEntityTypeId,
BXRating.Fields.CalculationMethod,
BXRating.Fields.RefreshMethod,
BXRating.Fields.XmlId
);
BXRatingCollection col = BXRating.GetList(
f,
new BXOrderBy(BXRating.Fields, string.IsNullOrEmpty(e.SortExpression) ? "Id" : e.SortExpression),
s,
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder
);
foreach (BXRating item in col)
list.Add(new RatingWrapper(item, this));
e.Data = list;
}
protected void ItemGrid_Select(object sender, BXSelectEventArgs e)
{
if (!BXPrincipal.Current.IsCanOperate(BXBlog.Operations.AdminManagement))
return;
List<BlogWrapper> list = new List<BlogWrapper>();
BXFilter f = new BXFilter(ItemFilter.CurrentFilter, BXBlog.Fields);
BXSelect s = new BXSelect(BXSelectFieldPreparationMode.Normal,
BXBlog.Fields.Id,
BXBlog.Fields.Name,
BXBlog.Fields.DateCreated,
BXBlog.Fields.DateLastPosted,
BXBlog.Fields.Active,
BXBlog.Fields.Owner,
BXBlog.Fields.Slug,
BXBlog.Fields.IndexContent,
BXBlog.Fields.IsTeam,
BXBlog.Fields.Categories.Category,
BXBlog.Fields.CustomFields.DefaultFields
);
BXBlogCollection blogList = BXBlog.GetList(
f,
new BXOrderBy(BXBlog.Fields, string.IsNullOrEmpty(e.SortExpression) ? "Id" : e.SortExpression),
s,
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder
);
foreach (BXBlog blog in blogList)
list.Add(new BlogWrapper(blog, this));
e.Data = list;
}
protected void ItemGrid_Select(object sender, BXSelectEventArgs e)
{
if (!BXPrincipal.Current.IsCanOperate(BXBlog.Operations.AdminManagement))
return;
List<BlogCommentWrapper> list = new List<BlogCommentWrapper>();
BXFilter f = new BXFilter(ItemFilter.CurrentFilter, BXBlogComment.Fields);
BXSelect s = new BXSelect(BXSelectFieldPreparationMode.Add,
BXBlogComment.Fields.Author.User.FirstName,
BXBlogComment.Fields.Author.User.LastName,
BXBlogComment.Fields.Author.User.UserName,
BXBlogComment.Fields.Blog.Id,
BXBlogComment.Fields.Blog.Name,
BXBlogComment.Fields.Post.Id,
BXBlogComment.Fields.Post.Title);
this.comments = BXBlogComment.GetList(
f,
new BXOrderBy(BXBlogComment.Fields, string.IsNullOrEmpty(e.SortExpression) ? "Id" : e.SortExpression),
s,
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder
);
this.processor = new BXBlogCommentChain();
foreach (BXBlogComment comment in this.comments)
list.Add(new BlogCommentWrapper(comment, this, this.processor));
e.Data = list;
}
protected void ItemGrid_Select(object sender, BXSelectEventArgs e)
{
if (typeSelectError != true)
typeSelectError = false;
List<RatingVotingWrapper> list = new List<RatingVotingWrapper>();
BXFilter f = new BXFilter(ItemFilter.CurrentFilter, BXRatingVoting.Fields);
//f.Add(new BXFilterItem(BXRatingVoting.Fields.TotalVotes, BXSqlFilterOperators.Greater, 0));
//если задан тип элемента и поисковая фраза - ищем поиском
BXFilterItem searchFilter = null;
if (ItemFilter.CurrentFilter.Exists(TypeFilterExist) && ItemFilter.CurrentFilter.Exists(VotingSubjectContainsExist))
{
#region запускаем поиск по введенной строке
//ErrorMessage.Visible = false;
List<BXSearchResult> results = new List<BXSearchResult>();
string boundEntityTypeId = string.Empty,
moduleSearchId = string.Empty,
searchQuery = string.Empty;
BXFormFilterItem tmp = null;
foreach (BXFormFilterItem f1 in ItemFilter.CurrentFilter)
{
if (f1.filterName == "BoundEntityTypeId")
boundEntityTypeId = f1.filterValue.ToString();
else if (f1.filterName == "VotingSubjectContains")
{
searchQuery = f1.filterValue.ToString();
//удаляем фильтр из списка по VotingSubjectContains,
//чтобы не создавать лишних условий в фильтре
tmp = f1;
}
}
ItemFilter.CurrentFilter.Remove(tmp);
//если опознан модуль и есть результаты поиска по словосочетанию
if (TryGetModuleId(boundEntityTypeId, out moduleSearchId))
switch (moduleSearchId)
{
case "iblock":
List<int> iblockElementIds = new List<int>();
results = SearchItems(moduleSearchId, searchQuery);
foreach (BXSearchResult r in results)
{
int var_i;
int.TryParse(r.Content.ItemId, out var_i);
iblockElementIds.Add(var_i);
}
searchFilter = new BXFilterItem(BXRatingVoting.Fields.BoundEntityId, BXSqlFilterOperators.In, iblockElementIds);
f.Add(searchFilter);
break;
case "blog":
List<int> blogPostIds = new List<int>();
results = SearchItems(moduleSearchId, searchQuery);
foreach (BXSearchResult r in results)
{
int var_i;
string var_s = r.Content.ItemId;
var_s = var_s.Remove(0, 1);
int.TryParse(var_s, out var_i);
blogPostIds.Add(var_i);
}
searchFilter = new BXFilterItem(BXRatingVoting.Fields.BoundEntityId, BXSqlFilterOperators.In, blogPostIds);
f.Add(searchFilter);
break;
case "forum":
List<int> forumPostIds = new List<int>();
results = SearchItems(moduleSearchId, searchQuery);
foreach (BXSearchResult r in results)
{
int var_i;
int.TryParse(r.Content.ItemId, out var_i);
forumPostIds.Add(var_i);
}
searchFilter = new BXFilterItem(BXRatingVoting.Fields.BoundEntityId, BXSqlFilterOperators.In, forumPostIds);
f.Add(searchFilter);
break;
case "user":
List<int> userIds = new List<int>();
BXUserCollection users = BXUserManager.GetList(new BXFormFilter(new BXFormFilterItem("username", searchQuery, BXSqlFilterOperators.Equal)), new BXOrderBy_old());
if (users.Count > 0)
searchFilter = new BXFilterItem(BXRatingVoting.Fields.BoundEntityId, BXSqlFilterOperators.Equal, users[0].UserId);
else
{
e.Data = list;
return;
}
break;
default:
e.Data = list;
return;
}
#endregion
}
else if (ItemFilter.CurrentFilter.Exists(VotingSubjectContainsExist) && !typeSelectError)
{
//ErrorMessage.Visible = true;
ErrorMessage.AddErrorText(GetMessage("Error.ChooseSubjectType"));
typeSelectError = true;
e.Data = list;
return;
}
BXSelect s = new BXSelect(
BXSelectFieldPreparationMode.Normal,
BXRatingVoting.Fields.Id,
BXRatingVoting.Fields.Active,
BXRatingVoting.Fields.BoundEntityTypeId,
BXRatingVoting.Fields.BoundEntityId, //за что или за кого голосуют
BXRatingVoting.Fields.CreatedUtc, //дата создания
BXRatingVoting.Fields.LastCalculatedUtc, //дата последней модификации голосования
BXRatingVoting.Fields.TotalValue, //суммарное значение голосов
BXRatingVoting.Fields.TotalPositiveVotes, //количество голосов "за"
BXRatingVoting.Fields.TotalNegativeVotes, //количество голосов "против"
BXRatingVoting.Fields.TotalVotes, //количество голосов
BXRatingVoting.Fields.XmlId
);
BXRatingVotingCollection col = BXRatingVoting.GetList(
f,
new BXOrderBy(BXRatingVoting.Fields, string.IsNullOrEmpty(e.SortExpression) ? "CreatedUtc DESC" : e.SortExpression),
s,
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder
);
int recalculateId = 0;
if (!String.IsNullOrEmpty(Request["recalculate"]) && Request["recalculate"] == "Y")
int.TryParse(Request["RecalculateId"], out recalculateId);
foreach (BXRatingVoting item in col)
{
if (recalculateId > 0 && item.Id == recalculateId)
item.Calculate(true);
list.Add(new RatingVotingWrapper(item, this));
}
e.Data = list;
}
public void PrepareElementSelect(BXSelect select)
{
if(select == null)
return;
select.Add(InnerCatalogItemAdapter.JoinScheme);
select.Add(InnerCatalogItemAdapter.JoinScheme.Catalog);
select.Add(InnerCatalogItemAdapter.JoinScheme.VATRate);
}
protected void ItemGrid_Select(object sender, BXSelectEventArgs e)
{
if (!BXPrincipal.Current.IsCanOperate(BXRoleOperation.Operations.ProductSettingsManage))
return;
List<StorageConfigWrapper> list = new List<StorageConfigWrapper>();
BXSelect s = new BXSelect(BXSelectFieldPreparationMode.Normal,
BXStorageConfiguration.Fields.Id,
BXStorageConfiguration.Fields.IsActive,
BXStorageConfiguration.Fields.Sort,
BXStorageConfiguration.Fields.CreatedUtc,
BXStorageConfiguration.Fields.StorageTypeName);
BXStorageConfigurationCollection col = BXStorageConfiguration.GetList(
null,
new BXOrderBy(BXStorageConfiguration.Fields, string.IsNullOrEmpty(e.SortExpression) ? "Id" : e.SortExpression),
s,
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder);
foreach (BXStorageConfiguration item in col)
list.Add(new StorageConfigWrapper(item, this));
e.Data = list;
}
protected void ItemGrid_Select(object sender, BXSelectEventArgs e)
{
if (!BXPrincipal.Current.IsCanOperate(BXAdvertisingModule.Operations.BannerManagement))
return;
List<AdvertisingBannerWrapper> list = new List<AdvertisingBannerWrapper>();
BXFilter f = new BXFilter(ItemFilter.CurrentFilter, BXAdvertisingBanner.Fields);
BXSelect s = new BXSelect(
BXSelectFieldPreparationMode.Normal,
BXAdvertisingBanner.Fields.Id,
BXAdvertisingBanner.Fields.Name,
BXAdvertisingBanner.Fields.ContentType,
BXAdvertisingBanner.Fields.ContentFile,
BXAdvertisingBanner.Fields.TextContentType,
BXAdvertisingBanner.Fields.TextContent,
BXAdvertisingBanner.Fields.Description,
BXAdvertisingBanner.Fields.Active,
BXAdvertisingBanner.Fields.DateCreated,
BXAdvertisingBanner.Fields.DateLastModified,
BXAdvertisingBanner.Fields.DateOfFirstDisplay,
BXAdvertisingBanner.Fields.DateOfLastDisplay,
BXAdvertisingBanner.Fields.EnableFixedRotation,
BXAdvertisingBanner.Fields.EnableUniformRotationVelocity,
BXAdvertisingBanner.Fields.EnableRedirectionCount,
BXAdvertisingBanner.Fields.DateOfRotationStart,
BXAdvertisingBanner.Fields.DateOfRotationFinish,
BXAdvertisingBanner.Fields.DisplayCount,
BXAdvertisingBanner.Fields.VisitorCount,
BXAdvertisingBanner.Fields.RedirectionCount,
BXAdvertisingBanner.Fields.MaxDisplayCount,
BXAdvertisingBanner.Fields.MaxDisplayCountPerVisitor,
BXAdvertisingBanner.Fields.MaxRedirectionCount,
BXAdvertisingBanner.Fields.MaxVisitorCount,
BXAdvertisingBanner.Fields.Weight,
BXAdvertisingBanner.Fields.Space.Name,
BXAdvertisingBanner.Fields.FlashVersion
);
BXAdvertisingBannerCollection advBannerList = BXAdvertisingBanner.GetList(
f,
new BXOrderBy(BXAdvertisingBanner.Fields, string.IsNullOrEmpty(e.SortExpression) ? "ID DESC" : e.SortExpression),
s,
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder
);
foreach (BXAdvertisingBanner advBanner in advBannerList)
list.Add(new AdvertisingBannerWrapper(advBanner, this));
e.Data = list;
}
