public void XoaDuLieu(E_Vendor et)
{
sql.XoaDuLieu(et);
}
public void SuaDuLieu(E_Vendor et)
{
sql.SuaDuLieu(et);
}
public void ThemDuLieu(E_Vendor et)
{
sql.ThemDuLieu(et);
}
public void XoaDuLieu(E_Vendor et)
{
cn.ThucThiCauLenhSQL(@"DELETE from Vendor Where MaNCC = N'" + et.MaNCC + "')");
}
public void SuaDuLieu(E_Vendor et)
{
cn.ThucThiCauLenhSQL(@"UPDATE Vendor (MaNCC, TenNCC, ADDRESS, SDT,Price, MaLoaiVendor, SoLuong) " +
"VALUES (N'" + et.MaNCC + "',N'" + et.TenNCC + "',N'" + et.ADDRESS + "',N'" + et.SDT + "')");
}
public void ThemDuLieu(E_Vendor et)
{
cn.ThucThiCauLenhSQL(@"INSERT INTO Vendor (MaNCC,TenNCC,ADDRESS,SDT) " +
"VALUES (N'" + et.MaNCC + "',N'" + et.TenNCC + "',N'" + et.ADDRESS + "',N'" + et.SDT + "')");
}
