Проектирование базы данных

                ms.Seek(0, SeekOrigin.Begin);

                bitmap.StreamSource = ms;

                bitmap.EndInit();

 

                var c = (Category) grdCategories.GetFocusedRow();

                c.BitmapSource = bitmap;

                grdCategories.RefreshData();

                _needForSave = true;

            }

        }

 

        private void btnSave_Click(object sender, RoutedEventArgs e)

        {

            Save();

        }

 

        private void btnDelete_Click(object sender, RoutedEventArgs e)

        {

            if (grdCategories.View.SelectedRows.Count > 0)

            {

                if (MessageBox.Show("Вы действительно хотите удалить выбранную категорию?", "Сообщение",

                                    MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)

                {

                    grdCategories.BeginDataUpdate();

 

                    var c = (Category) grdCategories.GetFocusedRow();

                    _dataManager.CategoryRepository.DeleteCategory(c);

                    ((List<Category>) (grdCategories.DataSource)).Remove(c);

                    _needForSave = true;

 

                    grdCategories.EndDataUpdate();

                }

            }

        }

 

        private void view_MouseDoubleClick(object sender, System.Windows.Input.MouseButtonEventArgs e)

        {

            int rowHandle = grdCategories.View.GetRowHandleByMouseEventArgs(e);

            if (grdCategories.IsValidRowHandle(rowHandle))

            {

                if (AskForSave())

                    Save();

 

                var c = (Category) grdCategories.GetFocusedRow();

 

                if (c.Children != null)

                {

                    _currentParentCategory = c;

                    _prevDataSource = grdCategories.DataSource;

                    grdCategories.DataSource = c.Children;

                    grdCategories.RefreshData();

                }

                else

                {

                    var infoMaterialsWindow = new InfoMaterialsWindow(_dataManager, c);

                    infoMaterialsWindow.Show();

                }

            }

        }

 

        private void Save()

        {

            if (_needForSave)

            {

                _dataManager.CategoryRepository.SaveChanges();

                _needForSave = false;

            }

        }

 

        private bool AskForSave()

        {

            if (_needForSave)

            {

                if (MessageBox.Show("Сохранить сделанные изменения?","Сообщение", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK)

                {

                    return true;

                }

            }

            return false;

        }

 

        private void btnPrev_Click(object sender, RoutedEventArgs e)

        {

            if (_prevDataSource != null)

                grdCategories.DataSource = _prevDataSource;

        }

 

        private void view_FocusedRowChanged(object sender, DevExpress.Wpf.Grid.FocusedRowChangedEventArgs e)

        {

            _focusedRowChanged = true;

        }

 

        private void TextBox_EditValueChanged(object sender, DevExpress.Wpf.Editors.EditValueChangedEventArgs e)

        {

            if (!_focusedRowChanged)

                _needForSave = true;

        }

 

        private void Window_Closing(object sender, System.ComponentModel.CancelEventArgs e)

        {

            if (AskForSave())

                Save();

        }

 

        private void TextBox_GotFocus(object sender, RoutedEventArgs e)

        {

            _focusedRowChanged = false;

        }

    }

       }

InfoMaterialAddEditWindow.xaml

<Window x:Class="WpfRDB.InfoMaterialAddEditWindow"

   xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

   xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

   xmlns:dxe="clr-namespace:DevExpress.Wpf.Editors;assembly=DevExpress.Wpf.Editors.v9.3"

   xmlns:dx="clr-namespace:DevExpress.Wpf.Utils.Themes;assembly=DevExpress.Wpf.Core.v9.3"

   Title="InfoMaterial" Height="692" Width="721" Loaded="Window_Loaded" Icon="Images/yinyang.png">

    <Grid dx:ThemeManager.ThemeName="Office2007Blue" x:Name="grBase">

        <Grid.ColumnDefinitions>

            <ColumnDefinition Width="4" />

            <ColumnDefinition/>

            <ColumnDefinition Width="4"/>

        </Grid.ColumnDefinitions>

        <Grid.RowDefinitions>

            <RowDefinition Height="24" />

            <RowDefinition Height="7" />

            <RowDefinition Height="128" />

            <RowDefinition Height="4" />

            <RowDefinition Height="16" />