Hannes Foulds - Professional Profile

using System;
using System.IO;
using System.Text;
using System.Xml;
using System.Xml.Serialization;

namespace Alexandria.Forums.Web.Navigation 
{
	/// <author>Hannes Foulds</author>
	/// <date>14 August 2006</date>
	/// <summary>
	/// The site map page object.
	/// </summary>
	[System.Xml.Serialization.XmlRootAttribute(ElementName="page", IsNullable=false)]
	public class Page 
	{
		#region Declarations
		private Page _parent;	// the parent page
		#endregion

		#region Properties
		/// <summary>
		/// The parent page.
		/// </summary>
		public Page Parent
		{
			get { return this._parent; }
			set { this._parent = value; }
		}
		#endregion

		#region Schema Properties
		/// <remarks/>
		[System.Xml.Serialization.XmlElementAttribute("page")]
		public Page[] Items;
        
		/// <remarks/>
		[System.Xml.Serialization.XmlAttributeAttribute(AttributeName="url", Form=System.Xml.Schema.XmlSchemaForm.Qualified)]
		public string Url;
        
		/// <remarks/>
		[System.Xml.Serialization.XmlAttributeAttribute(AttributeName="text", Form=System.Xml.Schema.XmlSchemaForm.Qualified)]
		public string Text;
        
		/// <remarks/>
		[System.Xml.Serialization.XmlAttributeAttribute(AttributeName="key", Form=System.Xml.Schema.XmlSchemaForm.Qualified)]
		public string Key;
        
		/// <remarks/>
		[System.Xml.Serialization.XmlAttributeAttribute(AttributeName="businessObject", Form=System.Xml.Schema.XmlSchemaForm.Qualified)]
		public string BusinessObject;
        
		/// <remarks/>
		[System.Xml.Serialization.XmlAttributeAttribute(AttributeName="businessKey", Form=System.Xml.Schema.XmlSchemaForm.Qualified)]
		public string BusinessKey;
        
		/// <remarks/>
		[System.Xml.Serialization.XmlAttributeAttribute(AttributeName="textKey", Form=System.Xml.Schema.XmlSchemaForm.Qualified)]
		public string TextKey;
		#endregion
	}
    
	/// <author>Hannes Foulds</author>
	/// <date>14 August 2006</date>
	/// <summary>
	/// The site map object for bread crumb navigation.
	/// </summary>
	[System.Xml.Serialization.XmlRootAttribute(ElementName="sitemap", IsNullable=false)]
	public class SiteMap 
	{
		/// <remarks/>
		[System.Xml.Serialization.XmlElementAttribute("page")]
		public Page[] Items;

		#region Serialize
		/// <summary>
		/// Serialize the object to a xml string.
		/// </summary>
		public string Serialize()
		{
			XmlSerializer serializer = new XmlSerializer(this.GetType());
			MemoryStream memoryStream = new MemoryStream();
			XmlTextWriter writer = new XmlTextWriter(memoryStream, Encoding.UTF8);
			writer.Formatting = Formatting.None;
			serializer.Serialize(writer, this);

			StreamReader reader = new StreamReader(memoryStream);
			memoryStream.Position = 0;
			string result = reader.ReadToEnd();
			writer.Close();

			return result;
		}
		#endregion

		#region Deserialize
		/// <summary>
		/// Deserialize the schema object from the XML string provided.
		/// </summary>
		/// <param name="xmlString">A string containing the XML for the schema object.</param>
		/// <returns>Returns the deserialized schema object.</returns>
		public static SiteMap Deserialize(string xmlString)
		{
			XmlSerializer serializer = new XmlSerializer(typeof(SiteMap));
			StringReader reader = new StringReader(xmlString);
			SiteMap siteMap = serializer.Deserialize(reader) as SiteMap;
			siteMap.SetParents(null, siteMap.Items);

			return siteMap;
		}
		#endregion

		#region Set Parents
		/// <summary>
		/// Recursively set the parent of page items.
		/// </summary>
		/// <param name="current">The parent page.</param>
		/// <param name="items">A collection of page items.</param>
		private void SetParents(Page current, Page[] items)
		{
			if (items != null)
			{
				foreach(Page page in items)
				{
					page.Parent = current;
					this.SetParents(page, page.Items);
				}
			}
		}
		#endregion
	}
}

#region Set Page Title
/// <summary>
/// Set the title of the page.
/// </summary>
/// <param name="pageTitle">The new title for the page.</param>
public void SetPageTitle(string pageTitle)
{
	TitleBarWebPart titleBar = this.FindTitleBar(this.Page);
	titleBar.HeaderTitle = pageTitle;
}
#endregion

#region Find Title Bar
/// <summary>
/// Find the title bar control of the page.
/// </summary>
/// <param name="control">The control to start the search at.</param>
/// <returns>Returns the first TitleBarWebPart control found.</returns>
private TitleBarWebPart FindTitleBar(Control control)
{
	TitleBarWebPart result = null;
	int counter = 0;

	while ( (counter < control.Controls.Count) && (result == null) )
	{
		Control currentControl = control.Controls[counter];
		if (currentControl.GetType() == typeof(Microsoft.SharePoint.WebPartPages.TitleBarWebPart))
		{
			return currentControl as TitleBarWebPart;
		}

		result = FindTitleBar(currentControl);
		counter++;
	}
	return result;
}
#endregion

-- create the full text index
sp_fulltext_database 'enable'
go

sp_fulltext_catalog 'search', 'create'
go

-- create index for the question table
sp_fulltext_table 'Question', 'create', 'search', 'PK_Question' 
go

sp_fulltext_column 'Question', 'Title', 'add'
go

sp_fulltext_column 'Question', 'Question', 'add'
go

sp_fulltext_table 'Question', 'activate'
go

-- perform a full index
sp_fulltext_catalog 'search', 'start_full'
go

use master

exec msdb..sp_delete_job @job_name = 'Start_Full on Alexandria.Search.'

declare @id BINARY(16)  
exec msdb..sp_add_job 	@job_name = 'Start_Full on Alexandria.Search.', 
			@description = 'Scheduled full-text full population for 
                                        full-text Catalog Search in database Alexandria. 
                                        This job was created by the full-text scheduling dialog or 
                                        full-text index wizard..',
			@enabled = 1, 
			@start_step_id = 1, 
			@notify_level_eventlog = 2, 
			@notify_level_email = 0, 
			@notify_level_netsend = 0, 
			@notify_level_page = 0, 
			@delete_level = 0, 
			@category_name = 'Full-Text', 
			@job_id = @id OUTPUT  select @id


exec msdb..sp_add_jobstep	@job_id = @id,
				@step_id = 1, 
				@cmdexec_success_code = 0, 
				@on_success_action = 1, 
				@on_success_step_id = 0, 
				@on_fail_action = 2, 
				@on_fail_step_id = 0, 
				@retry_attempts = 0, 
				@retry_interval = 0, 
				@os_run_priority = 0, 
				@flags = 0, 
				@step_name = 'Full-Text Indexing', 
				@subsystem = 'TSQL', 
				@command = 'use [Alexandria] exec sp_fulltext_catalog ''Search'', ''start_full''', 
				@database_name = 'master'

exec msdb..sp_add_jobserver	@job_id = @id, 
				@server_name = '(local)'

exec msdb..sp_add_jobschedule 	@job_id = @id, 
				@name = 'complete', 
				@enabled = 1, 
				@freq_type = 4, 
				@freq_interval = 1, 
				@freq_subday_type = 1, 
				@freq_subday_interval = 0, 
				@freq_relative_interval = 0, 
				@freq_recurrence_factor = 1, 
				@active_start_date = 20060713, 
				@active_end_date = 99991231, 
				@active_start_time = 120000, 
				@active_end_time = 235959

exec msdb.dbo.sp_update_job	@job_id = @id, 
				@automatic_post = 0 , 
				@owner_login_name = 'sa'

exec msdb..sp_help_job @job_id = @id, @job_aspect = N'job'
exec msdb..sp_help_jobstep @job_id = @id
exec msdb..sp_help_jobschedule @job_id = @id

#region Get Absolute Path
/// <summary>
/// Convert a relative path to an absolute path.
/// </summary>
/// <param name="relativePath">The path that should be converted,</param>
/// <returns>Returns the absolute path.</returns>
public static string GetAbsolutePath(string relativePath)
{
	Uri baseUrl = HttpContext.Current.Request.Url; 
	Uri absoluteUri = new Uri(baseUrl, relativePath); 

	return absoluteUri.ToString(); 
}
#endregion