public void XoaDuLieu(E_KhachHang et)
{
sql.XoaDuLieu(et);
}
public void SuaDuLieu(E_KhachHang et)
{
sql.SuaDuLieu(et);
}
public void ThemDuLieu(E_KhachHang et)
{
sql.ThemDuLieu(et);
}
public void XoaDuLieu(E_KhachHang et)
{
cn.ThucThiCauLenhSQL(@"DELETE from KhachHang Where MaKH = N'" + et.MaKH + "')");
}
public void SuaDuLieu(E_KhachHang et)
{
cn.ThucThiCauLenhSQL(@"UPDATE KhachHang (MaKH, TenKH, ADDRESS, SDT,CCCD, MaLoaiKhachHang, SoLuong) " +
"VALUES (N'" + et.MaKH + "',N'" + et.TenKH + "',N'" + et.ADDRESS + "',N'" + et.SDT + "',N'" + et.CCCD + "')");
}
public void ThemDuLieu(E_KhachHang et)
{
cn.ThucThiCauLenhSQL(@"INSERT INTO KhachHang (MaKH,TenKH,ADDRESS,SDT,CCCD) " +
"VALUES (N'" + et.MaKH + "',N'" + et.TenKH + "',N'" + et.ADDRESS + "',N'" + et.SDT + "',N'" + et.CCCD + "')");
}
