public eLibrary.Model.BookUpdateData GetBookDataById(string id) { eLibrary.Model.BookUpdateData BookData; DataTable dt = new DataTable(); string sql = @"SELECT BD.BOOK_NAME As BookName , BD.BOOK_AUTHOR As BookAuthor, BD.BOOK_PUBLISHER As BookPublisher , BD.BOOK_NOTE As BookNote, CONVERT( varchar(12), BD.BOOK_BOUGHT_DATE, 111) AS BookBoughtDate, BD.BOOK_CLASS_ID As BookClassId, BD.BOOK_STATUS As BookStatus, BD.BOOK_KEEPER As BookKeeper, BD.BOOK_ID As BookId FROM dbo.BOOK_DATA as BD Where (BD.BOOK_ID = @BookId)" ; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add(new SqlParameter("@BookId", id)); SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd); sqlAdapter.Fill(dt); conn.Close(); if (dt.Rows.Count == 0) { return(null); } BookData = new BookUpdateData() { BookId = (int)dt.Rows[0]["BookId"], BookName = dt.Rows[0]["BookName"].ToString(), BookAuthor = dt.Rows[0]["BookAuthor"].ToString(), BookPublisher = dt.Rows[0]["BookPublisher"].ToString(), BookNote = dt.Rows[0]["BookNote"].ToString(), BookBoughtDate = dt.Rows[0]["BookBoughtDate"].ToString(), BookClassId = dt.Rows[0]["BookClassId"].ToString(), BookCodeId = dt.Rows[0]["BookStatus"].ToString(), BookKeeper = dt.Rows[0]["BookKeeper"].ToString() }; } return(BookData); }
public void UpdateBook(BookUpdateData bookData) { GetBook(bookData.bookId)?.UpdateBookData(bookData); }
public bool UpdateBookData(BookUpdateData book) { throw new NotImplementedException(); }
public void UpdateBook(BookUpdateData data) { libUOW.GetBooksDao.UpdateBook(data); }