Gecko [ eib-egypt.com ]

Name	Size	Permission
CLEditor1_4_3	[ DIR ]	drwxrwxrwx
JS	[ DIR ]	drwxrwxrwx
Pics	[ DIR ]	drwxrwxrwx
ckeditor	[ DIR ]	drwxrwxrwx
colorpickersliders	[ DIR ]	drwxrwxrwx
AdminTopBanner.ascx	121 B	-rw-rw-rw-
AdminTopBanner.ascx.cs	425 B	-rw-rw-rw-
Admin_MasterPage.master	8.1 KB	-rw-rw-rw-
Admin_MasterPage.master.cs	3.5 KB	-rw-rw-rw-
Admin_MasterPage_Action.master	844 B	-rw-rw-rw-
Admin_MasterPage_Action.master...	1.44 KB	-rw-rw-rw-
Admin_MasterPage_POP.master	976 B	-rw-rw-rw-
Admin_MasterPage_POP.master.cs	1.44 KB	-rw-rw-rw-
Admin_StyleSheet.css	2.94 KB	-rw-rw-rw-
Background-Style.aspx	5.78 KB	-rw-rw-rw-
Background-Style.aspx.cs	16.13 KB	-rw-rw-rw-
Border-Style.aspx	44.13 KB	-rw-rw-rw-
Border-Style.aspx.cs	21.86 KB	-rw-rw-rw-
BorderOnly-Style.aspx	39.69 KB	-rw-rw-rw-
BorderOnly-Style.aspx.cs	20.83 KB	-rw-rw-rw-
Default.aspx	551 B	-rw-rw-rw-
Default.aspx.cs	2.25 KB	-rw-rw-rw-
EditorPage.aspx	357.07 KB	-rw-rw-rw-
EditorPage.aspx.cs	158.4 KB	-rw-rw-rw-
EditorPage_Delete.aspx	1.85 KB	-rw-rw-rw-
EditorPage_Delete.aspx.cs	2.88 KB	-rw-rw-rw-
EditorPage_Update_Order.aspx	397 B	-rw-rw-rw-
EditorPage_Update_Order.aspx.c...	5.18 KB	-rw-rw-rw-
EditorPages.aspx	6.79 KB	-rw-rw-rw-
EditorPages.aspx.cs	10.64 KB	-rw-rw-rw-
Fonts.aspx	8.65 KB	-rw-rw-rw-
Fonts.aspx.cs	10.69 KB	-rw-rw-rw-
Groups_Hidden.aspx	2.36 KB	-rw-rw-rw-
Groups_Hidden.aspx.cs	3.15 KB	-rw-rw-rw-
Groups_New.aspx	3.45 KB	-rw-rw-rw-
Groups_New.aspx.cs	11.17 KB	-rw-rw-rw-
Groups_Update.aspx	4.47 KB	-rw-rw-rw-
Groups_Update.aspx.cs	13.53 KB	-rw-rw-rw-
Groups_Update_Hide.aspx	387 B	-rw-rw-rw-
Groups_Update_Hide.aspx.cs	1.8 KB	-rw-rw-rw-
Groups_Update_Order.aspx	389 B	-rw-rw-rw-
Groups_Update_Order.aspx.cs	4.77 KB	-rw-rw-rw-
HeaderFooterNew.aspx	1.12 KB	-rw-rw-rw-
HeaderFooterNew.aspx.cs	283 B	-rw-rw-rw-
Help.aspx	10.91 KB	-rw-rw-rw-
Help.aspx.cs	262 B	-rw-rw-rw-
InitiateModule.aspx	379 B	-rw-rw-rw-
InitiateModule.aspx.cs	15.9 KB	-rw-rw-rw-
Link-Style.aspx	115.94 KB	-rw-rw-rw-
Link-Style.aspx.cs	72.5 KB	-rw-rw-rw-
Login.aspx	2.35 KB	-rw-rw-rw-
Login.aspx.cs	4.55 KB	-rw-rw-rw-
Logos.aspx	5.34 KB	-rw-rw-rw-
Logos.aspx.cs	14.08 KB	-rw-rw-rw-
Module-Settings-Common.aspx	2.94 KB	-rw-rw-rw-
Module-Settings-Common.aspx.cs	5.57 KB	-rw-rw-rw-
Module-Settings.aspx	6.53 KB	-rw-rw-rw-
Module-Settings.aspx.cs	5.49 KB	-rw-rw-rw-
Photos-POP.aspx	6 KB	-rw-rw-rw-
Photos-POP.aspx.cs	12.97 KB	-rw-rw-rw-
Photos.aspx	5.9 KB	-rw-rw-rw-
Photos.aspx.cs	12.81 KB	-rw-rw-rw-
StartGroup.aspx	1.63 KB	-rw-rw-rw-
StartGroup.aspx.cs	4.67 KB	-rw-rw-rw-
Strip-Style.aspx	89.8 KB	-rw-rw-rw-
Strip-Style.aspx.cs	49.81 KB	-rw-rw-rw-
Text-Border-Style.aspx	54.86 KB	-rw-rw-rw-
Text-Border-Style.aspx.cs	31.23 KB	-rw-rw-rw-
Text-Style.aspx	8.67 KB	-rw-rw-rw-
Text-Style.aspx.cs	13.67 KB	-rw-rw-rw-
Text.aspx	3.06 KB	-rw-rw-rw-
Text.aspx.cs	3.71 KB	-rw-rw-rw-
UpperBanners.aspx	15.72 KB	-rw-rw-rw-
UpperBanners.aspx.cs	29.14 KB	-rw-rw-rw-
UpperBanners_InsertBlank.aspx	399 B	-rw-rw-rw-
UpperBanners_InsertBlank.aspx....	1.65 KB	-rw-rw-rw-
UpperBanners_Set_Effect.aspx	397 B	-rw-rw-rw-
UpperBanners_Set_Effect.aspx.c...	1.02 KB	-rw-rw-rw-
WUC_RightMenu.ascx	5.1 KB	-rw-rw-rw-
WUC_RightMenu.ascx.cs	8.99 KB	-rw-rw-rw-
try.aspx	15.38 KB	-rw-rw-rw-
try.aspx.cs	545 B	-rw-rw-rw-
try.htm	8.81 KB	-rw-rw-rw-

Code Editor : EditorPages.aspx.cs

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

${this.title}

Code Editor : EditorPages.aspx.cs