//Xoá
public void XoaDuLieu(E_Sach et)
{
sql.XoaDuLieu(et);
}
//Sửa
public void SuaDuLieu(E_Sach et)
{
sql.SuaDuLieu(et);
}
// Thêm Dữ Liệu
public void ThemDuLieu(E_Sach et)
{
sql.ThemDuLieu(et);
}
//Xoá
public void XoaDuLieu(E_Sach et)
{
cn.ThucThiCauLenh(@"DELETE FROM Sach Where masach='" + et.masach + "'");
}
//Sửa
public void SuaDuLieu(E_Sach et)
{
cn.ThucThiCauLenh(@"UPDATE Sach SET tensach = N'" + et.tensach + "', theloai =N'" + et.theloai + "', tacgia ='" + et.tacgia + "', namsx ='" + et.namsx + "', nhaxuatban ='" + et.nhaxuatban + "', ngaynhap ='" + et.ngaynhap + "', trigia ='" + et.trigia + "' Where masach='" + et.masach + "'");
}
// Thêm Dữ Liệu
public void ThemDuLieu(E_Sach et)
{
cn.ThucThiCauLenh(@"INSERT INTO Sach (masach, tensach, theloai, tacgia, namsx, nhaxuatban, ngaynhap, trigia) VALUES ('" + et.masach + "',N'" + et.tensach + "',N'" + et.theloai + "',N'" + et.tacgia + "',N'" + et.namsx + "',N'" + et.nhaxuatban + "',N'" + et.ngaynhap + "',N'" + et.trigia + "')");
}
