public IEnumerable<Book> searchBookByTitleOrEditorInDataBase(string wordSearch, string categorie) { categorie = categorie.Replace('_', ' '); List<Book> listBook = new List<Book>(); List<Book> listBookNoDupli = new List<Book>(); var queryResultTitle = (from b in db.books where b.CodeCategorie == categorie && b.Title.Contains(wordSearch) select b).ToList(); var queryResultEditor = (from b in db.books where b.CodeCategorie == categorie && b.Editor.Contains(wordSearch) select b).ToList(); var queryResultAuthor = (from a in db.authors where a.NameAuthor.Contains(wordSearch) select a.books.ToList()).ToList(); foreach (var bT in queryResultTitle) { Book book = new Book(); fillBook(book, bT); listBook.Add(book); } foreach (var bE in queryResultEditor) { Book book = new Book(); fillBook(book, bE); listBook.Add(book); } foreach (var bA in queryResultAuthor) { foreach (var b in bA.Where(bc => bc.CodeCategorie == categorie)) { Book book = new Book(); fillBook(book, b); listBook.Add(book); } } listBookNoDupli = listBook.Distinct().ToList(); return listBookNoDupli; }
public IEnumerable<Book> getBooks30LastDays() { var dateOf30Days = DateTime.Now.Date.AddDays(-30); var queryResult = (from b in db.books where b.DateEntry > dateOf30Days select b).ToList(); List<Book> listBook = new List<Book>(); foreach (var b in queryResult) { Book book = new Book(); fillBook(book, b); listBook.Add(book); } return listBook; }
// GET: api/authors public IEnumerable<Author> Getauthors() { var queryResult = db.authors.ToList(); List<Author> listAuthor = new List<Author>(); foreach (var a in queryResult) { Author author = new Author(); author.NameAuthor = a.NameAuthor; author.NumAuthor = a.NumAuthor; List<Book> listBook = new List<Book>(); foreach (var b in a.books) { Book book = new Book(); book.NumBook = b.NumBook; book.Title = b.Title; book.Editor = b.Editor; book.YearPublication = b.YearPublication; book.DateEntry = b.DateEntry; book.Rangement = b.Rangement; book.Statut = b.Statut; var queryResultCategorie = (from c in db.categories where c.CodeCategorie == b.CodeCategorie select c).First(); Categorie categorie = new Categorie(); categorie.CodeCategorie = queryResultCategorie.CodeCategorie; categorie.LibelleCategorie = queryResultCategorie.LibelleCategorie; book.Categorie = categorie; book.NumberReservation = b.reservations.Count(); listBook.Add(book); } author.Book = listBook; listAuthor.Add(author); } return listAuthor; }
private void fillBook(Book book, book b) { book.NumBook = b.NumBook; book.Title = b.Title; book.Editor = b.Editor; book.YearPublication = b.YearPublication; book.DateEntry = b.DateEntry; book.Rangement = b.Rangement; book.Statut = b.Statut; var queryResultCategorie = (from c in db.categories where c.CodeCategorie == b.CodeCategorie select c).First(); Categorie categorie = new Categorie(); categorie.CodeCategorie = queryResultCategorie.CodeCategorie; categorie.LibelleCategorie = queryResultCategorie.LibelleCategorie; book.Categorie = categorie; List<Author> listAuthor = new List<Author>(); foreach (var a in b.authors) { Author author = new Author(); author.NumAuthor = a.NumAuthor; author.NameAuthor = a.NameAuthor; listAuthor.Add(author); } book.Author = listAuthor; book.NumberReservation = b.reservations.Count(); }