/// <summary>
/// Executes the specified context.
/// </summary>
/// <param name="context">The context.</param>
public virtual void Execute( IJobExecutionContext context )
{
JobDataMap dataMap = context.JobDetail.JobDataMap;
var emailTemplateGuid = dataMap.GetString( "SystemEmail" ).AsGuidOrNull();
var dataViewGuid = dataMap.GetString( "DataView" ).AsGuidOrNull();
if( dataViewGuid != null && emailTemplateGuid != null )
{
var rockContext = new RockContext();
var dataView = new DataViewService( rockContext ).Get( (Guid)dataViewGuid );
List<IEntity> resultSet = null;
var errorMessages = new List<string>();
var dataTimeout = dataMap.GetString( "DatabaseTimeout" ).AsIntegerOrNull() ?? 180;
try
{
var qry = dataView.GetQuery( null, rockContext, dataTimeout, out errorMessages );
if( qry != null )
{
resultSet = qry.AsNoTracking().ToList();
}
}
catch( Exception exception )
{
ExceptionLogService.LogException( exception, HttpContext.Current );
while( exception != null )
{
if( exception is SqlException && (exception as SqlException).Number == -2 )
{
// if there was a SQL Server Timeout, have the warning be a friendly message about that.
errorMessages.Add( "This dataview did not complete in a timely manner. You can try again or adjust the timeout setting of this block." );
exception = exception.InnerException;
}
else
{
errorMessages.Add( exception.Message );
exception = exception.InnerException;
}
return;
}
}
var recipients = new List<RecipientData>();
if( resultSet.Any() )
{
foreach( Person person in resultSet )
{
var mergeFields = Lava.LavaHelper.GetCommonMergeFields( null );
mergeFields.Add( "Person", person );
recipients.Add( new RecipientData( person.Email, mergeFields ) );
}
}
var appRoot = GlobalAttributesCache.Read( rockContext ).GetValue( "ExternalApplicationRoot" );
Email.Send( (Guid)emailTemplateGuid, recipients, appRoot );
context.Result = string.Format( "{0} emails sent", recipients.Count() );
}
}
/// <summary>
/// Job that will sync groups.
///
/// Called by the <see cref="IScheduler" /> when a
/// <see cref="ITrigger" /> fires that is associated with
/// the <see cref="IJob" />.
/// </summary>
public virtual void Execute( IJobExecutionContext context )
{
JobDataMap dataMap = context.JobDetail.JobDataMap;
try
{
// get groups set to sync
RockContext rockContext = new RockContext();
GroupService groupService = new GroupService( rockContext );
var groupsThatSync = groupService.Queryable().Where( g => g.SyncDataViewId != null ).ToList();
foreach ( var syncGroup in groupsThatSync )
{
GroupMemberService groupMemberService = new GroupMemberService( rockContext );
var syncSource = new DataViewService( rockContext ).Get( syncGroup.SyncDataViewId.Value );
// ensure this is a person dataview
bool isPersonDataSet = syncSource.EntityTypeId == EntityTypeCache.Read( typeof( Rock.Model.Person ) ).Id;
if ( isPersonDataSet )
{
SortProperty sortById = new SortProperty();
sortById.Property = "Id";
sortById.Direction = System.Web.UI.WebControls.SortDirection.Ascending;
List<string> errorMessages = new List<string>();
var sourceItems = syncSource.GetQuery( sortById, 180, out errorMessages ).Select( q => q.Id ).ToList();
var targetItems = groupMemberService.Queryable("Person").Where( gm => gm.GroupId == syncGroup.Id ).ToList();
// delete items from the target not in the source
foreach ( var targetItem in targetItems.Where( t => !sourceItems.Contains( t.PersonId ) ) )
{
// made a clone of the person as it will be detached when the group member is deleted. Also
// saving the delete before the email is sent in case an exception occurs so the user doesn't
// get an email everytime the agent runs.
Person recipient = (Person)targetItem.Person.Clone();
groupMemberService.Delete( targetItem );
rockContext.SaveChanges();
if ( syncGroup.ExitSystemEmailId.HasValue )
{
SendExitEmail( syncGroup.ExitSystemEmailId.Value, recipient, syncGroup );
}
}
// add items not in target but in the source
foreach ( var sourceItem in sourceItems.Where( s => !targetItems.Select( t => t.PersonId ).Contains( s ) ) )
{
// add source to target
var newGroupMember = new GroupMember { Id = 0 };
newGroupMember.PersonId = sourceItem;
newGroupMember.Group = syncGroup;
newGroupMember.GroupMemberStatus = GroupMemberStatus.Active;
newGroupMember.GroupRoleId = syncGroup.GroupType.DefaultGroupRoleId ?? syncGroup.GroupType.Roles.FirstOrDefault().Id;
groupMemberService.Add( newGroupMember );
if ( syncGroup.WelcomeSystemEmailId.HasValue )
{
SendWelcomeEmail( syncGroup.WelcomeSystemEmailId.Value, sourceItem, syncGroup, syncGroup.AddUserAccountsDuringSync ?? false );
}
}
rockContext.SaveChanges();
}
}
}
catch ( System.Exception ex )
{
HttpContext context2 = HttpContext.Current;
ExceptionLogService.LogException( ex, context2 );
throw ex;
}
}
public DataSet GetContributionPersonGroupAddress( [FromBody]ContributionStatementOptions options )
{
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add( "startDate", options.StartDate );
if ( options.EndDate.HasValue )
{
parameters.Add( "endDate", options.EndDate.Value );
}
else
{
parameters.Add( "endDate", DateTime.MaxValue );
}
if ( options.AccountIds != null )
{
parameters.Add( "accountIds", options.AccountIds.AsDelimited( "," ) );
}
else
{
parameters.Add( "accountIds", DBNull.Value );
}
if ( options.PersonId.HasValue )
{
parameters.Add( "personId", options.PersonId );
}
else
{
parameters.Add( "personId", DBNull.Value );
}
if ( options.IncludeIndividualsWithNoAddress )
{
parameters.Add( "includeIndividualsWithNoAddress", options.IncludeIndividualsWithNoAddress );
}
else
{
parameters.Add( "includeIndividualsWithNoAddress", false );
}
parameters.Add( "orderByPostalCode", options.OrderByPostalCode );
var result = DbService.GetDataSet( "spFinance_ContributionStatementQuery", System.Data.CommandType.StoredProcedure, parameters );
if ( result.Tables.Count > 0 )
{
var dataTable = result.Tables[0];
dataTable.TableName = "contribution_person_group_address";
if ( options.DataViewId.HasValue )
{
var dataView = new DataViewService( new RockContext() ).Get( options.DataViewId.Value );
if ( dataView != null )
{
List<string> errorMessages = new List<string>();
var personList = dataView.GetQuery( null, null, out errorMessages ).OfType<Rock.Model.Person>().Select( a => new { a.Id, a.GivingGroupId } ).ToList();
HashSet<int> personIds = new HashSet<int>( personList.Select( a => a.Id ) );
HashSet<int> groupsIds = new HashSet<int>( personList.Where( a => a.GivingGroupId.HasValue ).Select( a => a.GivingGroupId.Value ).Distinct() );
foreach ( var row in dataTable.Rows.OfType<DataRow>().ToList() )
{
var personId = row["PersonId"];
var groupId = row["GroupId"];
if ( personId != null && personId is int )
{
if ( !personIds.Contains( ( int ) personId ) )
{
dataTable.Rows.Remove( row );
}
}
else if ( groupId != null && groupId is int )
{
if ( !groupsIds.Contains( ( int ) groupId ) )
{
dataTable.Rows.Remove( row );
}
}
}
}
}
}
return result;
}