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 + "')");
}