public override bool Execute(RockContext rockContext, WorkflowAction action, object entity, out List <string> errorMessages)
{
errorMessages = new List <string>();
PersonAliasService personAliasService = new PersonAliasService(rockContext);
Person person = personAliasService.Get(action.Activity.Workflow.GetAttributeValue("Person").AsGuid()).Person;
LocationService locationService = new LocationService(rockContext);
Location currentMailingAddress = locationService.Get(action.Activity.Workflow.GetAttributeValue("CurrentMailingAddress").AsGuid());
Location previousMailingAddress = locationService.Get(action.Activity.Workflow.GetAttributeValue("PreviousMailingAddress").AsGuid());
if (previousMailingAddress == null)
{
previousMailingAddress = new Location();
}
Location reference1Address = locationService.Get(action.Activity.Workflow.GetAttributeValue("Reference1Address").AsGuid());
Location reference2Address = locationService.Get(action.Activity.Workflow.GetAttributeValue("Reference2Address").AsGuid());
Location reference3Address = locationService.Get(action.Activity.Workflow.GetAttributeValue("Reference3Address").AsGuid());
Location reference4Address = locationService.Get(action.Activity.Workflow.GetAttributeValue("Reference4Address").AsGuid());
Dictionary <string, string> fields = new Dictionary <string, string>()
{
{ "ministryOfInterest", action.Activity.Workflow.GetAttributeValue("MinistryOfInterest") },
{ "intPersonID", person.Id.ToString() },
{ "txtLastName", action.Activity.Workflow.GetAttributeValue("LastName") },
{ "txtFirstName", action.Activity.Workflow.GetAttributeValue("FirstName") },
{ "txtMiddleName", action.Activity.Workflow.GetAttributeValue("MiddleName") },
{ "txtMaidenOtherName", action.Activity.Workflow.GetAttributeValue("MaidenOtherNames") },
{ "txtParent", action.Activity.Workflow.GetAttributeValue("Parent") },
{ "txtParentEmail", action.Activity.Workflow.GetAttributeValue("ParentEmail") },
{ "txtParentHomePhone", action.Activity.Workflow.GetAttributeValue("ParentHomePhone") },
{ "txtParentCellPhone", action.Activity.Workflow.GetAttributeValue("ParentCellPhone") },
{ "txtDateOfBirth", action.Activity.Workflow.GetAttributeValue("DateofBirth").AsDateTime().Value.ToShortDateString() },
//{"txtSSN", action.Activity.Workflow.GetAttributeValue("")},
{ "radGender", action.Activity.Workflow.GetAttributeValue("") },
{ "radMale", action.Activity.Workflow.GetAttributeValue("Gender") == "Male"?"Yes":"No" },
{ "radFemale", action.Activity.Workflow.GetAttributeValue("Gender") == "Female"?"Yes":"No" },
{ "txtSCCAttendanceDuration", action.Activity.Workflow.GetAttributeValue("HowLongAttended") },
{ "txtSCCMember", person.ConnectionStatusValue.Guid == Rock.SystemGuid.DefinedValue.PERSON_CONNECTION_STATUS_MEMBER.AsGuid()?"Yes":"No" },
{ "txtSCCMemberPDFNo", person.ConnectionStatusValue.Guid == Rock.SystemGuid.DefinedValue.PERSON_CONNECTION_STATUS_MEMBER.AsGuid()?"No":"Yes" },
{ "txtSCCInvolvement", action.Activity.Workflow.GetAttributeValue("CurrentParticipation") },
{ "txtChurch", action.Activity.Workflow.GetAttributeValue("ChurchAtttended") },
{ "txtStreet", currentMailingAddress.Street1 },
{ "txtCity", currentMailingAddress.City },
{ "txtState", currentMailingAddress.State },
{ "txtZip", currentMailingAddress.PostalCode },
{ "SaveUpToThisPoint", "" },
{ "txtPrevStreet", previousMailingAddress.Street1 },
{ "txtPrevCity", previousMailingAddress.City },
{ "txtPrevState", previousMailingAddress.State },
{ "txtPrevZip", previousMailingAddress.PostalCode },
{ "radOutOfState", action.Activity.Workflow.GetAttributeValue("OutsideKentuckyIndiana") },
{ "radOutOfStatePDFYes", action.Activity.Workflow.GetAttributeValue("OutsideKentuckyIndiana").AsBoolean()?"Yes":"No" },
{ "radOutOfStatePDFNo", action.Activity.Workflow.GetAttributeValue("OutsideKentuckyIndiana").AsBoolean()?"No":"Yes" },
{ "txtOutOfState_Dates", action.Activity.Workflow.GetAttributeValue("WhenOutsideKentuckyIndiana") },
{ "txtOutOfState_State", action.Activity.Workflow.GetAttributeValue("StatesOutsideKentuckyIndiana") },
{ "txtEmployer", action.Activity.Workflow.GetAttributeValue("CurrentEmployer") },
{ "txtPosition", action.Activity.Workflow.GetAttributeValue("PositionHeld") },
{ "txtWorkPhone", action.Activity.Workflow.GetAttributeValue("WorkPhone") },
{ "txtHomePhone", action.Activity.Workflow.GetAttributeValue("HomePhone") },
{ "txtCellPhone", action.Activity.Workflow.GetAttributeValue("CellPhone") },
//{"txtWorkEmail", action.Activity.Workflow.GetAttributeValue("")},
{ "txtEmail", person.Email },
{ "txtRef1Name", action.Activity.Workflow.GetAttributeValue("Reference1Name") },
//{"txtRef1Relationship", action.Activity.Workflow.GetAttributeValue("")},
{ "radRef1YearsKnow", action.Activity.Workflow.GetAttributeValue("Reference1Relationship")
+ "/" + action.Activity.Workflow.GetAttributeValue("Reference1YearsKnown") },
{ "txtRef1Address", reference1Address.Street1 },
{ "txtRef1City", reference1Address.City },
{ "txtRef1State", reference1Address.State },
{ "txtRef1Zip", reference1Address.PostalCode },
//{"txtRef1PersPhone", action.Activity.Workflow.GetAttributeValue("")},
//{"txtRef1PersPhoneTime", action.Activity.Workflow.GetAttributeValue("")},
{ "txtRef1WorkPhone", action.Activity.Workflow.GetAttributeValue("Reference1WorkPhone") },
//{"txtRef1WorkPhoneTime", action.Activity.Workflow.GetAttributeValue("")},
{ "txtRef1HomePhone", action.Activity.Workflow.GetAttributeValue("Reference1HomePhone") },
{ "txtRef1CellPhone", action.Activity.Workflow.GetAttributeValue("Reference1CellPhone") },
{ "txtRef1Email", action.Activity.Workflow.GetAttributeValue("Reference1Email") },
{ "txtRef2Name", action.Activity.Workflow.GetAttributeValue("Reference2Name") },
//{"txtRef2Relationship", action.Activity.Workflow.GetAttributeValue("")},
{ "radRef2YearsKnow", action.Activity.Workflow.GetAttributeValue("Reference2Relationship")
+ "/" + action.Activity.Workflow.GetAttributeValue("Reference2YearsKnown") },
{ "txtRef2Address", reference2Address.Street1 },
{ "txtRef2City", reference2Address.City },
{ "txtRef2State", reference2Address.State },
{ "txtRef2Zip", reference2Address.PostalCode },
//{"txtRef2PersPhone", action.Activity.Workflow.GetAttributeValue("")},
//{"txtRef2PersPhoneTime", action.Activity.Workflow.GetAttributeValue("")},
{ "txtRef2WorkPhone", action.Activity.Workflow.GetAttributeValue("Reference2WorkPhone") },
//{"txtRef2WorkPhoneTime", action.Activity.Workflow.GetAttributeValue("")},
{ "txtRef2HomePhone", action.Activity.Workflow.GetAttributeValue("Reference2HomePhone") },
{ "txtRef2CellPhone", action.Activity.Workflow.GetAttributeValue("Reference2CellPhone") },
{ "txtRef2Email", action.Activity.Workflow.GetAttributeValue("Reference2Email") },
{ "txtRef3Name", action.Activity.Workflow.GetAttributeValue("Reference3Name") },
//{"txtRef3Relationship", action.Activity.Workflow.GetAttributeValue("")},
{ "radRef3YearsKnow", action.Activity.Workflow.GetAttributeValue("Reference3Relationship")
+ "/" + action.Activity.Workflow.GetAttributeValue("Reference3YearsKnown") },
{ "txtRef3Address", reference3Address.Street1 },
{ "txtRef3City", reference3Address.City },
{ "txtRef3State", reference3Address.State },
{ "txtRef3Zip", reference3Address.PostalCode },
//{"txtRef3PersPhone", action.Activity.Workflow.GetAttributeValue("")},
//{"txtRef3PersPhoneTime", action.Activity.Workflow.GetAttributeValue("")},
{ "txtRef3WorkPhone", action.Activity.Workflow.GetAttributeValue("Reference3WorkPhone") },
//{"txtRef3WorkPhoneTime", action.Activity.Workflow.GetAttributeValue("")},
{ "txtRef3HomePhone", action.Activity.Workflow.GetAttributeValue("Reference3HomePhone") },
{ "txtRef3CellPhone", action.Activity.Workflow.GetAttributeValue("Reference3CellPhone") },
{ "txtRef3Email", action.Activity.Workflow.GetAttributeValue("Reference3Email") },
{ "txtRef4Name", action.Activity.Workflow.GetAttributeValue("Reference4Name") },
//{"txtRef4Relationship", action.Activity.Workflow.GetAttributeValue("")},
{ "radRef4YearsKnow", action.Activity.Workflow.GetAttributeValue("Reference4Relationship")
+ "/" + action.Activity.Workflow.GetAttributeValue("Reference4YearsKnown") },
{ "txtRef4Address", reference4Address?.Street1 },
{ "txtRef4City", reference4Address?.City },
{ "txtRef4State", reference4Address?.State },
{ "txtRef4Zip", reference4Address?.PostalCode },
//{"txtRef4PersPhone", action.Activity.Workflow.GetAttributeValue("")},
//{"txtRef4PersPhoneTime", action.Activity.Workflow.GetAttributeValue("")},
{ "txtRef4WorkPhone", action.Activity.Workflow.GetAttributeValue("Reference4WorkPhone") },
//{"txtRef4WorkPhoneTime", action.Activity.Workflow.GetAttributeValue("")},
{ "txtRef4HomePhone", action.Activity.Workflow.GetAttributeValue("Reference4HomePhone") },
{ "txtRef4CellPhone", action.Activity.Workflow.GetAttributeValue("Reference4CellPhone") },
{ "txtRef4Email", action.Activity.Workflow.GetAttributeValue("Reference4Email") },
//{"txtPhysLimitations", action.Activity.Workflow.GetAttributeValue("")},
{ "txtPhysLimitations", action.Activity.Workflow.GetAttributeValue("PhysicalLimitationsExplanation") },
{ "txtPhysLimitationsPDF", action.Activity.Workflow.GetAttributeValue("PhysicalLimitationsExplanation") },
{ "radPhysLimitationsPDFYes", action.Activity.Workflow.GetAttributeValue("PhysicalLimitations").AsBoolean()?"Yes":"No" },
{ "radPhysLimitationsPDFNo", action.Activity.Workflow.GetAttributeValue("PhysicalLimitations").AsBoolean()?"No":"Yes" },
{ "radCrimePersons", action.Activity.Workflow.GetAttributeValue("Crime").AsBoolean()?"Yes":"No" },
{ "radCrimePersonsPDFNo", action.Activity.Workflow.GetAttributeValue("Crime").AsBoolean()?"No":"Yes" },
//{"radCrimeProperty", action.Activity.Workflow.GetAttributeValue("")},
{ "radThreatToMinors", action.Activity.Workflow.GetAttributeValue("Threat").AsBoolean()?"Yes":"No" },
{ "radThreatToMinorsPDFNo", action.Activity.Workflow.GetAttributeValue("Threat").AsBoolean()?"No":"Yes" },
{ "radCrimeCounseled", action.Activity.Workflow.GetAttributeValue("CrimeCounsel").AsBoolean()?"Yes":"No" },
{ "radCrimeCounseledPDFYes", action.Activity.Workflow.GetAttributeValue("CrimeCounsel").AsBoolean()?"Yes":"No" },
{ "radCrimeCounseledPDFNo", action.Activity.Workflow.GetAttributeValue("CrimeCounsel").AsBoolean()?"No":"Yes" },
{ "radNeedsStaffContact", action.Activity.Workflow.GetAttributeValue("Contact").AsBoolean()?"Yes":"No" },
{ "radNeedsStaffContactPDFNo", action.Activity.Workflow.GetAttributeValue("Contact").AsBoolean()?"No":"Yes" },
{ "personDetailPage", GlobalAttributesCache.Value("InternalApplicationRoot") + "/Person/" + person.Id },
{ "txtAppSigned", "{{t:s;r:y;o:\"Applicant\";}}" },
{ "txtAppDated", "{{t:d;r:y;o:\"Applicant\";l:\"Date\";dd:\"" + DateTime.Now.ToShortDateString() + "\";}}" },
{ "txtAppPrintedName", person.FullNameFormal },
{ "txtSOFSigned", "{{t:s;r:n;o:\"Applicant\";}}" },
{ "txtSOFDated", "{{t:d;r:n;o:\"Applicant\";l:\"Date\";dd:\"" + DateTime.Now.ToShortDateString() + "\";}}" },
{ "txtSOFPrintedName", person.FullNameFormal },
{ "txtParentSignature", "{{t:s;r:y;o:\"Parent\";}}" },
{ "txtDate1", "{{t:d;r:y;o:\"Parent\";l:\"Date\";dd:\"" + DateTime.Now.ToShortDateString() + "\";}}" },
{ "radReadSOFYes", action.Activity.Workflow.GetAttributeValue("ReadStatementOfFaith").AsBoolean()?"Yes":"No" },
{ "radReadSOFNo", action.Activity.Workflow.GetAttributeValue("ReadStatementOfFaith").AsBoolean()?"No":"Yes" },
{ "radAgreeSOFYes", action.Activity.Workflow.GetAttributeValue("AgreeStatementOfFaith").AsBoolean()?"Yes":"No" },
{ "radAgreeSOFNo", action.Activity.Workflow.GetAttributeValue("AgreeStatementOfFaith").AsBoolean()?"No":"Yes" },
{ "txtSOFCommentsAmendments", String.IsNullOrEmpty(action.Activity.Workflow.GetAttributeValue("CommentsStatementOfFaith"))?" ":action.Activity.Workflow.GetAttributeValue("CommentsStatementOfFaith") },
};
BinaryFileService binaryFileService = new BinaryFileService(rockContext);
BinaryFile PDF = null;
var isMinorApplicant = GetAttributeValue(action, "IsMinorApplication", true).AsBoolean();
if (isMinorApplicant)
{
PDF = binaryFileService.Get(GetActionAttributeValue(action, "MinorVolunteerApplicationPDF").AsGuid());
}
else
{
PDF = binaryFileService.Get(GetActionAttributeValue(action, "AdultVolunteerApplicationPDF").AsGuid());
}
var pdfBytes = PDF.ContentStream.ReadBytesToEnd();
using (MemoryStream ms = new MemoryStream())
{
PdfReader pdfReader = new PdfReader(pdfBytes);
PdfStamper pdfStamper = new PdfStamper(pdfReader, ms);
AcroFields pdfFormFields = pdfStamper.AcroFields;
foreach (var field in fields)
{
if (pdfFormFields.Fields.ContainsKey(field.Key))
{
pdfFormFields.SetField(field.Key, field.Value);
}
}
// flatten the form to remove editting options, set it to false
// to leave the form open to subsequent manual edits
pdfStamper.FormFlattening = true;
// close the pdf
pdfStamper.Close();
//pdfReader.Close();
pdfStamper.Dispose();
pdfStamper = null;
BinaryFile renderedPDF = new BinaryFile();
renderedPDF.CopyPropertiesFrom(PDF);
renderedPDF.Guid = Guid.NewGuid();
renderedPDF.FileName = "VolunteerApplication_" + person.FirstName + person.LastName + ".pdf";
renderedPDF.BinaryFileTypeId = new BinaryFileTypeService(rockContext).Get(new Guid(BACKGROUND_CHECK_BINARY_FILE_TYPE)).Id;
BinaryFileData pdfData = new BinaryFileData();
pdfData.Content = ms.ToArray();
renderedPDF.DatabaseData = pdfData;
binaryFileService.Add(renderedPDF);
rockContext.SaveChanges();
action.Activity.Workflow.SetAttributeValue("PDF", renderedPDF.Guid);
}
return(true);
}
/// <summary>
/// Executes the action.
/// </summary>
/// <param name="rockContext">The rock context.</param>
/// <param name="action">The action.</param>
/// <param name="entity">The entity.</param>
/// <param name="errorMessages">The error messages.</param>
/// <returns></returns>
public override bool Execute(RockContext rockContext, WorkflowAction action, object entity, out List <string> errorMessages)
{
errorMessages = new List <string>();
PDFWorkflowObject pdfWorkflowObject = new PDFWorkflowObject();
//A PDF merge can enter in two ways, kicked off with trigger or called from a block
//If it is called from a block we will get our information from a PDFWorkflowObject
//Otherwise we will need to get our information from the workflow attributes
if (entity is PDFWorkflowObject)
{
pdfWorkflowObject = Utility.GetPDFFormMergeFromEntity(entity, out errorMessages);
}
else
{
pdfWorkflowObject = new PDFWorkflowObject(action, rockContext);
}
BinaryFile renderedPDF = new BinaryFile();
//Merge PDF
using (MemoryStream ms = new MemoryStream())
{
var pdfGuid = GetAttributeValue(action, "PDFTemplate");
var pdf = new BinaryFileService(rockContext).Get(pdfGuid.AsGuid());
var pdfBytes = pdf.ContentStream.ReadBytesToEnd();
var pdfReader = new PdfReader(pdfBytes);
var stamper = new PdfStamper(pdfReader, ms);
var form = stamper.AcroFields;
form.GenerateAppearances = true;
var fieldKeys = form.Fields.Keys;
//Field keys are the names of form fields in a pdf form
foreach (string fieldKey in fieldKeys)
{
//If this is a key value pairing
if (pdfWorkflowObject.MergeObjects.ContainsKey(fieldKey))
{
if (pdfWorkflowObject.MergeObjects[fieldKey] is string)
{
form.SetField(fieldKey, pdfWorkflowObject.MergeObjects[fieldKey] as string);
}
}
//otherwise test for lava and use the form value as the lava input
else
{
string fieldValue = form.GetField(fieldKey);
if (!string.IsNullOrWhiteSpace(fieldValue) && fieldValue.HasMergeFields())
{
form.SetField(fieldKey, fieldValue.ResolveMergeFields(pdfWorkflowObject.MergeObjects));
}
}
}
//Should we flatten the form
stamper.FormFlattening = GetActionAttributeValue(action, "Flatten").AsBoolean();
stamper.Close();
pdfReader.Close();
//Generate New Object
renderedPDF.CopyPropertiesFrom(pdf);
renderedPDF.Guid = Guid.NewGuid();
renderedPDF.BinaryFileTypeId = new BinaryFileTypeService(rockContext).Get(new Guid(Rock.SystemGuid.BinaryFiletype.DEFAULT)).Id;
BinaryFileData pdfData = new BinaryFileData();
pdfData.Content = ms.ToArray();
renderedPDF.DatabaseData = pdfData;
pdfReader.Close();
}
if (entity is PDFWorkflowObject)
{
entity = pdfWorkflowObject;
}
else
{
BinaryFileService binaryFileService = new BinaryFileService(rockContext);
binaryFileService.Add(renderedPDF);
rockContext.SaveChanges();
Guid guid = GetAttributeValue(action, "PDFOutput").AsGuid();
if (!guid.IsEmpty())
{
var attribute = AttributeCache.Read(guid, rockContext);
if (attribute != null)
{
SetWorkflowAttributeValue(action, guid, renderedPDF.Guid.ToString());
}
}
}
return(true);
}