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