/// <summary>
/// Fetches all content pages from database by specified id or language.
/// </summary>
/// <param name="id">Represents content page id.</param>
/// <param name="languageID">The language ID.</param>
/// <param name="sortColumn">The sort column.</param>
/// <returns>Array of content pages.</returns>
public static ContentPage[] FetchContentPages(object id, object languageID, eSortColumn sortColumn)
{
string cacheKey = String.Format("ContentPage_FetchContentPages_{0}_{1}_{2}", id, languageID, sortColumn);
if (HttpContext.Current != null && HttpContext.Current.Cache[cacheKey] != null)
{
return HttpContext.Current.Cache[cacheKey] as ContentPage[];
}
var lPages = new List<ContentPage>(5);
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader =
SqlHelper.ExecuteReader(conn,
"FetchContentPages", id, languageID, sortColumn);
while (reader.Read())
{
var contentPage = new ContentPage();
contentPage.id = (int) reader["ID"];
contentPage.title = (string) reader["Title"];
contentPage.linkText = (string)reader["LinkText"];
contentPage.content = (string) reader["Content"];
contentPage.headerPosition = reader["HeaderPosition"] == DBNull.Value
? null
: (int?) reader["HeaderPosition"];
contentPage.footerPosition = reader["FooterPosition"] == DBNull.Value
? null
: (int?) reader["FooterPosition"];
contentPage.visibleFor = (eVisibility) (int) reader["VisibleFor"];
contentPage.url = reader["URL"] == DBNull.Value ? null : (string) reader["URL"];
contentPage.metaDescription = (string) reader["MetaDescription"];
contentPage.metaKeyword = (string) reader["MetaKeyword"];
contentPage.languageID = (int) reader["LanguageID"];
contentPage.urlRewrite = reader["UrlRewrite"] as string;
lPages.Add(contentPage);
}
}
ContentPage[] pages = lPages.ToArray();
if (HttpContext.Current != null)
{
HttpContext.Current.Cache.Insert(cacheKey, pages, null, DateTime.Now.AddMinutes(30),
Cache.NoSlidingExpiration, CacheItemPriority.NotRemovable, null);
}
return pages;
}
/// <summary>
/// Creates the specified title.
/// </summary>
/// <param name="title">The title.</param>
/// <param name="content">The content.</param>
/// <param name="headerPosition">The header position.</param>
/// <param name="footerPosition">The footer position.</param>
/// <param name="visibleFor">The visible for.</param>
/// <param name="url">The URL.</param>
/// <param name="metaDescription">The meta description.</param>
/// <param name="metaKeyword">The meta keyword.</param>
/// <param name="languageID">The language ID.</param>
/// <param name="urlRewrite">The URL rewrite.</param>
/// <returns></returns>
public static ContentPage Create(string title, string linkText, string content, int? headerPosition,
int? footerPosition, eVisibility visibleFor,
string url, string metaDescription, string metaKeyword, int languageID,
string urlRewrite)
{
var cp = new ContentPage
{
title = title,
linkText = linkText,
content = content,
headerPosition = headerPosition,
footerPosition = footerPosition,
visibleFor = visibleFor,
url = url,
metaDescription = metaDescription,
metaKeyword = metaKeyword,
languageID = languageID,
urlRewrite = urlRewrite
};
return cp;
}
