/// <summary> /// Gets the projects. /// </summary> /// <param name="fromDate">From date.</param> /// <param name="toDate">To date.</param> /// <param name="managerList">The manager 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 GetProjects(DateTime fromDate, DateTime toDate, string[] managerList, string[] clientList, string[] projectGroupList, int completion, DateTime completionFromDate, DateTime completionToDate) { TimeZone tz = Security.CurrentUser.CurrentTimeZone; completionFromDate = tz.ToUniversalTime(completionFromDate); completionToDate = tz.ToUniversalTime(completionToDate); string managers = String.Join(",", managerList); string clients = String.Join(",", clientList); string projectGroups = String.Join(",", projectGroupList); return(DbReport.GetProjects(fromDate, toDate, managers, clients, projectGroups, completion, completionFromDate, completionToDate)); }