/// <summary>
/// Handles the Click event of the btnShowDataPreview 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 btnShowDataPreview_Click(object sender, EventArgs e)
{
if (pnlPreview.Visible)
{
pnlPreview.Visible = false;
return;
}
var rockContext = new RockContext();
int entitySetId = hfEntitySetId.Value.AsInteger();
var entitySetService = new EntitySetService(rockContext);
var entitySet = entitySetService.Get(entitySetId);
if (entitySet.EntityTypeId.HasValue)
{
var qry = entitySetService.GetEntityQuery(entitySetId).Take(15);
EntityTypeCache itemEntityType = EntityTypeCache.Get(entitySet.EntityTypeId ?? 0);
gPreview.CreatePreviewColumns(itemEntityType.GetEntityType());
gPreview.DataSource = qry.ToList();
gPreview.DataBind();
}
else
{
var entitySetItemService = new EntitySetItemService(rockContext);
var qry = entitySetItemService.GetByEntitySetId(entitySetId, true).Take(15);
var list = qry.ToList().Select(a => a.AdditionalMergeValuesJson.FromJsonOrNull <Dictionary <string, object> >()).ToList();
if (list.Any())
{
gPreview.Columns.Clear();
foreach (var s in list[0])
{
var gridField = Grid.GetGridField(s.Value != null ? s.Value.GetType() : typeof(string));
gridField.HeaderText = s.Key.SplitCase();
gridField.DataField = s.Key;
gPreview.Columns.Add(gridField);
}
gPreview.DataSource = qry.ToList().Select(a => a.AdditionalMergeValuesJson.FromJsonOrNull <object>()).ToList();
gPreview.DataBind();
}
}
pnlPreview.Visible = true;
}
/// <summary>
/// Handles the Delete event of the gList control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="RowEventArgs"/> instance containing the event data.</param>
protected void gList_Delete(object sender, RowEventArgs e)
{
var rockContext = new RockContext();
var entitySetService = new EntitySetService(rockContext);
EntitySet entitySet = entitySetService.Get(e.RowKeyId);
if (entitySet != null)
{
string errorMessage;
if (!entitySetService.CanDelete(entitySet, out errorMessage))
{
mdGridWarning.Show(errorMessage, ModalAlertType.Information);
return;
}
// mark it as expired and RockCleanup will delete it later
entitySet.ExpireDateTime = RockDateTime.Now.AddMinutes(-1);
entitySet.EntitySetPurposeValueId = null;
rockContext.SaveChanges();
}
BindGrid();
}
/// <summary>
/// Gets the merge object list for the current EntitySet
/// </summary>
/// <param name="rockContext">The rock context.</param>
/// <param name="fetchCount">The fetch count.</param>
/// <returns></returns>
private List <object> GetMergeObjectList(RockContext rockContext, int?fetchCount = null)
{
int entitySetId = hfEntitySetId.Value.AsInteger();
var entitySetService = new EntitySetService(rockContext);
var entitySet = entitySetService.Get(entitySetId);
Dictionary <int, object> mergeObjectsDictionary = new Dictionary <int, object>();
// If this EntitySet contains IEntity Items, add those first
if (entitySet.EntityTypeId.HasValue)
{
var qryEntity = entitySetService.GetEntityQuery(entitySetId);
if (fetchCount.HasValue)
{
qryEntity = qryEntity.Take(fetchCount.Value);
}
var entityTypeCache = EntityTypeCache.Read(entitySet.EntityTypeId.Value);
bool isPersonEntityType = entityTypeCache != null && entityTypeCache.Guid == Rock.SystemGuid.EntityType.PERSON.AsGuid();
bool isGroupMemberEntityType = entityTypeCache != null && entityTypeCache.Guid == Rock.SystemGuid.EntityType.GROUP_MEMBER.AsGuid();
bool combineFamilyMembers = cbCombineFamilyMembers.Visible && cbCombineFamilyMembers.Checked;
if ((isGroupMemberEntityType || isPersonEntityType) && combineFamilyMembers)
{
IQueryable <IEntity> qryPersons;
if (isGroupMemberEntityType)
{
qryPersons = qryEntity.OfType <GroupMember>().Select(a => a.Person).Distinct();
}
else
{
qryPersons = qryEntity;
}
Guid familyGroupType = Rock.SystemGuid.GroupType.GROUPTYPE_FAMILY.AsGuid();
var qryFamilyGroupMembers = new GroupMemberService(rockContext).Queryable("GroupRole,Person").AsNoTracking()
.Where(a => a.Group.GroupType.Guid == familyGroupType)
.Where(a => qryPersons.Any(aa => aa.Id == a.PersonId));
var qryCombined = qryFamilyGroupMembers.Join(
qryPersons,
m => m.PersonId,
p => p.Id,
(m, p) => new { GroupMember = m, Person = p })
.GroupBy(a => a.GroupMember.GroupId)
.Select(x => new
{
GroupId = x.Key,
// Order People to match ordering in the GroupMembers.ascx block.
Persons =
// Adult Male
x.Where(xx => xx.GroupMember.GroupRole.Guid.Equals(new Guid(Rock.SystemGuid.GroupRole.GROUPROLE_FAMILY_MEMBER_ADULT)) &&
xx.GroupMember.Person.Gender == Gender.Male).OrderByDescending(xx => xx.GroupMember.Person.BirthDate).Select(xx => xx.Person)
// Adult Female
.Concat(x.Where(xx => xx.GroupMember.GroupRole.Guid.Equals(new Guid(Rock.SystemGuid.GroupRole.GROUPROLE_FAMILY_MEMBER_ADULT)) &&
xx.GroupMember.Person.Gender != Gender.Male).OrderByDescending(xx => xx.GroupMember.Person.BirthDate).Select(xx => xx.Person))
// non-adults
.Concat(x.Where(xx => !xx.GroupMember.GroupRole.Guid.Equals(new Guid(Rock.SystemGuid.GroupRole.GROUPROLE_FAMILY_MEMBER_ADULT)))
.OrderByDescending(xx => xx.GroupMember.Person.BirthDate).Select(xx => xx.Person))
});
foreach (var combinedFamilyItem in qryCombined)
{
object mergeObject;
string commaPersonIds = combinedFamilyItem.Persons.Select(a => a.Id).Distinct().ToList().AsDelimited(",");
var primaryGroupPerson = combinedFamilyItem.Persons.FirstOrDefault() as Person;
if (mergeObjectsDictionary.ContainsKey(primaryGroupPerson.Id))
{
foreach (var person in combinedFamilyItem.Persons)
{
if (!mergeObjectsDictionary.ContainsKey(person.Id))
{
primaryGroupPerson = person as Person;
break;
}
}
}
// if we are combining from a GroupMemberEntityType list add the GroupMember attributes of the primary person in the combined list
if (isGroupMemberEntityType)
{
var groupMember = qryEntity.OfType <GroupMember>().Where(a => a.PersonId == primaryGroupPerson.Id).FirstOrDefault();
primaryGroupPerson.AdditionalLavaFields = primaryGroupPerson.AdditionalLavaFields ?? new Dictionary <string, object>();
if (groupMember != null)
{
primaryGroupPerson.AdditionalLavaFields.AddOrIgnore("GroupMember", groupMember);
}
}
if (combinedFamilyItem.Persons.Count() > 1)
{
var combinedPerson = primaryGroupPerson.ToJson().FromJsonOrNull <MergeTemplateCombinedPerson>();
var familyTitle = RockUdfHelper.ufnCrm_GetFamilyTitle(rockContext, null, combinedFamilyItem.GroupId, commaPersonIds, true);
combinedPerson.FullName = familyTitle;
var firstNameList = combinedFamilyItem.Persons.Select(a => (a as Person).FirstName).ToList();
var nickNameList = combinedFamilyItem.Persons.Select(a => (a as Person).NickName).ToList();
combinedPerson.FirstName = firstNameList.AsDelimited(", ", " & ");
combinedPerson.NickName = nickNameList.AsDelimited(", ", " & ");
combinedPerson.LastName = primaryGroupPerson.LastName;
combinedPerson.SuffixValueId = null;
combinedPerson.SuffixValue = null;
mergeObject = combinedPerson;
}
else
{
mergeObject = primaryGroupPerson;
}
mergeObjectsDictionary.AddOrIgnore(primaryGroupPerson.Id, mergeObject);
}
}
else if (isGroupMemberEntityType)
{
foreach (var groupMember in qryEntity.AsNoTracking().OfType <GroupMember>())
{
var person = groupMember.Person;
person.AdditionalLavaFields = new Dictionary <string, object>();
person.AdditionalLavaFields.Add("GroupMember", groupMember);
mergeObjectsDictionary.AddOrIgnore(groupMember.PersonId, person);
}
}
else
{
foreach (var item in qryEntity.AsNoTracking())
{
mergeObjectsDictionary.AddOrIgnore(item.Id, item);
}
}
}
var entitySetItemService = new EntitySetItemService(rockContext);
string[] emptyJson = new string[] { string.Empty, "{}" };
var entitySetItemMergeValuesQry = entitySetItemService.GetByEntitySetId(entitySetId, true).Where(a => !emptyJson.Contains(a.AdditionalMergeValuesJson));
if (fetchCount.HasValue)
{
entitySetItemMergeValuesQry = entitySetItemMergeValuesQry.Take(fetchCount.Value);
}
// the entityId to use for NonEntity objects
int nonEntityId = 1;
// now, add the additional MergeValues regardless of if the EntitySet contains IEntity items or just Non-IEntity items
foreach (var additionalMergeValuesItem in entitySetItemMergeValuesQry.AsNoTracking())
{
object mergeObject;
int entityId;
if (additionalMergeValuesItem.EntityId > 0)
{
entityId = additionalMergeValuesItem.EntityId;
}
else
{
// not pointing to an actual EntityId, so use the nonEntityId for ti
entityId = nonEntityId++;
}
if (mergeObjectsDictionary.ContainsKey(entityId))
{
mergeObject = mergeObjectsDictionary[entityId];
}
else
{
if (entitySet.EntityTypeId.HasValue)
{
// if already have real entities in our list, don't add additional items to the mergeObjectsDictionary
continue;
}
// non-Entity merge object, so just use Dictionary
mergeObject = new Dictionary <string, object>();
mergeObjectsDictionary.AddOrIgnore(entityId, mergeObject);
}
foreach (var additionalMergeValue in additionalMergeValuesItem.AdditionalMergeValues)
{
if (mergeObject is IEntity)
{
// add the additional fields to AdditionalLavaFields
IEntity mergeEntity = (mergeObject as IEntity);
mergeEntity.AdditionalLavaFields = mergeEntity.AdditionalLavaFields ?? new Dictionary <string, object>();
object mergeValueObject = additionalMergeValue.Value;
// if the mergeValueObject is a JArray (JSON Object), convert it into an ExpandoObject or List<ExpandoObject> so that Lava will work on it
if (mergeValueObject is JArray)
{
var jsonOfObject = mergeValueObject.ToJson();
try
{
mergeValueObject = Rock.Lava.RockFilters.FromJSON(jsonOfObject);
}
catch (Exception ex)
{
LogException(new Exception("MergeTemplateEntry couldn't do a FromJSON", ex));
}
}
mergeEntity.AdditionalLavaFields.AddOrIgnore(additionalMergeValue.Key, mergeValueObject);
}
else if (mergeObject is IDictionary <string, object> )
{
// anonymous object with no fields yet
IDictionary <string, object> nonEntityObject = mergeObject as IDictionary <string, object>;
nonEntityObject.AddOrIgnore(additionalMergeValue.Key, additionalMergeValue.Value);
}
else
{
throw new Exception(string.Format("Unexpected MergeObject Type: {0}", mergeObject));
}
}
}
var result = mergeObjectsDictionary.Select(a => a.Value);
if (fetchCount.HasValue)
{
// make sure the result is limited to fetchCount (even though the above queries are also limited to fetch count)
result = result.Take(fetchCount.Value);
}
return(result.ToList());
}
private List <Rock.Model.Workflow> GetWorkflows(RockContext rockContext)
{
EntitySetService entitySetService = new EntitySetService(rockContext);
var entitySet = entitySetService.Get(PageParameter("EntitySetId").AsInteger());
var workflowEntityId = EntityTypeCache.GetId(typeof(Rock.Model.Workflow));
if (entitySet == null || entitySet.EntityTypeId != workflowEntityId)
{
return(null);
}
WorkflowService workflowService = new WorkflowService(rockContext);
var workflowQueryable = workflowService.Queryable();
var qry = entitySet.Items
.Join(workflowQueryable,
i => i.EntityId,
w => w.Id,
(i, w) => w);
var firstWorkflow = qry.FirstOrDefault();
if (firstWorkflow == null)
{
return(null);
}
var workflowTypeId = firstWorkflow.WorkflowTypeId;
AttributeService attributeService = new AttributeService(rockContext);
AttributeValueService attributeValueService = new AttributeValueService(rockContext);
var attributeQueryable = attributeService.Queryable()
.Where(a => a.EntityTypeId == workflowEntityId &&
a.EntityTypeQualifierColumn == "WorkflowTypeId" &&
a.EntityTypeQualifierValue == workflowTypeId.ToString())
.Select(a => a.Id);
var attributeValueQueryable = attributeValueService.Queryable()
.Where(av => attributeQueryable.Contains(av.AttributeId));
var mixedItems = qry.GroupJoin(attributeValueQueryable,
w => w.Id,
av => av.EntityId,
(w, av) => new { Workflow = w, AttributeValues = av })
.ToList();
Dictionary <string, AttributeCache> attributes = new Dictionary <string, AttributeCache>();
foreach (var id in attributeQueryable.ToList())
{
var attributeCache = AttributeCache.Get(id);
if (attributeCache != null)
{
attributes[attributeCache.Key] = attributeCache;
}
}
var workflows = new List <Rock.Model.Workflow>();
foreach (var item in mixedItems)
{
var workflow = item.Workflow;
workflow.Attributes = attributes;
workflow.AttributeValues = new Dictionary <string, AttributeValueCache>();
foreach (var attribute in attributes)
{
var attributeValue = item.AttributeValues.Where(av => av.AttributeKey == attribute.Key).FirstOrDefault();
workflow.AttributeValues[attribute.Key] = attributeValue != null ? new AttributeValueCache(attributeValue) : new AttributeValueCache();
}
workflows.Add(workflow);
}
return(workflows);
}
/// <summary>
/// Gets the merge object list for the current EntitySet
/// </summary>
/// <param name="rockContext">The rock context.</param>
/// <param name="fetchCount">The fetch count.</param>
/// <returns></returns>
private List <object> GetMergeObjectList(RockContext rockContext, int?fetchCount = null)
{
int entitySetId = hfEntitySetId.Value.AsInteger();
var entitySetService = new EntitySetService(rockContext);
var entitySet = entitySetService.Get(entitySetId);
Dictionary <int, object> mergeObjectsDictionary = new Dictionary <int, object>();
// If this EntitySet contains IEntity Items, add those first
if (entitySet.EntityTypeId.HasValue)
{
var qryEntity = entitySetService.GetEntityQuery(entitySetId);
if (fetchCount.HasValue)
{
qryEntity = qryEntity.Take(fetchCount.Value);
}
var entityTypeCache = EntityTypeCache.Read(entitySet.EntityTypeId.Value);
bool isPersonEntityType = entityTypeCache != null && entityTypeCache.Guid == Rock.SystemGuid.EntityType.PERSON.AsGuid();
bool isGroupMemberEntityType = entityTypeCache != null && entityTypeCache.Guid == Rock.SystemGuid.EntityType.GROUP_MEMBER.AsGuid();
bool combineFamilyMembers = cbCombineFamilyMembers.Visible && cbCombineFamilyMembers.Checked;
if (isPersonEntityType && combineFamilyMembers)
{
var qryPersons = qryEntity;
Guid familyGroupType = Rock.SystemGuid.GroupType.GROUPTYPE_FAMILY.AsGuid();
var qryFamilyGroupMembers = new GroupMemberService(rockContext).Queryable()
.Where(a => a.Group.GroupType.Guid == familyGroupType)
.Where(a => qryPersons.Any(aa => aa.Id == a.PersonId));
var qryCombined = qryFamilyGroupMembers.Join(
qryPersons,
m => m.PersonId,
p => p.Id,
(m, p) => new { GroupMember = m, Person = p })
.GroupBy(a => a.GroupMember.GroupId)
.Select(x => new
{
GroupId = x.Key,
Persons = x.Select(xx => xx.Person).Distinct()
});
foreach (var combinedFamilyItem in qryCombined)
{
object mergeObject;
string commaPersonIds = combinedFamilyItem.Persons.Select(a => a.Id).Distinct().ToList().AsDelimited(",");
var primaryGroupPerson = combinedFamilyItem.Persons.FirstOrDefault() as Person;
if (mergeObjectsDictionary.ContainsKey(primaryGroupPerson.Id))
{
foreach (var person in combinedFamilyItem.Persons)
{
if (!mergeObjectsDictionary.ContainsKey(person.Id))
{
primaryGroupPerson = person as Person;
break;
}
}
}
if (combinedFamilyItem.Persons.Count() > 1)
{
var combinedPerson = primaryGroupPerson.ToJson().FromJsonOrNull <MergeTemplateCombinedPerson>();
var familyTitle = RockUdfHelper.ufnCrm_GetFamilyTitle(rockContext, null, combinedFamilyItem.GroupId, commaPersonIds, true);
combinedPerson.FullName = familyTitle;
var firstNameList = combinedFamilyItem.Persons.Select(a => (a as Person).FirstName).ToList();
var nickNameList = combinedFamilyItem.Persons.Select(a => (a as Person).NickName).ToList();
combinedPerson.FirstName = firstNameList.AsDelimited(", ", " & ");
combinedPerson.NickName = nickNameList.AsDelimited(", ", " & ");
combinedPerson.LastName = primaryGroupPerson.LastName;
combinedPerson.SuffixValueId = null;
combinedPerson.SuffixValue = null;
mergeObject = combinedPerson;
}
else
{
mergeObject = primaryGroupPerson;
}
mergeObjectsDictionary.AddOrIgnore(primaryGroupPerson.Id, mergeObject);
}
}
else if (isGroupMemberEntityType)
{
foreach (var groupMember in qryEntity.AsNoTracking().OfType <GroupMember>())
{
var person = groupMember.Person;
person.AdditionalLavaFields = new Dictionary <string, object>();
foreach (var item in groupMember.ToDictionary())
{
if (item.Key == "Id")
{
person.AdditionalLavaFields.AddOrIgnore("GroupMemberId", item.Value);
}
else if (item.Key == "Guid")
{
person.AdditionalLavaFields.AddOrIgnore("GroupMemberGuid", item.Value.ToStringSafe());
}
else
{
person.AdditionalLavaFields.AddOrIgnore(item.Key, item.Value);
}
}
mergeObjectsDictionary.AddOrIgnore(groupMember.PersonId, person);
}
}
else
{
foreach (var item in qryEntity.AsNoTracking())
{
mergeObjectsDictionary.AddOrIgnore(item.Id, item);
}
}
}
var entitySetItemService = new EntitySetItemService(rockContext);
string[] emptyJson = new string[] { string.Empty, "{}" };
var entitySetItemMergeValuesQry = entitySetItemService.GetByEntitySetId(entitySetId, true).Where(a => !emptyJson.Contains(a.AdditionalMergeValuesJson));
if (fetchCount.HasValue)
{
entitySetItemMergeValuesQry = entitySetItemMergeValuesQry.Take(fetchCount.Value);
}
// the entityId to use for NonEntity objects
int nonEntityId = 1;
// now, add the additional MergeValues regardless of if the EntitySet contains IEntity items or just Non-IEntity items
foreach (var additionalMergeValuesItem in entitySetItemMergeValuesQry.AsNoTracking())
{
object mergeObject;
int entityId;
if (additionalMergeValuesItem.EntityId > 0)
{
entityId = additionalMergeValuesItem.EntityId;
}
else
{
// not pointing to an actual EntityId, so use the nonEntityId for ti
entityId = nonEntityId++;
}
if (mergeObjectsDictionary.ContainsKey(entityId))
{
mergeObject = mergeObjectsDictionary[entityId];
}
else
{
if (entitySet.EntityTypeId.HasValue)
{
// if already have real entities in our list, don't add additional items to the mergeObjectsDictionary
continue;
}
// non-Entity merge object, so just use Dictionary
mergeObject = new Dictionary <string, object>();
mergeObjectsDictionary.AddOrIgnore(entityId, mergeObject);
}
foreach (var additionalMergeValue in additionalMergeValuesItem.AdditionalMergeValues)
{
if (mergeObject is IEntity)
{
// add the additional fields to AdditionalLavaFields
IEntity mergeEntity = (mergeObject as IEntity);
mergeEntity.AdditionalLavaFields = mergeEntity.AdditionalLavaFields ?? new Dictionary <string, object>();
object mergeValueObject = additionalMergeValue.Value;
mergeEntity.AdditionalLavaFields.AddOrIgnore(additionalMergeValue.Key, mergeValueObject);
}
else if (mergeObject is IDictionary <string, object> )
{
// anonymous object with no fields yet
IDictionary <string, object> nonEntityObject = mergeObject as IDictionary <string, object>;
nonEntityObject.AddOrIgnore(additionalMergeValue.Key, additionalMergeValue.Value);
}
else
{
throw new Exception(string.Format("Unexpected MergeObject Type: {0}", mergeObject));
}
}
}
var result = mergeObjectsDictionary.Select(a => a.Value);
if (fetchCount.HasValue)
{
// make sure the result is limited to fetchCount (even though the above queries are also limited to fetch count)
result = result.Take(fetchCount.Value);
}
return(result.ToList());
}