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);
}
