private void button2_Click(object sender, EventArgs e)
        {
            task         = 3;
            BookingVideo = new BookingVideo(1, 1, 1, "ok", "Book");
            DataTable tbl = new DataTable();

            tbl = BookingVideo.CmdRecord("select * from CustomerPannel");
            ViewData.DataSource = tbl;
        }
        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    = "";
        }
 // video Delete
 private void btnRentalDelete_Click(object sender, EventArgs e)
 {
     BookingVideo = new BookingVideo(BookID, Convert.ToInt32(txtMovieID.Text), Convert.ToInt32(txtCustomerID.Text), dtpIssue.Text, "Book");
     BookingVideo.DeleteBookVideo();
     MessageBox.Show("Video is issed on rent ");
     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    = "";
 }
        private void rental_Click(object sender, EventArgs e)
        {
            task         = 1;
            BookingVideo = new BookingVideo(1, 1, 1, "ok", "Book");
            DataTable tbl = new DataTable();

            tbl = BookingVideo.CmdRecord("select * from BookingPannel");
            ViewData.DataSource = tbl;

            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    = "";
        }
        private void button4_Click(object sender, EventArgs e)
        {
            //compare the booking and fetch the most viewed movie
            DataTable    tblData = new DataTable();
            BookingVideo booking = new BookingVideo(1, 1, 1, "1", "1");

            tblData = booking.CmdRecord("select * from VideoPannel");
            int    x = 0, y = 0, c**t = 0;
            String Title = "";

            for (x = 0; x < tblData.Rows.Count; x++)
            {
                DataTable tblData1 = new DataTable();
                tblData1 = booking.CmdRecord("select * from BookingPannel where MovieID='" + tblData.Rows[x]["VideoID"].ToString() + "'");

                if (tblData1.Rows.Count > c**t)
                {
                    Title = tblData.Rows[x]["Name"].ToString();
                    c**t  = tblData1.Rows.Count;
                }
            }

            MessageBox.Show("Best Video is " + Title);
        }