private void deleteButton_Click(object sender, EventArgs e) { if (foundMovie is null) { MessageBox.Show("No movie was found."); } else { string displayText = "* Deleting Movie: *\n\n" + $"Movie Title: {foundMovie.MovieTitle}\n" + $"Year: {foundMovie.Year}\n" + $"Director: {foundMovie.Director}\n" + $"Genre: {foundMovie.Genre}\n" + $"RT Score: {foundMovie.RTScore}\n" + $"BOE: {foundMovie.BOE}"; MessageBox.Show(displayText); SqlHandler.deleteRecord(foundMovie); } }
private void findButton_Click(object sender, EventArgs e) { MovieData movieData = new MovieData(textBox_movieTitle.Text.Trim(), textBox_year.Text.Trim(), textBox_director.Text.Trim(), comboBox_genre.Text.Trim(), textBox_rtScore.Text.Trim(), textBox_boe.Text.Trim()); string displayText = "* Find Button *\n\n" + $"Movie Title: {movieData.MovieTitle}\n"; MessageBox.Show(displayText); // findRecord should return a single MovieData object and then populate the text fields with its data foundMovie = SqlHandler.findRecord(movieData); if (foundMovie is null) { MessageBox.Show($"No movie was found with title \"{movieData.MovieTitle}\""); } else { // Keep track of the found movie's id in case we want to update it //foundId = foundMovie.Id; // Populate text fields textBox_movieTitle.Text = foundMovie.MovieTitle; textBox_year.Text = foundMovie.Year; textBox_director.Text = foundMovie.Director; comboBox_genre.Text = foundMovie.Genre; textBox_rtScore.Text = foundMovie.RTScore; textBox_boe.Text = foundMovie.BOE; } }
private void RefreshMovieData() { ArrayList allMovieData = SqlHandler.queryAllMovieData(); dataGridView.DataSource = allMovieData; }