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

{

    /// <summary>

    /// Логика для InfoMaterialsFilterWindow.xaml

    /// </summary>

    public partial class InfoMaterialsFilterWindow

    {

        private InfoMaterialsDataManager _dataManager;

        private CheckEdit _curRatingOrViewCount;

        private CheckEdit _curTopOrLow;

 

        public InfoMaterialsFilterWindow()

        {

            InitializeComponent();

            _curRatingOrViewCount = chkRating;

            _curTopOrLow = chkTop;

        }

 

        public InfoMaterialsFilterWindow(InfoMaterialsDataManager dataManager) : this()

        {

            _dataManager = dataManager;

        }

 

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

        {

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

            if (grdInfoMaterials.IsValidRowHandle(rowHandle))

            {

                var infoMaterial = (InfoMaterial) grdInfoMaterials.GetRow(rowHandle);

                infoMaterial = _dataManager.InfoMaterialRepository.GetInfoMaterial(infoMaterial.ID_InfoMaterial);

                ((List<InfoMaterial>) grdInfoMaterials.DataSource)[grdInfoMaterials.GetRowListIndex(rowHandle)] =

                    infoMaterial;

                ViewMaterial(infoMaterial);

            }

        }

 

        private void btnFilter_Click(object sender, System.Windows.RoutedEventArgs e)

        {

            var filter = new Filter();

            filter.Name = txtName.Text;

            filter.ByRating = chkRating.IsChecked != null ? (bool) chkRating.IsChecked : false;

            filter.ByViewCount = chkViewCount.IsChecked != null ? (bool) chkViewCount.IsChecked : false;

            filter.NumberOfRows = (int) speNumberOfRows.Value;

            filter.DateFrom = dteDateFrom.EditValue != null ? dteDateFrom.DateTime : new DateTime(1900,01,01);

            filter.DateTo = dteDateTo.EditValue != null ? dteDateTo.DateTime : DateTime.Now;

            filter.SortDirection = chkTop.IsChecked == true ? SortDirectionType.Top : SortDirectionType.Low;

           

            grdInfoMaterials.BeginDataUpdate();

            grdInfoMaterials.DataSource = _dataManager.InfoMaterialRepository.GetInfoMaterialsByFilter(filter);

            grdInfoMaterials.EndDataUpdate();

        }

 

        private void RatingAndViewCount_Checked(object sender, System.Windows.RoutedEventArgs e)

        {

            _curRatingOrViewCount = (CheckEdit) sender;

            if (sender.Equals(chkRating))

                chkViewCount.IsChecked = false;

            else

                chkRating.IsChecked = false;

 

        }

 

        private void TopAndLow_Checked(object sender, System.Windows.RoutedEventArgs e)

        {

            _curTopOrLow = (CheckEdit) sender;

            if (sender.Equals(chkTop))

                chkLow.IsChecked = false;

            else

                chkTop.IsChecked = false;

        }

 

        private void RatingAndViewCount_Unchecked(object sender, System.Windows.RoutedEventArgs e)

        {

            var chk = (CheckEdit)sender;

            if (chk.Equals(_curRatingOrViewCount))

                chk.IsChecked = true;

        }

 

        private void TopAndLow_Unchecked(object sender, System.Windows.RoutedEventArgs e)

        {

            var chk = (CheckEdit)sender;

            if (chk.Equals(_curTopOrLow))

                chk.IsChecked = true;

        }

 

        private void ViewMaterial(InfoMaterial infoMaterial)

        {

 

            var imWindow = new InfoMaterialWindow(infoMaterial);

            imWindow.ShowDialog();

            Save();

        }

 

        private void Save()

        {

            _dataManager.InfoMaterialRepository.SaveChanges();

        }

    }

}

InfoMaterialsWindow.xaml

<Window x:Class="WpfRDB.InfoMaterialsWindow"

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

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

   xmlns:dx="clr-namespace:DevExpress.Wpf.Utils.Themes;assembly=DevExpress.Wpf.Core.v9.3" Title="Информационные материалы" Height="494" Width="758" Loaded="Window_Loaded"

   Icon="Images/yinyang.png">

    <Grid dx:ThemeManager.ThemeName="Office2007Blue">

        <Grid.RowDefinitions>

            <RowDefinition Height="24" />

            <RowDefinition Height="2" />

            <RowDefinition Height="369*" />

        </Grid.RowDefinitions>

        <Image Width="16" HorizontalAlignment="Left" Margin="4,4,0,4" Name="image1" Stretch="Fill">

            <Image.Source>pack://application:,,,/Images/information.png</Image.Source>

        </Image>

        <TextBlock HorizontalAlignment="Left" Margin="26,4,0,4" Name="tbHeader" Text="Информационные материалы" Width="160" />

        <dxg:GridControl Grid.Row="2" Name="grdInfoMaterials" xmlns:dxg="http://schemas.devexpress.com/winfx/2008/xaml/grid">