protected void ProcessUpload(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e) { System.IO.Stream stream; Edit.Utilities.DataIO data = new Profiles.Edit.Utilities.DataIO(); stream = AsyncFileUpload1.PostedFile.InputStream; byte[] imageBytes = new byte[AsyncFileUpload1.PostedFile.InputStream.Length + 1]; AsyncFileUpload1.PostedFile.InputStream.Read(imageBytes, 0, imageBytes.Length); Framework.Utilities.Namespace xmlnamespace = new Profiles.Framework.Utilities.Namespace(); XmlNamespaceManager namespaces = xmlnamespace.LoadNamespaces(BaseData); if (BaseData.SelectSingleNode("rdf:RDF/rdf:Description[1]/rdf:type[@rdf:resource='http://xmlns.com/foaf/0.1/Person']", namespaces) != null) { data.SaveImage(this.SubjectID, imageBytes, this.PropertyListXML); } if (BaseData.SelectSingleNode("rdf:RDF/rdf:Description[1]/rdf:type[@rdf:resource='http://xmlns.com/foaf/0.1/Group']", namespaces) != null) { data.SaveGroupImage(this.SubjectID, imageBytes, this.PropertyListXML); } base.GetSubjectProfile(); this.PropertyListXML = propdata.GetPropertyList(this.BaseData, base.PresentationXML, this.PredicateURI, false, true, false); this.DrawProfilesModule(); InitLinks(); pnlUpload.Visible = false; upnlEditSection.Update(); }
private void DrawProfilesModule() { Utilities.DataIO.ClassType type = Utilities.DataIO.ClassType.Unknown; Framework.Utilities.Namespace xmlnamespace = new Profiles.Framework.Utilities.Namespace(); XmlNamespaceManager namespaces = xmlnamespace.LoadNamespaces(BaseData); if (BaseData.SelectSingleNode("rdf:RDF/rdf:Description[1]/rdf:type[@rdf:resource='http://xmlns.com/foaf/0.1/Person']", namespaces) != null) { type = Utilities.DataIO.ClassType.Person; } if (BaseData.SelectSingleNode("rdf:RDF/rdf:Description[1]/rdf:type[@rdf:resource='http://xmlns.com/foaf/0.1/Group']", namespaces) != null) { type = Utilities.DataIO.ClassType.Group; } DateTime d = DateTime.Now; Profiles.Profile.Modules.CustomViewAuthorInAuthorshipTimeline.DataIO data = new Profiles.Profile.Modules.CustomViewAuthorInAuthorshipTimeline.DataIO(); // Get timeline bar chart string storedproc = "[Profile.Module].[NetworkAuthorshipTimeline.Person.GetCovidData]"; if (type == Utilities.DataIO.ClassType.Group) { storedproc = "[Profile.Module].[NetworkAuthorshipTimeline.Group.GetData]"; } Profiles.Profile.Modules.CustomViewAuthorInAuthorshipTimeline.DataIO.VisualizationImageLink vil; try { vil = data.GetGoogleTimeline(base.RDFTriple, storedproc); covidTimelineBar.Src = vil.src; covidTimelineBar.Alt = vil.alt; litTimelineTable.Text = vil.asText; } catch (Exception) { covidTimelineGraph.Visible = false; } storedproc = "[Profile.Module].[NetworkAuthorshipTimeline.Person.GetData]"; if (type == Utilities.DataIO.ClassType.Group) { storedproc = "[Profile.Module].[NetworkAuthorshipTimeline.Group.GetData]"; } vil = data.GetGoogleTimeline(base.RDFTriple, storedproc); timelineBar.Src = vil.src; timelineBar.Alt = vil.alt; litTimelineTable.Text = vil.asText; if (timelineBar.Src == "") { timelineBar.Visible = false; } Framework.Utilities.DebugLogging.Log("PUBLICATION MODULE end Milliseconds:" + (DateTime.Now - d).TotalSeconds); }
private void DrawProfilesModule() { DateTime d = DateTime.Now; Profiles.Profile.Modules.CustomViewAuthorInAuthorshipTimeline.DataIO data = new Profiles.Profile.Modules.CustomViewAuthorInAuthorshipTimeline.DataIO(); List <Publication> publication = new List <Publication>(); Utilities.DataIO.ClassType type = Utilities.DataIO.ClassType.Unknown; Framework.Utilities.Namespace xmlnamespace = new Profiles.Framework.Utilities.Namespace(); XmlNamespaceManager namespaces = xmlnamespace.LoadNamespaces(BaseData); //if (BaseData.SelectSingleNode("rdf:RDF/rdf:Description[1]/rdf:type[@rdf:resource='http://xmlns.com/foaf/0.1/Person']", namespaces) != null) // type = Utilities.DataIO.ClassType.Person; //if (BaseData.SelectSingleNode("rdf:RDF/rdf:Description[1]/rdf:type[@rdf:resource='http://xmlns.com/foaf/0.1/Group']", namespaces) != null) type = Utilities.DataIO.ClassType.Group; using (SqlDataReader reader = data.GetPublications(base.RDFTriple, type)) { while (reader.Read()) { publication.Add(new Publication(reader["bibo_pmid"].ToString(), reader["vivo_pmcid"].ToString(), reader["prns_informationResourceReference"].ToString(), reader["vivo_webpage"].ToString(), Convert.ToInt32(reader["PMCCitations"]), reader["Fields"].ToString(), Convert.ToInt32(reader["TranslationHumans"]), Convert.ToInt32(reader["TranslationAnimals"]), Convert.ToInt32(reader["TranslationCells"]), Convert.ToInt32(reader["TranslationPublicHealth"]), Convert.ToInt32(reader["TranslationClinicalTrial"]))); } rpPublication.DataSource = publication; rpPublication.DataBind(); } // Get timeline bar chart string storedproc = "[Profile.Module].[NetworkAuthorshipTimeline.Person.GetData]"; if (type == Utilities.DataIO.ClassType.Group) { storedproc = "[Profile.Module].[NetworkAuthorshipTimeline.Group.GetData]"; } Profiles.Profile.Modules.CustomViewAuthorInAuthorshipTimeline.DataIO.VisualizationImageLink vil = data.GetGoogleTimeline(new RDFTriple(Convert.ToInt64(System.Configuration.ConfigurationManager.AppSettings["Search.PublicationsNodeID2"].ToString())), storedproc); timelineBar.Src = vil.src; timelineBar.Alt = vil.alt; litTimelineTable.Text = vil.asText; 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"); //if (type == Utilities.DataIO.ClassType.Group) divPubHeaderText.Visible = false; Framework.Utilities.DebugLogging.Log("PUBLICATION MODULE end Milliseconds:" + (DateTime.Now - d).TotalSeconds); }
public void GetSubjectProfile() { Profile.Utilities.DataIO dataio = new Profile.Utilities.DataIO(); Namespace rdfnamespaces = new Namespace(); try { this.RDFTriple = new RDFTriple(Convert.ToInt64(HttpContext.Current.Request.QueryString["subject"])); this.RDFTriple.ShowDetails = true; this.RDFTriple.Expand = true; //This method is used during the edit process. this.RDFTriple.Edit = true; this.BaseData = dataio.GetRDFData(this.RDFTriple); this.Namespaces = rdfnamespaces.LoadNamespaces(this.BaseData); } catch (Exception ex) { Framework.Utilities.DebugLogging.Log(ex.Message + " ++ " + ex.StackTrace); } }
public void GetNetworkProfile(Int64 subject, Int64 predicate) { Profile.Utilities.DataIO dataio = new Profile.Utilities.DataIO(); Namespace rdfnamespaces = new Namespace(); try { this.RDFTriple = new RDFTriple(subject, predicate); this.RDFTriple.ShowDetails = true; this.RDFTriple.Expand = true; //This method is used during the edit process. this.RDFTriple.Edit = true; this.BaseData = dataio.GetRDFData(this.RDFTriple); this.Namespaces = rdfnamespaces.LoadNamespaces(this.BaseData); } catch (Exception ex) { Framework.Utilities.DebugLogging.Log(ex.Message + " ++ " + ex.StackTrace); } }
//Need to process this at the page level for the framework data //to process the presentation XML public void LoadRDFSearchResults() { XmlDocument xml = new XmlDocument(); Namespace rdfnamespaces = new Namespace(); Utilities.DataIO data = new Utilities.DataIO(); string searchtype = string.Empty; string lname = string.Empty; string fname = string.Empty; string institution = string.Empty; string department = string.Empty; string division = string.Empty; string searchfor = string.Empty; string classgroupuri = string.Empty; string classuri = string.Empty; string perpage = string.Empty; string offset = string.Empty; string sortby = string.Empty; string sortdirection = string.Empty; string searchrequest = string.Empty; string otherfilters = string.Empty; string institutionallexcept = string.Empty; string departmentallexcept = string.Empty; string divisionallexcept = string.Empty; string exactphrase = string.Empty; string nodeuri = string.Empty; string nodeid = string.Empty; if (this.SearchType.IsNullOrEmpty() == false) searchtype = this.SearchType; //else if (Request.Form["searchtype"] != null) //{ // searchtype = Request.Form["searchtype"]; //} if (Request.QueryString["searchfor"].IsNullOrEmpty() == false) searchfor = Request.QueryString["searchfor"]; if (Request.Form["txtSearchFor"].IsNullOrEmpty() == false) searchfor = Request.Form["txtSearchFor"]; if (Request.QueryString["lname"].IsNullOrEmpty() == false) lname = Request.QueryString["lname"]; if (Request.QueryString["institution"].IsNullOrEmpty() == false) institution = Request.QueryString["institution"]; if (Request.QueryString["department"].IsNullOrEmpty() == false) department = Request.QueryString["department"]; if (Request.QueryString["division"].IsNullOrEmpty() == false) division = Request.QueryString["division"]; if (Request.QueryString["fname"].IsNullOrEmpty() == false) fname = Request.QueryString["fname"]; if (Request.QueryString["classgroupuri"].IsNullOrEmpty() == false) classgroupuri = HttpUtility.UrlDecode(Request.QueryString["classgroupuri"]); else classgroupuri = HttpUtility.UrlDecode(Request.Form["classgroupuri"]); if (classgroupuri != null) { if (classgroupuri.Contains("!")) classgroupuri = classgroupuri.Replace('!', '#'); } if (Request.QueryString["classuri"].IsNullOrEmpty() == false) classuri = HttpUtility.UrlDecode(Request.QueryString["classuri"]); else classuri = HttpUtility.UrlDecode(Request.Form["classuri"]); if (classuri != null) { if (classuri.Contains("!")) classuri = classuri.Replace('!', '#'); } else { classuri = ""; } if (Request.QueryString["perpage"].IsNullOrEmpty() == false) perpage = Request.QueryString["perpage"]; else perpage = Request.Form["perpage"]; //if (perpage == string.Empty || perpage == null) //{ // perpage = Request.QueryString["perpage"]; //} if (perpage.IsNullOrEmpty()) perpage = "15"; if (Request.QueryString["offset"].IsNullOrEmpty() == false) offset = Request.QueryString["offset"]; else offset = Request.Form["offset"]; if (offset.IsNullOrEmpty()) offset = "0"; //if (offset == null) // offset = "0"; if (Request.QueryString["sortby"].IsNullOrEmpty() == false) sortby = Request.QueryString["sortby"]; if (Request.QueryString["sortdirection"].IsNullOrEmpty() == false) sortdirection = Request.QueryString["sortdirection"]; if (Request.QueryString["searchrequest"].IsNullOrEmpty() == false) searchrequest = Request.QueryString["searchrequest"]; else if (masterpage.SearchRequest.IsNullOrEmpty() == false) searchrequest = masterpage.SearchRequest; if (Request.QueryString["otherfilters"].IsNullOrEmpty() == false) otherfilters = Request.QueryString["otherfilters"]; if (Request.QueryString["institutionallexcept"].IsNullOrEmpty() == false) institutionallexcept = Request.QueryString["institutionallexcept"]; if (Request.QueryString["departmentallexcept"].IsNullOrEmpty() == false) departmentallexcept = Request.QueryString["departmentallexcept"]; if (Request.QueryString["divisionallexcept"].IsNullOrEmpty() == false) divisionallexcept = Request.QueryString["divisionallexcept"]; if (Request.QueryString["exactphrase"].IsNullOrEmpty() == false) exactphrase = Request.QueryString["exactphrase"]; if (Request.QueryString["nodeuri"].IsNullOrEmpty() == false) { nodeuri = Request.QueryString["nodeuri"]; nodeid = nodeuri.Substring(nodeuri.LastIndexOf("/") + 1); } switch (searchtype.ToLower()) { case "everything": if (searchrequest != string.Empty) xml.LoadXml(data.DecryptRequest(searchrequest)); else xml = data.SearchRequest(searchfor, exactphrase, classgroupuri, classuri, perpage, offset); break; default: //Person is the default if (searchrequest != string.Empty) xml.LoadXml(data.DecryptRequest(searchrequest)); else xml = data.SearchRequest(searchfor, exactphrase, fname, lname, institution, institutionallexcept, department, departmentallexcept, division, divisionallexcept, classuri, perpage, offset, sortby, sortdirection, otherfilters, "", ref searchrequest); break; } if (nodeuri != string.Empty && nodeid != string.Empty) masterpage.RDFData = data.WhySearch(xml, nodeuri, Convert.ToInt64(nodeid)); else masterpage.RDFData = data.Search(xml, false); Framework.Utilities.DebugLogging.Log(masterpage.RDFData.OuterXml); masterpage.RDFNamespaces = rdfnamespaces.LoadNamespaces(masterpage.RDFData); masterpage.SearchRequest = searchrequest; }
public void GetDataByURI() { Profile.Utilities.DataIO dataio = new Profile.Utilities.DataIO(); Namespace rdfnamespaces = new Namespace(); try { if (this.RDFTriple == null) { if (this.BaseData.SelectSingleNode(this.GetModuleParamString("DataURI"), this.Namespaces).InnerText.Contains(Root.Domain)) { string[] vars = this.BaseData.SelectSingleNode(this.GetModuleParamString("DataURI"), this.Namespaces).InnerText.Split('/'); //SPO Int64 subject = 0; Int64 predicate = 0; Int64 _object = 0; Int64 result; for (int i = 0; i < vars.Length; i++) { if (Int64.TryParse(vars[i], out result)) { if (subject != 0 && predicate != 0 && _object == 0) { _object = Convert.ToInt64(vars[i]); } if (subject != 0 && predicate == 0) { predicate = Convert.ToInt64(vars[i]); } if (subject == 0) { subject = Convert.ToInt64(vars[i]); } } } this.RDFTriple = new RDFTriple(subject, predicate, _object); } else { this.RDFTriple = new RDFTriple(this.BaseData.SelectSingleNode(this.GetModuleParamString("DataURI"), this.Namespaces).InnerText); } } if (this.GetModuleParamString("Offset") != string.Empty) { this.RDFTriple.Offset = this.GetModuleParamString("Offset"); } else { this.RDFTriple.Offset = string.Empty; } if (this.GetModuleParamString("Limit") != string.Empty) { this.RDFTriple.Limit = this.GetModuleParamString("Limit"); } else { this.RDFTriple.Limit = string.Empty; } if (this.GetModuleParamString("Edit") == "true") { this.RDFTriple.Edit = true; } if (this.GetModuleParamXml("ExpandRDFList") != null) { XmlNode x = this.GetModuleParamXml("ExpandRDFList"); if (x != null) { this.RDFTriple.ExpandRDFList = x.InnerXml; } } this.RDFTriple.ShowDetails = true; this.RDFTriple.Expand = true; this.BaseData = dataio.GetRDFData(this.RDFTriple); this.Namespaces = rdfnamespaces.LoadNamespaces(this.BaseData); } catch (Exception ex) { Framework.Utilities.DebugLogging.Log(ex.Message + " ++ " + ex.StackTrace); } }
protected void cmdSaveByURI_onclick(object sender, ImageClickEventArgs e) { Edit.Utilities.DataIO data = new Profiles.Edit.Utilities.DataIO(); if (txtURI.Text.ToLower().Trim() != string.Empty) { string uri = string.Empty; bool validuri = false; bool urifound = false; XmlNamespaceManager nmsmanager = null; pnlAddByURI.Visible = false; //you need to get back the actual URI that is discovered during the post. //The post might be to an HTML document where I have to look for an alt link to RDF data. //Plus the URI we get back from this method needs to be used to create a triple in our Database so dont lose it. XmlDocument rtndata = data.GetURIRelLink(txtURI.Text.Trim(), ref uri); if (rtndata.InnerXml != string.Empty) urifound = true; if (urifound) { Framework.Utilities.Namespace namespaces = new Namespace(); nmsmanager = namespaces.LoadNamespaces(rtndata); if (rtndata.SelectSingleNode("rdf:RDF/rdf:Description/rdf:type[@rdf:resource='" + PropertyList[0].Value + "']", nmsmanager) != null) validuri = true; } if (uri.Trim() != string.Empty) { litAddByURIConfirmLabel.Text = rtndata.SelectSingleNode("rdf:RDF/rdf:Description[@rdf:about='" + uri + "']/rdfs:label", nmsmanager).InnerText; hdnURI.Value = uri; } else { litAddByURIConfirmLabel.Text = txtURI.Text.Trim(); hdnURI.Value = txtURI.Text.Trim(); } if (validuri) litAddByURIConfirmType.Text = PropertyList[0].Text; else if (!urifound) litAddByURIConfirmType.Text = "The item could not be found. Do you still want to add this URL?"; else if (!validuri) litAddByURIConfirmType.Text = "The item type is invalid. Do you want to add this item anyway?"; pnlAddByURIConfirm.Visible = true; pnlAddBySearch.Visible = false; pnlAddNew.Visible = false; pnlAddByURI.Visible = false; phAddBySearch.Visible = false; phAddNew.Visible = false; phAddByURL.Visible = true; imgAddArror.ImageUrl = "~/Framework/Images/icon_squareDownArrow.gif"; Session["pnlAddByURI.Visible"] = true; } }
private void DrawProfilesModule() { DateTime d = DateTime.Now; Profiles.Profile.Utilities.DataIO data = new Profiles.Profile.Utilities.DataIO(); List <Publication> publication = new List <Publication>(); Utilities.DataIO.ClassType type = Utilities.DataIO.ClassType.Unknown; Framework.Utilities.Namespace xmlnamespace = new Profiles.Framework.Utilities.Namespace(); XmlNamespaceManager namespaces = xmlnamespace.LoadNamespaces(BaseData); if (BaseData.SelectSingleNode("rdf:RDF/rdf:Description[1]/rdf:type[@rdf:resource='http://xmlns.com/foaf/0.1/Person']", namespaces) != null) { type = Utilities.DataIO.ClassType.Person; } if (BaseData.SelectSingleNode("rdf:RDF/rdf:Description[1]/rdf:type[@rdf:resource='http://xmlns.com/foaf/0.1/Group']", namespaces) != null) { type = Utilities.DataIO.ClassType.Grant; } using (SqlDataReader reader = data.GetPublications(base.RDFTriple, type)) { 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 string storedproc = "[Profile.Module].[NetworkAuthorshipTimeline.Person.GetData]"; if (type == Utilities.DataIO.ClassType.Grant) { storedproc = "[Profile.Module].[NetworkAuthorshipTimeline.Group.GetData]"; } using (SqlDataReader reader = data.GetGoogleTimeline(base.RDFTriple, storedproc)) { 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"); if (type == Utilities.DataIO.ClassType.Grant) { divPubHeaderText.Visible = false; } Framework.Utilities.DebugLogging.Log("PUBLICATION MODULE end Milliseconds:" + (DateTime.Now - d).TotalSeconds); }
protected void DrawUIOnLoad() { oDataIO = new DIRECT.Utilities.DataIO(); Profiles.DIRECT.Utilities.DataIO searchDataIO; string DirectServiceURL = Root.Domain + "/DIRECT/Modules/DirectSearch/directservice.aspx";// Request.Url.AbsoluteUri.Replace("&", "&"); string ProfilesURL = Root.Domain; string PopulationTypeText = oDataIO.GetDirectConfig().PopulationType; int QueryTimeout = oDataIO.GetDirectConfig().Timeout; XmlDocument query = new XmlDocument(); XmlDocument result; Framework.Utilities.Namespace rdfnamespaces = new Namespace(); XmlNamespaceManager namespaces = null; string sql = string.Empty; string ResultDetailsURL = string.Empty; string strResult = ""; SqlDataReader dr; if (Request["Request"] == null) { return; } string task = Request["Request"].ToLower(); switch (task) { case "getsites": string ResultStr = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>" + "<site-list>"; dr = oDataIO.GetSitesOrderBySortOrder(); while (dr.Read()) { Int64 SiteID = Convert.ToInt64(dr["SiteID"]); string SiteName = dr["SiteName"].ToString(); string QueryURL = dr["QueryURL"].ToString(); if (SiteName == null) SiteName = ""; if (QueryURL == null) QueryURL = ""; ResultStr = ResultStr + "<site-description><site-id>" + SiteID + "</site-id><name>" + cx(SiteName) + "</name><aggregate-query>" + cx(QueryURL) + "</aggregate-query></site-description>"; } if (!dr.IsClosed) dr.Close(); ResultStr += "</site-list>"; Response.ContentType = "text/xml"; Response.AddHeader("Content-Type", "text/xml;charset=UTF-8"); //Response.ContentEncoding.CodePage = 65001; Response.Charset = "UTF-8"; Response.Write(ResultStr); break; case "incomingcount": string q = Request["SearchPhrase"].Trim(); // Enter log record sql = "insert into [Direct.].LogIncoming(Details,ReceivedDate,RequestIP,QueryString) " + " values (0,GetDate()," + cs(Request.ServerVariables["REMOTE_ADDR"]) + "," + cs(q) + ")"; oDataIO.ExecuteSQLDataCommand(sql); // Execute query string x = "<SearchOptions>" + "<MatchOptions>" + "<SearchString ExactMatch=\"false\">" + cx(q) + "</SearchString> " + "<SearchFiltersList /> " + "<ClassURI>http://xmlns.com/foaf/0.1/Person</ClassURI> " + "</MatchOptions>" + "<OutputOptions>" + "<Offset>0</Offset>" + "<Limit>1</Limit> " + "<SortByList>" + "</SortByList>" + "</OutputOptions>" + "</SearchOptions>"; query.LoadXml(x); searchDataIO = new Profiles.DIRECT.Utilities.DataIO(); result = searchDataIO.Search(query); namespaces = rdfnamespaces.LoadNamespaces(result); string ResultCount = result.SelectSingleNode("rdf:RDF/rdf:Description/prns:numberOfConnections", namespaces).InnerText; // Form result message ResultStr = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>"; ResultStr += "<aggregation-result>"; ResultStr += "<count>" + ResultCount + "</count>"; ResultStr += "<population-type>" + PopulationTypeText + "</population-type>"; ResultStr += "<preview-URL>" + DirectServiceURL + "?Request=IncomingPreview&SearchPhrase=" + cx(q) + "</preview-URL>"; ResultStr += "<search-results-URL>" + DirectServiceURL + "?Request=IncomingDetails&SearchPhrase=" + cx(q) + "</search-results-URL>"; ResultStr += "</aggregation-result>"; // Send result Response.ContentType = "text/xml"; Response.AddHeader("Content-Type", "text/xml;charset=UTF-8"); //Response.ContentEncoding.CodePage = 65001; Response.Charset = "UTF-8"; Response.Write(ResultStr); break; case "incomingdetails": q = Request["SearchPhrase"].Trim(); // Enter log record sql = "insert into [Direct.].LogIncoming(Details,ReceivedDate,RequestIP,QueryString) "; sql += " values (1,GetDate()," + cs(Request.ServerVariables["REMOTE_ADDR"]) + "," + cs(q) + ")"; oDataIO.ExecuteSQLDataCommand(sql); // Execute query query.LoadXml("<SearchOptions>" + "<MatchOptions>" + "<SearchString ExactMatch=\"false\">" + cx(q) + "</SearchString> " + "<SearchFiltersList /> " + "<ClassURI>http://xmlns.com/foaf/0.1/Person</ClassURI> " + "</MatchOptions>" + "<OutputOptions>" + "<Offset>0</Offset>" + "<Limit>1</Limit> " + "<SortByList>" + "</SortByList>" + "</OutputOptions>" + "</SearchOptions>"); searchDataIO = new Profiles.DIRECT.Utilities.DataIO(); result = searchDataIO.Search(query); strResult = result.InnerXml; // Parse results XmlDocument objDoc = new XmlDocument(); objDoc = new XmlDocument(); objDoc.LoadXml(strResult); namespaces = rdfnamespaces.LoadNamespaces(result); ResultCount = result.SelectSingleNode("rdf:RDF/rdf:Description/prns:numberOfConnections", namespaces).InnerText; if (ProfilesURL.Substring(ProfilesURL.Length - 1) != "/") { ProfilesURL += "/"; } Response.Redirect(ProfilesURL + "search/default.aspx?searchtype=people&classuri=http://xmlns.com/foaf/0.1/Person&searchfor=" + q); break; case "incomingpreview": q = Request["SearchPhrase"].Trim(); Utilities.DataIO data = new Profiles.DIRECT.Utilities.DataIO(); string searchphrase = Request["SearchPhrase"].Trim(); Response.Write(data.Search(searchphrase)); break; case "outgoingcount": if (Request["blank"] == "y") { Response.Write("<html><body></body></html>"); Response.End(); } string SearchPhrase = Request["SearchPhrase"]; Response.Write("<script>parent.dsLoading=1;</script>" + Environment.NewLine); dr = oDataIO.GetSitesOrderBySiteID(); SiteIDs = new int[1000]; URLs = new string[1000]; FSIDs = new string[1000]; Site site; ListOfSites = new List<Site>(); Int64 sites = 0; List<AsyncProcessing> ListOfThreads = new List<AsyncProcessing>(); AsyncProcessing async; while (dr.Read()) { SiteIDs[sites] = Convert.ToInt32(dr["SiteID"].ToString()); URLs[sites] = dr["QueryURL"] + SearchPhrase; FSIDs[sites] = dr["FSID"].ToString(); site = new Site(URLs[sites], SiteIDs[sites], FSIDs[sites], SearchPhrase, HttpContext.Current); ListOfSites.Add(site); async = new AsyncProcessing(); async.BeginProcessRequest(site); ListOfThreads.Add(async); sites++; } if (!dr.IsClosed) dr.Close(); //eat up the CPU for x number of seconds :) so all the requests can come back. This is set in the web.config file DateTime end = DateTime.Now.AddSeconds(QueryTimeout); while (DateTime.Now < end) { } //close out anything that did not complete in 5 seconds for (int loop = 0; loop < ListOfThreads.Count; loop++) { if (!ListOfThreads[loop].Site.IsDone) { sql = "update [Direct.].LogOutgoing set ResponseTime = datediff(ms,SentDate,GetDate()), " + " ResponseState = " + 1 + " where FSID = " + cs(ListOfThreads[loop].Site.FSID); oDataIO.ExecuteSQLDataCommand(sql); Response.Write("<script>parent.siteResult(" + ListOfThreads[loop].Site.SiteID + ",1,0,'','','','');</script>"); ListOfThreads.Remove(ListOfThreads[loop]); } } try { Response.Flush(); } catch { } break; case "outgoingdetails": string FSID = Request["fsid"].Trim(); string SiteId = string.Empty; if (FSID != "") { dr = oDataIO.GetFsID(cs(FSID)); if (dr.Read()) { SiteId = dr["SiteID"].ToString(); ResultDetailsURL = dr["ResultDetailsURL"].ToString().Replace("\n\t", ""); } if (!dr.IsClosed) dr.Close(); } if ((FSID != "") && (SiteId != "") && (ResultDetailsURL != "")) { // Enter log record oDataIO.ExecuteSQLDataCommand("insert into [Direct.].LogOutgoing(FSID,SiteID,Details,SentDate) " + " values ('" + FSID + "'," + SiteId + ",1,GetDate())"); Response.Redirect(ResultDetailsURL); } else Response.Redirect(ProfilesURL); break; } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { masterpage = (Framework.Template)base.Master; masterpage.Tab = ""; string method = string.Empty; if (Request.QueryString["method"] != null) { method = Request.QueryString["method"]; } else { method = "manage"; } this.LoadPresentationXML(method); this.LoadAssets(); BaseModule bm = new BaseModule(); XmlNamespaceManager xnm; Framework.Utilities.Namespace name = new Namespace(); bm.GetSubjectProfile(); xnm = name.LoadNamespaces(bm.BaseData); masterpage.RDFData = bm.BaseData; masterpage.RDFNamespaces = xnm; bm = null; masterpage.PresentationXML = this.PresentationXML; }
private void DrawProfilesModule() { DataIO.PublicationsType pt; if (base.Context.Request.RawUrl.Contains("Publications=All")) { pt = DataIO.PublicationsType.All; aAllPubs.HRef = ""; aAllPubs.Attributes.Add("class", "selected"); aCoronaPubs.HRef = base.Context.Request.Path + ""; aCovidPubs.HRef = base.Context.Request.Path + "?Publications=Covid-19"; } else if (base.Context.Request.RawUrl.Contains("Publications=Covid-19")) { pt = DataIO.PublicationsType.Covid; aCovidPubs.HRef = ""; aCovidPubs.Attributes.Add("class", "selected"); aCoronaPubs.HRef = base.Context.Request.Path + ""; aAllPubs.HRef = base.Context.Request.Path + "?Publications=All"; } else { pt = DataIO.PublicationsType.Coronavirus; aCoronaPubs.HRef = ""; aCoronaPubs.Attributes.Add("class", "selected"); aAllPubs.HRef = base.Context.Request.Path + "?Publications=All"; aCovidPubs.HRef = base.Context.Request.Path + "?Publications=Covid-19"; } DateTime d = DateTime.Now; Profiles.Profile.Modules.CustomViewAuthorInAuthorship.DataIO data = new Profiles.Profile.Modules.CustomViewAuthorInAuthorship.DataIO(); List <Publication> publication = new List <Publication>(); Utilities.DataIO.ClassType type = Utilities.DataIO.ClassType.Unknown; Framework.Utilities.Namespace xmlnamespace = new Profiles.Framework.Utilities.Namespace(); XmlNamespaceManager namespaces = xmlnamespace.LoadNamespaces(BaseData); if (BaseData.SelectSingleNode("rdf:RDF/rdf:Description[1]/rdf:type[@rdf:resource='http://xmlns.com/foaf/0.1/Person']", namespaces) != null) { type = Utilities.DataIO.ClassType.Person; } if (BaseData.SelectSingleNode("rdf:RDF/rdf:Description[1]/rdf:type[@rdf:resource='http://xmlns.com/foaf/0.1/Group']", namespaces) != null) { type = Utilities.DataIO.ClassType.Group; } using (SqlDataReader reader = data.GetPublications(base.RDFTriple, type, pt)) { while (reader.Read()) { publication.Add(new Publication(reader["bibo_pmid"].ToString(), reader["vivo_pmcid"].ToString(), reader["prns_informationResourceReference"].ToString(), reader["vivo_webpage"].ToString(), Convert.ToInt32(reader["PMCCitations"]), reader["Fields"].ToString(), Convert.ToInt32(reader["TranslationHumans"]), Convert.ToInt32(reader["TranslationAnimals"]), Convert.ToInt32(reader["TranslationCells"]), Convert.ToInt32(reader["TranslationPublicHealth"]), Convert.ToInt32(reader["TranslationClinicalTrial"]))); } rpPublication.DataSource = publication; rpPublication.DataBind(); } if (type == Utilities.DataIO.ClassType.Group) { divPubHeaderText.Visible = false; } Framework.Utilities.DebugLogging.Log("PUBLICATION MODULE end Milliseconds:" + (DateTime.Now - d).TotalSeconds); }
public void GetDataByURI() { Profile.Utilities.DataIO dataio = new Profile.Utilities.DataIO(); Namespace rdfnamespaces = new Namespace(); try { if (this.RDFTriple == null) this.RDFTriple = new RDFTriple(this.BaseData.SelectSingleNode(this.GetModuleParamString("DataURI"), this.Namespaces).InnerText); if (this.GetModuleParamString("Offset") != string.Empty) this.RDFTriple.Offset = this.GetModuleParamString("Offset"); else this.RDFTriple.Offset = string.Empty; if (this.GetModuleParamString("Limit") != string.Empty) this.RDFTriple.Limit = this.GetModuleParamString("Limit"); else this.RDFTriple.Limit = string.Empty; if (this.GetModuleParamString("Edit") == "true") this.RDFTriple.Edit = true; this.RDFTriple.ShowDetails = true; this.RDFTriple.Expand = true; this.BaseData = dataio.GetRDFData(this.RDFTriple); this.Namespaces = rdfnamespaces.LoadNamespaces(this.BaseData); } catch (Exception ex) { Framework.Utilities.DebugLogging.Log(ex.Message + " ++ " + ex.StackTrace); } }
public void GetDataByURI() { Profile.Utilities.DataIO dataio = new Profile.Utilities.DataIO(); Namespace rdfnamespaces = new Namespace(); try { if (this.RDFTriple == null) { if (this.BaseData.SelectSingleNode(this.GetModuleParamString("DataURI"), this.Namespaces).InnerText.Contains(Root.Domain)) { string[] vars = this.BaseData.SelectSingleNode(this.GetModuleParamString("DataURI"), this.Namespaces).InnerText.Split('/'); //SPO Int64 subject = 0; Int64 predicate = 0; Int64 _object = 0; Int64 result; for (int i = 0; i < vars.Length; i++) { if (Int64.TryParse(vars[i], out result)) { if (subject != 0 && predicate != 0 && _object == 0) _object = Convert.ToInt64(vars[i]); if (subject != 0 && predicate == 0) predicate = Convert.ToInt64(vars[i]); if (subject == 0) subject = Convert.ToInt64(vars[i]); } } this.RDFTriple = new RDFTriple(subject, predicate, _object); } else { this.RDFTriple = new RDFTriple(this.BaseData.SelectSingleNode(this.GetModuleParamString("DataURI"), this.Namespaces).InnerText); } } if (this.GetModuleParamString("Offset") != string.Empty) this.RDFTriple.Offset = this.GetModuleParamString("Offset"); else this.RDFTriple.Offset = string.Empty; if (this.GetModuleParamString("Limit") != string.Empty) this.RDFTriple.Limit = this.GetModuleParamString("Limit"); else this.RDFTriple.Limit = string.Empty; if (this.GetModuleParamString("Edit") == "true") this.RDFTriple.Edit = true; if (this.GetModuleParamXml("ExpandRDFList") != null) { XmlNode x = this.GetModuleParamXml("ExpandRDFList"); if (x != null) this.RDFTriple.ExpandRDFList = x.InnerXml; } this.RDFTriple.ShowDetails = true; this.RDFTriple.Expand = true; this.BaseData = dataio.GetRDFData(this.RDFTriple); this.Namespaces = rdfnamespaces.LoadNamespaces(this.BaseData); } catch (Exception ex) { Framework.Utilities.DebugLogging.Log(ex.Message + " ++ " + ex.StackTrace); } }
public void LoadRDFData() { Framework.Utilities.DebugLogging.Log("{Page Calling} Profile.ProfileData.LoadRDFData() start " + ((System.Web.UI.TemplateControl)(this)).AppRelativeVirtualPath); XmlDocument xml = new XmlDocument(); Namespace rdfnamespaces = new Namespace(); Profiles.Profile.Utilities.DataIO data = new Profiles.Profile.Utilities.DataIO(); if (HttpContext.Current.Request.Headers["Offset"] != null) this.RDFTriple.Offset = HttpContext.Current.Request.Headers["Offset"]; if (HttpContext.Current.Request.Headers["Limit"] != null) this.RDFTriple.Limit = HttpContext.Current.Request.Headers["Limit"]; if (HttpContext.Current.Request.Headers["ExpandRDFList"] != null) this.RDFTriple.ExpandRDFList = HttpContext.Current.Request.Headers["ExpandRDFList"]; xml = data.GetRDFData(this.RDFTriple); this.RDFData = xml; this.RDFNamespaces = rdfnamespaces.LoadNamespaces(xml); Framework.Utilities.DebugLogging.Log("{Page Calling} Profile.ProfileData.LoadRDFData() end" + ((System.Web.UI.TemplateControl)(this)).AppRelativeVirtualPath); }
public void LoadPageData() { Framework.Utilities.Namespace namespaces = new Namespace(); Profiles.Profile.Utilities.DataIO data = new Profiles.Profile.Utilities.DataIO(); this.PresentationXML = data.GetPresentationData(this.RDFTriple); XmlNode x = this.PresentationXML.SelectSingleNode("Presentation[1]/ExpandRDFList[1]"); if (x != null) this.RDFTriple.ExpandRDFList = x.OuterXml; this.RDFData = data.GetRDFData(this.RDFTriple); this.RDFNamespaces = namespaces.LoadNamespaces(this.RDFData); }
public void DrawProfilesModule() { string countrycodes = string.Empty; DataIOMap dataIO = new Search.Utilities.DataIOMap(); string researchers = Newtonsoft.Json.JsonConvert.SerializeObject(dataIO.GetTopGeoResearchers()); string countries = Newtonsoft.Json.JsonConvert.SerializeObject(dataIO.GetCountryCounts()); using (StreamReader sr = new StreamReader(Server.MapPath("~/Search/Modules/SearchMap/countries.json"))) { countrycodes = sr.ReadToEnd(); } litJS.Text = string.Format("<script>var countries = {0}; var researchers = {1};var countrycodes = {2};</script>", countries, researchers, countrycodes); Profiles.Profile.Modules.CustomViewAuthorInAuthorshipTimeline.DataIO data = new Profiles.Profile.Modules.CustomViewAuthorInAuthorshipTimeline.DataIO(); List <Publication> publication = new List <Publication>(); Profiles.Profile.Utilities.DataIO.ClassType type = Profiles.Profile.Utilities.DataIO.ClassType.Unknown; Framework.Utilities.Namespace xmlnamespace = new Profiles.Framework.Utilities.Namespace(); XmlNamespaceManager namespaces = xmlnamespace.LoadNamespaces(BaseData); //if (BaseData.SelectSingleNode("rdf:RDF/rdf:Description[1]/rdf:type[@rdf:resource='http://xmlns.com/foaf/0.1/Person']", namespaces) != null) // type = Utilities.DataIO.ClassType.Person; //if (BaseData.SelectSingleNode("rdf:RDF/rdf:Description[1]/rdf:type[@rdf:resource='http://xmlns.com/foaf/0.1/Group']", namespaces) != null) type = Profiles.Profile.Utilities.DataIO.ClassType.Group; using (SqlDataReader reader = data.GetPublications(base.RDFTriple, type)) { while (reader.Read()) { publication.Add(new Publication(reader["bibo_pmid"].ToString(), reader["vivo_pmcid"].ToString(), reader["prns_informationResourceReference"].ToString(), reader["vivo_webpage"].ToString(), Convert.ToInt32(reader["PMCCitations"]), reader["Fields"].ToString(), Convert.ToInt32(reader["TranslationHumans"]), Convert.ToInt32(reader["TranslationAnimals"]), Convert.ToInt32(reader["TranslationCells"]), Convert.ToInt32(reader["TranslationPublicHealth"]), Convert.ToInt32(reader["TranslationClinicalTrial"]))); } rpPublication.DataSource = publication; rpPublication.DataBind(); } // Get timeline bar chart string storedproc = "[Profile.Module].[NetworkAuthorshipTimeline.Person.GetData]"; if (type == Profiles.Profile.Utilities.DataIO.ClassType.Group) { storedproc = "[Profile.Module].[NetworkAuthorshipTimeline.Group.GetData]"; } Profiles.Profile.Modules.CustomViewAuthorInAuthorshipTimeline.DataIO.VisualizationImageLink vil = data.GetGoogleTimeline(new RDFTriple(Convert.ToInt64(System.Configuration.ConfigurationManager.AppSettings["Search.PublicationsNodeID2"].ToString())), storedproc); Profiles.Profile.Modules.CustomViewAuthorInAuthorshipTimeline.DataIO.VisualizationImageLink vilCOVID = data.GetGoogleTimelineCOVID(new RDFTriple(Convert.ToInt64(System.Configuration.ConfigurationManager.AppSettings["Search.PublicationsNodeID2"].ToString())), storedproc); timelineBarCOVID.Src = vilCOVID.src; timelineBarCOVID.Alt = vilCOVID.alt; timelineBar.Src = vil.src; timelineBar.Alt = vil.alt; litTimelineTable.Text = vil.asText; 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"); //if (type == Utilities.DataIO.ClassType.Group) divPubHeaderText.Visible = false; }