private void ComboBoxCategories_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (ComboBoxCategories.SelectedItem == null) { return; } category = (Category)ComboBoxCategories.SelectedItem; if (EditUser && user != null) { using (var db = new UsersCategoriesModel()) { var userToUpdate = db.Users.Find(user.UserId); // update category userToUpdate.CategoryId = category.CategoryId; db.SaveChanges(); // clear list box ListBox01.ItemsSource = null; // re-display list box users = db.Users.ToList(); ListBox01.ItemsSource = users; MessageBox.Show($"User {user.UserName} category changed to " + $"{userToUpdate.Category.CategoryName}"); // also update second categories ListBox02.ItemsSource = null; categories = db.Categories.ToList(); ListBox02.ItemsSource = categories; EditUser = false; ListBox01.Background = Brushes.White; } } }
void Initialise() { using (var db = new UsersCategoriesModel()) { users = db.Users.ToList(); categories = db.Categories.ToList(); } ListBox01.ItemsSource = users; ListBox02.ItemsSource = categories; ListBox01.DisplayMemberPath = "UserName"; ListBox02.DisplayMemberPath = "CategoryName"; ComboBoxCategories.ItemsSource = categories; ComboBoxCategories.DisplayMemberPath = "CategoryName"; ComboBoxCategories.IsReadOnly = true; ComboBoxCategories.AllowDrop = false; }