private void SaveButton_Click(object sender, RoutedEventArgs e) { /*I check if all TextBoxes have valid values in them, if not they won't be saved*/ if (TitleTextBox.Text == "Title..." || InstructorTextBox.Text == "Instructor..." || YearTextBox.Text == "Year...") { MessageBox.Show("All values must be given!"); } else { /*If the values are valid you have to confirm that you want to save it*/ MessageBoxResult warning; warning = MessageBox.Show("Are you sure you want to add this?", "Warning!", MessageBoxButton.YesNo); if (warning == MessageBoxResult.No) { this.Close(); } else if (warning == MessageBoxResult.Yes) { /*Here I update the values that exist already since this */ SqlManagement sqlManagement = new SqlManagement(); sqlManagement.RunNonQuery($"UPDATE movieList SET movieTitle = '{TitleTextBox.Text}', " + $"movieInstructor = '{InstructorTextBox.Text}', movieYear = {Convert.ToInt32(YearTextBox.Text)} WHERE " + $"movieTitle = '{((MainWindow)Application.Current.MainWindow).ItemList.SelectedItem}'"); } } }
public Edit() { InitializeComponent(); /*I grab the selected movies information using a query*/ SqlManagement sqlManagement = new SqlManagement(); string[] results = sqlManagement.RunQuery($"SELECT * FROM movieList WHERE movieTitle = '{((MainWindow)Application.Current.MainWindow).ItemList.SelectedItem}'").Split(','); TitleTextBox.Text = results[0]; InstructorTextBox.Text = results[1]; YearTextBox.Text = results[2]; }
public MainWindow() { /*I open an instance of my SqlManagement and use a method that returns a list which I display*/ SqlManagement sqlManagement = new SqlManagement(); InitializeComponent(); List <string> menuItems = sqlManagement.RunQueryList($"SELECT movieTitle FROM MovieList"); foreach (var item in menuItems) { ItemList.Items.Add(item); } }
private void SaveButton_Click(object sender, RoutedEventArgs e) { if (TitleTextBox.Text == "Title..." || InstructorTextBox.Text == "Instructor..." || YearTextBox.Text == "Year...") { MessageBox.Show("All values must be given!"); } else { MessageBoxResult warning; warning = MessageBox.Show("Are you sure you want to add this?", "Warning!", MessageBoxButton.YesNo); if (warning == MessageBoxResult.No) { this.Close(); } else if (warning == MessageBoxResult.Yes) { SqlManagement sqlManagement = new SqlManagement(); sqlManagement.RunNonQuery($"INSERT INTO movieList VALUES ('{TitleTextBox.Text}', '{InstructorTextBox.Text}', {Convert.ToInt32(YearTextBox.Text)})"); } } }
private void Delete_Click(object sender, RoutedEventArgs e) { /*I run a non query which deletes the selected movie*/ SqlManagement sqlManagement = new SqlManagement(); sqlManagement.RunNonQuery($"DELETE FROM movieList WHERE movieTitle = '{ItemList.SelectedItem.ToString()}'"); }