public void XoaDuLieu(ECtblNhanVien et) { sql.XoaDuLieu(et); }
public void SuaDuLieu(ECtblNhanVien et) { sql.SuaDuLieu(et); }
public void ThemDuLieu(ECtblNhanVien et) { sql.ThemDuLieu(et); }
public void XoaDuLieu(ECtblNhanVien et) { cn.ThucThiCauLenhSQL(@"DELETE from tblNhanVien where MaNV=N'" + et.MaNV + "'"); }
public void SuaDuLieu(ECtblNhanVien et) { cn.ThucThiCauLenhSQL(@"UPDATE tblNhanVien SET TenNV =N'" + et.TenNV + "', DiaChi =N'" + et.DiaChi + "', DienThoai =N'" + et.DienThoai + "', TinhTrang = N'" + et.TinhTrang + "', TenDN ='" + et.TenDN + "', MatKhau ='" + et.MatKhau + "' where MaNV=N'" + et.MaNV + "'"); }
public void ThemDuLieu(ECtblNhanVien et) { cn.ThucThiCauLenhSQL(@"INSERT INTO tblNhanVien (MaNV, TenNV, DiaChi, DienThoai, TinhTrang, TenDN, MatKhau ) VALUES(N'" + et.MaNV + "',N'" + et.TenNV + "',N'" + et.DiaChi + "',N'" + et.DienThoai + "',N'" + et.TinhTrang + "',N'" + et.TenDN + "','" + et.MatKhau + "')"); }