private void btnDiscontinue_Click(object sender, EventArgs e) { if (txtDVDId.Text.Equals("")) { MessageBox.Show("Field Must Not Be Empty", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtDVDId.Focus(); return; } DVD dvd = new DVD(); dvd.setDVDId(Convert.ToInt32(grdDVD.Rows[grdDVD.CurrentCell.RowIndex].Cells[0].Value)); dvd.setStatus(cbotxtStatus.Text); dvd.DiscontinueDVD(); if (cbotxtStatus.Text == "A") { dvd.setStatus("A"); } else { dvd.setStatus("NA"); } //Display Confirmation Message MessageBox.Show(grdDVD.Rows[grdDVD.CurrentCell.RowIndex].Cells[1].Value + " status has been changed", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); txtDVDId.Text = ""; cbotxtStatus.Text = ""; DataSet ds = new DataSet(); grdDVD.DataSource = DVD.getDVD(ds).Tables["ss"]; }
private void btnUpdate_Click(object sender, EventArgs e) { //Validate Data if (txtDVDId.Text.Equals("") || txtDVDTitle.Text.Equals("") || txtDVDDescription.Text.Equals("") || txtDVDYearRelease.Text.Equals("") || txtRateCode.Text.Equals("")) { MessageBox.Show("All field must be entered.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtDVDId.Focus(); return; } //instantiate Rate Object DVD myDVD = new DVD(); myDVD.setDVDId(Convert.ToInt32(txtDVDId.Text)); myDVD.setTitle(txtDVDTitle.Text); myDVD.setDescription(txtDVDDescription.Text); myDVD.setYear(Convert.ToInt32(txtDVDYearRelease.Text)); myDVD.setRateCode(txtRateCode.Text); //INSERT DVD record into table myDVD.updDVD(); //Display Confirmation Message MessageBox.Show("DVD has been Updated.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); //Reset UI grpDVD.Visible = false; cboDVD.SelectedIndex = -1; }
private void btnRegDVD_Click(object sender, EventArgs e) { //Validate Data if (txtDVDTitle.Text.Equals("") || txtDVDDescription.Text.Equals("") || txtDVDYearRelease.Text.Equals("") || txtRate.Text.Equals("")) { MessageBox.Show("All field must be entered.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtDVDTitle.Focus(); return; } //Validates Rate Code if (Rate.DVDRateCodeExists(txtRate.Text)) { MessageBox.Show("Rate Code doesnt exist"); return; } //Save Data to Registerd DVD file DVD myRegDVD = new DVD(); myRegDVD.setDVDId(Convert.ToInt32(txtDVDId.Text)); myRegDVD.setTitle(txtDVDTitle.Text); myRegDVD.setDescription(txtDVDDescription.Text); myRegDVD.setYear(Convert.ToInt32(txtDVDYearRelease.Text)); myRegDVD.setRateCode(txtRate.Text); myRegDVD.setStatus("A"); myRegDVD.setRentStatus("NR"); //Insert DVD record into DVD Table myRegDVD.setRegisterDVD(); { //Display Confirmation Message MessageBox.Show("DVD is Registered.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); } //Reset UI txtDVDId.Text = ""; txtDVDTitle.Text = ""; txtDVDDescription.Text = ""; txtDVDYearRelease.Text = ""; txtRate.Text = ""; txtDVDId.Text = DVD.nextDVDId().ToString("0000"); txtDVDTitle.Focus(); }
private void btnDone_Click(object sender, EventArgs e) { //Validate Data if (txtRentId.Text.Equals("") || txtMemId.Equals("")) { MessageBox.Show("All field must be entered.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); txtSearchName.Focus(); return; } string sd = DateTime.Now.ToString("d-MMM-yyyy"); string dd = DateTime.Now.AddDays(7).ToString("d-MMM-yyyy"); //Save Data to Rental file Rentals regExecute = new Rentals(); //Change Rent Status into DVD Table DVD rentDVDStatus = new DVD(); //Save Data to Transaction File Rentals regTransaction = new Rentals(); regExecute.setRentalId(Convert.ToInt32(txtRentId.Text)); regExecute.setName(txtMemName.Text); regExecute.setMemberId(Convert.ToInt32(txtMemId.Text)); regExecute.setRentDate(sd); regExecute.setDueDate(dd); regTransaction.setTransactionId(Convert.ToInt32(txtTransactionId.Text)); regTransaction.setMemberId(Convert.ToInt32(txtMemId.Text)); regTransaction.setRentalId(Convert.ToInt32(txtRentId.Text)); regTransaction.setTransactionType("Payment"); regTransaction.setTransactionDate(sd); regTransaction.setTransactionAmount(Convert.ToDecimal(txtPrice.Text)); //Insert Rental record into Rentals Table regExecute.setRentals(); //Insert Transaction record into Transaction Table regTransaction.setTransaction(); DVD dvdStatus = new DVD(); dvdStatus.setDVDId(Convert.ToInt32(grdSelectDVD.Rows[grdSelectDVD.CurrentCell.RowIndex].Cells[0].Value)); dvdStatus.setRentStatus(grdSelectDVD.Rows[grdSelectDVD.CurrentCell.RowIndex].Cells[2].Value.ToString()); dvdStatus.setRentStatus("R"); dvdStatus.ChangeRentDVD(); { //Display Confirmation Message MessageBox.Show("Rental is Executed.", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information); } txtSearchName.Text = ""; txtSearchDVDTitle.Text = ""; txtRentId.Text = ""; txtTransactionId.Text = Rentals.nextTransactionId().ToString("0000"); txtRentId.Text = Rentals.nextRentalId().ToString("0000"); }