/// <summary>
/// Checks WorkflowActionForm model for legacy lava and outputs SQL to correct it.
/// Fields evaluated: Header Footer
/// </summary>
public void CheckWorkflowActionForm()
{
RockContext rockContext = new RockContext();
WorkflowActionFormService workflowActionFormService = new WorkflowActionFormService(rockContext);
foreach (WorkflowActionForm workflowActionForm in workflowActionFormService.Queryable().ToList())
{
// don't change if modified
if (workflowActionForm.ModifiedDateTime != null)
{
continue;
}
bool isUpdated = false;
workflowActionForm.Header = ReplaceUnformatted(workflowActionForm.Header, ref isUpdated);
workflowActionForm.Header = ReplaceUrl(workflowActionForm.Header, ref isUpdated);
workflowActionForm.Header = ReplaceGlobal(workflowActionForm.Header, ref isUpdated);
workflowActionForm.Header = ReplaceDotNotation(workflowActionForm.Header, ref isUpdated);
workflowActionForm.Footer = ReplaceUnformatted(workflowActionForm.Footer, ref isUpdated);
workflowActionForm.Footer = ReplaceUrl(workflowActionForm.Footer, ref isUpdated);
workflowActionForm.Footer = ReplaceGlobal(workflowActionForm.Footer, ref isUpdated);
workflowActionForm.Footer = ReplaceDotNotation(workflowActionForm.Footer, ref isUpdated);
if (isUpdated)
{
string sql = $"UPDATE [WorkflowActionForm] SET [Header] = '{workflowActionForm.Header.Replace( "'", "''" )}', [Footer] = '{workflowActionForm.Footer.Replace( "'", "''" )}' WHERE [Guid] = '{workflowActionForm.Guid}';";
_sqlUpdateScripts.Add(sql);
}
}
}
private static int LoadByGuid2(Guid guid, RockContext rockContext)
{
var workflowActionFormService = new WorkflowActionFormService(rockContext);
return(workflowActionFormService
.Queryable().AsNoTracking()
.Where(c => c.Guid.Equals(guid))
.Select(c => c.Id)
.FirstOrDefault());
}
private static WorkflowActionFormCache LoadById2(int id, RockContext rockContext)
{
var workflowActionFormService = new WorkflowActionFormService(rockContext);
var workflowActionFormModel = workflowActionFormService
.Queryable()
.Where(t => t.Id == id)
.FirstOrDefault();
if (workflowActionFormModel != null)
{
return(new WorkflowActionFormCache(workflowActionFormModel));
}
return(null);
}
