コード例 #1
0
        public IQueryable<Property> FindBySearchModel(PropertySearchModel sm)
        {
            if (sm.PropertyLocation == null || sm.PropertyLocation.Count == 0)
                throw new ArgumentException("Suburb must be provided.");

            if (String.IsNullOrEmpty(sm.RentOrSale))
                throw new ArgumentException("Must specify rent or sale.");

            IQueryable<Property> ps = from p in db.Properties
                                      where sm.PropertyLocation.Contains(p.suburb_id) &&
                                            p.rent_or_sale == sm.RentOrSale.ToLower() &&
                                           (string.IsNullOrEmpty(p.status) || p.status != PROPERTY_STATUS_ARCHIVED)
                                      select p;

            if (sm.PropertyTypes != null && sm.PropertyTypes.Count(pt => pt != 0) > 0)
            {
                ps = ps.Where(p => sm.PropertyTypes.Contains(p.property_type));
            }

            if (sm.NumOfBedroom.HasValue)
            {
                ps = ps.Where(p => p.num_of_bedroom >= sm.NumOfBedroom);
            }

            if (sm.NumOfBathroom.HasValue)
            {
                ps = ps.Where(p => p.num_of_bathroom >= sm.NumOfBathroom);
            }

            if (sm.NumOfCarspace.HasValue)
            {
                ps = ps.Where(p => p.num_of_carspace >= sm.NumOfCarspace);
            }

            if (sm.MinPrice.HasValue)
            {
                ps = ps.Where(p => !p.min_price.HasValue || p.min_price >= sm.MinPrice);
            }

            if (sm.MaxPrice.HasValue)
            {
                ps = ps.Where(p => !p.max_price.HasValue || p.max_price <= sm.MaxPrice);
            }

            return ps;
        }
コード例 #2
0
        public ActionResult Search(PropertySearchModel sm, int? page, string sortOrder)
        {
            ViewBag.SortParam = sortOrder;
            SetSearchViewBag();
            var models = from m in repository.FindBySearchModel(sm)
                         where m.Language.LanguageName == CultureInfo.CurrentUICulture.Name
                         select m;

            switch (sortOrder)
            {
                case "hp":
                    models = models.OrderByDescending(p => p.min_price);
                    break;
                case "lp":
                    models = models.OrderBy(p => p.min_price);
                    break;
                default:
                    models = models.OrderByDescending(p => p.added_on);
                    break;
            }

            var listModels = models.AsEnumerable().Select(p => p.ToListModel());
            var pageNumber = page ?? 1;
            return View("Index", listModels.ToPagedList(pageNumber, PAGE_SIZE));
        }