Try our conversational search powered by Generative AI!

HXH
HXH
Apr 30, 2012
  2796
(0 votes)

EPiServer Workflow Replacement : Step 4–Rejecting Pages Programmatically

This is the fourth in a series of posts about how my company built a replacement workflow platform for EPiServer. Why we chose to do this is explained here: http://world.episerver.com/Blogs/Hans/Dates/2012/4/EPiServer-Workflow-Replacement--Step-1Explanation-and-Disabling-Edit-Tab/

I’ll go on record here and say that I don’t love that this is done through the database. This is why SDK’s are made..and this entire process should be able to be done by using the PageProviderBase.SetPageStatus method as described here : http://sdk.episerver.com/library/cms5/html/M_EPiServer_Core_PageProviderBase_SetPageStatus.htm

….. but, as I mentioned already, it doesn’t work – so we have to go right into the database. Any time you do this, make sure you know what you’re doing – there’s a good chance you’re mucking with something that isn’t meant to be touched. I take no responsibility for you using this, you’ve been warned*!

(*that being said, we’ve been using this in EPiServer CMS 5 for three years and EPiServer CMS 6 for several months, across different environments, and haven’t had any problems)

Here’s our RejectPage method. Basically, tblWorkPage seems to have all of the page status information – and all it really  needs is the WorkPageID (pkID) and the PageLinkID (fkPageID) values, and all we do is set ReadyToPublish back to 0, which in EPiServer terms basically means that the page is “Not Ready”.

 

        protected void RejectPage(PageData pageToReject)
        {
            SqlConnection SQLConnection = new SqlConnection();
            string UpdateString = "UPDATE tblWorkPage " +
                                "SET ReadyToPublish = 0 " +
                                "WHERE (pkID = " + pageToReject.WorkPageID + " ) " +
                                "AND (fkPageID = " + pageToReject.PageLink.ID + " )";

            String strConnString = ConfigurationManager.ConnectionStrings["EPiServerDB"].ConnectionString;
            try
            {
                SQLConnection.ConnectionString = strConnString;
                SQLConnection.Open();
                SqlCommand mySqlCommand = SQLConnection.CreateCommand();
                mySqlCommand.CommandText = UpdateString;

                mySqlCommand.ExecuteNonQuery();

            }
            catch (Exception ex)
            {
                if (SQLConnection != null)
                    SQLConnection.Dispose();
                ErrorHandler.HandleError(ex);
            }
            finally
            {
                SQLConnection.Close();
            }

        }
 

We, of course, are an Oracle shop, so most of our instances are actually using the following variant instead:

      protected void RejectPageOracle(PageData pageToReject)
        {
            OracleConnection ORCLConnection = new OracleConnection(strConnString);

            string UpdateString = "UPDATE tblWorkPage SET " +
                            "ReadyToPublish = 0 " +
                            "WHERE pkID = " + pageToReject.WorkPageID +
                            "AND fkPageID = " + pageToReject.PageLink.ID;
            try
            {
                ORCLConnection.Open();
                OracleCommand oracleCommand = ORCLConnection.CreateCommand();
                oracleCommand.CommandText = UpdateString;
                oracleCommand.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                ORCLConnection.Close();
                ErrorHandler.HandleError(ex);
            }
            finally
            {
                ORCLConnection.Close();
            }
        }
 

…but you get the idea. In the next post I will discuss how we get around those pesky “Save and Publish” buttons which let people circumvent our new Workflow implementation.

Apr 30, 2012

Comments

sca sc
sca sc May 30, 2018 05:26 AM

http://www.wholesalereclinersfurniture.com/ 

Our superior recliner chairs come in various styles to complement any room.From traditional reclining chairs to power and wall hugger recliners, La-Z-Boy has one to fit every room and every style.

Please login to comment.
Latest blogs
Optimizely Web... 6 Game Changing Features in 2024

If you are interested in learning about what's new within Optimizely Web, you are in the right place. Carry on reading to learn about the 6 greates...

Jon Jones | Mar 3, 2024 | Syndicated blog

Headless forms reloaded (beta)

Forms is used on the vast majority of CMS installations. But using Forms in a headless setup is a bit of pain since the rendering pipeline is based...

MartinOttosen | Mar 1, 2024

Uploading blobs to Optimizely DXP via PowerShell

We had a client moving from an On-Prem v11 Optimizely instance to DXP v12 and we had a lot of blobs (over 40 GB) needing uploading to DXP as a part...

Nick Hamlin | Mar 1, 2024 | Syndicated blog

DbLocalizationProvider v8.0 Released

I’m pleased to announce that Localization Provider v8.0 is finally out.

valdis | Feb 28, 2024 | Syndicated blog

Epinova DXP deployment extension – With Octopus deploy

Example how you can use Epinova DXP deployment extension in Octopus deployment.

Ove Lartelius | Feb 28, 2024 | Syndicated blog

Identify Azure web app instance id's for an Optimizely CMS site

When running Optimizely CMS in Azure, you will be using an instance bound cloud license. What instances are counted, and how can you check them? Le...

Tomas Hensrud Gulla | Feb 27, 2024 | Syndicated blog