/// <summary>
/// Gets the projects by user.
/// </summary>
/// <param name="fromDate">From date.</param>
/// <param name="toDate">To date.</param>
/// <param name="userList">The user list.</param>
/// <param name="clientList">The client list.</param>
/// <param name="projectGroupList">The project group list.</param>
/// <param name="completion">The completion.</param>
/// <param name="completionFromDate">The completion from date.</param>
/// <param name="completionToDate">The completion to date.</param>
/// <returns></returns>
public static IDataReader GetProjectsByUser(DateTime fromDate, DateTime toDate, string[] userList, string[] clientList, string[] projectGroupList, int completion, DateTime completionFromDate, DateTime completionToDate)
{
TimeZone tz = Security.CurrentUser.CurrentTimeZone;
completionFromDate = tz.ToUniversalTime(completionFromDate);
completionToDate = tz.ToUniversalTime(completionToDate);
string users = String.Join(",", userList);
string clients = String.Join(",", clientList);
string projectGroups = String.Join(",", projectGroupList);
return(DbReport.GetProjectsByUser(fromDate, toDate, users, clients, projectGroups, completion, completionFromDate, completionToDate));
}
