public DataStructure Get_DSD(ISTAT.ENTITY.SDMXIdentifier sdmxIdentity)
{
DataStructure _ds = new ISTAT.ENTITY.DataStructure();
Org.Sdmxsource.Sdmx.Api.Model.Objects.DataStructure.IDataStructureObject dsd = ISTAT.DBDAL.DataSDMX.GetDSD(sdmxIdentity);
#region Get Dimension
List<Dimension> dims = new List<Dimension>();
foreach (Org.Sdmxsource.Sdmx.Api.Model.Objects.DataStructure.IDimension dim in dsd.DimensionList.Dimensions)
{
Dimension _dim = new Dimension(dim);
dims.Add(_dim);
}
#endregion
#region Get Attribute
List<ISTAT.ENTITY.Attribute> atts = new List<ISTAT.ENTITY.Attribute>();
foreach (Org.Sdmxsource.Sdmx.Api.Model.Objects.DataStructure.IAttributeObject att in dsd.Attributes)
{
ISTAT.ENTITY.Attribute _att = new ISTAT.ENTITY.Attribute(att);
atts.Add(_att);
}
#endregion
_ds.Dimensions = dims;
_ds.Attributes = atts;
_ds.DSDIdentifier = sdmxIdentity;
_ds.IDDsd = ISTAT.DBDAL.DataSDMX.Get_IDDsd(sdmxIdentity);
_ds.IsFinal = dsd.IsFinal.IsTrue;
this._ds = _ds;
return _ds;
}
public static DataStructure Get_DataStructureByDataflow(ISTAT.ENTITY.SDMXIdentifier dataflow)
{
DataWrapper dtw = new DataWrapper(DataWrapper.ECONNECTIONTYPE.SQL, DataAccess.SQLConnString_DB.ConnectionString);
if (dtw.TestConnection())
{
dtw.DBConnection.Open();
try
{
////////////////////////
System.Data.IDbCommand cmd = dtw.DBConnection.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "dbo.proc_GET_DATASTRUCT_BY_DATAFLOW";
System.Data.IDbDataParameter param_agencyid = cmd.CreateParameter();
param_agencyid.DbType = System.Data.DbType.String;
param_agencyid.ParameterName = "agencyid";
param_agencyid.Value = dataflow.agencyid;
cmd.Parameters.Add(param_agencyid);
System.Data.IDbDataParameter param_id = cmd.CreateParameter();
param_id.DbType = System.Data.DbType.String;
param_id.ParameterName = "id";
param_id.Value = dataflow.id;
cmd.Parameters.Add(param_id);
System.Data.IDbDataParameter param_version = cmd.CreateParameter();
param_version.DbType = System.Data.DbType.String;
param_version.ParameterName = "version";
param_version.Value = dataflow.version;
cmd.Parameters.Add(param_version);
System.Data.IDbDataParameter param_twoLetter = cmd.CreateParameter();
param_twoLetter.DbType = System.Data.DbType.String;
param_twoLetter.ParameterName = "TwoLetterISO";
param_twoLetter.Value = DataAccess.TwoLetterIso;
cmd.Parameters.Add(param_twoLetter);
System.Data.IDataReader reader = cmd.ExecuteReader();
DataStructure ds = null;
if (reader.Read())
{
ds =
new DataStructure(
reader.GetInt32(reader.GetOrdinal("IDSet")),
reader.GetString(reader.GetOrdinal("Code")),
reader.GetInt32(reader.GetOrdinal("IDDataFlow")));
ds.IDCat = reader.GetInt32(reader.GetOrdinal("IDCat"));
List<TextTypeWrapper> names = DataAccess.Get_LocalisedStrings(ds.IDSet, "CatSet");
ds.Names.Add(names[TextTypeWrapper.GetIndexLocale(names, DataAccess.TwoLetterIso)]);
//ds.Names.Add(new TextTypeWrapper(DataAccess.TwoLetterIso, reader.GetString(reader.GetOrdinal("Value"))));
ds.IDDsd = DataSDMX.Get_IDDsd(ds.IDFlow);
}
////////////////////////
dtw.DBConnection.Close();
return ds;
}
catch// (Exception ex)
{
dtw.DBConnection.Close();
return null;
}
} return null;
}
private static void GetModel(IDataSetRenderer renderer, ISTAT.WebClient.WidgetEngine.Model.DataRender.IDataSetModel datasetModel, TextWriter streamResponse)
{
renderer.RenderAllTables(datasetModel, streamResponse);
}
private static void GetModel(IDataSetRenderer renderer, ISTAT.WebClient.WidgetEngine.Model.DataRender.IDataSetModel datasetModel, MemoryStream memoryStream)
{
renderer.RenderAllTables(datasetModel, memoryStream);
}
public DataStructure Get_DSD(ISTAT.ENTITY.SDMXIdentifier sdmxIdentity)
{
DataStructure _ds = new ISTAT.ENTITY.DataStructure();
Org.Sdmxsource.Sdmx.Api.Model.Objects.DataStructure.IDataStructureObject dsd = ISTAT.DBDAL.DataSDMX.GetDSD(sdmxIdentity, false);
#region Get Dimension
List<Dimension> dims = new List<Dimension>();
foreach (Org.Sdmxsource.Sdmx.Api.Model.Objects.DataStructure.IDimension dim in dsd.DimensionList.Dimensions)
{
Dimension _dim = new Dimension(dim);
dims.Add(_dim);
}
#endregion
#region Get Attribute
List<ISTAT.ENTITY.Attribute> atts = new List<ISTAT.ENTITY.Attribute>();
foreach (Org.Sdmxsource.Sdmx.Api.Model.Objects.DataStructure.IAttributeObject att in dsd.Attributes)
{
ISTAT.ENTITY.Attribute _att = new ISTAT.ENTITY.Attribute(att);
if (att.AttachmentGroup != null)
{
var group = dsd.Groups.FirstOrDefault(e => e.Id == att.AttachmentGroup);
if (group != null)
_att.DimensionReferences = new List<string>(group.DimensionRefs);
}
atts.Add(_att);
}
#endregion
_ds.Dimensions = dims;
_ds.Attributes = atts;
_ds.DSDIdentifier = sdmxIdentity;
_ds.IDDsd = ISTAT.DBDAL.DataSDMX.Get_IDDsd(sdmxIdentity);
_ds.IsFinal = dsd.IsFinal.IsTrue;
this._ds = _ds;
return _ds;
}
