private List <ICodeMutableObject> AttributeCodelistFromFile(IAttributeConcept attribute)
{
List <ICodeMutableObject> AttributeCodesObjects = new List <ICodeMutableObject>();
try
{
XmlDocument configuration = new XmlDocument();
configuration.Load(FlyConfiguration.AttributeFile);
foreach (XmlNode item in configuration.ChildNodes[0].ChildNodes)
{
if (item.Name != "Attribute" && item.Attributes == null || item.Attributes["Code"] == null)
{
continue;
}
if (item.Attributes["Code"].Value == attribute.ConceptObjectCode)
{
foreach (XmlNode nodoCodelistAttr in CommonFunction.FindSubNodo(item, "Codelist").ChildNodes)
{
if (nodoCodelistAttr.Name == "Code" && nodoCodelistAttr.Attributes != null && nodoCodelistAttr.Attributes["value"] != null)
{
AttributeCodesObjects.Add(CodelistItemBuilder.BuildCodeObjects(nodoCodelistAttr.Attributes["value"].Value, SdmxObjectNameDescription.GetNameDescriptions(nodoCodelistAttr), null));
}
}
break;
}
}
}
catch (SdmxException) { throw; }
catch (Exception ex)
{
throw new SdmxException(this, FlyExceptionObject.FlyExceptionTypeEnum.GetAttributeError, ex);
}
return(AttributeCodesObjects);
}
/// <summary>
/// retrieves the codelist of FlagDimension (OBS_STATUS) from database
/// </summary>
/// <param name="DataflowCode">Dataflow Code</param>
/// <param name="flag">Instance of Attribute "AttributeConcept"</param>
/// <returns>list of Mutable Code Object</returns>
public List <ICodeMutableObject> GetFlagCodelist(string DataflowCode, IAttributeConcept flag)
{
try
{
if (!this.DbAccess.CheckExistStoreProcedure(DBOperationEnum.GetFlags))
{
return(new List <ICodeMutableObject>());
}
List <ICodeMutableObject> _CodesObjects = new List <ICodeMutableObject>();
//prima capisco se non è un attributo o un flag
List <IParameterValue> parametri = new List <IParameterValue>()
{
new ParameterValue()
{
Item = "Code", Value = DataflowCode
},
};
if (!string.IsNullOrEmpty(this.parsingObject.TimeStamp))
{
parametri.Add(new ParameterValue()
{
Item = "TimeStamp", Value = this.parsingObject.TimeStamp, SqlType = SqlDbType.DateTime
});
}
//EFFETTUO LA RICHIESTA AL DB
List <XmlNode> risposta = this.DbAccess.Execute(DBOperationEnum.GetFlags, parametri);
////PARSO LA RISPOSTA E CREO L'OGGETTO
if (risposta.Count == 1 && risposta[0].Name == "DataSet" && risposta[0].ChildNodes.Count > 0)
{
foreach (XmlNode Member in risposta[0])
{
if (Member.Name != "Flag" || Member.Attributes == null || Member.Attributes["Code"] == null)
{
continue;
}
string code = Member.Attributes["Code"].Value;
_CodesObjects.Add(CodelistItemBuilder.BuildCodeObjects(Member.Attributes["Code"].Value, SdmxObjectNameDescription.GetNameDescriptions(Member), null));
}
}
return(_CodesObjects);
}
catch (SdmxException) { throw; }
catch (Exception ex)
{
throw new SdmxException(this, FlyExceptionObject.FlyExceptionTypeEnum.CreateICodeMutableObject, ex);
}
}
/// <summary>
/// retrieves the codelist of an attribute from SP Attribute codelist NoConstrain or from the file "AttributeConcept.xml"
/// </summary>
/// <param name="attribute">Instance of Attribute "AttributeConcept"</param>
/// <returns>list of Mutable Code Object</returns>
public List <ICodeMutableObject> GetAttributeCodelistNoConstrain(IAttributeConcept attribute)
{
if (!this.DbAccess.CheckExistStoreProcedure(DBOperationEnum.GetAttributeCodelistConstrain))
{
return(AttributeCodelistFromFile(attribute));
}
else if (!FlyConfiguration.CodelistWhitoutConstrain)
{
throw new SdmxException(this, FlyExceptionObject.FlyExceptionTypeEnum.CodelistContrainRequired);
}
else
{
IDataflowsManager dfMan = new MetadataFactory().InstanceDataflowsManager(this.parsingObject.CloneForReferences(), this.versionTypeResp);
List <ICodeMutableObject> listCode = new List <ICodeMutableObject>();
var _foundedDataflow = dfMan.GetDataFlows();
foreach (var df in _foundedDataflow)
{
string dfCode = df.Id;
IAttributeManager _AttributeManager = new AttributeManagerSP(this.parsingObject, this.versionTypeResp);
if (!this.DbAccess.CheckExistStoreProcedure(DBOperationEnum.GetAttributes))
{
_AttributeManager = new AttributeManager_FromFile(this.parsingObject, this.versionTypeResp);
}
List <IAttributeConcept> conc = _AttributeManager.GetAttribute(dfCode);
if (conc.Exists(c => c.Id == attribute.Id))
{
foreach (ICodeMutableObject item in GetAttributeCodelistConstrain(dfCode, conc.Find(c => c.Id == attribute.Id)))
{
if (!listCode.Exists(cl => cl.Id == item.Id))
{
listCode.Add(item);
}
}
}
}
return(listCode);
}
}
/// <summary>
/// retrieves the codelist of an attribute from SP Attribute codelist Constrain or from the file "AttributeConcept.xml"
/// </summary>
/// <param name="DataflowCode">Dataflow Code</param>
/// <param name="attribute">Instance of Attribute "AttributeConcept"</param>
/// <returns>list of Mutable Code Object</returns>
public List <ICodeMutableObject> GetAttributeCodelistConstrain(string DataflowCode, IAttributeConcept attribute)
{
//prima capisco se non è un attributo o un flag
List <IParameterValue> parametri = new List <IParameterValue>()
{
new ParameterValue()
{
Item = "DatasetCode", Value = DataflowCode
},
new ParameterValue()
{
Item = "AttributeCode", Value = attribute.Id
},
new ParameterValue()
{
Item = "UserName", Value = FlyConfiguration.UserName
},
new ParameterValue()
{
Item = "Domain", Value = FlyConfiguration.Domain
},
};
if (!string.IsNullOrEmpty(this.parsingObject.TimeStamp))
{
parametri.Add(new ParameterValue()
{
Item = "TimeStamp", Value = this.parsingObject.TimeStamp, SqlType = SqlDbType.DateTime
});
}
//EFFETTUO LA RICHIESTA AL DB
List <XmlNode> risposta = this.DbAccess.Execute(DBOperationEnum.GetAttributeCodelistConstrain, parametri);
return(InternalGetAttributeCodelist(risposta));
}
