/// <summary>
        /// return true if confidentiality might effect result
        /// </summary>
        public static bool IsAffectedByConfidentiality(int facilityID, string pollutantCode)
        {
            //Find data for confidential in the group of the pollutant
            LOV_POLLUTANT pollutant = ListOfValues.GetPollutant(pollutantCode);

            string groupCode = pollutant.ParentID.HasValue ? ListOfValues.GetPollutant(pollutant.ParentID.Value).Code : pollutantCode;

            var confidentialData = GetTimeSeries(facilityID, groupCode);

            return(confidentialData.Any());
        }
        /// <summary>
        /// Get confidential data for timeseries on facility level.
        /// The list will always contain data corresponding to the pollutant, even if no confidentiality claims has been made for any years
        /// </summary>
        public static List <TimeSeriesClasses.ConfidentialityPollutant> GetConfidentialTimeSeries(int facilityID, string pollutantCode)
        {
            //Find data for pollutant
            List <TimeSeriesClasses.PollutantTransfers> pollutantData = GetTimeSeries(facilityID, pollutantCode);

            //Find data for confidential in the group of the pollutant
            LOV_POLLUTANT pollutant = ListOfValues.GetPollutant(pollutantCode);
            string        groupCode = pollutant.ParentID.HasValue ? ListOfValues.GetPollutant(pollutant.ParentID.Value).Code : null;

            List <TimeSeriesClasses.PollutantTransfers> confidentialData = GetTimeSeries(facilityID, groupCode);

            //merge the two lists.
            List <TimeSeriesClasses.ConfidentialityPollutant> result = mergeList(pollutantData, confidentialData);

            return(result);
        }