public IQueryable GetProjects()
        {
            var        _db   = new INSTaskTracker.Models.ApplicationDbContext();
            IQueryable query = _db.Projects;

            return(query);
        }
        public IQueryable <Models.Assignment> GetAssignment([QueryString("assignmentID")] Guid?assignmentId)
        {
            var _db = new INSTaskTracker.Models.ApplicationDbContext();
            IQueryable <Models.Assignment> query = _db.Assignments;

            if (assignmentId.HasValue)
            {
                query = query.Where(p => p.AssignmentID == assignmentId);
            }
            else
            {
                query = null;
            }
            return(query);
        }
        public IQueryable <Models.Project> GetProject([QueryString("projectID")] Guid?projectId)
        {
            var _db = new INSTaskTracker.Models.ApplicationDbContext();
            IQueryable <Models.Project> query = _db.Projects;

            if (projectId.HasValue)
            {
                query = query.Where(p => p.ProjectID == projectId);
            }
            else
            {
                query = null;
            }
            return(query);
        }