public static List <Task> select(User requester, int projectId)
{
try
{
nova_ataEntities db = new nova_ataEntities();
var tasks = from t in db.tasks
where t.projectId == projectId
where t.activityOrigin.ToUpper() == "PROJECT"
select t;
List <Task> listOfTasks = new List <Task>();
foreach (var t in tasks)
{
Task task = new Task(t.taskId, t.projectId, t.notifyMe, t.meetingDate, t.product, t.pWork, t.criticalActivity,
t.activityTitle, t.activityDescription, t.parent, t.grandParent, t.responsible, t.start, t.finish,
t.status, CommentDAO.selectLastComment(t.taskId), t.activityOrigin, t.idProjectTask, t.idParentProjectTask,
t.ident, t.hash, t.delayDescription, t.delayDescription, UserDAO.instanceById((int)t.createdBy),
(int)t.reworkCount, t.actualFinishDate, t.newStart, t.newFinish, t.isFreezed, t.wasDeleted,
t.wasInsertedAfterFreezing);
listOfTasks.Add(task);
}
return(listOfTasks);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
