private void frmSelectValueDomain_Load(object sender, EventArgs e)
{
try
{
CommonItem.WaitOn();
BaseArtefactInfo[] vlList;
SelectedValueDomain = null;
VTLInt_Service.ServiceClient VTL_service = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
vlList = VTL_service.GetValueDomains();
ValuDomainListBox.Items.Clear();
if (vlList == null)
{
MessageBox.Show("There are not ValueDomain available into the database. Please, import the metadata from the metadata repository. (Metadata import)", "Empty", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
foreach (BaseArtefactInfo aInfo in vlList)
{
ValuDomainListBox.Items.Add(aInfo);
}
CommonItem.WaitOff();
}
catch (Exception ex)
{
CommonItem.ErrManger.ErrorManagement(ex, false, this);
}
}
private void FillValueDomainListBox()
{
try
{
CommonItem.WaitOn();
BaseArtefactInfo[] dsList;
VTLInt_Service.ServiceClient VTL_service = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
dsList = VTL_service.GetValueDomains();
if (dsList == null)
{
MessageBox.Show("There are not Value Domain available into the database. Please, import the metadata from the metadata repository. (Metadata import)", "Empty", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
this.ValueDomainListComboBox.Items.Clear();
this.ValueDomainListComboBox.Items.Add("Select a value domain parent...");
foreach (BaseArtefactInfo aInfo in dsList)
{
ValueDomainListComboBox.Items.Add(new ValueDomainContainer(aInfo));
}
CommonItem.WaitOff();
}
catch (Exception)
{
throw;
}
}
private void FillDataStructureForDataset()
{
try
{
CommonItem.WaitOn();
BaseArtefactInfo[] dsList;
VTLInt_Service.ServiceClient VTL_service = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
dsList = VTL_service.GetDataStructures();
if (dsList == null)
{
MessageBox.Show("There are not DataStructures available into the database. Please, import the metadata from the metadata repository. (Metadata import)", "Empty", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
DSDdataGridViewControl.Rows.Clear();
foreach (BaseArtefactInfo aInfo in dsList)
{
int rw = DSDdataGridViewControl.Rows.Add();
DSDdataGridViewControl.Rows[rw].Cells[0].Value = aInfo.vtlId;
DSDdataGridViewControl.Rows[rw].Cells[1].Value = aInfo.name[0].value;
}
CommonItem.WaitOff();
}
catch (Exception)
{
throw;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Do you want to import the selected artefacts?", "Import", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
foreach (string cb in checkedListBoxArtefact.CheckedItems)
{
if (cb.IndexOf("[DSD]") > -1)
{
}
else
{
string val = cb.Replace("[Codelist]: ", "");
string[] id_rest = val.Split(':');
string agency = id_rest[0].Trim();
string id = id_rest[1].Substring(0, id_rest[1].IndexOf('(')).Trim();
string version = id_rest[1].Substring(id_rest[1].IndexOf('(') + 1).Replace(")", "").Trim();
foreach (BaseArtefactInfo bs in _codelistList)
{
if (bs.sdmxId == id && bs.sdmxVersion == version && bs.sdmxAgency == agency)
{
CommonItem.WaitOn();
VTLInt_Service.ServiceClient VTLMan = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
BaseArtefactInfo[] one_item = { bs };
VTLMan.InsertValueDomain(id, agency, version, bs.name.ToArray(), one_item, true, BaseArtefactInfo.CREATION_TYPE.SDMX_WS_UPLOAD, ArtefactInfo.VTL.VTL_Model.VTL_DATATYPE.String);
CommonItem.WaitOff();
}
}
}
}
MessageBox.Show("Selected artefacts imported!");
}
}
private void frmSaveTrasformation_Load(object sender, EventArgs e)
{
try
{
TrasformationName = null;
VTLInt_Service.ServiceClient VTL_service = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
_transfInfo = VTL_service.GetTransformationList();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private BaseArtefactInfo[] getTrasformationList()
{
try
{
BaseArtefactInfo[] tsList;
VTLInt_Service.ServiceClient VTL_service = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
tsList = VTL_service.GetTransformationList();
return(tsList);
}
catch (Exception ex)
{
CommonItem.ErrManger.ErrorManagement(ex, false, this);
return(null);
}
}
private void RemoveButton_Click(object sender, EventArgs e)
{
try
{
if (TrasDataGridView.SelectedRows.Count > 0)
{
if (MessageBox.Show("Do you want to remove the transformation scheme: " + TrasDataGridView.SelectedRows[0].Cells[0].Value, "Remove", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
VTLInt_Service.ServiceClient VTL_service = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
VTL_service.RemoveTransformation((string)TrasDataGridView.SelectedRows[0].Cells[0].Value);
TrasDataGridView.Rows.RemoveAt(TrasDataGridView.SelectedRows[0].Index);
MessageBox.Show("Transformation removed");
}
}
}
catch (Exception ex)
{
CommonItem.ErrManger.ErrorManagement(ex, false, this);
}
}
public void setEnumeratedDescribedView(bool Enumerated, BaseArtefactInfo artInfo)
{
try
{
DescribedPanel.Enabled = false;
EnumeratedPanel.Enabled = false;
if (Enumerated)
{
EnumeratedPanel.Enabled = true;
ValueDomainListComboBox.SelectedIndex = ValueDomainListComboBox.FindStringExact(((ArtefactInfo.model.ValueDomainSubsetInfo)(artInfo)).vd_id_ref);
VTLInt_Service.ServiceClient VTL_service = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
BaseComponentInfo[] values = VTL_service.GetSubSetList(((ArtefactInfo.model.ValueDomainSubsetInfo)(artInfo)).vtlId);
foreach (BaseComponentInfo bs in values)
{
for (int i = 0; i < ValuesCheckedListBox.Items.Count; i++)
{
ValValueDomainObject vl = (ValValueDomainObject)ValuesCheckedListBox.Items[i];
if (vl.value_seq_id.ToString() == bs.seq_id)
{
ValuesCheckedListBox.SetItemCheckState(i, CheckState.Checked);
}
}
}
}
else
{
DescribedPanel.Enabled = true;
ValueDomainListComboBox.SelectedIndex = ValueDomainListComboBox.FindStringExact(((ArtefactInfo.model.ValueDomainSubsetInfo)(artInfo)).vd_id_ref + DESCRIBED_SUFFIX);
DescribedCriterionTextBox.Text = ((ArtefactInfo.model.ValueDomainSubsetInfo)(artInfo)).set_criterion_id;
}
}
catch (Exception)
{
throw;
}
}
private void ValueDomainListComboBox_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
BaseComponentInfo[] values;
KeyValuePair <int, string>[] value_seq_id;
DescribedCriterionTextBox.Clear();
valDomParentDescrTextBox.Clear();
ValuesCheckedListBox.Items.Clear();
if (this.ValueDomainListComboBox.SelectedItem.GetType().ToString() != "System.String")
{
ValueDomainContainer valCont = (ValueDomainContainer)this.ValueDomainListComboBox.SelectedItem;
_selectedParent = valCont.componentObject;
if (valCont.isEnumerated)
{
DescribedPanel.Enabled = false;
DescribedPanel.BackColor = Color.Gray;
EnumeratedPanel.Enabled = true;
EnumeratedPanel.BackColor = Color.SteelBlue;
VTLInt_Service.ServiceClient VTL_service = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
values = VTL_service.GetValueDomainValues(valCont.vtlID);
value_seq_id = VTL_service.GetValueDomain_seq_id(valCont.vtlID);
if (values.Count() == 0)
{
MessageBox.Show("No values found!", "Values missing", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
foreach (BaseComponentInfo val in values)
{
ValValueDomainObject tmpVal = new ValValueDomainObject();
tmpVal.name = val.name[0].value;
tmpVal.Vtl_ID = val.vtlId;
var tmpVar = from seq_id in value_seq_id
where seq_id.Value == val.vtlId
select seq_id.Key;
tmpVal.value_seq_id = (int)tmpVar.First();
ValuesCheckedListBox.Items.Add(tmpVal);
}
}
else
{
DescribedPanel.Enabled = true;
DescribedPanel.BackColor = Color.SteelBlue;
EnumeratedPanel.Enabled = false;
EnumeratedPanel.BackColor = Color.Gray;
valDomParentDescrTextBox.Text = valCont.restrictionText;
}
}
else
{
_selectedParent = null;
}
}
catch (Exception)
{
throw;
}
}
private void LoadingStuff()
{
try
{
CommonItem.CurrentSettings = new MainApplicationSettings();
CommonItem.ErrManger = new classes.tool.ErrorAndLogManager();
List <CommonConst.Loading_Status> settingResult = CommonItem.CurrentSettings.LoadSettings(true);
if (settingResult[0] == CommonConst.Loading_Status.NOT_FOUND)
{
_errorMessage.Add(" - Settings not found, please create them through the Settings module and restart the application! \n \n" + settingResult[0].ToString());
_error = true;
return;
}
//LoadSettings test
//-----------------------------------------------------------------------------
System.Threading.Thread.Sleep(_millisecondDelay);
backgroundLoader.ReportProgress(1);
if (settingResult[0] != CommonConst.Loading_Status.LOADED)
{
string resultList = "";
foreach (CommonConst.Loading_Status sr in settingResult)
{
resultList += sr + " ";
}
_errorMessage.Add("Some settings are missed or not correct. They can cause malfunctions. \r\n Please fix them through the Settings module and restart the application! [" + resultList + "]");
_error = true;
}
//Interaction Url test
//-----------------------------------------------------------------------------
System.Threading.Thread.Sleep(_millisecondDelay);
backgroundLoader.ReportProgress(2);
if (CommonItem.CurrentSettings.InteractionWebService != null)
{
if (settingResult.Where(err => err == CommonConst.Loading_Status.INTERACTION_WS_LOADED).Count() > 0)
{
if (!RemoteFileExists.Check(CommonItem.CurrentSettings.InteractionWebService.WebService_clear_URL, true))
{
_errorMessage.Add(" - Connection to Interaction web service failed.");
_error = true;
}
else
{
//Interaction DB test
//-----------------------------------------------------------------------------
VTLInt_Service.ServiceClient VTL_service = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
System.Threading.Thread.Sleep(_millisecondDelay);
backgroundLoader.ReportProgress(3);
if (!VTL_service.TestDatabaseConnection())
{
_errorMessage.Add(" - VTL Database connection from Interaction web service failed.");
_error = true;
}
}
}
}
//Validation Url test
//-----------------------------------------------------------------------------
System.Threading.Thread.Sleep(_millisecondDelay);
backgroundLoader.ReportProgress(4);
WebServiceConnector.RestWebConnector RestWS = new WebServiceConnector.RestWebConnector(CommonItem.CurrentSettings.ValidationWebService.WebService_public_URL + CommonItem.SYNTACTIC_VALIDATION_WEBMETHOD);
Dictionary <string, string> args = new Dictionary <string, string>();
try
{
string result = RestWS.SendPostRequest("ds1:=length(1);");
}
catch (Exception ex)
{
_errorMessage.Add(" - Connection to Validation web service failed. [" + ex.Message + "]");
_error = true;
}
//-----------------------------------------------------------------------------
//Metadata Url test
//-----------------------------------------------------------------------------
System.Threading.Thread.Sleep(_millisecondDelay);
backgroundLoader.ReportProgress(5);
if (CommonItem.CurrentSettings.WebServices.Count > 0)
{
ApplicationSettings.classes.services.ApplicationSettings.WebServiceInfo ws = CommonItem.CurrentSettings.WebServices[0];
if (!RemoteFileExists.Check(ws.WebService_clear_URL, true))
{
_errorMessage.Add(" - Connection to SDMX Metadata web service failed.");
_error = true;
}
}
//-----------------------------------------------------------------------------
}
catch (Exception ex)
{
_error = true;
if (_errorMessage.Count() == 0)
{
_errorMessage.Add(" - " + ex.Message);
}
}
}
private void cm_ItemImportClicked(object sender, System.EventArgs e)
{
try
{
TreeNode tmpNode = (TreeNode)((MenuItem)sender).Tag;
ArtefactNodeInfo artInfo = (ArtefactNodeInfo)tmpNode.Tag;
VTLInt_Service.ServiceClient VTLMan = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
MetadataLoader mtl = null;
//VTLMan.LineCountEvent += LineCountEventManager;
switch (artInfo.artType)
{
case ArtefactNodeInfo.ArtefactType.ValueDomains:
string vd_id = artInfo.artefactInfo.sdmxId;
string vd_agency = artInfo.artefactInfo.sdmxAgency;
string vd_version = artInfo.artefactInfo.sdmxVersion;
if (MessageBox.Show("Do you want import into the VTL database the codelist: \n " + vd_id + " " + vd_agency + " " + vd_version, "Import codelist", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
CommonItem.WaitOn();
mtl = new MetadataLoader(CommonItem.CurrentSettings.QueriesPath, new WebServiceLayer.classes.service.Net.WebServiceLayer(CommonItem.CurrentSettings, int.Parse(artInfo.webServiceID)));
List <BaseArtefactInfo> dsList = mtl.LoadCodelistCodes21(vd_id, vd_agency, vd_version);
VTLMan.InsertValueDomain(vd_id, vd_agency, vd_version, artInfo.artefactInfo.name.ToArray(), dsList.ToArray(), true, BaseArtefactInfo.CREATION_TYPE.SDMX_WS_UPLOAD, ArtefactInfo.VTL.VTL_Model.VTL_DATATYPE.String);
CommonItem.WaitOff();
MessageBox.Show("Value domain :" + vd_id + " " + vd_agency + " " + vd_version + " successufully imported", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
tmpNode.ForeColor = Color.Gray;
}
break;
case ArtefactNodeInfo.ArtefactType.DataStructureComponents:
string[] globIdent = CommonConstant.splitGlobalID(((ArtefactInfo.model.DataStructureComponentInfo)(artInfo.artefactComponentInfo)).valuedomain_id);
string cmp_id = globIdent[0];
string cmp_agency = globIdent[1];
string cmp_version = globIdent[2];
CommonItem.WaitOn();
mtl = new MetadataLoader(CommonItem.CurrentSettings.QueriesPath, new WebServiceLayer.classes.service.Net.WebServiceLayer(CommonItem.CurrentSettings, int.Parse(artInfo.webServiceID)));
List <BaseArtefactInfo> cmpList = mtl.LoadCodelistCodes21(cmp_id, cmp_agency, cmp_version);
VTLMan.InsertValueDomain(cmp_id, cmp_agency, cmp_version, artInfo.artefactInfo.name.ToArray(), cmpList.ToArray(), true, BaseArtefactInfo.CREATION_TYPE.SDMX_WS_UPLOAD, ArtefactInfo.VTL.VTL_Model.VTL_DATATYPE.String);
CommonItem.WaitOff();
MessageBox.Show("Value domain :" + cmp_id + " " + cmp_agency + " " + cmp_version + " successufully imported", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
tmpNode.ForeColor = Color.Gray;
break;
case ArtefactNodeInfo.ArtefactType.DataStructures:
string dsd_id = artInfo.artefactInfo.sdmxId;
string dsd_agency = artInfo.artefactInfo.sdmxAgency;
string dsd_version = artInfo.artefactInfo.sdmxVersion;
List <BaseArtefactInfo> valueDomainValueList;
List <BaseComponentInfo> componentsList = new List <BaseComponentInfo>();
if (MessageBox.Show("Do you want import into the VTL database the Datastructure: \n " + dsd_id + " " + dsd_agency + " " + dsd_version + "\n and all the referenced artefacts?", "Import datastructure", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
CommonItem.WaitOn();
label1.Text = DateTime.Now.ToString();
mtl = new MetadataLoader(CommonItem.CurrentSettings.QueriesPath, new WebServiceLayer.classes.service.Net.WebServiceLayer(CommonItem.CurrentSettings, int.Parse(artInfo.webServiceID)));
List <BaseArtefactInfo> componentList = mtl.LoadDataStructuresComponents21(dsd_id, dsd_agency, dsd_version);
foreach (BaseComponentInfo comp in componentList[0].DataStructureDetails.Components)
{
BaseComponentInfo tmpComponentInfo = new BaseComponentInfo();
ValueDomainInfoInDataStructure tmpInfo = new ValueDomainInfoInDataStructure();
string[] globalId = null;
tmpComponentInfo.vtlId = comp.vtlId;
tmpComponentInfo.name = comp.name;
tmpComponentInfo.datastructure_id_ref = comp.datastructure_id_ref;
tmpComponentInfo.seq_id = comp.seq_id;
switch (((ArtefactInfo.model.DataStructureComponentInfo)(comp)).role)
{
case "Dimension":
tmpComponentInfo.Role = "Identifier";
if (!String.IsNullOrEmpty(((ArtefactInfo.model.DataStructureComponentInfo)(comp)).valuedomain_id))
{
globalId = CommonConstant.splitGlobalID(((ArtefactInfo.model.DataStructureComponentInfo)(comp)).valuedomain_id);
}
break;
case "TimeDimension":
tmpComponentInfo.Role = "Identifier";
globalId = CommonConstant.splitGlobalID(CommonItem.CurrentSettings.TIME_PERIOD_default_valueDomainID);
break;
case "PrimaryMeasure":
tmpComponentInfo.Role = "Measure";
globalId = CommonConstant.splitGlobalID(CommonItem.CurrentSettings.OBS_default_valueDomainID);
break;
}
tmpInfo.vd_id = globalId[0];
tmpInfo.vd_agency = globalId[1];
tmpInfo.vd_version = globalId[2];
valueDomainValueList = mtl.LoadCodelistCodes21(globalId[0], globalId[1], globalId[2]);
if (valueDomainValueList != null)
{
tmpInfo.values = valueDomainValueList;
}
if (comp.name != null)
{
tmpInfo.names = comp.name;
}
else
{
tmpInfo.names = new List <LocalizedValue>();
tmpInfo.names.Add(new LocalizedValue("EN", comp.vtlId));
}
tmpComponentInfo.ValueDomainInfo = tmpInfo;
componentsList.Add(tmpComponentInfo);
}
try
{
VTLMan.InsertDataStructure(dsd_id, dsd_agency, dsd_version, artInfo.artefactInfo.name.ToArray(), componentsList.ToArray(), BaseArtefactInfo.CREATION_TYPE.SDMX_WS_UPLOAD);
}
catch (TimeoutException ext)
{
MessageBox.Show("Time out exception");
return;
}
label2.Text = DateTime.Now.ToString();
CommonItem.WaitOff();
MessageBox.Show("Data structures :" + dsd_id + " " + dsd_agency + " " + dsd_version + " and all the linked components successufully imported", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
tmpNode.ForeColor = Color.Gray;
}
break;
case ArtefactNodeInfo.ArtefactType.DataFlows:
string ref_dsd_id = ((DataSetInfo)artInfo.artefactInfo).sdmx_DataStructure_id;
string ref_dsd_agency = ((DataSetInfo)artInfo.artefactInfo).sdmx_DataStructure_agency;
string ref_dsd_version = ((DataSetInfo)artInfo.artefactInfo).sdmx_DataStructure_version;
string df_id = ((DataSetInfo)artInfo.artefactInfo).sdmxId;
string df_agency = ((DataSetInfo)artInfo.artefactInfo).sdmxAgency;
string df_version = ((DataSetInfo)artInfo.artefactInfo).sdmxVersion;
List <BaseArtefactInfo> ds_valueDomainValueList;
List <BaseComponentInfo> ds_componentsList = new List <BaseComponentInfo>();
if (MessageBox.Show("Do you want import into the VTL database the DataSet: \n " + df_id + " " + df_agency + " " + df_version + "\n and all the referenced artefacts?", "Import datastructure", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
CommonItem.WaitOn();
label1.Text = DateTime.Now.ToString();
mtl = new MetadataLoader(CommonItem.CurrentSettings.QueriesPath, new WebServiceLayer.classes.service.Net.WebServiceLayer(CommonItem.CurrentSettings, int.Parse(artInfo.webServiceID)));
List <BaseArtefactInfo> componentList = mtl.LoadDataStructuresComponents21(ref_dsd_id, ref_dsd_agency, ref_dsd_version);
BaseComponentInfo tmpInfo;
ValueDomainInfoInDataStructure tmpValueDomain;
foreach (BaseComponentInfo comp in componentList[0].DataStructureDetails.Components)
{
tmpInfo = new BaseComponentInfo();
tmpInfo.vtlId = comp.vtlId;
tmpInfo.name = comp.name;
string[] globalId = null;
switch (((ArtefactInfo.model.DataStructureComponentInfo)(comp)).role)
{
case "Dimension":
tmpInfo.Role = "Identifier";
if (!String.IsNullOrEmpty(((ArtefactInfo.model.DataStructureComponentInfo)(comp)).valuedomain_id))
{
globalId = CommonConstant.splitGlobalID(((ArtefactInfo.model.DataStructureComponentInfo)(comp)).valuedomain_id);
}
break;
case "TimeDimension":
tmpInfo.Role = "Identifier";
globalId = CommonConstant.splitGlobalID(CommonItem.CurrentSettings.TIME_PERIOD_default_valueDomainID);
break;
case "PrimaryMeasure":
tmpInfo.Role = "Measure";
globalId = CommonConstant.splitGlobalID(CommonItem.CurrentSettings.OBS_default_valueDomainID);
break;
}
tmpValueDomain = new ValueDomainInfoInDataStructure();
tmpValueDomain.vd_id = globalId[0];
tmpValueDomain.vd_agency = globalId[1];
tmpValueDomain.vd_version = globalId[2];
if (comp.name != null)
{
tmpValueDomain.names = comp.name;
}
else
{
tmpValueDomain.names = new List <LocalizedValue>();
tmpValueDomain.names.Add(new LocalizedValue("EN", comp.vtlId));
}
ds_valueDomainValueList = mtl.LoadCodelistCodes21(globalId[0], globalId[1], globalId[2]);
if (ds_valueDomainValueList != null)
{
tmpValueDomain.values = ds_valueDomainValueList;
}
tmpInfo.ValueDomainInfo = tmpValueDomain;
ds_componentsList.Add(tmpInfo);
}
try
{
VTLMan.InsertDataSet(ref_dsd_id, ref_dsd_agency, ref_dsd_version, df_id, df_agency, df_version, artInfo.artefactInfo.name.ToArray(), ds_componentsList.ToArray(), BaseArtefactInfo.CREATION_TYPE.SDMX_WS_UPLOAD);
}
catch (TimeoutException ds_ext)
{
MessageBox.Show("Time out exception");
return;
}
label2.Text = DateTime.Now.ToString();
CommonItem.WaitOff();
MessageBox.Show("Data set :" + df_id + " " + df_agency + " " + df_version + " and all the linked components successufully imported", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
tmpNode.ForeColor = Color.Gray;
}
break;
}
}
catch (Exception ex)
{
CommonItem.ErrManger.ErrorManagement(ex, false, this);
}
finally
{
CommonItem.WaitOff();
}
}
private void LoadDataStructures(string webserviceId, TreeNode parent)
{
try
{
CommonItem.WaitOn();
List <BaseArtefactInfo> dsList;
bool raiseError = false;
MetadataLoader mtl = new MetadataLoader(CommonItem.CurrentSettings.QueriesPath, new WebServiceLayer.classes.service.Net.WebServiceLayer(CommonItem.CurrentSettings, int.Parse(webserviceId)));
dsList = mtl.LoadDataStructures21();
VTLInt_Service.ServiceClient VTL_service = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
BaseArtefactInfo[] alreadyPresent = VTL_service.GetDataStructures();
foreach (BaseArtefactInfo aInfo in dsList)
{
string text;
if (switchTreeView.isCode())
{
text = aInfo.vtlId;
}
else
if (aInfo.name.Count == 0)
{
raiseError = true;
text = aInfo.vtlId;
}
else
{
text = aInfo.name[0].value.ToString();
}
TreeNode tmp = parent.Nodes.Add(aInfo.sdmxId, text);
tmp.ForeColor = Color.Black;
if (alreadyPresent != null)
{
var found = from i in alreadyPresent
where i.vtlId == text
select i;
if (found.Count() > 0)
{
tmp.ForeColor = Color.DarkGreen;
}
}
tmp.Tag = new ArtefactNodeInfo(webserviceId, aInfo, ArtefactNodeInfo.ArtefactType.DataStructures);
}
CommonItem.WaitOff();
if (raiseError)
{
MessageBox.Show("The description is not available for one or more items. The ID will be shown", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
CommonItem.ErrManger.ErrorManagement(ex, false, this);
}
}
private void LoadDataFlows(string webserviceId, TreeNode trNode)
{
try
{
CommonItem.WaitOn();
List <BaseArtefactInfo> dfList;
bool raiseError = false;
string vtlIdCode = null;
MetadataLoader mtl = new MetadataLoader(CommonItem.CurrentSettings.QueriesPath, new WebServiceLayer.classes.service.Net.WebServiceLayer(CommonItem.CurrentSettings, int.Parse(webserviceId)));
dfList = mtl.LoadDataflows21();
VTLInt_Service.ServiceClient VTL_service = VTLInt_ServiceManager.GetClient(CommonItem.CurrentSettings.InteractionWebService);
BaseArtefactInfo[] alreadyPresent = VTL_service.GetDataSets();
BaseArtefactInfo[] alreadyPresentDsD = VTL_service.GetDataStructures();
foreach (BaseArtefactInfo aInfo in dfList)
{
string text;
if (switchTreeView.isCode())
{
text = aInfo.sdmxId;
}
else
if (aInfo.name.Count == 0)
{
raiseError = true;
text = aInfo.vtlId;
}
else
{
text = aInfo.name[0].value.ToString();
}
vtlIdCode = CommonConstant.ToGlobalID(aInfo.sdmxId, aInfo.sdmxAgency, aInfo.sdmxVersion);
TreeNode tmp = trNode.Nodes.Add(vtlIdCode);
tmp.ForeColor = Color.Gray;
string dsdInfo = CommonConstant.ToGlobalID(((ArtefactInfo.model.DataSetInfo)(aInfo)).sdmx_DataStructure_id, ((DataSetInfo)aInfo).sdmx_DataStructure_agency, ((DataSetInfo)aInfo).sdmx_DataStructure_version);
if (alreadyPresentDsD != null)
{
var found = from i in alreadyPresentDsD
where (CommonConstant.ToGlobalID(i.sdmxId, i.sdmxAgency, i.sdmxVersion)) == dsdInfo
select i;
if (found.Count() > 0)
{
tmp.ForeColor = Color.Black;
}
}
if (alreadyPresent != null)
{
var found = from i in alreadyPresent
where (i.vtlId) == vtlIdCode
select i;
if (found.Count() > 0)
{
tmp.ForeColor = Color.DarkGreen;
}
}
tmp.Tag = new ArtefactNodeInfo(webserviceId, aInfo, ArtefactNodeInfo.ArtefactType.DataFlows);
tmp.ToolTipText = "Datastructure ref: " + ((ArtefactInfo.model.DataSetInfo)(aInfo)).sdmxAgency + ":" + ((ArtefactInfo.model.DataSetInfo)(aInfo)).datastructure_id + "(" + ((ArtefactInfo.model.DataSetInfo)(aInfo)).sdmx_DataStructure_version + ")";
}
CommonItem.WaitOff();
if (raiseError)
{
MessageBox.Show("The description is not available for one or more items.The ID will be shown", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
CommonItem.ErrManger.ErrorManagement(ex, false, this);
}
}