public IQueryable <project> GetProjects([QueryString("id")] int?projectId) { var _db = new LewishamProjectSite.ProjectContext(); IQueryable <project> query = _db.projects; if (projectId.HasValue && projectId > 0) { query = query.Where(p => p.projectId == projectId); } return(query); }
public IQueryable <employee> GetEmployees([QueryString("id")] int?employeeId) { var _db = new LewishamProjectSite.ProjectContext(); IQueryable <employee> query = _db.employees; if (employeeId.HasValue && employeeId > 0) { query = query.Where(em => em.employeeId == employeeId); } return(query); }
public IQueryable <project> GetProject( [QueryString("projectId")] int?projectID, [RouteData] string project1) { var _db = new LewishamProjectSite.ProjectContext(); IQueryable <project> query = _db.projects; if (projectID.HasValue && projectID > 0) { query = query.Where(p => p.projectId == projectID); } else if (!String.IsNullOrEmpty(project1)) { query = query.Where(p => String.Compare(p.project1, project1) == 0); } else { query = null; } return(query); }
public IQueryable <employee> GetEmployee( [QueryString("employeeId")] int?employeeId, [RouteData] string firstname) { var _db = new LewishamProjectSite.ProjectContext(); IQueryable <employee> query = _db.employees; if (employeeId.HasValue && employeeId > 0) { query = query.Where(em => em.employeeId == employeeId); } else if (!String.IsNullOrEmpty(firstname)) { query = query.Where(em => String.Compare(em.firstname, firstname) == 0); } else { query = null; } return(query); }