Esempio n. 1
0
        private void btnModify_Click(object sender, EventArgs e)
        {
            // create a new Movie object that holds the changes
            Movie newMovie = new Movie();

            newMovie.Id = currentMovie.Id;
            if (txtTitle.Text.Trim() != "")
            {
                newMovie.Title = txtTitle.Text.Trim();
            }
            if (cboFormat.SelectedIndex != 0)
            {
                newMovie.Format = cboFormat.Text;
            }
            if (cboGenre.SelectedIndex != 0)
            {
                newMovie.Genre = cboGenre.Text;
            }
            if (cboYear.SelectedIndex != 0)
            {
                newMovie.Year = Convert.ToInt16(cboYear.Text);
            }
            if (txtSynopsis.Text.Trim() != "")
            {
                newMovie.Synopsis = txtSynopsis.Text.Trim();
            }

            // update the database with changes
            bool modify = false;

            if (newMovie.Title != null)
            {
                modify = MovieDB.Modify(newMovie, currentMovie);
            }
            else
            {
                MessageBox.Show("Please add the Title of the movie.");
                newMovie.Title = "\"Empty Title\""; // this is ok because whenever you click btnModify it creates a new movie object so it clears this
            }


            // display a confirmation message
            if (modify == true)
            {
                MessageBox.Show(newMovie.Title + " has been modified in the database.");
                currentMovie = newMovie;            // if the database was modified then
                                                    //assign the value currentMovie
                                                    //variable to be the newMovie
            }
            else
            {
                MessageBox.Show(newMovie.Title + " was not modified in the database. " +
                                "Try again.");
            }
        }
Esempio n. 2
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            // create a new movie object
            Movie newMovie = new Movie();

            // check to see if the field has a valid value and then store it in its corrisponding variable
            if (txtTitle.Text.Trim() != "")
            {
                newMovie.Title = txtTitle.Text.Trim();
            }
            if (cboFormat.SelectedIndex != 0)
            {
                newMovie.Format = cboFormat.Text;
            }
            if (cboGenre.SelectedIndex != 0)
            {
                newMovie.Genre = cboGenre.Text;
            }
            if (cboYear.SelectedIndex != 0)
            {
                newMovie.Year = Convert.ToInt16(cboYear.Text);
            }
            if (txtSynopsis.Text.Trim() != "")
            {
                newMovie.Synopsis = txtSynopsis.Text.Trim();
            }

            // check to see any of the fields have values if so search DB and if no fields have values then let the user know
            if (!(newMovie.Title == null && newMovie.Format == null &&
                  newMovie.Genre == null && newMovie.Year == null && newMovie.Synopsis == null))
            {
                if (newMovie.Title != null)
                {
                    MovieDB.Add(newMovie);
                }
                else
                {
                    MessageBox.Show("There must be a title name. Please fill in that field.");
                }
            }
            else
            {
                MessageBox.Show("All search entries are empty. Please fill in one of them.", "Entry Error");
            }
        }
Esempio n. 3
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            // create a movie object to hold the search data
            Movie movieSearch = new Movie();

            // check to see if the field has a valid value and then store it in its corrisponding variable
            if (txtTitle.Text.Trim() != "")
            {
                movieSearch.Title = txtTitle.Text.Trim();
            }
            if (cboFormat.SelectedIndex != 0)
            {
                movieSearch.Format = cboFormat.Text;
            }
            if (cboGenre.SelectedIndex != 0)
            {
                movieSearch.Genre = cboGenre.Text;
            }
            if (cboYear.SelectedIndex != 0)
            {
                movieSearch.Year = Convert.ToInt16(cboYear.Text);
            }
            if (txtSynopsis.Text.Trim() != "")
            {
                movieSearch.Synopsis = txtSynopsis.Text.Trim();
            }

            // check to see any of the fields have values if so search DB and if no fields have values then let the user know
            if (!(movieSearch.Title == null && movieSearch.Format == null &&
                  movieSearch.Genre == null && movieSearch.Year == null &&
                  movieSearch.Synopsis == null))
            {
                MovieDB.Search(moviesDataGridView, movieSearch);
            }
            else
            {
                MessageBox.Show("All search entries are empty. Please fill in one of them.", "Entry Error");
            }
        }