public BookListModel QueryBooks(RequestBookModel searchMessage) { var cs = "Server=localhost\\SQLEXPRESS;Database=LibraryDB;Trusted_Connection=True;"; using var con = new SqlConnection(cs); //Using Class SqlConnection for COnnent to database con.Open(); string sql = string.Format(@"SELECT Id, Name, Auther, Category, BookmarkBtn, DetailBtn FROM BookTable WHERE(Name LIKE '%{0}%' OR Auther LIKE '%{0}%' OR Category LIKE '%{0}%')", searchMessage.text); using var cmd = new SqlCommand(sql, con); using SqlDataReader rdr = cmd.ExecuteReader(); BookListModel output = new BookListModel(); output.books = new List <BookModel>(); while (rdr.Read()) { output.books.Add( new BookModel() { bookId = rdr.GetInt32(0), name = rdr.GetString(1), author = rdr.GetString(2), category = rdr.GetString(3), bookmark = rdr.GetBoolean(4), detail = rdr.GetBoolean(5), } ); } return(output); }
public IActionResult Post([FromBody] RequestBookModel requestBookModel) { var book = bookService.Create(new Book(new Guid(), requestBookModel.Name, requestBookModel.Description, requestBookModel.Isbn, requestBookModel.AvailableQuantity)); return(Created($"/books/{book.Id}", book)); }
public async Task <ActionResult <object> > UpdateBook(RequestBookModel book) { var user = await GetCurrentAuthor(); _logger.LogTrace($"{user.UserName} try to update book {book.Id}..."); Book bookToUpdate = _service.GetBook(book.Id); Mapper.Map(book, bookToUpdate); _service.Update(bookToUpdate); _logger.LogTrace($"{user.UserName} successfully update book {book.Id}"); return(bookToUpdate); }
public async Task <IActionResult> AddBook(RequestBookModel book) { var user = await GetCurrentAuthor(); _logger.LogTrace($"AddBook method called by {user.UserName}."); Book newBook = Mapper.Map <RequestBookModel, Book>(book); newBook.AuthorId = user.Id.ToString(); newBook.DateOfRelease = DateTime.Now; _service.Create(newBook); _logger.LogTrace($"{user.UserName} successfully create a book!"); return(Ok(newBook)); }
public async Task <Book> UpdateBook(RequestBookModel book) { if (book != null) { var user = await GetActualUser(); _logger.LogTrace($"{user.Email} trying to update {book.BookId}"); Book actualBook = _bookService.GetBook(book.BookId); Mapper.Map(book, actualBook); _bookService.Update(actualBook); _logger.LogTrace($"{user.Email} successfully updated {book.BookId}"); return(actualBook); } return(null); }
public async Task <IActionResult> AddBook(RequestBookModel book) { if (book.Content != null) { var user = await GetActualUser(); _logger.LogTrace($"{user.Email} trying to Add new book"); Book newBook = Mapper.Map <RequestBookModel, Book>(book); newBook.AuthorId = user.Id.ToString(); newBook.ReleaseDate = DateTime.Now; _bookService.Create(newBook); _logger.LogTrace($"{newBook.Title} was created by {user.Email}"); return(Ok(newBook)); } return(BadRequest("Error")); }
public BookListModel SelectBooks(RequestBookModel searchMessage) { BookListModel result = _bookRepository.QueryBooks(searchMessage); return(result); }
public BookListModel GetBookList(RequestBookModel searchMessage) { BookListModel result = _bookService.SelectBooks(searchMessage); return(result); }