public void UpdateProperty(IndicatorMetadataTextProperty property, string text, int indicatorId, int? profileId)
        {
            var groupMatch = profileId.HasValue ? "=" + profileId.Value : "IS NULL";

            var queryString = string.Format(
                @"update IndicatorMetadataTextValue set {0} = :text where IndicatorID = {1} AND ProfileId {2}",
                     property.ColumnName, indicatorId, groupMatch);

            var updateSession = CurrentSession.CreateQuery(queryString);

            updateSession.SetParameter("text", text);

            updateSession.ExecuteUpdate();
        }
        public void CreateNewOverriddenIndicator(IndicatorMetadataTextProperty property, string text, int indicatorId,
            int? profileId)
        {
            var indicatorMetaDataTextValue = new IndicatorMetadataTextValue()
            {
                IndicatorId = indicatorId,
                ProfileId = profileId,
            };

            indicatorMetaDataTextValue.SetPropertyValue(property.ColumnName, text);

            CurrentSession.Save(indicatorMetaDataTextValue);
        }