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