HXH
HXH
Apr 30, 2012
  2307
(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
404 Error on Static Assets Within an Optimizely plugin

Background With the move to CMS 12 and .NET 5/6, developers are now able to build Plugins and Extensions using Razor Class Libraries (RCL).  These...

Mark Stott | Sep 23, 2022

How to bypass the content creation view in Optimizely

Something that has come up a couple of times in the last few year is feedback from content editors about the editing view that comes up when creati...

Ynze | Sep 23, 2022 | Syndicated blog

Welcome to Optimizely World's New Tech Video Portal

Optimizely, leader in the digital experience realm, has become a wealth of world class SaaS products including Web Experimentation, Full Stack, B2B...

The Developer Marketing Team of Optimizely | Sep 22, 2022

Introducing New Developer Tools for Integrated B2B Commerce & Content Cloud

We are very pleased to be releasing some developer tools to support Optimizely B2B Commerce and Optimizely Content Cloud integration.  This release...

Kara Andersen | Sep 22, 2022