private void btnUpdate_Click(object sender, EventArgs e)
{
int id;
if (!Int32.TryParse(txtID.Text.Trim(), out id))
{
MessageBox.Show(MsgBoxHelper.MustBe(lblID.Text), "Invalid " + lblID.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtID.Focus();
}
else
{
if (id > short.MaxValue) // 32767
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblID.Text), "Invalid " + lblID.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtID.Focus();
}
else if (id < short.MinValue)//-32768
{
MessageBox.Show(MsgBoxHelper.GTETmin(lblID.Text), "Invalid " + lblID.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtID.Focus();
}
else if (CheckAll())
{
Genre objGenre = new Genre();
objGenre.id = id;
objGenre.name = txtName.Text.Trim();
try
{
bool status = Genres.UpdateGenre(objGenre);
if (status)
{
MessageBox.Show(MsgBoxHelper.Updated("Genre"), "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmGenre_Load(sender, e);
}
else
{
MessageBox.Show(MsgBoxHelper.Updated("Genre not"), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if ((cmbMovieNumber.SelectedIndex == -1) && (cmbMemberNumber.SelectedIndex == -1) && dtpMediaCheckoutDate.Value == new DateTime(1753, 1, 1, 0, 0, 0))
{
MessageBox.Show(lblMovieNumber.Text + " and " + lblMemberNumber.Text + " and " + lblMediaCheckoutDate.Text + " must not all be blank.",
"Invalid " + lblMovieNumber.Text + " and/or " + lblMemberNumber.Text + " and/or " + lblMediaCheckoutDate.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error);
}
else
{
int first,
second;
if (cmbMovieNumber.SelectedIndex == -1)
{
first = -1;
}
else
{
first = (int)cmbMovieNumber.SelectedValue;
}
if (cmbMemberNumber.SelectedIndex == -1)
{
second = -1;
}
else
{
second = (int)cmbMemberNumber.SelectedValue;
}
Rental objRental = new Rental();
objRental.movie_number = first;
objRental.member_number = second;
objRental.media_checkout_date = dtpMediaCheckoutDate.Value;
objRental.media_return_date = dtpMediaReturnDate.Value;
try
{
bool status = Rentals.UpdateRental(ref objRental);
if (!BadKey(objRental, first, second))
{
//objRental.media_return_date = dtpMediaReturnDate.Value;//TODO only add if not blank
if (status)
{
MessageBox.Show(MsgBoxHelper.Updated("Rental"), "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
rentalList = Rentals.GetRentals();
rentalDataGridView.DataSource = rentalList; //TODO movie and member not -1?
}
else
{
MessageBox.Show(MsgBoxHelper.Updated("Rental not"), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
int number;
if (!Int32.TryParse(txtNumber.Text.Trim(), out number))
{
MessageBox.Show(MsgBoxHelper.MustBe(lblNumber.Text), "Invalid " + lblNumber.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtNumber.Focus();
}
else
{
if (number > short.MaxValue) // 32767
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblNumber.Text), "Invalid " + lblNumber.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtNumber.Focus();
}
else if (number < short.MinValue)//-32768
{
MessageBox.Show(MsgBoxHelper.GTETmin(lblNumber.Text), "Invalid " + lblNumber.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtNumber.Focus();
}
else if (CheckAll())
{
Member objMember = new Member();
Int32.TryParse(txtNumber.Text.Trim(), out number);
objMember.number = number;
objMember.joindate = dtpJoinDate.Value;
objMember.firstname = txtFirstName.Text.Trim();
objMember.lastname = txtLastName.Text.Trim();
objMember.address = txtAddress.Text.Trim();
objMember.city = txtCity.Text.Trim();
objMember.state = txtState.Text.Trim();
objMember.zipcode = txtZipCode.Text.Trim();
objMember.phone = txtPhone.Text.Trim();
objMember.member_status = rdoActive.Checked ? "A" : "I";
objMember.login_name = txtLoginName.Text.Trim();
objMember.password = txtPassword.Text.Trim();
objMember.email = txtEmail.Text.Trim();
if (rdoEmail.Checked)
{
objMember.contact_method = 1;
}
else if (rdoFacebook.Checked)
{
objMember.contact_method = 2;
}
else if (rdoPhoneText.Checked)
{
objMember.contact_method = 3;
}
else if (rdoTwitter.Checked)
{
objMember.contact_method = 4;
}
else
{
objMember.contact_method = 0;
}
objMember.subscription_id = (int)cmbSubscriptionID.SelectedValue;
objMember.photo = imageLocation;
try
{
bool status = Members.UpdateMember(objMember);
if (status)
{
MessageBox.Show(MsgBoxHelper.Updated("Member"), "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
memberList = Members.GetMembers();
memberDataGridView.DataSource = memberList;
}
else
{
MessageBox.Show(MsgBoxHelper.Updated("Member not"), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
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);
}
}
}
}
