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

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

public partial class Admin_EditorPages : System.Web.UI.Page
{
    DBAccess.DBAccess DBAcc = new DBAccess.DBAccess(System.Configuration.ConfigurationSettings.AppSettings["SE_ConnectionString"]);
    private void Page_Load(object sender, System.EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            LoadDLL_Groups();
            load();
        }

    }

    protected void LoadDLL_Groups()
    {
        DataSet DS = DBAcc.DataSetSel(@"  SELECT 
                                            [Group_ID]
                                            ,[GroupName]
                                        FROM [dbo].[__StandardEngine_T_Groups]
                                        where 
                                            [Module_ID]=" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"] + @" 
                                        Order by 
                                            [GroupName] asc");

        ddl_Group_ID.DataSource = DS;
        ddl_Group_ID.DataTextField = "GroupName";
        ddl_Group_ID.DataValueField = "Group_ID";

        ddl_Group_ID.DataBind();
    }

    public void load()
    {
        DataSet DS_HomePage_Photos = DBAcc.DataSetSel(@"    SELECT 
                                                                dbo.__StandardEngine_T_EditorPages.[EditorPage_ID],
                                                                dbo.__StandardEngine_T_EditorPages.[PageName],
                                                                dbo.__StandardEngine_T_Groups.GroupName,
                                                                dbo.__StandardEngine_T_EditorPages.IsStartPage  
                                                            FROM    dbo.__StandardEngine_T_EditorPages INNER JOIN
                                                                    dbo.__StandardEngine_T_Groups ON dbo.__StandardEngine_T_EditorPages.Group_ID = dbo.__StandardEngine_T_Groups.Group_ID
                                                            where 
                                                                dbo.__StandardEngine_T_EditorPages.[EditorPage_Type_ID] is NULL and 
                                                                dbo.__StandardEngine_T_EditorPages.[Module_ID]=" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"] + @"
                                                            Order by 
                                                                dbo.__StandardEngine_T_EditorPages.[EditorPage_ID] asc"
                                                    );
        DataGrid1.DataSource = DS_HomePage_Photos;
        DataGrid1.DataBind();

        #region Adding the con firm delete
        if (this.DataGrid1.Controls.Count > 0 && this.DataGrid1.Controls[0].Controls.Count > 2)
        {
            for (int i = 1; i < this.DataGrid1.Controls[0].Controls.Count - 1; i++)
            {
                LinkButton lnkB = (LinkButton)this.DataGrid1.Controls[0].Controls[i].FindControl("Linkbutton3");
                lnkB.Attributes["onclick"] = "javascript:return confirm('Confirm data deletion');";
            }
        }
        #endregion
        if (DS_HomePage_Photos.Tables.Count > 0 && DS_HomePage_Photos.Tables[0].Rows.Count > 0)
        {
            lbl_msg_NoCats.Visible = false;
            DataGrid1.Visible = true;
        }
        else
        {
            lbl_msg_NoCats.Visible = true;
            DataGrid1.Visible = false;
        }
    }



    public void edit(string _str_ID)
    {
        DataSet dataSet1 = new DataSet();
        dataSet1 = DBAcc.DataSetSel(@"  SELECT 
                                            [EditorPage_ID],
                                            [PageName], 
                                            [Group_ID]
                                        FROM [dbo].[__StandardEngine_T_EditorPages]
                                        where 
                                            [EditorPage_ID]=" + _str_ID
                                    );

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

        hdn_Photo_ID.Value = _str_ID;

        if (dataSet1.Tables[0].Rows[0]["PageName"] != Convert.DBNull && dataSet1.Tables[0].Rows[0]["PageName"].ToString() != "")
            txt_PageName.Text = dataSet1.Tables[0].Rows[0]["PageName"].ToString();

        if (dataSet1.Tables[0].Rows[0]["Group_ID"] != Convert.DBNull && dataSet1.Tables[0].Rows[0]["Group_ID"].ToString() != "")
            ddl_Group_ID.SelectedValue = dataSet1.Tables[0].Rows[0]["Group_ID"].ToString();

    }

    public void newrow()
    {
        hdn_Photo_ID.Value = "0";
        txt_PageName.Text = "";
    }

    protected void Button1_Click1(object sender, EventArgs e)
    {
        #region validation
        bool valid = true;
        if (!valid)
        {
            return;
        }
        #endregion


        string EditorPage_ID_v_s = "";
        string PageName_v_s = txt_PageName.Text!=""? ("N'"+txt_PageName.Text.Replace("'","")+"'") : "NULL";
        string Group_ID_v_s = ddl_Group_ID.SelectedValue;
        string Module_ID_v_s = System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"];



        if (hdn_Photo_ID.Value == "0" || hdn_Photo_ID.Value == "")
        {
            EditorPage_ID_v_s = DBAcc.DataSetSel("select dbo.[__StandardEngine_F_MaxID_EditorPages]()+1 ").Tables[0].Rows[0][0].ToString();


            DBAcc.CommandExc(@" INSERT INTO [dbo].[__StandardEngine_T_EditorPages]
                                       ([EditorPage_ID]
                                        ,[PageName]
                                        ,[Group_ID]
                                        ,[Parent_EditorPage_ID]
                                        ,[Module_ID])
                                VALUES
                                       (" + EditorPage_ID_v_s + @",
                                       " + PageName_v_s + @",
                                       " + Group_ID_v_s + @",
                                       [dbo].[__StandardEngine_F_Group_FirstPage](" + Group_ID_v_s + @"),
                                       " + Module_ID_v_s + @")"
                            );
            
        }
        else
        {
            EditorPage_ID_v_s = hdn_Photo_ID.Value;

            DBAcc.CommandExc(@" update [dbo].[__StandardEngine_T_EditorPages]
                                set
                                    [PageName]=" + PageName_v_s + @",
                                    [Group_ID]=" + Group_ID_v_s + @",
                                    [Parent_EditorPage_ID]= [dbo].[__StandardEngine_F_Group_FirstPage](" + Group_ID_v_s + @") 
                                where 
                                    [EditorPage_ID]=" + EditorPage_ID_v_s
                            );
        }
        newrow();
        load();
        btn_Cancel.Visible = false;
        btn_NewCat.Visible = true;
        td_Fields.Visible = false;
        td_Grid.Visible = true;
    }
    protected void Button2_Click1(object sender, EventArgs e)
    {
        btn_NewCat.Visible = false;
        btn_Cancel.Visible = true;
        td_Fields.Visible = true;
        td_Grid.Visible = false;

        newrow();
    }
    protected void DataGrid1_ItemCommand1(object source, DataGridCommandEventArgs e)
    {
        int int_Order;
        DataSet DS_Bnrs = new DataSet();
        switch (e.CommandName)
        {
            case "Edit":
                hdn_rowindex.Value = e.Item.ItemIndex.ToString().Trim();
                hdn_Photo_ID.Value = e.CommandArgument.ToString();

                btn_NewCat.Visible = false;
                btn_Cancel.Visible = true;
                td_Fields.Visible = true;
                td_Grid.Visible = false;

                edit(e.CommandArgument.ToString());
                break;
            case "Delete":
                f_Delete_EditorPage(e.CommandArgument.ToString());
                load();
                break;

        }
    }
    protected void Button3_Click1(object sender, EventArgs e)
    {

    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        btn_NewCat.Visible = true;
        btn_Cancel.Visible = false;
        td_Fields.Visible = false;
        td_Grid.Visible = true;
    }
    protected void category_id_SelectedIndexChanged(object sender, EventArgs e)
    {
        load();
    }

    protected void f_Delete_EditorPage(string str_EditorPage_ID)
    {
        //Delete children
        DataSet DS = DBAcc.DataSetSel(@"    SELECT 
                                                [EditorPage_ID]
                                            FROM [dbo].[__StandardEngine_T_EditorPages]
                                            where 
                                                [Parent_EditorPage_ID]="+str_EditorPage_ID);
        if(DS.Tables.Count>0 && DS.Tables[0].Rows.Count>0)   //Has children
        {
            foreach(DataRow DR in DS.Tables[0].Rows)
            {
                f_Delete_EditorPage(DR["EditorPage_ID"].ToString());
            }
        }

        //Delete current editop page

        DBAcc.CommandExc(@" delete 
                            FROM [dbo].[__StandardEngine_T_Link]
                            where 
                                [EditorPage_ID]=" + str_EditorPage_ID);

        DBAcc.CommandExc(@" delete 
                            FROM [dbo].[__StandardEngine_T_Photos]
                            where 
                                [EditorPage_ID]=" + str_EditorPage_ID);

        DBAcc.CommandExc(@" delete 
                            FROM [dbo].[__StandardEngine_T_Texts]
                            where 
                                [EditorPage_ID]=" + str_EditorPage_ID);

        DBAcc.CommandExc(@" delete 
                            FROM [dbo].[__StandardEngine_T_Banners]
                            where 
                                [EditorPage_ID]=" + str_EditorPage_ID);

        DBAcc.CommandExc(@" delete 
                            FROM [dbo].[__StandardEngine_T_BorderMode]
                            where 
                                [EditorPage_ID]=" + str_EditorPage_ID);


        DBAcc.CommandExc(@" delete 
                            FROM [dbo].[__StandardEngine_T_EditorPages]
                            where 
                                [EditorPage_ID]="+str_EditorPage_ID);
    }
}