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); }