/DDB/Areas/Administration/Models/Helper/ProjectHelper.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Core;
using DB;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Data.Linq;

namespace DDB.Areas.Administration.Models.Helper
{
    public class ProjectHelper : Project
    {
        public ProjectHelper()
        {

        }

        [Required(ErrorMessage = "Summary  is required")]
        public string Summary { get; set; }

        [Required(ErrorMessage = "Credits  is required")]
        public string Credits { get; set; }

        [Required(ErrorMessage = "Short Description is required")]
        public string SmallText { get; set; }

        /// <summary>
        /// Get Projects List
        /// </summary>
        /// <param name="Published">true - published; false - not published; null both</param>
        public List<ProjectHelper> ListProjects()
        {
            return TryToGetList<ProjectHelper>(string.Format("Core.ProjectHelper.ListProjects"), () =>
            {
                using (var db = ConnectionFactory.GetDBCoreDataContext())
                {
                    return db.List_Pojects(null).OrderBy(pro => pro.SortIndex).Select(pro => new ProjectHelper()
                    {
                        ID = pro.ProjectID 
                        //,CategoryID = pro.ProjectCategoryID                      
                        ,Title = pro.Title
                        ,Slug = pro.Slug
                        ,Summary = pro.Summary 
                        ,Credits = pro.Credits
                        ,SmallText = pro.SmallText
                    }).ToList();
                }
            });

        }        
    }
}