/// <summary>
/// Executes the specified workflow.
/// </summary>
/// <param name="action">The workflow action.</param>
/// <param name="entity">The entity.</param>
/// <param name="errorMessages">The error messages.</param>
/// <returns></returns>
/// <exception cref="System.NotImplementedException"></exception>
public override bool Execute(Model.WorkflowAction action, Object entity, out List <string> errorMessages)
{
var checkInState = GetCheckInState(entity, out errorMessages);
if (checkInState != null)
{
using (new Rock.Data.UnitOfWorkScope())
{
var personService = new PersonService();
var memberService = new GroupMemberService();
IQueryable <Person> people = null;
if (checkInState.CheckIn.SearchType.Guid.Equals(new Guid(SystemGuid.DefinedValue.CHECKIN_SEARCH_TYPE_PHONE_NUMBER)))
{
people = personService.GetByPhonePartial(checkInState.CheckIn.SearchValue);
}
else if (checkInState.CheckIn.SearchType.Guid.Equals(new Guid(SystemGuid.DefinedValue.CHECKIN_SEARCH_TYPE_NAME)))
{
people = personService.GetByFullName(checkInState.CheckIn.SearchValue);
}
else
{
errorMessages.Add("Invalid Search Type");
return(false);
}
foreach (var person in people.ToList())
{
foreach (var group in person.Members.Where(m => m.Group.GroupType.Guid == new Guid(SystemGuid.GroupType.GROUPTYPE_FAMILY)).Select(m => m.Group).ToList())
{
var family = checkInState.CheckIn.Families.Where(f => f.Group.Id == group.Id).FirstOrDefault();
if (family == null)
{
family = new CheckInFamily();
family.Group = group.Clone(false);
family.Group.LoadAttributes();
family.Caption = group.ToString();
family.SubCaption = memberService.GetFirstNames(group.Id).ToList().AsDelimited(", ");
checkInState.CheckIn.Families.Add(family);
}
}
}
return(true);
}
}
errorMessages.Add("Invalid Check-in State");
return(false);
}
/// <summary>
/// Executes the specified workflow.
/// </summary>
/// <param name="rockContext">The rock context.</param>
/// <param name="action">The workflow action.</param>
/// <param name="entity">The entity.</param>
/// <param name="errorMessages">The error messages.</param>
/// <returns></returns>
/// <exception cref="System.NotImplementedException"></exception>
public override bool Execute(RockContext rockContext, WorkflowAction action, object entity, out List <string> errorMessages)
{
var checkInState = GetCheckInState(entity, out errorMessages);
if (checkInState != null)
{
if (GetActionAttributeValue(action, "AlwaysSearch").AsBoolean() || !checkInState.CheckIn.Families.Any())
{
var searchValue = checkInState.CheckIn.SearchValue.Trim();
long n;
bool isNumeric = long.TryParse(searchValue, out n);
if (isNumeric)
{
UserLoginService userLogin = new UserLoginService(rockContext);
var user = userLogin.GetByUserName(searchValue);
if (user != null)
{
//Short PINs can be confused for phone numbers. Clear families if we have selected.
if (GetActionAttributeValue(action, "ClearFamilies").AsBoolean())
{
checkInState.CheckIn.Families.Clear();
}
var memberService = new GroupMemberService(rockContext);
var families = user.Person.GetFamilies();
foreach (var group in families)
{
var family = checkInState.CheckIn.Families.Where(f => f.Group.Id == group.Id).FirstOrDefault();
if (family == null)
{
family = new CheckInFamily();
family.Group = group.Clone(false);
family.Group.LoadAttributes(rockContext);
family.Caption = group.ToString();
family.SubCaption = memberService.GetFirstNames(group.Id).ToList().AsDelimited(", ");
checkInState.CheckIn.Families.Add(family);
}
}
}
}
}
return(true);
}
errorMessages.Add($"Attempted to run {this.GetType().GetFriendlyTypeName()} in check-in, but the check-in state was null.");
return(false);
}
/// <summary>
/// Executes the specified workflow.
/// </summary>
/// <param name="rockContext">The rock context.</param>
/// <param name="action">The workflow action.</param>
/// <param name="entity">The entity.</param>
/// <param name="errorMessages">The error messages.</param>
/// <returns></returns>
/// <exception cref="System.NotImplementedException"></exception>
public override bool Execute(RockContext rockContext, Rock.Model.WorkflowAction action, Object entity, out List <string> errorMessages)
{
var checkInState = GetCheckInState(entity, out errorMessages);
if (checkInState != null && checkInState.CheckIn.SearchType != null)
{
var personService = new PersonService(rockContext);
var memberService = new GroupMemberService(rockContext);
GroupService groupService = new GroupService(rockContext);
PhoneNumberService phoneNumberService = new PhoneNumberService(rockContext);
int familyGroupTypeId = GroupTypeCache.Get(Rock.SystemGuid.GroupType.GROUPTYPE_FAMILY.AsGuid()).Id;
if (checkInState.CheckIn.SearchType.Guid.Equals(new Guid(Rock.SystemGuid.DefinedValue.CHECKIN_SEARCH_TYPE_PHONE_NUMBER)))
{
string numericPhone = checkInState.CheckIn.SearchValue.AsNumeric();
var personRecordTypeId = DefinedValueCache.Get(Rock.SystemGuid.DefinedValue.PERSON_RECORD_TYPE_PERSON.AsGuid()).Id;
// Find the families with any member who has a phone number that contains selected value
var familyQry = phoneNumberService.Queryable().AsNoTracking();
if (checkInState.CheckInType == null || checkInState.CheckInType.PhoneSearchType == PhoneSearchType.EndsWith)
{
char[] charArray = numericPhone.ToCharArray();
Array.Reverse(charArray);
familyQry = familyQry.Where(o =>
o.NumberReversed.StartsWith(new string( charArray )));
}
else
{
familyQry = familyQry.Where(o =>
o.Number.Contains(numericPhone));
}
var tmpQry = familyQry.Join(personService.Queryable().AsNoTracking(),
o => new { PersonId = o.PersonId, IsDeceased = false, RecordTypeValueId = personRecordTypeId },
p => new { PersonId = p.Id, IsDeceased = p.IsDeceased, RecordTypeValueId = p.RecordTypeValueId.Value },
(pn, p) => new { Person = p, PhoneNumber = pn })
.Join(memberService.Queryable().AsNoTracking(),
pn => pn.Person.Id,
m => m.PersonId,
(o, m) => new { PersonNumber = o.PhoneNumber, GroupMember = m });
var familyIdQry = groupService.Queryable().Where(g => tmpQry.Any(o => o.GroupMember.GroupId == g.Id) && g.GroupTypeId == familyGroupTypeId)
.Select(g => g.Id)
.Distinct();
int maxResults = checkInState.CheckInType != null ? checkInState.CheckInType.MaxSearchResults : 100;
if (maxResults > 0)
{
familyIdQry = familyIdQry.Take(maxResults);
}
var familyIds = familyIdQry.ToList();
// Load the family members
var familyMembers = memberService
.Queryable("Group,GroupRole,Person").AsNoTracking()
.Where(m => familyIds.Contains(m.GroupId))
.ToList();
// Add each family
foreach (int familyId in familyIds)
{
// Get each of the members for this family
var thisFamilyMembers = familyMembers
.Where(m =>
m.GroupId == familyId &&
m.Person.NickName != null)
.ToList();
if (thisFamilyMembers.Any())
{
var group = thisFamilyMembers
.Select(m => m.Group)
.FirstOrDefault();
var firstNames = thisFamilyMembers
.OrderBy(m => m.GroupRole.Order)
.ThenBy(m => m.Person.BirthYear)
.ThenBy(m => m.Person.BirthMonth)
.ThenBy(m => m.Person.BirthDay)
.ThenBy(m => m.Person.Gender)
.Select(m => m.Person.NickName)
.ToList();
var family = new CheckInFamily();
family.Group = group.Clone(false);
family.Caption = group.ToString();
family.SubCaption = firstNames.AsDelimited(", ");
checkInState.CheckIn.Families.Add(family);
}
}
}
else if (checkInState.CheckIn.SearchType.Guid.Equals(new Guid(Rock.SystemGuid.DefinedValue.CHECKIN_SEARCH_TYPE_NAME)))
{
foreach (var person in personService.GetByFullName(checkInState.CheckIn.SearchValue, false).AsNoTracking())
{
foreach (var group in person.Members.Where(m => m.Group.GroupTypeId == familyGroupTypeId).Select(m => m.Group).ToList())
{
var family = checkInState.CheckIn.Families.Where(f => f.Group.Id == group.Id).FirstOrDefault();
if (family == null)
{
family = new CheckInFamily();
family.Group = group.Clone(false);
family.Group.LoadAttributes(rockContext);
family.Caption = group.ToString();
family.SubCaption = memberService.GetFirstNames(group.Id).ToList().AsDelimited(", ");
checkInState.CheckIn.Families.Add(family);
}
}
}
}
else
{
errorMessages.Add("Invalid Search Type");
return(false);
}
return(true);
}
errorMessages.Add("Invalid Check-in State");
return(false);
}
/// <summary>
/// Executes the specified workflow.
/// </summary>
/// <param name="rockContext">The rock context.</param>
/// <param name="action">The workflow action.</param>
/// <param name="entity">The entity.</param>
/// <param name="errorMessages">The error messages.</param>
/// <returns></returns>
/// <exception cref="System.NotImplementedException"></exception>
public override bool Execute(RockContext rockContext, Model.WorkflowAction action, Object entity, out List <string> errorMessages)
{
var checkInState = GetCheckInState(entity, out errorMessages);
if (checkInState != null)
{
var personService = new PersonService(rockContext);
var memberService = new GroupMemberService(rockContext);
Guid familyGroupTypeGuid = SystemGuid.GroupType.GROUPTYPE_FAMILY.AsGuid();
if (checkInState.CheckIn.SearchType.Guid.Equals(new Guid(SystemGuid.DefinedValue.CHECKIN_SEARCH_TYPE_PHONE_NUMBER)))
{
string numericPhone = checkInState.CheckIn.SearchValue.AsNumeric();
var personRecordTypeId = DefinedValueCache.Read(Rock.SystemGuid.DefinedValue.PERSON_RECORD_TYPE_PERSON.AsGuid()).Id;
// Find the families with any member who has a phone number that contains selected value
var familyQry = memberService
.Queryable().AsNoTracking()
.Where(m =>
m.Group.GroupType.Guid.Equals(familyGroupTypeGuid) &&
m.Person.RecordTypeValueId == personRecordTypeId);
int?phoneSearchType = GetAttributeValue(action, "PhoneSearchType").AsIntegerOrNull();
if (phoneSearchType.HasValue && phoneSearchType.Value == 1)
{
familyQry = familyQry.Where(m =>
m.Person.PhoneNumbers.Any(n => n.Number.EndsWith(numericPhone)));
}
else
{
familyQry = familyQry.Where(m =>
m.Person.PhoneNumbers.Any(n => n.Number.Contains(numericPhone)));
}
var familyIdQry = familyQry
.Select(m => m.GroupId)
.Distinct();
int maxResults = GetAttributeValue(action, "MaxResults").AsInteger();
if (maxResults > 0)
{
familyIdQry = familyIdQry.Take(maxResults);
}
var familyIds = familyIdQry.ToList();
// Load the family members
var familyMembers = memberService
.Queryable("Group,GroupRole,Person").AsNoTracking()
.Where(m => familyIds.Contains(m.GroupId))
.ToList();
// Add each family
foreach (int familyId in familyIds)
{
// Get each of the members for this family
var thisFamilyMembers = familyMembers
.Where(m =>
m.GroupId == familyId &&
m.Person.NickName != null)
.ToList();
if (thisFamilyMembers.Any())
{
var group = thisFamilyMembers
.Select(m => m.Group)
.FirstOrDefault();
var firstNames = thisFamilyMembers
.OrderBy(m => m.GroupRole.Order)
.ThenBy(m => m.Person.BirthYear)
.ThenBy(m => m.Person.BirthMonth)
.ThenBy(m => m.Person.BirthDay)
.ThenBy(m => m.Person.Gender)
.Select(m => m.Person.NickName)
.ToList();
var family = new CheckInFamily();
family.Group = group.Clone(false);
family.Caption = group.ToString();
family.SubCaption = firstNames.AsDelimited(", ");
checkInState.CheckIn.Families.Add(family);
}
}
}
else if (checkInState.CheckIn.SearchType.Guid.Equals(new Guid(SystemGuid.DefinedValue.CHECKIN_SEARCH_TYPE_NAME)))
{
foreach (var person in personService.GetByFullName(checkInState.CheckIn.SearchValue, false).AsNoTracking())
{
foreach (var group in person.Members.Where(m => m.Group.GroupType.Guid.Equals(familyGroupTypeGuid)).Select(m => m.Group).ToList())
{
var family = checkInState.CheckIn.Families.Where(f => f.Group.Id == group.Id).FirstOrDefault();
if (family == null)
{
family = new CheckInFamily();
family.Group = group.Clone(false);
family.Group.LoadAttributes(rockContext);
family.Caption = group.ToString();
family.SubCaption = memberService.GetFirstNames(group.Id).ToList().AsDelimited(", ");
checkInState.CheckIn.Families.Add(family);
}
}
}
}
else
{
errorMessages.Add("Invalid Search Type");
return(false);
}
return(true);
}
errorMessages.Add("Invalid Check-in State");
return(false);
}