public List <CrcReportHistory> GetUsersRecentRuns(string username, int max) { string sql = SqlPatternUsersRecentRuns(); DataTable res = new DataTable(); using (SqlConnection conn = new SqlConnection(GetReportServerConnectionString())) { SqlCommand comm = new SqlCommand(String.Format(sql, max), conn); comm.Parameters.Add("@UserName", SqlDbType.NVarChar, 520).Value = username; SqlDataAdapter adapt = new SqlDataAdapter(comm); adapt.Fill(res); } var histList = new List <CrcReportHistory>(); foreach (DataRow rowLoop in res.Rows) { var h = new CrcReportHistory() { ReportName = CrcReportDefinition.ReportNameFromPath(rowLoop["ReportPath"].ToString()), ReportPath = rowLoop["ReportPath"].ToString(), UserName = rowLoop["UserName"].ToString(), Parameters = rowLoop["Parameters"].ToString(), TimeStart = (DateTime)rowLoop["TimeStart"], RunDuration = (int)rowLoop["TimeDataRetrieval"], RowCount = (long)rowLoop["RowCount"] }; histList.Add(h); } return(histList); }
public CrcReportFolder Create(ReportingService2005Soap rService, string path) { var ret = new CrcReportFolder(); ret.Path = path; ret.FolderName = CrcReportDefinition.ReportNameFromPath(path); var lcRequest = new ListChildrenRequest(path, false); var lcResponse = rService.ListChildren(lcRequest); foreach (CatalogItem itemLoop in lcResponse.CatalogItems) { if (itemLoop.Type == ItemTypeEnum.Folder) { var sf = Create(rService, itemLoop.Path); if (sf.Reports.Count() > 0 || sf.SubFolders.Count() > 0) { ret.SubFolders.Add(sf); } } else if (itemLoop.Type == ItemTypeEnum.Report) { if (!itemLoop.Hidden) { var repItem = new CrcReportItem(); repItem.ReportPath = itemLoop.Path; repItem.DisplayName = itemLoop.Name; repItem.Description = itemLoop.Description; ret.Reports.Add(repItem); } } } return(ret); }