public static List<BookModel> GetAllBooks(string skip, string top)
{
var cache = HttpContext.Current.Cache["allBooks"];
var model = new BookModel();
List<BookModel> listAllBooks = new List<BookModel>();
if (cache == null)
{
GetApiResponse<BookModel> apiModelBook= new GetApiResponse<BookModel>();
listAllBooks = apiModelBook.GetAllBooksFromDb("api/APIDbBook?");
BookCount = listAllBooks.Count;
if (top=="0")
{
listAllBooks = apiModelBook.GetAllBooksFromDb("api/APIDbBook?");
}
else
{
listAllBooks = apiModelBook.GetAllBooksFromDb("api/APIDbBook?$skip=" + skip + "&$top=" + top );
}
cache = listAllBooks;
}
else
{
listAllBooks = cache as List<BookModel>;
}
return listAllBooks;
}
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));
}
