public void XoaDuLieu(E_NhanVien et)
{
sql.XoaDuLieu(et);
}
public void SuaDuLieu(E_NhanVien et)
{
sql.SuaDuLieu(et);
}
public void XoaDuLieu(E_NhanVien et)
{
cn.ThucThiCauLenhSQL(@"DELETE from NhanVien Where MaNV = N'" + et.MaNV + "')");
}
public void ThemDuLieu(E_NhanVien et)
{
sql.ThemDuLieu(et);
}
public void SuaDuLieu(E_NhanVien et)
{
cn.ThucThiCauLenhSQL(@"UPDATE NhanVien (MaNV, TenNV, Sex, NgaySinh, ADDRESS, SDT, ChucVu, Email, NgayLam, MaKho, Luong, Tongtien) " +
"VALUES (N'" + et.MaNV + "',N'" + et.TenNV + "',N'" + et.Sex + "',N'" + et.NgaySinh + "',N'" + et.ADDRESS + "',N'" + et.SDT + "',N'" + et.SDT + "',N'" + et.ChucVu + "',N'" + et.Email + "',N'" + et.NgayLam + "',N'" + et.MaKho + "',N'" + et.Luong + "',N'" + et.Tongtien + "')");
}
