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;
}
