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

        {

            _entities.DeleteObject(category);

        }

 

        public void SaveChanges()

        {

            _entities.SaveChanges();

        }

    }

}

InfoMaterial.cs

using System.Windows.Media.Imaging;

using ASDC.Model.Classes;

 

namespace ASDC.Model.InfoMaterials

{

    public partial class InfoMaterial

    {

        private BitmapImage _bitmapSource;

        public BitmapImage BitmapSource

        {

            get { return _bitmapSource; }

            set

            {

                _bitmapSource = value;

                Image.Image = Convertor.BitmapSourceToBytes(_bitmapSource);

            }

        }

    }

}

InfoMaterialRepository.cs

using System.Collections.Generic;

using System.Linq;

using ASDC.Model.Classes;

 

namespace ASDC.Model.InfoMaterials

{

    public class InfoMaterialRepository

    {

        private ASDCEntities _entities;

 

        public InfoMaterialRepository(ASDCEntities entities)

        {

            _entities = entities;

        }

 

        public List<InfoMaterial> GetInfoMaterialsByFilter(Filter filter)

        {

            var infoMaterials = from im in _entities.InfoMaterials.Include("Image")

                                 where (im.PublishDate >= filter.DateFrom && im.PublishDate <= filter.DateTo)

                                 select im;

            if (filter.NumberOfRows <= 0)

                filter.NumberOfRows = int.MaxValue;

 

            if (!string.IsNullOrEmpty(filter.Name))

                infoMaterials = infoMaterials.Where(im => im.Name.Contains(filter.Name)).Take(filter.NumberOfRows);

 

            if (filter.ByRating)

            {

                if (filter.SortDirection == SortDirectionType.Top)

                    infoMaterials = infoMaterials.OrderByDescending(im => im.Rating).Take(filter.NumberOfRows);

                else

                    infoMaterials = infoMaterials.OrderBy(im => im.Rating).Take(filter.NumberOfRows);

            }

         

            if (filter.ByViewCount)

                if (filter.SortDirection == SortDirectionType.Top)

                    infoMaterials = infoMaterials.OrderByDescending(im => im.ViewCount).Take(filter.NumberOfRows);

                else

                    infoMaterials = infoMaterials.OrderBy(im => im.ViewCount).Take(filter.NumberOfRows);

           

            return ConvertInfoMaterialImageToBitmapSource(infoMaterials.ToList());

        }

 

        public List<InfoMaterial> GetShortInfoMaterialsByCategory(long categoryId)

        {

            var infoMaterials = (from im in _entities.InfoMaterials.Include("Image").Include("Comments")

                                 where im.Category.ID_Category == categoryId

                                 select im).ToList();

           

            return ConvertInfoMaterialImageToBitmapSource(infoMaterials);

        }

 

        private List<InfoMaterial> ConvertInfoMaterialImageToBitmapSource(List<InfoMaterial> infoMaterials)

        {

            foreach (var infoMaterial in infoMaterials)

            {

                if (infoMaterial.Image != null)

                    infoMaterial.BitmapSource = Convertor.ByteToBitmapSource(infoMaterial.Image.Image);

            }

            return infoMaterials;

        }

 

        public InfoMaterial GetInfoMaterial(long materialId)

        {

            var infoMaterial =  (from im in _entities.InfoMaterials.Include("Image").Include("Comments")

                                where im.ID_InfoMaterial == materialId

                                select im).First();

            if (infoMaterial.Image != null)

                infoMaterial.BitmapSource = Convertor.ByteToBitmapSource(infoMaterial.Image.Image);

            return infoMaterial;

        }

 

        public InfoMaterial InsertInfoMaterial(InfoMaterial material)

        {

            _entities.AddToInfoMaterials(material);

            if (material.Image != null)

                _entities.AddToInfoMat_Image(material.Image);

            return material;

        }

 

        public InfoMaterial InsertComments(InfoMaterial material)

        {

            foreach (var comment in material.Comments.ToList())

            {

                _entities.AddToComments(comment);

            }

 

            return material;

        }

 

        public void DeleteInfoMaterial(InfoMaterial material)

        {

            _entities.DeleteObject(material);

        }

 

        public void SaveChanges()

        {

            _entities.SaveChanges();

        }

    }

InfoMaterialsDataManager.cs

namespace ASDC.Model.InfoMaterials

{

    public class InfoMaterialsDataManager

    {

        private ASDCEntities _entities;

        private CategoryRepository _categoryRepository;

        private InfoMaterialRepository _infoMaterialRepository;

 

        public InfoMaterialsDataManager()

        {

            _entities = new ASDCEntities();

        }

 

        public CategoryRepository CategoryRepository

        {

            get

            {

                if (_categoryRepository == null)