public void deleteNhanVien(string manv) { TAI_KHOAN kq1 = context.TAI_KHOANs.Where(t => t.MANV == manv).FirstOrDefault(); kq1.HOATDONG = 0; context.SubmitChanges(); }
public LoginResult checkUser(string userName, string passWord) { TAI_KHOAN result = context.TAI_KHOANs.Where(tk => tk.TENDN == userName && tk.MATKHAU == passWord).FirstOrDefault(); if (result == null) { return(LoginResult.Invalid); } else { if (result.HOATDONG == 0) { return(LoginResult.Disabled); } return(LoginResult.Success); } }
public void capNhatNhanVien(NHANVIEN nv) { NHANVIEN kq = context.NHANVIENs.Where(t => t.MANV == nv.MANV).FirstOrDefault(); kq.TENNV = nv.TENNV; kq.CHUCVU = nv.CHUCVU; kq.PHAI_NV = nv.PHAI_NV; kq.DIACHI_NV = nv.DIACHI_NV; kq.EMAIL = nv.EMAIL; kq.NGAY_SINH = nv.NGAY_SINH; kq.LUONG = nv.LUONG; TAI_KHOAN kq1 = context.TAI_KHOANs.Where(t => t.MANV == nv.MANV).FirstOrDefault(); kq1.MATKHAU = nv.MATKHAU; kq1.HOATDONG = nv.HOATDONG == "ACTIVE" ? 1 : 0; context.SubmitChanges(); }
public TAI_KHOAN getTaiKhoan(string userName, string passWord) { TAI_KHOAN result = context.TAI_KHOANs.Where(tk => tk.TENDN == userName && tk.MATKHAU == passWord).FirstOrDefault(); return(result); }