public NHAN_VIEN GetDVByUsername(String username) { NHAN_VIEN result = new NHAN_VIEN(); result = context.NHAN_VIEN.FirstOrDefault(m => m.USERNAME.ToUpper() == username.ToUpper()); return(result); }
public NHAN_VIEN GetDVByMa(int pMaT) { NHAN_VIEN result = new NHAN_VIEN(); result = context.NHAN_VIEN.FirstOrDefault(m => m.MA_NV == pMaT); return(result); }
public int Add(NHAN_VIEN pT) { int result = 0; context.NHAN_VIEN.Add(pT); result = context.SaveChanges(); return(result); }
public int Delete(int pMaT) { int result = 0; NHAN_VIEN k = context.NHAN_VIEN.FirstOrDefault(m => m.MA_NV == pMaT); context.NHAN_VIEN.Remove(k); result = context.SaveChanges(); return(result); }
public int Update(NHAN_VIEN pT) { int result = 0; NHAN_VIEN k = context.NHAN_VIEN.FirstOrDefault(m => m.MA_NV == pT.MA_NV); if (k != null) { k.TEN_NV = pT.TEN_NV; k.USERNAME = pT.USERNAME; k.PASSWORD = pT.PASSWORD; k.DIA_CHI = pT.DIA_CHI; k.EMAIL = pT.EMAIL; } result = context.SaveChanges(); return(result); }