示例#1
0
        public ActionResult Search(string q)
        {
            var items = RavenSession.Query<Item, Search_Items>()
                    .Where(i => i.Owner == UserId)
                    //.OrderByDescending(p => p.Created)
                    .ToList();

            var vm = new ItemsViewModel()
            {
                Items = items,
            };

            return View("Index", vm);
        }
示例#2
0
        public ActionResult ByCategory(string id)
        {
            var items = RavenSession.Query<Item>()
                   .Where(i => i.Owner == UserId)
                   // .Where(i => i.Categories.Contains(id)) // Fails!
                   .OrderByDescending(p => p.Created)
                   .ToList();

            items = items.Where(i => i.Categories.Contains(id)).ToList();

            var vm = new ItemsViewModel()
            {
                Items = items,
            };

            return View("Index", vm);
        }
示例#3
0
        //
        // GET: /Items/Category id
        public ActionResult Index(string id = "")
        {
            RavenQueryStatistics stats;
            var items = RavenSession.Query<Item>()
                .Statistics(out stats)
                .Where(i => i.Owner == UserId)
                .OrderByDescending(p => p.Created)
                //.Customize(q => q.WaitForNonStaleResultsAsOfLastWrite())
                .ToList();

            if (id != "")
            {
                items = items.Where(i => i.Categories.Contains(id)).ToList();
            }

            var vm = new ItemsViewModel()
                     {
                         Items = items,
                     };

            return View(vm);
        }