public bool ChangeAccount(int username, NHANVIEN after) //NHANVIEN before { db = new PBL3_QLTraSuaEntities(); var s = db.NHANVIENs.Where(p => p.ID_NV == username).FirstOrDefault(); s.Ten_NV = after.Ten_NV; s.password = after.password; try { db.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool Delete(NHANVIEN temp) { try { using (var newStaff = new PBL3_QLTraSuaEntities()) { newStaff.Entry(temp).State = System.Data.Entity.EntityState.Deleted; newStaff.SaveChanges(); MessageBox.Show("Thành Công"); return(true); } } catch (Exception) { MessageBox.Show("Lỗi"); return(false); } }
public bool Update(NHANVIEN before, NHANVIEN after) //NHANVIEN before { try { using (PBL3_QLTraSuaEntities db = new PBL3_QLTraSuaEntities()) //var newStaff = new PBL3_QLTraSuaEntities() { before = db.NHANVIENs.Where(p => p.ID_NV.Equals(before.ID_NV)).SingleOrDefault(); before.Ten_NV = after.Ten_NV; before.PhoneNumber = after.PhoneNumber; before.Gender = after.Gender; db.SaveChanges(); MessageBox.Show("Thành Công"); return(true); } } catch (Exception) { MessageBox.Show("Lỗi "); return(false); } }
public bool ResetPassword_DAL(string username, string newpassword) { db = new PBL3_QLTraSuaEntities(); var s = db.NHANVIENs.Where(p => p.PhoneNumber == username).FirstOrDefault(); s.password = newpassword; try { db.SaveChanges(); return(true); } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Console.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } return(false); } }
public void Sync() { db.SaveChanges(); }