public void XoaDuLieu(ECtblKhachHang et)
{
sql.XoaDuLieu(et);
}
public void SuaDuLieu(ECtblKhachHang et)
{
sql.SuaDuLieu(et);
}
public void ThemDuLieu(ECtblKhachHang et)
{
sql.ThemDuLieu(et);
}
public void XoaDuLieu(ECtblKhachHang et)
{
cn.ThucThiCauLenhSQL(@"DELETE from tblKhachHang where MaKH=N'" + et.MaKH + "'");
}
public void SuaDuLieu(ECtblKhachHang et)
{
cn.ThucThiCauLenhSQL(@"UPDATE tblKhachHang SET TenKH =N'" + et.TenKH + "', MaLoaiKH =N'" + et.MaLoaiKH + "', DiaChi =N'" + et.Diachi + "', DienThoai =N'" + et.DienThoai + "', TinhTrang = N'" + et.TinhTrang + "'where MaKH=N'" + et.MaKH + "'");
}
public void ThemDuLieu(ECtblKhachHang et)
{
cn.ThucThiCauLenhSQL(@"INSERT INTO tblKhachHang (MaKH, TenKH, MaLoaiKH, DiaChi, DienThoai, TinhTrang) VALUES(N'" + et.MaKH + "',N'" + et.TenKH + "',N'" + et.MaLoaiKH + "',N'" + et.Diachi + "',N'" + et.DienThoai + "',N'" + et.TinhTrang + "')");
}