private void btnReturn_Click(object sender, EventArgs e)
        {
            BookingVideo = new BookingVideo(BookID, Convert.ToInt32(txtMovieID.Text), Convert.ToInt32(txtCustomerID.Text), dtpIssue.Text, "Book");


            // movie Cost
            DataTable tbl = new DataTable();

            tbl = new DataTable();
            tbl = BookingVideo.CmdRecord("select * from VideoPannel where VideoID=" + Convert.ToInt32(txtMovieID.Text) + "");
            int Cost = Convert.ToInt32(tbl.Rows[0]["Price"].ToString());



            DateTime current_date = DateTime.Now;

            //date converersion
            DateTime prev_date = Convert.ToDateTime(dtpIssue.Text);


            String Daysdiff = (current_date - prev_date).TotalDays.ToString();


            //date calculater
            Double DaysInterval = Math.Round(Convert.ToDouble(Daysdiff));


            int Bill = Cost * Convert.ToInt32(DaysInterval);



            BookingVideo.ReturnVideo();
            MessageBox.Show("Thanks for the using you need to pay $" + Bill);
            txtMovieID.Text    = "";
            vd_Name.Text       = "";
            vd_Plot.Text       = "";
            Vd_Genre.Text      = "";
            Vd_Year.Text       = "";
            Vd_Copies.Text     = "";
            Vd_Price.Text      = "";
            txtCustomerID.Text = "";
            txtName.Text       = "";
            txtPhone.Text      = "";
            txtAddress.Text    = "";
            txtCountry.Text    = "";
        }