public ArtefactInfo(string id, string agencyId, string version, string urn, ArtefactTypes type, string fileName, XmlDocument content) { this._id = id; this._agencyId = agencyId; this._version = version; this._urn = urn; this._type = type; this._fileName = fileName; this._content = content; }
public ArtefactRef(string id, string agencyId, string version, string language, string name, string description, ArtefactTypes artefactType) { this._id = id; this._agencyId = agencyId; this._version = version; this._language = language; this._name = name; this._description = description; this._artefactType = artefactType; }
private void Save_Artefacts_Details_For_Uploaded_DSD_In_Database(int DbNId, string Id, string AgencyId, string Version, string URN, ArtefactTypes Type, string FileLocation, string FileName) { string InsertQuery; DIConnection DIConnection; System.Data.Common.DbParameter DbParam; List<System.Data.Common.DbParameter> DbParams; InsertQuery = string.Empty; DIConnection = null; string AppPhysicalPath = string.Empty; string DbFolder = string.Empty; try { AppPhysicalPath = HttpContext.Current.Request.PhysicalApplicationPath; DbFolder = Constants.FolderName.Data + DbNId.ToString() + "\\"; DIConnection = new DIConnection(DIServerType.MsAccess, string.Empty, string.Empty, Server.MapPath("~//stock//Database.mdb"), string.Empty, string.Empty); DbParams = new List<System.Data.Common.DbParameter>(); InsertQuery = "INSERT INTO Artefacts (DBNId, Id, AgencyId, Version, URN, Type, FileLocation)" + " VALUES(@DBNId, @Id, @AgencyId, @Version, @URN, @Type, @FileLocation);"; DbParams = new List<System.Data.Common.DbParameter>(); DbParam = DIConnection.CreateDBParameter(); DbParam.ParameterName = "DBNId"; DbParam.DbType = DbType.Int32; DbParam.Value = DbNId; DbParams.Add(DbParam); DbParam = DIConnection.CreateDBParameter(); DbParam.ParameterName = "Id"; DbParam.DbType = DbType.String; DbParam.Value = Id; DbParams.Add(DbParam); DbParam = DIConnection.CreateDBParameter(); DbParam.ParameterName = "AgencyId"; DbParam.DbType = DbType.String; DbParam.Value = AgencyId; DbParams.Add(DbParam); DbParam = DIConnection.CreateDBParameter(); DbParam.ParameterName = "Version"; DbParam.DbType = DbType.String; DbParam.Value = Version; DbParams.Add(DbParam); DbParam = DIConnection.CreateDBParameter(); DbParam.ParameterName = "URN"; DbParam.DbType = DbType.String; DbParam.Value = URN; DbParams.Add(DbParam); DbParam = DIConnection.CreateDBParameter(); DbParam.ParameterName = "Type"; DbParam.DbType = DbType.Int32; DbParam.Value = Convert.ToInt32(Type); DbParams.Add(DbParam); DbParam = DIConnection.CreateDBParameter(); DbParam.ParameterName = "FileLocation"; DbParam.DbType = DbType.String; switch (Type) { case ArtefactTypes.ConceptS: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.Concepts + FileName); break; case ArtefactTypes.DSD: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.sdmx + FileName); break; case ArtefactTypes.MSD: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.MSD + FileName); break; case ArtefactTypes.CL: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.Codelists + FileName); break; case ArtefactTypes.CategoryS: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.Categories + FileName); break; case ArtefactTypes.DFD: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.ProvisioningMetadata + FileName); break; case ArtefactTypes.MFD: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.ProvisioningMetadata + FileName); break; case ArtefactTypes.Complete: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.sdmx + FileName); break; case ArtefactTypes.Summary: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.sdmx + FileName); break; case ArtefactTypes.Report: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.sdmx + FileName); break; case ArtefactTypes.PA: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.PAs + FileName); break; case ArtefactTypes.Mapping: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.sdmx + FileName); break; case ArtefactTypes.Header: DbParam.Value = Path.Combine(AppPhysicalPath, DbFolder + Constants.FolderName.SDMX.sdmx + FileName); break; default: break; } DbParams.Add(DbParam); DIConnection.ExecuteDataTable(InsertQuery, CommandType.Text, DbParams); } catch (Exception ex) { Global.CreateExceptionString(ex, null); throw ex; } finally { if (DIConnection != null) { DIConnection.Dispose(); } } }
private ArtefactInfo Prepare_ArtefactInfo_From_OrganisationScheme(SDMXObjectModel.Structure.OrganisationSchemeType OrganisationScheme, string FileName, ArtefactTypes artefactType) { ArtefactInfo RetVal; SDMXObjectModel.Message.StructureType Structure; XmlDocument XmlContent; RetVal = null; XmlContent = null; try { Structure = this.Get_Structure_Object(OrganisationScheme); XmlContent = Serializer.SerializeToXmlDocument(typeof(SDMXObjectModel.Message.StructureType), Structure); RetVal = new ArtefactInfo(OrganisationScheme.id, OrganisationScheme.agencyID, OrganisationScheme.version, string.Empty, artefactType, FileName, XmlContent); } catch (Exception ex) { throw ex; } finally { } return RetVal; }