/// <summary>
/// Shows the merge for entity set identifier.
/// </summary>
/// <param name="entitySetId">The entity set identifier.</param>
protected void ShowMergeForEntitySetId(int entitySetId)
{
hfEntitySetId.Value = entitySetId.ToString();
var rockContext = new RockContext();
var entitySetService = new EntitySetService(rockContext);
var entitySetItemsService = new EntitySetItemService(rockContext);
var entitySet = entitySetService.Get(entitySetId);
if (entitySet == null)
{
nbWarningMessage.Text = "Merge Records not found";
nbWarningMessage.Title = "Warning";
nbWarningMessage.NotificationBoxType = NotificationBoxType.Warning;
pnlEntry.Visible = false;
return;
}
if (entitySet.EntityTypeId.HasValue)
{
bool isPersonEntitySet = entitySet.EntityTypeId.Value == EntityTypeCache.GetId <Rock.Model.Person>();
bool isGroupMemberEntitySet = entitySet.EntityTypeId.Value == EntityTypeCache.GetId <Rock.Model.GroupMember>();
cbCombineFamilyMembers.Visible = isPersonEntitySet || isGroupMemberEntitySet;
}
else
{
cbCombineFamilyMembers.Visible = false;
}
int itemsCount = entitySetItemsService.Queryable().Where(a => a.EntitySetId == entitySetId).Count();
nbNumberOfRecords.Text = string.Format("There are {0} {1} to merge", itemsCount, "row".PluralizeIf(itemsCount != 1));
}
/// <summary>
/// Creates the connection requests.
/// </summary>
/// <param name="context">The context.</param>
/// <param name="campaignItem">The campaign item.</param>
/// <returns></returns>
private int CreateConnectionRequests(IJobExecutionContext context, CampaignItem campaignItem)
{
context.UpdateLastStatusMessage($"Processing create connection requests for {campaignItem.Name}");
// Skip creating connection requests if set to "AsNeeded" and DailyLimitAssigned is 0 or null
if (campaignItem.CreateConnectionRequestOption == CreateConnectionRequestOptions.AsNeeded &&
(campaignItem.DailyLimitAssigned <= 0 || campaignItem.DailyLimitAssigned == null))
{
return(0);
}
int recordsProcessed = 0;
var rockContext = new RockContext();
var connectionOpportunityService = new ConnectionOpportunityService(rockContext);
var personAliasService = new PersonAliasService(rockContext);
var entitySetItemService = new EntitySetItemService(rockContext);
var connectionOpportunity = connectionOpportunityService.Get(campaignItem.OpportunityGuid);
if (connectionOpportunity == null)
{
return(0);
}
// get cutoff for the last connection datetime.
var lastConnectionDateTime = RockDateTime.Now.AddDays(-campaignItem.DaysBetweenConnection);
// if DaysBetweenConnection is 0 then check for connection request for any time period.
if (campaignItem.DaysBetweenConnection == default(int))
{
lastConnectionDateTime = DateTime.MinValue;
}
var entitySetItemsQry = entitySetItemService
.Queryable()
.Where(a => a.EntitySetId == campaignItem.EntitySetId)
.OrderBy(a => a.Order);
bool autoAssignment = false;
var eligibleConnectors = new List <ConnectionConnector>();
if (campaignItem.DailyLimitAssigned.HasValue &&
campaignItem.DailyLimitAssigned != default(int))
{
autoAssignment = true;
eligibleConnectors = GetEligibleConnectorWithLimit(connectionOpportunity.Id, rockContext, campaignItem.DailyLimitAssigned.Value);
}
var connectionStatusId = GetConnectionStatus(connectionOpportunity);
if (!connectionStatusId.HasValue)
{
return(0);
}
var entitySetItemList = entitySetItemsQry.ToList();
foreach (var entitySetItem in entitySetItemList)
{
var entityItemPersonAlias = personAliasService.GetPrimaryAlias(entitySetItem.EntityId);
int?connectorPersonId = null;
if (autoAssignment)
{
connectorPersonId = GetConnector(campaignItem, connectionOpportunity, eligibleConnectors, entityItemPersonAlias, rockContext);
if (campaignItem.CreateConnectionRequestOption == CreateConnectionRequestOptions.AsNeeded && !connectorPersonId.HasValue)
{
continue;
}
}
// double check that they haven't already been added
var personAlreadyHasConnectionRequest = CampaignConnectionHelper.PersonAlreadyHasConnectionRequest(connectionOpportunity.Id, rockContext, lastConnectionDateTime, entitySetItem.EntityId);
if (personAlreadyHasConnectionRequest)
{
continue;
}
int?connectorPersonAliasId = null;
if (connectorPersonId.HasValue)
{
foreach (var connectionConnector in eligibleConnectors.Where(a => a.PersonId == connectorPersonId.Value))
{
connectorPersonAliasId = connectionConnector.PersonAliasId;
connectionConnector.Current += 1;
}
}
CreateConnectionRequest(entityItemPersonAlias, campaignItem.RequestCommentsLavaTemplate, connectionOpportunity.Id, connectionStatusId, connectorPersonAliasId, rockContext);
recordsProcessed += 1;
}
return(recordsProcessed);
}
/// <summary>
/// Assigns the connection requests from the SelectedCampaign's entity set.
/// </summary>
/// <param name="rockContext">The rock context.</param>
/// <param name="selectedCampaignItem">The selected campaign item.</param>
/// <param name="numberOfRequestsRemaining">The number of requests remaining.</param>
/// <param name="connectorPerson">The connector person.</param>
private static void AssignConnectionRequestsFromEntitySet(RockContext rockContext, CampaignItem selectedCampaignItem, ref int numberOfRequestsRemaining, Person connectorPerson)
{
var opportunityService = new ConnectionOpportunityService(rockContext);
ConnectionOpportunity opportunity = opportunityService.Get(selectedCampaignItem.OpportunityGuid);
if (opportunity == null || !opportunity.IsActive)
{
return;
}
int?defaultStatusId = opportunity.ConnectionType.ConnectionStatuses
.Where(s => s.IsDefault)
.Select(s => ( int? )s.Id)
.FirstOrDefault();
// If opportunity doesn't have a default status, something is wrong
if (defaultStatusId == null)
{
return;
}
var connectorCampusIds = GetConnectorCampusIds(selectedCampaignItem, connectorPerson);
var connectionRequestService = new ConnectionRequestService(rockContext);
var connectionRequestActivityService = new ConnectionRequestActivityService(rockContext);
// get previous connections for the connector that have the same campus of the connector, or if the person's campus or connector person's campus is null
var previousConnectedPersonIdsForCurrentPerson = connectionRequestService.Queryable()
.Where(a => a.ConnectionOpportunityId == opportunity.Id)
.Where(a => a.ConnectorPersonAlias.PersonId == connectorPerson.Id)
.Where(a => (a.CampusId == null) || connectorCampusIds.Any(connectorCampusId => connectorCampusId == null || a.CampusId.Value == connectorCampusId))
.Select(a => a.PersonAlias.PersonId).Distinct().ToList();
var entitySetId = CampaignConnectionHelper.GetEntitySet(selectedCampaignItem);
var entitySetItemService = new EntitySetItemService(rockContext);
var entitySetItemList = entitySetItemService.Queryable().Where(a => a.EntitySetId == entitySetId).OrderBy(a => a.Order).Select(a => new
{
PersonId = a.EntityId,
EntityItemOrder = a.Order
}).ToList();
if (selectedCampaignItem.PreferPreviousConnector)
{
// sort them by any where the current person was assigned to this person before
entitySetItemList = entitySetItemList
.OrderBy(a => previousConnectedPersonIdsForCurrentPerson.Any(x => x == a.PersonId))
.ThenBy(a => a.EntityItemOrder).ToList();
}
else
{
entitySetItemList = entitySetItemList.OrderBy(a => a.EntityItemOrder).ToList();
}
var personService = new PersonService(rockContext);
// get the last connection datetime.
var lastConnectionDateTime = RockDateTime.Now.AddDays(-selectedCampaignItem.DaysBetweenConnection);
// if DaysBetweenConnection is 0 then check for connection request for any time period.
if (selectedCampaignItem.DaysBetweenConnection == default(int))
{
lastConnectionDateTime = DateTime.MinValue;
}
foreach (var entitySetItem in entitySetItemList)
{
var entitySetPerson = personService.Get(entitySetItem.PersonId);
if (entitySetPerson == null)
{
continue;
}
var entitySetPersonPrimaryCampusId = entitySetPerson.PrimaryCampusId;
bool validCampus = IsValidCampus(connectorCampusIds, entitySetPersonPrimaryCampusId);
if (!validCampus)
{
continue;
}
// double check that they haven't already been added
bool personAlreadyHasConnectionRequest = PersonAlreadyHasConnectionRequest(opportunity.Id, rockContext, lastConnectionDateTime, entitySetPerson.Id);
if (personAlreadyHasConnectionRequest)
{
continue;
}
var connectionRequest = new ConnectionRequest();
connectionRequest.ConnectionOpportunityId = opportunity.Id;
/*
* 3/30/2020 - NA
*
* When setting the connection request's Requester, we have to use the PrimaryAlias
* to set the connectionRequest.PersonAlias property because the ConnectionRequestChangeTransaction
* https://github.com/SparkabilityGroup/Rock/blob/a556a9285b7fdfe5594441286242f4feaa5847f2/Rock/Transactions/ConnectionRequestChangeTransaction.cs#L123
* (which handles triggered workflows) expects it. Also, it needs to be tracked by
* the current rockContext... hence the change from GetAsNoTracking() to just Get() above:
* var entitySetPerson = personService.Get( entitySetItem.PersonId );
*
* In other words, this will not work correctly:
* connectionRequest.PersonAliasId = entitySetPerson.PrimaryAliasId.Value;
*
* Reason: This plug-in cannot change Rock core assembly code.
*/
connectionRequest.PersonAlias = entitySetPerson.PrimaryAlias;
connectionRequest.ConnectionState = ConnectionState.Active;
connectionRequest.ConnectorPersonAliasId = connectorPerson.PrimaryAliasId;
connectionRequest.CampusId = entitySetPersonPrimaryCampusId;
connectionRequest.ConnectionStatusId = defaultStatusId.Value;
if (selectedCampaignItem.RequestCommentsLavaTemplate.IsNotNullOrWhiteSpace())
{
var mergeFields = new Dictionary <string, object>();
mergeFields.Add("Person", entitySetPerson);
mergeFields.Add("Family", entitySetPerson.GetFamily());
connectionRequest.Comments = selectedCampaignItem.RequestCommentsLavaTemplate.ResolveMergeFields(mergeFields);
}
connectionRequestService.Add(connectionRequest);
var connectionActivityTypeAssignedGuid = Rock.SystemGuid.ConnectionActivityType.ASSIGNED.AsGuid();
int?assignedActivityId = new ConnectionActivityTypeService(rockContext).GetId(connectionActivityTypeAssignedGuid);
if (assignedActivityId.HasValue)
{
var connectionRequestActivity = new ConnectionRequestActivity();
connectionRequestActivity.ConnectionRequest = connectionRequest;
connectionRequestActivity.ConnectionOpportunityId = connectionRequest.ConnectionOpportunityId;
connectionRequestActivity.ConnectionActivityTypeId = assignedActivityId.Value;
connectionRequestActivity.ConnectorPersonAliasId = connectorPerson.PrimaryAliasId;
connectionRequestActivityService.Add(connectionRequestActivity);
}
numberOfRequestsRemaining--;
if (numberOfRequestsRemaining <= 0)
{
break;
}
}
}
/// <summary>
/// Creates the connection requests.
/// </summary>
/// <param name="context">The context.</param>
/// <param name="campaignItem">The campaign item.</param>
/// <returns></returns>
private int CreateConnectionRequests(IJobExecutionContext context, CampaignItem campaignItem)
{
context.UpdateLastStatusMessage($"Processing create connection requests for {campaignItem.Name}");
// Skip creating connection requests if set to "AsNeeded" and DailyLimitAssigned is 0 or null
if (campaignItem.CreateConnectionRequestOption == CreateConnectionRequestOptions.AsNeeded &&
(campaignItem.DailyLimitAssigned <= 0 || campaignItem.DailyLimitAssigned == null))
{
return(0);
}
int recordsProcessed = 0;
var rockContext = new RockContext();
var connectionOpportunityService = new ConnectionOpportunityService(rockContext);
var personAliasService = new PersonAliasService(rockContext);
var connectionRequestService = new ConnectionRequestService(rockContext);
var connectionOpportunity = connectionOpportunityService.Get(campaignItem.OpportunityGuid);
if (connectionOpportunity == null)
{
return(0);
}
// get cutoff for the last connection datetime.
var lastConnectionDateTime = RockDateTime.Now.AddDays(-campaignItem.DaysBetweenConnection);
// if DaysBetweenConnection is 0 then check for connection request for any time period.
if (campaignItem.DaysBetweenConnection == default(int))
{
lastConnectionDateTime = DateTime.MinValue;
}
var entitySetItemService = new EntitySetItemService(rockContext);
var entitySetItemsQry = entitySetItemService
.Queryable()
.Where(a => a.EntitySetId == campaignItem.EntitySetId)
.OrderBy(a => a.Order);
bool autoAssignment = false;
var eligibleConnectors = new List <ConnectionConnector>();
if (campaignItem.CreateConnectionRequestOption == CreateConnectionRequestOptions.AsNeeded &&
campaignItem.DailyLimitAssigned.HasValue &&
campaignItem.DailyLimitAssigned != default(int))
{
autoAssignment = true;
eligibleConnectors = GetEligibleConnectorWithLimit(connectionOpportunity.Id, rockContext, campaignItem.DailyLimitAssigned.Value);
}
int?connectionStatusId = connectionOpportunity.ConnectionType.ConnectionStatuses
.Where(s => s.IsDefault)
.Select(s => ( int? )s.Id)
.FirstOrDefault();
// If opportunity doesn't have a default status, something is wrong
if (connectionStatusId == null)
{
ExceptionLogService.LogException(new Exception($"Unable to determine default connection status for {connectionOpportunity.Name} while processing campaigns", null));
return(0);
}
var dayofWeek = RockDateTime.Now.DayOfWeek;
var entitySetItemList = entitySetItemsQry.ToList();
foreach (var entitySetItem in entitySetItemList)
{
var personAlias = personAliasService.GetPrimaryAlias(entitySetItem.EntityId);
var defaultCampus = personAlias.Person.GetCampus();
int?connectorPersonAliasId = null;
if (autoAssignment)
{
int?connectorPersonId = null;
if (campaignItem.PreferPreviousConnector)
{
var personIds = eligibleConnectors
.Where(a => a.Limit - a.Current > 0 &&
(!a.DaysOfWeek.Any() || a.DaysOfWeek.Contains(dayofWeek)) &&
(!a.CampusId.HasValue || (a.CampusId.HasValue && defaultCampus != null && defaultCampus.Id == a.CampusId.Value)))
.Select(a => a.PersonId)
.ToList();
if (personIds.Any())
{
var person = connectionRequestService
.Queryable()
.Where(a => a.ConnectionOpportunityId == connectionOpportunity.Id &&
a.PersonAlias.PersonId == personAlias.PersonId &&
a.ConnectionState == ConnectionState.Connected &&
a.ConnectorPersonAliasId.HasValue &&
personIds.Contains(a.ConnectorPersonAlias.PersonId))
.Select(a => a.ConnectorPersonAlias.Person)
.FirstOrDefault();
if (person != null)
{
connectorPersonId = person.Id;
}
}
}
if (!connectorPersonId.HasValue)
{
var eligibleConnector = eligibleConnectors
.Where(a => a.Limit - a.Current > 0 &&
(!a.DaysOfWeek.Any() || a.DaysOfWeek.Contains(dayofWeek)) &&
(!a.CampusId.HasValue || (a.CampusId.HasValue && defaultCampus != null && defaultCampus.Id == a.CampusId.Value)))
.OrderBy(a => a.Current) // order from least assigned to most assigned
.ThenBy(x => Guid.NewGuid()) // and then randomize
.FirstOrDefault();
if (eligibleConnector != null)
{
connectorPersonId = eligibleConnector.PersonId;
}
}
if (!connectorPersonId.HasValue)
{
continue;
}
foreach (var connectionConnector in eligibleConnectors.Where(a => a.PersonId == connectorPersonId.Value))
{
connectorPersonAliasId = connectionConnector.PersonAliasId;
connectionConnector.Current += 1;
}
}
using (var insertRockContext = new RockContext())
{
try
{
/*
* 3/30/2020 - NA
*
* When setting the connection request's Requester, we have to use the PrimaryAlias
* to set the connectionRequest.PersonAlias property because the ConnectionRequestChangeTransaction
* https://github.com/SparkabilityGroup/Rock/blob/a556a9285b7fdfe5594441286242f4feaa5847f2/Rock/Transactions/ConnectionRequestChangeTransaction.cs#L123
* (which handles triggered workflows) expects it. Also, it needs to be tracked by
* the current rockContext...
*
* In other words, this will not work correctly:
* PersonAliasId = personAlias.Id,
*
* Reason: This plug-in cannot change Rock core assembly code.
*/
var personPrimaryAlias = new PersonAliasService(insertRockContext).GetPrimaryAlias(entitySetItem.EntityId);
var connectionRequestActivityService = new ConnectionRequestActivityService(insertRockContext);
var insertConnectionRequestService = new ConnectionRequestService(insertRockContext);
// double check that they haven't already been added
var personAlreadyHasConnectionRequest = CampaignConnectionHelper.PersonAlreadyHasConnectionRequest(connectionOpportunity.Id, rockContext, lastConnectionDateTime, entitySetItem.EntityId);
if (personAlreadyHasConnectionRequest)
{
continue;
}
var connectionRequest = new ConnectionRequest()
{
ConnectionOpportunityId = connectionOpportunity.Id,
PersonAlias = personPrimaryAlias,
ConnectionState = ConnectionState.Active,
ConnectorPersonAliasId = connectorPersonAliasId,
CampusId = defaultCampus?.Id,
ConnectionStatusId = connectionStatusId.Value,
};
if (campaignItem.RequestCommentsLavaTemplate.IsNotNullOrWhiteSpace())
{
var mergeFields = new Dictionary <string, object>();
mergeFields.Add("Person", personAlias.Person);
mergeFields.Add("Family", personAlias.Person.GetFamily());
connectionRequest.Comments = campaignItem.RequestCommentsLavaTemplate.ResolveMergeFields(mergeFields);
}
insertConnectionRequestService.Add(connectionRequest);
if (connectorPersonAliasId.HasValue)
{
var connectionActivityTypeAssignedGuid = Rock.SystemGuid.ConnectionActivityType.ASSIGNED.AsGuid();
int?assignedActivityId = new ConnectionActivityTypeService(rockContext).GetId(connectionActivityTypeAssignedGuid);
if (assignedActivityId.HasValue)
{
var connectionRequestActivity = new ConnectionRequestActivity();
connectionRequestActivity.ConnectionRequest = connectionRequest;
connectionRequestActivity.ConnectionOpportunityId = connectionRequest.ConnectionOpportunityId;
connectionRequestActivity.ConnectionActivityTypeId = assignedActivityId.Value;
connectionRequestActivity.ConnectorPersonAliasId = connectorPersonAliasId;
connectionRequestActivityService.Add(connectionRequestActivity);
}
}
insertRockContext.SaveChanges();
}
catch (Exception ex)
{
// Log exception and keep on trucking.
var exception = new Exception($"Exception occurred trying to create connection request:{personAlias.Id}.", ex);
createConnectionRequestExceptions.Add(exception);
ExceptionLogService.LogException(exception, null);
}
}
recordsProcessed += 1;
}
return(recordsProcessed);
}