private void frmMovie_Load(object sender, EventArgs e) { try { movieList = Movies.GetMovies(); movieDataGridView.DataSource = movieList; List <Genre> genreList = Genres.GetGenres(); cmbGenreID.DataSource = genreList; cmbGenreID.DisplayMember = Genres.extra; cmbGenreID.ValueMember = Genres.key; cmbGenreID.SelectedIndex = -1; } catch (Exception ex) { MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error); } ToolTip toolTip = new ToolTip(); toolTip.SetToolTip(btnAdd, "Add all Movie fields"); toolTip.SetToolTip(btnFind, "Browse by Movie Number"); toolTip.SetToolTip(btnUpdate, "Update all Movie fields"); toolTip.SetToolTip(btnDelete, "Delete Movie Number"); toolTip.SetToolTip(btnClear, "Clear all Movie fields"); toolTip.SetToolTip(txtMovieNumber, Movie.movie_numberTip); toolTip.SetToolTip(lblMovieNumber, Movie.movie_numberTip); toolTip.SetToolTip(txtMovieTitle, Movie.movie_titleTip); toolTip.SetToolTip(lblMovieTitle, Movie.movie_titleTip); toolTip.SetToolTip(txtDescription, Movie.DescriptionTip); toolTip.SetToolTip(lblDescription, Movie.DescriptionTip); toolTip.SetToolTip(txtMovieYearMade, Movie.movie_year_madeTip); toolTip.SetToolTip(lblMovieYearMade, Movie.movie_year_madeTip); toolTip.SetToolTip(cmbGenreID, Movie.genre_idTip); toolTip.SetToolTip(lblGenreID, Movie.genre_idTip); toolTip.SetToolTip(cmbMovieRating, Movie.movie_ratingTip); toolTip.SetToolTip(lblMovieRating, Movie.movie_ratingTip); toolTip.SetToolTip(cmbMediaType, Movie.media_typeTip); toolTip.SetToolTip(lblMediaType, Movie.media_typeTip); toolTip.SetToolTip(txtMovieRetailCost, Movie.movie_retail_costTip); toolTip.SetToolTip(lblMovieRetailCost, Movie.movie_retail_costTip); toolTip.SetToolTip(txtCopiesOnHand, Movie.copies_on_handTip); toolTip.SetToolTip(lblCopiesOnHand, Movie.copies_on_handTip); toolTip.SetToolTip(txtImage, Movie.imageTip); toolTip.SetToolTip(lblImage, Movie.imageTip); toolTip.SetToolTip(txtTrailer, Movie.trailerTip); toolTip.SetToolTip(lblTrailer, Movie.trailerTip); movieDataGridView.Width = 43 + 9 * 100 + 17; movieDataGridView.Height = 23 + 3 * 22 + 17; }
private void btnUpdate_Click(object sender, EventArgs e) { int movie_number; if (!Int32.TryParse(txtMovieNumber.Text.Trim(), out movie_number)) { MessageBox.Show(MsgBoxHelper.MustBe(lblMovieNumber.Text), "Invalid " + lblMovieNumber.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); txtMovieNumber.Focus(); } else { if (movie_number > short.MaxValue) // 32767 { MessageBox.Show(MsgBoxHelper.LTETmax(lblMovieNumber.Text), "Invalid " + lblMovieNumber.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); txtMovieNumber.Focus(); } else if (movie_number < short.MinValue)//-32768 { MessageBox.Show(MsgBoxHelper.GTETmin(lblMovieNumber.Text), "Invalid " + lblMovieNumber.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); txtMovieNumber.Focus(); } else if (CheckAll()) { Movie objMovie = new Movie(); int movie_year_made, copies_on_hand; float movie_retail_cost; objMovie.movie_number = movie_number; objMovie.movie_title = txtMovieTitle.Text.Trim(); objMovie.Description = txtDescription.Text.Trim(); Int32.TryParse(txtMovieYearMade.Text.Trim(), out movie_year_made); objMovie.movie_year_made = movie_year_made; objMovie.genre_id = (int)cmbGenreID.SelectedValue; objMovie.movie_rating = cmbMovieRating.Text; objMovie.media_type = cmbMediaType.Text; float.TryParse(txtMovieRetailCost.Text.Trim(), out movie_retail_cost); objMovie.movie_retail_cost = movie_retail_cost; Int32.TryParse(txtCopiesOnHand.Text.Trim(), out copies_on_hand); objMovie.copies_on_hand = copies_on_hand; objMovie.image = txtImage.Text.Trim(); picImage.ImageLocation = objMovie.image; objMovie.trailer = txtTrailer.Text.Trim(); try { bool status = Movies.UpdateMovie(objMovie); if (status) { MessageBox.Show(MsgBoxHelper.Updated("Movie"), "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); movieList = Movies.GetMovies(); movieDataGridView.DataSource = movieList; //TODO genre not -1? } else { MessageBox.Show(MsgBoxHelper.Updated("Movie not"), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }