/// <summary>
/// Build filter values/summary with user friendly data from filters
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void fExceptionList_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Site":
int siteId;
if (int.TryParse(e.Value, out siteId))
{
var site = SiteCache.Read(siteId);
if (site != null)
{
e.Value = site.Name;
}
}
break;
case "Page":
int pageId;
if (int.TryParse(e.Value, out pageId))
{
var page = PageCache.Read(pageId);
if (page != null)
{
e.Value = page.InternalName;
}
}
break;
case "User":
int userPersonId;
if (int.TryParse(e.Value, out userPersonId))
{
PersonService personService = new PersonService(new RockContext());
var user = personService.Get(userPersonId);
if (user != null)
{
e.Value = user.FullName;
}
}
break;
// ignore old filter parameters
case "Start Date":
case "End Date":
e.Value = null;
break;
case "Date Range":
e.Value = SlidingDateRangePicker.FormatDelimitedValues(e.Value);
break;
}
}
/// <summary>
/// Gfs the settings_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void gfSettings_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Amount":
e.Value = NumberRangeEditor.FormatDelimitedValues(e.Value, "N2");
break;
case "Frequency":
int definedValueId = 0;
if (int.TryParse(e.Value, out definedValueId))
{
var definedValue = DefinedValueCache.Get(definedValueId);
if (definedValue != null)
{
e.Value = definedValue.Value;
}
}
break;
case "Created":
e.Value = DateRangePicker.FormatDelimitedValues(e.Value);
break;
case "Account":
int accountId = 0;
if (int.TryParse(e.Value, out accountId) && ddlAccount.Visible)
{
var service = new FinancialAccountService(new RockContext());
var account = service.Get(accountId);
if (account != null)
{
e.Value = account.Name;
}
}
else
{
e.Value = string.Empty;
}
break;
case "Include Inactive":
break;
default:
e.Value = string.Empty;
break;
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
/// <exception cref="System.NotImplementedException"></exception>
void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Date Range":
e.Value = DateRangePicker.FormatDelimitedValues(e.Value);
break;
case "Group":
e.Value = ddlGroups.SelectedValue;
break;
}
}
/// <summary>
/// ts the filter display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case UserPreferenceKey.Active:
e.Value = ddlActiveFilter.SelectedValue;
break;
default:
e.Value = string.Empty;
break;
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
using (var rockContext = new RockContext())
{
if (e.Key == "Requester")
{
string personName = string.Empty;
int? personId = e.Value.AsIntegerOrNull();
if (personId.HasValue)
{
var person = new PersonService(rockContext).Get(personId.Value);
if (person != null)
{
personName = person.FullName;
}
}
e.Value = personName;
}
else if (e.Key == "Connector")
{
string personName = string.Empty;
int? personId = e.Value.AsIntegerOrNull();
if (personId.HasValue)
{
var person = new PersonService(rockContext).Get(personId.Value);
if (person != null)
{
personName = person.FullName;
}
}
e.Value = personName;
}
else if (e.Key == "Campus")
{
e.Value = ResolveValues(e.Value, cblCampus);
}
else if (e.Key == "State")
{
e.Value = ResolveValues(e.Value, cblState);
}
else if (e.Key == MakeKeyUniqueToOpportunity("Status"))
{
e.Value = ResolveValues(e.Value, cblStatus);
}
else
{
e.Value = string.Empty;
}
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
/// <exception cref="System.NotImplementedException"></exception>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
var rockContext = new RockContext();
switch (e.Key)
{
case "Date Range":
e.Value = DateRangePicker.FormatDelimitedValues(e.Value);
break;
case "Person":
var person = new PersonService(rockContext).Get(e.Value.AsIntegerOrNull() ?? 0);
if (person != null)
{
e.Value = person.ToString();
}
else
{
e.Value = null;
}
break;
case "Group":
var group = new GroupService(rockContext).Get(e.Value.AsIntegerOrNull() ?? 0);
if (group != null)
{
e.Value = group.ToString();
}
else
{
e.Value = null;
}
break;
case "Schedule":
var schedule = new ScheduleService(rockContext).Get(e.Value.AsIntegerOrNull() ?? 0);
if (schedule != null)
{
e.Value = schedule.Name;
}
else
{
e.Value = null;
}
break;
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
if (AvailableAttributes != null)
{
var attribute = AvailableAttributes.FirstOrDefault(a => MakeKeyUniqueToEventCalendar(a.Key) == e.Key);
if (attribute != null)
{
try
{
var values = JsonConvert.DeserializeObject <List <string> >(e.Value);
e.Value = attribute.FieldType.Field.FormatFilterValues(attribute.QualifierValues, values);
return;
}
catch { }
}
}
if (e.Key == MakeKeyUniqueToEventCalendar("Campus"))
{
e.Value = ResolveValues(e.Value, cblCampus);
}
else if (e.Key == MakeKeyUniqueToEventCalendar("DateRange"))
{
var drp = new DateRangePicker();
drp.DelimitedValues = e.Value;
if (drp.LowerValue.HasValue && !drp.UpperValue.HasValue)
{
drp.UpperValue = drp.LowerValue.Value.AddYears(1).AddDays(-1);
}
else if (drp.UpperValue.HasValue && !drp.LowerValue.HasValue)
{
drp.LowerValue = drp.UpperValue.Value.AddYears(-1).AddDays(1);
}
e.Value = DateRangePicker.FormatDelimitedValues(drp.DelimitedValues);
}
else if (e.Key == MakeKeyUniqueToEventCalendar("Audiences"))
{
e.Value = ResolveValues(e.Value, cblAudience);
}
else if (e.Key == MakeKeyUniqueToEventCalendar("Status") ||
e.Key == MakeKeyUniqueToEventCalendar("ApprovalStatus"))
{
e.Value = e.Value;
}
else
{
e.Value = string.Empty;
}
}
/// <summary>
/// Gfs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
void gfFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case UserPreferenceKey.Categories:
{
var categories = new List <string>();
foreach (var idVal in e.Value.SplitDelimitedValues())
{
int id = int.MinValue;
if (int.TryParse(idVal, out id))
{
if (id != 0)
{
var category = CategoryCache.Get(id);
if (category != null)
{
categories.Add(CategoryCache.Get(id).Name);
}
}
}
}
e.Value = categories.AsDelimited(", ");
break;
}
case UserPreferenceKey.Type:
{
int?typeId = e.Value.AsIntegerOrNull();
if (typeId.HasValue)
{
var contentType = new ContentChannelTypeService(new RockContext()).Get(typeId.Value);
if (contentType != null)
{
e.Value = contentType.Name;
}
}
break;
}
default:
{
e.Value = string.Empty;
break;
}
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
if (e.Key != "Street Address" && e.Key != "City" && e.Key != "Not Geocoded")
{
e.Value = string.Empty;
}
if (e.Key == "Not Geocoded")
{
if (e.Value == "False")
{
e.Value = String.Empty;
}
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Campus":
{
var values = new List <string>();
foreach (string value in e.Value.Split(';'))
{
var item = cblCampus.Items.FindByValue(value);
if (item != null)
{
values.Add(item.Text);
}
}
e.Value = values.AsDelimited(", ");
break;
}
case "DateRange":
{
var drp = new DateRangePicker();
drp.DelimitedValues = e.Value;
if (drp.LowerValue.HasValue && !drp.UpperValue.HasValue)
{
drp.UpperValue = drp.LowerValue.Value.AddYears(1).AddDays(-1);
}
else if (drp.UpperValue.HasValue && !drp.LowerValue.HasValue)
{
drp.LowerValue = drp.UpperValue.Value.AddYears(-1).AddDays(1);
}
e.Value = DateRangePicker.FormatDelimitedValues(drp.DelimitedValues);
break;
}
case "Contact":
{
e.Value = e.Value;
break;
}
default:
{
e.Value = string.Empty;
break;
}
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Group Type":
int id = e.Value.AsInteger() ?? 0;
var groupType = GroupTypeCache.Read(id);
if (groupType != null)
{
e.Value = groupType.Name;
}
break;
}
}
/// <summary>
/// Gets the display value for a filter field.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void fPayments_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Payments Date Range":
{
e.Value = SlidingDateRangePicker.FormatDelimitedValues(e.Value);
break;
}
default:
{
e.Value = string.Empty;
break;
}
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "EntityType":
{
if (e.Value != "")
{
if (e.Value != "0")
{
e.Value = EntityTypeCache.Get(int.Parse(e.Value)).FriendlyName;
}
}
break;
}
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case FilterKey.FirstName:
case FilterKey.LastName:
return;
case FilterKey.EnrollmentDate:
e.Value = DateRangePicker.FormatDelimitedValues(e.Value);
break;
default:
e.Value = string.Empty;
break;
}
}
/// <summary>
/// Displays the text of the gfShortLink control
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void gfShortLink_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Site":
int?siteId = e.Value.AsIntegerOrNull();
if (siteId.HasValue)
{
var site = SiteCache.Get(siteId.Value);
if (site != null)
{
e.Value = site.Name;
}
}
break;
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Date Range":
e.Value = DateRangePicker.FormatDelimitedValues(e.Value);
break;
case "Active Status":
e.Value = e.Value;
break;
default:
e.Value = string.Empty;
break;
}
}
/// <summary>
/// Gfs the settings_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void gfFiler_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case UserPreferenceKey.EntityType:
{
var entityTypeId = e.Value.AsIntegerOrNull();
if (entityTypeId.HasValue && entityTypeId.Value != default(int))
{
e.Value = EntityTypeCache.Get(entityTypeId.Value).FriendlyName;
}
break;
}
case UserPreferenceKey.Date:
{
e.Value = DateRangePicker.FormatDelimitedValues(e.Value);
break;
}
case UserPreferenceKey.ChangedBy:
{
var rockContext = new RockContext();
int?personId = e.Value.AsIntegerOrNull();
e.Value = null;
if (personId.HasValue)
{
var person = new PersonService(rockContext).Get(personId.Value);
if (person != null)
{
e.Value = person.ToString();
}
}
break;
}
case UserPreferenceKey.EntityId:
{
break;
}
}
}
protected void gFilter_OnDisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Status":
{
if (!string.IsNullOrWhiteSpace(e.Value))
{
var connectionStatus = new ConnectionStatusService(new RockContext()).Get(e.Value.AsGuid());
if (connectionStatus != null)
{
e.Value = connectionStatus.Name;
}
}
break;
}
case "Consolidator":
{
string personName = string.Empty;
int?personId = e.Value.AsIntegerOrNull();
if (personId.HasValue)
{
var personService = new PersonService(new RockContext());
var person = personService.Get(personId.Value);
if (person != null)
{
personName = person.FullName;
}
}
e.Value = personName;
break;
}
case "Submitted":
{
e.Value = DateRangePicker.FormatDelimitedValues(e.Value);
break;
}
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "EntityType":
int?entityTypeId = e.Value.AsIntegerOrNull();
if (entityTypeId.HasValue)
{
var entityType = EntityTypeCache.Read(entityTypeId.Value);
if (entityType != null)
{
e.Value = entityType.FriendlyName;
}
}
break;
}
}
/// <summary>
/// Displays the text of the current filters
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void fDevice_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Printer":
int deviceId = 0;
if (int.TryParse(e.Value, out deviceId))
{
var service = new DeviceService(new RockContext());
var device = service.Get(deviceId);
if (device != null)
{
e.Value = device.Name;
}
}
break;
case "Device Type":
int definedValueId = 0;
if (int.TryParse(e.Value, out definedValueId))
{
var definedValue = DefinedValueCache.Read(definedValueId);
if (definedValue != null)
{
e.Value = definedValue.Value;
}
}
break;
case "Print To":
e.Value = ((PrintTo)System.Enum.Parse(typeof(PrintTo), e.Value)).ToString();
break;
case "Print From":
e.Value = ((PrintFrom)System.Enum.Parse(typeof(PrintFrom), e.Value)).ToString();
break;
}
}
/// <summary>
/// Build filter values/summary with user friendly data from filters
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void fExceptionList_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Site":
int siteId;
if (int.TryParse(e.Value, out siteId))
{
SiteService siteService = new SiteService();
var site = siteService.Get(siteId);
if (site != null)
{
e.Value = site.Name;
}
}
break;
case "Page":
int pageId;
if (int.TryParse(e.Value, out pageId))
{
PageService pageService = new PageService();
var page = pageService.Get(pageId);
if (page != null)
{
e.Value = page.InternalName;
}
}
break;
case "User":
int userPersonId;
if (int.TryParse(e.Value, out userPersonId))
{
PersonService personService = new PersonService();
var user = personService.Get(userPersonId);
if (user != null)
{
e.Value = user.FullName;
}
}
break;
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
/// <exception cref="System.NotImplementedException"></exception>
void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
if (e.Key == FilterSettingName.Category)
{
int?categoryId = e.Value.AsIntegerOrNull();
if (categoryId.HasValue)
{
var category = CategoryCache.Get(categoryId.Value);
if (category != null)
{
e.Value = category.Name;
}
}
else
{
e.Value = string.Empty;
}
}
}
/// <summary>
/// Handles the filter display
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rAccountFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Campus":
int?campusId = e.Value.AsIntegerOrNull();
if (campusId.HasValue)
{
var campus = CampusCache.Read(campusId.Value);
if (campus != null)
{
e.Value = campus.Name;
}
}
break;
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Purpose":
int?id = e.Value.AsIntegerOrNull();
if (id.HasValue)
{
var purpose = DefinedValueCache.Read(id.Value);
if (purpose != null)
{
e.Value = purpose.Value;
}
}
break;
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Purpose":
int id = int.MinValue;
if (int.TryParse(e.Value, out id))
{
var purpose = DefinedValueCache.Read(id);
if (purpose != null)
{
e.Value = purpose.Name;
}
}
break;
}
}
/// <summary>
/// Rs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void rFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Group Type":
int id = int.MinValue;
if (int.TryParse(e.Value, out id))
{
var groupType = GroupTypeCache.Read(id);
if (groupType != null)
{
e.Value = groupType.Name;
}
}
break;
}
}
/// <summary>
/// Gfs the list display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void gfList_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Group Type":
int?groupTypeId = e.Value.AsIntegerOrNull();
if (groupTypeId.HasValue)
{
var groupType = GroupTypeCache.Get(groupTypeId.Value);
if (groupType != null)
{
e.Value = groupType.Name;
}
}
break;
}
}
/// <summary>
/// Gfs the note types display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
protected void gfNoteTypes_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case AttributeKey.EntityType:
int?entityTypeId = e.Value.AsIntegerOrNull();
if (entityTypeId.HasValue)
{
var entityType = EntityTypeCache.Get(entityTypeId.Value);
if (entityType != null)
{
e.Value = entityType.FriendlyName;
}
}
break;
}
}
/// <summary>
/// Handles displaying the stored filter values.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e as DisplayFilterValueArgs (hint: e.Key and e.Value).</param>
protected void gfFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
switch (e.Key)
{
case "Date Range":
e.Value = DateRangePicker.FormatDelimitedValues(e.Value);
break;
// don't display dead setting
case "From Date":
e.Value = string.Empty;
break;
// don't display dead setting
case "To Date":
e.Value = string.Empty;
break;
}
}
/// <summary>
/// Gfs the filter_ display filter value.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="e">The e.</param>
void gfFilter_DisplayFilterValue(object sender, GridFilter.DisplayFilterValueArgs e)
{
if (AvailableAttributes != null && SelectedChannelId.HasValue)
{
var attribute = AvailableAttributes.FirstOrDefault(a => MakeKeyUniqueToChannel(SelectedChannelId.Value, a.Key) == e.Key);
if (attribute != null)
{
try
{
var values = JsonConvert.DeserializeObject <List <string> >(e.Value);
e.Value = attribute.FieldType.Field.FormatFilterValues(attribute.QualifierValues, values);
return;
}
catch
{
// intentionally ignore
}
}
}
if (e.Key == "Date Range")
{
e.Value = DateRangePicker.FormatDelimitedValues(e.Value);
}
else if (e.Key == "Status")
{
var status = e.Value.ConvertToEnumOrNull <ContentChannelItemStatus>();
if (status.HasValue)
{
{
e.Value = status.ConvertToString();
}
}
}
else if (e.Key == "Title")
{
return;
}
else
{
e.Value = string.Empty;
}
}