public Communication CreateEmailCommunication
(
List <string> recipientEmails,
string fromName,
string fromAddress,
string replyTo,
string subject,
string message,
bool bulkCommunication,
DateTime?sendDateTime,
CommunicationRecipientStatus recipientStatus = CommunicationRecipientStatus.Delivered,
int?senderPersonAliasId = null)
{
var recipients = new PersonService(( RockContext )Context)
.Queryable()
.Where(p => recipientEmails.Contains(p.Email))
.ToList();
return(this.CreateEmailCommunication(recipients.Select(a => new RockEmailMessageRecipient(a, null)).ToList(), fromName, fromAddress, replyTo, subject, message, bulkCommunication, sendDateTime, recipientStatus, senderPersonAliasId));
}
/// <summary>
/// Gets the expression.
/// </summary>
/// <param name="context">The context.</param>
/// <param name="entityIdProperty">The entity identifier property.</param>
/// <param name="selection">The selection.</param>
/// <returns></returns>
public override System.Linq.Expressions.Expression GetExpression( Data.RockContext context, System.Linq.Expressions.MemberExpression entityIdProperty, string selection )
{
bool showAsLink = this.GetAttributeValueFromSelection( "ShowAsLink", selection ).AsBooleanOrNull() ?? false;
int displayOrder = this.GetAttributeValueFromSelection( "DisplayOrder", selection ).AsIntegerOrNull() ?? 0;
var personQry = new PersonService( context ).Queryable();
IQueryable<string> personLinkQuery;
string basePersonUrl = System.Web.VirtualPathUtility.ToAbsolute( "~/Person/" );
if ( showAsLink )
{
// return string in format: <a href='/person/{personId}'>LastName, NickName</a>
if ( displayOrder == 0 )
{
personLinkQuery = personQry.Select( p => "<a href='" + basePersonUrl + p.Id.ToString() + "'>" + p.NickName + " " + p.LastName + "</a>" );
}
else
{
personLinkQuery = personQry.Select( p => "<a href='" + basePersonUrl + p.Id.ToString() + "'>" + p.LastName + ", " + p.NickName + "</a>" );
}
}
else
{
if ( displayOrder == 0 )
{
personLinkQuery = personQry.Select( p => p.NickName + " " + p.LastName );
}
else
{
personLinkQuery = personQry.Select( p => p.LastName + ", " + p.NickName );
}
}
return SelectExpressionExtractor.Extract( personLinkQuery, entityIdProperty, "p" );
}
private void DisplayResults()
{
RockContext rockContext = new RockContext();
var statementYear = RockDateTime.Now.Year;
if ( Request["StatementYear"] != null )
{
Int32.TryParse( Request["StatementYear"].ToString(), out statementYear );
}
FinancialTransactionDetailService financialTransactionDetailService = new FinancialTransactionDetailService( rockContext );
var qry = financialTransactionDetailService.Queryable().AsNoTracking()
.Where( t=> t.Transaction.AuthorizedPersonAlias.Person.GivingId == CurrentPerson.GivingId);
qry = qry.Where( t => t.Transaction.TransactionDateTime.Value.Year == statementYear );
if ( string.IsNullOrWhiteSpace( GetAttributeValue( "Accounts" ) ) )
{
qry = qry.Where( t => t.Account.IsTaxDeductible );
} else
{
var accountGuids = GetAttributeValue( "Accounts" ).Split( ',' ).Select( Guid.Parse ).ToList();
qry = qry.Where( t => accountGuids.Contains( t.Account.Guid ) );
}
qry = qry.OrderByDescending( t => t.Transaction.TransactionDateTime );
var mergeFields = new Dictionary<string, object>();
mergeFields.Add( "StatementStartDate", "1/1/" + statementYear.ToString() );
if ( statementYear == RockDateTime.Now.Year )
{
mergeFields.Add( "StatementEndDate", RockDateTime.Now );
}
else
{
mergeFields.Add( "StatementEndDate", "12/31/" + statementYear.ToString() );
}
var familyGroupTypeId = GroupTypeCache.Read( Rock.SystemGuid.GroupType.GROUPTYPE_FAMILY ).Id;
var groupMemberQry = new GroupMemberService( rockContext ).Queryable().Where( m => m.Group.GroupTypeId == familyGroupTypeId );
// get giving group members in order by family role (adult -> child) and then gender (male -> female)
var givingGroup = new PersonService( rockContext ).Queryable().AsNoTracking()
.Where( p => p.GivingId == CurrentPerson.GivingId )
.GroupJoin(
groupMemberQry,
p => p.Id,
m => m.PersonId,
(p, m) => new {p, m})
.SelectMany( x => x.m.DefaultIfEmpty(), (y,z) => new { Person = y.p, GroupMember = z} )
.Select( p => new { FirstName = p.Person.NickName, LastName = p.Person.LastName, FamilyRoleOrder = p.GroupMember.GroupRole.Order, Gender = p.Person.Gender, PersonId = p.Person.Id } )
.DistinctBy(p => p.PersonId)
.OrderBy(p => p.FamilyRoleOrder).ThenBy(p => p.Gender)
.ToList();
// make a list of person ids in the giving group
List<int> givingGroupIdsOnly = new List<int>();
foreach ( var x in givingGroup )
{
givingGroupIdsOnly.Add(x.PersonId);
}
string salutation = string.Empty;
if (givingGroup.GroupBy(g => g.LastName).Count() == 1 )
{
salutation = string.Join( ", ", givingGroup.Select( g => g.FirstName ) ) + " " + givingGroup.FirstOrDefault().LastName;
if ( salutation.Contains( "," ) )
{
salutation = salutation.ReplaceLastOccurrence( ",", " &" );
}
}
else
{
salutation = string.Join( ", ", givingGroup.Select( g => g.FirstName + " " + g.LastName ) );
if ( salutation.Contains( "," ) )
{
salutation = salutation.ReplaceLastOccurrence( ",", " &" );
}
}
mergeFields.Add( "Salutation", salutation );
var homeAddress = CurrentPerson.GetHomeLocation();
if ( homeAddress != null )
{
mergeFields.Add( "StreetAddress1", homeAddress.Street1 );
mergeFields.Add( "StreetAddress2", homeAddress.Street2 );
mergeFields.Add( "City", homeAddress.City );
mergeFields.Add( "State", homeAddress.State );
mergeFields.Add( "PostalCode", homeAddress.PostalCode );
mergeFields.Add( "Country", homeAddress.Country );
}
else
{
mergeFields.Add( "StreetAddress1", string.Empty );
mergeFields.Add( "StreetAddress2", string.Empty );
mergeFields.Add( "City", string.Empty );
mergeFields.Add( "State", string.Empty );
mergeFields.Add( "PostalCode", string.Empty );
mergeFields.Add( "Country", string.Empty );
}
mergeFields.Add( "TransactionDetails", qry.ToList() );
mergeFields.Add( "AccountSummary", qry.GroupBy( t => t.Account.Name ).Select( s => new AccountSummary { AccountName = s.Key, Total = s.Sum( a => a.Amount ), Order = s.Max(a => a.Account.Order) } ).OrderBy(s => s.Order ));
// pledge information
var pledges = new FinancialPledgeService( rockContext ).Queryable().AsNoTracking()
.Where(p =>
p.PersonAlias.Person.GivingId == CurrentPerson.GivingId
&& (p.StartDate.Year == statementYear || p.EndDate.Year == statementYear))
.GroupBy(p => p.Account)
.Select(g => new PledgeSummary {
AccountId = g.Key.Id,
AccountName = g.Key.Name,
AmountPledged = g.Sum( p => p.TotalAmount ),
PledgeStartDate = g.Min(p => p.StartDate),
PledgeEndDate = g.Max( p => p.EndDate)
} )
.ToList();
// add detailed pledge information
foreach(var pledge in pledges )
{
var adjustedPedgeEndDate = pledge.PledgeEndDate.Value.Date.AddHours( 23 ).AddMinutes( 59 ).AddSeconds( 59 );
pledge.AmountGiven = new FinancialTransactionDetailService( rockContext ).Queryable()
.Where( t =>
t.AccountId == pledge.AccountId
&& givingGroupIdsOnly.Contains(t.Transaction.AuthorizedPersonAlias.PersonId)
&& t.Transaction.TransactionDateTime >= pledge.PledgeStartDate
&& t.Transaction.TransactionDateTime <= adjustedPedgeEndDate )
.Sum( t => t.Amount );
pledge.AmountRemaining = (pledge.AmountGiven > pledge.AmountPledged) ? 0 : (pledge.AmountPledged - pledge.AmountGiven);
if ( pledge.AmountPledged > 0 )
{
var test = (double)pledge.AmountGiven / (double)pledge.AmountPledged;
pledge.PercentComplete = (int)((pledge.AmountGiven * 100) / pledge.AmountPledged);
}
}
mergeFields.Add( "Pledges", pledges );
var template = GetAttributeValue( "LavaTemplate" );
lResults.Text = template.ResolveMergeFields( mergeFields );
// show debug info
if ( GetAttributeValue( "EnableDebug" ).AsBoolean() && IsUserAuthorized( Authorization.EDIT ) )
{
lDebug.Visible = true;
lDebug.Text = mergeFields.lavaDebugInfo();
}
}
/// <summary>
/// Binds the grid.
/// </summary>
private void BindGrid()
{
var rockContext = new RockContext();
var recordTypeValueId = DefinedValueCache.Read( Rock.SystemGuid.DefinedValue.PERSON_RECORD_TYPE_BUSINESS.AsGuid() ).Id;
var queryable = new PersonService( rockContext ).Queryable()
.Where( q => q.RecordTypeValueId == recordTypeValueId );
var businessName = string.Empty;
bool viaSearch = false;
// Use the name passed in the page parameter if given
if ( !string.IsNullOrWhiteSpace( PageParameter( "SearchTerm" ) ) )
{
viaSearch = true;
gfBusinessFilter.Visible = false;
businessName = PageParameter( "SearchTerm" );
}
else
{
// Business Name Filter
businessName = gfBusinessFilter.GetUserPreference( "Business Name" );
}
if ( !string.IsNullOrWhiteSpace( businessName ) )
{
queryable = queryable.Where( a => a.LastName.Contains( businessName ) );
}
if ( ! viaSearch )
{
var activeRecordStatusValueId = DefinedValueCache.Read( Rock.SystemGuid.DefinedValue.PERSON_RECORD_STATUS_ACTIVE.AsGuid() ).Id;
string activeFilterValue = gfBusinessFilter.GetUserPreference( "Active Status" );
if ( activeFilterValue == "inactive" )
{
queryable = queryable.Where( b => b.RecordStatusValueId != activeRecordStatusValueId );
}
else if ( activeFilterValue == "active" )
{
queryable = queryable.Where( b => b.RecordStatusValueId == activeRecordStatusValueId );
}
SortProperty sortProperty = gBusinessList.SortProperty;
if ( sortProperty != null )
{
queryable = queryable.Sort( sortProperty );
}
else
{
queryable = queryable.OrderBy( q => q.LastName );
}
}
var groupMemberQuery = new GroupMemberService( rockContext ).Queryable();
var businessList = queryable.Select( b => new
{
Id = b.Id,
b.LastName,
BusinessName = b.LastName,
PhoneNumber = b.PhoneNumbers.FirstOrDefault().NumberFormatted,
Email = b.Email,
Address = b.Members
.Where( m => m.Group.GroupType.Guid.ToString() == Rock.SystemGuid.GroupType.GROUPTYPE_FAMILY )
.SelectMany( m => m.Group.GroupLocations )
.FirstOrDefault()
.Location,
Contacts = b.Members
.Where( m => m.Group.GroupType.Guid.ToString() == Rock.SystemGuid.GroupType.GROUPTYPE_KNOWN_RELATIONSHIPS )
.SelectMany( m => m.Group.Members)
.Where( p => p.GroupRole.Guid.ToString() == Rock.SystemGuid.GroupRole.GROUPROLE_KNOWN_RELATIONSHIPS_OWNER && p.PersonId != b.Id)
.Select( p => p.Person.LastName + ", " + p.Person.NickName)
} );
if ( viaSearch && businessList.ToList().Count == 1 )
{
ShowDetailForm( businessList.ToList()[0].Id );
}
else
{
gBusinessList.EntityTypeId = EntityTypeCache.Read<Person>().Id;
gBusinessList.DataSource = businessList.ToList();
gBusinessList.DataBind();
}
}
/// <summary>
/// Returns a list of matching people
/// </summary>
/// <param name="searchterm"></param>
/// <returns></returns>
public override IQueryable<string> Search( string searchterm )
{
bool allowFirstNameSearch = false;
if ( !bool.TryParse( GetAttributeValue( "FirstNameSearch" ), out allowFirstNameSearch ) )
{
allowFirstNameSearch = false;
}
bool reversed = false;
var qry = new PersonService( new RockContext() ).GetByFullNameOrdered( searchterm, true, false, allowFirstNameSearch, out reversed );
return qry
.Select( p => ( reversed ?
p.LastName + ", " + p.NickName:
p.NickName + " " + p.LastName) )
.Distinct();
}
/// <summary>
/// Gets the expression.
/// </summary>
/// <param name="context">The context.</param>
/// <param name="entityIdProperty">The entity identifier property.</param>
/// <param name="selection">The selection.</param>
/// <returns></returns>
public override System.Linq.Expressions.Expression GetExpression( Data.RockContext context, System.Linq.Expressions.MemberExpression entityIdProperty, string selection )
{
bool showAsLink = this.GetAttributeValueFromSelection( "ShowAsLink", selection ).AsBooleanOrNull() ?? false;
int displayOrder = this.GetAttributeValueFromSelection( "DisplayOrder", selection ).AsIntegerOrNull() ?? 0;
var personQry = new PersonService( context ).Queryable();
IQueryable<string> personLinkQuery;
if ( showAsLink )
{
// return string in format: <a href='/person/{personId}'>LastName, NickName</a>
// prepend it with <!--LastName, NickName--> so that Sorting Works as expected
if ( displayOrder == 0 )
{
personLinkQuery = personQry.Select( p => "<!--" + p.NickName + " " + p.LastName + "--><a href='/person/" + p.Id.ToString() + "'>" + p.NickName + " " + p.LastName + "</a>" );
}
else
{
personLinkQuery = personQry.Select( p => "<!--" + p.LastName + ", " + p.NickName + "--><a href='/person/" + p.Id.ToString() + "'>" + p.LastName + ", " + p.NickName + "</a>" );
}
}
else
{
if ( displayOrder == 0 )
{
personLinkQuery = personQry.Select( p => p.NickName + " " + p.LastName );
}
else
{
personLinkQuery = personQry.Select( p => p.LastName + ", " + p.NickName );
}
}
return SelectExpressionExtractor.Extract<Rock.Model.Person>( personLinkQuery, entityIdProperty, "p" );
}
/// <summary>
/// Returns a list of matching people
/// </summary>
/// <param name="searchterm"></param>
/// <returns></returns>
public override IQueryable<string> Search( string searchterm )
{
bool allowFirstNameSearch = GetAttributeValue( "FirstNameSearch" ).AsBooleanOrNull() ?? false;
bool reversed = false;
var qry = new PersonService( new RockContext() ).GetByFullNameOrdered( searchterm, true, false, allowFirstNameSearch, out reversed );
IQueryable<string> resultQry;
if ( reversed )
{
resultQry = qry.Select( p => p.LastName + ", " + p.NickName).Distinct();
}
else
{
resultQry = qry.Select( p => p.NickName + " " + p.LastName ).Distinct();
}
return resultQry;
}