| public GetGoogleTimeline ( Profiles.Framework.Utilities.RDFTriple request, string storedproc ) : System.Data.SqlClient.SqlDataReader | ||
| request | Profiles.Framework.Utilities.RDFTriple | |
| storedproc | string | |
| return | System.Data.SqlClient.SqlDataReader | |
private void DrawProfilesModule()
{
Profiles.Profile.Utilities.DataIO data = new Profiles.Profile.Utilities.DataIO();
List<Publication> publication = new List<Publication>();
SqlDataReader reader = data.GetPublications(base.RDFTriple);
try
{
while (reader.Read())
{
publication.Add(new Publication(reader["bibo_pmid"].ToString(), reader["prns_informationResourceReference"].ToString()));
}
rpPublication.DataSource = publication;
rpPublication.DataBind();
}
finally
{
if (!reader.IsClosed)
reader.Close();
}
// Get timeline bar chart
using (reader = data.GetGoogleTimeline(base.RDFTriple, "[Profile.Module].[NetworkAuthorshipTimeline.Person.GetData]"))
{
try
{
while (reader.Read())
{
timelineBar.Src = reader["gc"].ToString();
}
}
finally
{
reader.Close();
}
}
// Login link
loginLiteral.Text = String.Format("<a href='{0}'>login</a>", Root.Domain + "/login/default.aspx?method=login&edit=true");
}
private void DrawProfilesModule()
{
DateTime d = DateTime.Now;
Profiles.Profile.Utilities.DataIO data = new Profiles.Profile.Utilities.DataIO();
List <Publication> publication = new List <Publication>();
using (SqlDataReader reader = data.GetPublications(base.RDFTriple))
{
while (reader.Read())
{
publication.Add(new Publication(reader["bibo_pmid"].ToString(), reader["vivo_pmcid"].ToString(), reader["prns_informationResourceReference"].ToString(), reader["vivo_webpage"].ToString()));
}
rpPublication.DataSource = publication;
rpPublication.DataBind();
}
// Get timeline bar chart
using (SqlDataReader reader = data.GetGoogleTimeline(base.RDFTriple, "[Profile.Module].[NetworkAuthorshipTimeline.Person.GetData]"))
{
while (reader.Read())
{
timelineBar.Src = reader["gc"].ToString();
timelineBar.Alt = reader["alt"].ToString();
litTimelineTable.Text = reader["asText"].ToString();
}
reader.Close();
}
if (timelineBar.Src == "")
{
timelineBar.Visible = false;
}
// Login link
loginLiteral.Text = String.Format("<a href='{0}'>login</a>", Root.Domain + "/login/default.aspx?pin=send&method=login&edit=true");
Framework.Utilities.DebugLogging.Log("PUBLICATION MODULE end Milliseconds:" + (DateTime.Now - d).TotalSeconds);
}
private void DrawProfilesModule()
{
DateTime d = DateTime.Now;
Profiles.Profile.Utilities.DataIO data = new Profiles.Profile.Utilities.DataIO();
List<Publication> publication = new List<Publication>();
using (SqlDataReader reader = data.GetPublications(base.RDFTriple))
{
while (reader.Read())
{
publication.Add(new Publication(reader["bibo_pmid"].ToString(), reader["prns_informationResourceReference"].ToString()));
}
rpPublication.DataSource = publication;
rpPublication.DataBind();
}
// Get timeline bar chart
using (SqlDataReader reader = data.GetGoogleTimeline(base.RDFTriple, "[Profile.Module].[NetworkAuthorshipTimeline.Person.GetData]"))
{
while(reader.Read())
{
timelineBar.Src = reader["gc"].ToString();
}
reader.Close();
}
if (timelineBar.Src == "")
{
timelineBar.Visible = false;
}
// Login link
loginLiteral.Text = String.Format("<a href='{0}'>login</a>", Root.Domain + "/login/default.aspx?pin=send&method=login&edit=true");
Framework.Utilities.DebugLogging.Log("PUBLICATION MODULE end Milliseconds:" + (DateTime.Now - d).TotalSeconds);
}
public void DrawProfilesModule()
{
var dataIO = new Profiles.Profile.Utilities.DataIO();
// Get concept publication timeline
using (var reader = dataIO.GetGoogleTimeline(base.RDFTriple, "[Profile.Module].[NetworkAuthorshipTimeline.Concept.GetData]"))
{
while (reader.Read())
{
timeline.Src = reader["gc"].ToString();
timeline.Alt = reader["alt"].ToString();
litTimelineTable.Text = reader["asText"].ToString();
}
reader.Close();
}
/* Reader returns multiple result sets in the following order
* 1) Cited publications
* 2) Newest publication
* 3) Oldest publications
*/
using (var reader = dataIO.GetConceptPublications(base.RDFTriple))
{
List <string> htmlList = new List <string>();
StringBuilder html = null;
int resultsetCnt = 0;
do
{
resultsetCnt++;
html = new StringBuilder();
while (reader.Read())
{
if (resultsetCnt == 3) // cited
{
html.AppendFormat(@"
<li>
<div>{0}</div>
<div class='viewIn'>View in: <a href='//www.ncbi.nlm.nih.gov/pubmed/{1}' target='_new'>PubMed</a></div>
<div>Cited: {2}</div>
</li>
" ,
reader["reference"].ToString(),
reader["pmid"].ToString(),
reader["n"].ToString()
);
}
else if (resultsetCnt == 1 || resultsetCnt == 2) // newest and oldest
{
html.AppendFormat(@"
<li>
<div>{0}</div>
<div class='viewIn'>View in: <a href='//www.ncbi.nlm.nih.gov/pubmed/{1}' target='_new'>PubMed</a></div>
</li>
" ,
reader["reference"].ToString(),
reader["pmid"].ToString()
);
}
}
htmlList.Add(html.ToString());
} while(reader.NextResult()); // Next resultset
reader.Close();
if (htmlList.Count == 1)
{
ShowOtherPub = false;
newest.Text = htmlList[0];
}
else
{
// For Catalyst site only until speed issue is resolved
ShowOtherPub = true;
newest.Text = htmlList[0];
oldest.Text = htmlList[1];
cited.Text = htmlList[2];
}
}
}
public void DrawProfilesModule()
{
var dataIO = new Profiles.Profile.Utilities.DataIO();
// Get concept publication timeline
using (var reader = dataIO.GetGoogleTimeline(base.RDFTriple, "[Profile.Module].[NetworkAuthorshipTimeline.Concept.GetData]"))
{
while (reader.Read())
{
timeline.Src = reader["gc"].ToString();
timeline.Alt = reader["alt"].ToString();
litTimelineTable.Text = reader["asText"].ToString();
}
reader.Close();
}
/* Reader returns multiple result sets in the following order
* 1) Cited publications
* 2) Newest publication
* 3) Oldest publications
*/
using (var reader = dataIO.GetConceptPublications(base.RDFTriple))
{
List<string> htmlList = new List<string>();
StringBuilder html = null;
int resultsetCnt = 0;
do
{
resultsetCnt++;
html = new StringBuilder();
while (reader.Read())
{
if(resultsetCnt==3) // cited
html.AppendFormat(@"
<li>
<div>{0}</div>
<div class='viewIn'>View in: <a href='//www.ncbi.nlm.nih.gov/pubmed/{1}' target='_new'>PubMed</a></div>
<div>Cited: {2}</div>
</li>
",
reader["reference"].ToString(),
reader["pmid"].ToString(),
reader["n"].ToString()
);
else if(resultsetCnt==1 || resultsetCnt==2) // newest and oldest
html.AppendFormat(@"
<li>
<div>{0}</div>
<div class='viewIn'>View in: <a href='//www.ncbi.nlm.nih.gov/pubmed/{1}' target='_new'>PubMed</a></div>
</li>
",
reader["reference"].ToString(),
reader["pmid"].ToString()
);
}
htmlList.Add(html.ToString());
} while(reader.NextResult()); // Next resultset
reader.Close();
if(htmlList.Count==1)
{
ShowOtherPub = false;
newest.Text = htmlList[0];
}
else
{
// For Catalyst site only until speed issue is resolved
ShowOtherPub = true;
newest.Text = htmlList[0];
oldest.Text = htmlList[1];
cited.Text = htmlList[2];
}
}
}