public ActionResult GetByYearPublished(int?year)
{
Library2Entities db = new Library2Entities();
List <book> list = db.books.Where(
b => b.YearPublished == year
).ToList();
return(Json(list));
}
public ActionResult GetByPublisher(string publisher)
{
Library2Entities db = new Library2Entities();
List <book> list = db.books.Where(
b => b.Publisher.Contains(publisher)
).ToList();
return(Json(list));
}
public ActionResult GetBookByPublisher(string publisher)
{
Library2Entities db = new Library2Entities();
List <book> ab = db.books.Where(
a => a.Publisher.Contains(publisher)
).ToList();
return(Json(ab));
}
public ActionResult GetByTitle(string title)
{
Library2Entities db = new Library2Entities();
List <book> list = db.books.Where(
b => b.Title.Contains(title)
).ToList();
return(Json(list));
}
public ActionResult GetBookByYear(int year)
{
Library2Entities db = new Library2Entities();
List <book> ab = db.books.Where(
a => a.YearPublished == year
).ToList();
return(Json(ab));
}
public ActionResult GetBookByTitle(string title)
{
Library2Entities db = new Library2Entities();
List <book> ab = db.books.Where(
a => a.Title.Contains(title)
).ToList();
return(Json(ab));
}
public ActionResult GetBooksByAuthor(string author)
{
Library2Entities db = new Library2Entities();
List <book> list = db.books
.Where(c => c.Author.Contains(author)).ToList();
return(Json(list));
}
public ActionResult GetBooksByGenre(string genre)
{
Library2Entities db = new Library2Entities();
List <book> list = db.books.Where(
c => c.Genre.Contains(genre)
).ToList();
return(Json(list));
}
public ActionResult GetBooksByAll(string userinput)
{
Library2Entities db = new Library2Entities();
int.TryParse(userinput, out int userint);
List <book> list = db.books
.Where(c => c.Title.Contains(userinput) ||
c.Author.Contains(userinput) ||
c.YearPublished == userint ||
c.Publisher.Contains(userinput) ||
c.Genre.Contains(userinput)
).ToList();
return(Json(list));
}
