public ManagerAssignmentCollection FetchAll()
{
ManagerAssignmentCollection coll = new ManagerAssignmentCollection();
Query qry = new Query(ManagerAssignment.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
/// <summary>
/// Gets the users by manager.
/// </summary>
/// <param name="managerID">The manager ID.</param>
/// <returns></returns>
public Collection <User> GetByManager(int managerID)
{
ManagerAssignmentCollection assignmentCollection =
new ManagerAssignmentCollection().Where(ManagerAssignment.Columns.ManagerID,
Comparison.Equals, managerID);
//TODO: optimize UserService.GetByManager()
Collection <User> userCollection = new Collection <User>();
foreach (ManagerAssignment assignment in assignmentCollection)
{
userCollection.Add(CreateRecord(assignment.User));
}
return(userCollection);
}
public ManagerAssignmentCollection FetchByQuery(Query qry)
{
ManagerAssignmentCollection coll = new ManagerAssignmentCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public ManagerAssignmentCollection FetchByID(object ManagerID)
{
ManagerAssignmentCollection coll = new ManagerAssignmentCollection().Where("ManagerID", ManagerID).Load();
return coll;
}