/// <summary> /// Gets the usernames of users, who modified object for which the given staging task was created. /// </summary> /// <param name="ti">Staging task</param> /// <returns>Returns usernames of users, who modified object for which the given staging task was created</returns> private static IEnumerable <string> GetUsersFromStagingTask(StagingTaskInfo ti) { List <string> usersWhoModifiedObject = new List <string>(); UserInfoProvider.GetUsers() .Columns("UserID", "UserName") .WhereIn("UserID", StagingTaskUserInfoProvider.GetTaskUsers().Column("UserID").WhereEquals("TaskID", ti.TaskID)) .ForEachObject(u => usersWhoModifiedObject.Add(u.UserName)); return(usersWhoModifiedObject); }
private void GetStagingTasksByUser(WhereCondition where, int selected) { if (selected > 0) { // Get tasks for current user where.WhereIn("TaskID", StagingTaskUserInfoProvider.GetTaskUsers().WhereEquals("UserID", selected).Column("TaskID")); } else if (selected == UniSelector.US_NONE_RECORD) { // Get all tasks without any assigned user where.WhereNotIn("TaskID", StagingTaskUserInfoProvider.GetTaskUsers().Column("TaskID")); } }