/// <summary>
/// Handles the Click event of the btnSave 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 btnSave_Click( object sender, EventArgs e )
{
ConnectionOpportunity connectionOpportunity = null;
using ( RockContext rockContext = new RockContext() )
{
int? groupTypeId = ddlGroupType.SelectedValueAsInt();
if ( groupTypeId.HasValue && GroupsState.Any( g => g.Group.GroupTypeId != groupTypeId.Value ) )
{
var groupType = new GroupTypeService( rockContext ).Get( groupTypeId.Value );
if ( groupType != null )
{
nbInvalidGroupTypes.Text = string.Format( "<p>One or more of the selected groups is not a <strong>{0}</strong> type. Please select groups that have a group type of <strong>{0}</strong>.", groupType.Name );
nbInvalidGroupTypes.Visible = true;
return;
}
}
ConnectionOpportunityService connectionOpportunityService = new ConnectionOpportunityService( rockContext );
EventCalendarItemService eventCalendarItemService = new EventCalendarItemService( rockContext );
ConnectionWorkflowService connectionWorkflowService = new ConnectionWorkflowService( rockContext );
ConnectionOpportunityConnectorGroupService connectionOpportunityConnectorGroupsService = new ConnectionOpportunityConnectorGroupService( rockContext );
ConnectionOpportunityCampusService connectionOpportunityCampusService = new ConnectionOpportunityCampusService( rockContext );
ConnectionOpportunityGroupService connectionOpportunityGroupService = new ConnectionOpportunityGroupService( rockContext );
int connectionOpportunityId = hfConnectionOpportunityId.ValueAsInt();
if ( connectionOpportunityId != 0 )
{
connectionOpportunity = connectionOpportunityService
.Queryable( "ConnectionOpportunityGroups, ConnectionWorkflows" )
.Where( ei => ei.Id == connectionOpportunityId )
.FirstOrDefault();
}
if ( connectionOpportunity == null )
{
connectionOpportunity = new ConnectionOpportunity();
connectionOpportunity.Name = string.Empty;
connectionOpportunity.ConnectionTypeId = PageParameter( "ConnectionTypeId" ).AsInteger();
connectionOpportunityService.Add( connectionOpportunity );
}
connectionOpportunity.Name = tbName.Text;
connectionOpportunity.Description = tbDescription.Text;
connectionOpportunity.IsActive = cbIsActive.Checked;
connectionOpportunity.PublicName = tbPublicName.Text;
connectionOpportunity.IconCssClass = tbIconCssClass.Text;
connectionOpportunity.GroupTypeId = ddlGroupType.SelectedValue.AsInteger();
connectionOpportunity.GroupMemberRoleId = ddlGroupRole.SelectedValue.AsInteger();
connectionOpportunity.GroupMemberStatus = ddlGroupMemberStatus.SelectedValueAsEnum<GroupMemberStatus>();
int? orphanedPhotoId = null;
if ( imgupPhoto.BinaryFileId != null )
{
if ( connectionOpportunity.PhotoId != imgupPhoto.BinaryFileId )
{
orphanedPhotoId = connectionOpportunity.PhotoId;
}
connectionOpportunity.PhotoId = imgupPhoto.BinaryFileId.Value;
}
// remove any workflows that removed in the UI
var uiWorkflows = WorkflowsState.Where( w => w.ConnectionTypeId == null ).Select( l => l.Guid );
foreach ( var connectionOpportunityWorkflow in connectionOpportunity.ConnectionWorkflows.Where( l => !uiWorkflows.Contains( l.Guid ) ).ToList() )
{
connectionOpportunity.ConnectionWorkflows.Remove( connectionOpportunityWorkflow );
connectionWorkflowService.Delete( connectionOpportunityWorkflow );
}
// Add or Update workflows from the UI
foreach ( ConnectionWorkflow connectionOpportunityWorkflowState in WorkflowsState.Where( w => w.ConnectionTypeId == null ) )
{
ConnectionWorkflow connectionOpportunityWorkflow = connectionOpportunity.ConnectionWorkflows.Where( a => a.Guid == connectionOpportunityWorkflowState.Guid ).FirstOrDefault();
if ( connectionOpportunityWorkflow == null )
{
connectionOpportunityWorkflow = new ConnectionWorkflow();
connectionOpportunity.ConnectionWorkflows.Add( connectionOpportunityWorkflow );
}
connectionOpportunityWorkflow.CopyPropertiesFrom( connectionOpportunityWorkflowState );
connectionOpportunityWorkflow.ConnectionOpportunityId = connectionOpportunity.Id;
}
// remove any group campuses that removed in the UI
var uiGroupCampuses = GroupCampusesState.Select( l => l.Guid );
foreach ( var connectionOpportunityConnectorGroups in connectionOpportunity.ConnectionOpportunityConnectorGroups.Where( l => !uiGroupCampuses.Contains( l.Guid ) ).ToList() )
{
connectionOpportunity.ConnectionOpportunityConnectorGroups.Remove( connectionOpportunityConnectorGroups );
connectionOpportunityConnectorGroupsService.Delete( connectionOpportunityConnectorGroups );
}
// Add or Update group campuses from the UI
foreach ( var connectionOpportunityConnectorGroupsState in GroupCampusesState )
{
ConnectionOpportunityConnectorGroup connectionOpportunityConnectorGroups = connectionOpportunity.ConnectionOpportunityConnectorGroups.Where( a => a.Guid == connectionOpportunityConnectorGroupsState.Guid ).FirstOrDefault();
if ( connectionOpportunityConnectorGroups == null )
{
connectionOpportunityConnectorGroups = new ConnectionOpportunityConnectorGroup();
connectionOpportunity.ConnectionOpportunityConnectorGroups.Add( connectionOpportunityConnectorGroups );
}
connectionOpportunityConnectorGroups.CopyPropertiesFrom( connectionOpportunityConnectorGroupsState );
}
// remove any campuses that removed in the UI
var uiCampuses = cblCampus.SelectedValuesAsInt;
foreach ( var connectionOpportunityCampus in connectionOpportunity.ConnectionOpportunityCampuses.Where( c => !uiCampuses.Contains( c.CampusId ) ).ToList() )
{
connectionOpportunity.ConnectionOpportunityCampuses.Remove( connectionOpportunityCampus );
connectionOpportunityCampusService.Delete( connectionOpportunityCampus );
}
// Add or Update campuses from the UI
foreach ( var campusId in uiCampuses )
{
ConnectionOpportunityCampus connectionOpportunityCampus = connectionOpportunity.ConnectionOpportunityCampuses.Where( c => c.CampusId == campusId ).FirstOrDefault();
if ( connectionOpportunityCampus == null )
{
connectionOpportunityCampus = new ConnectionOpportunityCampus();
connectionOpportunity.ConnectionOpportunityCampuses.Add( connectionOpportunityCampus );
}
connectionOpportunityCampus.CampusId = campusId;
}
// Remove any groups that were removed in the UI
var uiGroups = GroupsState.Select( r => r.Guid );
foreach ( var connectionOpportunityGroup in connectionOpportunity.ConnectionOpportunityGroups.Where( r => !uiGroups.Contains( r.Guid ) ).ToList() )
{
connectionOpportunity.ConnectionOpportunityGroups.Remove( connectionOpportunityGroup );
connectionOpportunityGroupService.Delete( connectionOpportunityGroup );
}
// Add or Update groups from the UI
foreach ( var connectionOpportunityGroupState in GroupsState )
{
ConnectionOpportunityGroup connectionOpportunityGroup = connectionOpportunity.ConnectionOpportunityGroups.Where( a => a.Guid == connectionOpportunityGroupState.Guid ).FirstOrDefault();
if ( connectionOpportunityGroup == null )
{
connectionOpportunityGroup = new ConnectionOpportunityGroup();
connectionOpportunity.ConnectionOpportunityGroups.Add( connectionOpportunityGroup );
}
connectionOpportunityGroup.CopyPropertiesFrom( connectionOpportunityGroupState );
}
connectionOpportunity.LoadAttributes();
Rock.Attribute.Helper.GetEditValues( phAttributes, connectionOpportunity );
if ( !Page.IsValid )
{
return;
}
if ( !connectionOpportunity.IsValid )
{
// Controls will render the error messages
return;
}
// use WrapTransaction since SaveAttributeValues does it's own RockContext.SaveChanges()
rockContext.WrapTransaction( () =>
{
rockContext.SaveChanges();
connectionOpportunity.SaveAttributeValues( rockContext );
if ( orphanedPhotoId.HasValue )
{
BinaryFileService binaryFileService = new BinaryFileService( rockContext );
var binaryFile = binaryFileService.Get( orphanedPhotoId.Value );
if ( binaryFile != null )
{
string errorMessage;
if ( binaryFileService.CanDelete( binaryFile, out errorMessage ) )
{
binaryFileService.Delete( binaryFile );
rockContext.SaveChanges();
}
}
}
} );
var qryParams = new Dictionary<string, string>();
qryParams["ConnectionTypeId"] = PageParameter( "ConnectionTypeId" );
NavigateToParentPage( qryParams );
}
}
/// <summary>
/// Translates the contact form data.
/// </summary>
/// <param name="tableData">The table data.</param>
/// <param name="totalRows">The total rows.</param>
public void TranslateContactFormData(IQueryable <Row> tableData, long totalRows = 0)
{
var lookupContext = new RockContext();
var importedCommunicationCount = new CommunicationService(lookupContext).Queryable().Count(c => c.ForeignKey != null);
var importedNoteCount = new NoteService(lookupContext).Queryable().Count(n => n.ForeignKey != null);
// Involvement Connection Type
var defaultConnectionType = new ConnectionTypeService(lookupContext).Get("DD565087-A4BE-4943-B123-BF22777E8426".AsGuid());
var opportunities = new ConnectionOpportunityService(lookupContext).Queryable().ToList();
var statuses = new ConnectionStatusService(lookupContext).Queryable().ToList();
var noContactStatus = statuses.FirstOrDefault(s => s.Name.Equals("No Contact", StringComparison.InvariantCultureIgnoreCase));
var prayerRequestors = new Dictionary <int, Person>();
var communicationList = new List <Communication>();
var connectionList = new List <ConnectionRequest>();
var prayerList = new List <PrayerRequest>();
var noteList = new List <Note>();
if (totalRows == 0)
{
totalRows = tableData.Count();
}
var completedItems = 0;
var percentage = (totalRows - 1) / 100 + 1;
ReportProgress(0, $"Verifying contact items ({totalRows:N0} found, {importedNoteCount + importedCommunicationCount:N0} already exist).");
foreach (var row in tableData.Where(r => r != null))
{
// ContactFormData joins to IndividualContactNotes on ContactInstItemID
var itemForeignKey = row["ContactInstItemID"] as int?;
var householdId = row["HouseholdID"] as int?;
var itemIndividualId = row["ContactItemIndividualID"] as int?;
var individualId = row["ContactIndividualID"] as int?;
var createdDate = row["ContactActivityDate"] as DateTime?;
var modifiedDate = row["ContactDatetime"] as DateTime?;
var approvalDate = row["ContactFormLastUpdatedDate"] as DateTime?;
var itemType = row["ContactFormName"] as string;
var itemStatus = row["ContactStatus"] as string;
var itemCaption = row["ContactItemName"] as string;
var noteText1 = row["ContactNote"] as string;
var noteText2 = row["ContactItemNote"] as string;
var itemUserId = row["ContactItemAssignedUserID"] as int?;
var contactUserId = row["ContactAssignedUserID"] as int?;
var initialContactUserId = row["InitialContactCreatedByUserID"] as int?;
var isConfidential = row["IsContactItemConfidential"] as int?;
var itemText = !string.IsNullOrWhiteSpace(noteText1) ? $"{noteText1}<br>{noteText2}" : noteText2 ?? string.Empty;
// look up the person this contact form is for
var hasCaption = !string.IsNullOrWhiteSpace(itemCaption);
var personKeys = GetPersonKeys(itemIndividualId ?? individualId, householdId);
if (personKeys != null && (hasCaption || !string.IsNullOrWhiteSpace(itemText)))
{
var assignedUserId = itemUserId ?? contactUserId ?? initialContactUserId ?? 0;
var userPersonAliasId = PortalUsers.ContainsKey(assignedUserId) ? (int?)PortalUsers[assignedUserId] : null;
// 99% of the Email types have no other info
if (itemType.Equals("Email", StringComparison.CurrentCultureIgnoreCase))
{
// create the recipient list for this contact
var recipients = new List <CommunicationRecipient> {
new CommunicationRecipient {
SendDateTime = createdDate ?? modifiedDate,
Status = CommunicationRecipientStatus.Delivered,
PersonAliasId = personKeys.PersonAliasId,
CreatedDateTime = createdDate ?? modifiedDate,
CreatedByPersonAliasId = userPersonAliasId,
ModifiedByPersonAliasId = userPersonAliasId,
ForeignKey = personKeys.PersonForeignId.ToString(),
ForeignId = personKeys.PersonForeignId
}
};
// create an email record for this contact form
var emailSubject = !string.IsNullOrWhiteSpace(itemCaption) ? itemCaption.Left(100) : itemText.Left(100);
var communication = AddCommunication(lookupContext, EmailCommunicationMediumTypeId, emailSubject, itemText, false,
CommunicationStatus.Approved, recipients, false, createdDate ?? modifiedDate, itemForeignKey.ToString(), userPersonAliasId);
communicationList.Add(communication);
}
else if (itemType.EndsWith("Connection Card", StringComparison.CurrentCultureIgnoreCase))
{
// lookup connection opportunity
var opportunity = opportunities.FirstOrDefault(o => o.Name.Equals(itemType, StringComparison.InvariantCultureIgnoreCase) || (o.ForeignKey != null && o.ForeignKey.Equals(itemType, StringComparison.InvariantCultureIgnoreCase)));
if (opportunity == null)
{
opportunity = AddConnectionOpportunity(lookupContext, defaultConnectionType.Id, createdDate, itemType, string.Empty, true, itemForeignKey.ToString());
opportunities.Add(opportunity);
}
// create a connection request
var requestStatus = statuses.FirstOrDefault(s => s.Name.Equals(itemStatus, StringComparison.InvariantCultureIgnoreCase)) ?? noContactStatus;
var requestState = itemStatus.Equals("Closed", StringComparison.InvariantCultureIgnoreCase) ? ConnectionState.Connected : ConnectionState.Active;
var request = AddConnectionRequest(opportunity, itemForeignKey.ToString(), createdDate, modifiedDate, requestStatus.Id, requestState, !string.IsNullOrWhiteSpace(itemText) ? $"{itemCaption} - {itemText}" : itemCaption ?? string.Empty, approvalDate, personKeys.PersonAliasId, userPersonAliasId);
connectionList.Add(request);
}
else if (hasCaption && itemCaption.EndsWith("Prayer Request", StringComparison.CurrentCultureIgnoreCase))
{
// create a prayer request
Person requestor = null;
prayerRequestors.TryGetValue(personKeys.PersonId, out requestor);
if (requestor == null)
{
requestor = lookupContext.People.FirstOrDefault(p => p.Id.Equals(personKeys.PersonId));
prayerRequestors.Add(personKeys.PersonId, requestor);
}
var request = AddPrayerRequest(lookupContext, null, personKeys.PersonAliasId, requestor.FirstName, requestor.LastName, requestor.Email, itemText ?? itemCaption, string.Empty,
!itemStatus.Equals("Closed", StringComparison.CurrentCultureIgnoreCase), false, createdDate ?? modifiedDate, approvalDate, itemForeignKey.ToString(), userPersonAliasId);
if (request != null)
{
prayerList.Add(request);
}
}
else
{
//strip campus from type
var campusId = GetCampusId(itemType);
if (campusId.HasValue)
{
itemType = StripPrefix(itemType, campusId);
}
// create a note for this contact form
var note = AddEntityNote(lookupContext, PersonEntityTypeId, personKeys.PersonId, itemCaption, itemText, false, false, itemType,
null, false, createdDate ?? modifiedDate, itemForeignKey.ToString(), userPersonAliasId);
noteList.Add(note);
}
completedItems++;
if (completedItems % percentage < 1)
{
var percentComplete = completedItems / percentage;
ReportProgress(percentComplete, $"{completedItems:N0} contact items imported ({percentComplete}% complete).");
}
else if (completedItems % ReportingNumber < 1)
{
SaveCommunications(communicationList);
SaveConnectionRequests(connectionList);
SavePrayerRequests(prayerList);
SaveNotes(noteList);
ReportPartialProgress();
communicationList.Clear();
connectionList.Clear();
prayerList.Clear();
noteList.Clear();
}
}
}
if (communicationList.Any() || connectionList.Any() || noteList.Any())
{
SaveCommunications(communicationList);
SaveConnectionRequests(connectionList);
SavePrayerRequests(prayerList);
SaveNotes(noteList);
}
ReportProgress(100, $"Finished contact item import: {completedItems:N0} items imported.");
}
/// <summary>
/// Handles the Click event of the btnSave 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 btnSave_Click( object sender, EventArgs e )
{
ConnectionOpportunity connectionOpportunity = null;
using ( RockContext rockContext = new RockContext() )
{
if ( !ValidPlacementGroups() )
{
return;
}
ConnectionOpportunityService connectionOpportunityService = new ConnectionOpportunityService( rockContext );
EventCalendarItemService eventCalendarItemService = new EventCalendarItemService( rockContext );
ConnectionWorkflowService connectionWorkflowService = new ConnectionWorkflowService( rockContext );
ConnectionRequestWorkflowService connectionRequestWorkflowService = new ConnectionRequestWorkflowService( rockContext );
ConnectionOpportunityConnectorGroupService connectionOpportunityConnectorGroupsService = new ConnectionOpportunityConnectorGroupService( rockContext );
ConnectionOpportunityCampusService connectionOpportunityCampusService = new ConnectionOpportunityCampusService( rockContext );
ConnectionOpportunityGroupConfigService connectionOpportunityGroupConfigService = new ConnectionOpportunityGroupConfigService( rockContext );
ConnectionOpportunityGroupService connectionOpportunityGroupService = new ConnectionOpportunityGroupService( rockContext );
int connectionOpportunityId = hfConnectionOpportunityId.ValueAsInt();
if ( connectionOpportunityId != 0 )
{
connectionOpportunity = connectionOpportunityService
.Queryable( "ConnectionOpportunityGroups, ConnectionWorkflows" )
.Where( ei => ei.Id == connectionOpportunityId )
.FirstOrDefault();
}
if ( connectionOpportunity == null )
{
connectionOpportunity = new ConnectionOpportunity();
connectionOpportunity.Name = string.Empty;
connectionOpportunity.ConnectionTypeId = PageParameter( "ConnectionTypeId" ).AsInteger();
connectionOpportunityService.Add( connectionOpportunity );
}
connectionOpportunity.Name = tbName.Text;
connectionOpportunity.Summary = htmlSummary.Text;
connectionOpportunity.Description = htmlDescription.Text;
connectionOpportunity.IsActive = cbIsActive.Checked;
connectionOpportunity.PublicName = tbPublicName.Text;
connectionOpportunity.IconCssClass = tbIconCssClass.Text;
int? orphanedPhotoId = null;
if ( imgupPhoto.BinaryFileId != null )
{
if ( connectionOpportunity.PhotoId != imgupPhoto.BinaryFileId )
{
orphanedPhotoId = connectionOpportunity.PhotoId;
}
connectionOpportunity.PhotoId = imgupPhoto.BinaryFileId.Value;
}
// remove any workflows that removed in the UI
var uiWorkflows = WorkflowsState.Where( w => w.ConnectionTypeId == null ).Select( l => l.Guid );
foreach ( var connectionWorkflow in connectionOpportunity.ConnectionWorkflows.Where( l => !uiWorkflows.Contains( l.Guid ) ).ToList() )
{
foreach( var requestWorkflow in connectionRequestWorkflowService.Queryable()
.Where( w => w.ConnectionWorkflowId == connectionWorkflow.Id ) )
{
connectionRequestWorkflowService.Delete( requestWorkflow );
}
connectionOpportunity.ConnectionWorkflows.Remove( connectionWorkflow );
connectionWorkflowService.Delete( connectionWorkflow );
}
// Add or Update workflows from the UI
foreach ( var workflowTypeStateObj in WorkflowsState.Where( w => w.ConnectionTypeId == null ) )
{
ConnectionWorkflow connectionOpportunityWorkflow = connectionOpportunity.ConnectionWorkflows.Where( a => a.Guid == workflowTypeStateObj.Guid ).FirstOrDefault();
if ( connectionOpportunityWorkflow == null )
{
connectionOpportunityWorkflow = new ConnectionWorkflow();
connectionOpportunity.ConnectionWorkflows.Add( connectionOpportunityWorkflow );
}
connectionOpportunityWorkflow.Id = workflowTypeStateObj.Id;
connectionOpportunityWorkflow.Guid = workflowTypeStateObj.Guid;
connectionOpportunityWorkflow.ConnectionTypeId = workflowTypeStateObj.ConnectionTypeId;
connectionOpportunityWorkflow.WorkflowTypeId = workflowTypeStateObj.WorkflowTypeId;
connectionOpportunityWorkflow.TriggerType = workflowTypeStateObj.TriggerType;
connectionOpportunityWorkflow.QualifierValue = workflowTypeStateObj.QualifierValue;
connectionOpportunityWorkflow.ConnectionOpportunityId = connectionOpportunity.Id;
}
// remove any group campuses that removed in the UI
var uiConnectorGroups = ConnectorGroupsState.Select( l => l.Guid );
foreach ( var connectionOpportunityConnectorGroups in connectionOpportunity.ConnectionOpportunityConnectorGroups.Where( l => !uiConnectorGroups.Contains( l.Guid ) ).ToList() )
{
connectionOpportunity.ConnectionOpportunityConnectorGroups.Remove( connectionOpportunityConnectorGroups );
connectionOpportunityConnectorGroupsService.Delete( connectionOpportunityConnectorGroups );
}
// Add or Update group campuses from the UI
foreach ( var groupStateObj in ConnectorGroupsState )
{
ConnectionOpportunityConnectorGroup connectionOpportunityConnectorGroup = connectionOpportunity.ConnectionOpportunityConnectorGroups.Where( a => a.Guid == groupStateObj.Guid ).FirstOrDefault();
if ( connectionOpportunityConnectorGroup == null )
{
connectionOpportunityConnectorGroup = new ConnectionOpportunityConnectorGroup();
connectionOpportunity.ConnectionOpportunityConnectorGroups.Add( connectionOpportunityConnectorGroup );
}
connectionOpportunityConnectorGroup.CampusId = groupStateObj.CampusId;
connectionOpportunityConnectorGroup.ConnectorGroupId = groupStateObj.GroupId;
connectionOpportunityConnectorGroup.ConnectionOpportunityId = connectionOpportunity.Id;
}
// remove any campuses that removed in the UI
var uiCampuses = cblSelectedItemsAsInt( cblCampus );
foreach ( var connectionOpportunityCampus in connectionOpportunity.ConnectionOpportunityCampuses.Where( c => !uiCampuses.Contains( c.CampusId ) ).ToList() )
{
connectionOpportunity.ConnectionOpportunityCampuses.Remove( connectionOpportunityCampus );
connectionOpportunityCampusService.Delete( connectionOpportunityCampus );
}
// Add or Update campuses from the UI
foreach ( var campusId in uiCampuses )
{
ConnectionOpportunityCampus connectionOpportunityCampus = connectionOpportunity.ConnectionOpportunityCampuses.Where( c => c.CampusId == campusId ).FirstOrDefault();
if ( connectionOpportunityCampus == null )
{
connectionOpportunityCampus = new ConnectionOpportunityCampus();
connectionOpportunity.ConnectionOpportunityCampuses.Add( connectionOpportunityCampus );
}
connectionOpportunityCampus.CampusId = campusId;
connectionOpportunityCampus.DefaultConnectorPersonAliasId = DefaultConnectors.ContainsKey( campusId ) ? DefaultConnectors[campusId] : (int?)null;
}
// remove any group configs that were removed in the UI
var uiGroupConfigs = GroupConfigsState.Select( r => r.Guid );
foreach ( var connectionOpportunityGroupConfig in connectionOpportunity.ConnectionOpportunityGroupConfigs.Where( r => !uiGroupConfigs.Contains( r.Guid ) ).ToList() )
{
connectionOpportunity.ConnectionOpportunityGroupConfigs.Remove( connectionOpportunityGroupConfig );
connectionOpportunityGroupConfigService.Delete( connectionOpportunityGroupConfig );
}
// Add or Update group configs from the UI
foreach ( var groupConfigStateObj in GroupConfigsState )
{
ConnectionOpportunityGroupConfig connectionOpportunityGroupConfig = connectionOpportunity.ConnectionOpportunityGroupConfigs.Where( a => a.Guid == groupConfigStateObj.Guid ).FirstOrDefault();
if ( connectionOpportunityGroupConfig == null )
{
connectionOpportunityGroupConfig = new ConnectionOpportunityGroupConfig();
connectionOpportunity.ConnectionOpportunityGroupConfigs.Add( connectionOpportunityGroupConfig );
}
connectionOpportunityGroupConfig.GroupTypeId = groupConfigStateObj.GroupTypeId;
connectionOpportunityGroupConfig.GroupMemberRoleId = groupConfigStateObj.GroupMemberRoleId;
connectionOpportunityGroupConfig.GroupMemberStatus = groupConfigStateObj.GroupMemberStatus;
connectionOpportunityGroupConfig.UseAllGroupsOfType = groupConfigStateObj.UseAllGroupsOfType;
connectionOpportunityGroupConfig.ConnectionOpportunityId = connectionOpportunity.Id;
}
// Remove any groups that were removed in the UI
var uiGroups = GroupsState.Select( r => r.Guid );
foreach ( var connectionOpportunityGroup in connectionOpportunity.ConnectionOpportunityGroups.Where( r => !uiGroups.Contains( r.Guid ) ).ToList() )
{
connectionOpportunity.ConnectionOpportunityGroups.Remove( connectionOpportunityGroup );
connectionOpportunityGroupService.Delete( connectionOpportunityGroup );
}
// Add or Update groups from the UI
foreach ( var groupStateObj in GroupsState )
{
ConnectionOpportunityGroup connectionOpportunityGroup = connectionOpportunity.ConnectionOpportunityGroups.Where( a => a.Guid == groupStateObj.Guid ).FirstOrDefault();
if ( connectionOpportunityGroup == null )
{
connectionOpportunityGroup = new ConnectionOpportunityGroup();
connectionOpportunity.ConnectionOpportunityGroups.Add( connectionOpportunityGroup );
}
connectionOpportunityGroup.GroupId = groupStateObj.GroupId;
connectionOpportunityGroup.ConnectionOpportunityId = connectionOpportunity.Id;
}
connectionOpportunity.LoadAttributes();
Rock.Attribute.Helper.GetEditValues( phAttributes, connectionOpportunity );
if ( !Page.IsValid )
{
return;
}
if ( !connectionOpportunity.IsValid )
{
// Controls will render the error messages
return;
}
// use WrapTransaction since SaveAttributeValues does it's own RockContext.SaveChanges()
rockContext.WrapTransaction( () =>
{
rockContext.SaveChanges();
connectionOpportunity.SaveAttributeValues( rockContext );
if ( orphanedPhotoId.HasValue )
{
BinaryFileService binaryFileService = new BinaryFileService( rockContext );
var binaryFile = binaryFileService.Get( orphanedPhotoId.Value );
if ( binaryFile != null )
{
string errorMessage;
if ( binaryFileService.CanDelete( binaryFile, out errorMessage ) )
{
binaryFileService.Delete( binaryFile );
rockContext.SaveChanges();
}
}
}
} );
ConnectionWorkflowService.FlushCachedTriggers();
var qryParams = new Dictionary<string, string>();
qryParams["ConnectionTypeId"] = PageParameter( "ConnectionTypeId" );
NavigateToParentPage( qryParams );
}
}
/// <summary>
/// Loads the ConnectionRequests.
/// </summary>
/// <param name="csvData">The CSV data.</param>
private int LoadConnectionRequest(CSVInstance csvData)
{
var lookupContext = new RockContext();
var connectionTypes = new ConnectionTypeService(lookupContext).Queryable().ToList();
var activityTypes = new ConnectionActivityTypeService(lookupContext).Queryable().ToList();
var opportunities = new ConnectionOpportunityService(lookupContext).Queryable().ToList();
var statuses = new ConnectionStatusService(lookupContext).Queryable().ToList();
var requests = new ConnectionRequestService(lookupContext).Queryable().ToList();
var newRequests = new List <ConnectionRequest>();
var newActivities = new List <ConnectionRequestActivity>();
var completedItems = 0;
ReportProgress(0, string.Format("Verifying connection request import ({0:N0} already imported).", requests.Count(n => n.ForeignKey != null)));
ConnectionType connectionType = null;
ConnectionOpportunity opportunity = null;
string[] row;
// Uses a look-ahead enumerator: this call will move to the next record immediately
while ((row = csvData.Database.FirstOrDefault()) != null)
{
var oForeignKey = row[OpportunityForeignKey] as string;
var oName = row[OpportunityName] as string;
var cType = row[ConnectionType] as string;
var oDescription = row[OpportunityDescription] as string;
var oActive = row[OpportunityActive].AsBoolean();
var oCreatedDate = row[OpportunityCreated].AsDateTime();
var oModifiedDate = row[OpportunityModified].AsDateTime();
var rForeignKey = row[RequestForeignKey] as string;
var rPersonId = row[RequestPersonId].AsIntegerOrNull();
var rConnectorId = row[RequestConnectorId].AsIntegerOrNull();
var rCreatedDate = row[RequestCreated].AsDateTime();
var rModifiedDate = row[RequestModified].AsDateTime();
var rStatus = row[RequestStatus] as string;
var rState = row[RequestState].AsIntegerOrNull();
var rComments = row[RequestComments] as string;
var rFollowUp = row[RequestFollowUp].AsDateTime();
var aType = row[ActivityType] as string;
var aNote = row[ActivityNote] as string;
var aCreatedDate = row[ActivityDate].AsDateTime();
var aConnectorId = row[ActivityConnectorId].AsIntegerOrNull();
// lookup or reuse connection type
if (connectionType == null || !connectionType.Name.Equals(cType, StringComparison.OrdinalIgnoreCase))
{
connectionType = connectionTypes.FirstOrDefault(t => t.Name.Equals(cType, StringComparison.OrdinalIgnoreCase));
}
if (connectionType == null)
{
connectionType = AddConnectionType(lookupContext, cType);
connectionTypes.Add(connectionType);
}
if (connectionType != null && !string.IsNullOrWhiteSpace(oName) && GetPersonKeys(rPersonId) != null)
{
// lookup, reuse, or create connection opportunity
if (opportunity == null || !opportunity.ForeignKey.Equals(oForeignKey, StringComparison.OrdinalIgnoreCase))
{
opportunity = opportunities.FirstOrDefault(o => (o.ForeignKey != null && o.ForeignKey.Equals(oForeignKey, StringComparison.OrdinalIgnoreCase)) || o.Name.Equals(oName, StringComparison.OrdinalIgnoreCase));
}
if (opportunity == null)
{
opportunity = AddConnectionOpportunity(lookupContext, connectionType.Id, oCreatedDate, oName, oDescription, oActive, oForeignKey);
opportunities.Add(opportunity);
}
else if (opportunity.ForeignKey == null)
{
opportunity.ForeignKey = oForeignKey;
opportunity.ForeignId = oForeignKey.AsIntegerOrNull();
lookupContext.SaveChanges();
}
// lookup, reuse, or create connection request
var requestStatus = statuses.FirstOrDefault(s => s.Name.Equals(rStatus, StringComparison.OrdinalIgnoreCase) && s.ConnectionTypeId.HasValue && s.ConnectionTypeId.Value == connectionType.Id);
if (requestStatus == null)
{
requestStatus = AddConnectionStatus(lookupContext, rStatus, connectionType.Id);
statuses.Add(requestStatus);
}
var requestor = GetPersonKeys(rPersonId);
var requestConnector = rConnectorId.HasValue ? GetPersonKeys(rConnectorId) : null;
var request = requests.FirstOrDefault(r => r.ForeignKey != null && r.ForeignKey.Equals(rForeignKey, StringComparison.OrdinalIgnoreCase))
?? newRequests.FirstOrDefault(r => r.ForeignKey != null && r.ForeignKey.Equals(rForeignKey, StringComparison.OrdinalIgnoreCase));
if (request == null && requestor != null && requestStatus != null)
{
request = AddConnectionRequest(opportunity, rForeignKey, rCreatedDate, rModifiedDate, requestStatus.Id, ( ConnectionState )rState, rComments, rFollowUp, requestor.PersonAliasId, requestConnector?.PersonAliasId);
newRequests.Add(request);
}
// create activity
if (!string.IsNullOrWhiteSpace(aType))
{
var activityConnector = aConnectorId.HasValue ? GetPersonKeys(aConnectorId) : null;
var activityType = activityTypes.FirstOrDefault(t => t.Name.Equals(aType, StringComparison.OrdinalIgnoreCase));
if (request != null && activityType != null)
{
var activity = AddConnectionActivity(opportunity.Id, aNote, aCreatedDate, activityConnector?.PersonAliasId, activityType.Id, rForeignKey);
if (request.Id > 0)
{
activity.ConnectionRequestId = request.Id;
newActivities.Add(activity);
}
else
{
request.ConnectionRequestActivities.Add(activity);
}
}
}
completedItems++;
if (completedItems % (ReportingNumber * 10) < 1)
{
ReportProgress(0, string.Format("{0:N0} requests processed.", completedItems));
}
if (completedItems % ReportingNumber < 1)
{
SaveConnectionRequests(newRequests, newActivities);
ReportPartialProgress();
requests.AddRange(newRequests);
newRequests.Clear();
newActivities.Clear();
}
}
}
if (newRequests.Count > 0 || newActivities.Count > 0)
{
SaveConnectionRequests(newRequests, newActivities);
}
ReportProgress(100, string.Format("Finished connection request import: {0:N0} requests imported.", completedItems));
return(completedItems);
}
