public string GetSingleStatement(Observation observation)
        {
            var mConcept = GetMConcept(observation.MConceptId);

            if (null == mConcept)
            {
                Log.Debug($"No concept {observation.MConceptId} for single statement");
                return(string.Empty);
            }

            var iqConcept = mConcept.IQConcepts.FirstOrDefault();

            if (null == iqConcept)
            {
                Log.Debug($"No iq-concept for {observation.MConceptId}");
                return(string.Empty);
            }
            StringBuilder singleBuilder = new StringBuilder();

            singleBuilder.AppendLine(
                $@"                    
                    UPDATE 
	                    {iqConcept.Tablename} 
                    SET 
	                    {iqConcept.Fieldname}={observation.ObsvalueSqlString()} 
                    WHERE 
	                    Ptn_pk=@ptnpk AND Visit_Pk=@visitipk AND LocationId=(select TOP 1 FacilityID from mst_Facility WHERE DeleteFlag = 0)
                    IF @@ROWCOUNT=0
                        Insert into 
                            [{iqConcept.Tablename}] (
                                [ptn_pk], [Visit_Pk], [LocationID],[{iqConcept.Fieldname}],UserId, CreateDate)
                        values (
                            @ptnpk,@visitipk, (select TOP 1 FacilityID from mst_Facility WHERE DeleteFlag = 0),{observation.ObsvalueSqlString()},{Patient.UserId},Getdate());");
            return(singleBuilder.ToString());
        }