public DataTable aplyBOOK(BOOK searchbook)
{
string sql = "select * from SACH where TenSach ='" + searchbook.TENSACH + "' and TheLoai='" + searchbook.THELOAI + "'and MaSach='" + searchbook.MASACH + "'";
return(da.GetTable(sql));
}
public void AddBook(BOOK addbook)
{
string sql = "Insert into SACH values( '" + addbook.TEBNXB + "','" + addbook.TENSACH + "','" + addbook.TACGIA + "','" + addbook.THELOAI + "','" + addbook.DONGIA + "','" + addbook.SOLUONG + "')";
da.ExNonQuery(sql);
}
// update soluong sach
public void updateSOLUONGSACH(BOOK book)
{
string sql = " update SACH set SoLuong ='" + book.SOLUONG + "' where MaSach='" + book.MASACH + "'";
da.ExNonQuery(sql);
}
//update sach
public void updateBOOK(BOOK book)
{
string sql = "UPDATE SACH set TenNXB = '" + book.TEBNXB + "', TenSach = '" + book.TENSACH + "', TacGia = '" + book.TACGIA + "', TheLoai = '" + book.THELOAI + "',DonGia = '" + book.DONGIA + "' where MaSach = '" + book.MASACH + "'";
da.ExNonQuery(sql);
}
