/// <summary>
/// The commands to run to migrate plugin to the specific version
/// </summary>
public override void Up()
{
RockMigrationHelper.UpdateFieldType("Label", "Labels that can be printed during check-in", "Rock", "Rock.Field.Types.LabelFieldType", Rock.SystemGuid.FieldType.LABEL);
Sql($@"
DECLARE @BinaryFileFieldTypeId int = ( SELECT TOP 1 [Id] FROM [FieldType] WHERE [Guid] = '{Rock.SystemGuid.FieldType.BINARY_FILE}' )
DECLARE @LabelFieldTypeId int = ( SELECT TOP 1 [Id] FROM [FieldType] WHERE [Guid] = '{Rock.SystemGuid.FieldType.LABEL}' )
UPDATE A SET [FieldTypeId] = @LabelFieldTypeId
FROM [Attribute] A
INNER JOIN [AttributeQualifier] Q
ON Q.[AttributeId] = A.[Id]
AND Q.[Key] = 'binaryFileType'
AND Q.[Value] = '{Rock.SystemGuid.BinaryFiletype.CHECKIN_LABEL}'
WHERE A.[FieldTypeId] = @BinaryFileFieldTypeId
");
}
/// <summary>
/// JE - Mobile Template Update
/// </summary>
private void MobileTemplateUpdate()
{
string STANDARD_ICON_SVG = "PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9Im5vIj8+CjwhRE9DVFlQRSBzdmcgUFVCTElDICItLy9XM0MvL0RURCBTVkcgMS4xLy9FTiIgImh0dHA6Ly93d3cudzMub3JnL0dyYXBoaWNzL1NWRy8xLjEvRFREL3N2ZzExLmR0ZCI+Cjxzdmcgd2lkdGg9IjEwMCUiIGhlaWdodD0iMTAwJSIgdmlld0JveD0iMCAwIDY0MCAyNDAiIHZlcnNpb249IjEuMSIgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIiB4bWxuczp4bGluaz0iaHR0cDovL3d3dy53My5vcmcvMTk5OS94bGluayIgeG1sOnNwYWNlPSJwcmVzZXJ2ZSIgeG1sbnM6c2VyaWY9Imh0dHA6Ly93d3cuc2VyaWYuY29tLyIgc3R5bGU9ImZpbGwtcnVsZTpldmVub2RkO2NsaXAtcnVsZTpldmVub2RkO3N0cm9rZS1saW5lam9pbjpyb3VuZDtzdHJva2UtbWl0ZXJsaW1pdDoyOyI+CiAgICA8ZyB0cmFuc2Zvcm09Im1hdHJpeCgxLjEwMTU1LDAsMCwxLC0zMC44NDM0LC0zMSkiPgogICAgICAgIDxyZWN0IHg9IjI4IiB5PSIzMSIgd2lkdGg9IjU4MSIgaGVpZ2h0PSIxOCIgc3R5bGU9ImZpbGw6cmdiKDIzMSwyMzEsMjMxKTsiLz4KICAgIDwvZz4KICAgIDxnIHRyYW5zZm9ybT0ibWF0cml4KDAuOTY1NTc3LDAsMCwxLC0yNy4wMzYxLDEyKSI+CiAgICAgICAgPHJlY3QgeD0iMjgiIHk9IjMxIiB3aWR0aD0iNTgxIiBoZWlnaHQ9IjE4IiBzdHlsZT0iZmlsbDpyZ2IoMjMxLDIzMSwyMzEpOyIvPgogICAgPC9nPgogICAgPGcgdHJhbnNmb3JtPSJtYXRyaXgoMS4wMjA2NSwwLDAsMSwtMjguNTc4Myw1NSkiPgogICAgICAgIDxyZWN0IHg9IjI4IiB5PSIzMSIgd2lkdGg9IjU4MSIgaGVpZ2h0PSIxOCIgc3R5bGU9ImZpbGw6cmdiKDIzMSwyMzEsMjMxKTsiLz4KICAgIDwvZz4KICAgIDxnIHRyYW5zZm9ybT0ibWF0cml4KDAuOTg0NTA5LDAsMCwxLC0yNy41NjYzLDk4KSI+CiAgICAgICAgPHJlY3QgeD0iMjgiIHk9IjMxIiB3aWR0aD0iNTgxIiBoZWlnaHQ9IjE4IiBzdHlsZT0iZmlsbDpyZ2IoMjMxLDIzMSwyMzEpOyIvPgogICAgPC9nPgogICAgPGcgdHJhbnNmb3JtPSJtYXRyaXgoMS4wNTY4LDAsMCwxLC0yOS41OTA0LDE0MSkiPgogICAgICAgIDxyZWN0IHg9IjI4IiB5PSIzMSIgd2lkdGg9IjU4MSIgaGVpZ2h0PSIxOCIgc3R5bGU9ImZpbGw6cmdiKDIzMSwyMzEsMjMxKTsiLz4KICAgIDwvZz4KICAgIDxnIHRyYW5zZm9ybT0ibWF0cml4KDEuMDc5MTcsMCwwLDEsLTMwLjIxNjksMTg0KSI+CiAgICAgICAgPHJlY3QgeD0iMjgiIHk9IjMxIiB3aWR0aD0iNTgxIiBoZWlnaHQ9IjE4IiBzdHlsZT0iZmlsbDpyZ2IoMjMxLDIzMSwyMzEpOyIvPgogICAgPC9nPgo8L3N2Zz4K";
RockMigrationHelper.AddOrUpdateTemplateBlockTemplate(
"674CF1E3-561C-430D-B4A8-39957AC1BCF1",
Rock.SystemGuid.DefinedValue.BLOCK_TEMPLATE_MOBILE_GROUP_MEMBER_LIST,
"Default",
@"<StackLayout>
{% assign groupMemberCount = Members | Size %}
<Label StyleClass=""h1"" Text=""{{ Title | Escape }}"" />
<Label StyleClass=""text"" Text=""{{ 'member' | ToQuantity:groupMemberCount }}"" />
{% if Members != empty %}
<StackLayout Spacing=""0"" Margin=""0,20,0,0"">
<Rock:Divider />
{% for member in Members %}
<StackLayout Orientation=""Horizontal"" Padding=""0,16"" Spacing=""16"">
<StackLayout.GestureRecognizers>
<TapGestureRecognizer Command=""{Binding PushPage}"" CommandParameter=""{{ DetailPage }}?GroupMemberGuid={{ member.Guid }}"" />
</StackLayout.GestureRecognizers>
<Rock:Image Source=""{{ member.PhotoUrl | Append:'&width=400' | Escape }}"" HeightRequest=""64"" WidthRequest=""64"" Aspect=""AspectFill"" BackgroundColor=""#ccc"">
<Rock:RoundedTransformation CornerRadius=""8"" />
</Rock:Image>
<StackLayout Spacing=""0"" HorizontalOptions=""FillAndExpand"" VerticalOptions=""Center"">
<Label StyleClass=""h4"" Text=""{{ member.FullName | Escape }}"" />
<Label StyleClass=""text, o-60"" Text=""{{ member.GroupRole | Escape }}"" />
</StackLayout>
<Rock:Icon IconClass=""chevron-right"" Margin=""0,0,20,0"" VerticalOptions=""Center"" />
</StackLayout>
<Rock:Divider />
{% endfor %}
</StackLayout>
{% endif %}
</StackLayout>",
STANDARD_ICON_SVG,
"standard-template.svg",
"image/svg+xml");
}
public override void Down()
{
RockMigrationHelper.DeleteBlock(SystemGuid.Block.REMOTE_DEPOSIT_EXPORT);
RockMigrationHelper.DeletePage(SystemGuid.Page.REMOTE_DEPOSIT_EXPORT);
RockMigrationHelper.DeleteBlock(SystemGuid.Block.FILE_FORMAT_DETAIL);
RockMigrationHelper.DeletePage(SystemGuid.Page.FILE_TYPE_DETAIL);
RockMigrationHelper.DeleteBlock(SystemGuid.Block.FILE_FORMAT_LIST);
RockMigrationHelper.DeletePage(SystemGuid.Page.FILE_TYPES);
RockMigrationHelper.DeleteBlock(SystemGuid.Block.PAGE_MENU);
RockMigrationHelper.DeletePage(SystemGuid.Page.IMAGE_CASH_LETTER);
RockMigrationHelper.DeleteBlockType(SystemGuid.BlockType.REMOTE_DEPOSIT_EXPORT);
RockMigrationHelper.DeleteBlockType(SystemGuid.BlockType.FILE_FORMAT_DETAIL);
RockMigrationHelper.DeleteBlockType(SystemGuid.BlockType.FILE_FORMAT_LIST);
}
/// <summary>
/// Operations to be performed during the downgrade process.
/// </summary>
public override void Down()
{
//Delete Attributes
RockMigrationHelper.DeleteAttribute("990275DB-611B-4D2E-94EA-3FFA1186A5E1");
RockMigrationHelper.DeleteAttribute("3A10ECFB-8CAB-4CCA-8B29-298756CD3251");
RockMigrationHelper.DeleteAttribute("FA4341B4-28C7-409E-A101-548BB5759BE6");
RockMigrationHelper.DeleteAttribute("3EFF4FEF-EE4C-40E2-8DBD-80F3276852DA");
RockMigrationHelper.DeleteAttribute("86670F7D-07BA-4ECE-9BB9-9D94B5FB5F26");
RockMigrationHelper.DeleteAttribute("4A2E1539-4ECC-40B9-9EBD-C0C84EC8DA36");
RockMigrationHelper.DeleteAttribute("2512DAC6-BBC4-4D0E-A01D-E92F94C534BD");
RockMigrationHelper.DeleteAttribute("7F0A1794-0150-413B-9AE1-A6B0D6373DA6");
RockMigrationHelper.DeleteAttribute("EDE5E199-37BE-424F-A788-5CDCC064157C");
//Delete Category
RockMigrationHelper.DeleteCategory("0B187C81-2106-4875-82B6-FBF1277AE23B");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
Sql(String.Format(@"
UPDATE [Group]
SET [Name] = 'RSR - Connection Administration',
[Description] = 'Group of individuals who can administrate the various parts of the connection functionality.'
WHERE [Guid] = '{0}'
", Rock.SystemGuid.Group.GROUP_CONNECTION_ADMINISTRATORS));
RockMigrationHelper.RenameBlockType("~/Blocks/Involvement/MyConnectionOpportunities.ascx", "~/Blocks/Connection/MyConnectionOpportunities.ascx", "Connection");
RockMigrationHelper.RenameBlockType("~/Blocks/Involvement/ConnectionRequestDetail.ascx", "~/Blocks/Connection/ConnectionRequestDetail.ascx", "Connection");
RockMigrationHelper.RenameBlockType("~/Blocks/Involvement/ConnectionTypeList.ascx", "~/Blocks/Connection/ConnectionTypeList.ascx", "Connection");
RockMigrationHelper.RenameBlockType("~/Blocks/Involvement/ConnectionOpportunityList.ascx", "~/Blocks/Connection/ConnectionOpportunityList.ascx", "Connection");
RockMigrationHelper.RenameBlockType("~/Blocks/Involvement/ConnectionTypeDetail.ascx", "~/Blocks/Connection/ConnectionTypeDetail.ascx", "Connection");
RockMigrationHelper.RenameBlockType("~/Blocks/Involvement/ConnectionOpportunityDetail.ascx", "~/Blocks/Connection/ConnectionOpportunityDetail.ascx", "Connection");
RockMigrationHelper.RenameBlockType("~/Blocks/Involvement/ExternalOpportunitySearch.ascx", "~/Blocks/Connection/ExternalOpportunitySearch.ascx", "Connection");
RockMigrationHelper.RenameBlockType("~/Blocks/Involvement/ExternalConnectionOpportunityDetail.ascx", "~/Blocks/Connection/ExternalConnectionOpportunityDetail.ascx", "Connection");
}
/// <summary>
/// Operations to be performed during the downgrade process.
/// </summary>
public override void Down()
{
DropIndex("dbo.FinancialTransaction", new[] { "CheckMicrHash" });
DropColumn("dbo.FinancialTransaction", "CheckMicrHash");
// Attrib for BlockType: Group Member Link:Success Page
RockMigrationHelper.DeleteAttribute("7CC07346-E82F-42C9-8DDA-5AB22D58B1F7");
// Attrib for BlockType: Group Member Link:Success Message
RockMigrationHelper.DeleteAttribute("2C5C3A4A-DD79-47CD-9E30-0531266C7F75");
// Attrib for BlockType: Group Member Link:Group Member Status
RockMigrationHelper.DeleteAttribute("DE9E9CA9-8A01-46AB-8A16-CA6967C88626");
// Attrib for BlockType: Group Member Link:Group
RockMigrationHelper.DeleteAttribute("24E0AF57-2C84-4625-98E9-BA2241C41E14");
// Attrib for BlockType: Group Member Link:Error Message
RockMigrationHelper.DeleteAttribute("5B2DF4FE-4231-43DB-B1E4-CB88F4E81219");
RockMigrationHelper.DeleteBlockType("9AAA967C-D0B0-4E42-89DE-2AE6AAFC17EF"); // Group Member Link
}
/// <summary>
/// Operations to be performed during the downgrade process.
/// </summary>
public override void Down()
{
// Attrib for BlockType: History Log:Entity Type
RockMigrationHelper.DeleteAttribute("8FB690EC-5299-46C5-8695-AAD23168E6E1");
// Attrib for BlockType: Batch Detail:Audit Page
RockMigrationHelper.DeleteAttribute("66E7C23A-797D-4945-931F-DC7671C79AC1");
// Remove Block: History Log, from Page: Audit Log, Site: Rock RMS
RockMigrationHelper.DeleteBlock("39F5EA5A-6F78-4A4F-ABFE-719DD75B445A");
RockMigrationHelper.DeleteBlockType("C6C2DF41-A50D-4975-B21C-4EFD6FF3E8D0"); // History Log
RockMigrationHelper.DeletePage("CBE0C5ED-744E-4392-A9D4-0DC57AF11D33"); // Page: Audit Log, Layout: Full Width, Site: Rock RMS
// Delete PageContext for Page:Audit Log, Entity: Rock.Model.FinancialBatch, Parameter: BatchId
RockMigrationHelper.DeletePageContext("307639F5-824A-453C-8650-B393DEC506F1");
RockMigrationHelper.DeleteCategory("477EE3BE-C68F-48BD-B218-FAFC99AF56B3");
RockMigrationHelper.DeleteCategory("AF6A8CFF-F24F-4AA8-B126-94B6903961C0");
RockMigrationHelper.DeleteCategory("E41FC407-B60E-4B85-954D-D27F0762114B");
}
/// <summary>
/// JM: Efs the clean up for file69 migration rollups for v8 7 6.
/// </summary>
private void EFCleanUpForFile69_MigrationRollupsForV8_7_6()
{
// Attrib for BlockType: Attendance Analytics:Filter Column Count
RockMigrationHelper.UpdateBlockTypeAttribute("3CD3411C-C076-4344-A9D5-8F3B4F01E31D", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Filter Column Count", "FilterColumnCount", "", @"The number of check boxes for each row.", 14, @"1", "244327E8-01EE-4860-9F12-4CF6144DFD61");
// Attrib for BlockType: Attendance Analytics:Filter Column Direction
RockMigrationHelper.UpdateBlockTypeAttribute("3CD3411C-C076-4344-A9D5-8F3B4F01E31D", "7525C4CB-EE6B-41D4-9B64-A08048D5A5C0", "Filter Column Direction", "FilterColumnDirection", "", @"Choose the direction for the checkboxes for filter selections.", 13, @"vertical", "0807FC61-26CE-41A1-9C54-8C4FA0DB6B5C");
// Attrib for BlockType: Giving Analytics:Filter Column Count
RockMigrationHelper.UpdateBlockTypeAttribute("48E4225F-8948-4FB0-8F00-1B43D3D9B3C3", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Filter Column Count", "FilterColumnCount", "", @"The number of check boxes for each row.", 4, @"1", "43B7025A-778A-4107-8243-D91A2FA74AA4");
// Attrib for BlockType: Giving Analytics:Filter Column Direction
RockMigrationHelper.UpdateBlockTypeAttribute("48E4225F-8948-4FB0-8F00-1B43D3D9B3C3", "7525C4CB-EE6B-41D4-9B64-A08048D5A5C0", "Filter Column Direction", "FilterColumnDirection", "", @"Choose the direction for the checkboxes for filter selections.", 3, @"vertical", "11C6953E-E176-40A2-9BF7-979344BD8FD8");
// Attrib Value for Block:Attendance Reporting, Attribute:Filter Column Count Page: Attendance Analytics, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("3EF007F1-6B46-4BCD-A435-345C03EBCA17", "244327E8-01EE-4860-9F12-4CF6144DFD61", @"3");
// Attrib Value for Block:Attendance Reporting, Attribute:Filter Column Direction Page: Attendance Analytics, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("3EF007F1-6B46-4BCD-A435-345C03EBCA17", "0807FC61-26CE-41A1-9C54-8C4FA0DB6B5C", @"horizontal");
// Attrib Value for Block:Giving Analysis, Attribute:Filter Column Count Page: Giving Analytics, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("784C58EF-B1B8-4237-BF12-E04DE8271A5A", "43B7025A-778A-4107-8243-D91A2FA74AA4", @"3");
// Attrib Value for Block:Giving Analysis, Attribute:Filter Column Direction Page: Giving Analytics, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("784C58EF-B1B8-4237-BF12-E04DE8271A5A", "11C6953E-E176-40A2-9BF7-979344BD8FD8", @"horizontal");
}
/// <summary>
/// Operations to be performed during the downgrade process.
/// </summary>
public override void Down()
{
Sql("DELETE [ServiceJob] WHERE [Guid] = '88674EB2-3ABC-4C1B-94B1-6E2E1EDF9BB9'");
RockMigrationHelper.DeleteAttribute("069A5B85-75B5-4F5F-86A7-9602B1760FE5");
RockMigrationHelper.DeleteAttribute("2A9A7991-D1F5-43CB-9566-552F6D2A6D95");
RockMigrationHelper.DeleteAttribute("F48F7422-E128-48F9-B429-027C573119FB");
RockMigrationHelper.DeleteSystemEmail("ED567FDE-A3B4-4827-899D-C2740DF3E5DA");
// Remove Block: Categories, from Page: System Email Categories, Site: Rock RMS
RockMigrationHelper.DeleteBlock("550D7229-2788-4C0E-BFE6-4AAE95D28267");
RockMigrationHelper.DeletePage("B55323CD-F494-43E7-97BF-4E13DAB58E0B"); // Page: System Email Categories, Layout: Full Width, Site: Rock RMS
DropIndex("dbo.AttributeQualifier", "IX_AttributeIdKey");
AlterColumn("dbo.Attribute", "Key", c => c.String(nullable: false, maxLength: 50));
AlterColumn("dbo.AttributeQualifier", "Key", c => c.String(nullable: false, maxLength: 50));
CreateIndex("dbo.AttributeQualifier", new[] { "AttributeId", "Key" }, unique: true, name: "IX_AttributeIdKey");
}
/// <summary>
/// The commands to run to migrate plugin to the specific version
/// </summary>
public override void Up()
{
// SK: Update group view lava template to display schedule when exist (ISSUE #3188)
// Update the default template
Sql(@"
UPDATE
[GroupType]
SET
[GroupViewLavaTemplate] = REPLACE([GroupViewLavaTemplate],'{{ Group.Schedule.ToString()','{{ Group.Schedule.FriendlyScheduleText')
WHERE
[GroupViewLavaTemplate] Like '%{{ Group.Schedule.ToString()%'
");
// Update the system setting
Sql(@"UPDATE
[Attribute]
SET
[DefaultValue] = REPLACE([DefaultValue],'{{ Group.Schedule.ToString()','{{ Group.Schedule.FriendlyScheduleText')
WHERE
[Key]='core_templates_GroupViewTemplate'" );
// SK: Added Other to Currency Type Defined Type
RockMigrationHelper.UpdateDefinedValue(Rock.SystemGuid.DefinedType.FINANCIAL_CURRENCY_TYPE, "Other", "The currency type is other.", SystemGuid.DefinedValue.CURRENCY_TYPE_OTHER, true);
// NA: Enable AllowGroupSync for Communication List type groups (Fixes #3223).
Sql(string.Format("UPDATE [GroupType] SET [AllowGroupSync] = 1 WHERE [AllowGroupSync] = 0 AND [Guid] = '{0}'", Rock.SystemGuid.GroupType.GROUPTYPE_COMMUNICATIONLIST));
// NA: Make Personal Device Platform Defined Values IsSystem=true
// Fix Personal Device Platform Defined Values to IsSystem=true
Sql(string.Format("UPDATE [DefinedValue] SET [IsSystem] = 1 WHERE [IsSystem] = 0 AND [Guid] = '{0}'", Rock.SystemGuid.DefinedValue.PERSONAL_DEVICE_PLATFORM_ANDROID));
Sql(string.Format("UPDATE [DefinedValue] SET [IsSystem] = 1 WHERE [IsSystem] = 0 AND [Guid] = '{0}'", Rock.SystemGuid.DefinedValue.PERSONAL_DEVICE_PLATFORM_IOS));
// NA: Fix FrontPorch Device Platform Defined Values IsSystem=true
// Fix FrontPorch Device Platform Defined Values IsSystem=true
// NOTE: These do not have a well-known GUIDs so we will target them via their value and description.
Sql(string.Format("UPDATE [DefinedValue] SET [IsSystem] = 1 WHERE [IsSystem] = 0 AND [DefinedTypeId] = ( SELECT [Id] FROM [DefinedType] WHERE [Guid] = '{0}' ) AND [Value] = 'Windows' AND [Description] = 'A Windows device'", Rock.SystemGuid.DefinedType.PERSONAL_DEVICE_PLATFORM));
Sql(string.Format("UPDATE [DefinedValue] SET [IsSystem] = 1 WHERE [IsSystem] = 0 AND [DefinedTypeId] = ( SELECT [Id] FROM [DefinedType] WHERE [Guid] = '{0}' ) AND [Value] = 'Mac' AND [Description] = 'A Macintosh device'", Rock.SystemGuid.DefinedType.PERSONAL_DEVICE_PLATFORM));
// Fix for metrics that might have been added without a Created,Modified, or LastRunDateTime
Sql(@"UPDATE Metric
SET ModifiedDateTime = SysDateTime()
WHERE ModifiedDateTime IS NULL");
}
public override void Up()
{
// Page: OAuth Configuration
RockMigrationHelper.AddPage("91CCB1C9-5F9F-44F5-8BE2-9EC3A3CFD46F", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "OAuth Configuration", "", "C2B15044-B63C-43EB-BADC-9730890F4621", "fa fa-cloud"); // Site:Rock RMS
RockMigrationHelper.UpdateBlockType("OAuth Configuration", "Configuration settings for OAuth.", "~/Plugins/org_secc/OAuth/Configuration.ascx", "SECC > Security", "34680C7A-84DF-413A-A474-3495C65372DA");
RockMigrationHelper.AddBlock("C2B15044-B63C-43EB-BADC-9730890F4621", "", "34680C7A-84DF-413A-A474-3495C65372DA", "OAuth Configuration", "Main", "", "", 0, "3339F274-F61D-4CAA-AA8D-EC84E3290FC7");
RockMigrationHelper.AddBlockTypeAttribute("34680C7A-84DF-413A-A474-3495C65372DA", "9C204CD0-1233-41C5-818A-C5DA439445AA", "OAuth Config Attribute Key", "OAuthConfigAttributeKey", "", "The OAuth Configuration Attribute\"s Key", 0, @"OAuthSettings", "3CE5DD1F-C69F-483D-B6BF-57FE0ED4C8AA");
RockMigrationHelper.AddBlockTypeAttribute("34680C7A-84DF-413A-A474-3495C65372DA", "BB7AB90F-4DE9-4804-A852-F5593A35C8A0", "OAuth Site", "OAuthSite", "", "The OAuth Porta/Site", 0, @"1", "5ED9C998-F7D0-4057-93B6-F4B4FE0837DA");
RockMigrationHelper.AddBlockAttributeValue("3339F274-F61D-4CAA-AA8D-EC84E3290FC7", "3CE5DD1F-C69F-483D-B6BF-57FE0ED4C8AA", @"OAuthSettings"); // OAuth Config Attribute Key
// Get the site so we can get its ID
Rock.Model.SiteService siteService = new Rock.Model.SiteService(new Rock.Data.RockContext());
Rock.Model.Site site = siteService.Get("92A541DB-F88C-4EEA-B015-B67497C5B2A0".AsGuid());
RockMigrationHelper.AddBlockAttributeValue("3339F274-F61D-4CAA-AA8D-EC84E3290FC7", "5ED9C998-F7D0-4057-93B6-F4B4FE0837DA", site.Id.ToString()); // OAuth Site
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
AlterColumn("dbo.FinancialScheduledTransaction", "LastStatusUpdateDateTime", c => c.DateTime());
// Add ContextAware attribute for HTML Content Block
RockMigrationHelper.UpdateBlockTypeAttribute("19B61D65-37E3-459F-A44F-DEF0089118A3", "3549BAB6-FE1B-4333-AFC4-C5ACA01BB8EB", "Entity Type", "ContextEntityType", "", "The type of entity that will provide context for this block", 0, "", "6783D47D-92F9-4F48-93C0-16111D675A0F");
// Remove prehtml headers from blocks on person detail pages now that grid blocks have a nice header.
Sql(@"
UPDATE [Block] SET [PreHtml] = ''
WHERE [Guid] IN (
'B33DF8C4-29B2-4DC5-B182-61FC255B01C0',
'9382B285-3EF6-47F7-94BB-A47C498196A3',
'1CBE10C7-5E64-4385-BEE3-81DCA43DC47F',
'68D34EC2-0A10-4344-89E3-E6DF99951FDB',
'F98649D7-E522-46CB-8F67-01DB7F59E3AA'
)
");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
AddColumn("dbo.WorkflowType", "IconCssClass", c => c.String());
Sql(@"UPDATE [WorkflowType] SET [IconCssClass] = 'fa fa-list-ol'");
// Grant Staff and Staff-Like roles edit access to the Known Relationships group type
RockMigrationHelper.DeleteSecurityAuthForGroupType("E0C5A0E2-B7B3-4EF4-820D-BBF7F9A374EF");
RockMigrationHelper.AddSecurityAuthForGroupType("E0C5A0E2-B7B3-4EF4-820D-BBF7F9A374EF", 0, "Edit", true, "2C112948-FF4C-46E7-981A-0257681EADF4", Model.SpecialRole.None, "C463D46C-DE81-4B78-828F-D219198DCB94");
RockMigrationHelper.AddSecurityAuthForGroupType("E0C5A0E2-B7B3-4EF4-820D-BBF7F9A374EF", 1, "Edit", true, "300BA2C8-49A3-44BA-A82A-82E3FD8C3745", Model.SpecialRole.None, "2F714BE7-FC9C-4DE6-9F3B-C5616F77ED71");
Sql(@"
IF OBJECT_ID('[dbo].[ufnUtility_GetPersonIdFromPersonAlias]', 'FN') IS NOT NULL
DROP FUNCTION [dbo].[ufnUtility_GetPersonIdFromPersonAlias]
");
Sql(@"
/*
<doc>
<summary>
This function returns the person id for the person alias given.
</summary>
<returns>
Int of the person id
</returns>
<remarks>
</remarks>
<code>
SELECT [dbo].[ufnUtility_GetPersonIdFromPersonAlias](1)
</code>
</doc>
*/
CREATE FUNCTION [dbo].[ufnUtility_GetPersonIdFromPersonAlias](@PersonAlias int)
RETURNS int AS
BEGIN
RETURN (SELECT [PersonId] FROM PersonAlias WHERE [Id] = @PersonAlias)
END
");
}
/// <summary>
/// Operations to be performed during the downgrade process.
/// </summary>
public override void Down()
{
RockMigrationHelper.DeleteAttribute("3B234A62-B87D-47CD-A33F-32CC6C840A02");
RockMigrationHelper.DeleteAttribute("B6EF4138-C488-4043-A628-D35F91503843");
RockMigrationHelper.DeleteAttribute("A4E00B14-8CFF-4719-A43F-462851C7BBEF");
RockMigrationHelper.DeleteAttribute("DA46DC37-5398-4520-B6A5-6E57C9C46F7A");
RockMigrationHelper.DeleteAttribute("7D785A5D-53CA-4FEC-BC88-DFBD7439B547");
RockMigrationHelper.DeleteAttribute("6FF59F53-28EA-4BFE-AFE1-A459CC588495");
RockMigrationHelper.DeleteDefinedType("407A3A73-A3EF-4970-B856-2A33F62AC72E");
RockMigrationHelper.DeleteDefinedType("D7979EA1-44E9-46E2-BF37-DDAF7F741378");
DropForeignKey("dbo.WorkflowActivity", "AssignedPersonAliasId", "dbo.PersonAlias");
DropForeignKey("dbo.WorkflowActivity", "AssignedGroupId", "dbo.Group");
DropIndex("dbo.WorkflowActivity", new[] { "AssignedGroupId" });
DropIndex("dbo.WorkflowActivity", new[] { "AssignedPersonAliasId" });
DropColumn("dbo.WorkflowActivity", "AssignedGroupId");
DropColumn("dbo.WorkflowActivity", "AssignedPersonAliasId");
}
/// <summary>
/// Script generated "Up" migrations for pages, blocks, and block attributes.
/// </summary>
private void CodeGenMigrationsUp()
{
RockMigrationHelper.UpdateMobileBlockType("Structured Content View", "Displays a structured content channel item for the user to view and fill out.", "Rock.Blocks.Types.Mobile.Cms.StructuredContentView", "Mobile > Cms", "EA048472-D4BD-4966-83B7-00695D458685");
RockMigrationHelper.UpdateMobileBlockType("Calendar Event Item Occurrence View", "Displays a particular calendar event item occurrence.", "Rock.Blocks.Types.Mobile.Events.CalendarEventItemOccurrenceView", "Mobile > Events", "F6131B1A-3464-4E8A-BB14-C558FF2D63EC");
// Attrib for BlockType: Calendar Event Item Occurrence View:Registration Url
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("F6131B1A-3464-4E8A-BB14-C558FF2D63EC", "9C204CD0-1233-41C5-818A-C5DA439445AA", "Registration Url", "RegistrationUrl", "Registration Url", @"The base URL to use when linking to the registration page.", 0, @"", "CD802FC7-448E-4DAF-854F-DFBC3F812C83");
// Attrib for BlockType: Calendar Event Item Occurrence View:Template
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("F6131B1A-3464-4E8A-BB14-C558FF2D63EC", "CCD73456-C83B-4D6E-BD69-8133D2EB996D", "Template", "Template", "Template", @"The template to use when rendering the event.", 1, @"6593D4EB-2B7A-4C24-8D30-A02991D26BC0", "88FB2AD3-2120-4E82-A11A-61DB448B77C2");
// Attrib for BlockType: Group Edit:Show Header
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("FEC66374-E38F-4651-BAA6-AC658409D9BD", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Show Header", "EnableHeader", "Show Header", @"If enabled, a 'Group Details' header will be displayed.", 0, @"True", "E5000EFA-D3A4-48C3-AB7D-7161AFA18FC7");
// Attrib for BlockType: Group Member Edit:Show Header
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("514B533A-8970-4628-A4C8-35388CD869BC", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Show Header", "EnableHeader", "Show Header", @"If enabled, a 'Group Member Edit' header will be displayed.", 0, @"True", "096EB064-699C-492E-A4A6-8DB5B4F288B1");
// Attrib for BlockType: Prayer Request Details:Show Header
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("EBB91B46-292E-4784-9E37-38781C714008", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Show Header", "EnableHeader", "Show Header", @"If enabled, a 'Add/Edit Prayer Request' header will be displayed.", 2, @"True", "D847C303-4FF4-4A84-A1EB-4734DCA3F886");
// Attrib for BlockType: Service Metrics Entry:Insert 0 for Blank Items
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("535E1879-CD4C-432B-9312-B27B3A668D88", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Insert 0 for Blank Items", "DefaultToZero", "Insert 0 for Blank Items", @"If enabled, a zero will be added to any metrics that are left empty when entering data.", 5, @"false", "2E147365-0BB3-4B1B-B18F-12CB262F8D24");
// Attrib for BlockType: Service Metrics Entry:Metric Date Determined By
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("535E1879-CD4C-432B-9312-B27B3A668D88", "7525C4CB-EE6B-41D4-9B64-A08048D5A5C0", "Metric Date Determined By", "MetricDateDeterminedBy", "Metric Date Determined By", @"This setting determines what date to use when entering the metric. 'Sunday Date' would use the selected Sunday date. 'Day from Schedule' will use the first day configured from the selected schedule.", 6, @"0", "62BA1A48-EEE3-4569-8F56-717087CB1B88");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
// Rename blocktypes
RockMigrationHelper.RenameBlockType("~/Blocks/Event/CalendarItemDetail.ascx", "~/Blocks/Event/EventItemDetail.ascx", null, "Calendar Event Item Detail", "Displays the details of the given calendar event item.");
RockMigrationHelper.RenameBlockType("~/Blocks/Event/CalendarItemList.ascx", "~/Blocks/Event/EventItemList.ascx", null, "Calendar Event Item List", "Lists all the event items in the given calendar.");
RockMigrationHelper.RenameBlockType("~/Blocks/Event/CalendarItemOccurrenceDetail.ascx", "~/Blocks/Event/EventItemOccurrenceDetail.ascx", null, "Calendar Event Item Occurrence Detail", "Displays the details of a given calendar event item occurrence.");
RockMigrationHelper.RenameBlockType("~/Blocks/Event/CalendarItemLava.ascx", "~/Blocks/Event/EventItemOccurrenceLava.ascx", null, "Calendar Event Item Occurrence Lava", "Renders a particular calendar event item occurrence using Lava.");
RockMigrationHelper.RenameBlockType("~/Blocks/Event/CalendarItemOccurrenceList.ascx", "~/Blocks/Event/EventItemOccurrenceList.ascx", null, "Calendar Event Item Occurrence List", "Displays the occurrence details for a given calendar event item.");
// Attrib for BlockType: Group Detail:Event Item Occurrence Page
RockMigrationHelper.AddBlockTypeAttribute("582BEEA1-5B27-444D-BC0A-F60CEB053981", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Event Item Occurrence Page", "EventItemOccurrencePage", "", "The page to display event item occurrence details.", 8, @"", "6114CE99-C97F-4394-93F5-B34D479AB54E");
// Attrib for BlockType: Group Detail:Content Item Page
RockMigrationHelper.AddBlockTypeAttribute("582BEEA1-5B27-444D-BC0A-F60CEB053981", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Content Item Page", "ContentItemPage", "", "The page to display registration details.", 9, @"", "45897721-F38C-4B4B-BCF9-A81D27DBB731");
// Attrib Value for Block:GroupDetailRight, Attribute:Event Item Occurrence Page Page: Group Viewer, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("88344FE3-737E-4741-A38D-D2D3A1653818", "6114CE99-C97F-4394-93F5-B34D479AB54E", @"4b0c44ee-28e3-4753-a95b-8c57cd958fd1");
// Attrib Value for Block:GroupDetailRight, Attribute:Content Item Page Page: Group Viewer, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("88344FE3-737E-4741-A38D-D2D3A1653818", "45897721-F38C-4B4B-BCF9-A81D27DBB731", @"d18e837c-9e65-4a38-8647-dff04a595d97");
}
/// <summary>
/// Script generated "Down" migrations for pages, blocks, and block attributes.
/// </summary>
private void CodeGenMigrationsDown()
{
// Attrib for BlockType: Service Metrics Entry:Metric Date Determined By
RockMigrationHelper.DeleteAttribute("62BA1A48-EEE3-4569-8F56-717087CB1B88");
// Attrib for BlockType: Service Metrics Entry:Insert 0 for Blank Items
RockMigrationHelper.DeleteAttribute("2E147365-0BB3-4B1B-B18F-12CB262F8D24");
// Attrib for BlockType: Prayer Request Details:Show Header
RockMigrationHelper.DeleteAttribute("D847C303-4FF4-4A84-A1EB-4734DCA3F886");
// Attrib for BlockType: Group Member Edit:Show Header
RockMigrationHelper.DeleteAttribute("096EB064-699C-492E-A4A6-8DB5B4F288B1");
// Attrib for BlockType: Group Edit:Show Header
RockMigrationHelper.DeleteAttribute("E5000EFA-D3A4-48C3-AB7D-7161AFA18FC7");
// Attrib for BlockType: Calendar Event Item Occurrence View:Template
RockMigrationHelper.DeleteAttribute("88FB2AD3-2120-4E82-A11A-61DB448B77C2");
// Attrib for BlockType: Calendar Event Item Occurrence View:Registration Url
RockMigrationHelper.DeleteAttribute("CD802FC7-448E-4DAF-854F-DFBC3F812C83");
RockMigrationHelper.DeleteBlockType("F6131B1A-3464-4E8A-BB14-C558FF2D63EC"); // Calendar Event Item Occurrence View
RockMigrationHelper.DeleteBlockType("EA048472-D4BD-4966-83B7-00695D458685"); // Structured Content View
}
/// <summary>
/// Operations to be performed during the downgrade process.
/// </summary>
public override void Down()
{
// Attrib for BlockType: Workflow Entry:Block Title Template
RockMigrationHelper.DeleteAttribute("6E7AC3BE-50D0-4219-BC6A-703821DC785F");
// Attrib for BlockType: Workflow Entry:Block Title Icon CSS Class
RockMigrationHelper.DeleteAttribute("A5A2897F-6448-45C2-BC9D-44F0E35E9192");
// Attrib for BlockType: Attempt Detail:Achievement Type Page
RockMigrationHelper.DeleteAttribute("4B405599-63FB-4704-8CB6-4A4CCA4F3EA5");
// Attrib for BlockType: Attempt Detail:Streak Page
RockMigrationHelper.DeleteAttribute("888C0B9A-CB02-4EF9-822E-F4BE36117395");
// Attrib for BlockType: Achievement Attempt List:Detail Page
RockMigrationHelper.DeleteAttribute("9C433A89-4D86-4E44-8B5E-03E4B00AEB9D");
// Attrib for BlockType: Streak Detail:Achievement Attempts Page
RockMigrationHelper.DeleteAttribute("B718AC3A-BD27-49EF-86CB-73DEF7A57E28");
// Attrib for BlockType: Achievement Type List:Detail Page
RockMigrationHelper.DeleteAttribute("6B9C55E0-8F30-4A17-BB6C-248208AD6CA6");
// Attrib for BlockType: Streak Type Detail:Achievements Page
RockMigrationHelper.DeleteAttribute("6D4C96F2-8FDC-4A6D-AC35-CCD6EF180694");
// Remove Block: Attempt Detail, from Page: Attempt, Site: Rock RMS
RockMigrationHelper.DeleteBlock("09AA3694-A9C7-485D-9F1E-A14ADCDA5161");
// Remove Block: Attempt Detail, from Page: Attempt, Site: Rock RMS
RockMigrationHelper.DeleteBlock("E9FAD400-E681-491D-9183-B719F78B5A49");
// Remove Block: Streak Map Editor, from Page: Exclusion, Site: Rock RMS
RockMigrationHelper.DeleteBlock("03F9510D-4E40-4ED4-8727-5AC0D62E4A78");
// Remove Block: Achievement Attempt List, from Page: Achievement Attempts, Site: Rock RMS
RockMigrationHelper.DeleteBlock("88079A6C-F2E8-4BC9-8C7F-DA7BBB5CEE70");
// Remove Block: Achievement Attempt List, from Page: Achievement Type, Site: Rock RMS
RockMigrationHelper.DeleteBlock("D3E699FC-2D8E-4698-90D6-CA351C886AEC");
// Remove Block: Achievement Type Detail, from Page: Achievement Type, Site: Rock RMS
RockMigrationHelper.DeleteBlock("169078DD-3255-4E84-A4C1-01C0440C1922");
// Remove Block: Achievement Type List, from Page: Achievement Types, Site: Rock RMS
RockMigrationHelper.DeleteBlock("B131FE34-E236-4044-B5D0-22AD3F71A471");
RockMigrationHelper.DeleteBlockType("7E4663CD-2176-48D6-9CC2-2DBC9B880C23"); // Attempt Detail
RockMigrationHelper.DeleteBlockType("9C1236AE-4FF0-480C-A7DF-0E5277CA75FB"); // Achievement Attempt List
RockMigrationHelper.DeleteBlockType("4C4A46CD-1622-4642-A655-11585C5D3D31"); // Achievement Type Detail
RockMigrationHelper.DeleteBlockType("D2F918CF-F63C-4643-A02A-FD3DE7C5CFFD"); // Achievement Type List
RockMigrationHelper.DeletePage("D3BE86DE-7237-4FE9-9F5D-3C08BD7F9F97"); // Page: Attempt, Layout: Full Width, Site: Rock RMS
RockMigrationHelper.DeletePage("75CDD408-3E1B-4EF3-9A6F-4DC76B92A80F"); // Page: Attempt, Layout: Full Width, Site: Rock RMS
RockMigrationHelper.DeletePage("4AC3D8B7-1A8A-40F9-8F51-8E09B863BA40"); // Page: Achievement Attempts, Layout: Full Width, Site: Rock RMS
RockMigrationHelper.DeletePage("1C378B3C-9721-4A9B-857A-E3C5188C5BF8"); // Page: Achievement Type, Layout: Full Width, Site: Rock RMS
RockMigrationHelper.DeletePage("FCE0D006-F854-4107-9298-667563FA8D77"); // Page: Achievement Types, Layout: Full Width, Site: Rock RMS
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
RockMigrationHelper.AddDefinedValue_pre20140819("1FAC459C-5F62-4E7C-8933-61FF9FE2DFEF", "Rock Windows Check-in Client", "The Windows Check-in Client hosts the Rock check-in screens and allows client based printing to either networked or USB printers.", "C162F21E-7D86-4BB4-A72C-7F4A0E5B02C3");
Sql(@"
declare
@attributeIconId int = (select [Id] from [Attribute] where [Guid] = 'C6E82AF0-2128-492B-B5CB-7915630DDA0B'),
@attributeVendorId int = (select [Id] from [Attribute] where [Guid] = 'E9AAE4D6-B4DC-4AA2-BD86-D63B2B4D26F3'),
@attributeDownloadUrlId int = (select [Id] from [Attribute] where [Guid] = 'E0AF9B30-15EA-413B-BAC4-25B286D91FD9'),
@definedValueCheckinClientId int = (select [Id] from [DefinedValue] where [Guid] = 'C162F21E-7D86-4BB4-A72C-7F4A0E5B02C3')
-- SVG Icons
INSERT INTO [dbo].[BinaryFile] ([IsTemporary], [IsSystem], [BinaryFileTypeId], [Url], [FileName], [MimeType], [Description], [StorageEntityTypeId], [Guid])
VALUES
(0, 0, 3, N'~/GetFile.ashx?guid=D128A532-A99A-430A-955B-C1444E87C053', N'checkin-client.svg', N'image/svg+xml', null, 51, N'D128A532-A99A-430A-955B-C1444E87C053')
EXEC(N'INSERT INTO [dbo].[BinaryFileData] ([Id], [Content], [Guid]) VALUES ((select [Id] from BinaryFile where [Guid] = N''D128A532-A99A-430A-955B-C1444E87C053''), 0x3C3F786D6C2076657273696F6E3D22312E302220656E636F64696E673D227574662D38223F3E0D0A3C212D2D2047656E657261746F723A2041646F626520496C6C7573747261746F722031362E302E302C20535647204578706F727420506C75672D496E202E205356472056657273696F6E3A20362E3030204275696C6420302920202D2D3E0D0A3C21444F435459504520737667205055424C494320222D2F2F5733432F2F4454442053564720312E312F2F454E222022687474703A2F2F7777772E77332E6F72672F47726170686963732F5356472F312E312F4454442F73766731312E647464223E0D0A3C7376672076657273696F6E3D22312E31222069643D224C617965725F312220786D6C6E733D22687474703A2F2F7777772E77332E6F72672F323030302F7376672220786D6C6E733A786C696E6B3D22687474703A2F2F7777772E77332E6F72672F313939392F786C696E6B2220783D223070782220793D22307078220D0A092077696474683D223230392E35707822206865696768743D223138342E3430367078222076696577426F783D22302030203230392E35203138342E3430362220656E61626C652D6261636B67726F756E643D226E657720302030203230392E35203138342E3430362220786D6C3A73706163653D227072657365727665223E0D0A3C673E0D0A093C636972636C652066696C6C3D2223464646464646222063783D223130372E383233222063793D2239342E3835312220723D2236352E353431222F3E0D0A093C706174682066696C6C3D22233235323532352220643D224D3130362E3732312C3137322E373636632D34342E3236382C302D38302E3138342D33352E3931362D38302E3138342D38302E31383363302D34342E3236382C33352E3931362D38302E3138342C38302E3138342D38302E3138340D0A09096334342E3236372C302C38302E3138332C33352E3931362C38302E3138332C38302E313834433138362E3930332C3133362E38352C3135302E3938372C3137322E3736362C3130362E3732312C3137322E3736367A204D3130362E3732312C33352E3738370D0A0909632D33312E3332322C302D35362E3739372C32352E3437352D35362E3739372C35362E37393763302C33312E33322C32352E3437352C35362E3739352C35362E3739372C35362E3739356333312E33322C302C35362E3739352D32352E3437352C35362E3739352D35362E3739350D0A0909433136332E3531362C36312E3236322C3133382E3034312C33352E3738372C3130362E3732312C33352E3738377A222F3E0D0A093C706174682066696C6C3D22233742433336342220643D224D3130362E3837372C3132392E303436632D322E36312C322E3630392D362E3738372C322E3630392D392E3339372C304C36362E3738352C39382E333531632D322E36312D322E3630392D322E36312D362E3738372C302D392E3339360D0A09096C31302E36352D31302E36343963322E36312D322E3630392C362E3738362D322E3630392C392E3339362C306C31352E3334382C31352E3334376C32382E3731312D32382E37313163322E3630392D322E36312C362E3738372D322E36312C392E3339362C306C31302E3634392C31302E3634390D0A090963322E3630392C322E3630392C322E3630392C362E3738372C302C392E3339364C3130362E3837372C3132392E3034367A222F3E0D0A3C2F673E0D0A3C2F7376673E0D0A, N''F9533ACE-CD63-407E-8877-CA9B98E724FF'')')
INSERT INTO [dbo].[AttributeValue] ([IsSystem],[AttributeId],[EntityId],[Order],[Value],[Guid])
VALUES
(1, @attributeIconId, @definedValueCheckinClientId, 0, (select Id from BinaryFile where Guid = 'D128A532-A99A-430A-955B-C1444E87C053'), 'AE028EAA-E366-4602-AC79-517A5F0D5CA9')
-- Vendor
INSERT INTO [dbo].[AttributeValue] ([IsSystem],[AttributeId],[EntityId],[Order],[Value],[Guid])
VALUES
(1, @attributeVendorId, @definedValueCheckinClientId, 0, 'Spark Development Network', '553E580E-B37D-4503-A845-55B8244E80B7')
-- DownloadUrl
INSERT INTO [dbo].[AttributeValue] ([IsSystem],[AttributeId],[EntityId],[Order],[Value],[Guid])
VALUES
(1, @attributeDownloadUrlId, @definedValueCheckinClientId, 0, 'http://storage.rockrms.com/externalapplications/sparkdevnetwork/windowscheckin/1.0.10/checkinclient.exe', '7ADC1B5B-D374-4B77-9DE1-4D788B572A10')
");
// update new location of statementgenerator installer
Sql("UPDATE [AttributeValue] set [Value] = 'http://storage.rockrms.com/externalapplications/sparkdevnetwork/statementgenerator/1.0.10/statementgenerator.exe' where [Guid] = '10BE2E03-7827-41B5-8CB2-DEB473EA107A'");
// Attrib for BlockType: Business Detail:Person Profile Page
RockMigrationHelper.AddBlockTypeAttribute("3CB1F9F0-11B2-4A46-B9D1-464811E5015C", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Person Profile Page", "PersonProfilePage", "", "The page used to view the details of a business contact", 0, @"", "19BA2FF7-09ED-4CD3-9B13-006650EC6C67");
// Attrib Value for Block:Business Detail, Attribute:Person Profile Page Page: Business Detail, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("77AB2D30-FCBE-45E9-9757-401AE2676A7F", "19BA2FF7-09ED-4CD3-9B13-006650EC6C67", @"08dbd8a5-2c35-4146-b4a8-0f7652348b25");
}
private void PagesBlocks_Down()
{
// Remove Block
// Name: Rock Security Settings, from Page: Security Settings, Site: Rock RMS
// from Page: Security Settings, Site: Rock RMS
RockMigrationHelper.DeleteBlock("CC957809-5DA9-47A2-A55D-63F612478722");
// Delete BlockType
// Name: Rock Security Settings
// Category: Security
// Path: ~/Blocks/Security/RockSecuritySettings.ascx
// EntityType: -
RockMigrationHelper.DeleteBlockType("186490CD-4132-43BD-9BDF-DD04C6CD2432");
// Delete Page
// Internal Name: Security Settings
// Site: Rock RMS
// Layout: Full Width
RockMigrationHelper.DeletePage("0EF3DE1C-CB97-431E-A066-DDF8BD2D8283");
}
/// <summary>
/// Operations to be performed during the downgrade process.
/// </summary>
public override void Down()
{
//
// Note Types
//
RockMigrationHelper.DeleteDefinedValue("EBB52236-B29A-4E00-B176-15B351679F99");
RockMigrationHelper.DeleteDefinedValue("68221BAB-13E6-43BB-9CEA-81507C5E4BAF");
RockMigrationHelper.DeleteDefinedValue("643FC41E-AF5C-4FD1-8118-8DAAE254DAA5");
RockMigrationHelper.DeleteDefinedValue("128C609C-1601-4247-8BA2-6CB60AB2562C");
RockMigrationHelper.DeleteDefinedValue("A52CEA75-CD49-43F7-82FF-D781835EB73F");
RockMigrationHelper.DeleteDefinedValue("EF911C5F-A922-4B21-B601-FD306538B0E2");
RockMigrationHelper.DeleteDefinedValue("B6B4ACE8-6B7E-4A67-AFFF-2CBEFC6C1BBF");
RockMigrationHelper.DeleteDefinedValue("9304261A-2369-4830-B5EE-77BE3C42E9BF");
//
// Delete security settings for content channels
//
Sql(@"DELETE FROM [Auth] WHERE [Guid] in ( 'E7874EFF-F507-44EB-9405-D8A6FBA2F21C', 'D154C7B3-EC9F-4C93-BBE9-CE943712939E', '9FB9F2DA-04FF-49C3-A0E3-C09C2E130F6E' )");
}
/// <summary>
/// Codes the gen migrations down.
/// </summary>
private void CodeGenMigrationsDown()
{
// Attrib for BlockType: Workflow Type Detail:Export Workflows Page
RockMigrationHelper.DeleteAttribute("4C602FC8-6E80-4E5A-90E4-7F54DFB5A98F");
// Attrib for BlockType: SMS Conversations:Enable SMS Send
RockMigrationHelper.DeleteAttribute("EE7FD478-70BE-44D7-A40F-02EF4AAFEB71");
// Attrib for BlockType: SMS Conversations:Hide personal SMS numbers
RockMigrationHelper.DeleteAttribute("09A89FDD-D3E4-43F3-95AE-D080F959FF0A");
// Attrib for BlockType: SMS Conversations:Show only personal SMS number
RockMigrationHelper.DeleteAttribute("CEBF759C-1B83-48BE-82E1-9E6B7C491333");
// Attrib for BlockType: SMS Conversations:Allowed SMS Numbers
RockMigrationHelper.DeleteAttribute("2F486671-07C6-448E-B647-A15C16C5B3A2");
// Attrib for BlockType: SMS Conversations:Person Info Lava Template
RockMigrationHelper.DeleteAttribute("A9AF883A-152E-44D8-AD5E-FD96CAF3A67E");
// Attrib for BlockType: Person Profile:Child Attribute Category
RockMigrationHelper.DeleteAttribute("62D60C22-EE97-4422-A9C7-155E157B0B2A");
// Attrib for BlockType: Person Profile:Adult Attribute Category
RockMigrationHelper.DeleteAttribute("0D34EADF-22B0-4DA7-91EC-1F29A217D943");
RockMigrationHelper.DeleteBlockType("5A074483-2845-4569-B277-3B030DA61111"); // Share Workflow
}
/// <summary>
/// Codes the gen migrations up.
/// </summary>
private void CodeGenMigrationsUp()
{
RockMigrationHelper.UpdateBlockType("Share Workflow", "Export and import workflows from Rock.", "~/Blocks/WorkFlow/ShareWorkflow.ascx", "WorkFlow", "5A074483-2845-4569-B277-3B030DA61111");
// Attrib for BlockType: Workflow Type Detail:Export Workflows Page
RockMigrationHelper.UpdateBlockTypeAttribute("E1FF677D-5E52-4259-90C7-5560ECBBD82B", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Export Workflows Page", "ExportWorkflowsPage", "", @"Page used to export workflows.", 4, @"", "4C602FC8-6E80-4E5A-90E4-7F54DFB5A98F");
// Attrib for BlockType: Person Profile:Adult Attribute Category
RockMigrationHelper.UpdateBlockTypeAttribute("48BBB7A7-1E1D-461E-9B64-E9CAD815E9E1", "309460EF-0CC5-41C6-9161-B3837BA3D374", "Adult Attribute Category", "AdultAttributeCategory", "", @"The adult Attribute Category to display attributes from.", 4, @"", "0D34EADF-22B0-4DA7-91EC-1F29A217D943");
// Attrib for BlockType: Person Profile:Child Attribute Category
RockMigrationHelper.UpdateBlockTypeAttribute("48BBB7A7-1E1D-461E-9B64-E9CAD815E9E1", "309460EF-0CC5-41C6-9161-B3837BA3D374", "Child Attribute Category", "ChildAttributeCategory", "", @"The children Attribute Category to display attributes from.", 3, @"", "62D60C22-EE97-4422-A9C7-155E157B0B2A");
// Attrib for BlockType: SMS Conversations:Person Info Lava Template
RockMigrationHelper.UpdateBlockTypeAttribute("3497603B-3BE6-4262-B7E9-EC01FC7140EB", "1D0D3794-C210-48A8-8C68-3FBEC08A6BA5", "Person Info Lava Template", "PersonInfoLavaTemplate", "", @"A Lava template to display person information about the selected Communication Recipient.", 5, @"", "A9AF883A-152E-44D8-AD5E-FD96CAF3A67E");
// Attrib for BlockType: SMS Conversations:Allowed SMS Numbers
RockMigrationHelper.UpdateBlockTypeAttribute("3497603B-3BE6-4262-B7E9-EC01FC7140EB", "59D5A94C-94A0-4630-B80A-BB25697D74C7", "Allowed SMS Numbers", "AllowedSMSNumbers", "", @"Set the allowed FROM numbers to appear when in SMS mode (if none are selected all numbers will be included). ", 1, @"", "2F486671-07C6-448E-B647-A15C16C5B3A2");
// Attrib for BlockType: SMS Conversations:Show only personal SMS number
RockMigrationHelper.UpdateBlockTypeAttribute("3497603B-3BE6-4262-B7E9-EC01FC7140EB", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Show only personal SMS number", "ShowOnlyPersonalSmsNumber", "", @"Only SMS Numbers tied to the current individual will be shown. Those with ADMIN rights will see all SMS Numbers.", 2, @"False", "CEBF759C-1B83-48BE-82E1-9E6B7C491333");
// Attrib for BlockType: SMS Conversations:Hide personal SMS numbers
RockMigrationHelper.UpdateBlockTypeAttribute("3497603B-3BE6-4262-B7E9-EC01FC7140EB", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Hide personal SMS numbers", "HidePersonalSmsNumbers", "", @"Only SMS Numbers that are not associated with a person. The numbers without a 'ResponseRecipient' attribute value.", 3, @"False", "09A89FDD-D3E4-43F3-95AE-D080F959FF0A");
// Attrib for BlockType: SMS Conversations:Enable SMS Send
RockMigrationHelper.UpdateBlockTypeAttribute("3497603B-3BE6-4262-B7E9-EC01FC7140EB", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Enable SMS Send", "EnableSmsSend", "", @"Allow SMS messages to be sent from the block.", 4, @"True", "EE7FD478-70BE-44D7-A40F-02EF4AAFEB71");
}
private void UpdateGradeTransitionDateFieldType()
{
RockMigrationHelper.UpdateFieldType("Month Day", "", "Rock", "Rock.Field.Types.MonthDayFieldType", Rock.SystemGuid.FieldType.MONTH_DAY);
Sql($@"
DECLARE @FieldTypeIdMonthDay INT = (
SELECT TOP 1 Id
FROM FieldType
WHERE [Guid] = '{Rock.SystemGuid.FieldType.MONTH_DAY}'
)
UPDATE Attribute
SET FieldTypeId = @FieldTypeIdMonthDay
,[Description] = 'The date when kids are moved to the next grade level.'
WHERE [Key] = 'GradeTransitionDate'
AND [EntityTypeId] IS NULL
AND (
FieldTypeId != @FieldTypeIdMonthDay
OR [Description] != 'The date when kids are moved to the next grade level.'
)
");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
// Add/Update Obsidian Block Type
// Name:Control Gallery
// Category:Obsidian > Example
// EntityType:Rock.Blocks.Example.ControlGallery
RockMigrationHelper.UpdateMobileBlockType("Control Gallery", "Allows the user to try out various controls.", "Rock.Blocks.Example.ControlGallery", "Obsidian > Example", "6FAB07FF-D4C6-412B-B13F-7B881ECBFAD0");
// Add/Update Obsidian Block Type
// Name:Field Type Gallery
// Category:Obsidian > Example
// EntityType:Rock.Blocks.Example.FieldTypeGallery
RockMigrationHelper.UpdateMobileBlockType("Field Type Gallery", "Allows the user to try out various field types.", "Rock.Blocks.Example.FieldTypeGallery", "Obsidian > Example", "50B7B326-8212-44E6-8CF6-515B1FF75A19");
// Attribute for BlockType
// BlockType: Attendance Analytics
// Category: Check-in
// Attribute: Database Timeout
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("3CD3411C-C076-4344-A9D5-8F3B4F01E31D", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Database Timeout", "DatabaseTimeoutSeconds", "Database Timeout", @"The number of seconds to wait before reporting a database timeout.", 15, @"180", "F1DE6A0D-A1BE-494F-BC0E-1CAE42AED897");
}
private void AddUpdateDefinedValuesFor_COMMUNICATION_SMS_FROM_Down()
{
// Edit DT Attribute Response Recipient and make optional
RockMigrationHelper.UpdateDefinedTypeAttribute(Rock.SystemGuid.DefinedType.COMMUNICATION_SMS_FROM,
Rock.SystemGuid.FieldType.PERSON,
"Response Recipient",
"ResponseRecipient",
"The person who should receive responses to the SMS number. This person must have a phone number with SMS enabled or no response will be sent.",
24,
true,
string.Empty,
false,
true,
"E9E82709-5506-4339-8F6A-C2259329A71F");
// Add DT Attribute Enable Mobile Conversations and set to true
RockMigrationHelper.DeleteAttribute("60E05E00-E1A3-46A2-A56D-FE208D91FE4F");
// Add DT Attribute LaunchWorkflowOnResponseReceived
RockMigrationHelper.DeleteAttribute("49C7A5A3-D711-4E41-86E4-06408ED6C1BD");
}
/// <summary>
/// MP: Update CheckinManagerBackButtons
/// </summary>
private void UpdateCheckinManagerBackButtons()
{
// Update javascript so that it works on iOS CheckinClient app
// Add/Update HtmlContent for Block: Back Button (Checkin Manager Roster)
RockMigrationHelper.UpdateHtmlContentBlock("B62CBF17-7FD1-42C8-9E98-00270A34400D",
@"<a href=""javascript:goBack();"" class=""btn btn-nav-zone""><i class=""fa fa-chevron-left""></i></a>
<script>
function goBack() {
window.location = document.referrer;
}
</script>", "26988382-5547-41E4-B737-99F0C079A788");
// Add/Update HtmlContent for Block: Back Button (Checkin Manager Attendance Detail)
RockMigrationHelper.UpdateHtmlContentBlock("A9A5FF01-2263-4CE3-82EB-326528BAAD98", @"<a href=""javascript:goBack();"" class=""btn btn-nav-zone""><i class=""fa fa-chevron-left""></i></a>
<script>
function goBack() {
window.location = document.referrer;
}
</script>", "89A52AED-0245-40DF-87D5-C692761B7E5E");
}
private void PagesBlocks_Up()
{
// Add Page
// Internal Name: Security Settings
// Site: Rock RMS
RockMigrationHelper.AddPage(true, "91CCB1C9-5F9F-44F5-8BE2-9EC3A3CFD46F", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Security Settings", "", "0EF3DE1C-CB97-431E-A066-DDF8BD2D8283", "fa fa-shield-alt");
// Add/Update BlockType
// Name: Rock Security Settings
// Category: Security
// Path: ~/Blocks/Security/RockSecuritySettings.ascx
// EntityType: -
RockMigrationHelper.UpdateBlockType("Rock Security Settings", "Block for displaying and editing Rock's security settings.", "~/Blocks/Security/RockSecuritySettings.ascx", "Security", "186490CD-4132-43BD-9BDF-DD04C6CD2432");
// Add Block
// Block Name: Rock Security Settings
// Page Name: Security Settings
// Layout: -
// Site: Rock RMS
RockMigrationHelper.AddBlock(true, "0EF3DE1C-CB97-431E-A066-DDF8BD2D8283".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "186490CD-4132-43BD-9BDF-DD04C6CD2432".AsGuid(), "Rock Security Settings", "Main", @"", @"", 0, "CC957809-5DA9-47A2-A55D-63F612478722");
}
private void UpAddBusinessConversion()
{
// Page: Business Conversion
RockMigrationHelper.AddPage(true, "F4DF4899-2D44-4997-BA9B-9D2C64958A20", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Business Conversion", "", "94B07FB1-41C1-4755-87E4-0892406D1F3D", ""); // Site:Rock RMS
RockMigrationHelper.AddPageRoute("94B07FB1-41C1-4755-87E4-0892406D1F3D", "convertbusiness");
RockMigrationHelper.UpdateBlockType("Convert Business", "Allows you to convert a Person record into a Business and vice-versa.", "~/Blocks/Finance/ConvertBusiness.ascx", "Finance", "155BC217-1B29-4EFA-A7EA-29C075AE96B3");
// Add Block to Page: Business Conversion, Site: Rock RMS
RockMigrationHelper.AddBlock(true, "94B07FB1-41C1-4755-87E4-0892406D1F3D", "", "155BC217-1B29-4EFA-A7EA-29C075AE96B3", "Convert Business", "Main", "", "", 0, "A4C78D56-34F7-4E8B-A8D2-A2CB66CDA515");
// Attrib for BlockType: Convert Business:Default Connection Status
RockMigrationHelper.UpdateBlockTypeAttribute("155BC217-1B29-4EFA-A7EA-29C075AE96B3", "59D5A94C-94A0-4630-B80A-BB25697D74C7", "Default Connection Status", "DefaultConnectionStatus", "", "The default connection status to use when converting a business to a person.", 0, @"", "D5A83572-EA10-4951-A860-B2E26017EF6D");
// Attrib Value for Block:Convert Business, Attribute:Default Connection Status Page: Business Conversion, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("A4C78D56-34F7-4E8B-A8D2-A2CB66CDA515", "D5A83572-EA10-4951-A860-B2E26017EF6D", @"39f491c5-d6ac-4a9b-8ac0-c431cb17d588");
// Add Block to Page: Businesses, Site: Rock RMS
RockMigrationHelper.AddBlock(true, "F4DF4899-2D44-4997-BA9B-9D2C64958A20", "", "19B61D65-37E3-459F-A44F-DEF0089118A3", "Action Links", "Main", @"", @"", 0, "D9B9E00F-399E-4A13-84FF-643E1C90118A");
Sql(@"UPDATE [Block] SET [Order] = 0 WHERE [Guid] = 'D9B9E00F-399E-4A13-84FF-643E1C90118A'"); // Page: Businesses, Zone: Main, Block: Action Links
Sql(@"UPDATE [Block] SET [Order] = 1 WHERE [Guid] = '04E68378-E2F6-465B-925A-D8B124858C44'"); // Page: Businesses, Zone: Main, Block: Business List
// Add/Update HtmlContent for Block: Action Links
RockMigrationHelper.UpdateHtmlContentBlock("D9B9E00F-399E-4A13-84FF-643E1C90118A", @"<div class=""clearfix margin-b-sm""> <a href=""/convertbusiness"" class=""btn btn-default btn-xs pull-right""><i class=""fa fa-exchange""></i> Convert Person/Business</a> </div>", "19496B8B-84BB-4C90-BD75-E4D5DE8DBE48");
}
/// <summary>
/// Operations to be performed during the downgrade process.
/// </summary>
public override void Down()
{
// Attrib for BlockType: Gateway List:Detail Page
RockMigrationHelper.DeleteAttribute("CBDD5D38-07EE-4ED5-8904-AF18F4161037");
// Remove Block: Gateway Detail, from Page: Gateway Detail, Site: Rock RMS
RockMigrationHelper.DeleteBlock("CB7AF6BA-4A89-4653-B4A2-A73999BC7236");
// Remove Block: Gateway List, from Page: Financial Gateways, Site: Rock RMS
RockMigrationHelper.DeleteBlock("80D93241-AB5D-46EC-BC12-0E32C3CA784C");
RockMigrationHelper.DeleteBlockType("32E89BAE-C085-40B3-B872-B62E25A62BDB"); // Gateway List
RockMigrationHelper.DeleteBlockType("B4D8CBCA-00F6-4D81-B8B6-170373D28128"); // Gateway Detail
RockMigrationHelper.DeletePage("24DE6092-CE91-468C-8E49-94DB3875B9B7"); // Page: Gateway Detail, Layout: Full Width, Site: Rock RMS
RockMigrationHelper.DeletePage("F65AA215-8B46-4E34-B709-FA956BF62C30"); // Page: Financial Gateways, Layout: Full Width, Site: Rock RMS
AddColumn("dbo.FinancialPersonSavedAccount", "GatewayEntityTypeId", c => c.Int());
AddColumn("dbo.FinancialScheduledTransaction", "GatewayEntityTypeId", c => c.Int());
AddColumn("dbo.FinancialTransaction", "GatewayEntityTypeId", c => c.Int());
DropForeignKey("dbo.FinancialPersonSavedAccount", "FinancialGatewayId", "dbo.FinancialGateway");
DropForeignKey("dbo.FinancialScheduledTransaction", "FinancialGatewayId", "dbo.FinancialGateway");
DropForeignKey("dbo.FinancialTransaction", "FinancialGatewayId", "dbo.FinancialGateway");
DropForeignKey("dbo.FinancialGateway", "ModifiedByPersonAliasId", "dbo.PersonAlias");
DropForeignKey("dbo.FinancialGateway", "EntityTypeId", "dbo.EntityType");
DropForeignKey("dbo.FinancialGateway", "CreatedByPersonAliasId", "dbo.PersonAlias");
DropIndex("dbo.FinancialPersonSavedAccount", new[] { "FinancialGatewayId" });
DropIndex("dbo.FinancialScheduledTransaction", new[] { "FinancialGatewayId" });
DropIndex("dbo.FinancialGateway", new[] { "Guid" });
DropIndex("dbo.FinancialGateway", new[] { "ModifiedByPersonAliasId" });
DropIndex("dbo.FinancialGateway", new[] { "CreatedByPersonAliasId" });
DropIndex("dbo.FinancialGateway", new[] { "EntityTypeId" });
DropIndex("dbo.FinancialTransaction", new[] { "FinancialGatewayId" });
DropColumn("dbo.FinancialPersonSavedAccount", "FinancialGatewayId");
DropColumn("dbo.FinancialScheduledTransaction", "FinancialGatewayId");
DropColumn("dbo.FinancialTransaction", "FinancialGatewayId");
DropTable("dbo.FinancialGateway");
CreateIndex("dbo.FinancialPersonSavedAccount", "GatewayEntityTypeId");
CreateIndex("dbo.FinancialScheduledTransaction", "GatewayEntityTypeId");
CreateIndex("dbo.FinancialTransaction", "GatewayEntityTypeId");
AddForeignKey("dbo.FinancialPersonSavedAccount", "GatewayEntityTypeId", "dbo.EntityType", "Id");
AddForeignKey("dbo.FinancialScheduledTransaction", "GatewayEntityTypeId", "dbo.EntityType", "Id");
AddForeignKey("dbo.FinancialTransaction", "GatewayEntityTypeId", "dbo.EntityType", "Id");
}