コード例 #1
0
        public ActionResult Index()
        {
            var model = new StartPageViewModel();
            apiModelBook.TopFiveBooks = apiModelBook.GetTopFiveBooksFromDb("api/APIDbTopFiveBooks", "?");
            model.BookList = CacheHelper.GetAllBooks("0","0");
            model.TopFive = apiModelBook.TopFiveBooks;

            return View(model);
        }
コード例 #2
0
        public PartialViewResult FullList()
        {
            var model = new StartPageViewModel();

            List<BookModel> books = new List<BookModel>();
            apiModelBook.TopFiveBooks = apiModelBook.GetTopFiveBooksFromDb("api/APIDbTopFiveBooks", "?");
            model.BookList = CacheHelper.GetAllBooks("0", "20");
            model.TopFive = apiModelBook.TopFiveBooks;
            return PartialView("_fullbookslist", model);
        }
コード例 #3
0
 public PartialViewResult PageJump(int pageNr)
 {
     var model = new StartPageViewModel();
     var nr = ((pageNr * 20)-20).ToString();
     model.BookList = CacheHelper.GetAllBooks(nr,"20");
     return PartialView("_fullbookslist", model);
 }
コード例 #4
0
        public ActionResult Search(string search)
        {
            var searchString = string.Empty;
            search = search.ToLower();

            if (search.IndexOf("&") > 0)
            {
                var tempGenreName = string.Empty;
                var tempAuthorFirstName = string.Empty;
                var tempAuthorLastName = string.Empty;
                var tempReaderFirstName = string.Empty;
                var tempReaderLastName = string.Empty;
                var stringArr = search.Split('&');

                foreach (var item in stringArr)
                {
                    tempGenreName += " contains(tolower(g/Name),  '" + item + "') and ";
                    tempAuthorFirstName += " contains(tolower(a/FirstName),  '" + item + "') and ";
                    tempAuthorLastName += " contains(tolower(a/LastName),  '" + item + "') and ";
                    tempReaderFirstName += " contains(tolower(r/FirstName),  '" + item + "') and ";
                    tempReaderLastName += " contains(tolower(r/LastName),  '" + item + "') and ";

                }
                tempGenreName = tempGenreName.Substring(0, tempGenreName.Length - 5);
                tempAuthorFirstName = tempAuthorFirstName.Substring(0, tempAuthorFirstName.Length - 5);
                tempAuthorLastName = tempAuthorLastName.Substring(0, tempAuthorLastName.Length - 5);
                tempReaderFirstName = tempReaderFirstName.Substring(0, tempReaderFirstName.Length - 5);
                tempReaderLastName = tempReaderLastName.Substring(0, tempReaderLastName.Length - 5);
                search = search.Replace("&", "");

                var startString = "api/APIDbBook?$filter=contains(tolower(Title), '" + search + "') " +
                    "or contains(tolower(Description), '" + search + "')  or ISBN eq '" + search + "' "+
                    "or tolower(Language/Name) eq  '" + search + "'  or tolower(Format/Name) eq  '" + search + "' or Genres/any(g:" ;

                var reader = " or Readers/any(r:";
                var author = " or Authors/any(a:";

                searchString = startString + tempGenreName + ")" + reader + tempReaderFirstName + " and " + tempReaderLastName + ")" + author + tempAuthorFirstName + " and " + tempAuthorLastName + ")";

            }
            else
            {
                searchString = "api/APIDbBook?$filter=contains(tolower(Title), '" + search + "') " +
                "or contains(tolower(Description), '" + search + "') or ISBN eq '" + search + "' "+
                " or Authors/any(a: tolower(a/FirstName) eq '" + search + "') " +
                "or Authors/any(a: tolower(a/LastName) eq '" + search + "') or Genres/any(g: contains(tolower(g/Name),  '" + search + "')) or Readers/any(r: tolower(r/FirstName) eq '" + search + "') " +
                "or Readers/any(r: tolower(r/LastName) eq '" + search + "') or tolower(Format/Name) eq  '" + search + "' or tolower(Language/Name) eq  '" + search + "'";

            }

            var model = new StartPageViewModel();
            var searchResults = apiModelBook.GetAllBooksFromDb(searchString);
            model.BookList = searchResults;
            apiModelBook.TopFiveBooks = apiModelBook.GetTopFiveBooksFromDb("api/APIDbTopFiveBooks", "?");
            model.TopFive = apiModelBook.TopFiveBooks;
            if (model.BookList == null)
            {
                model.ErrorInSearchResult = true;
                return PartialView("_bookslist", model);
            }
            if (model.BookList.Count == 0)
            {
                model.NoSearchResultFound = true;

            }
            return PartialView("_bookslist", model);
        }