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);
}
}
public List <ValueDomainInfo> GetValueDomain()
{
string queryString = VTLSqlStatement.ValueDomain;
IDataReader reader = _provider.ExecuteReader(queryString);
if (reader == null)
{
throw new Exception("Database connection failed");
}
var posIdVD = reader.GetOrdinal("ARTEFACT_ID");
var posSdmxId = reader.GetOrdinal("SDMX_ID");
var posAgency = reader.GetOrdinal("SDMX_AGENCY");
var posVersion = reader.GetOrdinal("SDMX_VERSION");
var posLocale = reader.GetOrdinal("LANGUAGE");
var posLabel = reader.GetOrdinal("NAME");
var posDataType = reader.GetOrdinal("DATA_TYPE");
var posIsEnumerated = reader.GetOrdinal("IS_ENUMERATED");
var posValueRestr = reader.GetOrdinal("VALUE_RESTRICTION");
var posCreationType = reader.GetOrdinal("CREATION_TYPE");
List <ValueDomainInfo> l = new List <ValueDomainInfo>();
string vtlOld = String.Empty;
string vtlNew = String.Empty;
string locale, label, vtlId, sdmxId, sdmxAg, sdmxVer, dataType, valueRetriction;
int creation_Type;
int isEnumerated;
bool bFirst = true;
List <LocalizedValue> lv = null;
ValueDomainInfo vdi = null;;
try
{
while (reader.Read())
{
if (bFirst)
{
bFirst = false;
vtlId = reader.GetString(posIdVD).Trim();
sdmxId = reader.GetString(posSdmxId).Trim();
sdmxAg = reader.GetString(posAgency).Trim();
sdmxVer = reader.GetString(posVersion).Trim();
dataType = Util.SafeGetString(reader, posDataType);
isEnumerated = reader.GetInt32(posIsEnumerated);
valueRetriction = Util.SafeGetString(reader, posValueRestr);
creation_Type = reader.GetInt32(posCreationType);
locale = reader.GetString(posLocale).Trim();
label = reader.GetString(posLabel).Trim();
vdi = new ValueDomainInfo {
vtlId = vtlId, sdmxId = sdmxId, sdmxAgency = sdmxAg, sdmxVersion = sdmxVer, dataSource = "VTL", isEnumerated = Util.IntToBool(isEnumerated), data_type = dataType, value_restriction = valueRetriction, creationType = creation_Type
};
lv = new List <LocalizedValue>();
lv.Add(new LocalizedValue {
lang = locale, value = label
});
vtlOld = vtlId;
}
else
{
vtlId = reader.GetString(posIdVD).TrimEnd();
if (!String.Equals(vtlOld, vtlId))
{
vdi.name = lv;
l.Add(vdi);
sdmxId = reader.GetString(posSdmxId).Trim();
sdmxAg = reader.GetString(posAgency).Trim();
sdmxVer = reader.GetString(posVersion).Trim();
dataType = Util.SafeGetString(reader, posDataType);
isEnumerated = reader.GetInt32(posIsEnumerated);
valueRetriction = Util.SafeGetString(reader, posValueRestr);
creation_Type = reader.GetInt32(posCreationType);
vdi = new ValueDomainInfo {
vtlId = vtlId, sdmxId = sdmxId, sdmxAgency = sdmxAg, sdmxVersion = sdmxVer, dataSource = "VTL", isEnumerated = Util.IntToBool(isEnumerated), data_type = dataType, value_restriction = valueRetriction, creationType = creation_Type
};
lv = new List <LocalizedValue>();
vtlOld = vtlId;
}
locale = reader.GetString(posLocale).Trim();
label = reader.GetString(posLabel).Trim();
lv.Add(new LocalizedValue {
lang = locale, value = label
});
}
}
if (lv == null)
{
return(null);
}
vdi.name = lv;
l.Add(vdi);
return(l);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
reader.Close();
}
}
private void OkButton_Click(object sender, EventArgs e)
{
SelectedValueDomain = (ValueDomainInfo)ValuDomainListBox.SelectedItem;
DialogResult = DialogResult.OK;
this.Close();
}
