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);
