コード例 #1
0
 public Customer FindByEmailAddress(string emailAddress)
 {
     return(_sessionFactory.GetCurrentSession().CreateCriteria <Customer>()
            .CreateAlias(PropertyNameHelper.ResolvePropertyName <Customer>(c => c.UserLogin), "user")
            .Add(Restrictions.Eq("user.Username", emailAddress))
            .UniqueResult <Customer>());
 }
コード例 #2
0
    public static Criterion Create <T>(Expression <Func <T, object> > expression, object value, CriteriaOperator criteriaOperator)
    {
        string    propertyName = PropertyNameHelper.ResolvePropertyName <T>(expression);
        Criterion myCriterion  = new Criterion(propertyName, value, criteriaOperator);

        return(myCriterion);
    }
コード例 #3
0
 public bool Exists(string firstName, string lastName, string emailAddress)
 {
     return(_sessionFactory.GetCurrentSession().CreateCriteria <Customer>()
            .Add(Restrictions.Eq(PropertyNameHelper.ResolvePropertyName <Customer>(c => c.FirstName), firstName))
            .Add(Restrictions.Eq(PropertyNameHelper.ResolvePropertyName <Customer>(c => c.LastName), lastName))
            .CreateAlias(PropertyNameHelper.ResolvePropertyName <Customer>(c => c.UserLogin), "user")
            .Add(Restrictions.Eq("user.Username", emailAddress))
            .UniqueResult <Customer>() != null);
 }
コード例 #4
0
        public Customer FindBy(string identityToken)
        {
            ICriteria criteriaQuery = SessionFactory.GetCurrentSession().CreateCriteria(typeof(Customer))
                                      .Add(Expression.Eq(PropertyNameHelper.ResolvePropertyName <Customer>(c => c.IdentityToken), identityToken));

            IList <Customer> customers = criteriaQuery.List <Customer>();

            Customer customer = customers.FirstOrDefault();

            return(customer);
        }
コード例 #5
0
        public GetFeaturedProductsResponse GetFeaturedProducts()
        {
            GetFeaturedProductsResponse response = new GetFeaturedProductsResponse();

            Query productQuery = new Query();

            productQuery.OrderByProperty = new OrderByClause()
            {
                Desc = true, PropertyName = PropertyNameHelper.ResolvePropertyName <ProductTitle>(pt => pt.Price)
            };

            response.Products = _productTitleRepository.FindBy(productQuery, 0, 6).ConvertToProductViews();

            return(response);
        }
コード例 #6
0
        //Returns all the pseudo SKUs
        public async Task <GetAllPseudoSkusResponse> GetAllPseudoSkus()
        {
            GetAllPseudoSkusResponse response = new GetAllPseudoSkusResponse();

            Query pseudoSkuQuery = new Query();

            pseudoSkuQuery.OrderByProperty = new OrderByClause()
            {
                Desc         = true,
                PropertyName = PropertyNameHelper.ResolvePropertyName <PseudoSkuTitle>(pt => pt.Price)
            };

            var pseudoSkus = await _pseudoSkuTitleRepository.FindByAsync(pseudoSkuQuery, 0, 6);

            response.Products = _mapper.Map <IEnumerable <PseudoSkuSummaryView> >(pseudoSkus);

            return(response);
        }
コード例 #7
0
        public IEnumerable <Order> FindAllCustomersOrdersWithInOrderDateBy(Guid customerId, DateTime orderDate)
        {
            IEnumerable <Order> customerOrders = new List <Order>();

            Query query = new Query();

            //query.Add(new Criterion("CustomerId", customerId, CriteriaOperator.Equal));
            query.Add(Criterion.Create <Order>(x => x.CustomerId, customerId, CriteriaOperator.Equal));
            query.QueryOperator = QueryOperator.And;
            //query.Add(new Criterion("OrderDate", orderDate, CriteriaOperator.LessThanOrEqual));
            query.Add(Criterion.Create <Order>(x => x.OrderDate, orderDate, CriteriaOperator.LessThanOrEqual));
            //query.OrderByProperty = new OrderByClause { PropertyName = "OrderDate", Desc = true };
            query.OrderByProperty = new OrderByClause
            {
                PropertyName = PropertyNameHelper.ResolvePropertyName <Order>(x => x.OrderDate),
                Desc         = true
            };

            customerOrders = _orderRepository.FindBy(query);

            return(customerOrders);
        }