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; }