private void button1_Click(object sender, EventArgs e)
        {
            if (rentID > 0)
            {
                DatabaseModule.Rental obj_Rental = new DatabaseModule.Rental(1, Convert.ToInt32(CustomerID.Text.ToString()), Convert.ToInt32(MovieId.Text.ToString()), MovieIssueDate.Text, MovieReturnDate.Text);
                if (obj_Rental.delMovie(rentID) == 0)
                {
                    MessageBox.Show("Rental Video is Deleted ");
                }
                else
                {
                    MessageBox.Show("Movie is already Booked ");
                }

                MovieId.Text    = "";
                CustomerID.Text = "";
                txtfName.Text   = "";
                txtLName.Text   = "";
                txtAddress.Text = "";
                txtMobile.Text  = "";
                txtName.Text    = "";
                txtScore.Text   = "";
                txtYear.Text    = "";
                txtCost.Text    = "";
                txtCopies.Text  = "";
                rent            = 0;
            }
        }
        private void button7_Click(object sender, EventArgs e)
        {
            if (MovieId.Text.ToString().Equals("") || CustomerID.Text.ToString().Equals(""))
            {
                MessageBox.Show("select the movie or customer first to book any movie ");
            }
            else
            {
                DatabaseModule.Rental obj_rent = new DatabaseModule.Rental(1, Convert.ToInt32(CustomerID.Text.ToString()), Convert.ToInt32(MovieId.Text.ToString()), MovieIssueDate.Text, MovieReturnDate.Text);
                if (obj_rent.issueMovie() == 1)
                {
                    MessageBox.Show("Movie is issued on rent ");
                }
                else
                {
                    MessageBox.Show("Movie is already booked or customer alrady may have 2 cd already on rent ");
                }

                MovieId.Text    = "";
                CustomerID.Text = "";
                txtfName.Text   = "";
                txtLName.Text   = "";
                txtAddress.Text = "";
                txtMobile.Text  = "";

                txtName.Text   = "";
                txtScore.Text  = "";
                txtYear.Text   = "";
                txtCost.Text   = "";
                txtCopies.Text = "";
            }
        }
 private void ShowRental_Click(object sender, EventArgs e)
 {
     DatabaseModule.Rental obj = new DatabaseModule.Rental(1, 1, 1, "MovieIssueDate.Text", "MovieReturnDate.Text");
     obj.Datarecord(Database);
     rent     = 1;
     movie    = 0;
     customer = 0;
 }
        private void btnMovieReturn_Click(object sender, EventArgs e)
        {
            DatabaseModule.Rental obj_rent = new DatabaseModule.Rental(rentID, Convert.ToInt32(CustomerID.Text), Convert.ToInt32(MovieId.Text), MovieIssueDate.Text, MovieReturnDate.Text);

            MessageBox.Show("the charges of the movie is $" + obj_rent.returnMovie(rentID, Convert.ToInt32(MovieId.Text)));

            MovieId.Text    = "";
            CustomerID.Text = "";
            txtfName.Text   = "";
            txtLName.Text   = "";
            txtAddress.Text = "";
            txtMobile.Text  = "";
            txtName.Text    = "";
            txtScore.Text   = "";
            txtYear.Text    = "";
            txtCost.Text    = "";
            txtCopies.Text  = "";
            rent            = 0;
        }