private void DeleteSchedule_Load(object sender, EventArgs e)
        {
            int rowindex = parent.dgvSchedule.CurrentCell.RowIndex;

            lblRoom.Text  = parent.dgvSchedule.Rows[rowindex].Cells[0].Value.ToString();
            lblTime.Text  = parent.dgvSchedule.Rows[rowindex].Cells[1].Value.ToString();
            lblMovie.Text = parent.dgvSchedule.Rows[rowindex].Cells[2].Value.ToString();
            lblDate.Text  = Convert.ToDateTime(parent.dgvSchedule.Rows[rowindex].Cells[3].Value.ToString()).ToString("yyyy-MM-dd");
            lblSeat.Text  = parent.dgvSchedule.Rows[rowindex].Cells[4].Value.ToString();

            roomID = sbus.GetRoomID(lblRoom.Text);
            hourID = sbus.GetHourID(lblTime.Text);
            date   = lblDate.Text;
        }
        private void UpdateSchedule_Load(object sender, EventArgs e)
        {
            try
            {
                cmbMovie.DisplayMember = "title";
                cmbMovie.ValueMember   = "movieID";
                cmbMovie.DataSource    = sbus.GetAllMovies();

                cmbHours.DisplayMember = "time";
                cmbHours.ValueMember   = "hourID";
                cmbHours.DataSource    = sbus.GetAllHours();

                cmbRoom.DisplayMember = "name";
                cmbRoom.ValueMember   = "roomID";
                cmbRoom.DataSource    = sbus.GetAllRooms();


                int rowindex = parent.dgvSchedule.CurrentCell.RowIndex;
                roomDK = sbus.GetRoomID(parent.dgvSchedule.Rows[rowindex].Cells[0].Value.ToString());
                hourDK = sbus.GetHourID(parent.dgvSchedule.Rows[rowindex].Cells[1].Value.ToString());
                int movieID = sbus.GetMovieID(parent.dgvSchedule.Rows[rowindex].Cells[2].Value.ToString());
                dateDK = parent.dgvSchedule.Rows[rowindex].Cells[3].Value.ToString();
                string leftSeat = parent.dgvSchedule.Rows[rowindex].Cells[4].Value.ToString();

                cmbRoom.SelectedValue  = roomDK;
                cmbHours.SelectedValue = hourDK;
                cmbMovie.SelectedValue = movieID;
                txtDate.Text           = dateDK;
                txtSeat.Text           = leftSeat;
                DateTime example = Convert.ToDateTime(dateDK);
                monthCalendar1.SetDate(example);
                dateDK = monthCalendar1.SelectionRange.Start.ToShortDateString();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }