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"; }