public override Page SelectPage(Guid id)
{
var page = new Page();
using (var conn = this.CreateConnection())
{
if (conn.HasConnection)
{
var sqlQuery = string.Format("SELECT PageID, Title, Description, PageContent, DateCreated, DateModified, Keywords, IsPublished, IsFrontPage, Parent, ShowInList, Slug, IsDeleted FROM {0}Pages WHERE BlogID = {1}blogid AND PageID = {1}id", this.tablePrefix, this.parmPrefix);
using (var cmd = conn.CreateTextCommand(sqlQuery))
{
cmd.Parameters.Add(conn.CreateParameter(FormatParamName("blogid"), Blog.CurrentInstance.Id.ToString()));
cmd.Parameters.Add(conn.CreateParameter(FormatParamName("id"), id.ToString()));
using (var rdr = cmd.ExecuteReader())
{
if (rdr.Read())
{
page.Id = rdr.GetGuid(0);
page.Title = rdr.IsDBNull(1) ? String.Empty : rdr.GetString(1);
page.Content = rdr.IsDBNull(3) ? String.Empty : rdr.GetString(3);
page.Description = rdr.IsDBNull(2) ? String.Empty : rdr.GetString(2);
if (!rdr.IsDBNull(4))
{
page.DateCreated = rdr.GetDateTime(4);
}
if (!rdr.IsDBNull(5))
{
page.DateModified = rdr.GetDateTime(5);
}
if (!rdr.IsDBNull(6))
{
page.Keywords = rdr.GetString(6);
}
if (!rdr.IsDBNull(7))
{
page.IsPublished = rdr.GetBoolean(7);
}
if (!rdr.IsDBNull(8))
{
page.IsFrontPage = rdr.GetBoolean(8);
}
if (!rdr.IsDBNull(9))
{
page.Parent = rdr.GetGuid(9);
}
if (!rdr.IsDBNull(10))
{
page.ShowInList = rdr.GetBoolean(10);
}
if (!rdr.IsDBNull(11))
{
page.Slug = rdr.GetString(11);
}
if (!rdr.IsDBNull(12))
{
page.IsDeleted = rdr.GetBoolean(12);
}
}
}
}
}
}
return page;
}