private void ESave_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                string pathDescription = "../../Description/" + FilmsName.Text + "E" + ".txt";
                File.WriteAllText(pathDescription, EDescription.Text);
                ExhibitionsClass exhibitionsClass = EBdGrid.SelectedItem as ExhibitionsClass;
                byte[]           imagecode        = null;
                if (imageByte == null)
                {
                    ImageToBD(ref imagecode);
                }
                else
                {
                    imagecode = imageByte;
                }

                bdClassUpdate.UpdateExhibitions(exhibitionsClass.Id, EName.Text, pathDescription, ETime.Text, imagecode, EGenre.Text);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                refreshExhibitionsBdGrid();
            }
        }
        private void EBdGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            try
            {
                if (EBdGrid.SelectedItem != null)
                {
                    ExhibitionsClass exhibitionsClass = EBdGrid.SelectedItem as ExhibitionsClass;

                    EName.Text        = exhibitionsClass.Name;
                    EGenre.Text       = exhibitionsClass.Genre;
                    ETime.Text        = exhibitionsClass.Time;
                    EDescription.Text = File.ReadAllText(exhibitionsClass.Description);
                    imageByte         = exhibitionsClass.Photo;

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

                    EImage.Source = image;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void EDelete_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (EBdGrid.SelectedItem != null)
                {
                    ExhibitionsClass exhibitionsClass = EBdGrid.SelectedItem as ExhibitionsClass;

                    bdClassDelete.DeleteRowTable(exhibitionsClass.Id, "Exhibitions");
                    string pathDescription = "../../Description/" + exhibitionsClass.Name + "E" + ".txt";
                    File.Delete(pathDescription);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                refreshExhibitionsBdGrid();
            }
        }