using System;
using System.Data;
using System.Collections.Generic;

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class AR_Default : System.Web.UI.Page
{
    DBAccess.DBAccess ClSqlCmd = new DBAccess.DBAccess(System.Configuration.ConfigurationSettings.AppSettings["SE_ConnectionString"]);

    public bool bool_inAdmin = false;
    public string str_BannerLocation_ID = "1";

    public void Page_Load(object sender, EventArgs e)
    {
        ////////////////////////////////////////////////////////////////////////////
        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 (!Page.IsPostBack)
        {
            getall();
        }
    }

    void getall()
    {
        if (Request.Params["ID"] != null && Request.Params["ID"] != "")
        {
            Response.Redirect("page.aspx?ID=" + Request.Params["ID"]);
        }
        else
        {
            DataSet DS = ClSqlCmd.DataSetSel(@"
                                SELECT     
                                    dbo.__StandardEngine_T_EditorPages.EditorPage_ID 
                                FROM  dbo.__StandardEngine_T_Groups INNER JOIN
                                      dbo.__StandardEngine_T_ModuleStyles ON dbo.__StandardEngine_T_Groups.Group_ID = dbo.__StandardEngine_T_ModuleStyles.Start_Group_ID INNER JOIN
                                      dbo.__StandardEngine_T_EditorPages ON dbo.__StandardEngine_T_Groups.Group_ID = dbo.__StandardEngine_T_EditorPages.Group_ID
                                where 
                                    dbo.__StandardEngine_T_Groups.Active=1 and 
                                    dbo.__StandardEngine_T_EditorPages.[IsStartPage]=1 and 
                                    dbo.__StandardEngine_T_ModuleStyles.Module_ID=" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"] + @" 
                                Order by 
                                    dbo.__StandardEngine_T_Groups.[Order] asc");

            if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0 && DS.Tables[0].Rows[0][0] != Convert.DBNull)
            {
                Response.Redirect("page.aspx?ID=" + DS.Tables[0].Rows[0][0].ToString());
            }
            else
            {
                Response.Redirect("../Admin/InitiateModule.aspx?retP="+Server.UrlEncode(Request.Url.ToString()));
            }
        }

    }



}