This report displays pages that exists on the site.
@using (Html.BeginForm("ListPages", "ExistingPagesReport", FormMethod.Post))
{
PageTypes {
get;
set;
}
public PageDataCollection Pages {
get;
set;
}
public string SelectedPageType {
get;
set;
}
}
```
4. Create a helper class to make a request against Optimizely like this:
```csharp
public static class ExistingPagesHelper {
public static IEnumerable GetAllPageTypes() {
var contentTypeRepository = ServiceLocator.Current.GetInstance();
return contentTypeRepository.List().OfType();
}
public static void SetPagesForPageTypeName(ExistingPagesReportViewModel model) {
var criterias = new PropertyCriteriaCollection();
var criteria = new PropertyCriteria();
criteria.Condition = CompareCondition.Equal;
criteria.Name = "PageTypeID";
criteria.Type = PropertyDataType.PageType;
criteria.Value = model.SelectedPageType;
criteria.Required = true;
criterias.Add(criteria);
var pages = DataFactory.Instance.FindPagesWithCriteria(ContentReference.RootPage, criterias);
model.Pages = pages;
}
}
```
5. Update your index action to create an instance of the view model and assign all page types to it:
```csharp
public ActionResult Index() {
var model = new ExistingPagesReportViewModel {
PageTypes = ExistingPagesHelper.GetAllPageTypes()
};
return View(model);
}
```
6. Create a view and add Optimizely's CSS and JavaScript to it to have the same appearance as other built-in reports in Optimizely. The complete view looks like this:
```asp
@model ExistingPagesReportViewModel
@using EPiServer.DataAbstraction
@using EPiServer.Framework.Web.Resources
@{
Layout = null;
}
@ViewBag.Title
@Html.Raw(ClientResources.RenderResources("ShellCore"))
@Html.Raw(ClientResources.RenderResources("ShellCoreLightTheme"))
@Html.Raw(Html.ShellInitializationScript())
Existing Pages
This report displays pages that exist on the site.
```
This code has two **Submit** buttons but only one form action; the JavaScript function connected to the click event on the export and search submit buttons updates a hidden value telling the controller to do an export of the data or not.
The action in the controller that handles this looks like this:
```csharp
[HttpPost]
public ActionResult ListPages(FormCollection form) {
var model = new ExistingPagesReportViewModel {
PageTypes = ExistingPagesHelper.GetAllPageTypes(),
SelectedPageType = form["pageType"]
};
ExistingPagesHelper.SetPagesForPageTypeName(model);
var doExport = false;
if (bool.TryParse(form["doExport"], out doExport) && doExport && model.Pages != null && model.Pages.Count > 0) {
Export(model.Pages, System.Web.HttpContext.Current.Response);
}
return View("Index", model);
}
```
It returns the view if the export values are not **true**.
7. To export the report to Excel, use **EPPlus** and create a function in the same class like this:
```csharp
public void Export(PageDataCollection pagesToExport, HttpResponse response) {
using(var package = new ExcelPackage()) {
ExcelWorksheet ws = package.Workbook.Worksheets.Add("pages");
ws.Cells[1, 1].Value = "PageId";
ws.Cells[1, 2].Value = "PageName";
ws.Cells[1, 3].Value = "PageUrl";
ws.Cells[1, 4].Value = "Published Date";
ws.Row(1).Style.Font.Bold = true;
ws.Row(1).Style.Locked = true;
int row = 2;
foreach(var page in pagesToExport) {
ws.Cells[row, 1].Value = page.ContentLink.ID;
ws.Cells[row, 2].Value = page.PageName;
ws.Cells[row, 3].Value = Url.ContentUrl(page.ContentLink);
ws.Cells[row, 4].Value = page.StartPublish.HasValue ? page.StartPublish.Value.ToString("yyyy-MM-dd HH:mm") : "Not published";
++row;
}
response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
response.AddHeader("content-disposition", string.Format("attachment; filename=pages{0}.xlsx", DateTime.Now.ToString("yyyyMMdd")));
response.BinaryWrite(package.GetAsByteArray());
response.Flush();
response.End();
}
}
```