public IEnumerable <Book> ExecuteQueryWith(BookSearchCriteria input) { var db = Database.Open(); dynamic branches, categories; SimpleQuery query = db.BOOKS.All() .Join(db.BRANCH, out branches) .On(branches.ID == db.BOOKS.BRANCH_ID) .Join(db.BOOK_CATEGORY, out categories) .On(categories.BOOK_ID == db.BOOKS.CATEGORY_ID) .Select( db.BOOKS.BOOK_ID.As("BookId"), db.BOOKS.ISBN.As("ISBN"), db.BOOKS.TITLE.As("Title"), db.BOOKS.AUTHORS.As("Authors"), db.BOOKS.PUBLISHER.As("Publishers"), db.BOOKS.EDITION.As("Edition"), db.BOOKS.BRANCH_ID.As("BranchId"), branches.NAME.As("BranchName"), db.BOOKS.SEMISTER.As("Semister"), db.BOOKS.PRICE.As("Price"), db.BOOKS.QUANTITY.As("Quantity"), db.BOOKS.BOOK_LANGUAGE.As("Language"), db.BOOKS.CATEGORY_ID.As("CategoryId"), categories.DESCRIPTION.As("CategoryName"), db.BOOKS.DESCRIPTION.As("Description") ); query = query.Where(db.BOOKS.BRANCH_ID == input.BranchId && db.BOOKS.CATEGORY_ID == input.CategoryId); return(query.ToList <Book>()); }
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { var pageableRequests = new IndexerPageableRequestChain(); pageableRequests.Add(GetPagedRequests(string.Format("{0}", searchCriteria.SanitizedSearchTerm), searchCriteria)); return(pageableRequests); }
public virtual IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { var pageableRequests = new IndexerPageableRequestChain(); if (SupportsBookSearch) { AddBookPageableRequests(pageableRequests, searchCriteria, NewsnabifyTitle($"&author={searchCriteria.AuthorQuery}&title={searchCriteria.BookQuery}")); } if (SupportsSearch) { pageableRequests.AddTier(); pageableRequests.Add(GetPagedRequests(MaxPages, Settings.Categories, "search", NewsnabifyTitle($"&q={searchCriteria.BookQuery}+{searchCriteria.AuthorQuery}"))); pageableRequests.Add(GetPagedRequests(MaxPages, Settings.Categories, "search", NewsnabifyTitle($"&q={searchCriteria.AuthorQuery}+{searchCriteria.BookQuery}"))); } return(pageableRequests); }
public IEnumerable <Student> ExecuteQueryWith(BookSearchCriteria input) { var db = Database.Open(); SimpleQuery query = null; if (input.Application.Equals("Diploma", StringComparison.CurrentCultureIgnoreCase)) { query = db.DIPLOMASTUDENTS.All().Where(db.DIPLOMASTUDENTS.BRANCH_ID == input.BranchId); } else if (input.Application.Equals("Paramedical", StringComparison.CurrentCultureIgnoreCase)) { query = db.PARAMEDICALSTUDENTS.All().Where(db.PARAMEDICALSTUDENTS.BRANCH_ID == input.BranchId); } else if (input.Application.Equals("Degree", StringComparison.CurrentCultureIgnoreCase)) { query = db.DEGREESTUDENTS.All().Where(db.DEGREESTUDENTS.BRANCH_ID == input.BranchId); } else if (input.Application.Equals("Pharmacy", StringComparison.CurrentCultureIgnoreCase)) { query = db.PHARMACYSTUDENTS.All().Where(db.PHARMACYSTUDENTS.BRANCH_ID == input.BranchId); } else if (input.Application.Equals("Nursing", StringComparison.CurrentCultureIgnoreCase)) { query = db.NURSINGSTUDENTS.All().Where(db.NURSINGSTUDENTS.BRANCH_ID == input.BranchId); } return(query.ToList <Student>()); }
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { var pageableRequests = new IndexerPageableRequestChain(); pageableRequests.Add(GetRequest(string.Format("&artistname={0}&groupname={1}", searchCriteria.AuthorQuery, searchCriteria.BookQuery))); return(pageableRequests); }
public void SetUp() { UseRealHttp(); _bookSearchCriteria = new BookSearchCriteria() { }; }
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { var pageableRequests = new IndexerPageableRequestChain(); pageableRequests.Add(GetRequest(searchCriteria.SanitizedSearchTerm)); return(pageableRequests); }
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { var pageableRequests = new IndexerPageableRequestChain(); pageableRequests.Add(GetRequest("search-torrents", Settings.Categories, string.Format(" & type=name&query={0}+{1}", Uri.EscapeDataString(searchCriteria.AuthorQuery.Trim()), Uri.EscapeDataString(searchCriteria.BookQuery.Trim())))); return(pageableRequests); }
public virtual IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { var pageableRequests = new IndexerPageableRequestChain(); pageableRequests.Add(GetPagedRequests("search", null, "{0}+{1}", searchCriteria.AuthorQuery, searchCriteria.BookQuery)); return(pageableRequests); }
public override Task <IndexerPageableQueryResult> Fetch(BookSearchCriteria searchCriteria) { if (!SupportsSearch) { return(Task.FromResult(new IndexerPageableQueryResult())); } return(FetchReleases(g => SetCookieFunctions(g).GetSearchRequests(searchCriteria))); }
public override IList <ReleaseInfo> Fetch(BookSearchCriteria searchCriteria) { if (!SupportsSearch) { return(new List <ReleaseInfo>()); } return(FetchReleases(g => g.GetSearchRequests(searchCriteria))); }
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { var parameters = GetBasicSearchParameters(searchCriteria.SanitizedSearchTerm, searchCriteria.Categories); var pageableRequests = new IndexerPageableRequestChain(); pageableRequests.Add(GetRequest(parameters)); return(pageableRequests); }
//Search Option public List <Book> GetBookBySearch(BookSearchCriteria model) { IEnumerable <Book> books = db.Books.Where(b => b.isDelete == false).AsQueryable(); if (!string.IsNullOrEmpty(model.Title)) { books = books.Where(b => b.Title.ToString().ToLower().Contains(model.Title.ToString().ToLower())); } return(books.ToList()); }
// // GET: /Book/ public ActionResult Index(BookSearchCriteria model) { var books = _bookManager.GetAllBook(); if (books == null) { books = new List <Book>(); } model.LanguageListItem = GetLanguagelist(); model.DepartmentListItem = GetDepartmentlist(); model.Books = books; return(View(model)); }
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { _logger.Trace("Getting Book search"); var pageableRequests = new IndexerPageableRequestChain(); var variables = GetQueryVariableDefaults(searchCriteria); variables[".Query.Author"] = searchCriteria.Author; variables[".Query.Title"] = searchCriteria.Title; pageableRequests.Add(GetRequest(variables)); return(pageableRequests); }
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { var pageableRequests = new IndexerPageableRequestChain(); if (searchCriteria.SearchTerm.IsNotNullOrWhiteSpace()) { var titleYearSearchQuery = string.Format("{0}", searchCriteria.SanitizedSearchTerm); pageableRequests.Add(GetRequest("search-torrents", searchCriteria.Categories, string.Format("&type=name&query={0}", titleYearSearchQuery.Trim()))); } else { pageableRequests.Add(GetRequest("latest-torrents", searchCriteria.Categories, "")); } return(pageableRequests); }
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { var capabilities = _capabilitiesProvider.GetCapabilities(Settings, Definition); var pageableRequests = new IndexerPageableRequestChain(); var parameters = new NameValueCollection(); if (searchCriteria.Author.IsNotNullOrWhiteSpace() && capabilities.BookSearchAuthorAvailable) { parameters.Add("author", searchCriteria.Author); } if (searchCriteria.Title.IsNotNullOrWhiteSpace() && capabilities.BookSearchTitleAvailable) { parameters.Add("title", searchCriteria.Title); } //Workaround issue with Sphinx search returning garbage results on some indexers. If we don't use id parameters, fallback to t=search if (parameters.Count == 0) { searchCriteria.SearchType = "search"; if (searchCriteria.SearchTerm.IsNotNullOrWhiteSpace() && capabilities.SearchAvailable) { parameters.Add("q", NewsnabifyTitle(searchCriteria.SearchTerm)); } } else { if (searchCriteria.SearchTerm.IsNotNullOrWhiteSpace() && capabilities.BookSearchAvailable) { parameters.Add("q", NewsnabifyTitle(searchCriteria.SearchTerm)); } } pageableRequests.Add(GetPagedRequests(searchCriteria, parameters)); return(pageableRequests); }
public void should_not_fail_if_search_criteria_contains_multiple_albums_with_the_same_name() { var artist = Builder <Author> .CreateNew().Build(); var albums = Builder <Book> .CreateListOfSize(2).All().With(x => x.Title = "IdenticalTitle").Build().ToList(); var criteria = new BookSearchCriteria { Author = artist, Books = albums }; var parsed = new ParsedBookInfo { BookTitle = "IdenticalTitle" }; Subject.GetAlbums(parsed, artist, criteria).Should().BeEquivalentTo(new List <Book>()); Mocker.GetMock <IBookService>() .Verify(s => s.FindByTitle(artist.AuthorMetadataId, "IdenticalTitle"), Times.Once()); }
public void Search() { if (CanSave()) { var result = MessageBoxService.Show("You have unsaved data. Do you want to save?", "Information", MessageBoxButton.YesNoCancel, MessageBoxImage.Exclamation); if (result == MessageBoxResult.Cancel) { return; } if (result == MessageBoxResult.Yes) { Save(); } } context = new Entities(); var loanQuery = context.Loans.AsQueryable(); if (PatronSearchCriteria != null && PatronSearchCriteria.Any()) { loanQuery = loanQuery.WherePropertyIn(x => x.PatronId, PatronSearchCriteria); } if (BookSearchCriteria != null && BookSearchCriteria.Any()) { loanQuery = loanQuery.WherePropertyIn(x => x.BookId, BookSearchCriteria); } if (IsExpired) { loanQuery = loanQuery.Where(x => x.DueDate <= DateTime.Today); } Loans = new ObservableCollection <Loan>(loanQuery); }
public void SetUp() { Subject.Settings = new NewznabSettings() { BaseUrl = "http://127.0.0.1:1234/", Categories = new[] { 1, 2 }, ApiKey = "abcd", }; _singleAlbumSearchCriteria = new BookSearchCriteria { Author = new Books.Author { Name = "Alien Ant Farm" }, BookTitle = "TruANT" }; _capabilities = new NewznabCapabilities(); Mocker.GetMock <INewznabCapabilitiesProvider>() .Setup(v => v.GetCapabilities(It.IsAny <NewznabSettings>())) .Returns(_capabilities); }
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { var pageableRequests = new IndexerPageableRequestChain(); return(pageableRequests); }
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { return(new IndexerPageableRequestChain()); }
public abstract IList <ReleaseInfo> Fetch(BookSearchCriteria searchCriteria);
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { return(GetSearchRequestsCommon(searchCriteria, string.Format("{0}", searchCriteria.SanitizedSearchTerm))); }
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) => PerformRequest(searchCriteria);
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { var request = GetRequest(searchCriteria.SanitizedSearchTerm, searchCriteria.Categories); return(GetRequestChain(request, 2)); }
public virtual IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) { throw new System.NotImplementedException(); }
public HttpResponseMessage Get([FromUri] BookSearchCriteria searchCriteria) { var students = this.studentSearchQuery.ExecuteQueryWith(searchCriteria); return(Request.CreateResponse(HttpStatusCode.OK, students)); }
public IndexerPageableRequestChain GetSearchRequests(BookSearchCriteria searchCriteria) => GetRequestWithSearchType(searchCriteria, "anime");
public abstract Task<IndexerPageableQueryResult> Fetch(BookSearchCriteria searchCriteria);