Skip to content

Open-source eCommerce platform for C# and ASP.NET Core 10 with MongoDB. Build multi-store shops and multi-vendor marketplaces with B2B/B2C, REST API, plugins, Vue 3 and Docker.

5.1 KB
Raw Blame
using Grand.Business.Core.Queries.Customers;
using Grand.Data;
using Grand.Domain.Customers;
using Grand.Mediator;
using System.Linq.Expressions;

namespace Grand.Business.Customers.Queries.Handlers;

public class GetCustomerQueryHandler : IRequestHandler<GetCustomerQuery, IQueryable<Customer>>
{
    private readonly IRepository<Customer> _customerRepository;

    public GetCustomerQueryHandler(IRepository<Customer> customerRepository)
    {
        _customerRepository = customerRepository;
    }

    public Task<IQueryable<Customer>> Handle(GetCustomerQuery request, CancellationToken cancellationToken)
    {
        var query = from p in _customerRepository.Table
            select p;

        if (request.CreatedFromUtc.HasValue)
            query = query.Where(c => request.CreatedFromUtc.Value <= c.CreatedOnUtc);
        if (request.CreatedToUtc.HasValue)
            query = query.Where(c => request.CreatedToUtc.Value >= c.CreatedOnUtc);
        if (!string.IsNullOrEmpty(request.AffiliateId))
            query = query.Where(c => request.AffiliateId == c.AffiliateId);
        if (!string.IsNullOrEmpty(request.VendorId))
            query = query.Where(c => request.VendorId == c.VendorId);
        if (!string.IsNullOrEmpty(request.StoreId))
            query = query.Where(c => c.StoreId == request.StoreId);
        if (!string.IsNullOrEmpty(request.OwnerId))
            query = query.Where(c => c.OwnerId == request.OwnerId);
        if (!string.IsNullOrEmpty(request.SalesEmployeeId))
            query = query.Where(c => c.SeId == request.SalesEmployeeId);

        query = query.Where(c => !c.Deleted);
        if (request.CustomerGroupIds is { Length: > 0 })
            query = query.Where(c => c.Groups.Any(x => request.CustomerGroupIds.Contains(x)));
        if (request.CustomerTagIds is { Length: > 0 })
            foreach (var item in request.CustomerTagIds)
                query = query.Where(c => c.CustomerTags.Contains(item));
        if (!string.IsNullOrWhiteSpace(request.Email))
            query = query.Where(c => c.Email != null && c.Email.Contains(request.Email.ToLower()));
        if (!string.IsNullOrWhiteSpace(request.Username))
            query = query.Where(c => c.Username != null && c.Username.ToLower().Contains(request.Username.ToLower()));

        if (!string.IsNullOrWhiteSpace(request.FirstName))
            query = query.Where(x => x.UserFields.Any(y =>
                y.Key == SystemCustomerFieldNames.FirstName && y.Value != null &&
                y.Value.ToLower().Contains(request.FirstName.ToLower())));

        if (!string.IsNullOrWhiteSpace(request.LastName))
            query = query.Where(x => x.UserFields.Any(y =>
                y.Key == SystemCustomerFieldNames.LastName && y.Value != null &&
                y.Value.ToLower().Contains(request.LastName.ToLower())));

        //search by company
        if (!string.IsNullOrWhiteSpace(request.Company))
            query = query.Where(x => x.UserFields.Any(y =>
                y.Key == SystemCustomerFieldNames.Company && y.Value != null &&
                y.Value.ToLower().Contains(request.Company.ToLower())));
        //search by phone
        if (!string.IsNullOrWhiteSpace(request.Phone))
            query = query.Where(x => x.UserFields.Any(y =>
                y.Key == SystemCustomerFieldNames.Phone && y.Value != null &&
                y.Value.ToLower().Contains(request.Phone.ToLower())));
        //search by zip
        if (!string.IsNullOrWhiteSpace(request.ZipPostalCode))
            query = query.Where(x => x.UserFields.Any(y =>
                y.Key == SystemCustomerFieldNames.ZipPostalCode && y.Value != null &&
                y.Value.ToLower().Contains(request.ZipPostalCode.ToLower())));

        if (request.LoadOnlyWithShoppingCart)
            query = request.Sct.HasValue
                ? query.Where(c => c.ShoppingCartItems.Any(x => x.ShoppingCartTypeId == request.Sct.Value))
                : query.Where(c => c.ShoppingCartItems.Any());

        if (request.OrderBySelector == null)
        {
            query = query.OrderByDescending(c => c.CreatedOnUtc);
        }
        else
        {
            var propName = GetName(request.OrderBySelector);
            query = OrderingHelper(query, propName);
        }

        return Task.FromResult(query);
    }

    private static string GetName(Expression<Func<Customer, object>> exp)
    {
        if (exp.Body is MemberExpression body) return body.Member.Name;
        var expBody = (UnaryExpression)exp.Body;
        body = expBody.Operand as MemberExpression;
        return body?.Member.Name;
    }

    private static IOrderedQueryable<T> OrderingHelper<T>(IQueryable<T> source, string propertyName)
    {
        var param = Expression.Parameter(typeof(T), propertyName);
        var property = Expression.PropertyOrField(param, propertyName);
        var sort = Expression.Lambda(property, param);

        var call = Expression.Call(
            typeof(Queryable),
            "OrderByDescending",
            [typeof(T), property.Type],
            source.Expression,
            Expression.Quote(sort));

        return (IOrderedQueryable<T>)source.Provider.CreateQuery<T>(call);
    }
}