private void ECSave_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                ExhibitionCentersClass exhibitionCentersClass = ECBdGrid.SelectedItem as ExhibitionCentersClass;
                byte[] imagecode = null;
                if (imageByte == null)
                {
                    ImageToBD(ref imagecode);
                }
                else
                {
                    imagecode = imageByte;
                }

                bdClassUpdate.UpdateExhibitionCenters(exhibitionCentersClass.Id, ECName.Text, ECAddress.Text, imagecode);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                refreshExhibitionCentersBdGrid();
            }
        }
        private void ECBdGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            try
            {
                if (ECBdGrid.SelectedItem != null)
                {
                    ExhibitionCentersClass exhibitionCentersClass = ECBdGrid.SelectedItem as ExhibitionCentersClass;

                    ECName.Text    = exhibitionCentersClass.Name;
                    ECAddress.Text = exhibitionCentersClass.Address;
                    imageByte      = exhibitionCentersClass.Photo;

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

                    ECImage.Source = image;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
        private void ECDelete_Click(object sender, RoutedEventArgs e)
        {
            try
            {
                if (ECBdGrid.SelectedItem != null)
                {
                    ExhibitionCentersClass exhibitionCentersClass = ECBdGrid.SelectedItem as ExhibitionCentersClass;

                    bdClassDelete.DeleteRowTable(exhibitionCentersClass.Id, "ExhibitionCenters");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                refreshExhibitionCentersBdGrid();
            }
        }