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

GetPublicationsCount() public method

public GetPublicationsCount ( ) : int
return int
        public int GetPublicationsCount()
        {
            string sql = "select (select count(distinct(PMID)) from [Profile.Data].[Publication.Person.Include] i join [Profile.Data].[Person] p on p.personid = i.personid where PMID is not null and isactive = 1) + " +
                                "(select count(distinct(MPID)) from [Profile.Data].[Publication.Person.Include] i join [Profile.Data].[Person] p on p.personid = i.personid where MPID is not null and 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();
 }