using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class EN_MasterPage : System.Web.UI.MasterPage
{
    DBAccess.DBAccess ClSqlCmd;
    bool bool_inAdmin;
    bool bool_HideControls = false;
    UpperBanner UB_1;
    public void Page_Load(object sender, EventArgs e)
    {

        ClSqlCmd = new DBAccess.DBAccess(System.Configuration.ConfigurationSettings.AppSettings["SE_ConnectionString"]);

        ///////////////////////////////////////////////////////////////////////////

        if (Session["AdminID" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"]] == null || Session["AdminID" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"]].ToString() == "")  //Admin logged in
        {
            bool_inAdmin = false;

        }
        else
        {
            bool_inAdmin = true;
        }

        if (Session["HideControls"] == null || Session["HideControls"].ToString() == "")  //Show Controls
        {
            bool_HideControls = false;
        }
        else
        {
            bool_HideControls = true;
        }

        ///////////////////////////////////////////////////////////////////////////

        if (bool_inAdmin)
        {
            tr_Admin_Header.Visible = true;
            tr_Script_ContentControl.Visible = true;
        }
        else
        {
            tr_Admin_Header.Visible = false;
            tr_Script_ContentControl.Visible = false;
        }

        ////////////////////////////////////////////////////////////////////////////

        if (!Page.IsPostBack)
        {
            GetData();
        }
    }
    
    void GetData()
    {
        string strUserAgent = Request.UserAgent.ToString().ToLower();
        if (strUserAgent != null)
        {
            if (Request.Browser.IsMobileDevice == true || strUserAgent.Contains("iphone") ||
                strUserAgent.Contains("blackberry") || strUserAgent.Contains("mobile") ||
                strUserAgent.Contains("windows ce") || strUserAgent.Contains("opera mini") ||
                strUserAgent.Contains("palm"))
            {
                tbl_Main.Style["width"] = "";
                tbl_Main.Attributes["class"] = "Main_OuterContent";
            }
        }

        #region Set Logo

        string str_HTML_Logo = "";

        DataSet DS = ClSqlCmd.DataSetSel(@"
                                SELECT 
                                       [Title] 
                                FROM [dbo].[__StandardEngine_T_ModuleStyles]
                                where 
                                    [Module_ID]=" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"]);


        if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
        {
            if (DS.Tables[0].Rows[0]["Title"] != Convert.DBNull)
            {
                Head1.Title = DS.Tables[0].Rows[0]["Title"].ToString();
            }
        }


        #endregion


        if (bool_inAdmin)
        {
            tr_Published.Visible = false;
            tr_Edit.Visible = true;
        }
        else
        {
            tr_Published.Visible = true;
            tr_Edit.Visible = false;

            //////////////////////////////

            string str_HTML_Header = "";
            string str_HTML_Banner = "";
            string str_HTML_Content = "";
            string str_HTML_Footer = "";
            string str_HTML_Temp = "";
            string str_HTML_Final = "";




            str_HTML_Header = @"
                                    <tr>
                                        <td><--Header--></td>
                                    </tr>
                                ";

            str_HTML_Banner = @"
                                    <tr>
                                        <td>
                                            <table align=center border=0 cellpadding=0 cellspacing=0 style='width:100%'>
                                                <tr>
                                                    <td class='UpperBanner_LayoutStrip_Outer_ShadowOuter' align=center style='text-align:center'>
        
                                                        <div class='UpperBanner_LayoutStrip_Outer' style='text-align:center; width:100%;'>

                                                        <--Banner-->

                                                        </div>

                                                    </td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                ";

            str_HTML_Content = @"
                                    <tr>
                                        <td class='Content_LayoutStrip_Outer_ShadowOuter'>
            
                                        <div class='Content_LayoutStrip_Outer' style='text-align:center; width:100%;'>

                                            <--Content-->

                                        </div>
            
                                        </td>
                                    </tr>
                                ";

            str_HTML_Footer = @"
                                    <tr>
                                        <td><--Footer--></td>
                                    </tr>
                                ";


            //Main
            str_HTML_Final += @"<table border=0 cellpadding=0 cellspacing=0 width='100%' style='width:100%; height:100%; position:absolute; top: 0; bottom: 0; left: 0; right: 0;'>
                                <tr style='height:100%'>
                                    <td style='height:100%' valign=top class='Body_Background Main_VerticalAlign'>



                                    <table border=0 cellpadding=0 cellspacing=0 width='100%' style='width:100%;'>
                                        
                                        <--HeaderHTML-->
                                        <--BannerHTML-->
                                        <--ContentHTML-->
                                        <--FooterHTML-->
                                        
                                    </table>


                                    <script type='text/javascript'>

                                        $('div.element_Drag').css('opacity', 1);

                                        $('.element_Drag').css('cursor', '');

                                    </script>

                                    </td>
                                </tr>
                            </table>";



            /////////////////////////////////////////////////////////////////////////////////////////////
            //Get Header
            str_HTML_Temp=GetPublishData("9997", null, System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"]);
            if(str_HTML_Temp.Trim()!="")
            {
                str_HTML_Temp=str_HTML_Header.Replace("<--Header-->",str_HTML_Temp);
            }
            str_HTML_Final = str_HTML_Final.Replace("<--HeaderHTML-->", str_HTML_Temp);

            //Get Content
            str_HTML_Temp = GetPublishData("9999", Request.Params["ID"].Replace("'", ""), System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"]);
            if (str_HTML_Temp.Trim() != "")
            {
                str_HTML_Temp = str_HTML_Content.Replace("<--Content-->", str_HTML_Temp);
            }
            str_HTML_Final = str_HTML_Final.Replace("<--ContentHTML-->", str_HTML_Temp);

            //Get Content
            str_HTML_Temp = GetPublishData("9998", null, System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"]);
            if (str_HTML_Temp.Trim() != "")
            {
                str_HTML_Temp = str_HTML_Footer.Replace("<--Footer-->", str_HTML_Temp);
            }
            str_HTML_Final = str_HTML_Final.Replace("<--FooterHTML-->", str_HTML_Temp);


            UB_1 = new UpperBanner(Server, Request, bool_inAdmin, bool_HideControls);
            string str_UB_HTML = UB_1.getall();
            if (str_UB_HTML.Trim() != "" && str_UB_HTML!="-1")
            {
                str_UB_HTML = str_HTML_Banner.Replace("<--Banner-->", str_UB_HTML);
            }
            str_HTML_Final = str_HTML_Final.Replace("<--BannerHTML-->", str_UB_HTML.Trim() != "-1" ? str_UB_HTML : "");


            /////////////////////////////////////////////////////////////////////////////////////////////
            //Get First page ID
            string str_Group_Start_EditorPage_ID = ClSqlCmd.DataSetSel(@"select [dbo].[__StandardEngine_F_Group_FirstPage]( 
                                                                        [dbo].[__StandardEngine_F_EditorPage_Group_ID]( " + Request.Params["ID"].Replace("'", "") + @" ) 
                                                                                                            )").Tables[0].Rows[0][0].ToString();

            string str_EditorPage_ID = Request.Params["ID"];
            str_HTML_Final = str_HTML_Final
                                        .Replace("ID=" + str_EditorPage_ID + "' class='DarkLnk_Menu'",
                                                "ID=" + str_EditorPage_ID + "' class='DarkLnk_Curr_Menu'")
                                        .Replace("ID=" + str_EditorPage_ID + "' class='LightLnk_Menu'",
                                                "ID=" + str_EditorPage_ID + "' class='LightLnk_Curr_Menu'")
                                        .Replace("ID=" + str_Group_Start_EditorPage_ID + "' class='UpperMenu_Menu'",
                                                "ID=" + str_Group_Start_EditorPage_ID + "' class='UpperMenu_Curr_Menu'")
                                        .Replace("ID=" + str_Group_Start_EditorPage_ID + "' class='FooterMenu_Menu'",
                                                "ID=" + str_Group_Start_EditorPage_ID + "' class='FooterMenu_Curr_Menu'");
            td_Published.InnerHtml = str_HTML_Final;
            
            
        }

    }


    string GetPublishData(string _EditorPage_Type_ID, string _Parent_EditorPage_ID, string _str_Module_ID)
    {
        string str_PublishedHTML = "";

        DataSet DS_Publish = ClSqlCmd.DataSetSel(@" SELECT 
                                                            HTMLContent 
                                                        FROM dbo.__StandardEngine_T_EditorPages 
                                                        where 
                                                            EditorPage_Type_ID=" + _EditorPage_Type_ID
                                                        + (_Parent_EditorPage_ID != null ? (@" and Parent_EditorPage_ID=" + _Parent_EditorPage_ID) : "")
                                                        + (_str_Module_ID != null ? (@" and Module_ID=" + _str_Module_ID) : "")
                                            + @"    order by 
                                                        [Order] asc,
                                                        [EditorPage_ID] asc");

        if (DS_Publish.Tables.Count > 0 && DS_Publish.Tables[0].Rows.Count > 0)
        {
            foreach (DataRow DR in DS_Publish.Tables[0].Rows)
            {
                str_PublishedHTML += DR["HTMLContent"].ToString();
            }
        }

        return str_PublishedHTML;
    }

}