//Updatebutton click event
private void updateBtn_Click(object sender, RoutedEventArgs e)
{
//If statement that prevents updating a row if the inputs are empty
if (!(movieName.Text == "" || movieReleaseYear.Text == null || movieGenre.Text == "" || movieInstructor.Text == "" || movieActors.Text == ""))
{
//Updatemovie is an action where m is a movie entity
//in the Movies table
//It selects a movie which has the same id as the variable we made earlier
//And only selects one movie*
Entities.Movies updateMovie = (from m in _db.Movies
where m.Id == id
select m).Single();
//Updating the movie columns with the text that is written in the input fields of the updatepage
updateMovie.MovieName = movieName.Text;
updateMovie.ReleaseYear = int.Parse(movieReleaseYear.Text);
updateMovie.Genre = movieGenre.Text;
updateMovie.Instructor = movieInstructor.Text;
updateMovie.Actors = movieActors.Text;
}
//Saving the changes to the database
_db.SaveChanges();
//Adding the changes to the list of movies
MainWindow.datagrid.ItemsSource = _db.Movies.ToList();
//Hiding the window
this.Hide();
}
//Insertbutton click event
private void insertBtn_Click(object sender, RoutedEventArgs e)
{
//Making a new movie entity
Entities.Movies newMovie = new Entities.Movies()
{
//Making the columns equal the input fields text
MovieName = movieName.Text,
ReleaseYear = int.Parse(movieReleaseYear.Text),
Genre = movieGenre.Text,
Instructor = movieInstructor.Text,
Actors = movieActors.Text
};
//Adding the new movie to the Movies table
_db.Movies.Add(newMovie);
//Saving the changes made to the database entity
_db.SaveChanges();
//Adding the changes and all other table data to the datagrid
MainWindow.datagrid.ItemsSource = _db.Movies.ToList();
//Hiding the window
this.Hide();
}
