private void FilmsBdFrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            try
            {
                if (FilmsBdFrid.SelectedItem != null)
                {
                    FilmsClass film = FilmsBdFrid.SelectedItem as FilmsClass;

                    FilmsName.Text        = film.Name;
                    FilmsGenre.Text       = film.Genre;
                    FilmsCountry.Text     = film.Country;
                    FilmsDuration.Text    = film.Duration;
                    FilmsDescription.Text = File.ReadAllText(film.DescriptionAndActors);
                    imageByte             = film.Photo;

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

                    FilmsImage.Source = image;
                }
            }
            catch
            {
                Console.WriteLine(e.ToString());
            }
        }
        private void FilmsSave_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                string pathDescription = "../../Description/" + FilmsName.Text + ".txt";
                File.WriteAllText(pathDescription, FilmsDescription.Text);
                FilmsClass film      = FilmsBdFrid.SelectedItem as FilmsClass;
                byte[]     imagecode = null;
                if (imageByte == null)
                {
                    ImageToBD(ref imagecode);
                }
                else
                {
                    imagecode = imageByte;
                }

                bdClassUpdate.UpdateFilm(film.Id, FilmsName.Text, pathDescription, imagecode, FilmsGenre.Text, FilmsCountry.Text, FilmsDuration.Text);
                refreshFilmsBdGrid();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void FilmsDelete_Click(object sender, RoutedEventArgs e)
        {
            if (FilmsBdFrid.SelectedItem != null)
            {
                FilmsClass film = FilmsBdFrid.SelectedItem as FilmsClass;

                bdClassDelete.DeleteRowTable(film.Id, "Films");
                string pathDescription = "../../Description/" + film.Name + ".txt";
                File.Delete(pathDescription);
                refreshFilmsBdGrid();
            }
        }