void ShowList()
{
var rockContext = new RockContext();
int sessionCount = Int32.Parse(GetAttributeValue("SessionCount"));
int skipCount = pageNumber * sessionCount;
var person = new PersonService(rockContext).GetByUrlEncodedKey(PageParameter("Person"));
if (person != null)
{
lPersonName.Text = person.FullName;
PageViewService pageviewService = new PageViewService(rockContext);
var pageViews = pageviewService.Queryable();
var sessionInfo = pageviewService.Queryable()
.Where(s => s.PersonAlias.PersonId == person.Id);
if (startDate != DateTime.MinValue)
{
sessionInfo = sessionInfo.Where(s => s.DateTimeViewed > drpDateFilter.LowerValue);
}
if (endDate != DateTime.MaxValue)
{
sessionInfo = sessionInfo.Where(s => s.DateTimeViewed < drpDateFilter.UpperValue);
}
if (siteId != -1)
{
sessionInfo = sessionInfo.Where(p => p.SiteId == siteId);
}
var pageviewInfo = sessionInfo.GroupBy(s => new { s.SessionId, s.SiteId, SiteName = s.Site.Name, s.ClientType, s.IpAddress, s.UserAgent })
.Select(s => new WebSession
{
SessionId = s.Key.SessionId,
StartDateTime = s.Min(x => x.DateTimeViewed),
EndDateTime = s.Max(x => x.DateTimeViewed),
SiteId = s.Key.SiteId,
Site = s.Key.SiteName,
ClientType = s.Key.ClientType,
IpAddress = s.Key.IpAddress,
UserAgent = s.Key.UserAgent,
PageViews = pageViews.Where(p => p.SessionId == s.Key.SessionId && p.SiteId == s.Key.SiteId).ToList()
});
pageviewInfo = pageviewInfo.OrderByDescending(p => p.StartDateTime)
.Skip(skipCount)
.Take(sessionCount + 1);
rptSessions.DataSource = pageviewInfo.ToList().Take(sessionCount);
rptSessions.DataBind();
// set next button
if (pageviewInfo.Count() > sessionCount)
{
hlNext.Visible = hlNext.Enabled = true;
Dictionary <string, string> queryStringNext = new Dictionary <string, string>();
queryStringNext.Add("Page", (pageNumber + 1).ToString());
queryStringNext.Add("Person", person.UrlEncodedKey);
if (siteId != -1)
{
queryStringNext.Add("SiteId", siteId.ToString());
}
if (startDate != DateTime.MinValue)
{
queryStringNext.Add("StartDate", startDate.ToShortDateString());
}
if (endDate != DateTime.MaxValue)
{
queryStringNext.Add("EndDate", endDate.ToShortDateString());
}
var pageReferenceNext = new Rock.Web.PageReference(CurrentPageReference.PageId, CurrentPageReference.RouteId, queryStringNext);
hlNext.NavigateUrl = pageReferenceNext.BuildUrl();
}
else
{
hlNext.Visible = hlNext.Enabled = false;
}
// set prev button
if (pageNumber == 0)
{
hlPrev.Visible = hlPrev.Enabled = false;
}
else
{
hlPrev.Visible = hlPrev.Enabled = true;
Dictionary <string, string> queryStringPrev = new Dictionary <string, string>();
queryStringPrev.Add("Page", (pageNumber - 1).ToString());
queryStringPrev.Add("Person", person.UrlEncodedKey);
if (siteId != -1)
{
queryStringPrev.Add("SiteId", siteId.ToString());
}
if (startDate != DateTime.MinValue)
{
queryStringPrev.Add("StartDate", startDate.ToShortDateString());
}
if (endDate != DateTime.MaxValue)
{
queryStringPrev.Add("EndDate", endDate.ToShortDateString());
}
var pageReferencePrev = new Rock.Web.PageReference(CurrentPageReference.PageId, CurrentPageReference.RouteId, queryStringPrev);
hlPrev.NavigateUrl = pageReferencePrev.BuildUrl();
}
}
else
{
lMessages.Text = "<div class='alert alert-warning'>No person provided to show results for.</div>";
}
}
/// <summary>
/// Handles the Click event of the btnDeleteConfirm control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs"/> instance containing the event data.</param>
protected void btnDeleteConfirm_Click(object sender, EventArgs e)
{
bool canDelete = false;
var rockContext = new RockContext();
SiteService siteService = new SiteService(rockContext);
Site site = siteService.Get(hfSiteId.Value.AsInteger());
LayoutService layoutService = new LayoutService(rockContext);
PageService pageService = new PageService(rockContext);
PageViewService pageViewService = new PageViewService(rockContext);
if (site != null)
{
var sitePages = new List <int> {
site.DefaultPageId ?? -1,
site.LoginPageId ?? -1,
site.RegistrationPageId ?? -1,
site.PageNotFoundPageId ?? -1
};
foreach (var pageView in pageViewService
.Queryable()
.Where(t =>
t.Page != null &&
t.Page.Layout != null &&
t.Page.Layout.SiteId == site.Id))
{
pageView.Page = null;
pageView.PageId = null;
}
var pageQry = pageService.Queryable("Layout")
.Where(t =>
t.Layout.SiteId == site.Id ||
sitePages.Contains(t.Id));
pageService.DeleteRange(pageQry);
var layoutQry = layoutService.Queryable()
.Where(l =>
l.SiteId == site.Id);
layoutService.DeleteRange(layoutQry);
rockContext.SaveChanges(true);
string errorMessage;
canDelete = siteService.CanDelete(site, out errorMessage, includeSecondLvl: true);
if (!canDelete)
{
mdDeleteWarning.Show(errorMessage, ModalAlertType.Alert);
return;
}
siteService.Delete(site);
rockContext.SaveChanges();
SiteCache.Flush(site.Id);
}
NavigateToParentPage();
}
