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

        private void btnAddComment_Click(object sender, RoutedEventArgs e)

        {

            var comment = new Comment {Text = txtComment.Text, AddingDate = DateTime.Now};

            ((ICollection<Comment>) grdComments.DataSource).Add(comment);

            _infoMaterial.Comments.Add(comment);

        }

 

        private void btnOK_Click(object sender, RoutedEventArgs e)

        {

            Close();

        }

 

        private void btnDelete_Click(object sender, RoutedEventArgs e)

        {

            grdComments.BeginDataUpdate();

            var comment = (Comment) grdComments.GetFocusedRow();

            ((ICollection<Comment>) grdComments.DataSource).Remove(comment);

            grdComments.EndDataUpdate();

        }

    }

}

Convertor.cs

using System.Drawing;

using System.IO;

using System.Windows.Media.Imaging;

 

namespace ASDC.Model.Classes

{

    public static class Convertor

    {

        public static byte[] ImageToByte(Image img)

        {

            var converter = new ImageConverter();

            return img != null ? (byte[])converter.ConvertTo(img, typeof(byte[])) : null;

        }

 

        public static Image ByteToImage(byte[] bytes)

        {

            var converter = new ImageConverter();

            return bytes != null ? (Image)converter.ConvertFrom(bytes) : null;

        }

 

        public static BitmapImage ByteToBitmapSource(byte[] bytes)

        {

            var img = ByteToImage(bytes);

            return ImageToBitmapSource(img);

        }

 

        public static BitmapImage ImageToBitmapSource(Image img)

        {

            if (img == null)

                return null;

 

            var bi = new BitmapImage();

            var ms = new MemoryStream();

 

            bi.BeginInit();

            img.Save(ms, System.Drawing.Imaging.ImageFormat.Png);

            ms.Seek(0, SeekOrigin.Begin);

            bi.StreamSource = ms;

            bi.EndInit();

 

            return bi;

        }

 

        public static Image BitmapSourceToImage(BitmapImage bs)

        {

            if ((bs == null) || (bs.StreamSource == null))

                return null;

 

            return new Bitmap(bs.StreamSource);

        }

 

        public static byte[] BitmapSourceToBytes(BitmapImage bs)

        {

            var bitmap = (Bitmap)BitmapSourceToImage(bs);

            return ImageToByte(bitmap);

        }

    }

}

Filter.cs

using System;

 

namespace ASDC.Model.Classes

{

    public enum SortDirectionType

    {

        Top = 0,

        Low = 1

    }   

   

    public class Filter

    {

        private string _name;

        private bool _byRating;

        private bool _byViewCount;

        private int _numberOfRows;

        private DateTime _dateFrom;

        private DateTime _dateTo;

        private SortDirectionType _sortDirection;

 

        public string Name

        {

            get { return _name; }

            set { _name = value; }

        }

 

        public bool ByRating

        {

            get { return _byRating; }

            set { _byRating = value; }

        }

 

        public bool ByViewCount

        {

            get { return _byViewCount; }

            set { _byViewCount = value; }

        }

 

        public int NumberOfRows

        {

            get { return _numberOfRows; }

            set { _numberOfRows = value; }

        }

 

        public DateTime DateFrom

        {

            get { return _dateFrom; }

            set { _dateFrom = value; }

        }

 

        public DateTime DateTo

        {

            get { return _dateTo; }

            set { _dateTo = value; }

        }

 

        public SortDirectionType SortDirection