/// <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 )
{
ConnectionType connectionType;
using ( var rockContext = new RockContext() )
{
if ( StatusesState.Any( s => s.IsDefault ) && ActivityTypesState.Any() )
{
ConnectionTypeService connectionTypeService = new ConnectionTypeService( rockContext );
ConnectionActivityTypeService connectionActivityTypeService = new ConnectionActivityTypeService( rockContext );
ConnectionStatusService connectionStatusService = new ConnectionStatusService( rockContext );
ConnectionWorkflowService connectionWorkflowService = new ConnectionWorkflowService( rockContext );
AttributeService attributeService = new AttributeService( rockContext );
AttributeQualifierService qualifierService = new AttributeQualifierService( rockContext );
int connectionTypeId = int.Parse( hfConnectionTypeId.Value );
if ( connectionTypeId == 0 )
{
connectionType = new ConnectionType();
connectionTypeService.Add( connectionType );
}
else
{
connectionType = connectionTypeService.Queryable( "ConnectionActivityTypes, ConnectionWorkflows" ).Where( c => c.Id == connectionTypeId ).FirstOrDefault();
var uiWorkflows = WorkflowsState.Select( l => l.Guid );
foreach ( var connectionWorkflow in connectionType.ConnectionWorkflows.Where( l => !uiWorkflows.Contains( l.Guid ) ).ToList() )
{
connectionType.ConnectionWorkflows.Remove( connectionWorkflow );
connectionWorkflowService.Delete( connectionWorkflow );
}
var uiActivityTypes = ActivityTypesState.Select( r => r.Guid );
foreach ( var connectionActivityType in connectionType.ConnectionActivityTypes.Where( r => !uiActivityTypes.Contains( r.Guid ) ).ToList() )
{
connectionType.ConnectionActivityTypes.Remove( connectionActivityType );
connectionActivityTypeService.Delete( connectionActivityType );
}
var uiStatuses = StatusesState.Select( r => r.Guid );
foreach ( var connectionStatus in connectionType.ConnectionStatuses.Where( r => !uiStatuses.Contains( r.Guid ) ).ToList() )
{
connectionType.ConnectionStatuses.Remove( connectionStatus );
connectionStatusService.Delete( connectionStatus );
}
}
connectionType.Name = tbName.Text;
connectionType.Description = tbDescription.Text;
connectionType.IconCssClass = tbIconCssClass.Text;
connectionType.DaysUntilRequestIdle = nbDaysUntilRequestIdle.Text.AsInteger();
connectionType.EnableFutureFollowup = cbFutureFollowUp.Checked;
connectionType.EnableFullActivityList = cbFullActivityList.Checked;
connectionType.RequiresPlacementGroupToConnect = cbRequiresPlacementGroup.Checked;
foreach ( var connectionActivityTypeState in ActivityTypesState )
{
ConnectionActivityType connectionActivityType = connectionType.ConnectionActivityTypes.Where( a => a.Guid == connectionActivityTypeState.Guid ).FirstOrDefault();
if ( connectionActivityType == null )
{
connectionActivityType = new ConnectionActivityType();
connectionType.ConnectionActivityTypes.Add( connectionActivityType );
}
connectionActivityType.CopyPropertiesFrom( connectionActivityTypeState );
}
foreach ( var connectionStatusState in StatusesState )
{
ConnectionStatus connectionStatus = connectionType.ConnectionStatuses.Where( a => a.Guid == connectionStatusState.Guid ).FirstOrDefault();
if ( connectionStatus == null )
{
connectionStatus = new ConnectionStatus();
connectionType.ConnectionStatuses.Add( connectionStatus );
}
connectionStatus.CopyPropertiesFrom( connectionStatusState );
connectionStatus.ConnectionTypeId = connectionType.Id;
}
foreach ( ConnectionWorkflow connectionWorkflowState in WorkflowsState )
{
ConnectionWorkflow connectionWorkflow = connectionType.ConnectionWorkflows.Where( a => a.Guid == connectionWorkflowState.Guid ).FirstOrDefault();
if ( connectionWorkflow == null )
{
connectionWorkflow = new ConnectionWorkflow();
connectionType.ConnectionWorkflows.Add( connectionWorkflow );
}
else
{
connectionWorkflowState.Id = connectionWorkflow.Id;
connectionWorkflowState.Guid = connectionWorkflow.Guid;
}
connectionWorkflow.CopyPropertiesFrom( connectionWorkflowState );
connectionWorkflow.ConnectionTypeId = connectionTypeId;
}
if ( !connectionType.IsValid )
{
// Controls will render the error messages
return;
}
// need WrapTransaction due to Attribute saves
rockContext.WrapTransaction( () =>
{
rockContext.SaveChanges();
/* Save Attributes */
string qualifierValue = connectionType.Id.ToString();
SaveAttributes( new ConnectionOpportunity().TypeId, "ConnectionTypeId", qualifierValue, AttributesState, rockContext );
connectionType = connectionTypeService.Get( connectionType.Id );
if ( connectionType != null )
{
if ( !connectionType.IsAuthorized( Authorization.VIEW, CurrentPerson ) )
{
connectionType.AllowPerson( Authorization.VIEW, CurrentPerson, rockContext );
}
if ( !connectionType.IsAuthorized( Authorization.EDIT, CurrentPerson ) )
{
connectionType.AllowPerson( Authorization.EDIT, CurrentPerson, rockContext );
}
if ( !connectionType.IsAuthorized( Authorization.ADMINISTRATE, CurrentPerson ) )
{
connectionType.AllowPerson( Authorization.ADMINISTRATE, CurrentPerson, rockContext );
}
}
} );
ConnectionWorkflowService.FlushCachedTriggers();
var qryParams = new Dictionary<string, string>();
qryParams["ConnectionTypeId"] = connectionType.Id.ToString();
NavigateToPage( RockPage.Guid, qryParams );
}
else
{
nbRequired.Visible = true;
}
}
}
/// <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);
}
