private DataTable GetDataTable() { int top = TopRecordsDropDownList1.SelectedId; int assetTypeId = AssetTypeDropDownList1.SelectedId; int brandId = BrandDropDownList.SelectedId; TimeFrame timeframe = EnumUtils.GetEnumFromValue <TimeFrame>(TimeFrameDropDownList1.SelectedId); DateRange dateRange = SiteUtils.GetDateRangeFromTimeFrame(timeframe); DataTable dt = AssetReportMapper.Instance.GetPopularAssetList(top, assetTypeId, brandId, dateRange); dt.DefaultView.Sort = AssetRepeater.GetSortExpressions()[0].ToString(); return(dt); }
private void BindRepeater() { DataTable dt = GetDataTable(); AssetRepeater.DataSource = dt; AssetRepeater.DataBind(); AssetRepeater.Visible = (dt.Rows.Count > 0); NoResultsPanel.Visible = (dt.Rows.Count == 0); InitialPanel.Visible = false; ResultsPanel.Visible = true; InitialFooterPanel.Visible = false; ResultsFooterPanel.Visible = true; }
protected void SortListLinkButton_Command(object sender, CommandEventArgs e) { AssetRepeater.UpdateSortExpression(e.CommandArgument.ToString()); BindRepeater(); }
protected override AssetFinder GetFinderFromForm() { AuditAssetHistoryFinder finder = new AuditAssetHistoryFinder(); if (UploadedCheckBox.Checked) { finder.IncludeActionsList.Add(AuditAssetAction.UploadedAsset); } if (DownloadedCheckBox.Checked) { finder.IncludeActionsList.Add(AuditAssetAction.DownloadedAssetFile); } if (OrderRequestsCheckBox.Checked) { finder.IncludeActionsList.Add(AuditAssetAction.Ordered); } if (ViewsCheckBox.Checked) { finder.IncludeActionsList.Add(AuditAssetAction.ViewedAssetDetail); } if (SearcHitsCheckBox.Checked) { finder.IncludeActionsList.Add(AuditAssetAction.ReturnedInSearch); } if (CartCheckBox.Checked) { finder.IncludeActionsList.Add(AuditAssetAction.AddedToCart); } if (LightboxCheckBox.Checked) { finder.IncludeActionsList.Add(AuditAssetAction.AddedToLightbox); } finder.BrandId = BrandDropDownList.SelectedId; TimeFrame timeframe = EnumUtils.GetEnumFromValue <TimeFrame>(TimeFrameDropDownList1.SelectedId); DateRange dateRange = SiteUtils.GetDateRangeFromTimeFrame(timeframe); finder.StartDate = dateRange.StartDate; finder.EndDate = dateRange.EndDate; // Initialise the asset finder AssetFinder assetFinder = new AssetFinder(); assetFinder.SortExpressions.AddRange(AssetRepeater.GetSortExpressions()); // Give the asset finder, so it only finds assets in the // asset audit history matching the specified criteria // Caution: If the AuditAssetHistoryFinder is using any values // causing the constructed SQL query to use the parameter list // (eg. by setting @properties), this will fail. assetFinder.AuditAssetHistoryFinder = finder; return(assetFinder); }