public static int Add(Page page)
{
if (page != null)
page.Name = page.Name.Replace(" ", "");
Page tempPage = GetPage(page.Name, page.PortalID, page.LanguageID);
if (tempPage != null)
throw new Exception("Page name already exists, please change the page name");
return PageDataMapper.Add(page);
}
public static void Update(Page page)
{
if (page != null)
page.Name = page.Name.Replace(" ", "");
Page tempPage = GetPage(page.Name, page.PortalID, page.LanguageID);
if (tempPage != null && tempPage.ID != page.ID)
throw new Exception("Page name already exists, please change the page name");
PageDataMapper.Update(page);
}
internal static void FillFromReader(Page page, SqlDataReader reader)
{
int colIndex = 0;
int days = 0, seconds = 0;
colIndex = reader.GetOrdinal(CN_PAGE_CREATION_DAY);
if (!reader.IsDBNull(colIndex))
days = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_CREATION_SEC);
if (!reader.IsDBNull(colIndex))
seconds = reader.GetInt32(colIndex);
page.CreationDate = CMSCoreHelper.GetDateTime(days, seconds);
colIndex = reader.GetOrdinal(CN_PAGE_DESCRIPTION);
if (!reader.IsDBNull(colIndex))
page.Description = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_DETAILS);
if (!reader.IsDBNull(colIndex))
page.Details = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_ICON);
if (!reader.IsDBNull(colIndex))
page.Icon = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_ID);
if (!reader.IsDBNull(colIndex))
page.ID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_IS_DELETED);
if (!reader.IsDBNull(colIndex))
page.IsDeleted = reader.GetBoolean(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_KEYWORDS);
if (!reader.IsDBNull(colIndex))
page.KeyWords = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_LANGUAGE_ID);
if (!reader.IsDBNull(colIndex))
page.LanguageID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_NAME);
if (!reader.IsDBNull(colIndex))
page.Name = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_PORTAL_ID);
if (!reader.IsDBNull(colIndex))
page.PortalID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_SEO_NAME);
if (!reader.IsDBNull(colIndex))
page.SEOName = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_TYPE);
if (!reader.IsDBNull(colIndex))
page.PageType = (CMSEnums.PageType)reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_TITLE);
if (!reader.IsDBNull(colIndex))
page.Title = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_TEMPLATE_ID);
if (!reader.IsDBNull(colIndex))
page.TemplateID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_PAGE_CREATED_BY);
if (!reader.IsDBNull(colIndex))
page.CreatedBy = reader.GetInt32(colIndex);
}
internal static Page GetPage(List<Page> pages, SqlDataReader reader)
{
int colIndex = 0;
colIndex = reader.GetOrdinal(CN_PAGE_ID);
int value = reader.GetInt32(colIndex);
Page page = pages.Where(c => c.ID == value).FirstOrDefault();
if (page == null)
{
page = new Page();
pages.Add(page);
}
return page;
}
internal static Page GetPage(string Name, int PortalID, int LanguageID)
{
Page page = null;
using (SqlConnection sqlConnection = new SqlConnection(CMSCoreBase.CMSCoreConnectionString))
{
SqlCommand sqlCommand = new SqlCommand(SN_PAGE_GET_BY_NAME, sqlConnection);
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter sqlParameter = new SqlParameter(PN_PAGE_NAME, System.Data.SqlDbType.NVarChar);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = Name;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PAGE_PORTAL_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = PortalID;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_PAGE_LANGUAGE_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = LanguageID;
sqlCommand.Parameters.Add(sqlParameter);
sqlCommand.Connection.Open();
using (SqlDataReader reader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection))
{
while (reader.Read())
{
if (page == null)
page = new Page();
FillFromReader(page, reader);
}
reader.Close();
sqlCommand.Connection.Close();
}
}
return page;
}
public static string GetPageUrl(Page page)
{
return "~/" + GetPageFileName(page);
}
public static string GetPagePath(Page page)
{
return CMSContext.CurrentPath + GetPageFileName(page);
}
public static string GetPageFileName(Page page)
{
return page.Name + ".aspx";
}
