コード例 #1
0
        /// <summary>
        /// لیست تمامی محصولات
        /// </summary>
        /// <param name="vm"></param>
        /// <returns></returns>
        public async Task <IActionResult> ProductDiscountIndex(ProductSearchListViewModel vm)
        {
            var test = configuration.GetSection(nameof(SiteSettings)).Get <SiteSettings>();

            var model = await _productRepository.GetProductsDiscount(vm, this.CurrentPage, this.PageSize);

            ViewBag.Category = await _productGroupRepository.GetParentsAsync();

            ViewBag.Url      = test.SiteConfig.UrlAddress;
            ViewBag.Search   = vm;
            ViewBag.MaxPrice = model != null && model.Item2.Count > 0 ? model.Item2.Max(a => a.Price) : 1000000;
            ViewBag.Count    = model.Item2.Count().ToPersianNumbers();

            this.TotalNumber = model.Item1;

            return(View(model.Item2));
        }
コード例 #2
0
        public async Task <Tuple <int, List <DataLayer.Entities.Product> > > GetProductsDiscount(ProductSearchListViewModel vm, int skip, int take)
        {
            var model = TableNoTracking
                        .Include(a => a.ProductGroup)
                        .Where(a => a.IsActive == true && !a.IsDeleted && a.Price != a.PriceWithDiscount);

            if (vm.Group != null && vm.Group != -1)
            {
                string sql = @"
                        declare @T table(Id int);

                        with A as (
                           select Id, ParentId
                               from ProductGroup
                               where Id = " + vm.Group.Value + @"
                               union all
                           select c.Id, c.ParentId
                               from ProductGroup c
                                   join A p on p.Id = c.ParentId) 

                        select Id from A";

                var result = await _connection.QueryMultipleAsync(sql);

                var groupsId = await result.ReadAsync <int>();


                model = model
                        .WhereIf(!string.IsNullOrEmpty(vm.Title), a => a.Title.Contains(vm.Title) ||
                                 a.ShortDescription.Contains(vm.Title) ||
                                 a.Text.Contains(vm.Title) ||
                                 a.Tags.Contains(vm.Title))
                        //.WhereIf(vm.Group != null && vm.Group != -1, a => a.ProductGroupId.Equals(vm.Group.Value))
                        .WhereIf(vm.Group != null && vm.Group != -1, a => groupsId.Contains(a.ProductGroupId))
                        .WhereIf(vm.MaxPrice != null && vm.MinPrice != null, a => a.Price >= long.Parse(vm.MinPrice) && a.Price <= long.Parse(vm.MaxPrice));
            }

            else
            {
                model = model
                        .WhereIf(!string.IsNullOrEmpty(vm.Title), a => a.Title.Contains(vm.Title) ||
                                 a.ShortDescription.Contains(vm.Title) ||
                                 a.Text.Contains(vm.Title) ||
                                 a.Tags.Contains(vm.Title))

                        .WhereIf(vm.MaxPrice != null && vm.MinPrice != null, a => a.Price >= long.Parse(vm.MinPrice) && a.Price <= long.Parse(vm.MaxPrice));
            }
            var count = model.Count();

            if (skip != 0)
            {
                model = model.Skip((skip - 1) * take);
            }

            if (take != 0)
            {
                model = model.Take(take);
            }

            return(new Tuple <int, List <DataLayer.Entities.Product> >(count, await model.ToListAsync()));
        }