/// <summary>
/// 新增書籍
/// </summary>
/// <param name="book"></param>
/// <returns>員工編號</returns>
public int InsertBook(Models.AddBook book)
{
string sql = @" INSERT INTO BOOK_DATA
(
BookName,BookAuthor,BookPublisher,BookNote,BookBoughtDate,BookClassName
)
VALUES
(
@BookName,@BookAuthor,@BookPublisher,@BookNote,@BookBoughtDate,@BookClassName
)
Select SCOPE_IDENTITY()" ;
int EmployeeId;
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@BookName", book.BookName == null ? (Object)DBNull.Value : book.BookName));
cmd.Parameters.Add(new SqlParameter("@BookAuthor", book.BookAuthor == null ? (Object)DBNull.Value : book.BookAuthor));
cmd.Parameters.Add(new SqlParameter("@BookPublisher", book.BookPublisher == null ? (Object)DBNull.Value : book.BookPublisher));
cmd.Parameters.Add(new SqlParameter("@BookNote", book.BookNote == null ? (Object)DBNull.Value : book.BookNote));
cmd.Parameters.Add(new SqlParameter("@BookBoughtDate", book.BookBoughtDate == null ? (Object)DBNull.Value : book.BookBoughtDate));
cmd.Parameters.Add(new SqlParameter("@BookClassName", book.BookClassName == null ? (Object)DBNull.Value : book.BookClassName));
EmployeeId = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
}
return(EmployeeId);
}
public ActionResult InsertBook(Models.AddBook book)
{
Models.BookService bookService = new Models.BookService();
ViewBag.AddBookItem = bookService.InsertBook(book);
return(View());
}
