ASP.NET

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Drawing;


public partial class ActivityCtrl : System.Web.UI.UserControl
{
    public static int MinimumActvWidth = 80;

    public System.Web.UI.WebControls.Button SaveButton()
    {
        return btnSaveStructure;
    }

    ///*Enabling Partial */

    //[DefaultValueAttribute(true)]

    //[CategoryAttribute("Behavior")]
    
    //public bool EnablePartialRendering { get; set; }
    
    public Boolean Enabled
    {
        set
        {
            btnSaveStructure.Enabled = value;
            gridviewContacts.Enabled = value;
        }
    }

    //public UpdatePanelUpdateMode UpdateMode
    //{

    //    get
    //    {
    //        return this.UpdatePanel1.UpdateMode;
    //    }
    //    set
    //    {
    //        this.UpdatePanel1.UpdateMode = value;
    //    }


    //}

    //public void Update()
    //{
    //    this.UpdatePanel1.Update();
    //}


    public int SubjectID
    {
        set
        {
            hfmodlID.Value = value.ToString();  // when the subjectId is set refresh 
            LoadSubjectStructure(SubjectID);    // redisplay the subject structure for the selected subject            
        }
        get
        {
            if (hfmodlID.Value == "")
            {
                hfmodlID.Value = "0";
            }
            return Convert.ToInt32(hfmodlID.Value);
        }
    }



    public string ActivityViewMode
    {
        // View either the activity properties or its resources/tags
        // valid options: "Activity" or "Tags" or "Venues" or "Staff"
        set
        {
            lblViewMode.Text = value;
            switch (value)
            {
                case "Activity": hfViewMode.Value = "0";    // this will set the ActiveViewIndex of the Activity Object Type to show e.g. ActvBox, ActivityResource or ActvStreams
                    break;
                case "Streams": hfViewMode.Value = "2";
                    break;
                default: hfViewMode.Value = "1";    // venues, staff, tags etc
                    break;
            }
            // Hide controls or adjust controls for the mode. The Activity Box will be displayed for actvity
            // and ActivityResources for resources/tags (this is handled automatically by the page)
            if (ActivityViewMode == "Activity")
            {
                menuActivityNameViewMode.Visible = true;
            }
            else
            {
                menuActivityNameViewMode.Visible = false;
            }
        }

        get
        {
            return lblViewMode.Text;
        }

    }

    public string ActivityNameViewMode
    {
        // view either the activities group name or the abreviated code for the activity
        set
        {
            menuActivityNameViewMode.SelectedItem.Selected = false;
            menuActivityNameViewMode.FindItem(value).Selected = true;
        }
        get
        {
            return menuActivityNameViewMode.SelectedValue;
        }
    }

    // in the case of streams tell the activity control to view keep apart streams or normal streams
    public Boolean KeepApart
    {
        set { hfKeepApart.Value = value.ToString(); }
        get { return Convert.ToBoolean(hfKeepApart.Value); }
    }

    public string ActivityBoxViewMode
    {
        get { return menuActivityNameViewMode.SelectedValue; }
    }

    // Return a list of selected contact types as an xml string from a grid
    public string SelectedContactsXml
    {
        get
        {
            string xml = "";
            xml = CommonFunctions.ReturnIdsInXmlForGridView(gridviewContacts);
            return xml;
        }
    }

    // Properties to expose values of control to main page
    public string SelectedActvs
    {
        // return an Xml string
        get { return BuildXMLforSelectedActvs(); }
        // populate the textbox with the selected activities in the format
        // "=actvid;"
        set
        {
            txtbxActvs.Text = value;

            HighlightSelectedActvs();
        }
    }

    public string SubjectTags
    {
        get
        {
            return lblSubjTags.Text;
        }
        set
        {
            lblSubjTags.Text = value;
        }
    }

    protected void Page_Init(object sender, EventArgs e)
    {
        // The SqlDataSources must connect to the database the user has logged into            
        // SqlDataSources within templates have this change made on their init method
        CommonFunctions.SetActiveConnectionStringForSqlDataSource(ref SqlDataSourceContacts);
        CommonFunctions.SetActiveConnectionStringForSqlDataSource(ref SqlDataSourceMaxActvs);
        CommonFunctions.SetActiveConnectionStringForSqlDataSource(ref SqlDataSourceActvDuration);

        // the structure must be redrawn in the Page_Init otherwise it
        // wont be visible on certain effents ( ViewState ) 
        if (!Page.IsPostBack)
        {
            if (Session["TTBL_TYPE"].ToString() != "CLASS")
            {

                gridviewContacts.Columns[1].HeaderText = "Paper Type";
                menuActivityNameViewMode.FindItem("Name").Selected = true;
                menuActivityNameViewMode.Enabled = false;
            }
        }




    }



    protected void Page_Load(object sender, EventArgs e)
    {
        string clientscript = "";

        // make available to all subcontrols a variable with the client ID of the textbox in which to store the selected activity IDs
        clientscript = "var txtbxActvClientID = '" + txtbxActvs.ClientID.ToString() + "'; ";
        // assign the current list of selected activities to the list for JavaScript here
        //clientscript += "var ActivityList = String(\"" + txtbxActvs.Text + "\"); ";  
        ClientScriptManager cs = Page.ClientScript;
        cs.RegisterClientScriptBlock(this.GetType(), "txtbxlookupid", clientscript, true);

        // if a subject is not selected hide the controls/actions a user has 
        if (!Page.IsPostBack)
        {
        }
        HighlightSelectedActvs();
        //LoadSubjectStructure(SubjectID);
    }


    public void LoadSubjectStructure(int subjectID)
    {
        // load the subject structure for the selected subject and store it in a session variable        
        SubjectStructure Subj = new SubjectStructure();
        Subj = Subj.GetSubjectStructure(subjectID);
        //Session["SubjStruct"] = Subj;        

        lblSubjectDescription.Text = Subj.Descr;

        // Show the subject tags
        PopulateSubjectTags();
    }
    /// <summary>
    /// This Method will Refresh the userControl, by Rebinding it
    /// </summary>
    public void RefreshUC()
    {
        string clientscript = "";

        // make available to all subcontrols a variable with the client ID of the textbox in which to store the selected activity IDs
        clientscript = "var txtbxActvClientID = '" + txtbxActvs.ClientID.ToString() + "'; ";
        // assign the current list of selected activities to the list for JavaScript here
        //clientscript += "var ActivityList = String(\"" + txtbxActvs.Text + "\"); ";  
        ClientScriptManager cs = Page.ClientScript;
        cs.RegisterClientScriptBlock(this.GetType(), "txtbxlookupid", clientscript, true);

        // if a subject is not selected hide the controls/actions a user has 
        if (!Page.IsPostBack)
        {
        }
        HighlightSelectedActvs();
        LoadSubjectStructure(SubjectID);
    
    }

    public void DisplaySubjectStructure()
    {
        gridviewContacts.DataBind();    // on DataBound colours are set and selected actvs highlighted        
    }

    public void SetContactRowColors()
    {
        // Calculate a color for each different contact type
        double hue;
        int TypID = 0;
        string colorstr = "";

        // go through the grid view and change the row color to that of the contact type
        foreach (GridViewRow row in gridviewContacts.Rows)
        {
            DropDownList drplstCntcTyp = (DropDownList)row.FindControl("drplstCntcTyp");
            if (drplstCntcTyp.SelectedValue != null && drplstCntcTyp.SelectedValue != "")
            {
                TypID = Convert.ToInt32(drplstCntcTyp.SelectedValue);


                hue = (TypID - 1) * 50 % 360;  // (Subj.contact[i].TypeID * 360) / 10 % 360;	// use the total number of subjects				        
                colorstr = CommonFunctions.HSVtoRGB(hue, 0.3, 1.0);	// hsv
                //bordercolor = CommonFunctions.HSVtoRGB(hue, 0.7, 1.0); //bordercolor = HSVtoRGB( hue, 0.7, 0.95 );
                //row.BackColor = System.Drawing.ColorTranslator.FromHtml(CommonFunctions.HSVtoRGB(hue, 0.3, 1.0));
                // For streams only color the dropdown lists for the contacts
                //if (ActivityViewMode != "Streams")
                //{
                row.BackColor = System.Drawing.ColorTranslator.FromHtml(colorstr);
                //}                
                //row.BorderColor = System.Drawing.ColorTranslator.FromHtml(bordercolor);            
            }
            drplstCntcTyp.BackColor = System.Drawing.ColorTranslator.FromHtml(colorstr);

            DropDownList drplstDuration = (DropDownList)row.FindControl("drplstDuration");
            drplstDuration.BackColor = System.Drawing.ColorTranslator.FromHtml(colorstr);
            drplstDuration.BorderColor = System.Drawing.ColorTranslator.FromHtml(colorstr);

        }

    }

    public void HighlightSelectedActvs()
    {
        string actvstr = "";
        int actvID = 0;
        bool selected = false;

        // parse through the activities and highlight those with ids in the list of selected activities
        foreach (GridViewRow row in gridviewContacts.Rows)
        {
            // get a handle to the activities
            DataList datalistActvs = (DataList)row.FindControl("datalistActvs");
            if (datalistActvs != null)
            {
                foreach (DataListItem dlitem in datalistActvs.Items)
                {
                    switch (ActivityViewMode)
                    {
                        case "Activity":
                            ActivityBox actvbox = (ActivityBox)dlitem.FindControl("ActivityBox1");
                            actvID = actvbox.ActvID;
                            actvstr = "=" + actvID.ToString() + ";";
                            // if the list of actvIDs contains this activities ID then select the activity
                            selected = txtbxActvs.Text.Contains(actvstr);
                            actvbox.Selected = selected;

                            break;
                        case "Streams":
                            ActvStreams actvstrm = (ActvStreams)dlitem.FindControl("ActvStreams1");
                            actvID = actvstrm.ActvID;
                            actvstr = "=" + actvID.ToString() + ";";
                            selected = txtbxActvs.Text.Contains(actvstr);
                            actvstrm.Selected = selected;
                            break;
                        case "Staff": // venues, staff
                            ActivityResource actvstaff = (ActivityResource)dlitem.FindControl("ActivityResource1");
                            actvID = actvstaff.ActvID;
                            actvstr = "=" + actvID.ToString() + ";";
                            selected = txtbxActvs.Text.Contains(actvstr);
                            actvstaff.Selected = selected;
                            break;
                        case "Venues":
                            ActivityResource actvres = (ActivityResource)dlitem.FindControl("ActivityResource1");
                            actvID = actvres.ActvID;
                            actvstr = "=" + actvID.ToString() + ";";
                            selected = txtbxActvs.Text.Contains(actvstr);
                            actvres.Selected = selected;
                            break;
                    }   // end switch

                }  // end foreach
            } // end if
        }

    }

    public string BuildXMLforSelectedActvs()
    {
        string xmlSelActvs = "";
        string xmlactvs = "";

        xmlSelActvs = "<Root>";
        xmlactvs = txtbxActvs.Text;
        // txtbxActvs.Text keeps a list of selected activities
        // in the format "=actvid;" -- put these into xml is just a matter of replacing the "=" and ";" with
        // the appropriate xml string
        xmlactvs = xmlactvs.Replace("=", "<Actvs><ID>");
        xmlactvs = xmlactvs.Replace(";", "</ID></Actvs>");
        xmlSelActvs += xmlactvs;

        xmlSelActvs += "</Root>";

        return xmlSelActvs;
    }

    protected void btnSelectNone_Click(object sender, EventArgs e)
    {
        // clear the selection of activities
        txtbxActvs.Text = "";

        HighlightSelectedActvs();
    }

    protected void menuActivityBoxViewMode_MenuItemClick(object sender, MenuEventArgs e)
    {
        gridviewContacts.DataBind();    // on DataBound colours are set and selected actvs highlighted
    }

    public void PopulateSubjectTags()
    {
        PopulateLabelWithTags(ref lblSubjTags, SubjectID, "Subject");
    }

    public void PopulateLabelWithTags(ref Label lbl, int objid, string TagType)
    {
        lbl.Text = "";
        lbl.ToolTip = "";

        // look up the venues for the specific activity
        string sql = "";

        DataSet ds = new DataSet();

        sql = sql + " select tbl_tag.id, tbl_tag.descr  ";
        sql = sql + " from tbl_tag ";
        sql = sql + " inner join mtm_obj_tag mot on mot.tag = tbl_tag.id  ";
        sql = sql + " inner join tbl_tag_typ tagtyp on tagtyp.id = tbl_tag.typ ";
        sql = sql + " where mot.objID = " + SubjectID.ToString() + " and ltrim(rtrim(tagtyp.descr)) = '" + TagType + "' ";
        sql = sql + " order by tbl_tag.descr ";

        ds = CommonFunctions.ReturnResultSet(sql);
        // the first result set will be used to populate the grid (i.e. Table[0])
        if (ds.Tables[0].Rows.Count > 0)
        {
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                // if there are 2 or less lecturers assigned show them
                if (i < 2)
                {
                    lbl.Text += ds.Tables[0].Rows[i]["descr"].ToString() + "\n";
                }
                else
                {
                    if (i == 2)
                    {
                        lbl.Text += "more...";
                    }
                }
                // fill the tooltip with a list of all the staff
                lbl.ToolTip += ds.Tables[0].Rows[i]["descr"].ToString() + "\n";
            }
        }

    }   // ...PopulateLabelWithTags

    protected void drplstActvViewMode_SelectedIndexChanged(object sender, EventArgs e)
    {
        ActivityViewMode = lblViewMode.Text;
        gridviewContacts.DataBind();    // on DataBound colours are set and selected actvs highlighted
    }

     protected void gridviewContacts_DataBound(object sender, EventArgs e)
    {
        // Set the row colors for each contact type after the gridview is populated from the database
        SetContactRowColors();
        HighlightSelectedActvs();

    }

    protected void btnSaveStructure_Click(object sender, EventArgs e)
    {
        string sql = "", CntcXml = "", ActvXml = "";

        SubjectStructure Subj = new SubjectStructure();
        Subj = Subj.GetSubjectStructure(SubjectID);

        Subj.contact = null;

        // Parse through the ActivityControl picking up the values and save to the database
        int CntcID = 0, actvID = 0, students = 0;
        int CntcTyp = 0, DurationCntc = 1, DurationActv = 1;
        string grpname = "";

        // build an xml string for the changes to the contacts and then also for the activities
        foreach (GridViewRow row in gridviewContacts.Rows)
        {
            CntcID = Convert.ToInt32(gridviewContacts.DataKeys[row.DataItemIndex].Value.ToString());
            // get the type and duration            
            CntcTyp = Convert.ToInt32(((DropDownList)row.FindControl("drplstCntcTyp")).SelectedValue);
            DurationCntc = Convert.ToInt32(((DropDownList)row.FindControl("drplstDuration")).SelectedValue);
            // update the contacts individually            
            CntcXml += "<Contact><ID>" + CntcID.ToString() + "</ID><CntcTyp>" + CntcTyp.ToString() + "</CntcTyp><Duration>" + DurationCntc.ToString() + "</Duration></Contact>";

            // get the activity details
            DataList datalistActvs = (DataList)row.FindControl("datalistActvs");
            if (datalistActvs != null)
            {
                foreach (DataListItem dlitem in datalistActvs.Items)
                {
                    ActivityBox actvbox = (ActivityBox)dlitem.FindControl("ActivityBox1");
                    actvID = actvbox.ActvID;
                    students = actvbox.Students;
                    DurationActv = actvbox.Duration;
                    grpname = actvbox.GrpName;

                    if ((DurationCntc > 1) && !(DurationActv > 1))
                    {
                        DurationActv = DurationCntc;
                    }

                    ActvXml += "<Actv><ID>" + actvID.ToString() + "</ID><Students>" + students.ToString() + "</Students><Duration>" + DurationActv.ToString() + "</Duration><GrpName>" + grpname + "</GrpName></Actv>";
                }
            }

        }
        // within this sp the contact numbers are adjusted after the update
        sql = "sp_Contacts_Update '<Root>" + CntcXml + "</Root>', " + SubjectID.ToString() + " ";
        CommonFunctions.ExecuteStoredProc(sql);

        string xm = "class";
        if (Session["TTBL_TYPE"].ToString() != "CLASS")
        {
            xm = "XM";
        }
        sql = "sp_Activities_Update '<Root>" + ActvXml + "</Root>', '" + ActivityNameViewMode + "', '" + xm + "' ";
        CommonFunctions.ExecuteStoredProc(sql);

        DisplaySubjectStructure();  // refresh the page

        CommonFunctions.setDataModifiedTime();
    }


    //----------------------------------------------------------------------------------------------------------
    /// <summary>
    ///     Setup an event handler to handle subject change. The containing page will do certain processing 
    ///     when this event is fired.
    /// </summary>
    /// bubble through the event
    public event EventHandler SubjectChange;

    protected void OnSubjectChange(EventArgs e)
    {
        if (SubjectChange != null)
        {
            SubjectChange(this, e);
        }
    }
    //----------------------------------------------------------------------------------------------------------

    private void StructureChanged(object sender, EventArgs e)
    {
        // When a subject is selected first get the subject structure from the database
        // this.LoadSubjectStructure(SubjectSelector1.SelectedSubjectID);    // reload the structure
        //        Response.Redirect("SubjectStructure.aspx"); // refresh the whole page
    }


    /// <summary>
    ///     Initialize main page - handle control events that bubble down
    /// </summary>
    /// <param name="e"></param>
    #region Web Form Designer generated code
    override protected void OnInit(EventArgs e)
    {
        InitializeComponent();
        base.OnInit(e);
    }

    // On main page handle the incomming events
    private void InitializeComponent()
    {
        this.Load += new System.EventHandler(this.Page_Load);
        // SubjectSelector1.SubjectChange += new EventHandler(SelectedSubjectChange);
        // SubjectDetails1.SubjectDetailsChange += new EventHandler(btnSaveSubj_Click);
    }
    #endregion


    protected void btnSelectAll_Click(object sender, EventArgs e)
    {
        SelectAllActvs();
        // write this list to the javascript to update the activities that are selected there
    }

    // this procedure looks at activities in the hidden field text box and only hightlights them
    public void SelectAllActvs()
    {
        txtbxActvs.Text = "";   // clear the text box and select all activities by putting each activity in the text box

        string actvstr = "";
        int actvID = 0;
        bool selected = false;

        // parse through the activities and highlight those with ids in the list of selected activities
        foreach (GridViewRow row in gridviewContacts.Rows)
        {
            // get a handle to the activities
            DataList datalistActvs = (DataList)row.FindControl("datalistActvs");
            if (datalistActvs != null)
            {
                foreach (DataListItem dlitem in datalistActvs.Items)
                {
                    switch (ActivityViewMode)
                    {
                        case "Activity":
                            ActivityBox actvbox = (ActivityBox)dlitem.FindControl("ActivityBox1");
                            actvID = actvbox.ActvID;



                            actvstr = "=" + actvID.ToString() + ";";
                            // if the list of actvIDs contains this activities ID then select the activity
                            txtbxActvs.Text += actvstr;
                            selected = txtbxActvs.Text.Contains(actvstr);
                            actvbox.Selected = selected;
                            // todo make this like Staff
                            break;
                        case "Streams":
                            ActvStreams actvstrm = (ActvStreams)dlitem.FindControl("ActvStreams1");
                            actvID = actvstrm.ActvID;
                            actvstr = "=" + actvID.ToString() + ";";
                            txtbxActvs.Text += actvstr;
                            selected = txtbxActvs.Text.Contains(actvstr);
                            actvstrm.Selected = selected;
                            // todo make this like Staff
                            break;
                        case "Staff":       // venues, staff
                            ActivityResource actvstaff = (ActivityResource)dlitem.FindControl("ActivityResource1");
                            actvID = actvstaff.ActvID;
                            actvstr = "=" + actvID.ToString() + ";";
                            txtbxActvs.Text += actvstr;
                            actvstaff.Selected = true;
                            // todo make this like Staff
                            break;
                        case "Venues":
                            ActivityResource actvres = (ActivityResource)dlitem.FindControl("ActivityResource1");
                            actvID = actvres.ActvID;
                            actvstr = "=" + actvID.ToString() + ";";
                            txtbxActvs.Text += actvstr;
                            selected = txtbxActvs.Text.Contains(actvstr);
                            actvres.Selected = selected;
                            // todo make this like Staff
                            break;
                    }   // end switch

                }  // end foreach
            } // end if
        }

    }

    protected void gridviewContacts_SelectedIndexChanged(object sender, EventArgs e)
    {


    }



    protected void SqlDataSourceActvs_DataBinding(object sender, EventArgs e)
    {
        // when binding the controls build themselves dynamically. Templates inside certain controls containe
        // SqlDataSources which must connect to the database logged onto to run properly. Just before evaluating
        // change the datasource
        // check that the sender is infact a SqlDataSource
        if (sender.GetType().ToString() == "System.Web.UI.WebControls.SqlDataSource")
        {
            SqlDataSource sqlDatSrc = (SqlDataSource)sender;
            CommonFunctions.SetActiveConnectionStringForSqlDataSource(ref sqlDatSrc);
        }

    }
    protected void SqlDataSourceActvs_Init(object sender, EventArgs e)
    {
        // when binding the controls build themselves dynamically. Templates inside certain controls containe
        // SqlDataSources which must connect to the database logged onto to run properly. Just before evaluating
        // change the datasource
        // check that the sender is infact a SqlDataSource
        if (sender.GetType().ToString() == "System.Web.UI.WebControls.SqlDataSource")
        {
            SqlDataSource sqlDatSrc = (SqlDataSource)sender;
            CommonFunctions.SetActiveConnectionStringForSqlDataSource(ref sqlDatSrc);
        }
    }
    protected void SqlDataSourceActvs_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        // when binding the controls build themselves dynamically. Templates inside certain controls containe
        // SqlDataSources which must connect to the database logged onto to run properly. Just before evaluating
        // change the datasource
        // check that the sender is infact a SqlDataSource
        if (sender.GetType().ToString() == "System.Web.UI.WebControls.SqlDataSource")
        {
            SqlDataSource sqlDatSrc = (SqlDataSource)sender;
            CommonFunctions.SetActiveConnectionStringForSqlDataSource(ref sqlDatSrc);
        }
    }
    protected void SqlDataSourceCntcTypes_DataBinding(object sender, EventArgs e)
    {
        // when binding the controls build themselves dynamically. Templates inside certain controls containe
        // SqlDataSources which must connect to the database logged onto to run properly. Just before evaluating
        // change the datasource
        // check that the sender is infact a SqlDataSource
        if (sender.GetType().ToString() == "System.Web.UI.WebControls.SqlDataSource")
        {
            SqlDataSource sqlDatSrc = (SqlDataSource)sender;
            CommonFunctions.SetActiveConnectionStringForSqlDataSource(ref sqlDatSrc);
        }
    }
    protected void SqlDataSourceCntcTypes_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        // when binding the controls build themselves dynamically. Templates inside certain controls containe
        // SqlDataSources which must connect to the database logged onto to run properly. Just before evaluating
        // change the datasource
        // check that the sender is infact a SqlDataSource
        if (sender.GetType().ToString() == "System.Web.UI.WebControls.SqlDataSource")
        {
            SqlDataSource sqlDatSrc = (SqlDataSource)sender;
            CommonFunctions.SetActiveConnectionStringForSqlDataSource(ref sqlDatSrc);
        }
    }
    protected void SqlDataSourceCntcTypes_Init(object sender, EventArgs e)
    {
        // when binding the controls build themselves dynamically. Templates inside certain controls containe
        // SqlDataSources which must connect to the database logged onto to run properly. Just before evaluating
        // change the datasource
        // check that the sender is infact a SqlDataSource
        if (sender.GetType().ToString() == "System.Web.UI.WebControls.SqlDataSource")
        {
            SqlDataSource sqlDatSrc = (SqlDataSource)sender;
            CommonFunctions.SetActiveConnectionStringForSqlDataSource(ref sqlDatSrc);
        }
    }
    protected void txtbxActvs_TextChanged(object sender, EventArgs e)
    {
        /* I created this Session Variables to keep Track of the Activities selected
         * As you can see there are lot of them doing them same thing, now the Reason is that 
         * they are used Diffenently in the Application 
         */

        Session["Activity_id"] = txtbxActvs.Text;

        Session["Selected_ID_Bind"] = txtbxActvs.Text;

        Session["Multi_Activity_ID"] = txtbxActvs.Text;
    }
    protected void txtActivity_TextChanged(object sender, EventArgs e)
    {
    }
    protected void gridviewContacts_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
    {
     
    }
}

if (e.Item.Text == "Remove Selected" && Session["Array_To_Be_Replaced"] != null && Convert.ToString(Session["Array_To_Be_Replaced"]) != "")
            {
                ArrayList Activity_IDS = (ArrayList)Session["Activity_IDS"];

                ArrayList Array_To_Be_Replaced = (ArrayList)Session["Array_To_Be_Replaced"];

                obj.Remove_Cycles(Activity_IDS, Array_To_Be_Replaced, Convert.ToString(Session["ActiveDatabase"]));

                Bind_Grid_For_Staff();
                //Response.Redirect("SubjectStaff.aspx", false); //Refresh the Page again :)
                //Response.Redirect(Request.CurrentExecutionFilePath);
                //Response.Write("<script><a href='SubjectStaff.aspx' onclick='location.reload(true)'>'ActivityCtrl.ascx'</a></script>");
               <pre> ActivityCtrl1.RefreshUC();

<asp:SqlDataSource ID="SqlDataSourceContacts" runat="server" ConnectionString="< %$ ConnectionStrings:DBConnectionString % >"
    SelectCommand="select distinct tbl_cntc.ID, tbl_cntc.CntcTyp, tbl_cntc.Number, tbl_cntc.Duration, count( distinct tbl_Actv.id ) [NumberOfActivities]&amp;#13;&amp;#10;from tbl_cntc&amp;#13;&amp;#10;left outer join tbl_actv on tbl_actv.cntcId = tbl_cntc.ID&amp;#13;&amp;#10;where tbl_cntc.modlID = @ModlID&amp;#13;&amp;#10;group by tbl_cntc.ID, tbl_cntc.CntcTyp, tbl_cntc.Number, tbl_cntc.Duration&amp;#13;&amp;#10;order by CntcTyp, tbl_cntc.Number" UpdateCommand="Update tbl_cntc &amp;#13;&amp;#10;   set CntcTyp = @CntcTyp,&amp;#13;&amp;#10;         Duration = @Duration&amp;#13;&amp;#10;   where ID = @CntcID" >
    < SelectParameters>
        < asp:ControlParameter ControlID="hfmodlID" Name="ModlID" PropertyName="Value" / >;
    < /SelectParameters >
    < UpdateParameters >
        < asp:Parameter Name="CntcTyp"  />
        < asp:Parameter Name="Duration" / >
        < asp:Parameter Name="CntcID" / >
    < /UpdateParameters >

protected void Page_Load(object sender, EventArgs e)
{
    string clientscript = "";

    // make available to all subcontrols a variable with the client ID of the textbox in which to store the selected activity IDs
    clientscript = "var txtbxActvClientID = '" + txtbxActvs.ClientID.ToString() + "'; ";
    // assign the current list of selected activities to the list for JavaScript here
    //clientscript += "var ActivityList = String(\"" + txtbxActvs.Text + "\"); ";
    ClientScriptManager cs = Page.ClientScript;
    cs.RegisterClientScriptBlock(this.GetType(), "txtbxlookupid", clientscript, true);

    // if a subject is not selected hide the controls/actions a user has
    if (!Page.IsPostBack)
    {
    }
    HighlightSelectedActvs();
    //LoadSubjectStructure(SubjectID);
}

jainiraj wrote:

But it is not retrieved

jainiraj wrote:

common obj=new common();