private void frmRental_Load(object sender, EventArgs e)
{
try
{
rentalList = Rentals.GetRentals();
rentalDataGridView.DataSource = rentalList;
List <Movie> movieList = Movies.GetMovies();
cmbMovieNumber.DataSource = movieList;
cmbMovieNumber.DisplayMember = Movies.extra;
cmbMovieNumber.ValueMember = Movies.key;
cmbMovieNumber.SelectedIndex = -1;
List <Member> memberList = Members.GetMembers();
cmbMemberNumber.DataSource = memberList;
cmbMemberNumber.DisplayMember = Members.extra3;
cmbMemberNumber.ValueMember = Members.key;
cmbMemberNumber.SelectedIndex = -1;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
ToolTip toolTip = new ToolTip();
toolTip.SetToolTip(btnAdd, "Add Movie, Member, Checkout and Return");
toolTip.SetToolTip(btnBrowse, "Browse by Movie, Member and Checkout");
toolTip.SetToolTip(btnUpdate, "Update Movie, Member, Checkout and Return");
toolTip.SetToolTip(btnDelete, "Delete Movie, Member and Checkout");
toolTip.SetToolTip(btnClear, "Clear all Rental fields");
toolTip.SetToolTip(cmbMovieNumber, Rental.movie_numberTip);
toolTip.SetToolTip(lblMovieNumber, Rental.movie_numberTip);
toolTip.SetToolTip(cmbMemberNumber, Rental.member_numberTip);
toolTip.SetToolTip(lblMemberNumber, Rental.member_numberTip);
toolTip.SetToolTip(dtpMediaCheckoutDate, Rental.media_checkout_dateTip);
toolTip.SetToolTip(lblMediaCheckoutDate, Rental.media_checkout_dateTip);
toolTip.SetToolTip(dtpMediaReturnDate, Rental.media_return_dateTip);
toolTip.SetToolTip(lblMediaReturnDate, Rental.media_return_dateTip);
rentalDataGridView.Width = 43 + 3 * 100 + 17;
rentalDataGridView.Height = 23 + 3 * 22 + 17;
}
private void btnDelete_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
{
Movie objMovie = new Movie();
objMovie.movie_number = movie_number;
try
{
bool status = Movies.DeleteMovie(objMovie);
if (status)
{
MessageBox.Show(MsgBoxHelper.Deleted("Movie"), "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
movieList = Movies.GetMovies();
movieDataGridView.DataSource = movieList; //TODO genre not -1?
}
else
{
MessageBox.Show(MsgBoxHelper.Deleted("Movie not"), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (CheckAll())
{
Movie objMovie = new Movie();
int movie_year_made,
copies_on_hand;
float movie_retail_cost;
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.AddMovie(objMovie);
if (status)
{
MessageBox.Show(MsgBoxHelper.Inserted("Movie"), "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
movieList = Movies.GetMovies();
movieDataGridView.DataSource = movieList; //TODO genre not -1?
txtMovieNumber.Text = objMovie.movie_number.ToString();
}
else
{
MessageBox.Show(MsgBoxHelper.Inserted("Movie not"), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
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);
}
}
}
}
