private void btnDelete_Click(object sender, RoutedEventArgs e) { if (MessageBox.Show("Вы действительно хотите удалить этот элемент?", "Подтвердите действие", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { Accomplice a = dataGrid.SelectedItem as Accomplice; if (sqlWorker.deleteItemById("Accomplice", a.Id)) { al.deleteById(a.Id); } else { MessageBox.Show("Ошибка удаления элемента, возможно он уже используется."); } } }
public SelectAccomplice(SqliteWorker _sqlWorker, AccompliceList accompliceList) { InitializeComponent(); lbChoosed.AutoGenerateColumns = false; lbChoosed.IsReadOnly = true; lbNotChoosed.AutoGenerateColumns = false; lbNotChoosed.IsReadOnly = true; sqlWorker = _sqlWorker; aList = new AccompliceList( DataWorker.getAccompliceList( sqlWorker.selectData("SELECT R.shortName as rank, S.shortName as subUnit, SF.shortName as battalion, M.shortName as militaryUnit, A.*, R.priority " + "FROM Accomplice A " + "INNER JOIN SubUnit S ON S.idSubUnit = A.idSubUnit " + "LEFT JOIN Rank R ON R.idRank = A.idRank " + "LEFT JOIN SubUnit SF ON S.idFKSubUnit = SF.idSubUnit " + "LEFT JOIN MilitaryUnit M ON M.idMilitaryUnit = S.idMilitaryUnit OR M.idMilitaryUnit = SF.idMilitaryUnit " + "")));//сортировка хз по чему if (accompliceList == null) { aChoosedList = new AccompliceList(); } else { aChoosedList = accompliceList; for (int i = 0; i < accompliceList.values.Count; i++) { aList.deleteById(accompliceList.values[i].Id); } } aChoosedView = new CollectionViewSource(); aChoosedView.Source = aList.values; aChoosedView.Filter += collectView_Filter; lbChoosed.ItemsSource = aChoosedList.values; lbNotChoosed.ItemsSource = aChoosedView.View; txFilter.Focus(); }