private void btnBrowse_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;
try
{
objMovie = Movies.GetMovie(movie_number);
if (objMovie == null)
{
MessageBox.Show(MsgBoxHelper.Selected("Movie " + lblMovieNumber.Text + " " + movie_number), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
txtMovieTitle.Text = objMovie.movie_title;
txtDescription.Text = objMovie.Description;
txtMovieYearMade.Text = objMovie.movie_year_made.ToString();
cmbGenreID.SelectedValue = objMovie.genre_id;
cmbMovieRating.Text = objMovie.movie_rating.Trim();
cmbMediaType.Text = objMovie.media_type;
txtMovieRetailCost.Text = objMovie.movie_retail_cost.ToString();
txtCopiesOnHand.Text = objMovie.copies_on_hand.ToString();
txtImage.Text = objMovie.image;
picImage.ImageLocation = objMovie.image;
txtTrailer.Text = objMovie.trailer;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
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 btnDelete_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
{
Member objMember = new Member();
objMember.number = number;
try
{
bool status = Members.DeleteMember(objMember);
if (status)
{
MessageBox.Show(MsgBoxHelper.Deleted("Member"), "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
memberList = Members.GetMembers();
memberDataGridView.DataSource = memberList;
}
else
{
MessageBox.Show(MsgBoxHelper.Deleted("Member not"), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void btnDelete_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
{
Genre objGenre = new Genre();
objGenre.id = id;
objGenre.name = txtName.Text.Trim();
try
{
bool status = Genres.DeleteGenre(objGenre);
if (status)
{
MessageBox.Show(MsgBoxHelper.Deleted("Genre"), "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmGenre_Load(sender, e);
}
else
{
MessageBox.Show(MsgBoxHelper.Deleted("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)
{
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())
{
Vendor objVendor = new Vendor();
objVendor.id = id;
objVendor.name = txtName.Text.Trim();
try
{
bool status = Vendors.UpdateVendor(objVendor);
if (status)
{
MessageBox.Show(MsgBoxHelper.Updated("Vendor"), "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
frmVendor_Load(sender, e);
}
else
{
MessageBox.Show(MsgBoxHelper.Updated("Vendor not"), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
private void btnBrowse_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
{
Genre objGenre;
try
{
objGenre = Genres.GetGenre(id);
if (objGenre == null)
{
MessageBox.Show(MsgBoxHelper.Selected("Genre " + lblID.Text + " " + id), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
txtName.Text = objGenre.name;
}
}
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);
}
}
}
public bool CheckAll()
{
if (txtName.Text.Trim() != string.Empty)
{
if (txtName.Text.Trim().Length > Genre.nameLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblName.Text, Genre.nameLength), "Invalid " + lblName.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtName.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblName.Text), "Invalid " + lblName.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtName.Focus();
return(false);
}
return(true);
}
private bool BadKey(Rental objRental, int first, int second)
{
if (objRental == null)
{
String tableName = "Rental ";
if (first > -1)
{
tableName += lblMovieNumber.Text + " " + cmbMovieNumber.Text;
if ((second > -1) || (dtpMediaCheckoutDate.Value > new DateTime(1753, 1, 1, 0, 0, 0)))
{
tableName += ", ";
}
}
if (second > -1)
{
tableName += lblMemberNumber.Text + " " + cmbMemberNumber.Text;
if (dtpMediaCheckoutDate.Value > new DateTime(1753, 1, 1, 0, 0, 0))
{
tableName += ", ";
}
}
if (dtpMediaCheckoutDate.Value > new DateTime(1753, 1, 1, 0, 0, 0))
{
tableName += lblMediaCheckoutDate.Text + " " + dtpMediaCheckoutDate.Text;
}
MessageBox.Show(MsgBoxHelper.Selected(tableName), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);//TODO if not -1
return(true);
}
else
{
cmbMovieNumber.SelectedValue = objRental.movie_number;
cmbMemberNumber.SelectedValue = objRental.member_number;
dtpMediaCheckoutDate.Value = objRental.media_checkout_date;
return(false);
}
}
private void btnDelete_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;
try
{
bool status = Rentals.DeleteRental(ref objRental);
if (!BadKey(objRental, first, second))
{
dtpMediaReturnDate.Value = objRental.media_return_date;
if (status)
{
MessageBox.Show(MsgBoxHelper.Deleted("Rental"), "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
rentalList = Rentals.GetRentals();
rentalDataGridView.DataSource = rentalList; //movie and member not -1?
}
else
{
MessageBox.Show(MsgBoxHelper.Deleted("Rental 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())
{
Member objMember = new Member();
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.AddMember(objMember);
if (status)
{
MessageBox.Show(MsgBoxHelper.Inserted("Member"), "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
memberList = Members.GetMembers();
memberDataGridView.DataSource = memberList;
txtNumber.Text = objMember.number.ToString();
}
else
{
MessageBox.Show(MsgBoxHelper.Inserted("Member not"), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public bool CheckAll()
{
if (dtpJoinDate.Value > DateTime.MaxValue) //
{
MessageBox.Show(lblJoinDate.Text + " must be less than or equal to " + DateTime.MaxValue + ".", "Invalid " + lblJoinDate.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
dtpJoinDate.Focus();
return(false);
}
else if (dtpJoinDate.Value <= new DateTime(1753, 1, 1, 0, 0, 0))//
{
MessageBox.Show(lblJoinDate.Text + " must be greater than " + new DateTime(1753, 1, 1, 0, 0, 0) + ".", "Invalid " + lblJoinDate.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
dtpJoinDate.Focus();
return(false);
}
if (txtFirstName.Text.Trim() != string.Empty)
{
if (txtFirstName.Text.Trim().Length > Member.firstnameLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblFirstName.Text, Member.firstnameLength), "Invalid " + lblFirstName.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtFirstName.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblFirstName.Text), "Invalid " + lblFirstName.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtFirstName.Focus();
return(false);
}
if (txtLastName.Text.Trim() != string.Empty)
{
if (txtLastName.Text.Trim().Length > Member.lastnameLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblLastName.Text, Member.lastnameLength), "Invalid " + lblLastName.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtLastName.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblLastName.Text), "Invalid " + lblLastName.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtLastName.Focus();
return(false);
}
if (txtAddress.Text.Trim() != string.Empty)
{
if (txtAddress.Text.Trim().Length > Member.addressLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblAddress.Text, Member.addressLength), "Invalid " + lblAddress.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtAddress.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblAddress.Text), "Invalid " + lblAddress.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtAddress.Focus();
return(false);
}
if (txtCity.Text.Trim() != string.Empty)
{
if (txtCity.Text.Trim().Length > Member.cityLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblCity.Text, Member.cityLength), "Invalid " + lblCity.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCity.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblCity.Text), "Invalid " + lblCity.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCity.Focus();
return(false);
}
if (txtState.Text.Trim() != string.Empty)
{
if (txtState.Text.Trim().Length > Member.stateLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblState.Text, Member.stateLength), "Invalid " + lblState.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtState.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblState.Text), "Invalid " + lblState.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtState.Focus();
return(false);
}
if (txtZipCode.Text.Trim() != string.Empty)
{
if (txtZipCode.Text.Trim().Length > Member.zipcodeLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblZipCode.Text, Member.zipcodeLength), "Invalid " + lblZipCode.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtZipCode.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblZipCode.Text), "Invalid " + lblZipCode.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtZipCode.Focus();
return(false);
}
if (txtPhone.Text.Trim() != string.Empty)
{
if (txtPhone.Text.Trim().Length > Member.phoneLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblPhone.Text, Member.phoneLength), "Invalid " + lblPhone.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtPhone.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblPhone.Text), "Invalid " + lblPhone.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtPhone.Focus();
return(false);
}
if (!rdoActive.Checked && !rdoInactive.Checked)
{
MessageBox.Show(grpMemberStatus.Text + " must be " + rdoActive.Text + " or " + rdoInactive.Text + ".",
"Invalid " + grpMemberStatus.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
return(false);
}
if (txtLoginName.Text.Trim() != string.Empty)
{
if (txtLoginName.Text.Trim().Length > Member.login_nameLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblLoginName.Text, Member.login_nameLength), "Invalid " + lblLoginName.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtLoginName.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblLoginName.Text), "Invalid " + lblLoginName.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtLoginName.Focus();
return(false);
}
if (txtPassword.Text.Trim() != string.Empty)
{
if (txtPassword.Text.Trim().Length > Member.passwordLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblPassword.Text, Member.passwordLength), "Invalid " + lblPassword.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtPassword.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblPassword.Text), "Invalid " + lblPassword.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtPassword.Focus();
return(false);
}
if (txtEmail.Text.Trim() != string.Empty)
{
if (txtEmail.Text.Trim().Length > Member.emailLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblEmail.Text, Member.emailLength), "Invalid " + lblEmail.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtEmail.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblEmail.Text), "Invalid " + lblEmail.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtEmail.Focus();
return(false);
}
if (cmbSubscriptionID.SelectedIndex == -1)
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblSubscriptionID.Text), "Invalid " + lblSubscriptionID.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbSubscriptionID.Focus();
return(false);
}
if (!rdoEmail.Checked && !rdoFacebook.Checked && !rdoPhoneText.Checked && !rdoTwitter.Checked)
{
MessageBox.Show(grpContactMethod.Text + " must be " + rdoEmail.Text + " or " + rdoFacebook.Text + " or " + rdoPhoneText.Text + " or " + rdoTwitter.Text + ".",
"Invalid " + grpContactMethod.Text,
MessageBoxButtons.OK,
MessageBoxIcon.Error
);
return(false);
}
return(true);
}
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 btnBrowse_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
{
Member objMember;
try
{
objMember = Members.GetMember(number);
if (objMember == null)
{
MessageBox.Show(MsgBoxHelper.Selected("Member " + lblNumber.Text + " " + number), "Failure", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
dtpJoinDate.Value = objMember.joindate;
txtFirstName.Text = objMember.firstname.Trim();
txtLastName.Text = objMember.lastname.Trim();
txtAddress.Text = objMember.address.Trim();
txtCity.Text = objMember.city.Trim();
txtState.Text = objMember.state;
txtZipCode.Text = objMember.zipcode;
txtPhone.Text = objMember.phone;
if (objMember.member_status == "A")
{
rdoActive.Checked = true;
}
else
{
rdoInactive.Checked = true;
}
txtLoginName.Text = objMember.login_name;
txtPassword.Text = objMember.password;
txtEmail.Text = objMember.email;
if (objMember.contact_method == 1)
{
rdoEmail.Checked = true;
}
else if (objMember.contact_method == 2)
{
rdoFacebook.Checked = true;
}
else if (objMember.contact_method == 3)
{
rdoPhoneText.Checked = true;
}
else if (objMember.contact_method == 4)
{
rdoTwitter.Checked = true;
}
else
{
objMember.contact_method = 0;
}
cmbSubscriptionID.SelectedValue = objMember.subscription_id;
imageLocation = objMember.photo;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Failure", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
public bool CheckAll()
{
if (txtMovieTitle.Text.Trim() != string.Empty)
{
if (txtMovieTitle.Text.Trim().Length > Movie.movie_titleLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblMovieTitle.Text, Movie.movie_titleLength), "Invalid " + lblMovieTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtMovieTitle.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblMovieTitle.Text), "Invalid " + lblMovieTitle.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtMovieTitle.Focus();
return(false);
}
if (txtDescription.Text.Trim() != string.Empty)
{
if (txtDescription.Text.Trim().Length > Movie.DescriptionLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblDescription.Text, Movie.DescriptionLength), "Invalid " + lblDescription.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtDescription.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblDescription.Text), "Invalid " + lblDescription.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtDescription.Focus();
return(false);
}
int movie_year_made;
if (Int32.TryParse(txtMovieYearMade.Text.Trim(), out movie_year_made))
{
if (movie_year_made > short.MaxValue) // 32767
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblMovieYearMade.Text), "Invalid " + lblMovieYearMade.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtMovieYearMade.Focus();
return(false);
}
else if (movie_year_made < short.MinValue)//-32768
{
MessageBox.Show(MsgBoxHelper.GTETmin(lblMovieYearMade.Text), "Invalid " + lblMovieYearMade.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtMovieYearMade.Focus();
return(false);
}
}
else
{
MessageBox.Show(MsgBoxHelper.MustBe(lblMovieYearMade.Text), "Invalid " + lblMovieYearMade.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtMovieYearMade.Focus();
return(false);
}
if (cmbGenreID.SelectedIndex == -1)
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblGenreID.Text), "Invalid " + lblGenreID.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbGenreID.Focus();
return(false);
}
if (cmbMovieRating.SelectedIndex == -1)
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblMovieRating.Text), "Invalid " + lblMovieRating.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbMovieRating.Focus();
return(false);
}
if (cmbMediaType.SelectedIndex == -1)
{
MessageBox.Show(MsgBoxHelper.NotBlank(lblMediaType.Text), "Invalid " + lblMediaType.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
cmbMediaType.Focus();
return(false);
}
float movie_retail_cost;
if (float.TryParse(txtMovieRetailCost.Text.Trim(), out movie_retail_cost))
{
if (movie_retail_cost > float.MaxValue) //3.40282347E+38
{
MessageBox.Show(lblMovieRetailCost.Text + " must be less than or equal to " + float.MaxValue + ".", "Invalid " + lblMovieRetailCost.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtMovieRetailCost.Focus();
return(false);
}
else if (movie_retail_cost < 0)
{
MessageBox.Show(lblMovieRetailCost.Text + " must be greater than or equal to 0.00.", "Invalid " + lblMovieRetailCost.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtMovieRetailCost.Focus();
return(false);
}
}
else
{
MessageBox.Show(lblMovieRetailCost.Text + " must be a monetary value (0.00 - " + float.MaxValue + ").", "Invalid " + lblMovieRetailCost.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtMovieRetailCost.Focus();
return(false);
}
int copies_on_hand;
if (Int32.TryParse(txtCopiesOnHand.Text.Trim(), out copies_on_hand))
{
if (copies_on_hand > short.MaxValue) // 32767
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblCopiesOnHand.Text), "Invalid " + lblCopiesOnHand.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCopiesOnHand.Focus();
return(false);
}
else if (copies_on_hand < short.MinValue)//-32768
{
MessageBox.Show(MsgBoxHelper.GTETmin(lblCopiesOnHand.Text), "Invalid " + lblCopiesOnHand.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCopiesOnHand.Focus();
return(false);
}
}
else
{
MessageBox.Show(lblCopiesOnHand.Text + " must be an integer (0 - " + short.MaxValue + ").", "Invalid " + lblCopiesOnHand.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtCopiesOnHand.Focus();
return(false);
}
if (txtImage.Text.Trim().Length > Movie.imageLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblImage.Text, Movie.imageLength), "Invalid " + lblImage.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtImage.Focus();
return(false);
}
if (txtTrailer.Text.Trim().Length > Movie.trailerLength)
{
MessageBox.Show(MsgBoxHelper.LTETmax(lblTrailer.Text, Movie.trailerLength), "Invalid " + lblTrailer.Text, MessageBoxButtons.OK, MessageBoxIcon.Error);
txtTrailer.Focus();
return(false);
}
return(true);
}
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);
}
}
}
}
