private void CocnertHallsSave_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                ConcertHallsClass concertHalls = ConcertHallsBdGrid.SelectedItem as ConcertHallsClass;
                byte[]            imagecode    = null;
                if (imageByte == null)
                {
                    ImageToBD(ref imagecode);
                }
                else
                {
                    imagecode = imageByte;
                }

                bdClassUpdate.UpdateConcertHalls(concertHalls.Id, ConcertHallsName.Text, ConcertHallsAddress.Text, imagecode);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                refreshConcertHallsBdGrid();
            }
        }
        /////////////////////////////////////////ConcertHalls event//////////////////////////////////
        private void ConcertHallsBdGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            try
            {
                if (ConcertHallsBdGrid.SelectedItem != null)
                {
                    ConcertHallsClass concertHalls = ConcertHallsBdGrid.SelectedItem as ConcertHallsClass;

                    ConcertHallsName.Text    = concertHalls.Name;
                    ConcertHallsAddress.Text = concertHalls.Address;
                    imageByte = concertHalls.Photo;

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

                    ConcertHallsImage.Source = image;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void ConcertHallsDelete_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (ConcertHallsBdGrid.SelectedItem != null)
                {
                    ConcertHallsClass concertHalls = ConcertHallsBdGrid.SelectedItem as ConcertHallsClass;

                    bdClassDelete.DeleteRowTable(concertHalls.Id, "ConcertHalls");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                refreshConcertHallsBdGrid();
            }
        }