Profiles.Activity.Utilities.DataIO.GetEditedCount C# (CSharp) Method

GetEditedCount() public method

public GetEditedCount ( ) : int
return int
        public int GetEditedCount()
        {
            string sql = "select count(*) from [Profile.Data].Person p " +
                            "join (select InternalID as PersonID from [RDF.Stage].InternalNodeMap i " +
                            "join (select distinct subject from [RDF.].Triple t " +
                            "join [RDF.].Node n on t.Predicate = n.NodeID and n.value in " +
                            "('http://profiles.catalyst.harvard.edu/ontology/prns#mainImage', 'http://vivoweb.org/ontology/core#awardOrHonor', " +
                            "'http://vivoweb.org/ontology/core#educationalTraining', 'http://vivoweb.org/ontology/core#freetextKeyword', 'http://vivoweb.org/ontology/core#overview')) t " +
                            "on i.NodeID = t.Subject and i.Class = 'http://xmlns.com/foaf/0.1/Person' union " +
                            "select distinct personid from [Profile.Data].[Publication.Person.Add] union " +
                            "select distinct personid from [Profile.Data].[Publication.Person.Exclude] as u) t " +
                            "on t.PersonID = p.PersonID " +
                            "and p.IsActive = 1";

            return GetCount(sql);
        }

Usage Example

Esempio n. 1
0
 public void DrawProfilesModule()
 {
     publicationsCount.Text   = "" + data.GetPublicationsCount();
     totalProfilesCount.Text  = "" + data.GetProfilesCount();
     editedProfilesCount.Text = "" + data.GetEditedCount();
 }