//Update
public int UpdateBookByISBN(string ISBN, BookUpdate newBook)
{
using (var ctx = new ApplicationDbContext())
{
Book book = ctx.Books.Find(ISBN);
if (book == null)
{
return(2);
}
//Using null-coalescing operator ?? to check if information entered to update
book.BookTitle = newBook.BookTitle ?? book.BookTitle;
book.AuthorFirstName = newBook.AuthorFirstName ?? book.AuthorFirstName;
book.AuthorLastName = newBook.AuthorLastName ?? book.AuthorLastName;
book.GenreOfBook = newBook.GenreOfBook ?? book.GenreOfBook;
book.Description = newBook.Description ?? book.Description;
if (ctx.SaveChanges() == 1)
{
return(0);
}
return(1);
}
}
// Put --Update a book detail via ISBN
//[HttpPut]
/// <summary>
/// Update Existing Book In Database
/// </summary>
/// <param name="ISBN"></param>
/// <param name="newBook"></param>
/// <returns></returns>
public IHttpActionResult Put([FromUri] string ISBN, [FromBody] BookUpdate newBook)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var service = CreateBookService();
switch (service.UpdateBookByISBN(ISBN, newBook))
{
case 0:
return(Ok($"{newBook.BookTitle} has been updated"));
case 1:
return(InternalServerError());
case 2:
return(BadRequest("Book not found"));
default:
return(InternalServerError());
}
}
private void EnableUpdate()
{
BookUpdate parent = Util.TryFindParent <BookUpdate>(this);
if (string.IsNullOrEmpty(txtTitle.Text) == false)
{
parent.cmdUpdate.IsEnabled = true;
parent.cmdUpdateWeb.IsEnabled = true;
}
else if (string.IsNullOrEmpty(txtBarcode.Text) == false)
{
parent.cmdUpdateWeb.IsEnabled = true;
if (string.IsNullOrEmpty(txtTitle.Text) == true)
{
parent.cmdUpdate.IsEnabled = false;
}
}
else
{
parent.cmdUpdate.IsEnabled = false;
parent.cmdUpdateWeb.IsEnabled = false;
}
}
public int Update(BookUpdate book)
{
int rowAffected = 0;
using (IDbConnection con = new SqlConnection(strConnectionString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Id", book.ID);
parameters.Add("@Avatar", book.Avatar);
parameters.Add("@Name", book.Name);
parameters.Add("@Author", book.Author);
parameters.Add("@Description", book.Description);
parameters.Add("@Year", book.Year);
parameters.Add("@Number", book.Number);
parameters.Add("@CateloryID", book.CateloryID);
rowAffected = con.Execute("Book_Update", parameters, commandType: CommandType.StoredProcedure);
}
return(rowAffected);
}
public IList <BookUpdate> GetBookUpdateByChapterID(int chapterID, int bookID)
{
IList <BookUpdate> objList = new List <BookUpdate>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_BOOK_UPDATE_Q";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_chapter_id", DbType.Int32, chapterID);
db.AddInParameter(dbCommand, "p_book_id", DbType.Int32, bookID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
BookUpdate obj = CreateModelObject(dataReader);
objList.Add(obj);
}
}
return(objList);
}
public async Task <IActionResult> UpdateBook([FromBody] BookUpdate bookUpdate, [FromQuery] string IniBookStatus, [FromQuery] string LaterBookStatus)
{
//借閱人借閱狀態關係
if ((bookUpdate.BookStatusId == "B" || bookUpdate.BookStatusId == "C") && (bookUpdate.BookKeeperId == "" || bookUpdate.BookKeeperId == null))
{
return(Ok("此借閱狀態,借閱人不能為空"));
}
else
{
//insert 借閱紀錄
if ((IniBookStatus == "A" || IniBookStatus == "U") && (LaterBookStatus == "B" || LaterBookStatus == "C"))
{
LendRecordInsert lendRecordInsert = new LendRecordInsert();
lendRecordInsert.BookKeeperId = bookUpdate.BookKeeperId;
lendRecordInsert.BookID = Convert.ToInt32(bookUpdate.BookID);
await _bookservice.InsertLendRecord(lendRecordInsert);
}
//update 書本資料
await _bookservice.UpdateBook(bookUpdate);
return(Ok("編輯成功"));
}
}
public void AddBookUpdate(BookUpdate BookChapter)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_BOOK_UPDATE_I";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddOutParameter(dbCommand, "p_book_update_id", DbType.Int32, 4);
db.AddInParameter(dbCommand, "p_book_id", DbType.Int32, BookChapter.BookId);
db.AddInParameter(dbCommand, "p_chapter_id", DbType.Int32, BookChapter.ChapterId);
db.AddInParameter(dbCommand, "p_update_person", DbType.String, BookChapter.updatePerson);
db.AddInParameter(dbCommand, "p_update_date", DbType.DateTime, BookChapter.updateDate);
db.AddInParameter(dbCommand, "p_update_cause", DbType.String, BookChapter.updateCause);
db.AddInParameter(dbCommand, "p_update_content", DbType.String, BookChapter.updateContent);
db.AddInParameter(dbCommand, "p_update_object", DbType.String, BookChapter.UpdateObject);
db.AddInParameter(dbCommand, "p_memo", DbType.String, BookChapter.Memo);
db.AddInParameter(dbCommand, "p_book_name", DbType.String, BookChapter.BookNameBak);
db.AddInParameter(dbCommand, "p_chapter_name", DbType.String, BookChapter.ChapterNameBak);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
db.ExecuteNonQuery(dbCommand, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
}
connection.Close();
}
private bool IsValid(BookUpdate book)
{
return(!string.IsNullOrEmpty(book.ImageUrl) && !book.Title.EndsWith("Variant)"));
}
private void UpdateItem(ThumbItem thumbItem)
{
try
{
if (thumbItem == null)
{
return;
}
bool?saved = false;
switch (thumbItem.EType)
{
case EntityType.Apps:
AppsUpdate objAppsDetails = new AppsUpdate();
objAppsDetails.ItemsId = thumbItem.Id;
saved = objAppsDetails.ShowDialog();
if (saved == true)
{
Apps apps = new AppServices().Get(thumbItem.Id) as Apps;
FileThumbItem(thumbItem, apps);
}
break;
case EntityType.Artist:
Task.Factory.StartNew(() => Util.NotifyEvent("ArtistDetail:" + thumbItem.Name));
ArtistDetail artistDetails = new ArtistDetail(thumbItem.Name, thumbItem.EType);
saved = artistDetails.ShowDialog();
break;
case EntityType.Books:
BookUpdate objBookDetails = new BookUpdate();
objBookDetails.ItemsId = thumbItem.Id;
saved = objBookDetails.ShowDialog();
if (saved == true)
{
Books books = new BookServices().Get(thumbItem.Id) as Books;
FileThumbItem(thumbItem, books);
}
break;
case EntityType.Games:
GameUpdate objGameDetails = new GameUpdate();
objGameDetails.ItemsId = thumbItem.Id;
saved = objGameDetails.ShowDialog();
if (saved == true)
{
Gamez games = new GameServices().Get(thumbItem.Id) as Gamez;
FileThumbItem(thumbItem, games);
}
break;
case EntityType.Movie:
MovieUpdate objMovieDetails = new MovieUpdate();
objMovieDetails.ItemsId = thumbItem.Id;
saved = objMovieDetails.ShowDialog();
if (saved == true)
{
Movie movie = new MovieServices().Get(thumbItem.Id) as Movie;
FileThumbItem(thumbItem, movie);
}
break;
case EntityType.Music:
MusicUpdate objMusicDetails = new MusicUpdate();
objMusicDetails.ItemsId = thumbItem.Id;
saved = objMusicDetails.ShowDialog();
if (saved == true)
{
Music music = new MusicServices().Get(thumbItem.Id) as Music;
FileThumbItem(thumbItem, music);
}
break;
case EntityType.Nds:
NdsUpdate objNdsDetails = new NdsUpdate();
objNdsDetails.ItemsId = thumbItem.Id;
saved = objNdsDetails.ShowDialog();
if (saved == true)
{
Nds nds = new NdsServices().Get(thumbItem.Id) as Nds;
FileThumbItem(thumbItem, nds);
}
break;
case EntityType.Series:
Main main = Util.TryFindParent <Main>(this);
main.NewSeasonAdded = false;
SerieUpdate objSerieDetails = new SerieUpdate();
objSerieDetails.ItemsId = thumbItem.Id;
saved = objSerieDetails.ShowDialog();
main.NewSeasonAdded = objSerieDetails.NewSeasonAdded;
if (objSerieDetails.NewSeasonAdded == true)
{
saved = true;
}
if (saved == true)
{
SeriesSeason serie = new SerieServices().Get(thumbItem.Id) as SeriesSeason;
FileThumbItem(thumbItem, serie);
}
break;
case EntityType.XXX:
XxxUpdate objXxxDetails = new XxxUpdate();
objXxxDetails.ItemsId = thumbItem.Id;
saved = objXxxDetails.ShowDialog();
if (saved == true)
{
XXX xxx = new XxxServices().Get(thumbItem.Id) as XXX;
FileThumbItem(thumbItem, xxx);
}
break;
}
_currentItem = thumbItem;
if (saved == true)
{
RoutedEventArgs args = new RoutedEventArgs(UpdateEvent);
RaiseEvent(args);
Cursor = null;
ShowVisibleItems(MainStack);
}
}
catch (Exception ex)
{
CatchException(ex);
}
}
private void UpdateItem(ThumbItem thumbItem)
{
try
{
bool?saved = false;
switch (thumbItem.EType)
{
case EntityType.Apps:
AppsUpdate objAppsDetails = new AppsUpdate();
objAppsDetails.ItemsId = thumbItem.Id;
saved = objAppsDetails.ShowDialog();
break;
case EntityType.Books:
BookUpdate objBookDetails = new BookUpdate();
objBookDetails.ItemsId = thumbItem.Id;
saved = objBookDetails.ShowDialog();
break;
case EntityType.Games:
GameUpdate objGameDetails = new GameUpdate();
objGameDetails.ItemsId = thumbItem.Id;
saved = objGameDetails.ShowDialog();
break;
case EntityType.Movie:
MovieUpdate objMovieDetails = new MovieUpdate();
objMovieDetails.ItemsId = thumbItem.Id;
saved = objMovieDetails.ShowDialog();
break;
case EntityType.Music:
MusicUpdate objMusicDetails = new MusicUpdate();
objMusicDetails.ItemsId = thumbItem.Id;
saved = objMusicDetails.ShowDialog();
break;
case EntityType.Nds:
NdsUpdate objNdsDetails = new NdsUpdate();
objNdsDetails.ItemsId = thumbItem.Id;
saved = objNdsDetails.ShowDialog();
break;
case EntityType.Series:
SerieUpdate objSerieDetails = new SerieUpdate();
objSerieDetails.ItemsId = thumbItem.Id;
saved = objSerieDetails.ShowDialog();
break;
case EntityType.XXX:
XxxUpdate objXxxDetails = new XxxUpdate();
objXxxDetails.ItemsId = thumbItem.Id;
saved = objXxxDetails.ShowDialog();
break;
}
if (saved == true)
{
RoutedEventArgs args = new RoutedEventArgs(SaveEventCf);
RaiseEvent(args);
}
}
catch (Exception ex)
{
CatchException(ex);
}
}
public void UpdateLine(MinibookMessage message)
{
BookUpdate book = (BookUpdate)message.BookHeader;
DeleteLineByIndex(book.OldPosition);
}
//public List<BookSearch> ToModelList(DataTable dt)
//{
// throw new NotImplementedException();
//}
public void UpdateBook(BookUpdate updatedata)
{
throw new NotImplementedException();
}
public void UpdateBookUpdate(BookUpdate BookUpdate)
{
dal.UpdateBookUpdate(BookUpdate);
}
public void AddBookUpdate(BookUpdate BookUpdate)
{
dal.AddBookUpdate(BookUpdate);
}
public void Update([FromBody] BookUpdate bookUpdate) => bookBusiness.Update(bookUpdate);
protected void SaveButton_Click(object sender, EventArgs e)
{
BookUpdateBLL BookUpdateBLL = new BookUpdateBLL();
BookUpdate BookUpdate = new BookUpdate();
string strUpdateObject = Request.QueryString.Get("Object");
if (txtCause.Text == string.Empty)
{
SessionSet.PageMessage = "更改原因不能为空！";
return;
}
if (txtContent.Text == string.Empty)
{
SessionSet.PageMessage = "更改内容不能为空！";
return;
}
if (ViewState["AddFlag"].ToString() == "1") //新增
{
BookBLL objBookBll = new BookBLL();
BookUpdate.BookId = int.Parse(ViewState["BookID"].ToString());
BookUpdate.ChapterId = int.Parse(ViewState["ChapterID"].ToString());
BookUpdate.updatePerson = lblPerson.Text;
BookUpdate.updateDate = DateTime.Parse(lblDate.Text);
BookUpdate.updateCause = txtCause.Text;
BookUpdate.updateContent = txtContent.Text;
BookUpdate.Memo = txtMemo.Text;
BookUpdate.BookNameBak = objBookBll.GetBook(Convert.ToInt32(ViewState["BookID"].ToString())).bookName;
if (ViewState["ChapterID"].ToString() != "0")
{
BookChapterBLL objChapterBll = new BookChapterBLL();
BookUpdate.ChapterNameBak =
objChapterBll.GetBookChapter(Convert.ToInt32(ViewState["ChapterID"].ToString())).ChapterName;
}
if (strUpdateObject == "insertchapterinfo")
{
BookUpdate.ChapterNameBak = Server.UrlDecode(Request.QueryString.Get("newchaptername"));
BookUpdate.UpdateObject = PrjPub.BOOKUPDATEOBJECT_INSERTCHAPTERINFO;
}
else if (strUpdateObject == "updatechapterinfo")
{
BookUpdate.UpdateObject = PrjPub.BOOKUPDATEOBJECT_UPDATECHAPTERINFO;
}
else if (strUpdateObject == "chaptercontent")
{
BookUpdate.UpdateObject = PrjPub.BOOKUPDATEOBJECT_CHAPTERCONTENT;
}
else if (strUpdateObject == "delbook")
{
BookUpdate.UpdateObject = PrjPub.BOOKUPDATEOBJECT_DELBOOK;
}
else if (strUpdateObject == "delchapter")
{
BookUpdate.UpdateObject = PrjPub.BOOKUPDATEOBJECT_DELCHAPTER;
}
else
{
BookUpdate.UpdateObject = lblChapterName.Text;
}
BookUpdateBLL.AddBookUpdate(BookUpdate);
Response.Write("<script>top.returnValue='true';window.close();</script>");
}
else //修改
{
BookUpdate.BookId = int.Parse(ViewState["BookID"].ToString());
BookUpdate.ChapterId = int.Parse(ViewState["ChapterID"].ToString());
BookUpdate.updatePerson = lblPerson.Text;
BookUpdate.updateDate = DateTime.Parse(lblDate.Text);
BookUpdate.updateCause = txtCause.Text;
BookUpdate.updateContent = txtContent.Text;
BookUpdate.Memo = txtMemo.Text;
BookUpdate.bookUpdateId = int.Parse(Request.QueryString.Get("id"));
BookUpdateBLL.UpdateBookUpdate(BookUpdate);
if (PrjPub.IsWuhan())
{
Response.Write("<script>window.opener.form1.RefreshGrid.value='true';window.opener.form1.submit();window.close();</script>");
}
else
{
Response.Write("<script>top.returnValue='true';window.close();</script>");
}
}
}
public ApiResponse Update(long id, BookUpdate bookUpdate)
{
this.bookApplication.UpdateFromAPI(id, bookUpdate);
return(new ApiResponseData(HttpStatusCode.OK, null));
}
