private void PagesAndBlocksUp()
{
RockMigrationHelper.AddPage(true, "199DC522-F4D6-4D82-AF44-3C16EE9D2CDA", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "SMS Pipeline", "", "2277986A-F53D-4E46-B6EC-6BAD1111DA39", "fa fa-sms"); // Site:Rock RMS
RockMigrationHelper.UpdateBlockType("SMS Pipeline", "Configures the pipeline that processes an incoming SMS message.", "~/Blocks/Communication/SmsPipeline.ascx", "Communication", "44C32EB7-4DA3-4577-AC41-E3517442E269");
// Add Block to Page: SMS Pipeline Site: Rock RMS
RockMigrationHelper.AddBlock(true, "2277986A-F53D-4E46-B6EC-6BAD1111DA39".AsGuid(), null, Rock.SystemGuid.Site.SITE_ROCK_INTERNAL.AsGuid(), "44C32EB7-4DA3-4577-AC41-E3517442E269".AsGuid(), "Sms Pipeline", "Main", @"", @"", 0, "F6CA6D07-DDF4-47DD-AA7E-29F5DCCC2DDC");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
RockMigrationHelper.UpdateDefinedValue(Rock.SystemGuid.DefinedType.INTERACTION_CHANNEL_MEDIUM, "PBX CDR", "Used for tracking phone calls coming from phone systems.", SystemGuid.DefinedValue.PBX_CDR_MEDIUM_VALUE);
RockMigrationHelper.AddPage(true, "C831428A-6ACD-4D49-9B2D-046D399E3123", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Phone Systems", "", "A33C221B-F361-437A-BDC1-E46BB3B532EF", "fa fa-phone-square"); // Site:Rock RMS
RockMigrationHelper.UpdateBlockType("Person Preferences", "Allows the person to set their personal preferences.", "~/Blocks/Crm/PersonPreferences.ascx", "CRM", "D2049782-C286-4EE1-94E8-039111E16794");
// Add Block to Page: My Settings, Site: Rock RMS
RockMigrationHelper.AddBlock(true, "CF54E680-2E02-4F16-B54B-A2F2D29CD932", "", "D2049782-C286-4EE1-94E8-039111E16794", "Person Preferences", "Feature", @"", @"", 0, "D7578388-BDEB-4E5F-9F35-DF98925027D7");
// Add Block to Page: Phone Systems, Site: Rock RMS
RockMigrationHelper.AddBlock(true, "A33C221B-F361-437A-BDC1-E46BB3B532EF", "", "21F5F466-59BC-40B2-8D73-7314D936C3CB", "Components", "Main", @"", @"", 0, "231B1FBC-7399-4453-A012-66E9A2783DE3");
// Attrib for BlockType: Person Bio:Enable Call Origination
RockMigrationHelper.UpdateBlockTypeAttribute("0F5922BB-CD68-40AC-BF3C-4AAB1B98760C", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Enable Call Origination", "EnableCallOrigination", "", @"Should click-to-call links be added to phone numbers.", 14, @"True", "5E066824-0ECE-46D1-B1B3-98E9D8D2FD5B");
// Attrib Value for Block:Bio, Attribute:Enable Call Origination , Layout: PersonDetail, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("B5C1FDB6-0224-43E4-8E26-6B2EAF86253A", "5E066824-0ECE-46D1-B1B3-98E9D8D2FD5B", @"True");
// Attrib Value for Block:Components, Attribute:Component Container Page: Phone Systems, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("231B1FBC-7399-4453-A012-66E9A2783DE3", "259AF14D-0214-4BE4-A7BF-40423EA07C99", @"Rock.Pbx.PbxContainer, Rock");
// Attrib Value for Block:Components, Attribute:Support Ordering Page: Phone Systems, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("231B1FBC-7399-4453-A012-66E9A2783DE3", "A4889D7B-87AA-419D-846C-3E618E79D875", @"True");
// Attrib Value for Block:Components, Attribute:core.CustomGridColumnsConfig Page: Phone Systems, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("231B1FBC-7399-4453-A012-66E9A2783DE3", "DACB8566-FD46-4905-BCAD-460BEECCFF5A", @"");
// Font Awesome Page/Block
RockMigrationHelper.AddPage(true, "B4A24AB7-9369-4055-883F-4F4892C39AE3", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Font Awesome Settings", "", "BB2AF2B3-6D06-48C6-9895-EDF2BA254533", "fa fa-flag"); // Site:Rock RMS
RockMigrationHelper.UpdateBlockType("Font Awesome Settings", "Block that can be used to configure Font Awesome", "~/Blocks/Cms/FontAwesomeSettings.ascx", "CMS", "5150C021-3BA5-4CCC-B943-52AABD49D481");
// Add Block to Page: Font Awesome Settings, Site: Rock RMS
RockMigrationHelper.AddBlock(true, "BB2AF2B3-6D06-48C6-9895-EDF2BA254533", "", "5150C021-3BA5-4CCC-B943-52AABD49D481", "Font Awesome Settings", "Main", @"", @"", 0, "F820E008-7754-4A92-ADB9-80D1BF662E2B");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
CreateIndex("dbo.EventItem", "PhotoId");
Sql("Update EventItem set PhotoId = null where PhotoId not in (select Id from BinaryFile)");
AddForeignKey("dbo.EventItem", "PhotoId", "dbo.BinaryFile", "Id");
RockMigrationHelper.AddBlockTypeAttribute("8760D668-8ADF-48C8-9D90-09461FB75B88", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Details Page", "DetailsPage", "", "Detail page for events", 0, @"", "ABFA11BD-19AF-4F8D-BE41-F667C928EB50");
RockMigrationHelper.AddBlockAttributeValue("0ADEEFE5-8293-48AC-AFA9-E0F0E363FCE7", "ABFA11BD-19AF-4F8D-BE41-F667C928EB50", @"8a477cc6-4a12-4fbe-8037-e666476dd413"); // Details Page
// Page: Event Details
RockMigrationHelper.AddPage("2E6FED28-683F-4726-8CF1-2822E8E73B03", "5FEAF34C-7FB6-4A11-8A1E-C452EC7849BD", "Event Details", "", "8A477CC6-4A12-4FBE-8037-E666476DD413", ""); // Site:External Website
RockMigrationHelper.UpdateBlockType("Calendar Item Lava", "Renders a particular calendar item using Lava.", "~/Blocks/Event/CalendarItemLava.ascx", "Event", "18EFAE90-3AB1-40FE-9EC6-A5CF42F2A7D9");
RockMigrationHelper.AddBlock("8A477CC6-4A12-4FBE-8037-E666476DD413", "", "18EFAE90-3AB1-40FE-9EC6-A5CF42F2A7D9", "Calendar Item Lava", "Main", "", "", 0, "FC400B7B-760A-4090-9E9E-F049631E7BB4");
RockMigrationHelper.AddBlockTypeAttribute("18EFAE90-3AB1-40FE-9EC6-A5CF42F2A7D9", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Set Page Title", "SetPageTitle", "", "Determines if the block should set the page title with the calendar item name.", 0, @"False", "5B3B9094-50C1-4E5A-8C6B-748E83BE792F");
RockMigrationHelper.AddBlockTypeAttribute("18EFAE90-3AB1-40FE-9EC6-A5CF42F2A7D9", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Registration Page", "RegistrationPage", "", "Registration page for events", 0, @"", "5FE92034-CC9B-4C3E-95B1-09CC91B0417A");
RockMigrationHelper.AddBlockTypeAttribute("18EFAE90-3AB1-40FE-9EC6-A5CF42F2A7D9", "1D0D3794-C210-48A8-8C68-3FBEC08A6BA5", "Lava Template", "LavaTemplate", "", "Lava template to use to display the list of events.", 2, @"{% include '~/Themes/Stark/Assets/Lava/ExternalCalendarItem.lava' %}", "100F84DD-4526-41CD-80BC-246E15CC8E04");
RockMigrationHelper.AddBlockTypeAttribute("18EFAE90-3AB1-40FE-9EC6-A5CF42F2A7D9", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Enable Debug", "EnableDebug", "", "Display a list of merge fields available for lava.", 3, @"False", "ABABD149-FD7C-468D-9D9E-CCE657CB8172");
RockMigrationHelper.AddBlockAttributeValue("FC400B7B-760A-4090-9E9E-F049631E7BB4", "ABABD149-FD7C-468D-9D9E-CCE657CB8172", @"False"); // Enable Debug
RockMigrationHelper.AddBlockAttributeValue("FC400B7B-760A-4090-9E9E-F049631E7BB4", "5B3B9094-50C1-4E5A-8C6B-748E83BE792F", @"False"); // Set Page Title
RockMigrationHelper.AddBlockAttributeValue("FC400B7B-760A-4090-9E9E-F049631E7BB4", "100F84DD-4526-41CD-80BC-246E15CC8E04", @"{% include '~/Themes/Stark/Assets/Lava/ExternalCalendarItem.lava' %}"); // Lava Template
RockMigrationHelper.AddBlockAttributeValue("FC400B7B-760A-4090-9E9E-F049631E7BB4", "5FE92034-CC9B-4C3E-95B1-09CC91B0417A", @"f7ca6e0f-c319-47ab-9a6d-247c5716d846,349782f9-b8d3-4c29-84f5-44b86cd198c2"); // Registration Page
}
/// <summary>
/// CMSs the changes up.
/// </summary>
private void CmsChangesUp()
{
// Add connection opportunity select
RockMigrationHelper.AddPage(true, SystemGuid.Page.ENGAGEMENT, SystemGuid.Layout.FULL_WIDTH_INTERNAL_SITE, "Connections", "", SystemGuid.Page.CONNECTION_OPPORTUNITY_SELECT, "");
// Add connection board page
RockMigrationHelper.AddPage(true, SystemGuid.Page.CONNECTION_OPPORTUNITY_SELECT, SystemGuid.Layout.FULL_WIDTH_INTERNAL_SITE, "Connection Board", "", SystemGuid.Page.CONNECTIONS_BOARD, "");
// Move the existing connection page underneath opportunity select, sibling to the board
RockMigrationHelper.MovePage(SystemGuid.Page.CONNECTIONS, SystemGuid.Page.CONNECTION_OPPORTUNITY_SELECT);
// Add/Update BlockType Connection Opportunity Select
var opportunitySelectBlockTypeGuid = "23438CBC-105B-4ADB-8B9A-D5DDDCDD7643";
RockMigrationHelper.UpdateBlockType("Connection Opportunity Select", "Block to display the connection opportunities that the user is authorized to view.", "~/Blocks//Connection/ConnectionOpportunitySelect.ascx", "Connection", opportunitySelectBlockTypeGuid);
// Add Connection Opportunity Select to Page: CONNECTION_OPPORTUNITY_SELECT, Site: Rock RMS
RockMigrationHelper.AddBlock(true, SystemGuid.Page.CONNECTION_OPPORTUNITY_SELECT.AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), opportunitySelectBlockTypeGuid.AsGuid(), "Connection Opportunity Select", "Main", @"", @"", 0, "340FBA54-FC54-4EA1-8DD2-301536405034");
// Add/Update BlockType Connection Request Board
var boardBlockTypeGuid = "28DBE708-E99B-4879-A64D-656C030D25B5";
RockMigrationHelper.UpdateBlockType("Connection Request Board", "Display the Connection Requests for a selected Connection Opportunity as a list or board view.", "~/Blocks//Connection/ConnectionRequestBoard.ascx", "Connection", boardBlockTypeGuid);
// Add Block Connection Request Board to Page: Connection Board, Site: Rock RMS
RockMigrationHelper.AddBlock(true, SystemGuid.Page.CONNECTIONS_BOARD.AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), boardBlockTypeGuid.AsGuid(), "Connection Request Board", "Main", @"", @"", 0, "7908EAD6-832B-4E38-9EDA-5FC40115DA0E");
// Hide the original connections page breadcrumb
Sql($"UPDATE [Page] SET [BreadCrumbDisplayName] = 0 WHERE [Guid] = '{SystemGuid.Page.CONNECTIONS}'");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
// Add a defined value for the Rest User record type
RockMigrationHelper.AddDefinedValue_pre20140819("26BE73A6-A9C5-4E94-AE00-3AFDCF8C9275", "RestUser", "Rest User Record", "E2261A84-831D-4234-9BE0-4D628BBE751E", true);
// Add the rest key list page
RockMigrationHelper.AddPage("91CCB1C9-5F9F-44F5-8BE2-9EC3A3CFD46F", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Rest Keys", "A list of REST API Keys", "881AB1C2-4E00-4A73-80CC-9886B3717A20", "fa fa-key");
// Add the rest key list block type
RockMigrationHelper.AddBlockType("Rest Key List", "Lists the REST API Keys", "~/Blocks/Security/RestKeyList.ascx", "Security", "7FAA46B5-C70D-4A77-9BBF-80DA4431AF13");
// Add the rest key list block
RockMigrationHelper.AddBlock("881AB1C2-4E00-4A73-80CC-9886B3717A20", "", "7FAA46B5-C70D-4A77-9BBF-80DA4431AF13", "Rest Key List", "Main", "", "", 0, "A8AEA50D-DF92-46D1-8A42-512C0EC5179E");
// Add the rest key detail page
RockMigrationHelper.AddPage("881AB1C2-4E00-4A73-80CC-9886B3717A20", "195BCD57-1C10-4969-886F-7324B6287B75", "Rest Key Detail", "Detailed information about this REST API Key", "594692AA-5647-4F9A-9488-AADB990FDE56", "fa fa-key");
// Add the rest key detail block type
RockMigrationHelper.AddBlockType("Rest Key Detail", "Used for viewing and editing REST API key information", "~/Blocks/Security/RestKeyDetail.ascx", "Security", "C3989D26-69C4-4E80-B069-60A157D467BB");
// Add the rest key detail block
RockMigrationHelper.AddBlock("594692AA-5647-4F9A-9488-AADB990FDE56", "", "C3989D26-69C4-4E80-B069-60A157D467BB", "Rest Key Detail", "Main", "", "", 0, "8457C5EE-C6A4-4DEA-9025-5788A0587C96");
// Create the Detail Page attribute on the Rest Key List page
RockMigrationHelper.AddBlockTypeAttribute("7FAA46B5-C70D-4A77-9BBF-80DA4431AF13", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Detail Page", "DetailPage", "", "", 0, "", "8ACB614A-BF2E-44B2-9F37-F7A113D7C9CA");
// Set "Detail Page" attribute on Rest Key List page to the Rest Key Detail page
RockMigrationHelper.AddBlockAttributeValue("A8AEA50D-DF92-46D1-8A42-512C0EC5179E", "8ACB614A-BF2E-44B2-9F37-F7A113D7C9CA", "594692AA-5647-4F9A-9488-AADB990FDE56");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
CreateIndex("dbo.FinancialTransactionDetail", new string[] { "EntityTypeId", "EntityId" });
AddColumn("dbo.Registration", "DiscountCode", c => c.String(maxLength: 100));
AddColumn("dbo.Registration", "DiscountPercentage", c => c.Decimal(nullable: false, precision: 18, scale: 2));
AddColumn("dbo.Registration", "DiscountAmount", c => c.Decimal(nullable: false, precision: 18, scale: 2));
AddColumn("dbo.RegistrationRegistrantFee", "Option", c => c.String());
AlterColumn("dbo.RegistrationTemplateDiscount", "DiscountPercentage", c => c.Decimal(nullable: false, precision: 18, scale: 2));
RockMigrationHelper.AddPage("2E6FED28-683F-4726-8CF1-2822E8E73B03", "5FEAF34C-7FB6-4A11-8A1E-C452EC7849BD", "Registration", "", "F7CA6E0F-C319-47AB-9A6D-247C5716D846", ""); // Site:External Website
RockMigrationHelper.AddPageRoute("F7CA6E0F-C319-47AB-9A6D-247C5716D846", "Registration/{Slug}");
RockMigrationHelper.UpdateBlockType("Registration Entry", "Block used to register for registration instance.", "~/Blocks/Event/RegistrationEntry.ascx", "Event", "CABD2BFB-DFFF-42CD-BF1A-14F3BEE583DD");
// Add Block to Page: Registration, Site: External Website
RockMigrationHelper.AddBlock("F7CA6E0F-C319-47AB-9A6D-247C5716D846", "", "CABD2BFB-DFFF-42CD-BF1A-14F3BEE583DD", "Registration Entry", "Main", "", "", 0, "2AD7E973-5F01-4B2F-95AB-E80CA557CE9F");
// Attrib for BlockType: Registration Entry:Batch Name Prefix
RockMigrationHelper.AddBlockTypeAttribute("CABD2BFB-DFFF-42CD-BF1A-14F3BEE583DD", "9C204CD0-1233-41C5-818A-C5DA439445AA", "Batch Name Prefix", "BatchNamePrefix", "", "The batch prefix name to use when creating a new batch", 3, @"Event Registration", "589260FC-E44F-48AA-B119-C94E1C7A595B");
// Attrib for BlockType: Registration Entry:Connection Status
RockMigrationHelper.AddBlockTypeAttribute("CABD2BFB-DFFF-42CD-BF1A-14F3BEE583DD", "59D5A94C-94A0-4630-B80A-BB25697D74C7", "Connection Status", "ConnectionStatus", "", "The connection status to use for new individuals (default: 'Web Prospect'.)", 0, @"368DD475-242C-49C4-A42C-7278BE690CC2", "A2FF6FA6-3A37-48AA-867E-FFA2AE0DBE45");
// Attrib for BlockType: Registration Entry:Record Status
RockMigrationHelper.AddBlockTypeAttribute("CABD2BFB-DFFF-42CD-BF1A-14F3BEE583DD", "59D5A94C-94A0-4630-B80A-BB25697D74C7", "Record Status", "RecordStatus", "", "The record status to use for new individuals (default: 'Pending'.)", 1, @"283999EC-7346-42E3-B807-BCE9B2BABB49", "CE8EDF18-7A68-4752-99C1-CEFFBF06632C");
// Attrib for BlockType: Registration Entry:Source
RockMigrationHelper.AddBlockTypeAttribute("CABD2BFB-DFFF-42CD-BF1A-14F3BEE583DD", "59D5A94C-94A0-4630-B80A-BB25697D74C7", "Source", "Source", "", "The Financial Source Type to use when creating transactions", 2, @"7D705CE7-7B11-4342-A58E-53617C5B4E69", "7290B82A-14A8-402D-8A97-1A1F730F7ECE");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
RockMigrationHelper.AddPage("CDF2C599-D341-42FD-B7DC-CD402EA96050", "66FA0143-F04C-4447-A67A-2A10A6BB1A2B", "Scheduled Locations", "", "4E210ABB-65B3-4816-BD77-D2C876FC0FD5", ""); // Site:Rock Check-in
RockMigrationHelper.AddPageRoute("4E210ABB-65B3-4816-BD77-D2C876FC0FD5", "checkin/scheduledlocations"); // for Page:Scheduled Locations
RockMigrationHelper.UpdateBlockType("Check-in Scheduled Locations", "Helps to enable/disable schedules associated with the configured group types at a kiosk", "~/Blocks/CheckIn/CheckinScheduledLocations.ascx", "Check-in", "C8C4E323-C227-4EAA-938F-4B962BC2DD7E");
// Add Block to Page: Scheduled Locations, Site: Rock Check-in
RockMigrationHelper.AddBlock("4E210ABB-65B3-4816-BD77-D2C876FC0FD5", "", "C8C4E323-C227-4EAA-938F-4B962BC2DD7E", "Check-in Scheduled Locations", "Main", "", "", 0, "23372BE4-4697-4E86-8B5F-C9A535435C2C");
// Attrib for BlockType: Welcome:Enable Override
RockMigrationHelper.AddBlockTypeAttribute("E1BBB48E-9E9A-4B69-B25C-820ABD9DCDEE", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Enable Override", "EnableOverride", "", "Allows the override link to be used on the configuration page.", 0, @"True", "B4CF0964-F2AD-482F-A50C-570159FD1FFC");
// Attrib for BlockType: Welcome:Enable Manager
RockMigrationHelper.AddBlockTypeAttribute("E1BBB48E-9E9A-4B69-B25C-820ABD9DCDEE", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Enable Manager", "EnableManager", "", "Allows the manager link to be placed on the page.", 0, @"True", "4C3B1C57-AF71-48A7-A8FE-36702BD67E78");
// Attrib for BlockType: Welcome:Scheduled Locations Page
RockMigrationHelper.AddBlockTypeAttribute("E1BBB48E-9E9A-4B69-B25C-820ABD9DCDEE", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Scheduled Locations Page", "ScheduledLocationsPage", "", "", 0, @"", "C79544CC-B79A-4D05-BFC2-DF78CCC3D4F4");
// Attrib Value for Block:Welcome, Attribute:Enable Override Page: Welcome, Site: Rock Check-in
RockMigrationHelper.AddBlockAttributeValue("296E50EB-AA26-4E9A-9981-FE1F37B1DFDE", "B4CF0964-F2AD-482F-A50C-570159FD1FFC", @"True");
// Attrib Value for Block:Welcome, Attribute:Enable Manager Page: Welcome, Site: Rock Check-in
RockMigrationHelper.AddBlockAttributeValue("296E50EB-AA26-4E9A-9981-FE1F37B1DFDE", "4C3B1C57-AF71-48A7-A8FE-36702BD67E78", @"True");
// Attrib Value for Block:Welcome, Attribute:Scheduled Locations Page Page: Welcome, Site: Rock Check-in
RockMigrationHelper.AddBlockAttributeValue("296E50EB-AA26-4E9A-9981-FE1F37B1DFDE", "C79544CC-B79A-4D05-BFC2-DF78CCC3D4F4", @"4e210abb-65b3-4816-bd77-d2c876fc0fd5,ff3b1ad7-4f4e-4e29-b960-8e7db50c3837");
// Attrib for BlockType: Check-in Scheduled Locations:Home Page
RockMigrationHelper.AddBlockTypeAttribute("C8C4E323-C227-4EAA-938F-4B962BC2DD7E", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Home Page", "HomePage", "", "", 0, @"", "93DDA73B-5672-4099-9CB0-61DFF17A48DC");
// Attrib Value for Block:Check-in Scheduled Locations, Attribute:Home Page Page: Scheduled Locations, Site: Rock Check-in
RockMigrationHelper.AddBlockAttributeValue("23372BE4-4697-4E86-8B5F-C9A535435C2C", "93DDA73B-5672-4099-9CB0-61DFF17A48DC", @"432b615a-75ff-4b14-9c99-3e769f866950");
}
/// <summary>
/// Adds the Assessment internal pages.
/// </summary>
private void AddInternalPagesUp()
{
RockMigrationHelper.AddPage(true, "BF04BB7E-BE3A-4A38-A37C-386B55496303", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Assessments", "", "985D7F56-9FD6-421B-B406-2D6B87CAFAE9", ""); // Site:Rock RMS
RockMigrationHelper.AddPage(true, "985D7F56-9FD6-421B-B406-2D6B87CAFAE9", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Conflict Profile Assessment", "", "218F78A5-3274-4A45-927E-EBC7B26E28EC", ""); // Site:Rock RMS
RockMigrationHelper.AddPage(true, "985D7F56-9FD6-421B-B406-2D6B87CAFAE9", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Emotional Intelligence Assessment", "", "6B8DB6BD-B747-453E-B116-153C60A48448", ""); // Site:Rock RMS
RockMigrationHelper.AddPage(true, "985D7F56-9FD6-421B-B406-2D6B87CAFAE9", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "DISC Assessment", "", "E64562B2-8D5F-40FD-B064-F249F76EF3BE", ""); // Site:Rock RMS
RockMigrationHelper.AddPage(true, "985D7F56-9FD6-421B-B406-2D6B87CAFAE9", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Gifts Assessment", "", "112F0A18-8F8A-4A06-B597-F0CF66480DA8", ""); // Site:Rock RMS
RockMigrationHelper.AddPage(true, "985D7F56-9FD6-421B-B406-2D6B87CAFAE9", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Motivators Assessment", "", "57BBC962-2F87-4A76-9647-26C6524EF87E", ""); // Site:Rock RMS
RockMigrationHelper.AddPageRoute("218F78A5-3274-4A45-927E-EBC7B26E28EC", "ConflictProfile", "0DA62733-6C44-40AD-B699-B2932B953722"); // for Page:Conflict Profile Assessment
RockMigrationHelper.AddPageRoute("218F78A5-3274-4A45-927E-EBC7B26E28EC", "ConflictProfile/{rckipid}", "ABDD2648-8EF1-4339-B8D6-0898EF09006A"); // for Page:Conflict Profile Assessment
RockMigrationHelper.AddPageRoute("6B8DB6BD-B747-453E-B116-153C60A48448", "EQ", "4C0DD8AB-67DF-435E-99CD-990C383B956E"); // for Page:Emotional Intelligence Assessment
RockMigrationHelper.AddPageRoute("6B8DB6BD-B747-453E-B116-153C60A48448", "EQ/{rckipid}", "B0545679-CC90-475B-9C83-DFFC8676B88C"); // for Page:Emotional Intelligence Assessment
RockMigrationHelper.AddPageRoute("112F0A18-8F8A-4A06-B597-F0CF66480DA8", "SpiritualGifts", "47E04A33-6AD1-4E31-9CE1-8D956339EFFE"); // for Page:Gifts Assessment
RockMigrationHelper.AddPageRoute("112F0A18-8F8A-4A06-B597-F0CF66480DA8", "SpiritualGifts/{rckipid}", "3FE0AAD9-2C78-44B6-9A59-039F677F6FCE"); // for Page:Gifts Assessment
RockMigrationHelper.AddPageRoute("57BBC962-2F87-4A76-9647-26C6524EF87E", "Motivators", "E32CC839-58DA-461F-B988-DAC4DD7A30F7"); // for Page:Motivators Assessment
RockMigrationHelper.AddPageRoute("57BBC962-2F87-4A76-9647-26C6524EF87E", "Motivators/{rckipid}", "72E55DBD-2DD6-4D19-BFD8-26D932EC1FD0"); // for Page:Motivators Assessment
RockMigrationHelper.AddPageRoute("E64562B2-8D5F-40FD-B064-F249F76EF3BE", "DISC", "606D5685-8030-4BB9-BD0B-D6B8F06BA551"); // for Page:Motivators Assessment
RockMigrationHelper.AddPageRoute("E64562B2-8D5F-40FD-B064-F249F76EF3BE", "DISC/{rckipid}", "8B16CACD-466B-4670-9F66-CBEEA87715E0"); // for Page:Motivators Assessment
// Add Block to Page: Conflict Profile Assessment Site: Rock RMS
RockMigrationHelper.AddBlock(true, "218F78A5-3274-4A45-927E-EBC7B26E28EC".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "91473D2F-607D-4260-9C6A-DD3762FE472D".AsGuid(), "Conflict Profile", "Main", @"", @"", 0, "934514C9-7973-4705-BFAF-D3DD05E16E2C");
// Add Block to Page: Emotional Intelligence Assessment Site: Rock RMS
RockMigrationHelper.AddBlock(true, "6B8DB6BD-B747-453E-B116-153C60A48448".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "040CFD6D-5155-4BC9-BAEE-A53219A7BECE".AsGuid(), "EQ Assessment", "Main", @"", @"", 0, "E25272A2-FE32-4A94-BDE9-437189A87993");
// Add Block to Page: DISC Assessment Site: Rock RMS
RockMigrationHelper.AddBlock(true, "E64562B2-8D5F-40FD-B064-F249F76EF3BE".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "A161D12D-FEA7-422F-B00E-A689629680E4".AsGuid(), "Disc", "Main", @"", @"", 0, "5D52E8D4-63E8-48F2-B016-923301E61B9C");
// Add Block to Page: Gifts Assessment Site: Rock RMS
RockMigrationHelper.AddBlock(true, "112F0A18-8F8A-4A06-B597-F0CF66480DA8".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "A7E86792-F0ED-46F2-988D-25EBFCD1DC96".AsGuid(), "Gifts Assessment", "Main", @"", @"", 0, "47DC0C1F-B94B-4A58-8ECD-6DBE934ECFF9");
// Add Block to Page: Motivators Assessment Site: Rock RMS
RockMigrationHelper.AddBlock(true, "57BBC962-2F87-4A76-9647-26C6524EF87E".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "18CF8DA8-5DE0-49EC-A279-D5507CFA5713".AsGuid(), "Motivators Assessment", "Main", @"", @"", 0, "02898091-CF95-4303-884D-9019666096AE");
}
public override void Up()
{
RockMigrationHelper.AddPage(Rock.SystemGuid.Page.INTERNAL_HOMEPAGE, "22D220B5-0D34-429A-B9E3-59D80AE423E7", "Check-In Administration", "", SystemGuid.Page.ROOT_NAV, "fa fa-check-square-o");
RockMigrationHelper.AddPage(SystemGuid.Page.ROOT_NAV, "22D220B5-0D34-429A-B9E3-59D80AE423E7", "Add", "", SystemGuid.Page.ADD_SUB_NAV, "");
RockMigrationHelper.AddPage(SystemGuid.Page.ROOT_NAV, "22D220B5-0D34-429A-B9E3-59D80AE423E7", "Reports", "", SystemGuid.Page.REPORTS_SUB_NAV, "");
RockMigrationHelper.AddPage(SystemGuid.Page.ROOT_NAV, "22D220B5-0D34-429A-B9E3-59D80AE423E7", "Headcount", "", SystemGuid.Page.HEADCOUNT_SUB_NAV, "");
RockMigrationHelper.AddPage(SystemGuid.Page.ADD_SUB_NAV, "22D220B5-0D34-429A-B9E3-59D80AE423E7", "Add Attendance", "", SystemGuid.Page.ADD_ATTENDANCE);
RockMigrationHelper.AddPage(SystemGuid.Page.REPORTS_SUB_NAV, "22D220B5-0D34-429A-B9E3-59D80AE423E7", "Active Attendees", "", SystemGuid.Page.ACTIVE_ATTENDEES);
RockMigrationHelper.AddPage(SystemGuid.Page.REPORTS_SUB_NAV, "22D220B5-0D34-429A-B9E3-59D80AE423E7", "Inactive Attendees", "", SystemGuid.Page.INACTIVE_ATTENDEES);
RockMigrationHelper.AddPage(SystemGuid.Page.REPORTS_SUB_NAV, "22D220B5-0D34-429A-B9E3-59D80AE423E7", "Group Activity", "", SystemGuid.Page.GROUP_ACTIVITY);
RockMigrationHelper.AddPage(SystemGuid.Page.HEADCOUNT_SUB_NAV, "22D220B5-0D34-429A-B9E3-59D80AE423E7", "Attendance Overview", "", SystemGuid.Page.ATTENDANCE_OVERERVIEW);
RockMigrationHelper.AddPage(SystemGuid.Page.HEADCOUNT_SUB_NAV, "22D220B5-0D34-429A-B9E3-59D80AE423E7", "Record Headcounts", "", SystemGuid.Page.RECORD_HEADCOUNTS);
RockMigrationHelper.AddBlock(SystemGuid.Page.ADD_ATTENDANCE, "", SystemGuid.BlockType.ATTENDANCE_INPUT, "Attendance Input", "Feature", "<div class='well'>Use keyboard shortcuts to speed up entry. <span class='navigation-tip'>Alt+Z</span> adds the currently selected person and<span class='navigation-tip'>Alt+S</span> saves the current attendance.</div>", "", 0, SystemGuid.Block.ATTENDANCE_INPUT);
RockMigrationHelper.AddBlock(SystemGuid.Page.ACTIVE_ATTENDEES, "", SystemGuid.BlockType.FIND_ACTIVES, "Active Attendees", "Feature", "", "", 0, SystemGuid.Block.ACTIVE_ATTENDANCE);
RockMigrationHelper.AddBlock(SystemGuid.Page.INACTIVE_ATTENDEES, "", SystemGuid.BlockType.FIND_INACTIVE_ATTENDEES, "Inactive Attendees", "Feature", "", "", 0, SystemGuid.Block.INACTIVE_ATTENDANCE);
RockMigrationHelper.AddBlock(SystemGuid.Page.GROUP_ACTIVITY, "", SystemGuid.BlockType.ATTENDED_GROUPS, "Attended Groups", "Feature", "", "", 0, SystemGuid.Block.ATTENDED_GROUPS);
RockMigrationHelper.AddBlock(SystemGuid.Page.ATTENDANCE_OVERERVIEW, "", SystemGuid.BlockType.ATTENDANCE_OVERVIEW, "Attendance Summary", "Feature", "", "", 0, SystemGuid.Block.ATTENDANCE_OVERVIEW);
RockMigrationHelper.AddBlock(SystemGuid.Page.RECORD_HEADCOUNTS, "", SystemGuid.BlockType.HEADCOUNT_METRIC_VALUE_LIST, "Headcount Values", "Feature", "", "", 0, SystemGuid.Block.HEADCOUNT_METRIC_VALUE_LIST);
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
AddColumn("dbo.Site", "EnabledForShortening", c => c.Boolean(nullable: false));
AddColumn("dbo.Site", "FavIconBinaryFileId", c => c.Int());
CreateIndex("dbo.Site", "FavIconBinaryFileId");
AddForeignKey("dbo.Site", "FavIconBinaryFileId", "dbo.BinaryFile", "Id");
Sql(@"
UPDATE [Site] SET [EnabledForShortening] = 1
WHERE [Guid] NOT IN ( '05E96F7B-B75E-4987-825A-B6F51F8D9CAA', 'A5FA7C3C-A238-4E0B-95DE-B540144321EC', '15AEFC01-ACB3-4F5D-B83E-AB3AB7F2A54A' )
");
// SK: Rename MyWorkflowsLiquid to MyWorkflowsLava.cs
Sql(@"
DELETE [BlockType] WHERE [Path]='~/Blocks/WorkFlow/MyWorkflowsLava.ascx'
UPDATE [BlockType] SET
[Path] = '~/Blocks/WorkFlow/MyWorkflowsLava.ascx',
[Name] = 'My Workflows Lava'
WHERE [Guid] = '4F217A7F-A34E-489E-AE0E-2B7EDCF69CD1'
");
// JE: Add Rapid Attendance Page
RockMigrationHelper.AddPage("B0F4B33D-DD11-4CCC-B79D-9342831B8701", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Rapid Attendance Entry", "", "78B79290-3234-4D8C-96D3-1901901BA1DD", "fa fa-calendar-check-o"); // Site:Rock RMS
RockMigrationHelper.UpdateBlockType("Rapid Attendance Entry", "Provides a way to manually enter attendance for a large group of people in an efficient manner.", "~/Blocks/CheckIn/RapidAttendanceEntry.ascx", "Check-in", "6C2ED1FA-218B-4ACC-B661-A2618F310CD4");
RockMigrationHelper.AddBlock("78B79290-3234-4D8C-96D3-1901901BA1DD", "", "6C2ED1FA-218B-4ACC-B661-A2618F310CD4", "Rapid Attendance Entry", "Main", "", "", 0, "24560306-8535-4119-BA4A-CBC172C3832C");
RockMigrationHelper.UpdateBlockTypeAttribute("6C2ED1FA-218B-4ACC-B661-A2618F310CD4", "F4399CEF-827B-48B2-A735-F7806FCFE8E8", "Parent Group", "ParentGroup", "", "Select the parent group whose immediate childeren will be displayed as options to take attendance for.", 0, @"", "A24BB4C5-4493-405F-91A6-FEEF257FF7B5");
RockMigrationHelper.UpdateBlockTypeAttribute("6C2ED1FA-218B-4ACC-B661-A2618F310CD4", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Default Show Current Attendees", "DefaultShowCurrentAttendees", "", "Should the Current Attendees grid be visible by default. When the grid is enabled performance will be reduced.", 1, @"False", "B291C231-3FCE-4B40-8C9E-C03A8DF3BE39");
RockMigrationHelper.UpdateBlockTypeAttribute("6C2ED1FA-218B-4ACC-B661-A2618F310CD4", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Include Parent Group", "IncludeParentGroup", "", "If true then the parent group will be included as an option in addition to it's children.", 1, @"False", "248FB07D-D939-405C-BC4E-0D6A03EBE2D1");
}
private void PagesAndBlocksUp()
{
RockMigrationHelper.AddPage(true, "7F79E512-B9DB-4780-9887-AD6D63A39050", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "SMS Conversations", "", "275A5175-60E0-40A2-8C63-4E9D9CD39036", "fa fa-comments"); // Site:Rock RMS
RockMigrationHelper.UpdateBlockType("SMS Conversations", "Block for having SMS Conversations between an SMS enabled phone and a Rock SMS Phone number that has 'Enable Mobile Conversations' set to false.", "~/Blocks/Communication/SmsConversations.ascx", "Communication", "3497603B-3BE6-4262-B7E9-EC01FC7140EB");
// Add Block to Page: SMS Conversations Site: Rock RMS
RockMigrationHelper.AddBlock(true, "275A5175-60E0-40A2-8C63-4E9D9CD39036".AsGuid(), null, Rock.SystemGuid.Site.SITE_ROCK_INTERNAL.AsGuid(), "3497603B-3BE6-4262-B7E9-EC01FC7140EB".AsGuid(), "Sms Conversations", "Main", @"", @"", 0, "24CAFC0B-3C23-45EB-B69C-BEC68BB21B97");
}
private void FarmUp()
{
// Add Page Web Farm to Site:Rock RMS
RockMigrationHelper.AddPage(true, "C831428A-6ACD-4D49-9B2D-046D399E3123", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Web Farm", "", "249BE98D-9DDE-4B19-9D97-9C76D9EA3056", "fa fa-network-wired");
// Add/Update BlockType Log
RockMigrationHelper.UpdateBlockType("Log", "Shows a list of Web Farm logs.", "~/Blocks/Farm/Log.ascx", "Farm", "63ADDB5A-75D6-4E86-A031-98B3451C49A3");
// Add/Update BlockType Web Farm Settings
RockMigrationHelper.UpdateBlockType("Web Farm Settings", "Displays the details of the Web Farm.", "~/Blocks/Farm/WebFarmSettings.ascx", "Farm", "4280625A-C69A-4B47-A4D3-89B61F43C967");
// Add Block Web Farm Settings to Page: Web Farm, Site: Rock RMS
RockMigrationHelper.AddBlock(true, "249BE98D-9DDE-4B19-9D97-9C76D9EA3056".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "4280625A-C69A-4B47-A4D3-89B61F43C967".AsGuid(), "Web Farm Settings", "Main", @"", @"", 0, "E6880262-1A1C-4857-929C-958CAD8A6DEF");
// Add Block Log to Page: Web Farm, Site: Rock RMS
RockMigrationHelper.AddBlock(true, "249BE98D-9DDE-4B19-9D97-9C76D9EA3056".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "63ADDB5A-75D6-4E86-A031-98B3451C49A3".AsGuid(), "Log", "Main", @"", @"", 1, "A99E9D67-3B9F-40D0-8C64-E95ECFE17D95");
// update block order for pages with new blocks if the page,zone has multiple blocks
// Update Order for Page: Web Farm, Zone: Main, Block: Log
Sql(@"UPDATE [Block] SET [Order] = 1 WHERE [Guid] = 'A99E9D67-3B9F-40D0-8C64-E95ECFE17D95'");
// Update Order for Page: Web Farm, Zone: Main, Block: Web Farm Settings
Sql(@"UPDATE [Block] SET [Order] = 0 WHERE [Guid] = 'E6880262-1A1C-4857-929C-958CAD8A6DEF'");
// Hide pages in system settings
Sql($"UPDATE [Page] SET [DisplayInNavWhen] = {( int ) Model.DisplayInNavWhen.Never} WHERE [Guid] = '{SystemGuid.Page.WEB_FARM}';");
Sql($"UPDATE [Page] SET [DisplayInNavWhen] = {( int ) Model.DisplayInNavWhen.Never} WHERE [Guid] = '{SystemGuid.Page.BUS}';");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
// add global attribute for boosting universal search models
RockMigrationHelper.AddGlobalAttribute(SystemGuid.FieldType.KEY_VALUE_LIST, "", "", "Universal Search Index Boost", "Allows you to boost certain universal search indexes.", 1000, "", "757F912F-55E0-76A9-46D2-345BB61D7B02", "UniversalSearchIndexBoost");
// Add Fundraising Page/Block
RockMigrationHelper.AddPage(true, "4E237286-B715-4109-A578-C1445EC02707", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Fundraising", "", "3E0F2EF9-DC32-4DFD-B213-A410AE5B6AB7", ""); // Site:Rock RMS
RockMigrationHelper.UpdateBlockType("Fundraising Progress", "Progress for all people in a fundraising opportunity", "~/Blocks/Fundraising/FundraisingProgress.ascx", "Fundraising", "75D2BC14-34DF-42EA-8DBB-3F5294B290A9");
// Add Block to Page: Fundraising, Site: Rock RMS
RockMigrationHelper.AddBlock(true, "3E0F2EF9-DC32-4DFD-B213-A410AE5B6AB7", "", "75D2BC14-34DF-42EA-8DBB-3F5294B290A9", "Fundraising Progress", "Main", @"", @"", 0, "59A24C5E-8214-4F84-AE4C-648B3C5E3975");
// Group List Page setting inside Group Detail Block
// Attrib for BlockType: Group Detail:Group List Page
RockMigrationHelper.UpdateBlockTypeAttribute("582BEEA1-5B27-444D-BC0A-F60CEB053981", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Group List Page", "GroupListPage", "", "The page to display related Group List.", 11, @"", "4F55D7DD-27A4-4ABC-89AD-1160F5697FD2");
// Attrib Value for Block:Security Roles Detail, Attribute:Group List Page Page: Security Roles Detail, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("B58919B6-0947-4FE6-A9AE-FB28194643E7", "4F55D7DD-27A4-4ABC-89AD-1160F5697FD2", @"d9678fef-c086-4232-972c-5dbac14bfee6");
// Attrib Value for Block:Application Group Detail, Attribute:Group List Page Page: Application Group Detail, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("64EEA884-8D04-44A3-9C75-5523A9EB9175", "4F55D7DD-27A4-4ABC-89AD-1160F5697FD2", @"ba078bb8-7205-46f4-9530-b2fb9ead3e57");
// Fundraising Progress setting in Group Detail Block
// Attrib for BlockType: Group Detail:Fundraising Progress Page
RockMigrationHelper.UpdateBlockTypeAttribute("582BEEA1-5B27-444D-BC0A-F60CEB053981", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Fundraising Progress Page", "FundraisingProgressPage", "", "The page to display fundraising progress for all its members.", 11, @"", "8C2AF872-C75A-41ED-8C22-76B472B18655");
// Attrib Value for Block:GroupDetailRight, Attribute:Fundraising Progress Page Page: Group Viewer, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("88344FE3-737E-4741-A38D-D2D3A1653818", "8C2AF872-C75A-41ED-8C22-76B472B18655", @"3e0f2ef9-dc32-4dfd-b213-a410ae5b6ab7");
// Attrib Value for Block:Security Roles Detail, Attribute:Fundraising Progress Page Page: Security Roles Detail, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("B58919B6-0947-4FE6-A9AE-FB28194643E7", "8C2AF872-C75A-41ED-8C22-76B472B18655", @"3e0f2ef9-dc32-4dfd-b213-a410ae5b6ab7");
// Attrib Value for Block:Application Group Detail, Attribute:Fundraising Progress Page Page: Application Group Detail, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("64EEA884-8D04-44A3-9C75-5523A9EB9175", "8C2AF872-C75A-41ED-8C22-76B472B18655", @"3e0f2ef9-dc32-4dfd-b213-a410ae5b6ab7");
// Attrib Value for Block:Group Detail, Attribute:Fundraising Progress Page Page: Org Chart, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("C1B5CA27-8B5B-4D7F-9160-916EFAAA7D26", "8C2AF872-C75A-41ED-8C22-76B472B18655", @"3e0f2ef9-dc32-4dfd-b213-a410ae5b6ab7");
}
public override void Up()
{
//
// Update the defined value attributes to show on grid.
//
Sql("UPDATE [Attribute] SET [IsGridColumn] = 1 WHERE [Guid] IN ('BF344704-6228-4467-AE4C-42B5EDF6954F', 'B92A5ECF-E819-43C3-8949-EC9BD0F59AAC')");
RockMigrationHelper.AddBlockType("Digital Sign Rotator",
"Displays a full-screen interface for displaying images and videos in a rotator.",
"~/Plugins/com_shepherdchurch/DigitalSignage/Digital Sign Rotator.ascx",
"Shepherd Church > Digital Signage", SystemGuid.BlockType.DIGITAL_SIGN_ROTATOR);
RockMigrationHelper.AddPage("5B6DBC42-8B03-4D15-8D92-AAFA28FD8616", "2E169330-D7D7-4ECA-B417-72C64BE150F0",
"Digital Sign", "Default page for displaying digital sign material on a kiosk device",
SystemGuid.Page.DIGITAL_SIGN);
Sql("UPDATE [Page] SET [DisplayInNavWhen] = 2 WHERE [Guid] = @Guid",
new Dictionary <string, object> {
{ "@Guid", SystemGuid.Page.DIGITAL_SIGN }
});
RockMigrationHelper.AddBlock(SystemGuid.Page.DIGITAL_SIGN, string.Empty,
SystemGuid.BlockType.DIGITAL_SIGN_ROTATOR, "Digital Sign Rotator",
"Main", string.Empty, string.Empty, 0, SystemGuid.Block.DIGITAL_SIGN_DIGITAL_SIGN_ROTATOR);
RockMigrationHelper.AddPageRoute(SystemGuid.Page.DIGITAL_SIGN, "digitalsign");
RockMigrationHelper.AddPageRoute(SystemGuid.Page.DIGITAL_SIGN, "digitalsign/{deviceId}");
}
/// <summary>
/// [MP] - Add Content Channel Item Attribute Categories block (Up)
/// </summary>
private void AddContentChannelItemAttributeCategoriesblockUp()
{
RockMigrationHelper.AddPage(true, "B4A24AB7-9369-4055-883F-4F4892C39AE3", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Content Channel Item Attribute Categories", "", "BBDE39C3-01C9-4C9E-9506-C2205508BC77", "fa fa-folder"); // Site:Rock RMS
// Add Block to Page: Content Channel Item Attribute Categories Site: Rock RMS
RockMigrationHelper.AddBlock(true, "BBDE39C3-01C9-4C9E-9506-C2205508BC77".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "620FC4A2-6587-409F-8972-22065919D9AC".AsGuid(), "Categories", "Main", @"", @"", 0, "3B05004B-0EF8-41A2-B5B8-058BEDB9B3AD");
// Attrib Value for Block:Categories, Attribute:Entity Type Page: Content Channel Item Attribute Categories, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("3B05004B-0EF8-41A2-B5B8-058BEDB9B3AD", "C405A507-7889-4287-8342-105B89710044", @"5997c8d3-8840-4591-99a5-552919f90cbd");
// Attrib Value for Block:Categories, Attribute:Enable Hierarchy Page: Content Channel Item Attribute Categories, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("3B05004B-0EF8-41A2-B5B8-058BEDB9B3AD", "736C3F4B-34CC-4B4B-9811-7171C82DDC41", @"False");
// Attrib Value for Block:Categories, Attribute:Entity Qualifier Column Page: Content Channel Item Attribute Categories, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("3B05004B-0EF8-41A2-B5B8-058BEDB9B3AD", "65C4A655-6E1D-4504-838B-28B91FCC6DF8", @"EntityTypeId");
// Attrib Value for Block:Categories, Attribute:Entity Qualifier Value Page: Content Channel Item Attribute Categories, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("3B05004B-0EF8-41A2-B5B8-058BEDB9B3AD", "19A79376-3F07-45E4-95CB-5AD5D3C4DDCF", @"");
// Set the Entity Qualifier Value to whatever the EntityTypeId of CONTENT_CHANNEL_ITEM is
Sql($@"UPDATE AttributeValue
SET [Value] = (
SELECT TOP 1 Id
FROM EntityType
WHERE [Guid] = '{Rock.SystemGuid.EntityType.CONTENT_CHANNEL_ITEM}'
)
WHERE AttributeId = (
SELECT TOP 1 ID
FROM Attribute
WHERE [Guid] = '19A79376-3F07-45E4-95CB-5AD5D3C4DDCF'
)
AND EntityId = (
SELECT TOP 1 ID
FROM [Block]
WHERE [Guid] = '3B05004B-0EF8-41A2-B5B8-058BEDB9B3AD'
)");
// Attrib Value for Block:Categories, Attribute:core.CustomGridColumnsConfig Page: Content Channel Item Attribute Categories, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("3B05004B-0EF8-41A2-B5B8-058BEDB9B3AD", "65AA8E36-9BAB-4BB7-B48A-FE0BF8A30CE3", @"");
// Attrib Value for Block:Categories, Attribute:core.CustomGridEnableStickyHeaders Page: Content Channel Item Attribute Categories, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("3B05004B-0EF8-41A2-B5B8-058BEDB9B3AD", "6D9CC876-720F-44C8-A95D-FEFC91DC7E85", @"");
}
/// <summary>
/// Operations to be performed during the downgrade process.
/// </summary>
public override void Down()
{
RockMigrationHelper.AddBlock("D2B43273-C64F-4F57-9AAE-9571E1982BAC", null, "694FF260-8C6F-4A59-93C9-CF3793FE30E6", "Scheduled Transaction List", "Main", "", "", 5, "91850A29-BB1A-4E92-A798-DE7D6E09E671");
RockMigrationHelper.AddBlock("D2B43273-C64F-4F57-9AAE-9571E1982BAC", null, "7011E792-A75F-4F22-B17E-D3A58C0EDB6D", "Pledge List", "Main", "", "", 4, "39A2DA08-1995-4A39-A6AF-5F8B8DE7372F");
RockMigrationHelper.AddBlock("D2B43273-C64F-4F57-9AAE-9571E1982BAC", null, "C4191011-0391-43DF-9A9D-BE4987C679A4", "Bank Account List", "Main", "", "", 7, "21D15CAB-EC52-4DEB-87DB-38F6C393FBE7");
// Attrib Value for Page/BlockBusiness Detail/Pledge List:Show Group Column (FieldType: Boolean)
RockMigrationHelper.AddBlockAttributeValue("39A2DA08-1995-4A39-A6AF-5F8B8DE7372F", "F2476138-7C16-404C-A4B6-600E39602601", @"False");
// Attrib Value for Page/BlockBusiness Detail/Pledge List:Show Date Range Filter (FieldType: Boolean)
RockMigrationHelper.AddBlockAttributeValue("39A2DA08-1995-4A39-A6AF-5F8B8DE7372F", "0049EC69-9814-4322-833F-BD82F92C64E9", @"True");
// Attrib Value for Page/BlockBusiness Detail/Pledge List:Show Person Filter (FieldType: Boolean)
RockMigrationHelper.AddBlockAttributeValue("39A2DA08-1995-4A39-A6AF-5F8B8DE7372F", "807B41A4-4286-434C-918A-FE3942A75F7B", @"True");
// Attrib Value for Page/BlockBusiness Detail/Pledge List:Show Account Column (FieldType: Boolean)
RockMigrationHelper.AddBlockAttributeValue("39A2DA08-1995-4A39-A6AF-5F8B8DE7372F", "63A83579-C73A-4387-B317-D9852F6647F3", @"True");
// Attrib Value for Page/BlockBusiness Detail/Pledge List:Show Account Filter (FieldType: Boolean)
RockMigrationHelper.AddBlockAttributeValue("39A2DA08-1995-4A39-A6AF-5F8B8DE7372F", "B16A3F35-C8A4-47B3-BA7A-E20098E7B028", @"True");
// Attrib Value for Page/BlockBusiness Detail/Pledge List:Show Last Modified Date Column (FieldType: Boolean)
RockMigrationHelper.AddBlockAttributeValue("39A2DA08-1995-4A39-A6AF-5F8B8DE7372F", "B27608E5-E5BF-4AC4-8C7E-C2A26456480B", @"True");
// Attrib Value for Page/BlockBusiness Detail/Pledge List:Limit Pledges To Current Person (FieldType: Boolean)
RockMigrationHelper.AddBlockAttributeValue("39A2DA08-1995-4A39-A6AF-5F8B8DE7372F", "6A056518-3E38-4E78-AF6F-16D5C23A057D", @"False");
// Attrib Value for Page/BlockBusiness Detail/Pledge List:Show Last Modified Filter (FieldType: Boolean)
RockMigrationHelper.AddBlockAttributeValue("39A2DA08-1995-4A39-A6AF-5F8B8DE7372F", "550E6B86-98BF-4DA7-9B54-634ADE0EE466", @"True");
// Attrib Value for Page/BlockBusiness Detail/Pledge List:Detail Page (FieldType: Page Reference)
RockMigrationHelper.AddBlockAttributeValue("39A2DA08-1995-4A39-A6AF-5F8B8DE7372F", "3E26B7DF-7A7F-4829-987F-47304C0F845E", @"EF7AA296-CA69-49BC-A28B-901A8AAA9466");
// Attrib Value for Page/BlockBusiness Detail/Pledge List:Entity Type (FieldType: EntityType)
RockMigrationHelper.AddBlockAttributeValue("39A2DA08-1995-4A39-A6AF-5F8B8DE7372F", "E9245CFD-4B11-4CE2-A120-BB3AC47C0974", @"72657ED8-D16E-492E-AC12-144C5E7567E7");
// Attrib Value for Page/BlockBusiness Detail/Scheduled Transaction List:Add Page (FieldType: Page Reference)
RockMigrationHelper.AddBlockAttributeValue("91850A29-BB1A-4E92-A798-DE7D6E09E671", "9BCE3FD8-9014-4120-9DCC-06C4936284BA", @"b1ca86dc-9890-4d26-8ebd-488044e1b3dd");
// Attrib Value for Page/BlockBusiness Detail/Scheduled Transaction List:Entity Type (FieldType: EntityType)
RockMigrationHelper.AddBlockAttributeValue("91850A29-BB1A-4E92-A798-DE7D6E09E671", "375F7220-04C6-4E41-B99A-A2CE494FD74A", @"72657ed8-d16e-492e-ac12-144c5e7567e7");
// Attrib Value for Page/BlockBusiness Detail/Scheduled Transaction List:View Page (FieldType: Page Reference)
RockMigrationHelper.AddBlockAttributeValue("91850A29-BB1A-4E92-A798-DE7D6E09E671", "47B99CD1-FB63-44D7-8586-45BDCDF51137", @"591204da-b586-454c-8bd5-85652ceaa553");
}
/// <summary>
/// CMSs up.
/// </summary>
private void CmsUp()
{
// Add Page Web Farm Node to Site:Rock RMS
RockMigrationHelper.AddPage(true, "249BE98D-9DDE-4B19-9D97-9C76D9EA3056", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Web Farm Node", "", "63698D5C-7C73-44A4-A27D-A7EB777EB2A2", "");
// Add/Update BlockType Web Farm Node Detail
RockMigrationHelper.UpdateBlockType("Web Farm Node Detail", "Displays the details of the Web Farm Node.", "~/Blocks/Farm/NodeDetail.ascx", "Farm", "95F38562-6CEF-4798-8A4F-05EBCDFB07E0");
// Add Block Log to Page: Web Farm Node, Site: Rock RMS
RockMigrationHelper.AddBlock(true, "63698D5C-7C73-44A4-A27D-A7EB777EB2A2".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "63ADDB5A-75D6-4E86-A031-98B3451C49A3".AsGuid(), "Log", "Main", @"", @"", 1, "F11880E1-621C-4793-8F68-21C728FE0A2B");
// Add Block Web Farm Node Detail to Page: Web Farm Node, Site: Rock RMS
RockMigrationHelper.AddBlock(true, "63698D5C-7C73-44A4-A27D-A7EB777EB2A2".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "95F38562-6CEF-4798-8A4F-05EBCDFB07E0".AsGuid(), "Web Farm Node Detail", "Main", @"", @"", 0, "F77FA989-CD77-40B8-8254-3144A3F6E7F5");
// update block order for pages with new blocks if the page,zone has multiple blocks
// Update Order for Page: Web Farm Node, Zone: Main, Block: Log
Sql(@"UPDATE [Block] SET [Order] = 1 WHERE [Guid] = 'F11880E1-621C-4793-8F68-21C728FE0A2B'");
// Update Order for Page: Web Farm Node, Zone: Main, Block: Web Farm Node Detail
Sql(@"UPDATE [Block] SET [Order] = 0 WHERE [Guid] = 'F77FA989-CD77-40B8-8254-3144A3F6E7F5'");
// Attribute for BlockType: Web Farm Settings:Farm Node Detail Page
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("4280625A-C69A-4B47-A4D3-89B61F43C967", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Farm Node Detail Page", "NodeDetailPage", "Farm Node Detail Page", @"The page where the node details can be seen", 1, @"63698D5C-7C73-44A4-A27D-A7EB777EB2A2", "A3E05855-B962-4447-BC8C-0B26A9F736E1");
}
private void UpdatePageAndBlockSettings()
{
// Rename block to SmsPipelineDetail.ascx
RockMigrationHelper.UpdateBlockTypeByGuid("SMS Pipeline Detail", "Configures the pipeline that processes an incoming SMS message.", "~/Blocks/Communication/SmsPipelineDetail.ascx", "Communication", "44C32EB7-4DA3-4577-AC41-E3517442E269");
RockMigrationHelper.AddPage(true, "2277986A-F53D-4E46-B6EC-6BAD1111DA39", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "SMS Pipeline Detail", "", "FCE39659-4D86-48D7-9C48-D837D3588C42", ""); // Site:Rock RMS
RockMigrationHelper.UpdateBlockType("SMS Pipeline List", "Lists the SMS Pipelines currently in the system.", "~/Blocks/Communication/SmsPipelineList.ascx", "Communication", "DB6FD0BF-FDCE-48DA-919C-240F029518A2");
// Remove Block: SMS Pipeline Detail, from Page: SMS Pipeline List, Site: Rock RMS
RockMigrationHelper.DeleteBlock("F6CA6D07-DDF4-47DD-AA7E-29F5DCCC2DDC");
// Add Block to Page: SMS Pipeline Detail Site: Rock RMS
RockMigrationHelper.AddBlock(true, "FCE39659-4D86-48D7-9C48-D837D3588C42".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "44C32EB7-4DA3-4577-AC41-E3517442E269".AsGuid(), "SMS Pipeline Detail", "Main", @"", @"", 0, "B191F27B-2A1D-4A2F-9E06-49BC2D8B1E5B");
// Add Block to Page: SMS Pipeline List Detail Site: Rock RMS
RockMigrationHelper.AddBlock(true, "2277986A-F53D-4E46-B6EC-6BAD1111DA39".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "DB6FD0BF-FDCE-48DA-919C-240F029518A2".AsGuid(), "SMS Pipeline List", "Main", @"", @"", 0, "EC3BDDFC-4688-485B-9EF3-890B9EC39527");
// Attrib for BlockType: SMS Pipeline List:SMS Pipeline Detail
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("DB6FD0BF-FDCE-48DA-919C-240F029518A2", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "SMS Pipeline Detail", "SMSPipelineDetail", "SMS Pipeline Detail", @"", 0, @"", "FA40D714-9D6F-4620-97B1-07BFFFC08F96");
// Attrib Value for Block:SMS Pipeline List, Attribute:core.CustomGridEnableStickyHeaders Page: SMS Pipeline, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("EC3BDDFC-4688-485B-9EF3-890B9EC39527", "27549AA7-AE69-4121-AAAC-DBA8EE5ED6EE", @"False");
// Attrib Value for Block:SMS Pipeline List, Attribute:SMS Pipeline Detail Page: SMS Pipeline, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("EC3BDDFC-4688-485B-9EF3-890B9EC39527", "FA40D714-9D6F-4620-97B1-07BFFFC08F96", @"fce39659-4d86-48d7-9c48-d837d3588c42");
}
/// <summary>
/// MB: Add Rock Shop Header Block Up()
/// </summary>
private void UpStoreHeaderBlock()
{
// Add/Update BlockType Store Header
RockMigrationHelper.UpdateBlockType("Store Header", "Shows the Organization information used by the Rock Shop.", "~/Blocks/Store/StoreHeader.ascx", "Store", "91355804-4B64-434F-949B-6180E5CC31D9");
// Add Block Store Header to Page: Rock Shop, Site: Rock RMS
RockMigrationHelper.AddBlock(true, "B093E7A0-5E7E-4A5F-AEF3-CE397D342BFA".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "91355804-4B64-434F-949B-6180E5CC31D9".AsGuid(), "Store Header", "Main", @"", @"", 0, "5C198E72-2E0F-4FD0-9F24-9B263FAD1789");
// update block order for pages with new blocks if the page,zone has multiple blocks
// Update Order for Page: Rock Shop, Zone: Main, Block: Featured Promos
Sql(@"UPDATE [Block] SET [Order] = 3 WHERE [Guid] = '8D23BB71-69D9-4409-8368-1D965A3C5128'");
// Update Order for Page: Rock Shop, Zone: Main, Block: Package Category Header List
Sql(@"UPDATE [Block] SET [Order] = 2 WHERE [Guid] = 'A239E904-3E32-462E-B97D-388E7E87C37F'");
// Update Order for Page: Rock Shop, Zone: Main, Block: Promo Rotator
Sql(@"UPDATE [Block] SET [Order] = 1 WHERE [Guid] = '5C5D96E2-7EA1-40A4-8C70-CDDCC66DD955'");
// Update Order for Page: Rock Shop, Zone: Main, Block: Sponsored Apps
Sql(@"UPDATE [Block] SET [Order] = 4 WHERE [Guid] = 'FA0152C9-71E1-47FF-9704-8D5EB39261DA'");
// Update Order for Page: Rock Shop, Zone: Main, Block: Store Header
Sql(@"UPDATE [Block] SET [Order] = 0 WHERE [Guid] = '5C198E72-2E0F-4FD0-9F24-9B263FAD1789'");
// Update Order for Page: Rock Shop, Zone: Main, Block: Top Free
Sql(@"UPDATE [Block] SET [Order] = 5 WHERE [Guid] = 'C9CFEF38-AF44-4F7D-B2A6-EBC4986527D8'");
// Attribute for BlockType: Store Header:Lava Template
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("91355804-4B64-434F-949B-6180E5CC31D9", "1D0D3794-C210-48A8-8C68-3FBEC08A6BA5", "Lava Template", "LavaTemplate", "Lava Template", @"Lava template to use to display the packages", 1, @"{% include '~/Assets/Lava/Store/StoreHeader.lava' %}", "25199FB1-FD8C-4A40-9A99-DFB096FE91B4");
// Attribute for BlockType: Store Header:Link Organization Page
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("91355804-4B64-434F-949B-6180E5CC31D9", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Link Organization Page", "LinkOrganizationPage", "Link Organization Page", @"Page to allow the user to link an organization to the store.", 0, @"", "3DBCAD71-5AC8-4728-8C48-DB3CCD0F966D");
// Attribute for BlockType: Lava Tester:Enabled Lava Commands
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("AD092814-8253-4E7B-AC5A-B84A9B811A95", "4BD9088F-5CC6-89B1-45FC-A2AAFFC7CC0D", "Enabled Lava Commands", "EnabledLavaCommands", "Enabled Lava Commands", @"The Lava commands that should be enabled.", 0, @"", "DCF68F80-083C-4AA5-A60B-D4F71378E045");
// Block Attribute Value for Store Header ( Page: Rock Shop, Site: Rock RMS )
RockMigrationHelper.AddBlockAttributeValue("5C198E72-2E0F-4FD0-9F24-9B263FAD1789", "25199FB1-FD8C-4A40-9A99-DFB096FE91B4", @"{% include '~/Assets/Lava/Store/StoreHeader.lava' %}");
// Block Attribute Value for Store Header ( Page: Rock Shop, Site: Rock RMS )
RockMigrationHelper.AddBlockAttributeValue("5C198E72-2E0F-4FD0-9F24-9B263FAD1789", "3DBCAD71-5AC8-4728-8C48-DB3CCD0F966D", @"6e029432-56f4-46ad-9d9c-c122f3d3c55c");
}
private void GridLaunchWorkflowsUp()
{
RockMigrationHelper.AddPage(true, "6510AB6B-DFB4-4DBF-9F0F-7EA598E4AC54", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Workflow Launch", "", "DCD0E0A3-F115-4609-860F-B5BF678AA41E", ""); // Site:Rock RMS
RockMigrationHelper.AddPageRoute("DCD0E0A3-F115-4609-860F-B5BF678AA41E", "LaunchWorkflows/{EntitySetId}", "D497A92F-AA0E-40BF-997F-D512FF0357CE"); // for Page:Workflow Launch
RockMigrationHelper.UpdateBlockType("Workflow Launch", "Block that enables previewing an entity set and then launching a workflow for each item within the set.", "~/Blocks/WorkFlow/WorkflowLaunch.ascx", "Workflow", "D7C15C1B-7487-42C3-A485-AD154F46558A");
// Add Block to Page: Workflow Launch Site: Rock RMS
RockMigrationHelper.AddBlock(true, "DCD0E0A3-F115-4609-860F-B5BF678AA41E".AsGuid(), null, "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "D7C15C1B-7487-42C3-A485-AD154F46558A".AsGuid(), "Workflow Launch", "Main", @"", @"", 0, "5AAAB4FD-6A07-47BD-A08E-F7DB68DD7F33");
// Attrib for BlockType: Workflow Launch:Default Number of Items to Show
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("D7C15C1B-7487-42C3-A485-AD154F46558A", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Default Number of Items to Show", "DefaultNumberOfItemsToShow", "Default Number of Items to Show", @"The number of entities to list on screen before summarizing ('...and xx more').", 5, @"50", "FF5A5181-F48E-4D75-B0FA-0CC626FDBBEE");
// Attrib for BlockType: Workflow Launch:Workflow Types
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("D7C15C1B-7487-42C3-A485-AD154F46558A", "1D50399B-0D6E-480B-A71A-E7BD37DD83F0", "Workflow Types", "WorkflowTypes", "Workflow Types", @"Only the selected workflow types will be shown. If left blank, any workflow type can be launched.", 1, @"", "EAD99415-02EA-4D67-BC8B-1B7E186D6057");
// Attrib for BlockType: Workflow Launch:Allow Multiple Workflow Launches
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("D7C15C1B-7487-42C3-A485-AD154F46558A", "1EDAFDED-DFE6-4334-B019-6EECBA89E05A", "Allow Multiple Workflow Launches", "AllowMultipleWorkflowLaunches", "Allow Multiple Workflow Launches", @"If set to yes, allows launching multiple different types of workflows. After one is launched, the block will allow the individual to select another type to be launched. This will only show if more than one type is configured.", 2, @"True", "A9F130BF-F793-4755-BAC2-8B685E1176B0");
// Attrib for BlockType: Workflow Launch:Panel Title
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("D7C15C1B-7487-42C3-A485-AD154F46558A", "9C204CD0-1233-41C5-818A-C5DA439445AA", "Panel Title", "PanelTitle", "Panel Title", @"The title to display in the block panel.", 3, @"Workflow Launch", "C291BDE3-5689-45E6-B092-87EEF0782ABE");
// Attrib for BlockType: Workflow Launch:Panel Title Icon CSS Class
RockMigrationHelper.AddOrUpdateBlockTypeAttribute("D7C15C1B-7487-42C3-A485-AD154F46558A", "9C204CD0-1233-41C5-818A-C5DA439445AA", "Panel Title Icon CSS Class", "PanelIcon", "Panel Title Icon CSS Class", @"The icon to use before the panel title.", 4, @"fa fa-cog", "8EF7E051-F5ED-4C6B-A314-04FE8D97CC89");
// Attrib Value for Block:Workflow Launch, Attribute:Default Number of Items to Show Page: Workflow Launch, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("5AAAB4FD-6A07-47BD-A08E-F7DB68DD7F33", "FF5A5181-F48E-4D75-B0FA-0CC626FDBBEE", @"");
// Attrib Value for Block:Workflow Launch, Attribute:Workflow Types Page: Workflow Launch, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("5AAAB4FD-6A07-47BD-A08E-F7DB68DD7F33", "EAD99415-02EA-4D67-BC8B-1B7E186D6057", @"");
// Attrib Value for Block:Workflow Launch, Attribute:Allow Multiple Workflow Launches Page: Workflow Launch, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("5AAAB4FD-6A07-47BD-A08E-F7DB68DD7F33", "A9F130BF-F793-4755-BAC2-8B685E1176B0", @"True");
// Attrib Value for Block:Workflow Launch, Attribute:Panel Title Page: Workflow Launch, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("5AAAB4FD-6A07-47BD-A08E-F7DB68DD7F33", "C291BDE3-5689-45E6-B092-87EEF0782ABE", @"");
// Attrib Value for Block:Workflow Launch, Attribute:Panel Title Icon CSS Class Page: Workflow Launch, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("5AAAB4FD-6A07-47BD-A08E-F7DB68DD7F33", "8EF7E051-F5ED-4C6B-A314-04FE8D97CC89", @"");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
// Add Decline Reasons defined type/values.
RockMigrationHelper.AddDefinedType("Group", "Group RSVP Decline Reason", "Possible reasons someone might decline an invitation.", SystemGuid.DefinedType.GROUP_RSVP_DECLINE_REASON);
// Nick: This list probably needs to be updated with appropriate default values.
RockMigrationHelper.UpdateDefinedValue(SystemGuid.DefinedType.GROUP_RSVP_DECLINE_REASON, "Illness", "", SystemGuid.DefinedValue.GROUP_RSVP_DECLINE_REASON_ILLNESS, true);
RockMigrationHelper.UpdateDefinedValue(SystemGuid.DefinedType.GROUP_RSVP_DECLINE_REASON, "Vacation", "", SystemGuid.DefinedValue.GROUP_RSVP_DECLINE_REASON_VACATION, true);
RockMigrationHelper.UpdateDefinedValue(SystemGuid.DefinedType.GROUP_RSVP_DECLINE_REASON, "Schedule Conflict", "", SystemGuid.DefinedValue.GROUP_RSVP_DECLINE_REASON_SCHEDULE_CONFLICT, true);
RockMigrationHelper.UpdateDefinedValue(SystemGuid.DefinedType.GROUP_RSVP_DECLINE_REASON, "No Childcare Available", "", SystemGuid.DefinedValue.GROUP_RSVP_DECLINE_REASON_CHILDCARE, true);
RockMigrationHelper.UpdateDefinedValue(SystemGuid.DefinedType.GROUP_RSVP_DECLINE_REASON, "Other", "", SystemGuid.DefinedValue.GROUP_RSVP_DECLINE_REASON_OTHER, true);
// Add Group RSVP List Page.
RockMigrationHelper.AddPage(true, SystemGuid.Page.GROUP_VIEWER, SystemGuid.Layout.FULL_WIDTH_INTERNAL_SITE, "Group RSVP List", "", SystemGuid.Page.GROUP_RSVP_LIST);
// Add RSVP List Block to RSVP List Page.
RockMigrationHelper.UpdateBlockType("RSVP List", "Lists RSVP Occurrences.", "~/Blocks/Rsvp/RsvpList.ascx", "RSVP", SystemGuid.BlockType.RSVP_LIST);
RockMigrationHelper.AddBlock(true, SystemGuid.Page.GROUP_RSVP_LIST.AsGuid(), null, SystemGuid.Site.SITE_ROCK_INTERNAL.AsGuid(), SystemGuid.BlockType.RSVP_LIST.AsGuid(), "RSVP List", "Main", @"", @"", 0, SystemGuid.Block.RSVP_LIST);
// Add Group RSVP Detail Page.
RockMigrationHelper.AddPage(true, SystemGuid.Page.GROUP_RSVP_LIST, SystemGuid.Layout.FULL_WIDTH_INTERNAL_SITE, "Group RSVP Detail", "", SystemGuid.Page.GROUP_RSVP_DETAIL);
// Add RSVP Detail Block to RSVP Detail Page.
RockMigrationHelper.UpdateBlockType("RSVP Detail", "Shows detailed RSVP information for a specific occurrence and allows editing RSVP details.", "~/Blocks/Rsvp/RsvpDetail.ascx", "RSVP", SystemGuid.BlockType.RSVP_DETAIL);
RockMigrationHelper.AddBlock(true, SystemGuid.Page.GROUP_RSVP_DETAIL.AsGuid(), null, SystemGuid.Site.SITE_ROCK_INTERNAL.AsGuid(), SystemGuid.BlockType.RSVP_DETAIL.AsGuid(), "RSVP Detail", "Main", @"", @"", 0, SystemGuid.Block.RSVP_DETAIL);
// Add Group RSVP Response Page (External Site).
RockMigrationHelper.AddPage(true, SystemGuid.Page.SUPPORT_PAGES_EXTERNAL_SITE, SystemGuid.Layout.FULL_WIDTH, "Group RSVP Response", "", SystemGuid.Page.GROUP_RSVP_RESPONSE);
RockMigrationHelper.AddPageRoute(SystemGuid.Page.GROUP_RSVP_RESPONSE, "RSVP", SystemGuid.PageRoute.RSVP);
// Add RSVP Response Block to RSVP Detail Page.
RockMigrationHelper.UpdateBlockType("RSVP Response", "Allows invited people to RSVP for one or more Attendance Occurrences.", "~/Blocks/Rsvp/RsvpResponse.ascx", "RSVP", SystemGuid.BlockType.RSVP_RESPONSE);
RockMigrationHelper.AddBlock(true, SystemGuid.Page.GROUP_RSVP_RESPONSE.AsGuid(), null, SystemGuid.Site.EXTERNAL_SITE.AsGuid(), SystemGuid.BlockType.RSVP_RESPONSE.AsGuid(), "RSVP Response", "Main", @"", @"", 0, SystemGuid.Block.RSVP_RESPONSE);
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
CreateTable(
"dbo.ScheduleCategoryExclusion",
c => new
{
Id = c.Int(nullable: false, identity: true),
CategoryId = c.Int(nullable: false),
Title = c.String(nullable: false, maxLength: 50),
StartDate = c.DateTime(nullable: false),
EndDate = c.DateTime(nullable: false),
CreatedDateTime = c.DateTime(),
ModifiedDateTime = c.DateTime(),
CreatedByPersonAliasId = c.Int(),
ModifiedByPersonAliasId = c.Int(),
Guid = c.Guid(nullable: false),
ForeignId = c.Int(),
ForeignGuid = c.Guid(),
ForeignKey = c.String(maxLength: 100),
})
.PrimaryKey(t => t.Id)
.ForeignKey("dbo.Category", t => t.CategoryId, cascadeDelete: true)
.ForeignKey("dbo.PersonAlias", t => t.CreatedByPersonAliasId)
.ForeignKey("dbo.PersonAlias", t => t.ModifiedByPersonAliasId)
.Index(t => t.CategoryId)
.Index(t => t.CreatedByPersonAliasId)
.Index(t => t.ModifiedByPersonAliasId)
.Index(t => t.Guid, unique: true);
// Page: Schedules
RockMigrationHelper.UpdateBlockType("Schedule Category Exclusion List", "List of dates that schedules are not active for an entire category.", "~/Blocks/Core/ScheduleCategoryExclusionList.ascx", "Core", "ACF84335-34A1-4DD6-B242-20119B8D0967");
RockMigrationHelper.AddBlock("AFFFB245-A0EB-4002-B736-A2D52DD692CF", "", "ACF84335-34A1-4DD6-B242-20119B8D0967", "Schedule Category Exclusion List", "Main", "", "", 1, "286DC221-C04A-4405-8B69-EC3D83740CD0");
}
/// <summary>
/// GJ: Communication Wizard Polish
/// </summary>
private void CommunicationWizardPolish()
{
// Site: Rock
RockMigrationHelper.AddLayout("C2D29296-6A87-47A9-A753-EE4E9159C4C4", "FullWorksurface", "Full Worksurface", "", "C2467799-BB45-4251-8EE6-F0BF27201535");
// Update New Communication Page to Use Full Worksurface
RockMigrationHelper.UpdatePageLayout("2A22D08D-73A8-4AAF-AC7E-220E8B2E7857", "C2467799-BB45-4251-8EE6-F0BF27201535");
// Add Block Page Menu to Layout: Full Worksurface, Site: Rock RMS
RockMigrationHelper.AddBlock(true, null, "C2467799-BB45-4251-8EE6-F0BF27201535".AsGuid(), "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "CACB9D1A-A820-4587-986A-D66A69EE9948".AsGuid(), "Page Menu", "Navigation", @"", @"", 0, "4709764E-5378-4B7D-AC85-A5D06BE86ECA");
// Add Block Attribute Value // Block: Page Menu // BlockType: Page Menu // Block Location: Layout=Full Worksurface, Site=Rock RMS // Attribute: Include Current Parameters // Attribute Value: False
RockMigrationHelper.AddBlockAttributeValue("4709764E-5378-4B7D-AC85-A5D06BE86ECA", "EEE71DDE-C6BC-489B-BAA5-1753E322F183", @"False");
// Add Block Attribute Value // Block: Page Menu // BlockType: Page Menu // Block Location: Layout=Full Worksurface, Site=Rock RMS // Attribute: Template // Attribute Value: {% include '~~/Assets/Lava/PageNav.lava' %}
RockMigrationHelper.AddBlockAttributeValue("4709764E-5378-4B7D-AC85-A5D06BE86ECA", "1322186A-862A-4CF1-B349-28ECB67229BA", @"{% include '~~/Assets/Lava/PageNav.lava' %}");
// Add Block Attribute Value // Block: Page Menu // BlockType: Page Menu // Block Location: Layout=Full Worksurface, Site=Rock RMS // Attribute: Root Page // Attribute Value: 20f97a93-7949-4c2a-8a5e-c756fe8585ca
RockMigrationHelper.AddBlockAttributeValue("4709764E-5378-4B7D-AC85-A5D06BE86ECA", "41F1C42E-2395-4063-BD4F-031DF8D5B231", @"20f97a93-7949-4c2a-8a5e-c756fe8585ca");
// Add Block Attribute Value // Block: Page Menu // BlockType: Page Menu // Block Location: Layout=Full Worksurface, Site=Rock RMS // Attribute: Number of Levels // Attribute Value: 3
RockMigrationHelper.AddBlockAttributeValue("4709764E-5378-4B7D-AC85-A5D06BE86ECA", "6C952052-BC79-41BA-8B88-AB8EA3E99648", @"3");
// Add Block Attribute Value // Block: Page Menu // BlockType: Page Menu // Block Location: Layout=Full Worksurface, Site=Rock RMS // Attribute: Include Current QueryString // Attribute Value: False
RockMigrationHelper.AddBlockAttributeValue("4709764E-5378-4B7D-AC85-A5D06BE86ECA", "E4CF237D-1D12-4C93-AFD7-78EB296C4B69", @"False");
// Add Block Attribute Value // Block: Page Menu // BlockType: Page Menu // Block Location: Layout=Full Worksurface, Site=Rock RMS // Attribute: Is Secondary Block // Attribute Value: False
RockMigrationHelper.AddBlockAttributeValue("4709764E-5378-4B7D-AC85-A5D06BE86ECA", "C80209A8-D9E0-4877-A8E3-1F7DBF64D4C2", @"False");
// Add Block Login Status to Layout: Full Worksurface, Site: Rock RMS
RockMigrationHelper.AddBlock(true, null, "C2467799-BB45-4251-8EE6-F0BF27201535".AsGuid(), "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "04712F3D-9667-4901-A49D-4507573EF7AD".AsGuid(), "Login Status", "Login", @"", @"", 0, "0E3484CA-06EA-46CD-A55E-A1A480965DC9");
// Add Block Smart Search to Layout: Full Worksurface, Site: Rock RMS
RockMigrationHelper.AddBlock(true, null, "C2467799-BB45-4251-8EE6-F0BF27201535".AsGuid(), "C2D29296-6A87-47A9-A753-EE4E9159C4C4".AsGuid(), "9D406BD5-88C1-45E5-AFEA-70F9CFB66C74".AsGuid(), "Smart Search", "Header", @"", @"", 0, "AD1A8AD8-3E94-45F3-A4B4-6BD2AE72A133");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
RockMigrationHelper.AddPage("C831428A-6ACD-4D49-9B2D-046D399E3123", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Checkr", "", CheckrSystemGuid.CHECKR_PAGE, "fa fa-shield", "E7F4B733-60FF-4FA3-AB17-0832E123F6F2"); // Site:Rock RMS
RockMigrationHelper.UpdateBlockType("Checkr Settings", "Block for updating the settings used by the Checkr integration.", "~/Blocks/Security/BackgroundCheck/CheckrSettings.ascx", "Security > Background Check", CheckrSystemGuid.CHECKR_SETTINGS_BLOCKTYPE);
RockMigrationHelper.UpdateBlockType("Checkr Request List", "Lists all the Checkr background check requests.", "~/Blocks/Security/BackgroundCheck/CheckrRequestList.ascx", "Security > Background Check", CheckrSystemGuid.CHECKR_REQUESTLIST_BLOCKTYPE);
RockMigrationHelper.AddBlock(CheckrSystemGuid.CHECKR_PAGE, "", CheckrSystemGuid.CHECKR_SETTINGS_BLOCKTYPE, "Checkr Settings", "Main", "", "", 0, CheckrSystemGuid.CHECKR_SETTINGS_BLOCK);
RockMigrationHelper.AddBlock(CheckrSystemGuid.CHECKR_PAGE, "", CheckrSystemGuid.CHECKR_REQUESTLIST_BLOCKTYPE, "Checkr Request List", "Main", "", "", 1, CheckrSystemGuid.CHECKR_REQUESTLIST_BLOCK);
// Attrib for BlockType: Request List:Workflow Detail Page
RockMigrationHelper.AddBlockTypeAttribute(CheckrSystemGuid.CHECKR_REQUESTLIST_BLOCKTYPE, FieldType.PAGE_REFERENCE, "Workflow Detail Page", "WorkflowDetailPage", "", "The page to view details about the background check workflow", 0, @"", CheckrSystemGuid.CHECKR_REQUESTLIST_WORKFLOWDETAILPAGE_ATTRIBUTE);
// Attrib Value for Block:Request List, Attribute:Workflow Detail Page Page: Protect My Ministry, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue(CheckrSystemGuid.CHECKR_REQUESTLIST_WORKFLOWDETAILPAGE_ATTRIBUTE, "EBD0D19C-E73D-41AE-82D4-C89C21C35998", Rock.SystemGuid.Page.WORKFLOW_DETAIL);
int count = (int)SqlScalar("SELECT COUNT(Id) FROM [dbo].[BackgroundCheck]");
if (count == 0)
{
MakeCheckrDefaultWorkflowAction();
}
else
{
// Do nothing if PMM have been used.
}
}
private void AddLogPage()
{
RockMigrationHelper.UpdateBlockType("Logs",
"Block to view system logs.",
"~/Blocks/Administration/LogViewer.ascx",
"Administration",
SystemGuid.BlockType.LOG_VIEWER);
RockMigrationHelper.AddPage(true,
SystemGuid.Page.SYSTEM_SETTINGS,
SystemGuid.Layout.FULL_WIDTH_INTERNAL_SITE,
"Rock Logs",
"",
SystemGuid.Page.LOG_VIEWER,
"fa fa-file-medical-alt"); // Site:Rock RMS
// Add Block to Page: Rock Logs Site: Rock RMS
RockMigrationHelper.AddBlock(true,
SystemGuid.Page.LOG_VIEWER.AsGuid(),
null,
SystemGuid.Site.SITE_ROCK_INTERNAL.AsGuid(),
SystemGuid.BlockType.LOG_VIEWER.AsGuid(),
"Rock Logs",
"Main",
"",
"",
0,
SystemGuid.Block.LOG_VIEWER);
}
private void AccountTopLevelOrderingPage()
{
RockMigrationHelper.AddPage(true, "2B630A3B-E081-4204-A3E4-17BB3A5F063D", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Order Top-Level Accounts", string.Empty, "AD1ED5A5-2E43-433F-B1C3-E6052213EF71", string.Empty); // Site:Rock RMS
// Add Block to Page: Order Top-Level Accounts, Site: Rock RMS
RockMigrationHelper.AddBlock(true, "AD1ED5A5-2E43-433F-B1C3-E6052213EF71", string.Empty, "87A5A2E4-E6BA-4F3C-A6F2-ED046A04062E", "Top-Level Account List", "Main", string.Empty, string.Empty, 0, "EB047AC6-40BB-4215-AACC-5ECE8FE73A9B");
// Attrib for BlockType: Scheduled Transaction List:Person Token Usage Limit
RockMigrationHelper.UpdateBlockTypeAttribute("694FF260-8C6F-4A59-93C9-CF3793FE30E6", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Person Token Usage Limit", "PersonTokenUsageLimit", string.Empty, @"When adding a new scheduled transaction from a person detail page, the maximum number of times the person token for the transaction can be used.", 4, @"1", "A6B71434-FD9B-45EC-AA50-07AE5D6BA384");
// Attrib for BlockType: Scheduled Transaction List:Person Token Expire Minutes
RockMigrationHelper.UpdateBlockTypeAttribute("694FF260-8C6F-4A59-93C9-CF3793FE30E6", "A75DFC58-7A1B-4799-BF31-451B2BBE38FF", "Person Token Expire Minutes", "PersonTokenExpireMinutes", string.Empty, @"When adding a new scheduled transaction from a person detail page, the number of minutes the person token for the transaction is valid after it is issued.", 3, @"60", "ADC80D72-976B-4DFD-B50C-5B2BAC3FFD17");
// Attrib for BlockType: Account Tree View:Order Top-Level Page
RockMigrationHelper.UpdateBlockTypeAttribute("EC6ECB2B-665F-43FC-9FF4-A6B1CD5F2AE6", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Order Top-Level Page", "OrderTopLevelPage", string.Empty, string.Empty, 5, string.Empty, "F3E582D6-409E-4CDA-80FA-8E46B8CD95AF");
// Attrib Value for Block:Scheduled Contributions, Attribute:Person Token Usage Limit Page: Scheduled Transactions, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("32A7BA7B-968E-4BFD-BEA3-042CF863D751", "A6B71434-FD9B-45EC-AA50-07AE5D6BA384", @"1");
// Attrib Value for Block:Scheduled Contributions, Attribute:Person Token Expire Minutes Page: Scheduled Transactions, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("32A7BA7B-968E-4BFD-BEA3-042CF863D751", "ADC80D72-976B-4DFD-B50C-5B2BAC3FFD17", @"60");
// Attrib Value for Block:Finance - Giving Profile List, Attribute:Person Token Usage Limit Page: Contributions, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("B33DF8C4-29B2-4DC5-B182-61FC255B01C0", "A6B71434-FD9B-45EC-AA50-07AE5D6BA384", @"1");
// Attrib Value for Block:Finance - Giving Profile List, Attribute:Person Token Expire Minutes Page: Contributions, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("B33DF8C4-29B2-4DC5-B182-61FC255B01C0", "ADC80D72-976B-4DFD-B50C-5B2BAC3FFD17", @"60");
// Attrib Value for Block:Account Tree View, Attribute:Order Top-Level Page Page: Accounts, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("7F52E6B6-B4ED-4ECE-BE19-98BD3B939965", "F3E582D6-409E-4CDA-80FA-8E46B8CD95AF", @"ad1ed5a5-2e43-433f-b1c3-e6052213ef71");
}
/// <summary>
/// Add SystemCommunication pages and blocks and rename SystemEmail pages and blocks.
/// </summary>
private void SystemCommunicationPagesAndBlocksUp()
{
// Add New Block Types.
RockMigrationHelper.UpdateBlockType("System Communication List", "Lists the system communications that can be configured for use by the system and other automated (non-user) tasks.", "~/Blocks/Communication/SystemCommunicationList.ascx", "Communication", SystemGuid.BlockType.SYSTEM_COMMUNICATION_LIST);
RockMigrationHelper.AddNewBlockTypeAttribute(SystemGuid.BlockType.SYSTEM_COMMUNICATION_LIST, SystemGuid.FieldType.PAGE_REFERENCE, "Detail Page", "DetailPage", "Detail Page", "", 0, SystemGuid.Page.SYSTEM_COMMUNICATION_DETAIL, SystemGuid.Attribute.SYSTEM_COMMUNICATION_LIST_DETAIL_PAGE, false);
RockMigrationHelper.UpdateBlockType("System Communication Detail", "Allows the administration of a system communication.", "~/Blocks/Communication/SystemCommunicationDetail.ascx", "Communication", SystemGuid.BlockType.SYSTEM_COMMUNICATION_DETAIL);
// Add System Communication List.
RockMigrationHelper.AddPage(true, SystemGuid.Page.COMMUNICATIONS_ROCK_SETTINGS, SystemGuid.Layout.FULL_WIDTH_INTERNAL_SITE, "System Communications", "", SystemGuid.Page.SYSTEM_COMMUNICATION_LIST, "fa fa-comments-o", SystemGuid.Page.COMMUNICATION_TEMPLATES_COMMUNICATIONS);
RockMigrationHelper.AddBlock(true, SystemGuid.Page.SYSTEM_COMMUNICATION_LIST, null, SystemGuid.BlockType.SYSTEM_COMMUNICATION_LIST, "System Communication List", "Main", @"", @"", 0, SystemGuid.Block.SYSTEM_COMMUNICATION_LIST);
RockMigrationHelper.AddBlockAttributeValue(SystemGuid.Block.SYSTEM_COMMUNICATION_LIST, SystemGuid.Attribute.SYSTEM_COMMUNICATION_LIST_DETAIL_PAGE, SystemGuid.Page.SYSTEM_COMMUNICATION_DETAIL);
RockMigrationHelper.AddPageRoute(SystemGuid.Page.SYSTEM_COMMUNICATION_LIST, "Communications/System", "AB7E233D-B45E-4394-BA3A-C059FA75B29F");
// Add System Communication Detail.
RockMigrationHelper.AddPage(true, SystemGuid.Page.SYSTEM_COMMUNICATION_LIST, SystemGuid.Layout.FULL_WIDTH_INTERNAL_SITE, "System Communication Details", "", SystemGuid.Page.SYSTEM_COMMUNICATION_DETAIL, "fa fa-comments-o");
RockMigrationHelper.AddBlock(true, SystemGuid.Page.SYSTEM_COMMUNICATION_DETAIL, null, SystemGuid.BlockType.SYSTEM_COMMUNICATION_DETAIL, "System Communication Detail", "Main", @"", @"", 0, SystemGuid.Block.SYSTEM_COMMUNICATION_DETAIL);
RockMigrationHelper.AddPageRoute(SystemGuid.Page.SYSTEM_COMMUNICATION_DETAIL, "Communications/System/{CommunicationId}", "5F7B7998-E83D-45D6-A3C6-1C866C509C28");
// Update System Communication Categories
SetBlockAttributeValue(SystemGuid.Block.SYSTEM_COMMUNICATION_CATEGORIES, "EntityType", SystemGuid.EntityType.SYSTEM_COMMUNICATION);
// Rename existing Pages.
RockMigrationHelper.RenamePage(ObsoleteSystemGuid_Page_SYSTEM_EMAILS, "System Emails (Legacy)");
RockMigrationHelper.RenamePage(ObsoleteSystemGuid_Page_SYSTEM_EMAIL_DETAILS, "System Email Details (Legacy)");
RockMigrationHelper.RenamePage(SystemGuid.Page.SYSTEM_EMAIL_CATEGORIES_COMMUNICATIONS, "System Communication Categories");
RockMigrationHelper.RenamePage(SystemGuid.Page.SYSTEM_EMAIL_CATEGORIES_SYSTEM_EMAILS, "System Communication Categories");
}
/// <summary>
/// The commands to run to migrate plugin to the specific version
/// </summary>
public override void Up()
{
RockMigrationHelper.AddPage("7F2581A1-941E-4D51-8A9D-5BE9B881B003", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Referral Agencies", "", "223AC4F2-CBED-4733-807A-188CFBBFA0C8", "fa fa-check-square-o"); // Site:Rock RMS
RockMigrationHelper.AddPage("223AC4F2-CBED-4733-807A-188CFBBFA0C8", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Referral Agency Details", "", "4BF8FA57-AE86-4103-B07E-80ECE0000AEE", "fa fa-check-square-o"); // Site:Rock RMS
// Since the Referral Agency Details block handles displaying the breadcrumb for the page, we need to turn off the default breadcrumb rendered by the page
Sql(@"
UPDATE [Page] SET [BreadCrumbDisplayName] = 0 WHERE [Guid] = '4BF8FA57-AE86-4103-B07E-80ECE0000AEE'
");
RockMigrationHelper.UpdateBlockType("Referral Agency Detail", "Displays the details of a Referral Agency.", "~/Plugins/com_schracksolutions/SampleProject/ReferralAgencyDetail.ascx", "com_schracksolutions > Sample Project", "2F130DF6-1EE4-45CE-9410-CBB0517EB33E");
RockMigrationHelper.UpdateBlockType("Referral Agency List", "Lists all the Referral Agencies.", "~/Plugins/com_schracksolutions/SampleProject/ReferralAgencyList.ascx", "com_schracksolutions > Sample Project", "53F447CE-4B91-470A-A15D-B60DCAAB29CB");
// Add Block to Page: Referral Agencies, Site: Rock RMS
RockMigrationHelper.AddBlock("223AC4F2-CBED-4733-807A-188CFBBFA0C8", "", "53F447CE-4B91-470A-A15D-B60DCAAB29CB", "Referral Agency List", "Main", "", "", 0, "A0B53736-4132-4D1B-8300-9F9FB1A5DC21");
// Add Block to Page: Referral Agency Details, Site: Rock RMS
RockMigrationHelper.AddBlock("4BF8FA57-AE86-4103-B07E-80ECE0000AEE", "", "2F130DF6-1EE4-45CE-9410-CBB0517EB33E", "Referral Agency Detail", "Main", "", "", 0, "B69EBD0E-A1B4-47C5-AAE7-B40BEA37965F");
// Attrib for BlockType: Referral Agency List:Detail Page
RockMigrationHelper.AddBlockTypeAttribute("53F447CE-4B91-470A-A15D-B60DCAAB29CB", "BD53F9C9-EBA9-4D3F-82EA-DE5DD34A8108", "Detail Page", "DetailPage", "", "", 0, @"", "5B480350-663C-4789-BF4D-33EC8DF882E8");
// Attrib Value for Block:Referral Agency List, Attribute:Detail Page Page: Referral Agencies, Site: Rock RMS
RockMigrationHelper.AddBlockAttributeValue("A0B53736-4132-4D1B-8300-9F9FB1A5DC21", "5B480350-663C-4789-BF4D-33EC8DF882E8", @"4bf8fa57-ae86-4103-b07e-80ece0000aee");
RockMigrationHelper.AddDefinedType("Global", "Referral Agency Type", "The type of agency (e.g. Counseling, Food, Financial Assistance, etc.)", "150478D4-3709-4543-906F-1F9496B4E7D0");
RockMigrationHelper.AddDefinedValue("150478D4-3709-4543-906F-1F9496B4E7D0", "Counseling and Therapy", "", "83F9A59C-DBE5-4E1A-B33C-F701FA8175E1", false);
RockMigrationHelper.AddDefinedValue("150478D4-3709-4543-906F-1F9496B4E7D0", "Financial Assistance or Counseling", "", "7A30D312-996E-4823-B1FF-AA27C1806521", false);
RockMigrationHelper.AddDefinedValue("150478D4-3709-4543-906F-1F9496B4E7D0", "24 Hour Crisis Hotlines", "", "EDBE6DCE-313F-4648-8D97-A39520A54BFC", false);
RockMigrationHelper.AddDefinedValue("150478D4-3709-4543-906F-1F9496B4E7D0", "Youth Resources", "", "BB666FA1-5391-40B1-B334-3A27575AD9D5", false);
RockMigrationHelper.AddDefinedValue("150478D4-3709-4543-906F-1F9496B4E7D0", "Food and Clothing", "", "E15AE7DE-3555-437B-99B0-B28601C4EA2D", false);
RockMigrationHelper.AddDefinedValue("150478D4-3709-4543-906F-1F9496B4E7D0", "Homeless Resources/Housing", "", "F6E4D78C-E05A-4AEF-AF8C-09B3B8FDDEBF", false);
RockMigrationHelper.AddDefinedValue("150478D4-3709-4543-906F-1F9496B4E7D0", "Substance Abuse", "", "AD01D370-7CB6-4261-ACF6-8EE21CB353AA", false);
RockMigrationHelper.AddDefinedValue("150478D4-3709-4543-906F-1F9496B4E7D0", "Residential Drug Treatment Centers", "", "57F4BCC8-B80F-48E5-93E2-A76E3F572C0C", false);
RockMigrationHelper.AddDefinedValue("150478D4-3709-4543-906F-1F9496B4E7D0", "Domestic Violence Resources", "", "AE95FD8A-FD9E-4EDD-9689-5491725FEFE6", false);
RockMigrationHelper.AddDefinedValue("150478D4-3709-4543-906F-1F9496B4E7D0", "Mediation", "", "40C66BE2-CE13-4E7D-980A-A2D66968CE57", false);
RockMigrationHelper.AddDefinedValue("150478D4-3709-4543-906F-1F9496B4E7D0", "Miscellaneous", "", "62AB4A35-6E72-4BCD-BF6A-5B0D2052BACA", false);
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
RockMigrationHelper.AddPage("18C9E5C3-3E28-4AA3-84F6-78CD4EA2DD3C", "D65F783D-87A9-4CC9-8110-E83466A0EADB", "Pledge Analytics", "", "FEB2332D-4605-4E2B-8EF2-2C6B1A9612C3", ""); // Site:Rock RMS
RockMigrationHelper.UpdateBlockType("Email Form", "Block that takes and HTML form and emails the contents to an address of your choosing.", "~/Blocks/Cms/EmailForm.ascx", "CMS", "48253494-F8A0-4DD8-B645-6CB481CEB7BD");
RockMigrationHelper.UpdateBlockType("Pledge Analytics", "Used to look at pledges using various criteria.", "~/Blocks/Finance/PledgeAnalytics.ascx", "Finance", "72B4BBC0-1E8A-46B7-B956-A399624F513C");
// Add Block to Page: Pledge Analytics, Site: Rock RMS
RockMigrationHelper.AddBlock("FEB2332D-4605-4E2B-8EF2-2C6B1A9612C3", "", "72B4BBC0-1E8A-46B7-B956-A399624F513C", "Pledge Analytics", "Main", "", "", 0, "2DFEEEAE-0DC3-4DF5-B2B8-3C33C81624B3");
//
// rename blocks
//
// ReportData -> Dynamic Report
Sql(@"DELETE FROM [BlockType] WHERE [Path] = '~/Blocks/Reporting/DynamicReport.ascx'");
Sql(@"UPDATE [BlockType] SET [Path] = '~/Blocks/Reporting/DynamicReport.ascx', [Name] = 'Dynamic Report' WHERE [Guid] = 'C7C069DB-9EEE-4245-9DF2-34E3A1FF4CCB'");
// AttendanceAnalysis -> Attendance Analytics
Sql(@"DELETE FROM [BlockType] WHERE [Path] = '~/Blocks/CheckIn/AttendanceAnalytics.ascx'");
Sql(@"UPDATE [BlockType] SET [Path] = '~/Blocks/CheckIn/AttendanceAnalytics.ascx', [Name] = 'Attendance Analytics' WHERE [Guid] = '3CD3411C-C076-4344-A9D5-8F3B4F01E31D'");
// rename attendance analysis page
Sql(@"UPDATE [Page]
SET [BrowserTitle] = 'Attendance Analytics', [PageTitle] = 'Attendance Analytics', [InternalName] = 'Attendance Analytics'
WHERE [Guid] = '7A3CF259-1090-403C-83B7-2DB3A53DEE26'");
}
/// <summary>
/// Operations to be performed during the upgrade process.
/// </summary>
public override void Up()
{
// Add Page En Route to Site:Rock Check-in Manager
RockMigrationHelper.AddPage(true, "A4DCE339-9C11-40CA-9A02-D2FE64EA164B", "8305704F-928D-4379-967A-253E576E0923", "En Route", "", Rock.SystemGuid.Page.CHECK_IN_MANAGER_EN_ROUTE, "fa fa-walking");
// Remove page display options for Check-in En Route page
Sql($@"UPDATE [Page]
SET [PageDisplayBreadCrumb] = 0, [PageDisplayDescription] = 0, [PageDisplayIcon] = 0, [PageDisplayTitle] = 0
WHERE [Guid] IN (
'{Rock.SystemGuid.Page.CHECK_IN_MANAGER_EN_ROUTE}'
)");
// Add/Update BlockType En Route
RockMigrationHelper.UpdateBlockType("En Route", "Lists the people who are checked-in but not yet marked present.", "~/Blocks/CheckIn/Manager/EnRoute.ascx", "Check-in > Manager", Rock.SystemGuid.BlockType.CHECK_IN_MANAGER_EN_ROUTE);
// Add Block En Route to Page: En Route, Site: Rock Check-in Manager
RockMigrationHelper.AddBlock(true, "F6466964-6593-4B20-A49B-D2386D8A260C".AsGuid(), null, "A5FA7C3C-A238-4E0B-95DE-B540144321EC".AsGuid(), "BC86F18C-9F38-4CA3-8CF9-5A837CBC700D".AsGuid(), "En Route", "Main", @"", @"", 0, Rock.SystemGuid.Block.CHECKIN_MANAGER_EN_ROUTE);
Sql($@"
Update [Page] set [Order] =
(select [Order]+1 from [Page] where Guid = '{Rock.SystemGuid.Page.CHECK_IN_MANAGER_EN_ROUTE}')
where [Guid] = '{Rock.SystemGuid.Page.CHECK_IN_MANAGER_SETTINGS}'
");
// Add/Update HtmlContent for Block: Back Button
RockMigrationHelper.UpdateHtmlContentBlock("B62CBF17-7FD1-42C8-9E98-00270A34400D", @"<a href=""javascript:history.back();"" class=""btn btn-nav-zone""><i class=""fa fa-chevron-left""></i></a>", "26988382-5547-41E4-B737-99F0C079A788");
}
