public virtual List <Project> GetAllProjects()
{
var query = from project in _context.Set <Project>()
select project;
return(query.Include(t => t.ProjectManager).AsNoTracking().ToList());
}
public virtual List <User> GetAllUsers()
{
var query = from user in _context.Set <User>()
where user.IsDeleted == false
select user;
var users = query.Include(t => t.UserProject).Include(t => t.UserTask).AsNoTracking().ToList();
return(users);
}
public virtual List <Task> GetAllTasks()
{
var query = from task in _context.Set <Task>()
select task;
return(query.Include(t => t.Parent).Include(t => t.Project).Include(t => t.User).AsNoTracking().ToList());
}