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