private void createBacklogButton_Click(object sender, RoutedEventArgs e) { // Create a new window to input new information about the new Backlog NewBacklogWindow myWindow = new NewBacklogWindow(); myWindow.Closing += MyWindow_Closing; myWindow.ShowDialog(); }
private void MyWindow_Closing(object sender, System.ComponentModel.CancelEventArgs e) { NewBacklogWindow win = sender as NewBacklogWindow; // If the Tag is TRUE (no UNIQUE constraints errors) then proceed as normal if ((Boolean)win.Tag) { try { // Obtain the newly created row SQLiteConnection sqlConnection1 = new SQLiteConnection(connectionString); sqlConnection1.Open(); SQLiteCommand myCommand = new SQLiteCommand("SELECT * FROM [backlogs] WHERE [name] = @param", sqlConnection1); myCommand.Parameters.Add(new SQLiteParameter("@param", win.Title.ToString())); SQLiteDataReader myReader = myCommand.ExecuteReader(); // Create a Button for the newly inserted row Button myButton = new Button(); // Set Button properties myReader.Read(); myButton.Style = Application.Current.FindResource("BacklogButton") as Style; myButton.Content = myReader["name"].ToString(); myButton.Tag = myReader["summary"].ToString(); myButton.Click += new RoutedEventHandler(myButton_Click); myReader.Close(); // Add created DockPanel to the StackPanel DockPanel myDockPanel = createBacklogDockPanel(myButton); BacklogsStackPanel.Children.Add(myDockPanel); sqlConnection1.Close(); } catch (Exception excep) { Console.WriteLine(excep.ToString()); } } }