public void TestGetBook()
{
//Act
Book_Maintain_Ajax.Model.BookUpdate bookUpdate = bookDao.GetUpdateBook(InsertId);
System.Diagnostics.Debug.WriteLine("TestGetBook:" + InsertId);
//Assert
Assert.AreEqual(bookInsert.BookName, bookUpdate.BookName);
Assert.AreEqual(bookInsert.BookAuthor, bookUpdate.BookAuthor);
Assert.AreEqual(bookInsert.BookPublisher, bookUpdate.BookPublisher);
Assert.AreEqual(bookInsert.Note, bookUpdate.Note);
Assert.AreEqual(bookInsert.BoughtDate.ToString("yyyy/MM/dd"), bookUpdate.BoughtDate);
Assert.AreEqual(bookInsert.BookClass, bookUpdate.BookClassId);
System.Diagnostics.Debug.WriteLine("************TestGetBook SUCCESS*************");
}
public void UpdateBook(Book_Maintain_Ajax.Model.BookUpdate updatedata)
{
string sql = @"
BEGIN TRY
BEGIN TRANSACTION
UPDATE BOOK_DATA
SET BOOK_NAME= @BOOK_NAME,
BOOK_AUTHOR = @BOOK_AUTHOR,
BOOK_PUBLISHER = @BOOK_PUBLISHER,
BOOK_NOTE = @BOOK_NOTE,
BOOK_BOUGHT_DATE = @BOOK_BOUGHT_DATE,
BOOK_CLASS_ID = @BOOK_CLASS_ID,
BOOK_STATUS = @BOOK_STATUS_ID,
BOOK_KEEPER = @BOOK_KEEPER_ID,
MODIFY_DATE = GETDATE()
WHERE BOOK_ID = @BOOK_ID
COMMIT TRANSACTION
End TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() as ErrorState,
ERROR_PROCEDURE() as ErrorProcedure,
ERROR_LINE() as ErrorLine,
ERROR_MESSAGE() as ErrorMessage
ROLLBACK TRANSACTION
END CATCH " ;
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Execute(sql, new
{
BOOK_NAME = updatedata.BookName,
BOOK_AUTHOR = updatedata.BookAuthor,
BOOK_PUBLISHER = updatedata.BookPublisher,
BOOK_NOTE = updatedata.Note,
BOOK_BOUGHT_DATE = updatedata.BoughtDate,
BOOK_CLASS_ID = updatedata.BookClassId,
BOOK_STATUS_ID = updatedata.BookStatusId,
BOOK_KEEPER_ID = updatedata.BookKeeperId == null ? string.Empty : updatedata.BookKeeperId,
BOOK_ID = updatedata.BookID
});
}
}
public void TestUpdateBook()
{
//Act
bookDao.UpdateBook(InsertId, bookUpdate);
Book_Maintain_Ajax.Model.BookUpdate bookUpdateBack = bookDao.GetUpdateBook(InsertId);
System.Diagnostics.Debug.WriteLine("TestUpdateBook:" + InsertId);
//Assert
Assert.AreEqual(bookUpdate.BookName, bookUpdateBack.BookName);
Assert.AreEqual(bookUpdate.BookAuthor, bookUpdateBack.BookAuthor);
Assert.AreEqual(bookUpdate.BookPublisher, bookUpdateBack.BookPublisher);
Assert.AreEqual(bookUpdate.Note, bookUpdateBack.Note);
Assert.AreEqual(bookUpdate.BoughtDate, bookUpdateBack.BoughtDate);
Assert.AreEqual(bookUpdate.BookClassId, bookUpdateBack.BookClassId);
Assert.AreEqual(bookUpdate.BookStatusId, bookUpdateBack.BookStatusId);
Assert.AreEqual(bookUpdate.BookKeeperId, bookUpdateBack.BookKeeperId);
System.Diagnostics.Debug.WriteLine("************TestUpdateBook SUCCESS*************");
}
public void TestLendDeleteBook()
{
//Act
System.Diagnostics.Debug.WriteLine("TestDelete:" + InsertId);
string IfDelete = bookDao.DecideDelete(Convert.ToString(InsertId));
Book_Maintain_Ajax.Model.BookUpdate bookUpdate = bookDao.GetUpdateBook(InsertId);
//Assert
Assert.AreEqual("已借出不可刪除", IfDelete);
Assert.AreNotEqual(null, bookUpdate.BookName);
Assert.AreNotEqual(null, bookUpdate.BookAuthor);
Assert.AreNotEqual(null, bookUpdate.BookPublisher);
Assert.AreNotEqual(null, bookUpdate.Note);
Assert.AreNotEqual(null, bookUpdate.BoughtDate);
Assert.AreNotEqual(null, bookUpdate.BookClassId);
System.Diagnostics.Debug.WriteLine("************TestLendDeleteBook SUCCESS*************");
}
public void UpdateBook(Book_Maintain_Ajax.Model.BookUpdate updatedata)
{
bookDao.UpdateBook(updatedata);
}
