public void ThemNSX(string tennsx)
{
string sqlQuery = string.Format("Insert into NHASANXUAT values ('',N'{0}')", tennsx);
db.ExecuteNonQuery(sqlQuery);
}
public void XoaKhachHang(string makh)
{
string sqlQuery = "Delete from KHACHHANG where makh = '" + makh + "'";
db.ExecuteNonQuery(sqlQuery);
}
public void XoaSanPham(String masanpham)
{
string sqlQuery = "Delete from SanPham where masanpham = '" + masanpham + "'";
db.ExecuteNonQuery(sqlQuery);
}
public void XoaNhanVien(string manv)
{
string sqlQuery = "Delete from Nhanvien where manv = '" + manv + "'";
db.ExecuteNonQuery(sqlQuery);
}
public void ThemHoaDon(string manv, string makh, string ngayban)
{
string sqlQuery = string.Format("insert into HOADON values('','{0}','{1}','{2}','')", manv, makh, ngayban);
db.ExecuteNonQuery(sqlQuery);
}
public void XoaSanPham_HoaDon(string masp)
{
string sqlQuery = "delete from CHITIETHOADON where masanpham = '" + masp + "'";
db.ExecuteNonQuery(sqlQuery);
}