Example #1
0
 private Telerik.Web.UI.RadToolTip GetTooltip(string tooltipId, string targetId)
 {
     Telerik.Web.UI.RadToolTip tooltip = new Telerik.Web.UI.RadToolTip();
     tooltip.ShowEvent       = Telerik.Web.UI.ToolTipShowEvent.OnMouseOver;
     tooltip.Position        = Telerik.Web.UI.ToolTipPosition.TopRight;
     tooltip.RelativeTo      = Telerik.Web.UI.ToolTipRelativeDisplay.Element;
     tooltip.HideEvent       = Telerik.Web.UI.ToolTipHideEvent.LeaveToolTip;
     tooltip.ID              = tooltipId;
     tooltip.IsClientID      = true;
     tooltip.TargetControlID = targetId;
     return(tooltip);
 }
Example #2
0
        private Telerik.Web.UI.RadToolTip GetInfoTooltip(DataObject DataObject)
        {
            Telerik.Web.UI.RadToolTip tooltip            = GetTooltip(string.Format(@"ITT_{0}", DataObject.ObjectID), string.Format(@"ITTT_{0}", DataObject.ObjectID));
            ObjectDetailsSmall        objectDetailsSmall = (ObjectDetailsSmall)this.LoadControl(typeof(ObjectDetailsSmall), null);

            objectDetailsSmall.DataObject = DataObject;
            Literal literal = new Literal();

            literal.Text = objectDetailsSmall.GetContent();
            tooltip.Controls.Add(literal);
            return(tooltip);
        }
        private Telerik.Web.UI.RadToolTip GetInfoTooltip(Guid navID)
        {
            Telerik.Web.UI.RadToolTip tooltip = GetTooltip(string.Format(@"ITT_{0}", navID), string.Format(@"ITTT_{0}", navID));
            Literal literal = new Literal();

            literal.Text = language.GetString("TooltipInfoTitle");;
            tooltip.Controls.Add(literal);
            TextBox txtID = new TextBox();

            txtID.Text = navID.ToString();
            tooltip.Controls.Add(txtID);
            return(tooltip);
        }
Example #4
0
        private Telerik.Web.UI.RadToolTip GetEditTooltip(DataObject DataObject)
        {
            Telerik.Web.UI.RadToolTip tooltip = GetTooltip(string.Format(@"ETT_{0}", DataObject.ObjectID), string.Format(@"ETTT_{0}", DataObject.ObjectID));

            DropDownList dropDownList = new DropDownList();

            dropDownList.ID = string.Format("DDLFeat_{0}", DataObject.ObjectID);
            dropDownList.SelectedIndexChanged += new EventHandler(OnFeaturedValueChange);
            dropDownList.AutoPostBack          = true;
            foreach (var featuredValue in featuredValues)
            {
                ListItem listItem = new ListItem(featuredValue.Value, featuredValue.Key.ToString());
                if (DataObject.Featured == featuredValue.Key)
                {
                    listItem.Selected = true;
                }
                dropDownList.Items.Add(listItem);
            }
            tooltip.Controls.Add(dropDownList);

            return(tooltip);
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        DayOfWeek theWeekDay = DayOfWeek.Friday;
        switch (theDay)
        {
            case days.Sun:
                theWeekDay = DayOfWeek.Sunday;
                break;
            case days.Mon:
                theWeekDay = DayOfWeek.Monday;
                break;
            case days.Tues:
                theWeekDay = DayOfWeek.Tuesday;
                break;
            case days.Wed:
                theWeekDay = DayOfWeek.Wednesday;
                break;
            case days.Thurs:
                theWeekDay = DayOfWeek.Thursday;
                break;
            case days.Fri:
                theWeekDay = DayOfWeek.Friday;
                break;
            case days.Sat:
                theWeekDay = DayOfWeek.Saturday;
                break;
        }

        if (!IsPostBack)
        {
            string imageSrc = "";
            string eventStr = "";
            string thisDay = theDay.ToString();

            HttpCookie cookie = Request.Cookies["BrowserDate"];
            DateTime datNow = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"));
            Data dat = new Data(datNow);

            int thisDayCount = 0;
            DataView dvAll = dat.GetDataDV("SELECT DISTINCT EO.DateTimeStart AS TheDate, EO.EventID AS ID, E.Header FROM Events E, User_Calendar UC, Event_Occurance EO WHERE " +
                "UC.EventID=EO.EventID AND EO.EventID=E.ID AND UC.UserID=" + Session["User"].ToString());

            int subtraction = 0;

            switch (datNow.DayOfWeek)
            {
                case DayOfWeek.Friday:
                    subtraction = 5;
                    break;
                case DayOfWeek.Monday:
                    subtraction = 1;
                    break;
                case DayOfWeek.Saturday:
                    subtraction = 6;
                    break;
                case DayOfWeek.Sunday:
                    subtraction = 0;
                    break;
                case DayOfWeek.Thursday:
                    subtraction = 4;
                    break;
                case DayOfWeek.Tuesday:
                    subtraction = 2;
                    break;
                case DayOfWeek.Wednesday:
                    subtraction = 3;
                    break;
                default: break;
            }

            string toolTipText = "";

            if (dvAll.Count > 0)
            {
                for (int i = 0; i < dvAll.Count; i++)
                {
                    DateTime date2 = DateTime.Parse(dvAll[i]["TheDate"].ToString());

                    if (date2.DayOfWeek == theWeekDay)
                    {
                        if (dat.IsThisWeek(date2))
                        {
                            thisDayCount++;
                            toolTipText += "<div class=\"TextNormal\" style=\"clear: both;\"><a class=\"NavyLink12\" href=\"" + dat.MakeNiceName(dvAll[i]["Header"].ToString()) +
                                "_" + dvAll[i]["ID"].ToString() + "_Event\">" + dvAll[i]["Header"].ToString() + "</a> at " +
                                DateTime.Parse(dvAll[i]["TheDate"].ToString()).ToShortTimeString() + "</div>";
                        }
                    }
                }
            }

            numberOfEvents = thisDayCount;

            switch (numberOfEvents)
            {
                case 0:
                    imageSrc = "NewImages/GlanceCalendarOpen.png";
                    eventStr = "open";
                    break;
                default:
                    imageSrc = "NewImages/GlanceCalendarOpen.png";
                    if (numberOfEvents == 1)
                        eventStr = numberOfEvents + " event";
                    else
                        eventStr = numberOfEvents + " events";
                    break;
            }

            if (datNow.DayOfWeek.ToString().Substring(0, 3) == theDay.ToString() ||
                datNow.DayOfWeek.ToString().Substring(0, 4) == theDay.ToString() ||
                datNow.DayOfWeek.ToString().Substring(0, 5) == theDay.ToString())
            {
                thisDay = "Today";
                imageSrc = "NewImages/GlanceCalendarOrange.png";
            }

            string addStr = "";
            if (toolTipText != "")
                addStr = " style=\"text-decoration: underline;cursor: pointer;\"";
            ImageLiteral.Text = "<div class=\"TextNormal\" id=\"theDay" + theDay.ToString() +
                "\" style=\"font-size: 10px;float:left;margin-right:5px;" +
                "width: 53px; height: 58px; background-image:url('" +
                imageSrc + "'); font-weight: bold;\"><div style=\"padding-left:2px;\"> " +
                thisDay + "</div><br/><div align=\"center\" " + addStr + ">" + eventStr + "</div></div>";
            ImageLiteral.ID = "lit" + theDay.ToString();

            if (toolTipText != "")
            {
                Telerik.Web.UI.RadToolTip tip = new Telerik.Web.UI.RadToolTip();
                tip.Text = "<div style=\"padding: 10px;\">" + toolTipText + "</div>";
                tip.Width = 200;
                tip.TargetControlID = "theDay" + theDay.ToString();
                tip.IsClientID = true;
                tip.HideEvent = Telerik.Web.UI.ToolTipHideEvent.ManualClose;
                tip.Animation = Telerik.Web.UI.ToolTipAnimation.None;
                tip.Position = Telerik.Web.UI.ToolTipPosition.TopCenter;
                tip.ShowEvent = Telerik.Web.UI.ToolTipShowEvent.OnClick;
                tip.Skin = "Sunset";
                ToolTipPanel.Controls.Add(tip);
                tip.RelativeTo = Telerik.Web.UI.ToolTipRelativeDisplay.Element;
            }
        }
    }
    protected void LoadFriends()
    {
        HttpCookie cookie = Request.Cookies["BrowserDate"];
        ClearMessage();
        Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
        DateTime isNow = DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":"));
        DataSet dsFriends = dat.GetData("SELECT * FROM User_Friends UF, Users U WHERE UF.FriendID=U.User_ID AND UF.UserID=" + Session["User"].ToString());
        Panel FriendPanel = (Panel)Tab1.FindControl("FriendPanel");

        //Search for what your friends did in the past 30 days.
        string thisMonth = isNow.AddDays(-30).Month.ToString() + "/" + isNow.AddDays(-30).Day.ToString() + "/" +
            isNow.AddDays(-30).Year.ToString();
        Panel WhatMyFriendsDidPanel = (Panel)Tab2.FindControl("WhatMyFriendsDidPanel");
        DataView dvFriends = new DataView(dsFriends.Tables[0], "", "", DataViewRowState.CurrentRows);

        if (dvFriends.Count > 0)
        {
            //Added Events to calendar
            DataView dvEvents = dat.GetDataDV("SELECT TOP 10 U.UserName,  U.ProfilePicture, UC.DateAdded AS THE_DATE, 'Added the event <a class=NavyLink12 target=_blank href=' + dbo.MAKENICENAME(E.Header) + '_' + CONVERT(NVARCHAR,E.ID)+'_Event>'+  E.Header +'</a>' AS HEADER " +
                "FROM User_Friends UF, Users U, User_Calendar UC, Events E WHERE UF.UserID=" +
                Session["User"].ToString() + " AND U.User_ID=UF.FriendID AND E.ID=UC.EventID " +
                "AND UF.FriendID=UC.UserID AND UC.DateAdded > CONVERT(DATETIME, '" + thisMonth + "') ORDER BY THE_DATE DESC");
                //AND UC.DateAdded > CONVERT(DATETIME, '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A",":")).AddDays(double.Parse("-10")).Date.ToString() + "')
            //Added Favorite Venues
            DataView dvVenues = dat.GetDataDV("SELECT TOP 10  U.UserName, U.ProfilePicture, UV.DateAdded AS THE_DATE, 'Added a favorite venue <a class=NavyLink12 target=_blank href='+dbo.MAKENICENAME(V.Name)+'_'+CONVERT(NVARCHAR,V.ID)+'_Venue>'+ V.Name +'</a>' AS HEADER " +
                "FROM User_Friends UF, Users U, UserVenues UV, Venues V WHERE UF.UserID=" +
                Session["User"].ToString() + " AND V.ID=UV.VenueID AND UV.DateAdded > CONVERT(DATETIME, '" + thisMonth + "') AND U.User_ID=UF.FriendID AND UF.FriendID=UV.UserID ORDER BY THE_DATE DESC");

            //AND UV.DateAdded > CONVERT(DATETIME, '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).AddDays(double.Parse("-10")).Date.ToString() + "')

            //Added Event Comments
            DataView dvComments = dat.GetDataDV("SELECT TOP 10 U.UserName, U.ProfilePicture,  C.BlogDate AS THE_DATE, 'Posted a comment:  " +
                "<a class=Green12LinkNF target=_blank href=' + dbo.MAKENICENAME(E.Header) + '_' + CONVERT(NVARCHAR,E.ID)+'_Event>'+ C.Comment +'</a>' AS HEADER " +
                "FROM User_Friends UF, Users U, Comments C, Events E WHERE UF.UserID=" +
                Session["User"].ToString() + " AND C.BlogDate > CONVERT(DATETIME, '" + thisMonth + "') AND U.User_ID=UF.FriendID AND C.BlogID=E.ID " +
                "AND UF.FriendID=C.UserID  ORDER BY THE_DATE DESC");

            //AND C.BlogDate > CONVERT(DATETIME, '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A",":")).AddDays(double.Parse("-10")).Date.ToString() + "')

            //Added Venue Comments
            DataView dvCommentsVenue = dat.GetDataDV("SELECT TOP 10  U.UserName, U.ProfilePicture,  VC.CommentDate AS THE_DATE, 'Posted a comment: " +
                "<a class=Green12LinkNF target=_blank href='+dbo.MAKENICENAME(V.Name)+'_'+CONVERT(NVARCHAR,V.ID)+'_Venue>'+ VC.Comment +'</a>' AS HEADER " +
                "FROM User_Friends UF, Users U, Venue_Comments VC, Venues V WHERE UF.UserID=" +
                Session["User"].ToString() + " AND VC.CommentDate > CONVERT(DATETIME, '" + thisMonth + "') AND U.User_ID=UF.FriendID AND V.ID=VC.VenueID " +
                "AND UF.FriendID=VC.UserID ORDER BY THE_DATE DESC");

             //AND VC.CommentDate > CONVERT(DATETIME, '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A",":")).AddDays(double.Parse("-10")).Date.ToString() + "')

            //Posted Events
            DataView dvPostedEvents = dat.GetDataDV("SELECT TOP 10  U.UserName, U.ProfilePicture, E.PostedOn AS THE_DATE, " +
                "'Posted the event <a class=AddOrangeLink target=_blank href=' + dbo.MAKENICENAME(E.Header) + '_' + CONVERT(NVARCHAR,E.ID)+'_Event>'+ E.Header +'</a>'AS HEADER " +
                "FROM User_Friends UF, Users U, Events E WHERE UF.UserID=" +
                Session["User"].ToString() + " AND E.PostedOn > CONVERT(DATETIME, '" + thisMonth + "') AND U.User_ID=UF.FriendID AND U.UserName=E.UserName  ORDER BY THE_DATE DESC");

            //"+"AND E.PostedOn > CONVERT(DATETIME, '" +" ").Replace("%3A", ":")).AddDays(double.Parse("-10")).Date.ToString() + "')

            //Posted Venues
            DataView dvPostedVenues = dat.GetDataDV("SELECT TOP 10  U.UserName,  U.ProfilePicture, V.PostedOn AS THE_DATE, " +
                "'Posted the venue <a class=AddOrangeLink target=_blank href='+ dbo.MAKENICENAME(V.Name)+'_'+CONVERT(NVARCHAR,V.ID)+'_Venue>'+ V.Name +'</a>' AS HEADER " +
                "FROM User_Friends UF, Users U, Venues V WHERE UF.UserID=" +
                Session["User"].ToString() + " AND V.PostedOn > CONVERT(DATETIME, '" + thisMonth + "') AND U.User_ID=UF.FriendID AND UF.FriendID=V.CreatedByUser ORDER BY THE_DATE DESC");

            // AND V.PostedOn > CONVERT(DATETIME, '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).AddDays(double.Parse("-10")).Date.ToString() + "')

            //Posted Ads
            DataView dvPostedAds = dat.GetDataDV("SELECT TOP 10  U.UserName,  U.ProfilePicture, CONVERT(DATETIME,A.DateAdded) AS THE_DATE, " +
                "'Posted the ad <a target=_blank class=AddOrangeLink href='+ dbo.MAKENICENAME(A.Header)+'_'+CONVERT(NVARCHAR,A.Ad_ID)+'_Ad>'+ A.Header +'</a>' AS HEADER " +
                "FROM User_Friends UF, Users U, Ads A WHERE UF.UserID=" +
                Session["User"].ToString() + " AND CONVERT(DATETIME,A.DateAdded) > CONVERT(DATETIME, '" + thisMonth + "') AND U.User_ID=UF.FriendID AND UF.FriendID=A.User_ID  ORDER BY THE_DATE DESC");

            //AND A.DateAdded > CONVERT(DATETIME, '" + DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).AddDays(double.Parse("-10")).Date.ToString() + "')

            DataView dv = MergeDVThreeCol(MergeDVThreeCol(MergeDVThreeCol(MergeDVThreeCol(MergeDVThreeCol(MergeDVThreeCol(dvPostedEvents,
                dvPostedVenues), dvPostedAds), dvCommentsVenue), dvComments), dvVenues), dvEvents);

            string friendImg = "";
            string strFill = "";

            Telerik.Web.UI.RadRotatorItem rItem = new Telerik.Web.UI.RadRotatorItem();
            Literal hiddenPostingLiteral = new Literal();

            dv.Sort = "THE_DATE DESC";

            if (dv.Count != 0)
            {
                int count = 0;

                dv.Sort = "THE_DATE DESC";

                for (int i = 0; i < dv.Count;i++ )
                {
                    string rowHeader = dv[i]["HEADER"].ToString();

                    if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + dv[i]["UserName"].ToString() +
                        "\\Profile\\" + dv[i]["ProfilePicture"].ToString()))
                    {
                        friendImg = "UserFiles/" + dv[i]["UserName"].ToString() + "/Profile/" + dv[i]["ProfilePicture"].ToString();
                        strFill = "";
                    }
                    else
                    {
                        friendImg = "NewImages/noAvatar_50x50_small.png";
                        strFill = "onmouseover=\"this.src='NewImages/noAvatar_50x50_smallhover.png'\"" +
                            "onmouseout=\"this.src='NewImages/noAvatar_50x50_small.png'\" ";
                    }

                        PostingLiteral.Text += "<div align=\"left\" style=\"margin-right: 10px;float: left;width: 230px; line-height: 12px; min-height: 54px;padding: 10px; margin-bottom: 20px;\">" +
                            "<a href=\"" + dv[i]["UserName"].ToString() + "_Friend\"><img " + strFill + " style=\"border: solid 1px #dedbdb;background-color: #dedbdb; float: left;margin-right: 7px; margin-bottom: 2px;\" " +
                            "src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a>";
                        PostingLiteral.Text += "<span class=\"NavyLink\" style=\" font-weight: bold;\"><a class=\"NavyLink12\" href=\"" + dv[i]["UserName"].ToString() + "_Friend\">" +
                            dv[i]["UserName"].ToString() + "</a></span> " + rowHeader + " on " + DateTime.Parse(dv[i]["THE_DATE"].ToString()).ToShortDateString() + "</div>";
                    count++;
                }
            }
            else
            {
                //PostingLiteral.Text += "<div  style=\"padding-top: 10px;padding-left:0; padding-right: 10px;\">Your friends haven't been up to anything. Tell them that they could win the Hippo Points badge for the month and promote themselves on our home page just by posting content on the Hippo! <a class=\"NavyLink\" href=\"hippo-points\">Read more about Hippo Points.</a></div>";
                PostingLiteral.Text += "<div  style=\"padding-top: 10px;padding-left:0; padding-right: 10px;\">Hey, your friends haven't been up to anything lately. Sad face!</div>";

            }

            //dvEvents = MergeDVThreeCol(dvEvents, dvVenues);

            //if (dvEvents.Count != 0)
            //{
            //    rItem = new Telerik.Web.UI.RadRotatorItem();
            //    hiddenPostingLiteral = new Literal();

            //    int count = 0;

            //    dvEvents.Sort = "THE_DATE DESC";

            //    foreach (DataRowView row in dvEvents)
            //    {
            //        string rowHeader = row["HEADER"].ToString();

            //        if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + row["UserName"].ToString() +
            //            "\\Profile\\" + row["ProfilePicture"].ToString()))
            //        {
            //            friendImg = "UserFiles/" + row["UserName"].ToString() + "/Profile/" + row["ProfilePicture"].ToString();
            //            strFill = "";
            //        }
            //        else
            //        {
            //            friendImg = "NewImages/noAvatar_50x50_small.png";
            //            strFill = "onmouseover=\"this.src='NewImages/noAvatar_50x50_smallhover.png'\"" +
            //                "onmouseout=\"this.src='NewImages/noAvatar_50x50_small.png'\" ";
            //        }

            //            PostingLiteral.Text += "<div style=\"line-height: 12px; min-height: 54px;\">" +
            //                "<a href=\"" + row["UserName"].ToString() + "_Friend\"><img " + strFill + " style=\"background-color: #dedbdb;border: 0;float: left;margin-right: 7px; margin-bottom: 2px;\" " +
            //                "src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a>";
            //            PostingLiteral.Text += "<span style=\" font-weight: bold;\"><a class=\"NavyLink12\" href=\"" + row["UserName"].ToString() + "_Friend\">" +
            //                row["UserName"].ToString() + "</a></span> " + rowHeader + " on " + DateTime.Parse(row["THE_DATE"].ToString()).ToShortDateString() + "</div>";
            //    }
            //}
            //else
            //{
            //    PostingLiteral.Text += "<div  style=\"padding-top: 10px;padding-left:0; \">Your friends haven't had any Event Going Action in 10 days.</div>";
            //}

            //DataView dvCommentsFinal = MergeDVThreeCol(dvComments, dvCommentsVenue);

            //if (dvCommentsFinal.Count != 0)
            //{
            //    int count = 0;
            //    dvCommentsFinal.Sort = "THE_DATE DESC";
            //    foreach (DataRowView row in dvCommentsFinal)
            //    {
            //        string rowHeader = row["HEADER"].ToString();

            //        if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + row["UserName"].ToString() +
            //            "\\Profile\\" + row["ProfilePicture"].ToString()))
            //        {
            //            friendImg = "UserFiles/" + row["UserName"].ToString() + "/Profile/" + row["ProfilePicture"].ToString();
            //            strFill = "";
            //        }
            //        else
            //        {
            //            friendImg = "NewImages/noAvatar_50x50_small.png";
            //            strFill = "onmouseover=\"this.src='NewImages/noAvatar_50x50_smallhover.png'\"" +
            //                "onmouseout=\"this.src='NewImages/noAvatar_50x50_small.png'\" ";
            //        }

            //            PostingLiteral.Text += "<div style=\"line-height: 12px;  min-height: 54px;\">" +
            //                "<a href=\"" + row["UserName"].ToString() + "_Friend\"><img " + strFill + " style=\"background-color: #dedbdb;border: 0;float: left;margin-right: 7px; margin-bottom: 2px;\" " +
            //                "src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a>";
            //            PostingLiteral.Text += "<span style=\"color: #628e02; font-weight: bold;\"></span> " + rowHeader + " on " + DateTime.Parse(row["THE_DATE"].ToString()).ToShortDateString() + "</div>";
            //    }
            //}
            //else
            //{
            //    PostingLiteral.Text += "<div  style=\"padding-top: 10px;padding-left:0; \">Your friends haven't had any Commenting Action in 10 days.</div>";
            //}
        }
        else
        {
            PostingLiteral.Text += "<div  style=\"padding-top: 10px;padding-left:0; padding-right: 10px;\">Your friends haven't been up to anything. Tell them that they could win the Hippo Points badge for the month and promote themselves on our home page just by posting content on the Hippo! <a class=\"NavyLink\" href=\"hippo-points\">Read more about Hippo Points.</a></div>";
        }

        DataView dvUser = dat.GetDataDV("SELECT * FROM UserPreferences WHERE UserID=" + Session["User"].ToString());
        string emailPrefs = dvUser[0]["EmailPrefs"].ToString();
        dvUser = dat.GetDataDV("SELECT * FROM UserFriendPrefs WHERE UserID=" + Session["User"].ToString());
        string emailFriendPrefs = "";
        int friendcount = 0;
        if (dsFriends.Tables.Count > 0)
            if (dsFriends.Tables[0].Rows.Count > 0)
            {
                friendcount = dsFriends.Tables[0].Rows.Count;
                for (int i = 0; i < dsFriends.Tables[0].Rows.Count; i++)
                {
                    dvUser.RowFilter = "FriendID = " + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    if (dvUser.Count > 0)
                        emailFriendPrefs = dvUser[0]["Preferences"].ToString();
                    else
                        emailFriendPrefs = "";

                    Literal lit = new Literal();
                    lit.Text = "<div style=\"float: left; padding: 8px;\"><table align=\"center\" valign=\"middle\" cellpadding=\"0\" cellspacing=\"0\"  bgcolor=\"#dedbdb\" width=\"52\" style=\"border: solid 1px #DEDBDB\" height=\"52\"><tr><td align=\"center\">";
                    ImageButton profilePicture = new ImageButton();

                    profilePicture.AlternateText = dsFriends.Tables[0].Rows[i]["UserName"].ToString();
                    profilePicture.ToolTip = dsFriends.Tables[0].Rows[i]["UserName"].ToString();
                    profilePicture.Height = 50;
                    profilePicture.Width = 50;
                    profilePicture.ID = "pic" + i.ToString();
                    profilePicture.AlternateText = dsFriends.Tables[0].Rows[i]["UserName"].ToString();
                    profilePicture.CommandArgument = dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + dsFriends.Tables[0].Rows[i]["UserName"].ToString() + "\\Profile\\" + dsFriends.Tables[0].Rows[i]["ProfilePicture"].ToString()))
                    {
                        profilePicture.ImageUrl = "~/UserFiles/" + dsFriends.Tables[0].Rows[i]["UserName"].ToString() + "/Profile/" + dsFriends.Tables[0].Rows[i]["ProfilePicture"].ToString();
                        System.Drawing.Image theimg = System.Drawing.Image.FromFile(Server.MapPath(".") + "/UserFiles/" + dsFriends.Tables[0].Rows[i]["UserName"].ToString() +
                     "/Profile/" + dsFriends.Tables[0].Rows[i]["ProfilePicture"].ToString());

                        double width = double.Parse(theimg.Width.ToString());
                        double height = double.Parse(theimg.Height.ToString());

                        if (width > height)
                        {
                            if (width <= 50)
                            {

                            }
                            else
                            {
                                double dividor = double.Parse("50.00") / double.Parse(width.ToString());
                                width = double.Parse("50.00");
                                height = height * dividor;
                            }
                        }
                        else
                        {
                            if (width == height)
                            {
                                width = double.Parse("50.00");
                                height = double.Parse("50.00");
                            }
                            else
                            {
                                double dividor = double.Parse("50.00") / double.Parse(height.ToString());
                                height = double.Parse("50.00");
                                width = width * dividor;
                            }
                        }

                        profilePicture.Width = int.Parse((Math.Round(decimal.Parse(width.ToString()))).ToString());
                        profilePicture.Height = int.Parse((Math.Round(decimal.Parse(height.ToString()))).ToString());

                    }
                    else
                    {
                        profilePicture.ImageUrl = "~/NewImages/noAvatar_50x50_small.png";
                        profilePicture.Attributes.Add("onmouseover", "this.src='NewImages/noAvatar_50x50_smallhover.png'");
                        profilePicture.Attributes.Add("onmouseout", "this.src='NewImages/noAvatar_50x50_small.png'");
                    }
                    profilePicture.PostBackUrl = "~/" + dsFriends.Tables[0].Rows[i]["UserName"].ToString() + "_Friend";
                    //profilePicture.Click += new ImageClickEventHandler(ViewFriend);

                    MyFriendsPanel.Controls.Add(lit);
                    MyFriendsPanel.Controls.Add(profilePicture);
                    lit = new Literal();
                    lit.Text = "</td></tr></table><div align=\"center\">";
                    MyFriendsPanel.Controls.Add(lit);

                    HyperLink link = new HyperLink();
                    link.Text = "edit prefs";
                    link.CssClass = "PrefsLink";
                    link.ID = "editPrefs" + dsFriends.Tables[0].Rows[i]["UserName"].ToString();

                    Telerik.Web.UI.RadToolTip tip = new Telerik.Web.UI.RadToolTip();
                    tip.TargetControlID = "editPrefs" + dsFriends.Tables[0].Rows[i]["UserName"].ToString();
                    tip.ShowEvent = Telerik.Web.UI.ToolTipShowEvent.OnClick;
                    tip.Position = Telerik.Web.UI.ToolTipPosition.MiddleRight;
                    tip.RelativeTo = Telerik.Web.UI.ToolTipRelativeDisplay.Element;
                    tip.ManualClose = true;
                    tip.Attributes.Add("style", "z-index: 1000;");
                    tip.Skin = "Sunset";
                    tip.ID = "Tooltip" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();

                    UpdatePanel upP = new UpdatePanel();
                    upP.ID = "UpdatePanel" + dsFriends.Tables[0].Rows[i]["UserName"].ToString();
                    upP.UpdateMode = UpdatePanelUpdateMode.Conditional;

                    Literal tipLit = new Literal();
                    tipLit.Text = "<div align=\"center\" style=\"width: 300px !important; height: 254px !important;\">";
                    tipLit.Text += "<table width=\"100%\" cellspacing=\"0\" align=\"center\" style=\"font-family: "+
                        "Arial; font-size: 12px;   padding: 10px;\">";
                    tipLit.Text += "<tr><td  style=\"padding-bottom: 5px;\"> <span style=\"  " +
                        "font-size: 11px; font-weight: bold;\">Friend Options:</span></td></tr>";
                    tipLit.Text += "<tr><td align=\"center\" style=\"padding-bottom: 10px;\">" +
                        "<a class=\"NavyLink12\" onclick=\"OpenRemove('" +
                        dsFriends.Tables[0].Rows[i]["FriendID"].ToString() +
                        "')\">Remove Friend</a></td></tr>";
                    tipLit.Text += "<tr><td><span style=\"  " +
                        "font-size: 11px; font-weight: bold;\">Notify me when friend:</span></td></tr>";
                    upP.ContentTemplateContainer.Controls.Add(tipLit);
                    //tipLit.Text += "<tr><td align=\"center\" style=\"padding-top: 5px;\"><h2>adds an event to calendar</h2></td></tr>";
                    //tipLit.Text += "<tr><td align=\"center\">";

                    //upP.ContentTemplateContainer.Controls.Add(tipLit);
                    ImageButton imgB;
                    CheckBox check;
                    //if (emailPrefs.Contains("6"))
                    //{
                    //    tipLit = new Literal();
                    //    tipLit.Text = "<span style=\"color: #33a923;\">This preference is turned on for everyone.  If you want to set it just for this user, turn it off for everyone in 'Email Prefs'.</span></td></tr>";

                    //    upP.ContentTemplateContainer.Controls.Add(tipLit);
                    //}
                    //else
                    //{
                    //    tipLit = new Literal();
                    //    tipLit.Text = "<div style=\"width: 118px;\" class=\"topDiv\"><div>";

                    //    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    //    check = new CheckBox();
                    //    check.ID = "email" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    //    check.Text = "email";
                    //    if (emailFriendPrefs.Contains("0"))
                    //        check.Checked = true;

                    //    upP.ContentTemplateContainer.Controls.Add(check);

                    //    tipLit = new Literal();
                    //    tipLit.Text = "</div></div></td></tr>";
                    //    //    "<div style=\"float: left;\">";

                    //    //upP.ContentTemplateContainer.Controls.Add(tipLit);

                    //    //check = new CheckBox();
                    //    //check.ID = "text" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    //    //check.Text = "text";
                    //    //if (emailFriendPrefs.Contains("1"))
                    //    //    check.Checked = true;

                    //    //upP.ContentTemplateContainer.Controls.Add(check);

                    //    //tipLit = new Literal();
                    //    //tipLit.Text = "</div>"

                    //    upP.ContentTemplateContainer.Controls.Add(tipLit);
                    //}

                    //posts an event
                    tipLit = new Literal();
                    tipLit.Text = "<tr><td align=\"center\" style=\"padding-top: 5px;\"><h2>posts event/locale/adventure</h2></td></tr>";
                    if (emailPrefs.Contains("3"))
                    {
                        tipLit.Text += "<tr><td align=\"center\"><span style=\"color: #33a923;\">This preference is turned on for everyone.  If you want to set it just for this user, turn it off for everyone in 'Email Prefs'.</span></td></tr>";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);
                    }
                    else
                    {
                        tipLit.Text += "<tr><td align=\"center\"><div style=\"width: 125px;\" class=\"topDiv\"><div>";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);

                        check = new CheckBox();
                        check.ID = "email2" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                        check.Text = "email";
                        if (emailFriendPrefs.Contains("2"))
                            check.Checked = true;

                        upP.ContentTemplateContainer.Controls.Add(check);

                        tipLit = new Literal();
                        tipLit.Text = "</div></td></tr>";

                        //    "<div style=\"padding-right: 8px;float: left;\">";

                        //upP.ContentTemplateContainer.Controls.Add(tipLit);

                        //check = new CheckBox();
                        //check.ID = "text2" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                        //check.Text = "text";
                        //if (emailFriendPrefs.Contains("3"))
                        //    check.Checked = true;

                        //upP.ContentTemplateContainer.Controls.Add(check);

                        //tipLit = new Literal();
                        //tipLit.Text = "</div>"

                        upP.ContentTemplateContainer.Controls.Add(tipLit);
                    }

                    ////posts an ad
                    //tipLit = new Literal();
                    //tipLit.Text = "<tr><td align=\"center\" style=\"padding-top: 5px;\"><h2>posts an ad</h2></td></tr>";
                    //tipLit.Text += "<tr><td align=\"center\"><div style=\"width: 125px;\" class=\"topDiv\"><div style=\"float: left;padding-right: 8px;\">";

                    //upP.ContentTemplateContainer.Controls.Add(tipLit);

                    //check = new CheckBox();
                    //check.ID = "email3" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    //check.Text = "email";
                    //if (emailFriendPrefs.Contains("4"))
                    //    check.Checked = true;

                    //upP.ContentTemplateContainer.Controls.Add(check);

                    //tipLit = new Literal();
                    //tipLit.Text = "</div><div style=\"padding-right: 8px;float: left;\">";

                    //upP.ContentTemplateContainer.Controls.Add(tipLit);

                    //check = new CheckBox();
                    //check.ID = "text3" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    //check.Text = "text";
                    //if (emailFriendPrefs.Contains("5"))
                    //    check.Checked = true;

                    //upP.ContentTemplateContainer.Controls.Add(check);

                    //tipLit = new Literal();
                    //tipLit.Text = "</div></td></tr>";

                    //upP.ContentTemplateContainer.Controls.Add(tipLit);

                    //sends a Hippo Mail to you
                    tipLit = new Literal();
                    tipLit.Text = "<tr><td align=\"center\" style=\"padding-top: 5px;\"><h2>sends a Hippo Mail to you</h2></td></tr>";
                    tipLit.Text += "<tr><td align=\"center\">";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    if (emailPrefs.Contains("4"))
                    {
                        tipLit = new Literal();
                        tipLit.Text = "<span style=\"color: #33a923;\">This preference is on for everyone.  If you want to set it just for this user, turn it off for everyone in 'Email Prefs'.</span></td></tr>";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);
                    }
                    else
                    {
                        tipLit = new Literal();
                        tipLit.Text = "<div style=\"width: 125px;\" class=\"topDiv\"><div>";
                        upP.ContentTemplateContainer.Controls.Add(tipLit);

                        check = new CheckBox();
                        check.ID = "email4" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                        check.Text = "email";
                        if (emailFriendPrefs.Contains("6"))
                            check.Checked = true;

                        upP.ContentTemplateContainer.Controls.Add(check);

                        tipLit = new Literal();
                        tipLit.Text = "</div></td></tr>";

                        //    "<div style=\"padding-right: 8px;float: left;\">";

                        //upP.ContentTemplateContainer.Controls.Add(tipLit);

                        //check = new CheckBox();
                        //check.ID = "text4" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                        //check.Text = "text";
                        //if (emailFriendPrefs.Contains("7"))
                        //    check.Checked = true;

                        //upP.ContentTemplateContainer.Controls.Add(check);

                        //tipLit = new Literal();
                        //tipLit.Text = "</div>"

                        upP.ContentTemplateContainer.Controls.Add(tipLit);
                    }

                    //shares event/venue/ad with you
                    tipLit = new Literal();
                    tipLit.Text = "<tr><td align=\"center\" style=\"padding-top: 5px;\"><h2>shares event/locale/adventure with you</h2></td></tr>";
                    tipLit.Text += "<tr><td align=\"center\">";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    if (emailPrefs.Contains("9"))
                    {
                        tipLit = new Literal();
                        tipLit.Text = "<span style=\"color: #33a923;\">This preference is turned on for everyone.  If you want to set it just for this user, turn it off for everyone in 'Email Prefs'.</span></td></tr>";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);
                    }
                    else
                    {
                        tipLit = new Literal();
                        tipLit.Text = "<div style=\"width: 125px;\" class=\"topDiv\"><div>";
                        upP.ContentTemplateContainer.Controls.Add(tipLit);

                        check = new CheckBox();
                        check.ID = "email5" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                        check.Text = "email";
                        if (emailFriendPrefs.Contains("8"))
                            check.Checked = true;

                        upP.ContentTemplateContainer.Controls.Add(check);

                        tipLit = new Literal();
                        tipLit.Text = "</div></td></tr>";

                        //"<div style=\"padding-right: 8px;float: left;\">";

                        //upP.ContentTemplateContainer.Controls.Add(tipLit);

                        //check = new CheckBox();
                        //check.Text = "text";
                        //check.ID = "text5" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                        //if (emailFriendPrefs.Contains("9"))
                        //    check.Checked = true;

                        //upP.ContentTemplateContainer.Controls.Add(check);

                        //tipLit = new Literal();
                        //tipLit.Text = "</div>"

                        upP.ContentTemplateContainer.Controls.Add(tipLit);

                    }
                    tipLit = new Literal();
                    tipLit.Text = "</table><div style=\"color: red;float: left;padding-top: 10px;\">";
                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    Label labl = new Label();
                    labl.ID = "ErrorLabel" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();

                    upP.ContentTemplateContainer.Controls.Add(labl);

                    tipLit = new Literal();
                    tipLit.Text = "</div><div style=\"float: right;padding-top: 10px;\">";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    ASP.controls_bluebutton_ascx btn = new ASP.controls_bluebutton_ascx();
                    btn.BUTTON_TEXT = "Save";
                    btn.COMMAND_ARGS = dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    btn.CLIENT_CLICK = "javascript:CloseToolTip();";
                    btn.SERVER_CLICK += PrefsSave;
                    btn.ID = "Save" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    btn.WIDTH = "55px";

                    upP.ContentTemplateContainer.Controls.Add(btn);

                    tipLit = new Literal();
                    tipLit.Text = "</div></div>";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    tip.Controls.Add(upP);

                    MyFriendsPanel.Controls.Add(link);
                    MyFriendsPanel.Controls.Add(tip);

                    lit = new Literal();
                    lit.Text = "</div></div>";
                    MyFriendsPanel.Controls.Add(lit);
                }
            }

        NumFriendsLabel.Text = friendcount.ToString();
        LinkButton friendLink = new LinkButton();
        friendLink.Text = "Add Friends";
    }
Example #7
0
        private void RenderCommunity(Panel pnl, DataObjectCommunity item)
        {
            PlaceHolder ph = new PlaceHolder();

            ph.Controls.Add(new LiteralControl("<div class=\"membership\">"));
            ph.Controls.Add(new LiteralControl("<div class=\"\">"));
            ph.Controls.Add(new LiteralControl("<div class=\"\">"));
            ph.Controls.Add(new LiteralControl(string.Format("<img src='{0}{1}' title='{2}' class='CSB_img105' />", _4screen.CSB.Common.SiteConfig.MediaDomainName, item.GetImage(PictureVersion.XS), item.Title)));
            ph.Controls.Add(new LiteralControl("</div>"));
            ph.Controls.Add(new LiteralControl("</div>"));

            // set community/Profillink
            string CommTitle = item.Title.CropString(14);

            ph.Controls.Add(new LiteralControl(string.Format(@"<div class=""""><a class="""" href=""/Default.aspx?CN={0}"" title=""Gehe zu Community: {2}"">{1}</a></div>", item.CommunityID, CommTitle, item.Title)));

            string strTmp = item.Nickname;

            if (strTmp.Length > 9)
            {
                strTmp = strTmp.Substring(0, 7) + "..";
            }

            if (Guid.Equals(UserProfile.Current.UserId, item.UserID.Value))
            {
                ph.Controls.Add(new LiteralControl(string.Format(@"<div class="""" title=""{2}: {1}"">{3}: {0}</div>", strTmp, item.Nickname, language.GetString("LableCratedBy"), language.GetString("LableFrom"))));
            }
            else
            {
                ph.Controls.Add(new LiteralControl(string.Format(@"<div class="""">von: <a class="""" href=""{0}{1}"" title=""{3}: {1}"">{2}</a></div>", Constants.Links["NICE_LINK_TO_USER_DETAIL"].Url, item.Nickname, strTmp, language.GetString("LableCratedBy"))));
            }
            ph.Controls.Add(new LiteralControl(@"<div class="""">"));
            ph.Controls.Add(new LiteralControl(string.Format(@"<a id=""SpnInf_{0}"" href=""javascript:void(0)"" class="""">{1}</a>", item.ObjectID, language.GetString("LableInfo"))));
            ph.Controls.Add(new LiteralControl("<br/>"));

            Telerik.Web.UI.RadToolTip tooltip = new Telerik.Web.UI.RadToolTip();
            tooltip.TargetControlID     = string.Format(@"SpnInf_{0}", item.ObjectID);
            tooltip.IsClientID          = true;
            tooltip.EnableEmbeddedSkins = false;
            tooltip.ShowEvent           = Telerik.Web.UI.ToolTipShowEvent.OnClick;
            tooltip.Position            = Telerik.Web.UI.ToolTipPosition.TopRight;
            tooltip.RelativeTo          = Telerik.Web.UI.ToolTipRelativeDisplay.Element;
            tooltip.HideEvent           = Telerik.Web.UI.ToolTipHideEvent.LeaveToolTip;
            ObjectDetailsSmall objectDetailsSmall = this.LoadControl("~/UserControls/ObjectDetailsSmall.ascx") as ObjectDetailsSmall;

            objectDetailsSmall.DataObject = item;
            Literal literal = new Literal();

            literal.Text = objectDetailsSmall.GetContent();
            tooltip.Controls.Add(literal);
            ph.Controls.Add(tooltip);

            //Löschen
            if (item.UserID.Value != UserProfile.Current.UserId)
            {
                LinkButton btnRem = new LinkButton();
                btnRem.Text            = language.GetString("CommandMembershipRelease");
                btnRem.CssClass        = "";
                btnRem.CommandArgument = item.CommunityID.Value.ToString();
                btnRem.Click          += new EventHandler(btnRem_Click);
                ph.Controls.Add(btnRem);
                ph.Controls.Add(new LiteralControl("<br/>"));
            }
            else
            {
                ph.Controls.Add(new LiteralControl(@"<span class="""">&nbsp;</span><br/>"));
            }

            ph.Controls.Add(new LiteralControl(string.Format(@"</div>")));
            ph.Controls.Add(new LiteralControl(@"</div>"));
            pnl.Controls.Add(ph);
        }
    protected void LoadFriends()
    {
        HttpCookie cookie = Request.Cookies["BrowserDate"];
        ClearMessage();
        Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));
        DataSet dsFriends = dat.GetData("SELECT * FROM User_Friends UF, Users U WHERE UF.FriendID=U.User_ID AND UF.UserID=" + Session["User"].ToString());
        Panel FriendPanel = (Panel)Tab1.FindControl("FriendPanel");

        //Search for what your friends did in the past 30 days.
        Panel WhatMyFriendsDidPanel = (Panel)Tab2.FindControl("WhatMyFriendsDidPanel");
        DataView dvFriends = new DataView(dsFriends.Tables[0], "", "", DataViewRowState.CurrentRows);

        if (dvFriends.Count > 0)
        {
            //Added Events to calendar
            DataView dvEvents = dat.GetDataDV("SELECT U.UserName,  U.ProfilePicture, UC.DateAdded AS THE_DATE, 'Added the event <a class=AddLink target=_blank href=' + dbo.MAKENICENAME(E.Header) + '_' + CONVERT(NVARCHAR,E.ID)+'_Event>'+ CASE WHEN LEN(E.Header) > 20 THEN SUBSTRING(E.Header, 0, 20) + '...' ELSE E.Header END +'</a>' AS HEADER " +
                "FROM User_Friends UF, Users U, User_Calendar UC, Events E WHERE UF.UserID=" +
                Session["User"].ToString() + " AND U.User_ID=UF.FriendID AND E.ID=UC.EventID " +
                "AND UF.FriendID=UC.UserID AND UC.DateAdded > CONVERT(DATETIME, '" +
                DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A",
                ":")).AddDays(double.Parse("-10")).Date.ToString() + "') ORDER BY THE_DATE DESC");

            //Added Group Events to Calendar
            DataView dvGroupEvents = dat.GetDataDV("SELECT U.UserName, U.ProfilePicture, UGEC.DateAdded AS THE_DATE, " +
                "'Added the group event <a target=_blank class=AddLink href='+ " +
                "dbo.MAKENICENAME(GE.Name)+'_'+CONVERT(NVARCHAR, GEO.ID)+'_'+CONVERT(NVARCHAR,GE.ID)+'_GroupEvent>'+ " +
                "CASE WHEN LEN(GE.Name) " +
                "> 20 THEN SUBSTRING(GE.Name, 0, 20) + '...' ELSE GE.Name END +'</a>' AS HEADER " +
                " FROM User_GroupEvent_Calendar UGEC, GroupEvents GE, GroupEvent_Occurance GEO, User_Friends UF, Users U " +
                "WHERE GE.EventType=1 AND GEO.GroupEventID=GE.ID AND UGEC.GroupEventID=GE.ID AND GE.ID=UGEC.GroupEventID " +
                " AND UF.UserID=" + Session["User"].ToString() + " AND U.User_ID=UF.FriendID AND " +
                "UF.FriendID=UGEC.UserID AND UGEC.DateAdded > CONVERT(DATETIME, '" +
                DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A",
                ":")).AddDays(double.Parse("-10")).Date.ToString() + "')  ORDER BY THE_DATE DESC");

            dvEvents = MergeDVThreeCol(dvEvents, dvGroupEvents);

            //Added Group Events to Calendar
            DataView dvGroupEvents2 = dat.GetDataDV("SELECT U.UserName, U.ProfilePicture, GEM.DateAdded AS THE_DATE, " +
                "'Added the group event <a target=_blank class=AddLink href='+ " +
                "dbo.MAKENICENAME(GE.Name)+'_'+CONVERT(NVARCHAR, GEO.ID)+'_'+CONVERT(NVARCHAR,GE.ID)+'_GroupEvent>'+ " +
                "CASE WHEN LEN(GE.Name) " +
                "> 20 THEN SUBSTRING(GE.Name, 0, 20) + '...' ELSE GE.Name END +'</a>' AS HEADER " +
                " FROM GroupEvent_Members GEM, GroupEvents GE, GroupEvent_Occurance GEO, User_Friends UF, Users U " +
                "WHERE GE.EventType=1 AND GEO.GroupEventID=GE.ID AND GEM.GroupEventID=GE.ID AND GE.ID=GEM.GroupEventID " +
                " AND UF.UserID=" + Session["User"].ToString() + " AND U.User_ID=UF.FriendID AND " +
                "UF.FriendID=GEM.UserID AND GEM.DateAdded > CONVERT(DATETIME, '" +
                DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A",
                ":")).AddDays(double.Parse("-10")).Date.ToString() + "')  ORDER BY THE_DATE DESC");

            dvEvents = MergeDVThreeCol(dvEvents, dvGroupEvents2);

            //Added Favorite Venues
            DataView dvVenues = dat.GetDataDV("SELECT U.UserName, UV.DateAdded AS THE_DATE, 'Added a favorite venue <a class=AddLink target=_blank href='+dbo.MAKENICENAME(V.Name)+'_'+CONVERT(NVARCHAR,V.ID)+'_Venue>'+ CASE WHEN LEN(V.Name) > 20 THEN SUBSTRING(V.Name, 0, 20) + '...' ELSE V.Name END + +'</a>' AS HEADER " +
                "FROM User_Friends UF, Users U, UserVenues UV, Venues V WHERE UF.UserID=" +
                Session["User"].ToString() + " AND V.ID=UV.VenueID AND U.User_ID=UF.FriendID AND UF.FriendID=UV.UserID AND UV.DateAdded > CONVERT(DATETIME, '" +
                DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).AddDays(double.Parse("-10")).Date.ToString() + "')  ORDER BY THE_DATE DESC");

            //Added Event Comments
            DataView dvComments = dat.GetDataDV("SELECT U.UserName, U.ProfilePicture,  C.BlogDate AS THE_DATE, 'Posted a comment:  " +
                "<a class=AddGreenLink target=_blank href=' + dbo.MAKENICENAME(E.Header) + '_' + CONVERT(NVARCHAR,E.ID)+'_Event>'+CASE WHEN LEN(C.Comment) <= 27 THEN C.Comment ELSE SUBSTRING(C.Comment, 0, 27) + '...' END +'</a>' AS HEADER " +
                "FROM User_Friends UF, Users U, Comments C, Events E WHERE UF.UserID=" +
                Session["User"].ToString() + " AND U.User_ID=UF.FriendID AND C.BlogID=E.ID "+
                "AND UF.FriendID=C.UserID AND C.BlogDate > CONVERT(DATETIME, '" +
                DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A",
                ":")).AddDays(double.Parse("-10")).Date.ToString() + "')  ORDER BY THE_DATE DESC");

            //Added Venue Comments
            DataView dvCommentsVenue = dat.GetDataDV("SELECT U.UserName, U.ProfilePicture,  VC.CommentDate AS THE_DATE, 'Posted a comment: " +
                "<a class=AddGreenLink target=_blank href='+dbo.MAKENICENAME(V.Name)+'_'+CONVERT(NVARCHAR,V.ID)+'_Venue>'+CASE WHEN LEN(VC.Comment) <= 27 THEN VC.Comment ELSE SUBSTRING(VC.Comment, 0, 27) + '...' END +'</a>' AS HEADER " +
                "FROM User_Friends UF, Users U, Venue_Comments VC, Venues V WHERE UF.UserID=" +
                Session["User"].ToString() + " AND U.User_ID=UF.FriendID AND V.ID=VC.VenueID " +
                "AND UF.FriendID=VC.UserID AND VC.CommentDate > CONVERT(DATETIME, '" +
                DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A",
                ":")).AddDays(double.Parse("-10")).Date.ToString() + "')  ORDER BY THE_DATE DESC");

            //Added Group Thread Comments
            DataView dvGroupThreadComments = dat.GetDataDV("SELECT U.UserName, U.ProfilePicture, GTC.PostedDate AS THE_DATE, " +
                "'Posted a comment on group <a target=_blank class=AddGreenLink href='+ " +
                "dbo.MAKENICENAME(G.Header)+'_'+CONVERT(NVARCHAR,G.ID)+'_Group>'+ " +
                "CASE WHEN LEN(G.Header) " +
                "> 20 THEN SUBSTRING(G.Header, 0, 20) + '...' ELSE G.Header END +'</a>' AS HEADER " +
                " FROM  GroupThreads_Comments GTC, Groups G, GroupThreads GT, User_Friends UF, Users U " +
                "WHERE G.isPrivate='False' AND GT.ID=GTC.ThreadID AND GT.GroupID=G.ID AND UF.UserID=" + Session["User"].ToString() + " AND U.User_ID=UF.FriendID AND " +
                "UF.FriendID=GTC.UserID AND GTC.PostedDate > CONVERT(DATETIME, '" +
                DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A",
                ":")).AddDays(double.Parse("-10")).Date.ToString() + "')  ORDER BY THE_DATE DESC");

            dvComments = MergeDVThreeCol(dvComments, dvGroupThreadComments);

            //Posted Events
            DataView dvPostedEvents = dat.GetDataDV("SELECT U.UserName, U.ProfilePicture, E.PostedOn AS THE_DATE, "+
                "'Posted the event <a class=AddOrangeLink target=_blank href=' + dbo.MAKENICENAME(E.Header) + '_' + CONVERT(NVARCHAR,E.ID)+'_Event>'+ CASE WHEN LEN(E.Header) > 20 THEN SUBSTRING(E.Header, 0, 20) + '...' ELSE E.Header END +'</a>'AS HEADER " +
                "FROM User_Friends UF, Users U, Events E WHERE UF.UserID=" +
                Session["User"].ToString() + " AND U.User_ID=UF.FriendID AND U.UserName=E.UserName "+
            "AND E.PostedOn > CONVERT(DATETIME, '" +
                DateTime.Parse(cookie.Value.ToString().Replace("%20",
                " ").Replace("%3A", ":")).AddDays(double.Parse("-10")).Date.ToString() + "')  ORDER BY THE_DATE DESC");

            //Posted Venues
            DataView dvPostedVenues = dat.GetDataDV("SELECT U.UserName,  U.ProfilePicture, V.PostedOn AS THE_DATE, "+
                "'Posted the venue <a class=AddOrangeLink target=_blank href='+ dbo.MAKENICENAME(V.Name)+'_'+CONVERT(NVARCHAR,V.ID)+'_Venue>'+ CASE WHEN LEN(V.Name) > 20 THEN SUBSTRING(V.Name, 0, 20) + '...' ELSE V.Name END +'</a>' AS HEADER " +
                "FROM User_Friends UF, Users U, Venues V WHERE UF.UserID=" +
                Session["User"].ToString() + " AND U.User_ID=UF.FriendID AND UF.FriendID=V.CreatedByUser AND V.PostedOn > CONVERT(DATETIME, '" +
                DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).AddDays(double.Parse("-10")).Date.ToString() + "')  ORDER BY THE_DATE DESC");

            //Posted Ads
            DataView dvPostedAds = dat.GetDataDV("SELECT U.UserName,  U.ProfilePicture, CONVERT(DATETIME,A.DateAdded) AS THE_DATE, "+
                "'Posted the ad <a target=_blank class=AddOrangeLink href='+ dbo.MAKENICENAME(A.Header)+'_'+CONVERT(NVARCHAR,A.Ad_ID)+'_Ad>'+ CASE WHEN LEN(A.Header) > 20 THEN SUBSTRING(A.Header, 0, 20) + '...' ELSE A.Header END +'</a>' AS HEADER " +
                "FROM User_Friends UF, Users U, Ads A WHERE UF.UserID=" +
                Session["User"].ToString() + " AND U.User_ID=UF.FriendID AND UF.FriendID=A.User_ID AND A.DateAdded > CONVERT(DATETIME, '" +
                DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")).AddDays(double.Parse("-10")).Date.ToString() + "')  ORDER BY THE_DATE DESC");

            //Posted Group Events
            DataView dvGroupEventsPosts = dat.GetDataDV("SELECT U.UserName, U.ProfilePicture, GE.LastEdit AS THE_DATE, " +
                "'Posted/Edited the group event <a target=_blank class=AddOrangeLink href='+ " +
                "dbo.MAKENICENAME(GE.Name)+'_'+CONVERT(NVARCHAR,GEO.ID)+'_'+CONVERT(NVARCHAR,GE.ID)+'_GroupEvent>'+ " +
                "CASE WHEN LEN(GE.Name) " +
                "> 20 THEN SUBSTRING(GE.Name, 0, 20) + '...' ELSE GE.Name END +'</a>' AS HEADER " +
                ",G.ID AS GID, GE.ID AS TheID, " +
                " 'GEP' AS Type, GEO.ID AS GEOID " +
                " FROM GroupEvent_Occurance GEO, GroupEvents GE, Groups G, User_Friends UF, Users U " +
                "WHERE GEO.GroupEventID=GE.ID AND GE.LastEdit IS NOT NULL AND G.ID=GE.GroupID AND GE.EventType=1 " +
                " AND UF.UserID=" + Session["User"].ToString() + " AND U.User_ID=UF.FriendID AND " +
                "UF.FriendID=GE.LastEditBy AND GE.LastEdit > CONVERT(DATETIME, '" +
                DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A",
                ":")).AddDays(double.Parse("-10")).Date.ToString() + "')  ORDER BY THE_DATE DESC");

            //Posted Groups
            DataView dvGroupPosts = dat.GetDataDV("SELECT U.UserName, U.ProfilePicture, G.LastEditOn AS THE_DATE, " +
                "'Posted/Edited the group <a target=_blank class=AddOrangeLink href='+ " +
                "dbo.MAKENICENAME(G.Header)+'_'+CONVERT(NVARCHAR,G.ID)+'_Group>'+ " +
                "CASE WHEN LEN(G.Header) " +
                "> 20 THEN SUBSTRING(G.Header, 0, 20) + '...' ELSE G.Header END +'</a>' AS HEADER "+
                " FROM Groups G, User_Friends UF, Users U " +
                "WHERE G.LastEditOn IS NOT NULL " +
                " AND G.isPrivate='False' AND UF.UserID=" + Session["User"].ToString() + " AND U.User_ID=UF.FriendID AND " +
                "UF.FriendID=G.LastEditBy AND G.LastEditOn > CONVERT(DATETIME, '" +
                DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A",
                ":")).AddDays(double.Parse("-10")).Date.ToString() + "')  ORDER BY THE_DATE DESC");

            DataView dv = MergeDVThreeCol(MergeDVThreeCol(MergeDVThreeCol(MergeDVThreeCol(dvPostedEvents,
                dvPostedVenues), dvPostedAds), dvGroupEventsPosts), dvGroupPosts);

            string friendImg = "";
            string strFill = "";

            Telerik.Web.UI.RadRotatorItem rItem = new Telerik.Web.UI.RadRotatorItem();
            Literal hiddenPostingLiteral = new Literal();

            if (dv.Count != 0)
            {
                PostingLiteral.Text = "<ul style=\"margin-bottom: 0px;font-family: Arial; font-size: 12px; color: #ff6b09;padding-left:0; \">";
                int count = 0;

                dv.Sort = "THE_DATE DESC";

                for (int i = 0; i < dv.Count;i++ )
                {
                    string rowHeader = dv[i]["HEADER"].ToString();

                    if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + dv[i]["UserName"].ToString() +
                        "\\Profile\\" + dv[i]["ProfilePicture"].ToString()))
                    {
                        friendImg = "UserFiles/" + dv[i]["UserName"].ToString() + "/Profile/" + dv[i]["ProfilePicture"].ToString();
                        strFill = "";
                    }
                    else
                    {
                        friendImg = "image/noAvatar_50x50_small.png";
                        strFill = "onmouseover=\"this.src='NewImages/noAvatar_50x50_smallhover.png'\"" +
                            "onmouseout=\"this.src='image/noAvatar_50x50_small.png'\" ";
                    }
                    if (count < 3)
                    {
                        PostingLiteral.Text += "<li style=\"background-color: #1b1b1b;\">";
                        PostingLiteral.Text += "<div style=\"line-height: 12px;color: #cccccc; min-height: 54px;\">" +
                            "<a href=\"" + dv[i]["UserName"].ToString() + "_Friend\"><img " + strFill + " style=\" border: 0;float: left;padding-right: 7px; padding-bottom: 2px;\" " +
                            "src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a>";
                        PostingLiteral.Text += "<span style=\"color: #ff6b09; font-weight: bold;\"><a class=\"AddOrangeLink\" href=\"" + dv[i]["UserName"].ToString() + "_Friend\">" +
                            dv[i]["UserName"].ToString() + "</a></span> " + rowHeader + " on " + DateTime.Parse(dv[i]["THE_DATE"].ToString()).ToShortDateString() + "</div>";
                        PostingLiteral.Text += "</li>";
                        if (count == dv.Count - 1 || count == 2)
                            PostingLiteral.Text += "</ul>";
                    }
                    else if (count == 3)
                    {
                        PostingLiteral.Text += "<div style=\"cursor: pointer;margin-top: -10px;float: right;font-family: Arial; font-size: 12px; color: #ff6b09;padding-left:0; font-weight: bold;\" onclick=\"OpenPostingDiv();\">more..</div>";
                    }

                    hiddenPostingLiteral.Text += "<div style=\"height: 53px;line-height: 12px;font-family: Arial; font-size: 12px; color: #cccccc;padding-left:0;float: left; padding-right: 5px;width: 200px;\">";

                    hiddenPostingLiteral.Text += "<div style=\"color: #cccccc; padding-left: 5px; padding-top: 2px;\">" +
                        "<a href=\"" + dv[i]["UserName"].ToString() + "_Friend\"><img " + strFill + " style=\" border: 0;float: left;padding-right: 7px;\" " +
                        "src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a>";
                    hiddenPostingLiteral.Text += "<span style=\"color: #ff6b09; font-weight: bold;\"><a class=\"AddOrangeLink\" href=\"" + dv[i]["UserName"].ToString() + "_Friend\">" +
                        dv[i]["UserName"].ToString() + "</a></span> " + rowHeader + " on " + DateTime.Parse(dv[i]["THE_DATE"].ToString()).ToShortDateString() + "</div></div>";
                    count++;

                    if (count % 9 == 0)
                    {
                        rItem.Height = 159;
                        rItem.Controls.Add(hiddenPostingLiteral);
                        PostingRotator.Items.Add(rItem);
                        rItem = new Telerik.Web.UI.RadRotatorItem();
                        hiddenPostingLiteral = new Literal();
                    }
                }
                if (dv.Count % 9 != 0)
                {
                    rItem.Height = 159;
                    rItem.Controls.Add(hiddenPostingLiteral);
                    PostingRotator.Items.Add(rItem);
                }

                //PostingLiteral.Text = "<div onmouseover=\"OpenPostingDiv()\">" + PostingLiteral.Text + "</div>";

            }
            else
            {
                PostingLiteral.Text = "<div  style=\"padding-top: 10px;font-family: Arial; font-size: 12px; color: #ff6b09;padding-left:0; \">Your friends haven't had any Posting Action in 10 days.</div>";
            }

            if (dvEvents.Count != 0)
            {
                rItem = new Telerik.Web.UI.RadRotatorItem();
                hiddenPostingLiteral = new Literal();

                EventGoingLiteral.Text = "<ul style=\"margin-bottom: 0px;font-family: Arial; font-size: 12px; color: #1fb6e7;padding-left:0; \">";
                int count = 0;

                dvEvents.Sort = "THE_DATE DESC";

                foreach (DataRowView row in dvEvents)
                {
                    string rowHeader = row["HEADER"].ToString();

                    if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + row["UserName"].ToString() +
                        "\\Profile\\" + row["ProfilePicture"].ToString()))
                    {
                        friendImg = "UserFiles/" + row["UserName"].ToString() + "/Profile/" + row["ProfilePicture"].ToString();
                        strFill = "";
                    }
                    else
                    {
                        friendImg = "image/noAvatar_50x50_small.png";
                        strFill = "onmouseover=\"this.src='NewImages/noAvatar_50x50_smallhover.png'\"" +
                            "onmouseout=\"this.src='image/noAvatar_50x50_small.png'\" ";
                    }
                    if (count < 3)
                    {
                        EventGoingLiteral.Text += "<li style=\"background-color: #1b1b1b;\">";
                        EventGoingLiteral.Text += "<div style=\"line-height: 12px;color: #cccccc; min-height: 54px;\">" +
                            "<a href=\"" + row["UserName"].ToString() + "_Friend\"><img " + strFill + " style=\" border: 0;float: left;padding-right: 7px; padding-bottom: 2px;\" " +
                            "src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a>";
                        EventGoingLiteral.Text += "<span style=\"color: #1fb6e7; font-weight: bold;\"><a class=\"AddLink\" href=\"" + row["UserName"].ToString() + "_Friend\">" +
                            row["UserName"].ToString() + "</a></span> " + rowHeader + " on " + DateTime.Parse(row["THE_DATE"].ToString()).ToShortDateString() + "</div>";
                        EventGoingLiteral.Text += "</li>";

                        if (count == dvEvents.Count - 1 || count == 2)
                            EventGoingLiteral.Text += "</ul>";
                    }
                    else if (count == 3)
                    {
                        EventGoingLiteral.Text += "<div style=\"cursor: pointer;margin-top: -10px;float: right;font-family: Arial; font-size: 12px; color: #1fb6e7;padding-left:0; font-weight: bold;\" onclick=\"OpenEventDiv();\">more..</div>";
                    }

                    hiddenPostingLiteral.Text += "<div style=\"height: 53px;line-height: 12px;font-family: Arial; font-size: 12px; color: #cccccc;padding-left:0;float: left; padding-right: 5px;width: 200px;\">";

                    hiddenPostingLiteral.Text += "<div style=\"color: #cccccc; padding-left: 5px; padding-top: 2px;\">" +
                        "<a href=\"" + row["UserName"].ToString() + "_Friend\"><img " + strFill + " style=\" border: 0;float: left;padding-right: 7px;\" " +
                        "src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a>";
                    hiddenPostingLiteral.Text += "<span style=\"color: #1fb6e7; font-weight: bold;\"><a class=\"AddLink\" href=\"" + row["UserName"].ToString() + "_Friend\">" +
                        row["UserName"].ToString() + "</a></span> " + rowHeader + " on " + DateTime.Parse(row["THE_DATE"].ToString()).ToShortDateString() + "</div></div>";
                    count++;

                    if (count % 9 == 0)
                    {
                        rItem.Height = 159;
                        rItem.Controls.Add(hiddenPostingLiteral);
                        EventRotator.Items.Add(rItem);
                        rItem = new Telerik.Web.UI.RadRotatorItem();
                        hiddenPostingLiteral = new Literal();
                    }
                }
                if (dvEvents.Count % 9 != 0)
                {
                    rItem.Height = 159;
                    rItem.Controls.Add(hiddenPostingLiteral);
                    EventRotator.Items.Add(rItem);
                }
                EventGoingLiteral.Text += "</ul>";
            }
            else
            {
                EventGoingLiteral.Text = "<div  style=\"padding-top: 10px;font-family: Arial; font-size: 12px; color: " +
                    "#1fb6e7;padding-left:0; \">Your friends haven't had any Event Going Action in 10 days.</div>";
            }

            DataView dvCommentsFinal = MergeDVThreeCol(dvComments, dvCommentsVenue);

            if (dvCommentsFinal.Count != 0)
            {
                rItem = new Telerik.Web.UI.RadRotatorItem();
                hiddenPostingLiteral = new Literal();

                CommentingLiteral.Text = "<ul style=\"margin-bottom: 0px;font-family: Arial; font-size: 12px; color: #568301;padding-left:0; \">";
                int count = 0;
                dvCommentsFinal.Sort = "THE_DATE DESC";
                foreach (DataRowView row in dvCommentsFinal)
                {
                    string rowHeader = row["HEADER"].ToString();

                    if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + row["UserName"].ToString() +
                        "\\Profile\\" + row["ProfilePicture"].ToString()))
                    {
                        friendImg = "UserFiles/" + row["UserName"].ToString() + "/Profile/" + row["ProfilePicture"].ToString();
                        strFill = "";
                    }
                    else
                    {
                        friendImg = "image/noAvatar_50x50_small.png";
                        strFill = "onmouseover=\"this.src='NewImages/noAvatar_50x50_smallhover.png'\"" +
                            "onmouseout=\"this.src='image/noAvatar_50x50_small.png'\" ";
                    }
                    if (count < 3)
                    {
                        CommentingLiteral.Text += "<li style=\"background-color: #1b1b1b;\">";
                        CommentingLiteral.Text += "<div style=\"line-height: 12px;color: #cccccc; min-height: 54px;\">" +
                            "<a href=\"" + row["UserName"].ToString() + "_Friend\"><img " + strFill + " style=\" border: 0;float: left;padding-right: 7px; padding-bottom: 2px;\" " +
                            "src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a>";
                        CommentingLiteral.Text += "<span style=\"color: #628e02; font-weight: bold;\"></span> " + rowHeader + " on " + DateTime.Parse(row["THE_DATE"].ToString()).ToShortDateString() + "</div>";
                        CommentingLiteral.Text += "</li>";

                        if (count == dvCommentsFinal.Count - 1 || count == 2)
                            CommentingLiteral.Text += "</ul>";
                    }
                    else if (count == 3)
                    {
                        CommentingLiteral.Text += "<div style=\"cursor: pointer;margin-top: -10px;float: right;font-family: Arial; font-size: 12px; color: #628e02;padding-left:0; font-weight: bold;\" onclick=\"OpenCommentDiv();\">more..</div>";
                    }

                    hiddenPostingLiteral.Text += "<div style=\"height: 53px;line-height: 12px;font-family: Arial; font-size: 12px; color: #cccccc;padding-left:0;float: left; padding-right: 5px;width: 200px;\">";

                    hiddenPostingLiteral.Text += "<div style=\"color: #cccccc; padding-left: 5px; padding-top: 2px;\">" +
                        "<a href=\"" + row["UserName"].ToString() + "_Friend\"><img " + strFill + " style=\" border: 0;float: left;padding-right: 7px;\" " +
                        "src=\"" + friendImg + "\" width=\"50px\" height=\"50px\" /></a>";
                    hiddenPostingLiteral.Text += "<span style=\"color: #628e02; font-weight: bold;\"><a class=\"AddGreenLink\" href=\"" + row["UserName"].ToString() + "_Friend\">" +
                        row["UserName"].ToString() + "</a></span> " + rowHeader + " on " + DateTime.Parse(row["THE_DATE"].ToString()).ToShortDateString() + "</div></div>";
                    count++;

                    if (count % 9 == 0)
                    {
                        rItem.Height = 159;
                        rItem.Controls.Add(hiddenPostingLiteral);
                        CommentRotator.Items.Add(rItem);
                        rItem = new Telerik.Web.UI.RadRotatorItem();
                        hiddenPostingLiteral = new Literal();
                    }
                }
                if (dvCommentsFinal.Count % 9 != 0)
                {
                    rItem.Height = 159;
                    rItem.Controls.Add(hiddenPostingLiteral);
                    CommentRotator.Items.Add(rItem);
                }

                CommentingLiteral.Text += "</ul>";
            }
            else
            {
                CommentingLiteral.Text = "<div  style=\"padding-top: 10px;font-family: Arial; font-size: 12px; color: " +
                    "#568301;padding-left:0; \">Your friends haven't had any Commenting Action in 10 days.</div>";
            }

        //    DataView dvFinal = MergeDVThreeCol(MergeDVThreeCol(MergeDVThreeCol(MergeDVThreeCol(MergeDVThreeCol(MergeDVThreeCol(dvEvents,
        //        dvVenues), dvComments), dvPostedEvents), dvPostedVenues), dvPostedAds), dvCommentsVenue);

        //    dvFinal.Sort = "THE_DATE DESC";
        //    Label lab;
        //    if (dvFinal.Count != 0)
        //    {
        //        Literal lit = new Literal();
        //        lit.Text = "<ul style=\"color: #1fb6e7;margin: 0;margin-bottom:5px;margin-top:5px;padding-left:20px;\" color=#1fb6e7>";
        //        WhatMyFriendsDidPanel.Controls.Add(lit);
        //        for (int i = 0; i < dvFinal.Count; i++)
        //        {
        //            lab = new Label();
        //            lab.Text = "<li color=#1fb6e7><span class=\"AspLabel\"><span class=\"AddWhiteLink\">" + dvFinal[i]["UserName"].ToString() + "</span> " + dvFinal[i]["HEADER"].ToString() +
        //                " on " + dvFinal[i]["THE_DATE"].ToString() + "</span></li>";
        //            WhatMyFriendsDidPanel.Controls.Add(lab);
        //        }
        //        lit = new Literal();
        //        lit.Text = "</ul>";
        //        WhatMyFriendsDidPanel.Controls.Add(lit);
        //    }
        //    else
        //    {
        //        WhatMyFriendsDidPanel.Visible = false;
        //    }
        }
        else
        {
            PostingLiteral.Text = "<div  style=\"padding-top: 10px;font-family: Arial; font-size: 12px; color: #ff6b09;padding-left:0; \">Your friends haven't had any Posting Action in 10 days.</div>";
            CommentingLiteral.Text = "<div  style=\"padding-top: 10px;font-family: Arial; font-size: 12px; color: " +
        "#568301;padding-left:0; \">Your friends haven't had any Commenting Action in 10 days.</div>";
            EventGoingLiteral.Text = "<div  style=\"padding-top: 10px;font-family: Arial; font-size: 12px; color: " +
                "#1fb6e7;padding-left:0; \">Your friends haven't had any Event Going Action in 10 days.</div>";
            WhatMyFriendsDidPanel.Visible = false;
            MyFriendsPanel.Visible = false;
        }

        DataView dvUser = dat.GetDataDV("SELECT * FROM UserPreferences WHERE UserID=" + Session["User"].ToString());
        string emailPrefs = dvUser[0]["EmailPrefs"].ToString();
        dvUser = dat.GetDataDV("SELECT * FROM UserFriendPrefs WHERE UserID=" + Session["User"].ToString());
        string emailFriendPrefs = "";
        int friendcount = 0;
        if (dsFriends.Tables.Count > 0)
            if (dsFriends.Tables[0].Rows.Count > 0)
            {
                friendcount = dsFriends.Tables[0].Rows.Count;
                for (int i = 0; i < dsFriends.Tables[0].Rows.Count; i++)
                {
                    dvUser.RowFilter = "FriendID = " + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    if (dvUser.Count > 0)
                        emailFriendPrefs = dvUser[0]["Preferences"].ToString();
                    else
                        emailFriendPrefs = "";

                    Literal lit = new Literal();
                    lit.Text = "<div style=\"float: left; padding: 8px;\"><table align=\"center\" valign=\"middle\" cellpadding=\"0\" cellspacing=\"0\"  bgcolor=\"#666666\" width=\"52\" height=\"52\"><tr><td align=\"center\">";
                    ImageButton profilePicture = new ImageButton();

                    profilePicture.AlternateText = dsFriends.Tables[0].Rows[i]["UserName"].ToString();
                    profilePicture.ToolTip = dsFriends.Tables[0].Rows[i]["UserName"].ToString();
                    profilePicture.Height = 50;
                    profilePicture.Width = 50;
                    profilePicture.ID = "pic" + i.ToString();
                    profilePicture.AlternateText = dsFriends.Tables[0].Rows[i]["UserName"].ToString();
                    profilePicture.CommandArgument = dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    if (System.IO.File.Exists(Server.MapPath(".") + "\\UserFiles\\" + dsFriends.Tables[0].Rows[i]["UserName"].ToString() + "\\Profile\\" + dsFriends.Tables[0].Rows[i]["ProfilePicture"].ToString()))
                    {
                        profilePicture.ImageUrl = "~/UserFiles/" + dsFriends.Tables[0].Rows[i]["UserName"].ToString() + "/Profile/" + dsFriends.Tables[0].Rows[i]["ProfilePicture"].ToString();
                        System.Drawing.Image theimg = System.Drawing.Image.FromFile(Server.MapPath(".") + "/UserFiles/" + dsFriends.Tables[0].Rows[i]["UserName"].ToString() +
                     "/Profile/" + dsFriends.Tables[0].Rows[i]["ProfilePicture"].ToString());

                        double width = double.Parse(theimg.Width.ToString());
                        double height = double.Parse(theimg.Height.ToString());

                        if (width > height)
                        {
                            if (width <= 50)
                            {

                            }
                            else
                            {
                                double dividor = double.Parse("50.00") / double.Parse(width.ToString());
                                width = double.Parse("50.00");
                                height = height * dividor;
                            }
                        }
                        else
                        {
                            if (width == height)
                            {
                                width = double.Parse("50.00");
                                height = double.Parse("50.00");
                            }
                            else
                            {
                                double dividor = double.Parse("50.00") / double.Parse(height.ToString());
                                height = double.Parse("50.00");
                                width = width * dividor;
                            }
                        }

                        profilePicture.Width = int.Parse((Math.Round(decimal.Parse(width.ToString()))).ToString());
                        profilePicture.Height = int.Parse((Math.Round(decimal.Parse(height.ToString()))).ToString());

                    }
                    else
                    {
                        profilePicture.ImageUrl = "~/image/noAvatar_50x50_small.png";
                        profilePicture.Attributes.Add("onmouseover", "this.src='NewImages/noAvatar_50x50_smallhover.png'");
                        profilePicture.Attributes.Add("onmouseout", "this.src='image/noAvatar_50x50_small.png'");
                    }

                    profilePicture.Click += new ImageClickEventHandler(ViewFriend);

                    MyFriendsPanel.Controls.Add(lit);
                    MyFriendsPanel.Controls.Add(profilePicture);
                    lit = new Literal();
                    lit.Text = "</td></tr></table><div align=\"center\">";
                    MyFriendsPanel.Controls.Add(lit);

                    HyperLink link = new HyperLink();
                    link.Text = "edit prefs";
                    link.CssClass = "PrefsLink";
                    link.ID = "editPrefs" + dsFriends.Tables[0].Rows[i]["UserName"].ToString();

                    Telerik.Web.UI.RadToolTip tip = new Telerik.Web.UI.RadToolTip();
                    tip.TargetControlID = "editPrefs" + dsFriends.Tables[0].Rows[i]["UserName"].ToString();
                    tip.ShowEvent = Telerik.Web.UI.ToolTipShowEvent.OnClick;
                    tip.Position = Telerik.Web.UI.ToolTipPosition.MiddleRight;
                    tip.RelativeTo = Telerik.Web.UI.ToolTipRelativeDisplay.Element;
                    tip.ManualClose = true;
                    tip.Skin = "Vista";

                    UpdatePanel upP = new UpdatePanel();
                    upP.UpdateMode = UpdatePanelUpdateMode.Conditional;

                    Literal tipLit = new Literal();
                    tipLit.Text = "<div align=\"center\" style=\"width: 206px !important; height: 254px !important;\">";
                    tipLit.Text += "<table width=\"100%\" cellspacing=\"0\" align=\"center\" style=\"font-family: Arial; font-size: 11px; color: #1fb6e7;\">"+
                        "<tr><td align=\"center\" style=\"padding-bottom: 17px;padding-top: 20px;\"><span style=\"color: #cccccc; " +
                        "font-size: 12px; font-weight: bold;\">Update Friend's Prefs</span></td></tr>";
                    tipLit.Text += "<tr><td align=\"center\">adds an event to calendar</td></tr>";
                    tipLit.Text += "<tr><td align=\"center\">";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);
                    ImageButton imgB;
                    if (emailPrefs.Contains("2"))
                    {
                        tipLit = new Literal();
                        tipLit.Text = "<span style=\"color: #ff6b09;\">This preference is on for everyone.  If you want to set it just for this user, turn it off for everyone in 'Email Prefs'.</span></td></tr>";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);
                    }
                    else
                    {
                        tipLit = new Literal();
                        tipLit.Text = "<div style=\"width: 118px;\" class=\"topDiv\"><div style=\"float: left;padding-right: 8px;\">";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);

                        imgB = new ImageButton();
                        imgB.ID = "email" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                        if(emailFriendPrefs.Contains("0"))
                            imgB.ImageUrl = "image/CheckSelected.png";
                        else
                            imgB.ImageUrl = "image/Check.png";
                        imgB.CommandArgument = "0";
                        imgB.Click += new ImageClickEventHandler(ChangeCheckImage);

                        upP.ContentTemplateContainer.Controls.Add(imgB);

                        tipLit = new Literal();
                        tipLit.Text = "</div><div style=\"color: #cccccc; float: left;padding-right: 28px;\">email</div><div style=\"padding-right: 8px;float: left;\">";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);

                        imgB = new ImageButton();
                        imgB.ID = "text" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                        if (emailFriendPrefs.Contains("1"))
                            imgB.ImageUrl = "image/CheckSelected.png";
                        else
                            imgB.ImageUrl = "image/Check.png";
                        imgB.CommandArgument = "1";
                        imgB.Click += new ImageClickEventHandler(ChangeCheckImage);

                        upP.ContentTemplateContainer.Controls.Add(imgB);

                        tipLit = new Literal();
                        tipLit.Text = "</div><div style=\"color: #cccccc; float: left\">text</div></div></td></tr>";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);
                    }

                    //posts an event
                    tipLit = new Literal();
                    tipLit.Text = "<tr><td align=\"center\">posts an event</td></tr>";
                    tipLit.Text += "<tr><td align=\"center\"><div style=\"width: 118px;\" class=\"topDiv\"><div style=\"float: left;padding-right: 8px;\">";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    imgB = new ImageButton();
                    imgB.ID = "email2" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    if (emailFriendPrefs.Contains("2"))
                        imgB.ImageUrl = "image/CheckSelected.png";
                    else
                        imgB.ImageUrl = "image/Check.png";
                    imgB.CommandArgument = "2";
                    imgB.Click += new ImageClickEventHandler(ChangeCheckImage);

                    upP.ContentTemplateContainer.Controls.Add(imgB);

                    tipLit = new Literal();
                    tipLit.Text = "</div><div style=\"color: #cccccc; float: left;padding-right: 28px;\">email</div><div style=\"padding-right: 8px;float: left;\">";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    imgB = new ImageButton();
                    imgB.ID = "text2" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    if (emailFriendPrefs.Contains("3"))
                        imgB.ImageUrl = "image/CheckSelected.png";
                    else
                        imgB.ImageUrl = "image/Check.png";
                    imgB.CommandArgument = "3";
                    imgB.Click += new ImageClickEventHandler(ChangeCheckImage);

                    upP.ContentTemplateContainer.Controls.Add(imgB);

                    tipLit = new Literal();
                    tipLit.Text = "</div><div style=\"color: #cccccc; float: left\">text</div></td></tr>";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    //posts an ad
                    tipLit = new Literal();
                    tipLit.Text = "<tr><td align=\"center\">posts an ad</td></tr>";
                    tipLit.Text += "<tr><td align=\"center\"><div style=\"width: 118px;\" class=\"topDiv\"><div style=\"float: left;padding-right: 8px;\">";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    imgB = new ImageButton();
                    imgB.ID = "email3" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    if (emailFriendPrefs.Contains("4"))
                        imgB.ImageUrl = "image/CheckSelected.png";
                    else
                        imgB.ImageUrl = "image/Check.png";
                    imgB.CommandArgument = "4";
                    imgB.Click += new ImageClickEventHandler(ChangeCheckImage);

                    upP.ContentTemplateContainer.Controls.Add(imgB);

                    tipLit = new Literal();
                    tipLit.Text = "</div><div style=\"color: #cccccc; float: left;padding-right: 28px;\">email</div><div style=\"padding-right: 8px;float: left;\">";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    imgB = new ImageButton();
                    imgB.ID = "text3" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    if (emailFriendPrefs.Contains("5"))
                        imgB.ImageUrl = "image/CheckSelected.png";
                    else
                        imgB.ImageUrl = "image/Check.png";
                    imgB.CommandArgument = "5";
                    imgB.Click += new ImageClickEventHandler(ChangeCheckImage);

                    upP.ContentTemplateContainer.Controls.Add(imgB);

                    tipLit = new Literal();
                    tipLit.Text = "</div><div style=\"color: #cccccc; float: left\">text</div></td></tr>";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    //sends a Hippo Mail to you
                    tipLit = new Literal();
                    tipLit.Text = "<tr><td align=\"center\">sends a Hippo Mail to you</td></tr>";
                    tipLit.Text += "<tr><td align=\"center\">";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    if (emailPrefs.Contains("7"))
                    {
                        tipLit = new Literal();
                        tipLit.Text = "<span style=\"color: #ff6b09;\">This preference is on for everyone.  If you want to set it just for this user, turn it off for everyone in 'Email Prefs'.</span></td></tr>";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);
                    }
                    else
                    {
                        tipLit = new Literal();
                        tipLit.Text = "<div style=\"width: 118px;\" class=\"topDiv\"><div style=\"float: left;padding-right: 8px;\">";
                        upP.ContentTemplateContainer.Controls.Add(tipLit);

                        imgB = new ImageButton();
                        imgB.ID = "email4" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                        if (emailFriendPrefs.Contains("6"))
                            imgB.ImageUrl = "image/CheckSelected.png";
                        else
                            imgB.ImageUrl = "image/Check.png";
                        imgB.CommandArgument = "6";
                        imgB.Click += new ImageClickEventHandler(ChangeCheckImage);

                        upP.ContentTemplateContainer.Controls.Add(imgB);

                        tipLit = new Literal();
                        tipLit.Text = "</div><div style=\"color: #cccccc; float: left;padding-right: 28px;\">email</div><div style=\"padding-right: 8px;float: left;\">";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);

                        imgB = new ImageButton();
                        imgB.ID = "text4" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                        if (emailFriendPrefs.Contains("7"))
                            imgB.ImageUrl = "image/CheckSelected.png";
                        else
                            imgB.ImageUrl = "image/Check.png";
                        imgB.CommandArgument = "7";
                        imgB.Click += new ImageClickEventHandler(ChangeCheckImage);

                        upP.ContentTemplateContainer.Controls.Add(imgB);

                        tipLit = new Literal();
                        tipLit.Text = "</div><div style=\"color: #cccccc; float: left\">text</div></td></tr>";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);
                    }

                    //shares event/venue/ad with you
                    tipLit = new Literal();
                    tipLit.Text = "<tr><td align=\"center\">shares event/venue/ad with you</td></tr>";
                    tipLit.Text += "<tr><td align=\"center\">";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    if (emailPrefs.Contains("9"))
                    {
                        tipLit = new Literal();
                        tipLit.Text = "<span style=\"color: #ff6b09;\">This preference is on for everyone.  If you want to set it just for this user, turn it off for everyone in 'Email Prefs'.</span></td></tr>";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);
                    }
                    else
                    {
                        tipLit = new Literal();
                        tipLit.Text = "<div style=\"width: 118px;\" class=\"topDiv\"><div style=\"float: left;padding-right: 8px;\">";
                        upP.ContentTemplateContainer.Controls.Add(tipLit);

                        imgB = new ImageButton();
                        imgB.ID = "email5" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                        if (emailFriendPrefs.Contains("8"))
                            imgB.ImageUrl = "image/CheckSelected.png";
                        else
                            imgB.ImageUrl = "image/Check.png";
                        imgB.CommandArgument = "8";
                        imgB.Click += new ImageClickEventHandler(ChangeCheckImage);

                        upP.ContentTemplateContainer.Controls.Add(imgB);

                        tipLit = new Literal();
                        tipLit.Text = "</div><div style=\"color: #cccccc; float: left;padding-right: 28px;\">email</div><div style=\"padding-right: 8px;float: left;\">";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);

                        imgB = new ImageButton();
                        imgB.ID = "text5" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                        if (emailFriendPrefs.Contains("9"))
                            imgB.ImageUrl = "image/CheckSelected.png";
                        else
                            imgB.ImageUrl = "image/Check.png";
                        imgB.CommandArgument = "9";
                        imgB.Click += new ImageClickEventHandler(ChangeCheckImage);

                        upP.ContentTemplateContainer.Controls.Add(imgB);

                        tipLit = new Literal();
                        tipLit.Text = "</div><div style=\"color: #cccccc; float: left\">text</div></td></tr>";

                        upP.ContentTemplateContainer.Controls.Add(tipLit);

                    }
                    tipLit = new Literal();
                    tipLit.Text = "</table><div style=\"color: red;float: left;padding-top: 10px;\">";
                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    Label labl = new Label();
                    labl.ID = "ErrorLabel" + dsFriends.Tables[0].Rows[i]["FriendID"].ToString();

                    upP.ContentTemplateContainer.Controls.Add(labl);

                    tipLit = new Literal();
                    tipLit.Text = "</div><div style=\"float: right;padding-top: 10px;\">";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    Button btn = new Button();
                    btn.Text = "Save";
                    btn.CssClass="SearchButtonSmall";
                    btn.Attributes.Add("onmouseout", "this.style.backgroundImage='url(image/SmallButton.png)'");
                    btn.Attributes.Add("onmouseover","this.style.backgroundImage='url(image/SmallButtonSelected.png)'");
                    btn.Attributes.Add("onclientclick", "this.value = 'Working...';");
                    btn.CommandArgument = dsFriends.Tables[0].Rows[i]["FriendID"].ToString();
                    btn.OnClientClick = "javascript:CloseToolTip();";
                    btn.Click += new EventHandler(PrefsSave);

                    upP.ContentTemplateContainer.Controls.Add(btn);

                    tipLit = new Literal();
                    tipLit.Text = "</div></div>";

                    upP.ContentTemplateContainer.Controls.Add(tipLit);

                    tip.Controls.Add(upP);

                    MyFriendsPanel.Controls.Add(link);
                    MyFriendsPanel.Controls.Add(tip);

                    lit = new Literal();
                    lit.Text = "</div></div>";
                    MyFriendsPanel.Controls.Add(lit);
                }
            }

        NumFriendsLabel.Text = friendcount.ToString();
        LinkButton friendLink = new LinkButton();
        friendLink.Text = "Add Friends";
    }
Example #9
0
        private void InitialiseControls()
        {
            switch (TypeSkin)
            {
            case Skin.Vista:
                this.Attributes["class"] = "TVista";
                _btnSelectedPage         = "btnPageEmptyBlue";
                break;

            case Skin.Sunset:
                this.Attributes["class"] = "TSunset";
                _btnSelectedPage         = "btnPageEmptyBrown";
                break;

            default:
                this.Attributes["class"] = "TVista";
                _btnSelectedPage         = "btnPageEmptyBlue";
                break;
            }


            CallbackID = UniqueID; // needed for the callbacks and postbacks

            // Create JavaScript function for ClientCallBack WebForm_DoCallBack
            // Not sure why we need it, but the callback doesn't get registered on the client side properly without it.
            Page.ClientScript.GetCallbackEventReference(this, "", "", "");


            List <FunctionColumnRow> funcionesRows = new List <FunctionColumnRow>();

            foreach (FunctionColumnRow item in _functions)
            {
                funcionesRows.Add(item);
            }


            List <FunctionGral> funcionesGrales = new List <FunctionGral>();

            foreach (FunctionGral item in _functionsGral)
            {
                funcionesGrales.Add(item);
            }


            StringBuilder tblBasica = new StringBuilder();

            tblBasica.AppendLine("<table id='" + _ControlID + "' cellpadding='0' cellspacing='0' width='100%' >");
            tblBasica.AppendLine("<thead>theadAdd");
            tblBasica.AppendLine("<tr>");


            /// Controlo si se ha definido la columna de Edicion
            if (funcionesRows.Any(w => w.Type == FunctionColumnRow.FunctionType.Edit))
            {
                tblBasica.AppendLine("<td class='tdEdit Theader' >&nbsp;</td>");
                ColumnasVisibles++;
            }


            /// Controlo si se ha definido columnas custom
            if (funcionesRows.Any(w => w.Type == FunctionColumnRow.FunctionType.Custom))
            {
                tblBasica.AppendLine("<td class='tdCustom Theader' >&nbsp;</td>");
                ColumnasVisibles++;
            }


            /// Creo todas las columnas definidas
            foreach (Column item in Columns)
            {
                /// Solo creo en la tabla las columnas que se muestran
                if (item.Display == true)
                {
                    bool   ColumnaTotalizable = item.Totalizar;
                    string strWidth           = item.Width.IsEmpty ? "" : "width:" + item.Width;
                    tblBasica.AppendLine("<td dataFieldName='" + item.DataFieldName + "' style='" + strWidth + "' class='Theader' Totalizar='" + ColumnaTotalizable.ToString() + "' >" + item.HeaderName + "</td>");
                    ColumnasVisibles++;
                }
            }

            /// Controlo si se ha definido la columna de Eliminacion
            if (funcionesRows.Any(w => w.Type == FunctionColumnRow.FunctionType.Delete))
            {
                tblBasica.AppendLine("<td class='tdEliminar Theader' >&nbsp;</td>");
                ColumnasVisibles++;
            }


            tblBasica.AppendLine("</tr>");
            tblBasica.AppendLine("</thead>");
            tblBasica.AppendLine("<tbody></tbody>");



            tblBasica.AppendLine("<tfoot>tfootAdd");

            if (this.AllowPaging)
            {
                tblBasica.AppendLine("<tr class='tdFooter'>");
                tblBasica.AppendLine("<td class='tdGral' colspan='" + ColumnasVisibles.ToString() + "'>");



                long resto = 0;
                long CantidadTotalHojas = Math.DivRem(VirtualCount, PageSize, out resto);
                CantidadTotalHojas += resto > 0 ? 1 : 0;
                string displayTblPaging = CantidadTotalHojas <= 1 ? "display:none" : "display:block";

                tblBasica.AppendLine("<table id='tblPaging' cellpadding='0' cellspacing='3' border='0' style='height: 100%;" + displayTblPaging + "' ><tr>" +
                                     "<td style='width:22px;height:22px'><div id='theFirst' class='ImgPagingFirst'>&nbsp;</div></td>" +
                                     "<td style='width:22px;height:22px'><div id='thePrev' class='ImgPagingPrev'>&nbsp;</div></td>");


                for (int i = 0; i < 10; i++)
                {
                    if (CantidadTotalHojas > 0 && i < 10)
                    {
                        if (i == 0)
                        {
                            tblBasica.AppendLine("<td style='width:22px;height:22px;' class='vacia' ><div id='btnChangePage' class='btnChangePageIndex' style='background-image:url(" + Page.ClientScript.GetWebResourceUrl(this.GetType(), "ControlsAjaxNotti.ImagenesGrid." + _btnSelectedPage + ".jpg") + ")' PageIndex='" + (i).ToString() + "'  >" + (i + 1).ToString() + "</div></td>");
                        }
                        else
                        {
                            if (i < CantidadTotalHojas)
                            {
                                tblBasica.AppendLine("<td style='width:22px;height:22px;' class='vacia' ><div id='btnChangePage' class='btnChangePageIndex' PageIndex='" + (i).ToString() + "'  >" + (i + 1).ToString() + "</div></td>");
                            }
                            else
                            {
                                tblBasica.AppendLine("<td style='width:22px;height:22px;display:none'  class='vacia' ><div id='btnChangePage'  class='btnChangePageIndex' PageIndex='" + (i).ToString() + "'  >" + (i + 1).ToString() + "</div></td>");
                            }
                        }
                    }
                }

                if (CantidadTotalHojas >= 10)
                {
                    tblBasica.AppendLine("<td style='width:22px;height:22px' class='vacia' ><div id='btnChangePage' class='btnChangePageIndex' PageIndex='...'  >...</div></td>");
                }


                tblBasica.AppendLine("<td style='width:22px;height:22px'><div id='theNext' class='ImgPagingNext'>&nbsp;</div></td>" +
                                     "<td style='width:22px;height:22px'><div id='theLast' class='ImgPagingLast'>&nbsp;</div></td>" +
                                     "</tr></table>");


                tblBasica.AppendLine("</td></tr>");
            }

            tblBasica.AppendLine("</tfoot>");



            /// Controlo si se han definido funciones generales
            if (funcionesGrales.Count > 0)
            {
                if (PositionAdd == positionAdd.Top || PositionAdd == positionAdd.Both)
                {
                    tblBasica.Replace("theadAdd", "<tr><td colspan='" + ColumnasVisibles.ToString() + "' class='tdFunctionAdd' ></td></tr>");
                }
                else
                {
                    tblBasica.Replace("theadAdd", "");
                }

                if (PositionAdd == positionAdd.Botton || PositionAdd == positionAdd.Both)
                {
                    tblBasica.Replace("tfootAdd", "<tr><td colspan='" + ColumnasVisibles.ToString() + "' class='tdFunctionAdd' ></td></tr>");
                }
                else
                {
                    tblBasica.Replace("tfootAdd", "");
                }
            }
            else
            {
                tblBasica.Replace("theadAdd", "");
                tblBasica.Replace("tfootAdd", "");
            }



            tblBasica.AppendLine("</table>");
            this.TblBase = tblBasica.ToString();



            /// codigo necesario para agregar un tool tip a la grilla para utilizar
            /// en las columnas de datos.
            HtmlGenericControl divBlock = new HtmlGenericControl("Div");

            divBlock.ID = "DivToolTiop";
            divBlock.Style.Add(HtmlTextWriterStyle.Display, "none");
            this.Controls.Add(divBlock);


            Telerik.Web.UI.RadToolTip tooltip = new Telerik.Web.UI.RadToolTip();
            tooltip.ID         = "RadToolTipCtr";
            tooltip.Position   = Telerik.Web.UI.ToolTipPosition.MiddleLeft;
            tooltip.RelativeTo = Telerik.Web.UI.ToolTipRelativeDisplay.Element;


            divBlock.Controls.Add(tooltip);
        }
    protected void Page_Load(object sender, EventArgs e)
    {
        HtmlMeta hm = new HtmlMeta();
        HtmlHead head = (HtmlHead)Page.Header;
        hm.Name = "ROBOTS";
        hm.Content = "NOINDEX, FOLLOW";
        head.Controls.AddAt(0, hm);

        HttpCookie cookie = Request.Cookies["BrowserDate"];
        if (cookie == null)
        {
            cookie = new HttpCookie("BrowserDate");
            cookie.Value = DateTime.Now.ToString();
            cookie.Expires = DateTime.Now.AddDays(22);
            Response.Cookies.Add(cookie);
        }
        Data dat = new Data(DateTime.Parse(cookie.Value.ToString().Replace("%20", " ").Replace("%3A", ":")));

        ImageButton9.OnClientClick = "javascript:Search('Group.aspx?ID=" + Request.QueryString["ID"].ToString() + "');";

        DataView dvMembers = dat.GetDataDV("SELECT * FROM Group_Members GM, Users U WHERE " +
            "U.User_ID=GM.MemberID AND GM.GroupID=" + Request.QueryString["ID"].ToString());

        DataView dvGroup = dat.GetDataDV("SELECT * FROM Groups WHERE ID=" + Request.QueryString["ID"].ToString());

        string host = dvGroup[0]["Host"].ToString();

        bool isHost = false;
        if (Session["User"].ToString() == host)
            isHost = true;

        Label label;
        Literal lit;
        TextBox textB;
        TextBox textD;
        CheckBox checkS;
        RadioButton radButt;

        lit = new Literal();
        lit.Text = "<table><tr><td><label>Member</label></td><td><label>Title</label>" +
            "</td><td><label>Description</label></td><td><label>Shared Hosting</label>" +
            "</td>";
        if(isHost)
            lit.Text += "<td align=\"center\"><label>Make Primary Host</label></td>";

        lit.Text += "<td width=\"200px\" style=\"padding-left: 15px;\"><div style=\"float: left;padding-top: 5px;\"><label>Remove Member</label>" +
            "</div><div style=\"float: left; padding-left: 5px; \" >";
        MembersPanel.Controls.Add(lit);

        Image HelpImage = new Image();
        HelpImage.CssClass = "HelpImage";
        HelpImage.ID = "HelpImage2";
        HelpImage.ImageUrl = "~/image/helpIcon.png";
        MembersPanel.Controls.Add(HelpImage);

        Telerik.Web.UI.RadToolTip RadToolTip2 = new Telerik.Web.UI.RadToolTip();
        RadToolTip2.Skin = "Black";
        RadToolTip2.Width = 200;
        RadToolTip2.Height = 200;
        RadToolTip2.ManualClose = true;
        RadToolTip2.ShowEvent = Telerik.Web.UI.ToolTipShowEvent.OnClick;
        RadToolTip2.Position = Telerik.Web.UI.ToolTipPosition.MiddleRight;
        RadToolTip2.RelativeTo = Telerik.Web.UI.ToolTipRelativeDisplay.Element;
        RadToolTip2.TargetControlID = HelpImage.ClientID;

        lit = new Literal();
        lit.Text = "<label>To remove a member, you must first disable their 'Shared Hosting' "+
        "if they have it. However, you cannot ever remove the member that has posted the group.</label>";
        RadToolTip2.Controls.Add(lit);
        MembersPanel.Controls.Add(RadToolTip2);

        lit = new Literal();
        lit.Text = "</div></td></tr>";
        MembersPanel.Controls.Add(lit);

        foreach (DataRowView row in dvMembers)
        {
            lit = new Literal();
            lit.Text = "<tr><td valign=\"top\">";
            MembersPanel.Controls.Add(lit);

            label = new Label();
            label.CssClass = "AddLink";
            label.Text = row["UserName"].ToString();
            label.ID = "member" + row["MemberID"].ToString();
            MembersPanel.Controls.Add(label);

            lit = new Literal();
            lit.Text = "</td><td valign=\"top\">";
            MembersPanel.Controls.Add(lit);

            textB = new TextBox();
            textB.ID = "text" + row["MemberID"].ToString();
            textB.Width = 150;
            textB.Text = row["Title"].ToString();
            MembersPanel.Controls.Add(textB);

            lit = new Literal();
            lit.Text = "</td><td valign=\"top\">";
            MembersPanel.Controls.Add(lit);

            textD = new TextBox();
            textD.ID = "textD" + row["MemberID"].ToString();
            textD.TextMode = TextBoxMode.MultiLine;
            textD.Width = 170;
            textD.Height = 100;
            textD.Text = row["Description"].ToString();
            MembersPanel.Controls.Add(textD);

            lit = new Literal();
            lit.Text = "</td><td align=\"center\" valign=\"top\">";
            MembersPanel.Controls.Add(lit);

            checkS = new CheckBox();
            checkS.ID = "checkS" + row["MemberID"].ToString();
            checkS.Checked = bool.Parse(row["SharedHosting"].ToString());
            MembersPanel.Controls.Add(checkS);

            lit = new Literal();
            lit.Text = "</td><td align=\"center\" valign=\"top\" width=\"50px\">";
            MembersPanel.Controls.Add(lit);

            if (isHost)
            {
                radButt = new RadioButton();
                radButt.Checked = false;
                radButt.AutoPostBack = true;
                if (!IsPostBack)
                {
                    if (row["MemberID"].ToString() == host)
                        radButt.Checked = true;
                }
                radButt.ID = "radButt" + row["MemberID"].ToString();
                radButt.CheckedChanged += new EventHandler(radButt_CheckedChanged);
                MembersPanel.Controls.Add(radButt);

                lit = new Literal();
                lit.Text = "</td><td align=\"center\" valign=\"top\" style=\"padding-left: 15px;\">";
                MembersPanel.Controls.Add(lit);
            }

            checkS = new CheckBox();
            checkS.ID = "checkD" + row["MemberID"].ToString();
            MembersPanel.Controls.Add(checkS);

            lit = new Literal();
            lit.Text = "</td></tr>";
            MembersPanel.Controls.Add(lit);
        }

        lit = new Literal();
        lit.Text = "</tr></table>";
        MembersPanel.Controls.Add(lit);
    }