public GetActiveNetwork ( System.Int64 subject, bool details ) : System.Data.SqlClient.SqlDataReader | ||
subject | System.Int64 | |
details | bool | |
return | System.Data.SqlClient.SqlDataReader |
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; } */ }
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; } }