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;
}
}