Exemple #1
0
        private void deleteButton_Click(object sender, RoutedEventArgs e)
        {
            if (proceduresGrid.SelectedItems.Count > 0)
            {
                var procedure = proceduresGrid.SelectedItems[0] as BaseProcedures;

                if (procedure == null)
                {
                    return;
                }

                var paramNames =
                    db.BaseProcedureParameterNames.Where(p => p.BaseProcedureId == procedure.BaseProcedureId).ToList();

                if (paramNames.Count > 0)
                {
                    MessageBox.Show("Нельзя удалить процедуру, т.к. у неё есть параметры!");
                    return;
                }

                db.BaseProcedureParameterNames.RemoveRange(paramNames);

                db.BaseProcedures_Delete(procedure.BaseProcedureId);
                proceduresGrid.ItemsSource = null;
                proceduresGrid.ItemsSource = db.BaseProcedures.ToList();
            }
        }