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