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;

/// <summary>
/// Summary description for UpperBanner
/// </summary>
public class UpperBanner
{
    public HttpRequest Request;
    public HttpServerUtility Server;
    bool bool_inAdmin = false;
    bool bool_HideControls = false;
    public int int_UpperBanner_Style = 1;
    public string str_UpperBanner_Effect = "random";
    public int int_UpperBanner_Navigation = 2;
    public int int_UpperBanner_Thumbnails = 0;
    public int int_UpperBanner_Time = 7000;
    public int int_UpperBanner_TransPeriod = 1500;
    DBAccess.DBAccess ClSqlCmd = new DBAccess.DBAccess(System.Configuration.ConfigurationSettings.AppSettings["SE_ConnectionString"]);

    public string str_BannerLocation_ID = "1";

    public UpperBanner(HttpServerUtility _Server, HttpRequest _Request, bool _bool_inAdmin, bool _bool_HideControls)
    {
        Request = _Request;
        Server = _Server;
        bool_inAdmin = _bool_inAdmin;
        bool_HideControls = _bool_HideControls;
		//
		// TODO: Add constructor logic here
		//
	}

    public string getall()
    {



        string str_UpperBanner_AdminHTML = @"
                                    <table border=0 cellpadding=0 cellspacing=0 style='width:100%; display:inline-table'>
                                    <tr>
                                        <td class='AdminBorder_BorderOnlyStyle' style='text-align:center; vertical-align:middle'><--Banner--></td>
                                    </tr>
                                    <tr>
                                        <td style='text-align:left; vertical-align:top'>
                                                <table border=0 cellpadding=0 cellspacing=0 style='width:100%; display:inline-table'>
                                                    <tr>
                                                        <td>
                                                            <a class='AdminBorder_BorderOnlyStyle AdminText_TextStyle' href='../Admin/UpperBanners.aspx?EPID=" + Request.Params["ID"].Replace("'", "") + "&LocID=1&Title=الصور العلوية&retP=" + Server.UrlEncode(Request.Url.ToString()) + @"'>/</a>
                                                        </td>
                                                    </tr>
                                                </table>
                                        </td>
                                    </tr>
                                    </table>";





        string str_HTML_Banners = "<--Banner-->";
        string str_HTML_Banners_Inner = "";
        DataSet DS_Photos;
        string str_EditorPage_ID = "-1";

        //Check if banner is closed
        DS_Photos = ClSqlCmd.DataSetSel(@"  SELECT [Banner_FileName] 
                                            FROM [dbo].[__StandardEngine_T_Banners] 
                                            where 
                                                [BannerLocation_ID]=1 and 
                                                [EditorPage_ID]=" + Request.Params["ID"].Replace("'", ""));

        if (DS_Photos.Tables.Count > 0 && DS_Photos.Tables[0].Rows.Count > 0)
        {
            str_EditorPage_ID = Request.Params["ID"].Replace("'", "");
            if (DS_Photos.Tables[0].Rows[0]["Banner_FileName"] == Convert.DBNull) //Banner is closed for this page
            {
                if (bool_inAdmin && !bool_HideControls)
                {
                    str_HTML_Banners_Inner = "<a class='AdminBorder_BorderOnlyStyle AdminText_TextStyle'> تم إعداد الصور العلوية لعدم الظهور لهذه الصفحة </a>";
                }
                else
                {
                    str_HTML_Banners = "";
                }
            }
        }
        else
        {
            if (bool_inAdmin && !bool_HideControls)
            {
                str_HTML_Banners = str_HTML_Banners.Replace("<--Banner-->",
                                        @"  <table border=0 cellpadding=0 cellspacing=0 style='width:100%; display:inline-table'>
                                        <tr>
                                            <td class='AdminBorder_BorderOnlyStyle' style='text-align:left; vertical-align:middle'><a class='AdminBorder_BorderOnlyStyle AdminText_TextStyle'> تم إعداد الصور العلوية لظهور اخر صور علوية في القسم لهذه الصفحة </a></td>
                                        </tr>
                                        <tr>
                                            <td style='text-align:left; vertical-align:middle'><--Banner--></td>
                                        </tr>
                                    </table>");
            }
        }

        if (str_EditorPage_ID == "-1")
        {
            str_EditorPage_ID = ClSqlCmd.DataSetSel(@"select [dbo].[__StandardEngine_F_EditorPage_HasBanner](" + Request.Params["ID"].Replace("'", "") + ") ").Tables[0].Rows[0][0].ToString();

            if (str_EditorPage_ID == "-1")  //NoBanner settings for category
            {
                //Check on main category
                DataSet DS_MainBanners = ClSqlCmd.DataSetSel(@" SELECT top 1      
                                                                dbo.__StandardEngine_T_EditorPages.EditorPage_ID,
                                                                dbo.__StandardEngine_T_Banners.Banner_FileName 
                                                            FROM         dbo.__StandardEngine_T_ModuleStyles INNER JOIN
                                                                    dbo.__StandardEngine_T_Groups ON dbo.__StandardEngine_T_ModuleStyles.Start_Group_ID = dbo.__StandardEngine_T_Groups.Group_ID INNER JOIN
                                                                    dbo.__StandardEngine_T_EditorPages ON dbo.__StandardEngine_T_Groups.Group_ID = dbo.__StandardEngine_T_EditorPages.Group_ID INNER JOIN
                                                                    dbo.__StandardEngine_T_Banners ON dbo.__StandardEngine_T_EditorPages.EditorPage_ID = dbo.__StandardEngine_T_Banners.EditorPage_ID
                                                            where 
                                                                dbo.__StandardEngine_T_Banners.[BannerLocation_ID]=1 and 
                                                                dbo.__StandardEngine_T_EditorPages.EditorPage_Type_ID is NULL and 
                                                                dbo.__StandardEngine_T_ModuleStyles.Module_ID=" + System.Configuration.ConfigurationSettings.AppSettings["SE_ModuleID"] + @" 
                                                            Order by 
                                                                dbo.__StandardEngine_T_EditorPages.EditorPage_ID asc");

                if (DS_MainBanners.Tables.Count > 0 && DS_MainBanners.Tables[0].Rows.Count > 0 && DS_MainBanners.Tables[0].Rows[0]["Banner_FileName"] != Convert.DBNull)
                {
                    str_EditorPage_ID = DS_MainBanners.Tables[0].Rows[0]["EditorPage_ID"].ToString();
                }
            }
        }







        if (str_EditorPage_ID == "-1")  //NoBanner settings
        {
            if (!bool_inAdmin || bool_HideControls)
            {
                //tbl_UpperBanner.Visible = false;
                return "-1";
            }
        }
        else
        {
            #region Get UpperBanner_Style
            DataSet DS_Style = ClSqlCmd.DataSetSel(@"  SELECT 
                                                [EditorPage_ID]
                                                ,[UpperBanner_Style]
                                                ,[UpperBanner_Effect] 
                                                ,[UpperBanner_Navigation] 
                                                ,[UpperBanner_Thumbnails] 
                                                ,[UpperBanner_Time] 
                                                ,[UpperBanner_TransPeriod] 
                                            FROM [dbo].[__StandardEngine_T_EditorPages]
                                            where [EditorPage_ID]=" + str_EditorPage_ID);
            if (DS_Style.Tables[0].Rows[0]["UpperBanner_Style"] != Convert.DBNull)
            {
                int_UpperBanner_Style = Convert.ToInt32(DS_Style.Tables[0].Rows[0]["UpperBanner_Style"].ToString());
            }

            if (DS_Style.Tables[0].Rows[0]["UpperBanner_Effect"] != Convert.DBNull)
            {
                str_UpperBanner_Effect = DS_Style.Tables[0].Rows[0]["UpperBanner_Effect"].ToString();
            }

            if (DS_Style.Tables[0].Rows[0]["UpperBanner_Navigation"] != Convert.DBNull)
            {
                int_UpperBanner_Navigation = Convert.ToInt32(DS_Style.Tables[0].Rows[0]["UpperBanner_Navigation"].ToString());
            }

            if (DS_Style.Tables[0].Rows[0]["UpperBanner_Thumbnails"] != Convert.DBNull)
            {
                int_UpperBanner_Thumbnails = Convert.ToInt32(DS_Style.Tables[0].Rows[0]["UpperBanner_Thumbnails"].ToString());
            }

            if (DS_Style.Tables[0].Rows[0]["UpperBanner_Time"] != Convert.DBNull)
            {
                int_UpperBanner_Time = Convert.ToInt32(DS_Style.Tables[0].Rows[0]["UpperBanner_Time"].ToString());
            }

            if (DS_Style.Tables[0].Rows[0]["UpperBanner_TransPeriod"] != Convert.DBNull)
            {
                int_UpperBanner_TransPeriod = Convert.ToInt32(DS_Style.Tables[0].Rows[0]["UpperBanner_TransPeriod"].ToString());
            }
            #endregion

            DS_Photos = ClSqlCmd.DataSetSel(@"
                                        SELECT 
                                            [Banner_ID]
                                            ,[Banner_URL]
                                            ,[Banner_FileName]
                                            ,[EditorPage_ID]
                                            ,[Banner_Target]
                                            ,[effect]
                                            ,[Order]
                                            ,[WidthPerc]
                                            ,[HeightPerc] 
                                        FROM [dbo].[__StandardEngine_T_Banners]
                                        where 
                                            [EditorPage_ID]=" + str_EditorPage_ID + @" 
                                        Order by 
                                            [Order] asc");

            if (DS_Photos.Tables.Count > 0 && DS_Photos.Tables[0].Rows.Count > 0)
            {
                if (DS_Photos.Tables[0].Rows[0]["Banner_FileName"] == Convert.DBNull)
                {
                    if (bool_inAdmin && !bool_HideControls)
                    {
                        str_HTML_Banners_Inner = "<a class='AdminBorder_BorderOnlyStyle AdminText_TextStyle'> تم إعداد اخر صور علوية في القسم لعدم الظهور </a>";
                    }
                    else
                    {
                        //tbl_UpperBanner.Visible = false;
                        return "-1";
                        str_HTML_Banners_Inner = "";
                    }

                }
                else
                {
                    double dbl_HeightPerc = 0;
                    //tbl_UpperBanner.Visible = true;
                    ////////////////////////////////////////////////////////////////////
                    foreach (DataRow DR in DS_Photos.Tables[0].Rows)
                    {
                        if (DR["HeightPerc"] != Convert.DBNull)
                        {
                            if (Convert.ToDouble(DR["HeightPerc"].ToString().Replace("%", "")) > dbl_HeightPerc)
                            {
                                dbl_HeightPerc = Convert.ToDouble(DR["HeightPerc"].ToString().Replace("%", ""));
                            }
                        }

                        if (DS_Photos.Tables[0].Rows.Count > 1)
                        {
                            str_HTML_Banners_Inner += "<div data-src='UpperBanner_Photos/images/" + DR["Banner_FileName"].ToString() + @"' data-thumb='UpperBanner_Photos/images/" + DR["Banner_FileName"].ToString() + @"' " + (DR["Banner_URL"] != Convert.DBNull ? ("data-link='" + DR["Banner_URL"].ToString() + "'") : "") + @" ></div>";
                        }
                        else //One image to be shawn
                        {
                            str_HTML_Banners_Inner += " <a target='_top' " + (DR["Banner_URL"] != Convert.DBNull ? ("href='" + DR["Banner_URL"].ToString() + "'") : "") + @"  style='width:100%' >
                                    <img src='UpperBanner_Photos/images/" + DR["Banner_FileName"].ToString() + @"' alt='' style='width:100%' />
                                </a>";
                        }
                    }


                    if (DS_Photos.Tables[0].Rows.Count > 1)
                    {
                        str_HTML_Banners_Inner = @"
                                <script>
                                    jQuery(function () {

                                        jQuery('#camera_wrap_1').camera({
                                            height: '" + dbl_HeightPerc.ToString() + @"%',
                                            fx: '" + str_UpperBanner_Effect + @"',
                                            navigation : " + (int_UpperBanner_Navigation == 0 ? "false" : "true") + @",
                                            navigationHover : " + (int_UpperBanner_Navigation == 2 ? "true" : "false") + @",
                                            thumbnails : " + (int_UpperBanner_Thumbnails == 1 ? "true" : "false") + @",
                                            time : " + int_UpperBanner_Time.ToString() + @" ,
                                            transPeriod : " + int_UpperBanner_TransPeriod.ToString() + @" ,
                                            loader: 'none',
                                            hover : false ,
                                            pagination: false
                                        });
                                    });
                                    ///////////////////////////////////
                                    jQuery(function () {

                                        jQuery('#camera_wrap_2').camera({
                                            height: '110%',
                                            loader: 'none',
                                            pagination: false,
                                            thumbnails: false,
                                            navigationHover: false,
                                            fx: 'scrollHorz',
                                            mobileNavHover: false
                                        });
                                    });
		
	                            </script>

                                <table border=0 cellpadding=0 cellspacing=0 style='width:100%; display:inline-table'>
                                    <tr>
                                        <td>
                                <div  class='pix_100Perc'>
                                    <div class='camera_wrap camera_azure_skin' id='camera_wrap_1'>" + str_HTML_Banners_Inner;

                        str_HTML_Banners_Inner += @"
                                    </div>
                                </div>
                                        </td>
                                    </tr>
                                </table>";
                        //        break;
                        //}
                    }
                }

            }
            else
            {
                if (!bool_inAdmin || bool_HideControls)
                {
                    //tbl_UpperBanner.Visible = false;
                    return "-1";
                }
            }
        }




        if (bool_inAdmin && !bool_HideControls)
        {
            str_HTML_Banners = str_HTML_Banners.Replace("<--Banner-->", str_UpperBanner_AdminHTML);
            str_HTML_Banners = str_HTML_Banners.Replace("<--Banner-->", str_HTML_Banners_Inner);
        }
        else
        {
            str_HTML_Banners = str_HTML_Banners.Replace("<--Banner-->", str_HTML_Banners_Inner);
        }
        ///////////////////////////////////////////////////////////////////////////

        switch (int_UpperBanner_Style)
        {
            case 1:
                return @"   <table align=center border=0 cellpadding=0 cellspacing=0 style='text-align:center;'>
                                <tr>
                                    <td class='UpperBanner_LayoutStrip_Inner_ShadowOuter' align=center style='text-align:center;'>
        
                                        <div align=center class='UpperBanner_LayoutStrip_Inner Main_OuterContent' style='display:inline-block; height:auto; text-align:center;'>
                                        
                                            <table align=center border=0 cellpadding=0 cellspacing=0 style='text-align:center; width:100%; display:inline-table'>
                                                <tr>
                                                    <td>
                                            
                                        " + str_HTML_Banners+ @"

                                                    </td>
                                                </tr>
                                            </table>

                                        </div>
        
                                    </td>
                                </tr>
                            </table>";
                break;
            case 20:
                return str_HTML_Banners;
                break;
            default:
                return str_HTML_Banners;
                break;
        }


        return "";
    }

}