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 : UpperBanners.aspx.cs

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

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Drawing;
using System.Drawing.Drawing2D;
using System.Drawing.Imaging;
using System.IO;

public partial class Admin_UpperBanners : System.Web.UI.Page
{
    public double dbl_HeightPerc;
    DBAccess.DBAccess DBAcc = new DBAccess.DBAccess(System.Configuration.ConfigurationSettings.AppSettings["SE_ConnectionString"]);
    private void Page_Load(object sender, System.EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            
            btn_SetBlank.Attributes["onclick"] = "javascript:return confirm('Confirm data deletion');";
            btn_SetParent.Attributes["onclick"] = "javascript:return confirm('Confirm data deletion');";

#region Delete block if exists
            DBAcc.CommandExc(@" Delete FROM [dbo].[__StandardEngine_T_Banners] 
                                        where 
                                            Banner_FileName is NULL and 
                                            [EditorPage_ID]=" + Request.Params["EPID"].Replace("'", ""));
            #endregion

load();
        }

}

private Size NewthumbSize(int currentwidth, int currentheight, int MaxWH)
    {
        //Calculate the Size of the New image  
        Double tempMultiplier;
        Size NewSize = new Size();
        if (currentheight > currentwidth) // portrait  
        {
            if (currentheight > MaxWH)
            {
                NewSize = new Size(Convert.ToInt32(currentwidth * MaxWH / currentheight), Convert.ToInt32(currentheight * MaxWH / currentheight));
            }
            else
            {
                NewSize = new Size(Convert.ToInt32(currentwidth), Convert.ToInt32(currentheight));
            }
        }
        else
        {
            if (currentwidth > MaxWH)
            {
                NewSize = new Size(Convert.ToInt32(currentwidth * MaxWH / currentwidth), Convert.ToInt32(currentheight * MaxWH / currentwidth));
            }
            else
            {
                NewSize = new Size(Convert.ToInt32(currentwidth), Convert.ToInt32(currentheight));
            }
        }

return NewSize;
    }
    private string ImgRes_Save(string filepath, string id, int MaxWH)
    {
        System.Drawing.Image g = System.Drawing.Image.FromFile(filepath);
        dbl_HeightPerc = (g.Height * 100 / g.Width);
        ImageFormat thisFormat = g.RawFormat;
        Size thumbSize = new Size();
        thumbSize = NewthumbSize(g.Width, g.Height, MaxWH);

//create a new Bitmap the size of the new image
        Bitmap imgOutput = new Bitmap(thumbSize.Width, thumbSize.Height);
        //create a new graphic from the Bitmap
        Graphics graphic = Graphics.FromImage((System.Drawing.Image)imgOutput);
        graphic.SmoothingMode = SmoothingMode.HighQuality;
        graphic.InterpolationMode = InterpolationMode.HighQualityBicubic;
        graphic.PixelOffsetMode = PixelOffsetMode.HighQuality;
        //draw the newly resized image
        graphic.DrawImage(g, 0, 0, thumbSize.Width, thumbSize.Height);

System.IO.FileStream fs = new FileStream(Request.MapPath("") + "\\..\\ar\\UpperBanner_Photos\\images\\" + id.ToString() + "_" + MaxWH.ToString() + filepath.Substring(filepath.LastIndexOf(".")), FileMode.OpenOrCreate);
        //imgOutput.Save(Response.OutputStream, thisFormat); //output to the user  
        imgOutput.Save(fs, thisFormat); //output to the user

//tidy up  
        //dispose and free up the resources
        graphic.Dispose();
        g.Dispose();
        imgOutput.Dispose();
        fs.Dispose();
        g = null;
        return id.ToString() + "_" + MaxWH.ToString() + filepath.Substring(filepath.LastIndexOf("."));

}

public void load()
    {

#region Get UpperBanner Mode
        DataSet DS = DBAcc.DataSetSel(@"    SELECT 
                                                [EditorPage_ID]
                                                ,[UpperBanner_Style]
                                                ,[UpperBanner_Effect] 
                                                ,[UpperBanner_Navigation] 
                                                ,[UpperBanner_Thumbnails] 
                                                ,[UpperBanner_Time] 
                                                ,[UpperBanner_TransPeriod] 
                                            FROM [dbo].[__StandardEngine_T_EditorPages]
                                            where [EditorPage_ID]=" + Request.Params["EPID"].Replace("'", ""));
        if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
        {
            if (DS.Tables[0].Rows[0]["UpperBanner_Style"] != Convert.DBNull)
            {
                rbl_UpperBanner_Style.SelectedValue = DS.Tables[0].Rows[0]["UpperBanner_Style"].ToString();
            }
            //else
            //{
            //    rbl_UpperBanner_Style.SelectedValue = "1";
            //}

if (DS.Tables[0].Rows[0]["UpperBanner_Effect"] != Convert.DBNull)
            {
                ddl_UpperBanner_Effect.SelectedValue = DS.Tables[0].Rows[0]["UpperBanner_Effect"].ToString();
            }

if (DS.Tables[0].Rows[0]["UpperBanner_Navigation"] != Convert.DBNull)
            {
                ddl_UpperBanner_Navigation.SelectedValue = DS.Tables[0].Rows[0]["UpperBanner_Navigation"].ToString();
            }

if (DS.Tables[0].Rows[0]["UpperBanner_Thumbnails"] != Convert.DBNull)
            {
                ddl_UpperBanner_Thumbnails.SelectedValue = DS.Tables[0].Rows[0]["UpperBanner_Thumbnails"].ToString();
            }

if (DS.Tables[0].Rows[0]["UpperBanner_Time"] != Convert.DBNull)
            {
                ddl_UpperBanner_Time.SelectedValue = DS.Tables[0].Rows[0]["UpperBanner_Time"].ToString();
            }

if (DS.Tables[0].Rows[0]["UpperBanner_TransPeriod"] != Convert.DBNull)
            {
                ddl_UpperBanner_TransPeriod.SelectedValue = DS.Tables[0].Rows[0]["UpperBanner_TransPeriod"].ToString();
            }
        }
        #endregion

DataSet DS_HomePage_Photos = DBAcc.DataSetSel(@"SELECT 
                                                            [Banner_ID]
                                                            ,[Banner_URL]
                                                            ,[Banner_FileName]
                                                        FROM [dbo].[__StandardEngine_T_Banners]
                                                        where 
                                                            [Banner_FileName] is not NULL and 
                                                            [EditorPage_ID]=" + Request.Params["EPID"].Replace("'","") + @"
                                                        Order by 
                                                            [Order] asc,
                                                            [Banner_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_HomePage_Photo_ID)
    {
        DataSet dataSet1 = new DataSet();
        dataSet1 = DBAcc.DataSetSel(@"  SELECT 
                                            [Banner_ID]
                                            ,[Banner_URL]
                                            ,[Banner_FileName]
                                            ,[Banner_Target] 
                                        FROM [dbo].[__StandardEngine_T_Banners]
                                        where 
                                            [Banner_ID]= " + _str_HomePage_Photo_ID
                                    );

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

hdn_Photo_ID.Value = _str_HomePage_Photo_ID;

if (dataSet1.Tables[0].Rows[0]["Banner_URL"] != Convert.DBNull)
            txt_Banner_URL.Text = dataSet1.Tables[0].Rows[0]["Banner_URL"].ToString();
        if (dataSet1.Tables[0].Rows[0]["Banner_Target"] != Convert.DBNull)
            ddl_Banner_Target.SelectedValue = dataSet1.Tables[0].Rows[0]["Banner_Target"].ToString();
        if (dataSet1.Tables[0].Rows[0]["Banner_FileName"] != Convert.DBNull && dataSet1.Tables[0].Rows[0]["Banner_FileName"].ToString() != "")
        {
            hdn_passed_Photo_Filename.Value = dataSet1.Tables[0].Rows[0]["Banner_FileName"].ToString().Trim();
            img_Photo_Filename.ImageUrl = "../ar/UpperBanner_Photos/images/" + dataSet1.Tables[0].Rows[0]["Banner_FileName"].ToString().Trim();
            img_Photo_Filename.Visible = true;
        }
        else
        {
            img_Photo_Filename.Visible = false;
        }

RequiredFieldValidator2.Enabled = false;
    }

public void newrow()
    {
        hdn_Photo_ID.Value = "0";
        txt_Banner_URL.Text = "";
        ddl_Banner_Target.SelectedIndex = -1;
        hdn_passed_Photo_Filename.Value = "";

RequiredFieldValidator2.Enabled = true;
    }

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

string Banner_ID_v_s = "";
        //Order_v_s = Order_v_s == "" ? "1" : Order_v_s;
        string Banner_FileName_v_s = "";
        string Banner_URL_v_s = txt_Banner_URL.Text == "" ? "NULL" : "N'" + txt_Banner_URL.Text.Replace("'", "''") + "'";
        string BannerLocation_ID_v_s = (Request.Params["LocID"] != null && Request.Params["LocID"] != "") ? Request.Params["LocID"] : "NULL";
        string Banner_Target_v_s = "N'" + ddl_Banner_Target.SelectedValue + "'";
        string Module_ID_v_s = System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"];
        string EditorPage_ID_v_s = Request.Params["EPID"].Replace("'", "");
        string Order_v_s = DBAcc.DataSetSel(@"    SELECT dbo.[__StandardEngine_F_MaxOrder_Banners](" + Request.Params["EPID"].Replace("'", "") + ")+1").Tables[0].Rows[0][0].ToString();

int int_BannerWidth = 0;
        if (rbl_UpperBanner_Style.SelectedValue == "20")
        {
            int_BannerWidth=1600;
        }
        else
        {
            string str_BannerWidth = DBAcc.DataSetSel(@"SELECT [ContentWidth] FROM [dbo].[__StandardEngine_T_ModuleStyles] where [Module_ID]=" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"]).Tables[0].Rows[0][0].ToString();
            int_BannerWidth = str_BannerWidth != "" ? Convert.ToInt32(str_BannerWidth.Replace("px", "")) : 1000;
        }

dbl_HeightPerc = 100;
        if (hdn_Photo_ID.Value == "0" || hdn_Photo_ID.Value == "")
        {
            Banner_ID_v_s = DBAcc.DataSetSel("select dbo.[__StandardEngine_F_MaxID_Banners]()+1 ").Tables[0].Rows[0][0].ToString();

#region Uploading the picfile
            
            if (fil_Photo_Filename.Value != "")
            {
                string str_Temp = "";
                Banner_FileName_v_s = Banner_ID_v_s + "_" + fil_Photo_Filename.PostedFile.FileName.Substring(fil_Photo_Filename.PostedFile.FileName.LastIndexOf("."));
                str_Temp = Banner_FileName_v_s;
                fil_Photo_Filename.PostedFile.SaveAs(Request.MapPath("") + "\\..\\ar\\UpperBanner_Photos\\images\\" + Banner_FileName_v_s);
                Banner_FileName_v_s = "N'" + ImgRes_Save(Request.MapPath("") + "\\..\\ar\\UpperBanner_Photos\\images\\" + Banner_FileName_v_s, Banner_ID_v_s, int_BannerWidth) + "'";
                System.IO.File.Delete(Request.MapPath("") + "\\..\\ar\\UpperBanner_Photos\\images\\" + str_Temp);
            }
            else
            {
                Banner_FileName_v_s = "NULL";
            }
            #endregion

DBAcc.CommandExc(@" INSERT INTO [dbo].[__StandardEngine_T_Banners]
                                       ([Banner_ID]
                                        ,[Banner_URL]
                                        ,[BannerLocation_ID]
                                        ,[Banner_FileName]
                                        ,[EditorPage_ID]
                                        ,[Banner_Target]
                                        ,[Order]
                                        ,[WidthPerc]
                                        ,[HeightPerc])
                                VALUES
                                       (" + Banner_ID_v_s + @",
                                       " + Banner_URL_v_s + @",
                                       " + BannerLocation_ID_v_s + @",
                                       " + Banner_FileName_v_s + @",
                                       " + EditorPage_ID_v_s + @",
                                       " + Banner_Target_v_s + @",
                                       " + Order_v_s + @",
                                            N'100%' ,
                                       " + "N'"+dbl_HeightPerc.ToString()+ "%' )"
                            );

}
        else
        {
            Banner_ID_v_s = hdn_Photo_ID.Value.Replace("'", "");
            #region Uploading the picfile
            if (fil_Photo_Filename.Value != "")
            {
                if (hdn_passed_Photo_Filename.Value != "")
                {
                    try
                    {
                        System.IO.File.Delete(Request.MapPath("") + "\\..\\ar\\UpperBanner_Photos\\images\\" + hdn_passed_Photo_Filename.Value);
                    }
                    catch
                    {
                    }
                }
                string str_Temp = "";
                Banner_FileName_v_s = hdn_Photo_ID.Value.Trim() + "_" + fil_Photo_Filename.PostedFile.FileName.Substring(fil_Photo_Filename.PostedFile.FileName.LastIndexOf("."));
                str_Temp = Banner_FileName_v_s;
                fil_Photo_Filename.PostedFile.SaveAs(Request.MapPath("") + "\\..\\ar\\UpperBanner_Photos\\images\\" + Banner_FileName_v_s);
                Banner_FileName_v_s = "N'" + ImgRes_Save(Request.MapPath("") + "\\..\\ar\\UpperBanner_Photos\\images\\" + Banner_FileName_v_s, Banner_ID_v_s, int_BannerWidth) + "'";
                System.IO.File.Delete(Request.MapPath("") + "\\..\\ar\\UpperBanner_Photos\\images\\" + str_Temp);
            }
            else if (hdn_passed_Photo_Filename.Value != "")
            {
                Banner_FileName_v_s = hdn_passed_Photo_Filename.Value != "" ? "N'" + hdn_passed_Photo_Filename.Value + "'" : "NULL";
            }
            else
            {
                Banner_FileName_v_s = "NULL";
            }
            #endregion
            DBAcc.CommandExc(@" update [dbo].[__StandardEngine_T_Banners]
                                set
                                        [Banner_URL]=" + Banner_URL_v_s + @"
                                       ,[Banner_FileName]=" + Banner_FileName_v_s + @"
                                       ,[Banner_Target]=" + Banner_Target_v_s + @"
                                       ,[WidthPerc]=N'100%'
                                       ,[HeightPerc]=N'"+dbl_HeightPerc.ToString() + @"' 
                                where 
                                        [Banner_ID]=" + hdn_Photo_ID.Value
                            );
        }

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;
        img_Photo_Filename.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":
                try
                {
                    System.IO.File.Delete(Request.MapPath("") + "\\..\\ar\\UpperBanner_Photos\\images\\" + DBAcc.DataSetSel(@"SELECT [Banner_FileName] FROM [dbo].[__StandardEngine_T_Banners] where [Banner_ID]=" + e.CommandArgument.ToString()).Tables[0].Rows[0][0].ToString());
                }
                catch
                {
                }

DBAcc.CommandExc(@" Delete FROM [dbo].[__StandardEngine_T_Banners] 
                                    where 
                                        [Banner_ID]=" + e.CommandArgument.ToString());

#region ReOrder the rest
                DataSet DS = DBAcc.DataSetSel(@"  SELECT 
                                                    [Banner_ID]
                                                FROM [dbo].[__StandardEngine_T_Banners]
                                                where 
                                                    [EditorPage_ID]=" + Request.Params["EPID"].Replace("'","") + @"
                                                Order by 
                                                    [Order] asc,
                                                    [Banner_ID] asc"
                                            );

if (DS.Tables.Count > 0 && DS.Tables[0].Rows.Count > 0)
                {
                    for (int y = 0; y < DS.Tables[0].Rows.Count; y++)
                    {
                        DBAcc.CommandExc(@" update [dbo].[__StandardEngine_T_Banners]
                                            set
                                                    [Order]=" + Convert.ToString(y + 1) + @"
                                            where 
                                                    [Banner_ID]=" + DS.Tables[0].Rows[y]["Banner_ID"].ToString()
                                        );
                    }
                }

#endregion
                load();
                break;
            case "Order_Up":
            case "Order_Down":
                string i = e.Item.ItemIndex.ToString();
                #region Get Data
                DS = DBAcc.DataSetSel(@"    SELECT     
                                                    Banner_ID, 
                                                    [Order] 
                                                FROM    [dbo].[__StandardEngine_T_Banners]
                                                where 
                                                    EditorPage_ID=" + Request.Params["EPID"].Replace("'","") + @"  
                                                Order by
                                                    [Order] asc ");
                #endregion

if (e.CommandName == "Order_Up")
                {
                    if (i != "0")
                    {
                        //update current
                        DBAcc.CommandExc(@"
                                                update [dbo].[__StandardEngine_T_Banners]
                                                set 
                                                    [Order]=" + DS.Tables[0].Rows[Convert.ToInt32(i.Replace("'", "")) - 1]["Order"].ToString() + @"  
                                                where 
                                                    [Banner_ID]=" + DS.Tables[0].Rows[Convert.ToInt32(i.Replace("'", ""))]["Banner_ID"].ToString()
                                            );

//update Prev
                        DBAcc.CommandExc(@"
                                                update [dbo].[__StandardEngine_T_Banners]
                                                set 
                                                    [Order]=" + DS.Tables[0].Rows[Convert.ToInt32(i.Replace("'", ""))]["Order"].ToString() + @"  
                                                where 
                                                    [Banner_ID]=" + DS.Tables[0].Rows[Convert.ToInt32(i.Replace("'", "")) - 1]["Banner_ID"].ToString()
                                            );
                    }
                }
                else
                {
                    if (Convert.ToInt32(i) < DS.Tables[0].Rows.Count - 1)
                    {
                        //update current
                        DBAcc.CommandExc(@"
                                                update [dbo].[__StandardEngine_T_Banners]
                                                set 
                                                    [Order]=" + DS.Tables[0].Rows[Convert.ToInt32(i.Replace("'", "")) + 1]["Order"].ToString() + @"  
                                                where 
                                                    [Banner_ID]=" + DS.Tables[0].Rows[Convert.ToInt32(i.Replace("'", ""))]["Banner_ID"].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_DeleteAllBanners()
    {
        DataSet DS_HomePage_Photos = DBAcc.DataSetSel(@"SELECT 
                                                            [Banner_ID]
                                                            ,[Banner_URL]
                                                            ,[Banner_FileName]
                                                        FROM [dbo].[__StandardEngine_T_Banners]
                                                        where 
                                                            [EditorPage_ID]=" + Request.Params["EPID"].Replace("'", "") + @"
                                                        Order by 
                                                            [Order] asc,
                                                            [Banner_ID] asc"
                                                    );
        if (DS_HomePage_Photos.Tables.Count > 0 && DS_HomePage_Photos.Tables[0].Rows.Count > 0)
        {
            foreach (DataRow DR in DS_HomePage_Photos.Tables[0].Rows)
            {
                try
                {
                    System.IO.File.Delete(Request.MapPath("") + "\\..\\ar\\UpperBanner_Photos\\images\\" + DR["Banner_FileName"].ToString());
                }
                catch
                {
                }

DBAcc.CommandExc(@" Delete FROM [dbo].[__StandardEngine_T_Banners] 
                                    where 
                                        [Banner_ID]=" + DR["Banner_ID"].ToString());

}
        }

}
    protected void btn_SetParent_Click(object sender, EventArgs e)
    {
        F_DeleteAllBanners();

load();
    }
    protected void btn_SetBlank_Click(object sender, EventArgs e)
    {
        F_DeleteAllBanners();

#region Insert Blank
        string Banner_ID_v_s = "";
        string Module_ID_v_s = System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"];
        string BannerLocation_ID_v_s = (Request.Params["LocID"] != null && Request.Params["LocID"] != "") ? Request.Params["LocID"] : "NULL";
        string EditorPage_ID_v_s = Request.Params["EPID"].Replace("'", "");

Banner_ID_v_s = DBAcc.DataSetSel("select dbo.[__StandardEngine_F_MaxID_Banners]()+1 ").Tables[0].Rows[0][0].ToString();

DBAcc.CommandExc(@" INSERT INTO [dbo].[__StandardEngine_T_Banners]
                                       ([Banner_ID]
                                       ,[BannerLocation_ID]
                                       ,[EditorPage_ID])
                                VALUES
                                       (" + Banner_ID_v_s + @",
                                       " + BannerLocation_ID_v_s + @",
                                       " + EditorPage_ID_v_s + ")"
                        );
        #endregion

load();
    }
    protected void rbl_UpperBanner_Style_SelectedIndexChanged(object sender, EventArgs e)
    {

#region Update UpperBanner Mode
        DBAcc.CommandExc(@"    Update [dbo].[__StandardEngine_T_EditorPages]
                                set [UpperBanner_Style]=" + rbl_UpperBanner_Style.SelectedValue + @"
                                where [EditorPage_ID]=" + Request.Params["EPID"].Replace("'", ""));
        #endregion
    }
    protected void ddl_UpperBanner_Effect_SelectedIndexChanged(object sender, EventArgs e)
    {
        #region Update UpperBanner Mode
        DBAcc.CommandExc(@"    Update [dbo].[__StandardEngine_T_EditorPages]
                                set [UpperBanner_Effect]=N'" + ddl_UpperBanner_Effect.SelectedValue + @"' 
                                where [EditorPage_ID]=" + Request.Params["EPID"].Replace("'", ""));
        #endregion
    }
    protected void ddl_UpperBanner_Navigation_SelectedIndexChanged(object sender, EventArgs e)
    {
        #region Update UpperBanner Mode
        DBAcc.CommandExc(@"    Update [dbo].[__StandardEngine_T_EditorPages]
                                set [UpperBanner_Navigation]=" + ddl_UpperBanner_Navigation.SelectedValue + @" 
                                where [EditorPage_ID]=" + Request.Params["EPID"].Replace("'", ""));
        #endregion
    }
    protected void ddl_UpperBanner_Thumbnails_SelectedIndexChanged(object sender, EventArgs e)
    {

#region Update UpperBanner Mode
        DBAcc.CommandExc(@"    Update [dbo].[__StandardEngine_T_EditorPages]
                                set [UpperBanner_Thumbnails]=" + ddl_UpperBanner_Thumbnails.SelectedValue + @" 
                                where [EditorPage_ID]=" + Request.Params["EPID"].Replace("'", ""));
        #endregion
    }
    protected void ddl_UpperBanner_Time_SelectedIndexChanged(object sender, EventArgs e)
    {

#region Update UpperBanner Mode
        DBAcc.CommandExc(@"    Update [dbo].[__StandardEngine_T_EditorPages]
                                set [UpperBanner_Time]=" + ddl_UpperBanner_Time.SelectedValue + @" 
                                where [EditorPage_ID]=" + Request.Params["EPID"].Replace("'", ""));
        #endregion
    }
    protected void ddl_UpperBanner_TransPeriod_SelectedIndexChanged(object sender, EventArgs e)
    {
        #region Update UpperBanner Mode
        DBAcc.CommandExc(@"    Update [dbo].[__StandardEngine_T_EditorPages]
                                set [UpperBanner_TransPeriod]=" + ddl_UpperBanner_TransPeriod.SelectedValue + @" 
                                where [EditorPage_ID]=" + Request.Params["EPID"].Replace("'", ""));
        #endregion
    }
}

${this.title}

Code Editor : UpperBanners.aspx.cs