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)
{
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 Grid_Select(object sender, BXSelectEventArgs e)
{
e.Data = BXSchedulerAgent.GetList(
new BXFilter(Filter.CurrentFilter, BXSchedulerAgent.Fields),
new BXOrderBy(BXSchedulerAgent.Fields, e.SortExpression),
null,
new BXQueryParams(e.PagingOptions)
);
}
protected void BXGridView1_Select(object sender, BXSelectEventArgs e)
{
e.Data = BXCustomField.GetList(
new BXFilter(BXAdminFilter1.CurrentFilter, BXCustomField.Fields),
new BXOrderBy(BXCustomField.Fields, e.SortExpression),
null,
new BXQueryParams(e.PagingOptions)
);
}
protected void MailerGridView_Select(object sender, BXSelectEventArgs e)
{
e.Data = BXMailerTemplate.GetList(
new BXFilter(Filter.CurrentFilter, BXMailerTemplate.Fields),
new BXOrderBy(BXMailerTemplate.Fields, e.SortExpression),
null,
new BXQueryParams(e.PagingOptions),
BXTextEncoder.HtmlTextEncoder
);
}
protected void GridView_Select(object sender, BXSelectEventArgs e)
{
e.Data = BXLanguage.GetList(
null,
new BXOrderBy(BXLanguage.Fields, e.SortExpression),
null,
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder
);
}
private BXSchedulerAgentCollection GetBackupAgents(BXSelectEventArgs e)
{
var filter = new BXFormFilter(new BXFormFilterItem("Name", "BackupAgent", BXSqlFilterOperators.StartsLike));
return(BXSchedulerAgent.GetList(new BXFilter(filter, BXSchedulerAgent.Fields),
new BXOrderBy(BXSchedulerAgent.Fields, e.SortExpression),
null,
new BXQueryParams(e.PagingOptions)
));
}
protected void ItemGrid_Select(object sender, BXSelectEventArgs e)
{
if (!BXPrincipal.Current.IsCanOperate(BXRoleOperation.Operations.ProductSettingsView))
return;
BXContentTagQuery query = BuildTagQuery();
query.OrderBy = new BXContentTagOrderBy(string.IsNullOrEmpty(e.SortExpression) ? "Name" : e.SortExpression);
query.PagingOptions = e.PagingOptions;
query.TextEncoder = BXTextEncoder.EmptyTextEncoder;
e.Data = query.Execute();
}
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;
}
protected void GridView_Select(object sender, BXSelectEventArgs e)
{
e.Data = BXSite.GetList(
new BXFilter(new BXFilterItem(BXSite.Fields.Active, BXSqlFilterOperators.Equal, true)),
new BXOrderBy(
new BXOrderByPair(BXSite.Fields.Sort, BXOrderByDirection.Asc),
new BXOrderByPair(BXSite.Fields.Name, BXOrderByDirection.Asc)
),
null,
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder
)
.ConvertAll(x => new SiteInfo(x, this));
}
protected void ItemGrid_Select(object sender, BXSelectEventArgs e)
{
var f = new BXFilter(ItemFilter.CurrentFilter, CustomerProfiles.Fields);
var playerList = CustomerProfiles.GetList(
f,
new BXOrderBy(CustomerProfiles.Fields, string.IsNullOrEmpty(e.SortExpression) ? "sourceid" : e.SortExpression),
new BXSelectAdd(CustomerProfiles.Fields.name),
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder
).ToList<CustomerProfiles>();
e.Data = playerList;
}
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 GridView_Select(object sender, BXSelectEventArgs e)
{
var query = BuildQuery();
Match m;
if ((m = Regex.Match(e.SortExpression ?? "", @"^(\w+)(?:\s+(ASC|DESC))?$", RegexOptions.IgnoreCase)).Success)
{
try
{
query.OrderBy = (BXMarketplaceQueryOrderBy)Enum.Parse(typeof(BXMarketplaceQueryOrderBy), m.Groups[1].Value, true);
query.OrderByAsc = !string.Equals(m.Groups[2].Value, "DESC", StringComparison.OrdinalIgnoreCase);
}
catch
{
}
}
BXMarketplaceQueryResult r;
try
{
r = query.Execute();
}
catch(Exception ex)
{
ErrorMessage.AddErrorText(ex.Message);
r = new BXMarketplaceQueryResult();
}
var q = r.Modules.Skip(e.PagingOptions.startRowIndex);
if (e.PagingOptions.maximumRows > 0)
q = q.Take(e.PagingOptions.maximumRows);
e.Data = q.ToList();
}
protected void BXForumGrid_Select(object sender, BXSelectEventArgs e)
{
BXFilter filter = new BXFilter(new BXFilterItem(BXForum.Fields.CheckPermissions, BXSqlFilterOperators.Equal, new string[] { BXForum.Operations.ForumAdminManage }));
filter.Add(new BXFilter(BXForumFilter.CurrentFilter, BXForum.Fields));
BXOrderBy orderBy;
if (String.IsNullOrEmpty(e.SortExpression))
orderBy = new BXOrderBy(
new BXOrderByPair(BXForum.Fields.Category.Sort, BXOrderByDirection.Asc),
new BXOrderByPair(BXForum.Fields.Category.Id, BXOrderByDirection.Asc),
new BXOrderByPair(BXForum.Fields.Sort, BXOrderByDirection.Asc),
new BXOrderByPair(BXForum.Fields.Name, BXOrderByDirection.Asc)
);
else
orderBy = new BXOrderBy(BXForum.Fields, e.SortExpression);
e.Data = BXForum.GetList(
filter,
orderBy,
null,
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder
);
}
protected void BXSubscriptionsGrid_Select(object sender, BXSelectEventArgs e)
{
if (UserId <= 0)
{
e.Data = new List<BXSubscriptionsSelect>();
return;
}
currentFilter = new BXFilter(new BXFilterItem(BXForumSubscription.Fields.Subscriber.Id,BXSqlFilterOperators.Equal,UserId));
currentFilter.Add(new BXFilter(BXSubscriptionsFilter.CurrentFilter, BXForumSubscription.Fields));
//BXSubscriptionsFilter.CurrentFilter.con
BXOrderBy orderBy;
if (String.IsNullOrEmpty(e.SortExpression))
orderBy = new BXOrderBy(new BXOrderByPair(BXForumSubscription.Fields.Id, BXOrderByDirection.Asc));
else
orderBy = new BXOrderBy(BXForumSubscription.Fields, e.SortExpression);
BXForumSubscriptionCollection subs = BXForumSubscription.GetList(
currentFilter,
orderBy,
new BXSelectAdd(BXForumSubscription.Fields.Topic,BXForumSubscription.Fields.Forum),
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder
);
List<BXSubscriptionsSelect> list = subs.ConvertAll<BXSubscriptionsSelect>(delegate(BXForumSubscription input)
{
string siteName = String.Empty;
if (sites.ContainsKey(input.SiteId)) siteName = sites[input.SiteId];
else throw new KeyNotFoundException("site is not found");
return new BXSubscriptionsSelect(
input.Id, input.Forum!=null ? input.Forum.Name:"",
input.Topic!=null? input.Topic.Name:"", input.OnlyTopic,
input.DateStart, siteName,
GetMessageRaw(input.TopicId>0? "ColumnText.Topic" : input.OnlyTopic ? "ColumnText.OnlyTopic" : "ColumnText.FullForum")
);
}
);
e.Data = list;
}
protected void fileManGrid_Select(object sender, BXSelectEventArgs e)
{
string role = rolesList.SelectedValue;
if (role == null)
role = String.Empty;
string[] columns = GetColumns();
bool access = BXSet.Contains(columns, "access");
DataView view = BXSecureIO.DirectoryList(curPath, true, null, columns);
view.RowFilter = Filter.CurrentFilter.BuildDataViewFilter();
DataTable result = view.ToTable();
result.Columns.Add("isbackbutton", typeof(bool));
if (access)
result.Columns.Add("access", typeof(string));
foreach (DataRow r in result.Rows)
{
r["path"] = ((string)r["path"]);//.Substring(2).ToLower();
r["isbackbutton"] = false;
if (access)
r["access"] = GetAccessString((string)r["path"], role);
}
if (!IsRoot) //Don't need paging options, because it's a normal element of list
AddParentRow(result);
DataView dv = new DataView(result);
dv.Sort = "isbackbutton DESC, file ASC" + (string.IsNullOrEmpty(e.SortExpression) ? string.Empty : (", " + e.SortExpression));
result = dv.ToTable();
if (e.PagingOptions != null)
{
if (!IsRoot && e.PagingOptions.startRowIndex == 0)
e.PagingOptions.maximumRows++;
result.Columns.Add("isvisible", typeof(bool));
for (int i = 0; i < result.Rows.Count; i++)
result.Rows[i]["isvisible"] = (i >= e.PagingOptions.startRowIndex && i < (e.PagingOptions.startRowIndex + e.PagingOptions.maximumRows));
dv = new DataView(result);
dv.RowFilter = "isvisible = true";
result = dv.ToTable();
}
e.Data = new DataView(result);
}
protected void GridView_Select(object sender, BXSelectEventArgs e)
{
DataTable dt = new DataTable("Templates");
dt.Columns.Add("ID", typeof(string));
dt.Columns.Add("Name", typeof(string));
dt.Columns.Add("Description", typeof(string));
dt.Columns.Add("PreviewSmall", typeof(string));
dt.Columns.Add("PreviewBig", typeof(string));
dt.Columns.Add("PreviewBigPath", typeof(string));
int i = -1;
foreach (DirectoryInfo temp in new DirectoryInfo(BXPath.MapPath(BXConfigurationUtility.Constants.TemplatesFolderPath)).GetDirectories())
{
var tempFile =
BXApplicationHelper.ApplicationType == BXApplicationTechnologyType.Mvc
? "template.cshtml"
: BXConfigurationUtility.Constants.TemplateFileName;
if (!File.Exists(Path.Combine(temp.FullName, tempFile)))
{
continue;
}
i++;
if (i < e.PagingOptions.startRowIndex || i >= e.PagingOptions.startRowIndex + e.PagingOptions.maximumRows)
{
continue;
}
DataRow newRow = dt.NewRow();
newRow["ID"] = temp.Name;
string resorcePath = string.Format("{0}\\lang\\{1}\\include.lang", temp.FullName, BXLoc.CurrentLocale);
if (File.Exists(resorcePath))
{
using (var res = new BXResourceFile(resorcePath))
{
if (res.ContainsKey("Template.Name"))
{
newRow["Name"] = res["Template.Name"];
}
if (res.ContainsKey("Template.Description"))
{
newRow["Description"] = BXStringUtility.HtmlToText(res["Template.Description"] ?? "");
}
}
}
if (File.Exists(temp.FullName + "\\preview.gif"))
{
newRow["PreviewSmall"] = ResolveClientUrl(BXPath.Combine(
BXConfigurationUtility.Constants.TemplatesFolderPath,
temp.Name,
"preview.gif"
));
}
if (File.Exists(temp.FullName + "\\screen.gif"))
{
newRow["PreviewBig"] = ResolveClientUrl(BXPath.Combine(
BXConfigurationUtility.Constants.TemplatesFolderPath,
temp.Name,
"screen.gif"
));
newRow["PreviewBigPath"] = temp.FullName + "\\screen.gif";
}
dt.Rows.Add(newRow);
}
var view = new DataView(dt) { Sort = e.SortExpression };
e.Data = view;
}
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 Grid_Select(object sender, BXSelectEventArgs e)
{
e.Data = new DataView(FillTable(e.PagingOptions, e.SortExpression));
}
protected void BXGridView1_Select(object sender, BXSelectEventArgs e)
{
if (!IsUserAuthorized)
return;
e.Data = BXCustomField.GetList(
CreateSelectFilter(),
new BXOrderBy(BXCustomField.Fields, e.SortExpression),
null,
new BXQueryParams(e.PagingOptions)
);
}
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;
}
protected void BXUsersGrid_Select(object sender, BXSelectEventArgs e)
{
BXFilter filter = new BXFilter();
filter.Add(new BXFilter(BXUsersFilter.CurrentFilter, BXForumUser.Fields));
BXOrderBy orderBy;
if (String.IsNullOrEmpty(e.SortExpression))
orderBy = new BXOrderBy(new BXOrderByPair(BXForumUser.Fields.Id, BXOrderByDirection.Asc));
else
orderBy = new BXOrderBy(BXForumUser.Fields, e.SortExpression);
BXForumUserCollection subs = BXForumUser.GetList( filter,
orderBy,
new BXSelectAdd(BXForumUser.Fields.User,BXForumUser.Fields.SubscriptionsCount),
new BXQueryParams(e.PagingOptions),
BXTextEncoder.EmptyTextEncoder
);
List<SubscriptionsGridSelect> list = new List<SubscriptionsGridSelect>();
string msg = GetMessage("GridText.ToolTip.EditUser");
foreach (BXForumUser u in subs)
list.Add(new SubscriptionsGridSelect(u.User,u,msg));
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)
{
List<LogWrapper> list = new List<LogWrapper>();
BXFilter f = new BXFilter(ItemFilter.CurrentFilter, BXMailerEventEntity.Fields);
BXMailerEventEntityCollection subscribePostingList = BXMailerEventEntity.GetList(
f,
new BXOrderBy(BXMailerEventEntity.Fields, string.IsNullOrEmpty(e.SortExpression) ? "LastUpdated DESC" : e.SortExpression),
null,
new BXQueryParams(e.PagingOptions),
BXTextEncoder.HtmlTextEncoder
);
foreach (BXMailerEventEntity item in subscribePostingList)
list.Add(new LogWrapper(item, this));
e.Data = list;
}
