public void UpdateBooksLeft(int book_id, byte books_left)
{
DAL.DataSet1.booksDataTable books = Adapter.GetData();
for (int i = 0; i < books.Rows.Count; i++)
{
if (Convert.ToInt32(books.Rows[i]["book_id"]) == book_id)
{
books.Rows[i]["BooksLeft"] = books_left;
Adapter.Update(books.Rows[i]);
}
}
}
public byte GetBooksLeft(int book_id)
{
byte books_left = 0;
DAL.DataSet1.booksDataTable books = Adapter.GetData();
for (int i = 0; i < books.Rows.Count; i++)
{
if (Convert.ToInt32(books.Rows[i]["book_id"]) == book_id)
{
books_left = Convert.ToByte(books.Rows[i]["BooksLeft"]);
return(books_left);
}
}
return(books_left);
}
