public DateTime GetLastPublishedDate(string url)
 {
     using (Com.Tridion.Broker.Pages.Meta.SQLPageMetaHome pa = new Com.Tridion.Broker.Pages.Meta.SQLPageMetaHome())
     {
         Com.Tridion.Meta.PageMeta pm = pa.FindByURL(PublicationId, url);
         if (pm == null)
         {
             return(DateTime.Now);
         }
         else
         {
             return(DateTime.Parse(pm.GetLastPublicationDate().ToString()));
         }
     }
 }
        /// <summary>
        /// Gets the raw string (xml) from the broker db by URL
        /// </summary>
        /// <param name="Url">URL of the page</param>
        /// <returns>String with page xml or empty string if no page was found</returns>
        private string GetStringContentFromBrokerByUrl(string Url, int publicationId)
        {
            string retVal = string.Empty;

            //TODO: Add usings instead of fully classified names
            using (Com.Tridion.Broker.Pages.Meta.SQLPageMetaHome pa = new Com.Tridion.Broker.Pages.Meta.SQLPageMetaHome())
            {
                Com.Tridion.Meta.PageMeta pm = pa.FindByURL(publicationId, Url);
                if (pm == null)
                {
                    return(retVal);
                }
                using (Com.Tridion.Broker.Pages.SQLPageHome pageHome = new Com.Tridion.Broker.Pages.SQLPageHome())
                {
                    Com.Tridion.Data.CharacterData data = pageHome.FindByPrimaryKey(publicationId, pm.GetId());
                    retVal = data.GetString();
                }
            }

            return(retVal);
        }