private void MICSave_Click(object sender, RoutedEventArgs e)
 {
     try
     {
         MICClass mic = MICBdFrid.SelectedItem as MICClass;
         bdClassUpdate.UpdateMIC(mic.Id, (DateTime)MICDate.SelectedDate, FilmIdName.SelectedItem.ToString(), CinemaIdName.SelectedItem.ToString(), Int32.Parse(MICPrice.Text), MICTime.Text, Int32.Parse(MICFreeSpaces.Text), Int32.Parse(MICReservedSpaces.Text));
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
     finally
     {
         refreshMICBdGrid();
     }
 }
        private void MICDelete_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (MICBdFrid.SelectedItem != null)
                {
                    MICClass mic = MICBdFrid.SelectedItem as MICClass;

                    bdClassDelete.DeleteRowTable(mic.Id, "MIC");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                refreshMICBdGrid();
            }
        }
        private void MICBdFrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            try
            {
                if (MICBdFrid.SelectedItem != null)
                {
                    MICClass mic = MICBdFrid.SelectedItem as MICClass;

                    MICDate.SelectedDate = mic.Date;
                    int indexFilm = FilmIdName.Items.IndexOf(mic.FilmName);
                    FilmIdName.SelectedItem = FilmIdName.Items.GetItemAt(indexFilm);
                    int indexCinema = CinemaIdName.Items.IndexOf(mic.CinemaName);
                    CinemaIdName.SelectedItem = CinemaIdName.Items.GetItemAt(indexCinema);
                    MICPrice.Text             = mic.Price.ToString();
                    MICTime.Text           = mic.Time;
                    MICFreeSpaces.Text     = mic.FreeSpaces.ToString();
                    MICReservedSpaces.Text = mic.FreeSpaces.ToString();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }