public BooksObj GetBookById(string Id)
{
Books dbBook = BooksSqlDBService.GetBookById(_booksContext, int.Parse(Id));
if (dbBook == null)
{
return(null);
}
return(GetBooksObj(dbBook));
}
public IEnumerable <BooksObj> GetAllBooks()
{
List <BooksObj> books = new List <BooksObj>();
IEnumerable <Books> dbBook = BooksSqlDBService.GetAllBooks(_booksContext);
foreach (Books b in dbBook)
{
books.Add(GetBooksObj(b));
}
return(books);
}
public IEnumerable <BooksObj> GetStoredProcedureExample(BooksObj book)
{
List <BooksObj> books = new List <BooksObj>();
Books dbBook = GetSqlBooks(book);
IEnumerable <Books> dbBooks = BooksSqlDBService.GetStoredProcedureExample(_booksContext, dbBook);
foreach (Books b in dbBooks)
{
books.Add(GetBooksObj(b));
}
return(books);
}
public async Task <BooksObj> DeleteBook(string id)
{
Books dbBook = await BooksSqlDBService.DeleteBook(_booksContext, int.Parse(id));
return(GetBooksObj(dbBook));
}
public BooksObj UpdateBook(string id, BooksObj book)
{
Books dbBook = GetSqlBooks(book);
return(GetBooksObj(BooksSqlDBService.UpdateBook(_booksContext, int.Parse(id), dbBook)));
}
public BooksObj AddBook(BooksObj newBook)
{
Books dbBook = GetSqlBooks(newBook);
return(GetBooksObj(BooksSqlDBService.AddBook(_booksContext, dbBook)));
}
