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; }