Try your search with a different keyword or use * as a wildcard.
using Nop.Core.Domain.Catalog;
using Nop.Core.Domain.Localization;
using Nop.Data;
namespace Nop.Services.Catalog;
public static class ProductExtensions
{
///
/// Sorts the elements of a sequence in order according to a product sorting rule
///
/// A sequence of products to order
/// Current language
/// Product sorting rule
/// Localized property repository
/// An System.Linq.IOrderedQueryable`1 whose elements are sorted according to a rule.
///
/// If Position and passed
public static IQueryable OrderBy(this IQueryable productsQuery, IRepository localizedPropertyRepository, Language currentLanguage, ProductSortingEnum orderBy)
{
if (orderBy == ProductSortingEnum.NameAsc || orderBy == ProductSortingEnum.NameDesc)
{
var currentLanguageId = currentLanguage.Id;
var query =
from product in productsQuery
join localizedProperty in localizedPropertyRepository.Table on new
{
product.Id,
languageId = currentLanguageId,
keyGroup = nameof(Product),
key = nameof(Product.Name)
}
equals new
{
Id = localizedProperty.EntityId,
languageId = localizedProperty.LanguageId,
keyGroup = localizedProperty.LocaleKeyGroup,
key = localizedProperty.LocaleKey
} into localizedProperties
from localizedProperty in localizedProperties.DefaultIfEmpty(new LocalizedProperty { LocaleValue = product.Name })
select new
{
sortName = localizedProperty == null ? product.Name : localizedProperty.LocaleValue,
product
};
if (orderBy == ProductSortingEnum.NameAsc)
productsQuery = from item in query
orderby item.sortName
select item.product;
else
productsQuery = from item in query
orderby item.sortName descending
select item.product;
return productsQuery;
}
return orderBy switch
{
ProductSortingEnum.PriceAsc => productsQuery.OrderBy(p => p.Price),
ProductSortingEnum.PriceDesc => productsQuery.OrderByDescending(p => p.Price),
ProductSortingEnum.CreatedOn => productsQuery.OrderByDescending(p => p.CreatedOnUtc),
ProductSortingEnum.Position when productsQuery is IOrderedQueryable => productsQuery,
_ => productsQuery.OrderBy(p => p.DisplayOrder).ThenBy(p => p.Id)
};
}
}