private void LoadCulture(FavoriteCulturePart part)
{
var culture = _commonService.ListCultures().SingleOrDefault(x => x.Id == part.Culture_Id);
if (culture != null)
{
part.Culture = culture.Culture;
}
else
{
part.Culture = _orchardService.WorkContext.CurrentCulture;
}
}
public List <FaqTypePartRecord> GetFaqTypes(bool filterOnCurrentCulture)
{
if (filterOnCurrentCulture)
{
var culture = _worckContextAccessor.GetContext().CurrentCulture;
var idCurrentCulture = _commonsServices.ListCultures().Where(w => w.Culture == culture).Select(s => s.Id).FirstOrDefault();
var list = _contentManager.Query <LocalizationPart, LocalizationPartRecord>("FaqType")
.ForVersion(VersionOptions.Published)
.Where(w => w.CultureId == idCurrentCulture || w.CultureId == 0)
.List <FaqTypePart>();
if (list == null)
{
return(_FaqTypeRepository.Table.ToList());
}
//(VersionOptions.Published).ForType("FaqType").Where(s=>s.
return(list.Select(s => s.Record).ToList());
}
else
{
return(_FaqTypeRepository.Table.ToList());
}
}
public void Register(UserRegistration userRegistrationParams)
{
if (RegistrationSettings.UsersCanRegister)
{
var policyAnswers = new List <PolicyForUserViewModel>();
if (_utilsServices.FeatureIsEnabled("Laser.Orchard.Policy") &&
UserRegistrationExtensionsSettings.IncludePendingPolicy == Policy.IncludePendingPolicyOptions.Yes)
{
IEnumerable <PolicyTextInfoPart> policies = GetUserLinkedPolicies(userRegistrationParams.Culture);
// controllo che tutte le policy abbiano una risposta e che le policy obbligatorie siano accettate
var allRight = true;
foreach (var policy in policies)
{
var policyId = policy.Id;
var policyRequired = policy.UserHaveToAccept;
var answer = userRegistrationParams.PolicyAnswers.Where(w => w.PolicyId == policyId).SingleOrDefault();
if (answer != null)
{
if (!answer.PolicyAnswer && policyRequired)
{
allRight = false;
}
}
else if (answer == null && policyRequired)
{
allRight = false;
}
if (answer != null)
{
policyAnswers.Add(new PolicyForUserViewModel {
OldAccepted = false,
PolicyTextId = policyId,
Accepted = answer.PolicyAnswer,
AnswerDate = DateTime.Now
});
}
}
if (!allRight)
{
throw new SecurityException(T("User has to accept policies!").Text);
}
}
var registrationErrors = new List <string>();
if (ValidateRegistration(userRegistrationParams.Username, userRegistrationParams.Email,
userRegistrationParams.Password, userRegistrationParams.ConfirmPassword, out registrationErrors))
{
var createdUser = _membershipService.CreateUser(new CreateUserParams(
userRegistrationParams.Username,
userRegistrationParams.Password,
userRegistrationParams.Email,
userRegistrationParams.PasswordQuestion,
userRegistrationParams.PasswordAnswer,
(RegistrationSettings.UsersAreModerated == false) && (RegistrationSettings.UsersMustValidateEmail == false),
false
));
// _membershipService.CreateUser may return null and tell nothing about why it failed to create the user
// if the Creating user event handlers set the flag to cancel user creation.
if (createdUser == null)
{
throw new SecurityException(T("User registration failed.").Text);
}
// here user was created
var favCulture = createdUser.As <FavoriteCulturePart>();
if (favCulture != null)
{
var culture = _commonsServices.ListCultures().SingleOrDefault(x => x.Culture.Equals(userRegistrationParams.Culture));
if (culture != null)
{
favCulture.Culture_Id = culture.Id;
}
else
{
// usa la culture di default del sito
favCulture.Culture_Id = _cultureManager.GetCultureByName(_cultureManager.GetSiteCulture()).Id;
}
}
if ((RegistrationSettings.UsersAreModerated == false) && (RegistrationSettings.UsersMustValidateEmail == false))
{
_userEventHandler.LoggingIn(userRegistrationParams.Username, userRegistrationParams.Password);
_authenticationService.SignIn(createdUser, userRegistrationParams.CreatePersistentCookie);
// solleva l'evento LoggedIn sull'utente
_userEventHandler.LoggedIn(createdUser);
}
// [HS] BEGIN: Whe have to save the PoliciesAnswers cookie and persist answers on the DB after Login/SignIn events because during Login/Signin events database is not updated yet and those events override cookie in an unconsistent way.
if (_utilsServices.FeatureIsEnabled("Laser.Orchard.Policy") && UserRegistrationExtensionsSettings.IncludePendingPolicy == Policy.IncludePendingPolicyOptions.Yes)
{
_policyServices.PolicyForUserMassiveUpdate(policyAnswers, createdUser);
}
// [HS] END
if (RegistrationSettings.UsersMustValidateEmail)
{
// send challenge e-mail
var siteUrl = _orchardServices.WorkContext.CurrentSite.BaseUrl;
if (string.IsNullOrWhiteSpace(siteUrl))
{
siteUrl = HttpContext.Current.Request.ToRootUrlString();
}
UrlHelper urlHelper = new UrlHelper(HttpContext.Current.Request.RequestContext);
_userService.SendChallengeEmail(createdUser, nonce => urlHelper.MakeAbsolute(urlHelper.Action("ChallengeEmail", "Account", new { Area = "Orchard.Users", nonce = nonce }), siteUrl));
}
}
else
{
throw new SecurityException(String.Join(", ", registrationErrors));
}
}
else
{
throw new SecurityException(T("User cannot register due to Site settings").Text);
}
}
public ActionResult List(ListContentsViewModelExtension model, PagerParameters pagerParameters)
{
Pager pager = new Pager(_siteService.GetSiteSettings(), pagerParameters);
var versionOptions = VersionOptions.Latest;
switch (model.Options.ContentsStatus)
{
case ContentsStatus.Published:
versionOptions = VersionOptions.Published;
break;
case ContentsStatus.Draft:
versionOptions = VersionOptions.Draft;
break;
case ContentsStatus.AllVersions:
versionOptions = VersionOptions.AllVersions;
break;
default:
versionOptions = VersionOptions.Latest;
break;
}
var query = _contentManager.Query(versionOptions, GetListableTypes(false).Select(ctd => ctd.Name).ToArray());
//the lQuery is used only in the case where we have the language queries, but since we cannot clone IContentQuery objects,
//we create it here and build is as we build the other
var lQuery = _contentManager.Query(versionOptions, GetListableTypes(false).Select(ctd => ctd.Name).ToArray());
if (!string.IsNullOrEmpty(model.TypeName))
{
var contentTypeDefinition = _contentDefinitionManager.GetTypeDefinition(model.TypeName);
if (contentTypeDefinition == null)
{
return(HttpNotFound());
}
model.TypeDisplayName = !string.IsNullOrWhiteSpace(contentTypeDefinition.DisplayName)
? contentTypeDefinition.DisplayName
: contentTypeDefinition.Name;
query = query.ForType(model.TypeName);
lQuery = lQuery.ForType(model.TypeName);
}
// FILTER QUERIES: START //
// terms query
if (model.AdvancedOptions.SelectedTermId > 0)
{
var termId = model.AdvancedOptions.SelectedTermId;
query = query.Join <TermsPartRecord>().Where(x => x.Terms.Any(a => a.TermRecord.Id == termId));
lQuery = lQuery.Join <TermsPartRecord>().Where(x => x.Terms.Any(a => a.TermRecord.Id == termId));
}
// owner query
if ( //user cannot see everything by default
(
!Services.Authorizer.Authorize(AdvancedSearchPermissions.SeesAllContent) ||
(Services.Authorizer.Authorize(AdvancedSearchPermissions.SeesAllContent) && model.AdvancedOptions.OwnedByMeSeeAll)
) && ( //user has either limitation
((Services.Authorizer.Authorize(AdvancedSearchPermissions.MayChooseToSeeOthersContent)) &&
(model.AdvancedOptions.OwnedByMe)) ||
(Services.Authorizer.Authorize(AdvancedSearchPermissions.CanSeeOwnContents) &&
!Services.Authorizer.Authorize(AdvancedSearchPermissions.MayChooseToSeeOthersContent))
)
)
{
//this user can only see the contents they own
var lowerName = Services.WorkContext.CurrentUser.UserName.ToLowerInvariant();
var email = Services.WorkContext.CurrentUser.Email;
var user = _contentManager.Query <UserPart, UserPartRecord>().Where(u => u.NormalizedUserName == lowerName || u.Email == email).List().FirstOrDefault();
query = query.Join <CommonPartRecord>().Where(x => x.OwnerId == user.Id);
lQuery = lQuery.Join <CommonPartRecord>().Where(x => x.OwnerId == user.Id);
}
else if (!String.IsNullOrWhiteSpace(model.AdvancedOptions.SelectedOwner))
{
var lowerName = model.AdvancedOptions.SelectedOwner == null ? "" : model.AdvancedOptions.SelectedOwner.ToLowerInvariant();
var email = model.AdvancedOptions.SelectedOwner;
var user = _contentManager.Query <UserPart, UserPartRecord>().Where(u => u.NormalizedUserName == lowerName || u.Email == email).List().FirstOrDefault();
if (user != null)
{
query = query.Join <CommonPartRecord>().Where(x => x.OwnerId == user.Id);
lQuery = lQuery.Join <CommonPartRecord>().Where(x => x.OwnerId == user.Id);
}
else
{
_notifier.Add(NotifyType.Warning, T("No user found. Ownership filter not applied."));
}
}
//date query
if (model.AdvancedOptions.SelectedFromDate != null || model.AdvancedOptions.SelectedToDate != null)
{
//set default dates for From and To if they are null.
var fromD = _dataLocalization.StringToDatetime(model.AdvancedOptions.SelectedFromDate, "") ?? _dataLocalization.StringToDatetime("09/05/1985", "");
var toD = _dataLocalization.StringToDatetime(model.AdvancedOptions.SelectedToDate, "") ?? DateTime.Now;
if (model.AdvancedOptions.DateFilterType == DateFilterOptions.Created)
{
query = query.Join <CommonPartRecord>().Where(x => x.CreatedUtc >= fromD && x.CreatedUtc <= toD);
lQuery = lQuery.Join <CommonPartRecord>().Where(x => x.CreatedUtc >= fromD && x.CreatedUtc <= toD);
}
else if (model.AdvancedOptions.DateFilterType == DateFilterOptions.Modified)
{
query = query.Join <CommonPartRecord>().Where(x => x.ModifiedUtc >= fromD && x.ModifiedUtc <= toD);
lQuery = lQuery.Join <CommonPartRecord>().Where(x => x.ModifiedUtc >= fromD && x.ModifiedUtc <= toD);
}
else if (model.AdvancedOptions.DateFilterType == DateFilterOptions.Published)
{
query = query.Join <CommonPartRecord>().Where(x => x.PublishedUtc >= fromD && x.PublishedUtc <= toD);
lQuery = lQuery.Join <CommonPartRecord>().Where(x => x.PublishedUtc >= fromD && x.PublishedUtc <= toD);
}
}
// Has media query
if (model.AdvancedOptions.HasMedia)
{
var allCt = GetListableTypes(false);
var listFields = new List <string>();
foreach (var ct in allCt)
{
var allMediaFld = _contentDefinitionService.GetType(ct.Name).Fields.Where(w =>
w._Definition.FieldDefinition.Name == "MediaLibraryPickerField");
var allFieldNames = allMediaFld.Select(s => ct.Name + "." + s.Name + ".");
listFields.AddRange(allFieldNames);
}
query = query.Join <FieldIndexPartRecord>().Where(w => w.StringFieldIndexRecords.Any(
w2 => listFields.Contains(w2.PropertyName) && w2.Value != ""
));
lQuery = lQuery.Join <FieldIndexPartRecord>().Where(w => w.StringFieldIndexRecords.Any(
w2 => listFields.Contains(w2.PropertyName) && w2.Value != ""
));
}
// Extended Status query
if (!String.IsNullOrWhiteSpace(model.AdvancedOptions.SelectedStatus))
{
query = query.Join <FieldIndexPartRecord>().Where(w => w.StringFieldIndexRecords.Any(
w2 => w2.PropertyName == "PublishExtensionPart.PublishExtensionStatus." && w2.Value == model.AdvancedOptions.SelectedStatus
));
lQuery = lQuery.Join <FieldIndexPartRecord>().Where(w => w.StringFieldIndexRecords.Any(
w2 => w2.PropertyName == "PublishExtensionPart.PublishExtensionStatus." && w2.Value == model.AdvancedOptions.SelectedStatus
));
}
// FILTER QUERIES: END //
switch (model.Options.OrderBy)
{
case ContentsOrder.Modified:
//query = query.OrderByDescending<ContentPartRecord, int>(ci => ci.ContentItemRecord.Versions.Single(civr => civr.Latest).Id);
query = query.OrderByDescending <CommonPartRecord>(cr => cr.ModifiedUtc);
lQuery = lQuery.OrderByDescending <CommonPartRecord>(cr => cr.ModifiedUtc);
break;
case ContentsOrder.Published:
query = query.OrderByDescending <CommonPartRecord>(cr => cr.PublishedUtc);
lQuery = lQuery.OrderByDescending <CommonPartRecord>(cr => cr.PublishedUtc);
break;
case ContentsOrder.Created:
//query = query.OrderByDescending<ContentPartRecord, int>(ci => ci.Id);
query = query.OrderByDescending <CommonPartRecord>(cr => cr.CreatedUtc);
lQuery = lQuery.OrderByDescending <CommonPartRecord>(cr => cr.CreatedUtc);
break;
}
model.Options.SelectedFilter = model.TypeName;
model.Options.FilterOptions = GetListableTypes(false)
.Select(ctd => new KeyValuePair <string, string>(ctd.Name, ctd.DisplayName))
.ToList().OrderBy(kvp => kvp.Value);
// FILTER MODELS: START //
// language filter model
model.AdvancedOptions.LanguageOptions = _commonService.ListCultures().Select(x => new KeyValuePair <int, string>(x.Id, x.Culture));
// taxonomy filter model
var termList = new List <KeyValuePair <int, string> >();
foreach (var taxonomy in _taxonomyService.GetTaxonomies())
{
termList.Add(new KeyValuePair <int, string>(-1, taxonomy.Name));
foreach (var term in _taxonomyService.GetTerms(taxonomy.Id))
{
var gap = new string('-', term.GetLevels());
if (gap.Length > 0)
{
gap += " ";
}
termList.Add(new KeyValuePair <int, string>(term.Id, gap + term.Name));
}
}
model.AdvancedOptions.TaxonomiesOptions = termList;
// extended status
var partDefinition = _contentDefinitionService.GetPart("PublishExtensionPart");
if (partDefinition != null)
{
var partField = partDefinition.Fields.Where(w => w.Name == "PublishExtensionStatus").SingleOrDefault();
var settings = partField.Settings.GetModel <EnumerationFieldSettings>().Options;
string[] options = (!String.IsNullOrWhiteSpace(settings)) ? settings.Split(new string[] { System.Environment.NewLine }, StringSplitOptions.None) : null;
model.AdvancedOptions.StatusOptions = options.Select(s => new KeyValuePair <string, string>(s, T(s).Text));
}
#region TEST OF CPF QUERIES
//if (model.AdvancedOptions.CPFOwnerId != null) {
// var item = _contentManager.Get((int)model.AdvancedOptions.CPFOwnerId);
// var parts = item.Parts;
// list = Shape.List();
// foreach (var part in parts) {
// foreach (var field in part.Fields) {
// if (field.FieldDefinition.Name == "ContentPickerField") {
// bool noName = String.IsNullOrWhiteSpace(model.AdvancedOptions.CPFName);
// if (noName || (!noName && field.Name == model.AdvancedOptions.CPFName)) {
// var relatedItems = _contentManager.GetMany<ContentItem>((IEnumerable<int>)field.GetType().GetProperty("Ids").GetValue(field), VersionOptions.Latest, QueryHints.Empty);
// list.AddRange(relatedItems.Select(ci => _contentManager.BuildDisplay(ci, "SummaryAdmin")));
// }
// }
// }
// }
//}
if (model.AdvancedOptions.CPFIdToSearch != null && !String.IsNullOrWhiteSpace(model.AdvancedOptions.CPFName))
{
//given an Id, search for all items that have a Content Picker Field whose PropertyName is PCFName and that have the
//Id among the corresponding values.
string fieldName = (string)model.AdvancedOptions.CPFName;
query = query.Join <FieldIndexPartRecord>()
.Where(fip =>
fip.StringFieldIndexRecords
.Any(sfi =>
sfi.PropertyName.Contains(fieldName) &&
sfi.LatestValue.Contains("{" + model.AdvancedOptions.CPFIdToSearch.ToString() + "}")
)
);
lQuery = lQuery.Join <FieldIndexPartRecord>()
.Where(fip =>
fip.StringFieldIndexRecords
.Any(sfi =>
sfi.PropertyName.Contains(fieldName) &&
sfi.LatestValue.Contains("{" + model.AdvancedOptions.CPFIdToSearch.ToString() + "}")
)
);
}
#endregion
// FILTER MODELS: END //
//EXECUTE QUERIES
var pagerShape = Shape.Pager(pager).TotalItemCount(0);
var list = Shape.List();
IEnumerable <ContentItem> pageOfContentItems = (IEnumerable <ContentItem>)null;
//Stopwatch sw = Stopwatch.StartNew();
//the user may not have permission to see anything: in that case, do not execute the query
#region original query
//this is roughly 1000 slower than the variant below
//if (Services.Authorizer.Authorize(AdvancedSearchPermissions.CanSeeOwnContents)) {
// // language query
// //For any language query, remember that Orchard's localization table, as of Orchard 1.8, has an issue where the content
// //created but never translated does not have the default Culture assigned to it.
// Expression<Func<LocalizationPartRecord, bool>> selLangPredicate = null;
// if (model.AdvancedOptions.SelectedLanguageId > 0) {
// bool siteCultureSelected = _cultureManager.GetSiteCulture() == _cultureManager.GetCultureById(model.AdvancedOptions.SelectedLanguageId).Culture;
// if (siteCultureSelected) {
// selLangPredicate =
// x => x.CultureId == model.AdvancedOptions.SelectedLanguageId ||
// x.CultureId == 0;
// } else {
// selLangPredicate =
// x => x.CultureId == model.AdvancedOptions.SelectedLanguageId;
// }
// }
// if (model.AdvancedOptions.SelectedLanguageId > 0) {
// query = query.Join<LocalizationPartRecord>().Where(selLangPredicate);
// }
// //if we want only items that do not have a specific translation, we have to do things differently,
// //because the check is done after the query. Hence, for example, we cannot directly page.
// if (model.AdvancedOptions.SelectedUntranslatedLanguageId > 0) {
// var allCi = query.List();
// //for (int i = 0; i < allCi.Count(); i++) { //this loop is used to test null conditions and other stuff like that while debugging
// // var ci = allCi.ElementAt(i);
// // if (ci.Is<LocalizationPart>()) {
// // var lci = _localizationService.GetLocalizations(ci, versionOptions);
// // var clci = lci.Count();
// // var bo = lci.Any(li => li.Culture.Id == model.AdvancedOptions.SelectedUntranslatedLanguageId);
// // }
// //}
// var untranslatedCi = allCi
// .Where(x =>
// x.Is<LocalizationPart>() && //the content is translatable
// (
// x.As<LocalizationPart>().Culture == null || //this is the case where the content was created and never translated to any other culture.
// x.As<LocalizationPart>().Culture.Id != model.AdvancedOptions.SelectedUntranslatedLanguageId //not a content in the language in which we are looking translations
// ) &&
// _localizationService.GetLocalizations(x, versionOptions) != null &&
// !_localizationService.GetLocalizations(x, versionOptions).Any(li =>
// li.Culture != null &&
// li.Culture.Id == model.AdvancedOptions.SelectedUntranslatedLanguageId
// )
// );
// //.Where(x =>
// // x.Is<LocalizationPart>() && //some content items may not be translatable
// // (
// // (x.As<LocalizationPart>().Culture != null && x.As<LocalizationPart>().Culture.Id != model.AdvancedOptions.SelectedUntranslatedLanguageId) ||
// // (x.As<LocalizationPart>().Culture == null) //this is the case where the content was created and never translated to any other culture.
// // //In that case, in Orchard 1.8, no culture is directly assigned to it, even though the default culture is assumed.
// // ) &&
// // x.As<LocalizationPart>().MasterContentItem == null &&
// // !allCi.Any(y =>
// // y.Is<LocalizationPart>() &&
// // (y.As<LocalizationPart>().MasterContentItem == x || y.As<LocalizationPart>().MasterContentItem == x.As<LocalizationPart>().MasterContentItem) &&
// // y.As<LocalizationPart>().Culture.Id == model.AdvancedOptions.SelectedUntranslatedLanguageId
// // )
// //);
// //Paging
// pagerShape = Shape.Pager(pager).TotalItemCount(untranslatedCi.Count());
// int pSize = pager.PageSize != 0 ? pager.PageSize : untranslatedCi.Count();
// pageOfContentItems = untranslatedCi
// .Skip(pager.GetStartIndex())
// .Take((pager.GetStartIndex() + pSize) > untranslatedCi.Count() ?
// untranslatedCi.Count() - pager.GetStartIndex() :
// pSize)
// .ToList();
// } else {
// pagerShape = Shape.Pager(pager).TotalItemCount(query.Count());
// pageOfContentItems = query.Slice(pager.GetStartIndex(), pager.PageSize).ToList();
// }
//} else {
// Services.Notifier.Error(T("Not authorized to visualize any item."));
//}
#endregion
if (Services.Authorizer.Authorize(AdvancedSearchPermissions.CanSeeOwnContents))
{
// language queries
//For any language query, remember that Orchard's localization table, as of Orchard 1.8, has an issue where the content
//created but never translated does not have the default Culture assigned to it.
Expression <Func <LocalizationPartRecord, bool> > selLangPredicate = null;
if (model.AdvancedOptions.SelectedLanguageId > 0)
{
bool siteCultureSelected = _cultureManager.GetSiteCulture() == _cultureManager.GetCultureById(model.AdvancedOptions.SelectedLanguageId).Culture;
if (siteCultureSelected)
{
selLangPredicate =
x => x.CultureId == model.AdvancedOptions.SelectedLanguageId ||
x.CultureId == 0;
}
else
{
selLangPredicate =
x => x.CultureId == model.AdvancedOptions.SelectedLanguageId;
}
query = query.Join <LocalizationPartRecord>().Where(selLangPredicate);
}
Expression <Func <LocalizationPartRecord, bool> > untranLangPredicate = null;
if (model.AdvancedOptions.SelectedUntranslatedLanguageId > 0)
{
bool siteCultureSelected = _cultureManager.GetSiteCulture() == _cultureManager.GetCultureById(model.AdvancedOptions.SelectedUntranslatedLanguageId).Culture;
if (siteCultureSelected)
{
untranLangPredicate =
x => x.CultureId == model.AdvancedOptions.SelectedUntranslatedLanguageId ||
x.CultureId == 0;
}
else
{
untranLangPredicate =
x => x.CultureId == model.AdvancedOptions.SelectedUntranslatedLanguageId;
}
lQuery = lQuery.Join <LocalizationPartRecord>().Where(untranLangPredicate);
var lRes = lQuery.List();
var masters = lRes.Where(x => x.As <LocalizationPart>().Record.MasterContentItemId != 0).Select(x => x.As <LocalizationPart>().Record.MasterContentItemId).ToList();
var items = lRes.Select(x => x.Id).ToList();
Expression <Func <LocalizationPartRecord, bool> > sulPredicate =
x => x.CultureId != model.AdvancedOptions.SelectedUntranslatedLanguageId &&
!masters.Contains(x.Id) && !masters.Contains(x.MasterContentItemId) && !items.Contains(x.MasterContentItemId);
query = query.Join <LocalizationPartRecord>().Where(sulPredicate);
}
pagerShape = Shape.Pager(pager).TotalItemCount(query.Count());
pageOfContentItems = query.Slice(pager.GetStartIndex(), pager.PageSize).ToList();
}
else
{
Services.Notifier.Error(T("Not authorized to visualize any item."));
}
//sw.Stop();
//Services.Notifier.Error(new LocalizedString(sw.Elapsed.TotalMilliseconds.ToString()));
if (pageOfContentItems != null)
{
list.AddRange(pageOfContentItems.Select(ci => _contentManager.BuildDisplay(ci, "SummaryAdmin")));
}
var viewModel = Shape.ViewModel()
.ContentItems(list)
.Pager(pagerShape)
.Options(model.Options)
.AdvancedOptions(model.AdvancedOptions)
.TypeDisplayName(model.TypeDisplayName ?? "");
return(View(viewModel));
}