public bool UpdateFaculty(FacultyDTO user) { using (officehoursEntities officeHoursDB = new officehoursEntities()) { var facultyData = (from f in officeHoursDB.officehours_faculty where f.member_id == user.memberId select f).FirstOrDefault(); facultyData.member_id = user.memberId; facultyData.first_Name = user.firstName; facultyData.last_Name = user.lastName; facultyData.Email = user.Email; facultyData.Password = user.Password; facultyData.account_status = user.accountStatus; facultyData.auth_code = user.authCode; facultyData.create_date = DateTime.Now; facultyData.phone_number = user.phoneNumber; officeHoursDB.Entry(facultyData).State = EntityState.Modified; try { officeHoursDB.SaveChanges(); return(true); } catch (Exception ex) { return(false); } } }