private void CocnertsSave_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                string pathDescription = "../../Description/" + FilmsName.Text + "C" + ".txt";
                File.WriteAllText(pathDescription, ConcertsDescription.Text);
                ConcertsClass concertsClass = ConcertsBdGrid.SelectedItem as ConcertsClass;
                byte[]        imagecode     = null;
                if (imageByte == null)
                {
                    ImageToBD(ref imagecode);
                }
                else
                {
                    imagecode = imageByte;
                }

                bdClassUpdate.UpdateConcerts(concertsClass.Id, ConcertsName.Text, pathDescription, ConcertsTime.Text, imagecode, ConcertsGenre.Text);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                refreshConcertsBdGrid();
            }
        }
        ///////////////////////////////////Concerts event //////////////////////////////////////////////
        private void ConcertsBdGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            try
            {
                if (ConcertsBdGrid.SelectedItem != null)
                {
                    ConcertsClass concertsClass = ConcertsBdGrid.SelectedItem as ConcertsClass;

                    ConcertsName.Text        = concertsClass.Name;
                    ConcertsGenre.Text       = concertsClass.Genre;
                    ConcertsTime.Text        = concertsClass.Time;
                    ConcertsDescription.Text = File.ReadAllText(concertsClass.Description);
                    imageByte = concertsClass.Photo;

                    BitmapImage image = new BitmapImage();
                    image.BeginInit();
                    image.StreamSource = new MemoryStream(concertsClass.Photo);
                    image.EndInit();

                    ConcertsImage.Source = image;
                }
            }
            catch (Exception ex)
            {
                // MessageBox.Show(ex.Message);
            }
        }
        private void ConcertsDelete_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (ConcertsBdGrid.SelectedItem != null)
                {
                    ConcertsClass concerts = ConcertsBdGrid.SelectedItem as ConcertsClass;

                    bdClassDelete.DeleteRowTable(concerts.Id, "Concerts");
                    string pathDescription = "../../Description/" + concerts.Name + "C" + ".txt";
                    File.Delete(pathDescription);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                refreshConcertsBdGrid();
            }
        }