Data.ProjectsDBManager.GetProjects C# (CSharp) Method

GetProjects() public static method

public static GetProjects ( int page, int pageSize, bool asc, string sortExpression, int &itemsCount ) : IEnumerable
page int
pageSize int
asc bool
sortExpression string
itemsCount int
return IEnumerable
        public static IEnumerable<Project> GetProjects(int page, int pageSize, bool asc, string sortExpression, out int itemsCount)
        {
            DataClassesBugTrackingSystemDataContext db = new DataClassesBugTrackingSystemDataContext();

            int items;
            if(sortExpression == "SortNumber")
            {
                 var projects = db.Projects.Page(page, pageSize, p => p.ProjectId, asc, out items);
                 itemsCount = items;
                 return projects;
            }
            else if (sortExpression == "SortName")
            {
                var projects = db.Projects.Page(page, pageSize, p => p.Name, asc, out items);
                itemsCount = items;
                return projects;
            }
            else if (sortExpression == "SortDescription")
            {
                var projects = db.Projects.Page(page, pageSize, p => p.Description, asc, out items);
                itemsCount = items;
                return projects;
            }
            else
            {
                itemsCount = 0;
                return null;
            }
        }