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