public TaskAssignmentCollection FetchAll() { TaskAssignmentCollection coll = new TaskAssignmentCollection(); Query qry = new Query(TaskAssignment.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
/// <summary> /// Gets the assigned tasks. /// </summary> /// <returns></returns> public Collection <Task> GetAssigned() { Collection <Task> collection = new Collection <Task>(); TaskAssignmentCollection dalAssignments = _taskAssignmentController.FetchAll(); #warning //TODO: optimize foreach (TaskAssignment taskAssignment in dalAssignments) { collection.Add(CreateRecord(taskAssignment.Task)); } return(collection); }
public Collection <Task> GetByUser(int devID) { Query query = TaskAssignment.CreateQuery().AddWhere(TaskAssignment.Columns.UserID, Comparison.Equals, devID); TaskAssignmentCollection assignmentCollection = _taskAssignmentController.FetchByQuery(query); #warning //TODO: optimize Collection <Task> tasks = new Collection <Task>(); foreach (TaskAssignment assignment in assignmentCollection) { tasks.Add(CreateRecord(assignment.Task)); } return(tasks); }
public TaskAssignmentCollection FetchByQuery(Query qry) { TaskAssignmentCollection coll = new TaskAssignmentCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return coll; }
public TaskAssignmentCollection FetchByID(object TaskID) { TaskAssignmentCollection coll = new TaskAssignmentCollection().Where("TaskID", TaskID).Load(); return coll; }