void ConcertHalls()
        {
            List <int>    Id      = new List <int>();
            List <string> Name    = new List <string>();
            List <string> Address = new List <string>();
            List <byte[]> Photo   = new List <byte[]>();

            get.SearchConcertHalls(SearchString.Text, Id, Name, Address, Photo);
            if (Name.Count > 0)
            {
                Border border = new Border();
                border.Height     = 30;
                border.Background = Brushes.WhiteSmoke;

                Label label = new Label();
                label.FontSize = 15;
                label.Content  = "ConcertHalls";

                border.Child = label;

                MainStack.Children.Add(border);
            }
            for (int iterator = 0; iterator < Name.Count; iterator++)
            {
                Grid grid = new Grid();
                grid.Name       = "grid1"; // имя потом брать из названия фильма
                grid.Height     = 150;
                grid.MouseDown += Grid_MouseDownConcertHalls;

                Border border = new Border();
                border.Background      = Brushes.WhiteSmoke;
                border.BorderThickness = new Thickness(1);
                border.Height          = 4;

                MainStack.Children.Add(grid);
                MainStack.Children.Add(border);

                Image image = new Image();
                image.Height              = 120;
                image.Width               = 134;
                image.Margin              = new Thickness(328, 15, 0, 0);
                image.VerticalAlignment   = VerticalAlignment.Top;
                image.HorizontalAlignment = HorizontalAlignment.Left;
                BitmapImage img = new BitmapImage();
                img.BeginInit();
                img.StreamSource = new MemoryStream(Photo[iterator]);
                img.EndInit();
                image.Source = img;
                grid.Children.Add(image);

                Label name = new Label();
                name.Content             = Name[iterator]; // имя взять из бд
                name.Margin              = new Thickness(10, 15, 0, 0);
                name.FontFamily          = new FontFamily("Times New Roman");
                name.FontSize            = 28;
                name.Width               = 288;
                name.FontWeight          = FontWeights.Bold;
                name.VerticalAlignment   = VerticalAlignment.Top;
                name.HorizontalAlignment = HorizontalAlignment.Left;
                grid.Children.Add(name);


                Label address = new Label();
                address.Content             = Address[iterator]; // имя взять из бд
                address.Margin              = new Thickness(10, 65, 0, 0);
                address.FontFamily          = new FontFamily("Times New Roman");
                address.FontSize            = 18;
                address.Width               = 288;
                address.VerticalAlignment   = VerticalAlignment.Top;
                address.HorizontalAlignment = HorizontalAlignment.Left;
                grid.Children.Add(address);
            }
        }