private void Window_Loaded(object sender, RoutedEventArgs e) { ERPEF entity = new ERPEF(); comboBoxStates.ItemsSource = entity.States.ToList(); comboBoxStates.SelectedIndex = 0; }
private void buttonDisplay_Click(object sender, RoutedEventArgs e) { try { using (ERPEF entity = new ERPEF()) { IQueryable <Employee> employees = null; string keyword = textBoxKeyword.Text; string state = Convert.ToString(comboBoxStates.SelectedValue).Trim(); if (keyword != "" || state != "") { employees = entity.Employees. Where(n => (keyword != "" && (n.FirstName.Contains(keyword) || n.LastName.Contains(keyword))) || keyword == ""). Where(n => state == "" || (state != "" && n.StateCode.Equals(state))); } else { employees = entity.Employees; } //listViewData.ItemsSource = employees.ToList(); CollectionView view = (CollectionView)CollectionViewSource.GetDefaultView(employees.ToList()); PropertyGroupDescription groupDescription = new PropertyGroupDescription("StateCode"); view.GroupDescriptions.Add(groupDescription); listViewData.ItemsSource = view; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }