/// <summary> /// 修改書籍資訊 /// </summary> /// <param name="book"></param> /// <returns></returns> public int UpdateBooks(BOOK_DATA book) { try { //預設借閱狀態可借閱、借閱人為空、建立日期及修改日期為目前日期 book.MODIFY_DATE = DateTime.Now; book.BOOK_KEEPER = book.BOOK_KEEPER ?? string.Empty; db.Entry(book).State = EntityState.Modified; return(db.SaveChanges()); } catch (Exception) { return(0); } }
/// <summary> /// 新增書籍資訊 /// </summary> /// <param name="book"></param> /// <returns></returns> public int InsertBooks(BOOK_DATA book) { try { //預設借閱狀態可借閱、借閱人為空、建立日期及修改日期為目前日期 book.BOOK_STATUS = "A"; book.BOOK_KEEPER = ""; book.CREATE_DATE = DateTime.Now; book.MODIFY_DATE = DateTime.Now; db.BOOK_DATA.Add(book); return(db.SaveChanges()); } catch (Exception ex) { return(0); } }