public bool InsertBookAuthor(BookAuthor bookAuthor)
{
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@BookID", bookAuthor.BookID),
new SqlParameter("@AuthorID", bookAuthor.AuthorID )
};
return DataProvider.ExecuteNonQuery("sp_InsertBook_Author", CommandType.StoredProcedure,
Params);
}
public List<BookAuthor> GetBookAuthors(int BookID)
{
List<BookAuthor> bookAuthors = null;
SqlParameter[] Params = { new SqlParameter("@BookID", BookID) };
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_ViewBookAuthors",
CommandType.StoredProcedure, Params))
{
if (table.Rows.Count > 0)
{
bookAuthors = new List<BookAuthor>();
foreach (DataRow row in table.Rows)
{
BookAuthor bookAuthor = new BookAuthor();
bookAuthor.BookID = Convert.ToInt32(row["BookID"]);
bookAuthor.AuthorID = Convert.ToInt32(row["AuthorID"]);
bookAuthors.Add(bookAuthor);
}
}
}
return bookAuthors;
}
public bool DeleteBookAuthor(BookAuthor bookAuthor)
{
BookAuthorHandler myHandler = new BookAuthorHandler(); return myHandler.DeleteBookAuthor(bookAuthor);
}
public bool InsertBookAuthor(BookAuthor bookAuthor)
{
BookAuthorHandler myHandler = new BookAuthorHandler(); return myHandler.InsertBookAuthor(bookAuthor);
}
public BookAuthor TrailInsertBook(Book book)
{
BookAuthor bookAuthor = new BookAuthor();
SqlParameter[] Params = new SqlParameter[]
{
new SqlParameter("@ProductID", book.ProductID),
new SqlParameter("@BookTitle", book.BookTitle),
new SqlParameter("@Synopsis", book.Synopsis),
new SqlParameter("@ISBN", book.ISBN),
new SqlParameter("@BookCategoryID", book.BookCategoryID),
new SqlParameter("@PublisherID", book.PublisherID),
new SqlParameter("@SupplierID", book.SupplierID),
new SqlParameter("@CoverImage", book.CoverImage)
};
using (DataTable table = DataProvider.ExecuteParamatizedSelectCommand("sp_Insert_Book", CommandType.StoredProcedure, Params))
{
if (table.Rows.Count == 1)
{
DataRow row = table.Rows[0];
bookAuthor.BookID = Convert.ToInt32(row["BookID"]);
}
}
return bookAuthor;
}
