GetActiveNetwork() public method

public GetActiveNetwork ( System.Int64 subject, bool details ) : System.Data.SqlClient.SqlDataReader
subject System.Int64
details bool
return System.Data.SqlClient.SqlDataReader
示例#1
0
        private void DrawProfilesModule()
        {
            SqlDataReader reader;

            Framework.Utilities.DataIO data = new Profiles.Framework.Utilities.DataIO();
            List <NetworkItem>         ni   = new List <NetworkItem>();
            List <NetworkItem>         nibinder;

            reader = data.GetActiveNetwork(0, true);


            while (reader.Read())
            {
                ni.Add(new NetworkItem(reader["URI"].ToString(),
                                       reader["Name"].ToString(),
                                       Convert.ToInt64(reader["NodeID"]),
                                       reader["RelationshipType"].ToString(),
                                       reader["RelationshipName"].ToString()));
            }



            nibinder = this.GetItems("Collaborator", ni);
            litCollaborators.Text      = "<b>Collaborators</b> (" + nibinder.Count.ToString() + ")";
            gvCollaborators.DataSource = nibinder;
            gvCollaborators.DataBind();

            nibinder = this.GetItems("CurrentAdvisor", ni);
            litAdvisorsCurrent.Text      = "<b>Advisor (Current)</b> (" + nibinder.Count.ToString() + ")";
            gvAdvisorsCurrent.DataSource = nibinder;
            gvAdvisorsCurrent.DataBind();
            nibinder = new List <NetworkItem>();

            nibinder = this.GetItems("CurrentAdvisee", ni);
            litAdviseesCurrent.Text      = "<b>Advisee (Current)</b> (" + nibinder.Count.ToString() + ")";
            gvAdviseesCurrent.DataSource = nibinder;
            gvAdviseesCurrent.DataBind();
            nibinder = new List <NetworkItem>();

            nibinder                  = this.GetItems("PastAdvisor", ni);
            litAdvisorsPast.Text      = "<b>Advisor (Past)</b> (" + nibinder.Count.ToString() + ")";
            gvAdvisorsPast.DataSource = nibinder;
            gvAdvisorsPast.DataBind();
            nibinder = new List <NetworkItem>();

            nibinder                  = this.GetItems("PastAdvisee", ni);
            litAdviseesPast.Text      = "<b>Advisee (Past)</b> (" + nibinder.Count.ToString() + ")";
            gvAdviseesPast.DataSource = nibinder;
            gvAdviseesPast.DataBind();
        }
        private void DrawProfilesModule()
        {
            Utilities.DataIO data = new Profiles.Framework.Utilities.DataIO();
            SqlDataReader reader;

            List<NetworkItem> networkitem = new List<NetworkItem>();

            this.RelationshipTypes = new List<RelationshipType>();

            if (sm.Session().NodeID != null)
                try
                {
                    this.Subject = sm.Session().NodeID;
                }
                catch (Exception ex)
                {
                    this.Subject = 0;
                }
            else
                this.Subject = 0;

            if (sm.Session().NodeID != 0)
            {
                if ((Convert.ToInt64(HttpContext.Current.Request.QueryString["subject"]) != sm.Session().NodeID) && (HttpContext.Current.Request.QueryString["subject"] != null))
                {
                    reader = data.GetActiveNetwork(Convert.ToInt64(HttpContext.Current.Request.QueryString["subject"]), true);
                    while (reader.Read())
                    {
                        this.RelationshipTypes.Add(new RelationshipType(reader["RelationshipName"].ToString(), reader["RelationshipType"].ToString(), Convert.ToBoolean(reader["DoesExist"])));
                    }
                    if (RelationshipTypes.Count > 0)
                    {
                        rptRelationshipTypes.DataSource = this.RelationshipTypes;
                        rptRelationshipTypes.DataBind();
                        pnlSetActiveNetworks.Visible = true;

                    }
                    else
                    {
                        pnlSetActiveNetworks.Visible = false;
                    }
                }
                else
                {
                    pnlSetActiveNetworks.Visible = false;
                }

            }

            /** UCSF
            reader = data.GetActiveNetwork(0, false);

            while (reader.Read())
            {
                networkitem.Add(new NetworkItem(reader[1].ToString(), Convert.ToInt64(reader[2]), reader[3].ToString()));
            }

            if (!reader.IsClosed)
                reader.Close();

            if (networkitem.Count > 0)
            {
                gvActiveNetwork.DataSource = networkitem;
                gvActiveNetwork.DataBind();

                pnlMyNetwork.Visible = true;

                litActiveNetworkDetails.Text = "<a class='activeSectionDetails' href='" + Root.Domain + "/activenetwork/default.aspx'>View Details</a>";
            }
            else
            {
                pnlMyNetwork.Visible = false;
            }

            */
        }
示例#3
0
        private void DrawProfilesModule()
        {

            Utilities.DataIO data = new Profiles.Framework.Utilities.DataIO();
            SqlDataReader reader;

            List<NetworkItem> networkitem = new List<NetworkItem>();

            this.RelationshipTypes = new List<RelationshipType>();

            Int64 subject = 0;

            if (HttpContext.Current.Request.QueryString["subject"] != null)
            {
                subject = Convert.ToInt64(HttpContext.Current.Request.QueryString["subject"]);
            }

            if (sm.Session().UserID != 0)
            {
                if (subject != sm.Session().NodeID && subject != 0 && (!Root.AbsolutePath.Contains("/proxy") && !Root.AbsolutePath.Contains("/edit")))
                {
                    reader = data.GetActiveNetwork(subject, true);

                    while (reader.Read())
                    {
                        this.RelationshipTypes.Add(new RelationshipType(reader["RelationshipName"].ToString(), reader["RelationshipType"].ToString(), Convert.ToBoolean(reader["DoesExist"])));

                    }
                    if (RelationshipTypes.Count > 0)
                    {
                        rptRelationshipTypes.DataSource = this.RelationshipTypes;
                        rptRelationshipTypes.DataBind();
                        pnlSetActiveNetworks.Visible = true;
                    }
                    else
                    {
                        pnlSetActiveNetworks.Visible = false;
                    }
                }
                else
                {
                    pnlSetActiveNetworks.Visible = false;
                }
            }

            reader = data.GetActiveNetwork(0, false);

            while (reader.Read())
            {
                networkitem.Add(new NetworkItem(reader[1].ToString(), Convert.ToInt64(reader[2]), reader[3].ToString()));
            }

            if (!reader.IsClosed)
                reader.Close();

            if (networkitem.Count > 0)
            {
                gvActiveNetwork.DataSource = networkitem;
                gvActiveNetwork.DataBind();

                pnlMyNetwork.Visible = true;

                litActiveNetworkDetails.Text = "<a class='activeSectionDetails' href='" + Root.Domain + "/activenetwork/default.aspx'><font style='font-size:10px'>View Details</font></a>";
            }
            else
            {
                pnlMyNetwork.Visible = false;
            }


        }
        private void DrawProfilesModule()
        {
            SqlDataReader reader;
            Framework.Utilities.DataIO data = new Profiles.Framework.Utilities.DataIO();
            List<NetworkItem> ni = new List<NetworkItem>();
            List<NetworkItem> nibinder;

            reader = data.GetActiveNetwork(0, true);

            while (reader.Read())
            {
                ni.Add(new NetworkItem(reader["URI"].ToString(),
                    reader["Name"].ToString(),
                    Convert.ToInt64(reader["NodeID"]),
                    reader["RelationshipType"].ToString(),
                    reader["RelationshipName"].ToString()));
            }

            nibinder = this.GetItems("Collaborator", ni);
            litCollaborators.Text = "<b>Collaborators</b> (" + nibinder.Count.ToString() + ")";
            gvCollaborators.DataSource = nibinder;
            gvCollaborators.DataBind();

            nibinder = this.GetItems("CurrentAdvisor", ni);
            litAdvisorsCurrent.Text = "<b>Advisor (Current)</b> (" + nibinder.Count.ToString() + ")";
            gvAdvisorsCurrent.DataSource = nibinder;
            gvAdvisorsCurrent.DataBind();
            nibinder = new List<NetworkItem>();

            nibinder = this.GetItems("CurrentAdvisee", ni);
            litAdviseesCurrent.Text = "<b>Advisee (Current)</b> (" + nibinder.Count.ToString() + ")";
            gvAdviseesCurrent.DataSource = nibinder;
            gvAdviseesCurrent.DataBind();
            nibinder = new List<NetworkItem>();

            nibinder = this.GetItems("PastAdvisor", ni);
            litAdvisorsPast.Text = "<b>Advisor (Past)</b> (" + nibinder.Count.ToString() + ")";
            gvAdvisorsPast.DataSource = nibinder;
            gvAdvisorsPast.DataBind();
            nibinder = new List<NetworkItem>();

            nibinder = this.GetItems("PastAdvisee", ni);
            litAdviseesPast.Text = "<b>Advisee (Past)</b> (" + nibinder.Count.ToString() + ")";
            gvAdviseesPast.DataSource = nibinder;
            gvAdviseesPast.DataBind();
        }
        private void DrawProfilesModule()
        {
            this.first = true;
            Utilities.DataIO   data        = new Profiles.Framework.Utilities.DataIO();
            List <NetworkItem> networkitem = new List <NetworkItem>();

            if (HttpContext.Current.Request.QueryString["subject"] != null)
            {
                this.Subject = Convert.ToInt64(HttpContext.Current.Request.QueryString["subject"]);
            }

            hdSubject.Value = this.Subject.ToString();

            using (SqlDataReader reader = data.GetActiveNetwork(0, false))
            {
                while (reader.Read())
                {
                    networkitem.Add(new NetworkItem(reader[1].ToString(), Convert.ToInt64(reader[2]), reader[3].ToString()));
                }

                if (!reader.IsClosed)
                {
                    reader.Close();
                }
            }


            if (networkitem.Count > 0)
            {
                gvActiveNetwork.DataSource = networkitem;
                gvActiveNetwork.DataBind();
                this.Count = networkitem.Count;
                string seeall = string.Empty;
                if (this.Count > 1)
                {
                    seeall = "See all " + networkitem.Count.ToString() + " people";
                }
                else
                {
                    seeall = "See all people";
                }
                litActiveNetworkDetails.Text = "<li  style='height: 25px !important'><a style='border-left:1px solid #383737;border-right:1px solid #383737;border-bottom:1px solid #383737;border-top:2px solid #383737;' href='" + Root.Domain + "/activenetwork/default.aspx'>" + seeall + "</a></li>";
            }
            else
            {
                gvActiveNetwork.Visible         = false;
                litActiveNetworkDetails.Visible = false;
            }


            if (sm.Session().UserID != 0 && Subject > 0)
            {
                if (this.Subject != sm.Session().NodeID&& (Root.AbsolutePath.Contains("/display/")))
                {
                    int count = RelationshipTypeUtils.GetRelationshipTypes(Convert.ToInt64(Subject)).Count;

                    if (count > 0)
                    {
                        rptRelationshipTypes.DataSource = RelationshipTypeUtils.GetRelationshipTypes(Convert.ToInt64(Subject));
                        rptRelationshipTypes.DataBind();
                        this.Count = count;
                        rptRelationshipTypes.Visible = true;
                    }
                    else
                    {
                        rptRelationshipTypes.Visible = false;
                    }
                }
            }
        }
        private void DrawProfilesModule()
        {
            Utilities.DataIO data = new Profiles.Framework.Utilities.DataIO();
            SqlDataReader reader;

            List<NetworkItem> networkitem = new List<NetworkItem>();

            this.RelationshipTypes = new List<RelationshipType>();

            Int64 subject = 0;

            if (HttpContext.Current.Request.QueryString["subject"] != null)
            {
                subject = Convert.ToInt64(HttpContext.Current.Request.QueryString["subject"]);
            }

            if (sm.Session().UserID != 0)
            {
                if (subject != sm.Session().NodeID && subject != 0 && (!Root.AbsolutePath.Contains("/proxy") && !Root.AbsolutePath.Contains("/edit")))
                {
                    reader = data.GetActiveNetwork(subject, true);

                    while (reader.Read())
                    {
                        this.RelationshipTypes.Add(new RelationshipType(reader["RelationshipName"].ToString(), reader["RelationshipType"].ToString(), Convert.ToBoolean(reader["DoesExist"])));

                    }
                    if (RelationshipTypes.Count > 0)
                    {
                        rptRelationshipTypes.DataSource = this.RelationshipTypes;
                        rptRelationshipTypes.DataBind();
                        pnlSetActiveNetworks.Visible = true;
                    }
                    else
                    {
                        pnlSetActiveNetworks.Visible = false;
                    }
                }
                else
                {
                    pnlSetActiveNetworks.Visible = false;
                }
            }

            reader = data.GetActiveNetwork(0, false);

            while (reader.Read())
            {
                networkitem.Add(new NetworkItem(reader[1].ToString(), Convert.ToInt64(reader[2]), reader[3].ToString()));
            }

            if (!reader.IsClosed)
                reader.Close();

            if (networkitem.Count > 0)
            {
                gvActiveNetwork.DataSource = networkitem;
                gvActiveNetwork.DataBind();

                pnlMyNetwork.Visible = true;

                litActiveNetworkDetails.Text = "<a class='activeSectionDetails' href='" + Root.Domain + "/activenetwork/default.aspx'><font style='font-size:10px'>View Details</font></a>";
            }
            else
            {
                pnlMyNetwork.Visible = false;
            }
        }