private void DeleteMovie_Click(object sender, EventArgs e) { try { if (MovieId.Text.ToString().Equals("")) { MessageBox.Show("Select the Movie First to delete "); } else { DatabaseModule.Movie obj_Movie = new DatabaseModule.Movie(1, txtName.Text.ToString(), txtScore.Text.ToString(), Convert.ToInt32(txtYear.Text.ToString()), Convert.ToInt32(txtCost.Text.ToString()), Convert.ToInt32(txtCopies.Text.ToString())); if (obj_Movie.srchMovieData(Convert.ToInt32(MovieId.Text.ToString())) == 0) { obj_Movie.delMovie(Convert.ToInt32(MovieId.Text.ToString())); MessageBox.Show("Movie Record is deleted from the Database "); } else { MessageBox.Show("Movie is already booked "); } txtName.Text = ""; txtScore.Text = ""; txtYear.Text = ""; txtCost.Text = ""; txtCopies.Text = ""; MovieId.Text = ""; } } catch (Exception ex) { MessageBox.Show("error " + ex.Message); } }
private void ShowVideo_Click(object sender, EventArgs e) { DatabaseModule.Movie obj = new DatabaseModule.Movie(1, "txtName.Text.ToString()", "txtScore.Text.ToString()", 2019, 5, 5); obj.Datarecord(Database); movie = 1; rent = 0; customer = 0; }
private void UpdateMovie_Click(object sender, EventArgs e) { if (txtName.Text.ToString().Equals("") || txtScore.Text.ToString().Equals("") || MovieId.Text.ToString().Equals("") || txtYear.Text.ToString().Equals("") || txtCopies.Text.ToString().Equals("")) { MessageBox.Show("Fill all the details of the Movie POrtal to keep it up to Date "); } else { DatabaseModule.Movie obj_Movie = new DatabaseModule.Movie(1, txtName.Text.ToString(), txtScore.Text.ToString(), Convert.ToInt32(txtYear.Text.ToString()), Convert.ToInt32(txtCost.Text.ToString()), Convert.ToInt32(txtCopies.Text.ToString())); obj_Movie.updateMovie(Convert.ToInt32(MovieId.Text.ToString())); MessageBox.Show("Movie Record is Updated in the Database Table "); txtName.Text = ""; txtScore.Text = ""; txtYear.Text = ""; txtCost.Text = ""; txtCopies.Text = ""; MovieId.Text = ""; } }
private void AddMovie_Click(object sender, EventArgs e) { if (txtName.Text.ToString().Equals("") || txtScore.Text.ToString().Equals("") || txtYear.Text.ToString().Equals("") || txtCopies.Text.ToString().Equals("")) { MessageBox.Show("Fill all the details of the Movie POrtal to keep it up to Date "); } else { try { //dislay the cost of the price of the video after adding the year of the video DateTime dateNow = DateTime.Now; int Currentyear = dateNow.Year; int diffYear = Currentyear - Convert.ToInt32(txtYear.Text.ToString()); // MessageBox.Show(diff.ToString()); if (diffYear >= 5) { txtCost.Text = "2"; } if (diffYear >= 0 && diffYear < 5) { txtCost.Text = "5"; } } catch (Exception ex) { } DatabaseModule.Movie obj_Movie = new DatabaseModule.Movie(1, txtName.Text.ToString(), txtScore.Text.ToString(), Convert.ToInt32(txtYear.Text.ToString()), Convert.ToInt32(txtCost.Text.ToString()), Convert.ToInt32(txtCopies.Text.ToString())); obj_Movie.addMovie(); MessageBox.Show("Movie Record is saved in the Database Table and the Movie Rental Cost is ==$" + txtCost.Text); txtName.Text = ""; txtScore.Text = ""; txtYear.Text = ""; txtCost.Text = ""; txtCopies.Text = ""; } }
private void btnMostMovie_Click(object sender, EventArgs e) { DatabaseModule.Movie obj_Movie = new DatabaseModule.Movie(1, " txtName.Text.ToString()", " txtScore.Text.ToString()", 2019, 5, 5); MessageBox.Show("" + obj_Movie.mostMovie()); }