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