public static List<Friends.Models.State> GetAllStates() { using (AddressBookContext dataContext = new AddressBookContext()) { return (from s in dataContext.States select s).ToList(); } }
public void DeleteFriend(Friend deleteFriend) { using (AddressBookContext dataContext = new AddressBookContext()) { Friend friendToDelete = dataContext.Friends.Single(t => t.ID == deleteFriend.FirstName); dataContext.Friends.Remove(friendToDelete); dataContext.SaveChanges(); } }
public void UpdateFriend(Friend updatefriend) { using (AddressBookContext dataContext = new AddressBookContext()) { Friend friendToUpdate = dataContext.Friends.Single(t => t.FirstName == updatefriend.FirstName); updatefriend.FirstName = updatefriend.FirstName; updatefriend.LastName = updatefriend.LastName; updatefriend.Street = updatefriend.Street; updatefriend.State = updatefriend.State; updatefriend.Zip = updatefriend.Zip; dataContext.SaveChanges(); } }
public List<Friend> GetAllFriends() { using (AddressBookContext dataContext = new AddressBookContext()) { return (from friend in dataContext.Friends orderby friend.FirstName select new Friend { FirstName = friend.FirstName, LastName = friend.LastName, Street = friend.Street, State = friend.State, Zip = friend.Zip, }).ToList(); } }
public void AddFriend(Friend newFriend) { using (AddressBookContext dataContext = new AddressBookContext()) { Friend friend = new Friend { FirstName = newFriend.FirstName, LastName = newFriend.LastName, Street = newFriend.Street, State = newFriend.State, Zip = newFriend.Zip, }; dataContext.Friends.Add(friend); dataContext.SaveChanges(); } }