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 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; }