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;
        }