namespace ASPNET.StarterKit.Communities {

    using System;
    using System.Data;
    using System.Data.SqlClient;
    using System.Web;
    using System.Collections;
    using ASPNET.StarterKit.Communities;


    //*********************************************************************
    //
    // NamedPageUtility Class
    //
    // Contains static methods for working with Named Pages.
    //
    //*********************************************************************

    public class NamedPageUtility {


        //*********************************************************************
        //
        // GetPageInfoFromNamedPage Method
        //
        // Returns a PageInfo object from a file name of a named page. 
        //
        //*********************************************************************

        public static PageInfo GetPageInfoFromNamedPage(string requestFile) {
            NamedPageCollection colNamedPages = GetAllNamedPages();
            return colNamedPages[requestFile];
        }

        //*********************************************************************
        //
        // GetAllNamedPages Method
        //
        // Returns all list of all named pages (this list is community
        // independent).. 
        //
        //*********************************************************************

        public static NamedPageCollection GetAllNamedPages() {
            HttpContext Context = HttpContext.Current;
            NamedPageCollection colNamedPages = (NamedPageCollection)Context.Cache[ "NamedPages" ];
            if (colNamedPages == null) {
                colNamedPages = GetAllNamedPagesFromDB();
                Context.Cache[ "NamedPages" ] = colNamedPages;
            }
            return colNamedPages;
        }


        //*********************************************************************
        //
        // GetAllNamedPagesFromDB Method
        //
        // This method goes to the database to get the list
        // of named pages. 
        //
        //*********************************************************************

        public static NamedPageCollection GetAllNamedPagesFromDB() {
            NamedPageCollection colNamedPages = new NamedPageCollection();
            SqlConnection conPortal = new SqlConnection(CommunityGlobals.ConnectionString);
            SqlCommand cmdGet = new SqlCommand( "Community_NamedPagesGetNamedPages", conPortal );
            cmdGet.CommandType = CommandType.StoredProcedure;
            conPortal.Open();
            SqlDataReader dr = cmdGet.ExecuteReader();
            while (dr.Read())
                colNamedPages.Add( (string)dr["NamedPage_path"], PopulateNamedPageFromSqlDataReader(dr));
            conPortal.Close();
            return colNamedPages;
        }


        //*********************************************************************
        //
        // PopulateNamedPageFromSqlDataReader Method
        //
        // Creates a PageInfo object from a SqlDataReader. 
        //
        //*********************************************************************

        private static PageInfo PopulateNamedPageFromSqlDataReader(SqlDataReader dr) {
            return new PageInfo
            (
                (int)dr[ "namedPage_id" ],               // Page ID
                (string)dr[ "namedPage_name" ],          // Page Name
                -1,                                      // Page Parent ID
                -1,                                      // Page Type
                (string)dr[ "namedPage_title" ],         // Page Title
                (string)dr[ "namedPage_description" ],   // Page Description
                String.Empty,                            // Page Meta Desc
                String.Empty,                            // Page Meta Keys
                (string)dr[ "namedPage_pageContent" ]    // Page Content
            );
        }


    }
}