SortCMSPages.cs

public class SortCMSPages : Migration
{
    /// <summary>
    /// Operations to be performed during the upgrade process.
    /// </summary>
    public override void Up()
    {
        // Remove page display options for Section Pages in CMS Config
        var cmsSectionPageGuids = new string[] {
            "\'CCDFEA8F-CF33-49C7-86C0-C4B10DCF1E89\'", // Website Configurations Section Page
            "\'889D7F7F-EB0F-40CD-9E80-E58A00EE69F7\'", // Content Channels Section Page
            "\'B892DF6D-4789-4AC3-9E6C-2BFE0D9E30E4\'", // Personalization Section Page
            "\'04FE297E-D45E-44EC-B521-181423F05A1C\'", // Content Platform Section Page
            "\'82726ACD-3480-4514-A920-FE920A71C046\'" // Digital Media Applications Section Page
        }.JoinStrings( ", " );

        Sql( $@"UPDATE [dbo].[Page]
                SET [PageDisplayBreadCrumb] = 0,
                    [PageDisplayDescription] = 0,
                    [PageDisplayIcon] = 0,
                    [PageDisplayTitle] = 0,
                    [BreadCrumbDisplayName] = 0
            WHERE [Guid] IN ( 
                {cmsSectionPageGuids}
            )" );

        // Set the order of the pages within the Sections
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 1 WHERE [Guid] = '7596D389-4EAB-4535-8BEE-229737F46F44'" ); // Sites Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 2 WHERE [Guid] = 'EC7A06CD-AAB5-4455-962E-B4043EA2440E'" ); // Pages Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 3 WHERE [Guid] = '6F074DAA-BDCC-44C5-BB89-B899C1AAC6C1'" ); // File Manager Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 4 WHERE [Guid] = '4A833BE3-7D5E-4C38-AF60-5706260015EA'" ); // Routes Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 5 WHERE [Guid] = '5FBE9019-862A-41C6-ACDC-287D7934757D'" ); // Block Types Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 6 WHERE [Guid] = 'BC2AFAEF-712C-4173-895E-81347F6B0B1C'" ); // Themes Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 7 WHERE [Guid] = '39F928A5-1374-4380-B807-EADF145F18A1'" ); // HTTP Modules Page

        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 1 WHERE [Guid] = '8ADCE4B2-8E95-4FA3-89C4-06A883E8145E'" ); // Content Channels Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 2 WHERE [Guid] = '37E3D602-5D7D-4818-BCAA-C67EBB301E55'" ); // Content Channel Types Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 3 WHERE [Guid] = '40875E7E-B912-43FF-892B-6161C21F130B'" ); // Content Collections Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 4 WHERE [Guid] = 'F1ED10C2-A17D-4310-9F86-76E11A4A7ED2'" ); // Content Component Templates Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 5 WHERE [Guid] = 'BBDE39C3-01C9-4C9E-9506-C2205508BC77'" ); // Content Channel Item Attribute Categories Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 6 WHERE [Guid] = '0F1B45B8-032D-4306-834D-670FA3933589'" ); // Content Channel Categories Page

        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 1 WHERE [Guid] = '905F6132-AE1C-4C85-9752-18D22E604C3A'" ); // Personalization Segments Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 2 WHERE [Guid] = '511FC29A-EAF2-4AC0-B9B3-8613739A9ACF'" ); // Request Filters Page

        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 1 WHERE [Guid] = '6CFF2C81-6303-4477-A7EC-156DDBF8BE64'" ); // Lava Shortcodes Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 2 WHERE [Guid] = '07CB7BB5-1465-4E75-8DD4-28FA6EA48222'" ); // Media Accounts Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 3 WHERE [Guid] = '37C20B91-737B-42D1-907D-9868104DBA7B'" ); // Persisted Datasets Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 4 WHERE [Guid] = '8C0114FF-31CF-443E-9278-3F9E6087140C'" ); // Short Links Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 5 WHERE [Guid] = 'C206A96E-6926-4EB9-A30F-E5FCE559D180'" ); // Shared Links Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 6 WHERE [Guid] = '4B8691C7-537F-4B6E-9ED1-E3BA3FA0051E'" ); // Cache Manager Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 7 WHERE [Guid] = 'D2B919E2-3725-438F-8A86-AC87F81A72EB'" ); // Asset Manager Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 8 WHERE [Guid] = '706C0584-285F-4014-BA61-EC42C8F6F76B'" ); // Control Gallery Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 9 WHERE [Guid] = 'BB2AF2B3-6D06-48C6-9895-EDF2BA254533'" ); // Font Awesome Settings Page

        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 1 WHERE [Guid] = '784259EC-46B7-4DE3-AC37-E8BFDB0B90A6'" ); // Mobile Applications Page
        Sql( $@"UPDATE [dbo].[Page] SET [Order] = 2 WHERE [Guid] = 'C8B81EBE-E98F-43EF-9E39-0491685145E2'" ); // Apple TV Apps Page

    }

    /// <summary>
    /// Operations to be performed during the downgrade process.
    /// </summary>
    public override void Down()
    {
        // Down migrations are not yet supported in plug-in migrations.
    }
}