public override void doUpdate() { CswNbtSchemaUpdateImportMgr UnitMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); UnitMgr.CAFimportOrder( "Unit_Each", "units_of_measure", "each_view", "unitofmeasureid" ); UnitMgr.importBinding( "unitofmeasurename", CswNbtObjClassUnitOfMeasure.PropertyName.Name, "" ); UnitMgr.importBinding( "conversionfactor", CswNbtObjClassUnitOfMeasure.PropertyName.ConversionFactor, CswEnumNbtSubFieldName.Base.ToString() ); UnitMgr.importBinding( "conversionfactorexp", CswNbtObjClassUnitOfMeasure.PropertyName.ConversionFactor, CswEnumNbtSubFieldName.Exponent.ToString() ); UnitMgr.importBinding( "unittype", CswNbtObjClassUnitOfMeasure.PropertyName.UnitType, "" ); UnitMgr.CAFimportOrder( "Unit_Volume", "units_of_measure", "volume_view", "unitofmeasureid" ); UnitMgr.importBinding( "unitofmeasurename", CswNbtObjClassUnitOfMeasure.PropertyName.Name, "" ); UnitMgr.importBinding( "conversionfactor", CswNbtObjClassUnitOfMeasure.PropertyName.ConversionFactor, CswEnumNbtSubFieldName.Base.ToString() ); UnitMgr.importBinding( "conversionfactorexp", CswNbtObjClassUnitOfMeasure.PropertyName.ConversionFactor, CswEnumNbtSubFieldName.Exponent.ToString() ); UnitMgr.importBinding( "unittype", CswNbtObjClassUnitOfMeasure.PropertyName.UnitType, "" ); UnitMgr.CAFimportOrder( "Unit_Weight", "units_of_measure", "weight_view", "unitofmeasureid" ); UnitMgr.importBinding( "unitofmeasurename", CswNbtObjClassUnitOfMeasure.PropertyName.Name, "" ); UnitMgr.importBinding( "conversionfactor", CswNbtObjClassUnitOfMeasure.PropertyName.ConversionFactor, CswEnumNbtSubFieldName.Base.ToString() ); UnitMgr.importBinding( "conversionfactorexp", CswNbtObjClassUnitOfMeasure.PropertyName.ConversionFactor, CswEnumNbtSubFieldName.Exponent.ToString() ); UnitMgr.importBinding( "unittype", CswNbtObjClassUnitOfMeasure.PropertyName.UnitType, "" ); UnitMgr.finalize(); } // update()
} // update() #region import script private void _createImportBindings() { CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); ImpMgr.CAFimportOrder( "Receipt Lot", "receipt_lots", "receipt_lots_view", "receiptlotid" ); ImpMgr.importBinding( "ReceiptLotNo", CswNbtObjClassReceiptLot.PropertyName.ReceiptLotNo, "" ); ImpMgr.importBinding( "CreatedDate", CswNbtObjClassReceiptLot.PropertyName.ManufacturedDate, "" ); ImpMgr.importBinding( "PackageId", CswNbtObjClassReceiptLot.PropertyName.Material, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.CAFimportOrder( "C of A Document", "receipt_lots", "cofa_docs_view", "receiptlotid" ); ImpMgr.importBinding( "ReceiptLotId", "Receipt Lot", CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "CA_FileName", CswNbtObjClassCofADocument.PropertyName.Title, "" ); ImpMgr.importBinding( "CA_AcquisitionDate", CswNbtObjClassCofADocument.PropertyName.AcquiredDate, "" ); ImpMgr.importBinding( "CA_FileExtension", CswNbtObjClassCofADocument.PropertyName.FileType, "" ); ImpMgr.importBinding( "CA_Content_Type", CswNbtObjClassCofADocument.PropertyName.File, CswEnumNbtSubFieldName.ContentType.ToString() ); ImpMgr.importBinding( "CA_Document", CswNbtObjClassCofADocument.PropertyName.File, CswEnumNbtSubFieldName.Blob.ToString(), BlobTableName: "receipt_lots", LobDataPkColOverride: "receiptlotid" ); ImpMgr.CAFimportOrder( "Container Group", "container_groups", PkColumnName: "ContainerGroupId" ); ImpMgr.importBinding( "ContainerGroupCode", CswNbtObjClassContainerGroup.PropertyName.Name, "" ); ImpMgr.CAFimportOrder( "Container", "containers", "containers_view", "containerid" ); ImpMgr.importBinding( "BarcodeId", CswNbtObjClassContainer.PropertyName.Barcode, "" ); ImpMgr.importBinding( "PackDetailId", CswNbtObjClassContainer.PropertyName.Size, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "ParentId", CswNbtObjClassContainer.PropertyName.SourceContainer, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "ContainerGroupId", CswNbtObjClassContainer.PropertyName.ContainerGroup, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "OwnerId", CswNbtObjClassContainer.PropertyName.Owner, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "ContainerStatus", CswNbtObjClassContainer.PropertyName.Status, "" ); ImpMgr.importBinding( "ReceiptLotId", CswNbtObjClassContainer.PropertyName.ReceiptLot, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "PackageId", CswNbtObjClassContainer.PropertyName.Material, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "NetQuantity", CswNbtObjClassContainer.PropertyName.Quantity, CswEnumNbtSubFieldName.Value.ToString() ); ImpMgr.importBinding( "UnitOfMeasureId", CswNbtObjClassContainer.PropertyName.Quantity, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "ExpirationDate", CswNbtObjClassContainer.PropertyName.ExpirationDate, "" ); ImpMgr.importBinding( "LocationId", CswNbtObjClassContainer.PropertyName.Location, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "StorPress", CswNbtObjClassContainer.PropertyName.StoragePressure, "" ); ImpMgr.importBinding( "StorTemp", CswNbtObjClassContainer.PropertyName.StorageTemperature, "" ); ImpMgr.importBinding( "UseType", CswNbtObjClassContainer.PropertyName.UseType, "" ); ImpMgr.importBinding( "ReceivedDate", CswNbtObjClassContainer.PropertyName.DateCreated, "" ); ImpMgr.importBinding( "OpenedDate", CswNbtObjClassContainer.PropertyName.OpenedDate, "" ); ImpMgr.importBinding( "Concentration", CswNbtObjClassContainer.PropertyName.Concentration, "" ); ImpMgr.importBinding( "HomeLocation", CswNbtObjClassContainer.PropertyName.HomeLocation, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "Notes", CswNbtObjClassContainer.PropertyName.Notes, "" ); ImpMgr.importBinding( "ProjectId", CswNbtObjClassContainer.PropertyName.Project, "" ); ImpMgr.importBinding( "SpecificActivity", CswNbtObjClassContainer.PropertyName.SpecificActivity, "" ); ImpMgr.importBinding( "TareQuantity", CswNbtObjClassContainer.PropertyName.TareQuantity, CswEnumNbtSubFieldName.Value.ToString() ); ImpMgr.importBinding( "UnitOfMeasureId", CswNbtObjClassContainer.PropertyName.TareQuantity, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.finalize(); }
public override void doUpdate() { CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); ImpMgr.CAFimportOrder( "Role", "roles", PkColumnName: "roleid" ); ImpMgr.importBinding( "roledescription", CswNbtObjClassRole.PropertyName.Description, "" ); ImpMgr.importBinding( "rolename", CswNbtObjClassRole.PropertyName.Name, "" ); ImpMgr.importBinding( "timeout", CswNbtObjClassRole.PropertyName.Timeout, "" ); ImpMgr.CAFimportOrder( "User", "users", "users_view", "userid" ); ImpMgr.importBinding( "disabled", CswNbtObjClassUser.PropertyName.Archived, "" ); ImpMgr.importBinding( "namefirst", CswNbtObjClassUser.PropertyName.FirstName, "" ); ImpMgr.importBinding( "namelast", CswNbtObjClassUser.PropertyName.LastName, "" ); ImpMgr.importBinding( "password", CswNbtObjClassUser.PropertyName.Password, "" ); ImpMgr.importBinding( "email", CswNbtObjClassUser.PropertyName.Email, "" ); ImpMgr.importBinding( "employeeid", CswNbtObjClassUser.PropertyName.EmployeeId, "" ); ImpMgr.importBinding( "navrows", CswNbtObjClassUser.PropertyName.PageSize, "" ); ImpMgr.importBinding( "locked", CswNbtObjClassUser.PropertyName.AccountLocked, "" ); ImpMgr.importBinding( "failedlogincount", CswNbtObjClassUser.PropertyName.FailedLoginCount, "" ); ImpMgr.importBinding( "defaultlanguage", CswNbtObjClassUser.PropertyName.Language, "" ); ImpMgr.importBinding( "phone", CswNbtObjClassUser.PropertyName.Phone, "" ); ImpMgr.importBinding( "username", CswNbtObjClassUser.PropertyName.Username, "" ); ImpMgr.importBinding( "defaultlocationid", CswNbtObjClassUser.PropertyName.DefaultLocation, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "roleid", CswNbtObjClassUser.PropertyName.Role, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "workunitid", CswNbtObjClassUser.PropertyName.CurrentWorkUnit, CswEnumNbtSubFieldName.NodeID.ToString() ); /* +defaultlocationid, +disabled, homeinventorygroupid, - We dont' have an inventory group property on Users +namefirst, +namelast, +navrows, +password, +roleid, +userid, +username, +workunitid, +locked, +failedlogincount, +email, +phone, +defaultlanguage, ?? pending TDU investigation supervisorid, +employeeid */ // Exclude issystemuser ImpMgr.finalize(); } // update()
public override void doUpdate() { CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); ImpMgr.CAFimportOrder( "Regulatory List", "regulatory_lists", "reglists_view", "regulatorylistid" ); ImpMgr.importBinding( "displayname", CswNbtObjClassRegulatoryList.PropertyName.Name, "" ); ImpMgr.importBinding( "listmode", CswNbtObjClassRegulatoryList.PropertyName.ListMode, "" ); ImpMgr.CAFimportOrder( "Regulatory List CAS", "regulated_casnos", PkColumnName : "regulatedcasnoid" ); ImpMgr.importBinding( "casno", CswNbtObjClassRegulatoryListCasNo.PropertyName.CASNo, "" ); ImpMgr.finalize(); } // update()
public override void doUpdate() { // CAF bindings definitions for Vendors CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); //This is only necessary for the very first CAF script, to create the caf definition ImpMgr.importDef( 1, "CAF" ); ImpMgr.CAFimportOrder( "Vendor", "vendors", PkColumnName: "vendorid" ); // Binding ImpMgr.importBinding( "accountno", CswNbtObjClassVendor.PropertyName.AccountNo, "" ); ImpMgr.importBinding( "city", CswNbtObjClassVendor.PropertyName.City, "" ); ImpMgr.importBinding( "contactname", CswNbtObjClassVendor.PropertyName.ContactName, "" ); ImpMgr.importBinding( "fax", CswNbtObjClassVendor.PropertyName.Fax, "" ); ImpMgr.importBinding( "phone", CswNbtObjClassVendor.PropertyName.Phone, "" ); ImpMgr.importBinding( "state", CswNbtObjClassVendor.PropertyName.State, "" ); ImpMgr.importBinding( "street1", CswNbtObjClassVendor.PropertyName.Street1, "" ); ImpMgr.importBinding( "street2", CswNbtObjClassVendor.PropertyName.Street2, "" ); ImpMgr.importBinding( "vendorname", CswNbtObjClassVendor.PropertyName.VendorName, "" ); ImpMgr.importBinding( "zip", CswNbtObjClassVendor.PropertyName.Zip, "" ); // Relationship // Vendor has no relationships ImpMgr.finalize(); } // update()
public override void update() { bool DefinitionExists = CswNbtImportDef.checkForDefinitionEntries( _CswNbtSchemaModTrnsctn, CswScheduleLogicNbtCAFImport.DefinitionName ); if( DefinitionExists ) { // CAF bindings definitions for Supplies CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); ImpMgr.CAFimportOrder( "Supply", "packages", "supplies_view", "packageid" ); //Simple Props ImpMgr.importBinding( "materialid", CswNbtPropertySetMaterial.PropertyName.LegacyMaterialId, "" ); ImpMgr.importBinding( "productdescription", "Description", "" ); ImpMgr.importBinding( "materialname", CswNbtPropertySetMaterial.PropertyName.TradeName, "" ); ImpMgr.importBinding( "productno", CswNbtPropertySetMaterial.PropertyName.PartNumber, "" ); ImpMgr.importBinding( "approved_trans", CswNbtPropertySetMaterial.PropertyName.ApprovedForReceiving, "" ); //Relationships ImpMgr.importBinding( "vendorid", CswNbtPropertySetMaterial.PropertyName.Supplier, CswEnumNbtSubFieldName.NodeID.ToString() ); //LOBs ImpMgr.importBinding( "struct_pict", CswNbtObjClassNonChemical.PropertyName.Picture, CswEnumNbtSubFieldName.Blob.ToString(), BlobTableName: "materials", LobDataPkColOverride: "materialid" ); ImpMgr.finalize(); } } // update()
public override void update() { bool DefinitionExists = CswNbtImportDef.checkForDefinitionEntries( _CswNbtSchemaModTrnsctn, CswScheduleLogicNbtCAFImport.DefinitionName ); if( DefinitionExists ) { // CAF bindings definitions for Biologicals CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); ImpMgr.CAFimportOrder( "Biological", "packages", "biologicals_view", "packageid" ); //Simple Props ImpMgr.importBinding( "materialid", CswNbtPropertySetMaterial.PropertyName.LegacyMaterialId, "" ); ImpMgr.importBinding( "refno", CswNbtObjClassBiological.PropertyName.ReferenceNumber, "" ); ImpMgr.importBinding( "type", CswNbtObjClassBiological.PropertyName.Type, "" ); ImpMgr.importBinding( "species", CswNbtObjClassBiological.PropertyName.SpeciesOrigin, "" ); ImpMgr.importBinding( "biosafety", CswNbtObjClassBiological.PropertyName.BiosafetyLevel, "" ); ImpMgr.importBinding( "vectors", CswNbtObjClassBiological.PropertyName.Vectors, "" ); ImpMgr.importBinding( "storage_conditions", CswNbtObjClassBiological.PropertyName.StorageCondition, "" ); ImpMgr.importBinding( "materialname", "Biological Name", "" ); ImpMgr.importBinding( "productno", CswNbtPropertySetMaterial.PropertyName.PartNumber, "" ); ImpMgr.importBinding( "approved_trans", CswNbtPropertySetMaterial.PropertyName.ApprovedForReceiving, "" ); //Relationships ImpMgr.importBinding( "vendorid", CswNbtPropertySetMaterial.PropertyName.Supplier, CswEnumNbtSubFieldName.NodeID.ToString() ); //LOBs ImpMgr.importBinding( "struct_pict", CswNbtObjClassNonChemical.PropertyName.Picture, CswEnumNbtSubFieldName.Blob.ToString(), BlobTableName: "materials", LobDataPkColOverride: "materialid" ); ImpMgr.finalize(); } } // update()
public override void doUpdate() { // CAF bindings definitions for Vendors CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr(_CswNbtSchemaModTrnsctn, "CAF"); ImpMgr.CAFimportOrder("SDS Document", "documents", "sds_view", "legacyid", false); //simple props ImpMgr.importBinding("acquisitiondate", CswNbtObjClassSDSDocument.PropertyName.AcquiredDate, ""); ImpMgr.importBinding("description", CswNbtObjClassSDSDocument.PropertyName.Title, ""); ImpMgr.importBinding("captureddate", CswNbtObjClassSDSDocument.PropertyName.RevisionDate, ""); //relationships ImpMgr.importBinding("packageid", "Material", CswEnumNbtSubFieldName.NodeID.ToString()); //SDS Document NTP "Owner" is changed to "Material" //transformed props ImpMgr.importBinding("language_trans", CswNbtObjClassSDSDocument.PropertyName.Language, ""); ImpMgr.importBinding("fileextension_trans", CswNbtObjClassSDSDocument.PropertyName.FileType, ""); //file specific bindings ImpMgr.importBinding("content_type", CswNbtObjClassSDSDocument.PropertyName.File, CswEnumNbtSubFieldName.ContentType.ToString()); ImpMgr.importBinding("filename", CswNbtObjClassSDSDocument.PropertyName.File, CswEnumNbtSubFieldName.Name.ToString()); //Link and BlobData are stored in the same column, we're going to import it twice and let the "FileType" property dictate what is shown ImpMgr.importBinding("document", CswNbtObjClassSDSDocument.PropertyName.File, CswEnumNbtSubFieldName.Blob.ToString(), BlobTableName: "documents", LobDataPkColOverride: "documentid"); ImpMgr.importBinding("document", CswNbtObjClassSDSDocument.PropertyName.Link, CswEnumNbtSubFieldName.Href.ToString(), BlobTableName: "documents", LobDataPkColOverride: "documentid"); //Use the description as the text that displays for links ImpMgr.importBinding("description", CswNbtObjClassSDSDocument.PropertyName.Link, CswEnumNbtSubFieldName.Text.ToString()); //Legacy Id for documents is "<documentid>_<packageid>" (ex: "123_343") ImpMgr.importBinding("legacyid", "Legacy Id", ""); ImpMgr.finalize(); }
public override void update() { if (CswNbtImportDef.checkForDefinitionEntries(_CswNbtSchemaModTrnsctn, "CAF")) { CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr(_CswNbtSchemaModTrnsctn, "CAF"); ImpMgr.CAFimportOrder("Equipment", "materials", "equipment_view", "legacyid", createLegacyId: true); //Simple props ImpMgr.importBinding("serialno", CswNbtObjClassEquipment.PropertyName.SerialNo, ""); ImpMgr.importBinding("barcodeid", CswNbtObjClassEquipment.PropertyName.EquipmentId, ""); ImpMgr.importBinding("expirationdate", CswNbtObjClassEquipment.PropertyName.ServiceEndsOn, ""); ImpMgr.importBinding("model", CswNbtObjClassEquipment.PropertyName.Model, ""); ImpMgr.importBinding("manufacturer", CswNbtObjClassEquipment.PropertyName.Manufacturer, ""); ImpMgr.importBinding("description", CswNbtObjClassEquipment.PropertyName.Description, ""); //Relationships and Locations ImpMgr.importBinding("ownerid", CswNbtObjClassEquipment.PropertyName.User, CswEnumNbtSubFieldName.NodeID.ToString()); ImpMgr.importBinding("locationid", CswNbtObjClassEquipment.PropertyName.Location, CswEnumNbtSubFieldName.NodeID.ToString()); ImpMgr.importBinding("materialsubclassid", CswNbtObjClassEquipment.PropertyName.Type, CswEnumNbtSubFieldName.NodeID.ToString()); //LOB data ImpMgr.importBinding("struct_pict", CswNbtObjClassEquipment.PropertyName.Picture, CswEnumNbtSubFieldName.Blob.ToString(), BlobTableName: "materials", LobDataPkColOverride: "materialid"); ImpMgr.finalize(); } }
public override void doUpdate() { // Case 30043 - CAF Migration: Sites/Locations/Work Units // View creation script //select w.*, s.sitename || ' ' || b.businessunitname as workunitname from work_units w //left outer join business_units b on (b.businessunitid = w.businessunitid) //left outer join sites s on (s.siteid = w.siteid) CswNbtSchemaUpdateImportMgr importMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); importMgr.CAFimportOrder( "Work Unit", "work_units", "workunits_view", "workunitid" ); // Binding importMgr.importBinding( "workunitname", CswNbtObjClassWorkUnit.PropertyName.Name, "" ); // Relationship //none importMgr.finalize(); // Columns in work_units table //deleted //retestwarndays //workunitid //siteid //businessunitid //stdapprovalmode //skiplotcodedefault //expiryinterval //retestintervaldefault //messagetext //expiryintervalunits //retaincount //retainkeepyears //retainquantity //retainunitofmeasureid //mininventorylevel //mininventoryunitofmeasureid //homeinventorygroupid //stdexpiryinterval //stdexpiryintervalunits //autolotapproval //samplecollectionrequired //dispense_percent //canorderdraft //canoverreq //cansynchcontainers //srireviewgroupid //def_reqaschild //amountenable //alloc1 //alloc2 //alloc3 //alloc4 //alloc5 //removegroupondispense //removegrouponmove } // update()
public override void doUpdate() { CswNbtSchemaUpdateImportMgr RoleMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); RoleMgr.removeImportOrder( "CAF", "Role" ); RoleMgr.CAFimportOrder( "Role", "roles", "roles_view", "roleid" ); RoleMgr.importBinding( "administrator", CswNbtObjClassRole.PropertyName.Administrator, "" ); RoleMgr.finalize(); } // update()
public override void update() { if (CswNbtImportDef.checkForDefinitionEntries(_CswNbtSchemaModTrnsctn, "CAF")) { CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr(_CswNbtSchemaModTrnsctn, "CAF"); ImpMgr.CAFimportOrder("Equipment Type", "materials_subclass", "equipment_type_view", "materialsubclassid"); //Simple props ImpMgr.importBinding("subclassname", CswNbtObjClassEquipmentType.PropertyName.TypeName, ""); ImpMgr.finalize(); } }
} // update() #region import script private void _createImportBindings() { CswNbtSchemaUpdateImportMgr sizeImporter = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); sizeImporter.CAFimportOrder( "Size", "packdetail", "packdetail_view", "packdetailid" ); sizeImporter.importBinding( "packagedescription", CswNbtObjClassSize.PropertyName.Description, "" ); sizeImporter.importBinding( "packageid", CswNbtObjClassSize.PropertyName.Material, CswEnumNbtSubFieldName.NodeID.ToString() ); sizeImporter.importBinding( "catalogno", CswNbtObjClassSize.PropertyName.CatalogNo, "" ); sizeImporter.importBinding( "capacity", CswNbtObjClassSize.PropertyName.InitialQuantity, CswEnumNbtSubFieldName.Value.ToString() ); sizeImporter.importBinding( "unitofmeasureid", CswNbtObjClassSize.PropertyName.InitialQuantity, CswEnumNbtSubFieldName.NodeID.ToString() ); //sizeImporter.importBinding( "upc", "UPC Barcode", "" );//Case 31264 invalidates this binding sizeImporter.importBinding( "containertype", CswNbtObjClassSize.PropertyName.ContainerType, "" ); sizeImporter.finalize(); }
public override void update() { bool DefinitionExists = CswNbtImportDef.checkForDefinitionEntries( _CswNbtSchemaModTrnsctn, CswScheduleLogicNbtCAFImport.DefinitionName ); if( DefinitionExists ) { // CAF bindings definitions for Biologicals CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); ImpMgr.CAFimportOrder( "Constituent", "materials", "constituents_view", "legacyid" ); //Simple Props ImpMgr.importBinding( "name", CswNbtObjClassChemical.PropertyName.TradeName, "" ); ImpMgr.importBinding( "casno", CswNbtObjClassChemical.PropertyName.CasNo, "" ); ImpMgr.importBinding( "einecs", CswNbtObjClassChemical.PropertyName.EINECS, "" ); ImpMgr.finalize(); } } // update()
public override void doUpdate() { // Case 30043 - CAF Migration: Sites/Locations/Work Units CswNbtSchemaUpdateImportMgr ImportMgr_ControlZones = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); ImportMgr_ControlZones.CAFimportOrder( "Control Zone", "cispro_controlzones", PkColumnName: "controlzoneid" ); // Binding ImportMgr_ControlZones.importBinding( "controlzonename", CswNbtObjClassControlZone.PropertyName.Name, "" ); ImportMgr_ControlZones.importBinding( "exemptqtyfactor", CswNbtObjClassControlZone.PropertyName.MAQOffset, "" ); // Relationship //none ImportMgr_ControlZones.finalize(); } // update()
public override void doUpdate() { CswNbtSchemaUpdateImportMgr InventoryLevelBindings = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); InventoryLevelBindings.CAFimportOrder( "Inventory Level", "mininventory_basic", "inventory_view", "inventorybasicid" ); //SPECIAL CASE: maxinventory_basic is also in the view InventoryLevelBindings.importBinding( "inventorybasicid", CswNbtObjClassInventoryLevel.PropertyName.LegacyId, "" ); InventoryLevelBindings.importBinding( "inventorylevel", CswNbtObjClassInventoryLevel.PropertyName.Level, CswEnumNbtSubFieldName.Value.ToString() ); InventoryLevelBindings.importBinding( "unitofmeasureid", CswNbtObjClassInventoryLevel.PropertyName.Level, CswEnumNbtSubFieldName.NodeID.ToString() ); InventoryLevelBindings.importBinding( "locationid", CswNbtObjClassInventoryLevel.PropertyName.Location, CswEnumNbtSubFieldName.NodeID.ToString() ); InventoryLevelBindings.importBinding( "packageid", CswNbtObjClassInventoryLevel.PropertyName.Material, CswEnumNbtSubFieldName.NodeID.ToString() ); InventoryLevelBindings.importBinding( "inventorytype", CswNbtObjClassInventoryLevel.PropertyName.Type, CswEnumNbtSubFieldName.Value.ToString() ); InventoryLevelBindings.finalize(); }
public override void doUpdate() { // CAF bindings definitions for Vendors CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr(_CswNbtSchemaModTrnsctn, "CAF"); ImpMgr.CAFimportOrder("Material Synonym", "materials_synonyms", "synonyms_view", "legacyid", false); //simple props ImpMgr.importBinding("synonymname", CswNbtObjClassMaterialSynonym.PropertyName.Name, ""); ImpMgr.importBinding("synonymclass", CswNbtObjClassMaterialSynonym.PropertyName.Type, ""); //relationships ImpMgr.importBinding("packageid", CswNbtObjClassMaterialSynonym.PropertyName.Material, CswEnumNbtSubFieldName.NodeID.ToString()); //Legacy Id for Synonyms is "<SynonymId>_<PackageId>" (ex: "123_343") ImpMgr.importBinding("legacyid", "Legacy Id", ""); ImpMgr.finalize(); }
public override void update() { bool DefinitionExists = CswNbtImportDef.checkForDefinitionEntries( _CswNbtSchemaModTrnsctn, CswScheduleLogicNbtCAFImport.DefinitionName ); if( DefinitionExists ) { // CAF bindings definitions for Biologicals CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); ImpMgr.CAFimportOrder( "Material Component", "component_casnos", "materialcomps_view", "legacyid" ); //Simple Props ImpMgr.importBinding( "quantity", CswNbtObjClassMaterialComponent.PropertyName.TargetPercentageValue, "" ); ImpMgr.importBinding( "quantity", CswNbtObjClassMaterialComponent.PropertyName.HighPercentageValue, "" ); //Relationships ImpMgr.importBinding( "packageid", CswNbtObjClassMaterialComponent.PropertyName.Mixture, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "constituentid", CswNbtObjClassMaterialComponent.PropertyName.Constituent, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.finalize(); } } // update()
public override void doUpdate() { // Case 30043 - CAF Migration: Sites/Locations/Work Units CswNbtSchemaUpdateImportMgr importMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); importMgr.CAFimportOrder( "Inventory Group", "inventory_groups", PkColumnName: "inventorygroupid" ); // Binding importMgr.importBinding( "inventorygroupname", CswNbtObjClassInventoryGroup.PropertyName.Name, "" ); importMgr.importBinding( "iscentralgroup", CswNbtObjClassInventoryGroup.PropertyName.Central, "" ); // Relationship //none importMgr.finalize(); //Columns in inventory_groups table //deleted //inventorygroupid //inventorygroupname //iscentralgroup //workunitid //inventorygroupcode } // update()
public override void doUpdate() { #region GHS CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); ImpMgr.CAFimportOrder( "Jurisdiction", "sites", "regions_view", "region", false ); ImpMgr.importBinding( "region", CswNbtObjClassJurisdiction.PropertyName.LegacyId, "" ); // Regions are distinct so we can use as the LegacyId ImpMgr.importBinding( "region", CswNbtObjClassJurisdiction.PropertyName.Name, "" ); ImpMgr.CAFimportOrder( "GHS Phrase", "ghs_phrases", PkColumnName: "ghsphraseid" ); ImpMgr.importBinding( "ghscategory", CswNbtObjClassGHSPhrase.PropertyName.Category, "" ); ImpMgr.importBinding( "ghscode", CswNbtObjClassGHSPhrase.PropertyName.Code, "" ); ImpMgr.importBinding( "phraseenglish", CswNbtObjClassGHSPhrase.PropertyName.English, "" ); ImpMgr.importBinding( "phrasedanish", CswNbtObjClassGHSPhrase.PropertyName.Danish, "" ); ImpMgr.importBinding( "phrasedutch", CswNbtObjClassGHSPhrase.PropertyName.Dutch, "" ); ImpMgr.importBinding( "phrasefinnish", CswNbtObjClassGHSPhrase.PropertyName.Finnish, "" ); ImpMgr.importBinding( "phrasefrench", CswNbtObjClassGHSPhrase.PropertyName.French, "" ); ImpMgr.importBinding( "phrasegerman", CswNbtObjClassGHSPhrase.PropertyName.German, "" ); ImpMgr.importBinding( "phraseitalian", CswNbtObjClassGHSPhrase.PropertyName.Italian, "" ); ImpMgr.importBinding( "phraseportuguese", CswNbtObjClassGHSPhrase.PropertyName.Portuguese, "" ); ImpMgr.importBinding( "phrasespanish", CswNbtObjClassGHSPhrase.PropertyName.Spanish, "" ); ImpMgr.importBinding( "phraseswedish", CswNbtObjClassGHSPhrase.PropertyName.Swedish, "" ); ImpMgr.importBinding( "phrasechinese", CswNbtObjClassGHSPhrase.PropertyName.Chinese, "" ); ImpMgr.CAFimportOrder( "GHS", "jct_ghsphrase_matsite", "ghs_view", "legacyid", false ); ImpMgr.importBinding( "legacyid", CswNbtObjClassGHS.PropertyName.LegacyId, "" ); ImpMgr.importBinding( "region", CswNbtObjClassGHS.PropertyName.Jurisdiction, "" ); ImpMgr.importBinding( "packageid", CswNbtObjClassGHS.PropertyName.Material, CswEnumNbtSubFieldName.NodeID.ToString() ); ImpMgr.importBinding( "ghscodes", CswNbtObjClassGHS.PropertyName.AddLabelCodes, "" ); ImpMgr.importBinding( "pictos", CswNbtObjClassGHS.PropertyName.Pictograms, "" ); ImpMgr.importBinding( "signal", CswNbtObjClassGHS.PropertyName.SignalWord, "" ); #endregion GHS #region DSD ImpMgr.CAFimportOrder( "DSD Phrase", "rs_phrases", PkColumnName: "rsphraseid" ); ImpMgr.importBinding( "code", CswNbtObjClassDSDPhrase.PropertyName.Code, "" ); ImpMgr.importBinding( "phraseenglish", CswNbtObjClassDSDPhrase.PropertyName.English, "" ); ImpMgr.importBinding( "phrasedanish", CswNbtObjClassDSDPhrase.PropertyName.Danish, "" ); ImpMgr.importBinding( "phrasedutch", CswNbtObjClassDSDPhrase.PropertyName.Dutch, "" ); ImpMgr.importBinding( "phrasefinnish", CswNbtObjClassDSDPhrase.PropertyName.Finnish, "" ); ImpMgr.importBinding( "phrasefrench", CswNbtObjClassDSDPhrase.PropertyName.French, "" ); ImpMgr.importBinding( "phrasegerman", CswNbtObjClassDSDPhrase.PropertyName.German, "" ); ImpMgr.importBinding( "phraseitalian", CswNbtObjClassDSDPhrase.PropertyName.Italian, "" ); ImpMgr.importBinding( "phraseportuguese", CswNbtObjClassDSDPhrase.PropertyName.Portuguese, "" ); ImpMgr.importBinding( "phrasespanish", CswNbtObjClassDSDPhrase.PropertyName.Spanish, "" ); ImpMgr.importBinding( "phraseswedish", CswNbtObjClassDSDPhrase.PropertyName.Swedish, "" ); ImpMgr.importBinding( "phrasechinese", CswNbtObjClassDSDPhrase.PropertyName.Chinese, "" ); #endregion DSD ImpMgr.finalize(); }//update()
public override void doUpdate() { // Case 30043 - CAF Migration: Sites/Locations/Work Units const string SiteNTName = "Site"; const string BuildingNTName = "Building"; const string RoomNTName = "Room"; const string CabinetNTName = "Cabinet"; const string ShelfNTName = "Shelf"; const string BoxNTName = "Box"; const string LocationSheetName = "CAF"; CswNbtSchemaUpdateImportMgr LocationsMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); // Bindings #region Site LocationsMgr.CAFimportOrder( SiteNTName, "locations", "locations_view", "locationid", false, 1 ); LocationsMgr.importBinding( "sitename", CswNbtObjClassLocation.PropertyName.Name, "", LocationSheetName, SiteNTName, 1 ); LocationsMgr.importBinding( "sitecode", CswNbtObjClassLocation.PropertyName.LocationCode, "", LocationSheetName, SiteNTName, 1 ); LocationsMgr.importBinding( "siteid", "Legacy Id", "", LocationSheetName, SiteNTName, 1 ); LocationsMgr.importBinding( "controlzoneid", CswNbtObjClassLocation.PropertyName.ControlZone, CswEnumNbtSubFieldName.NodeID.ToString(), LocationSheetName, SiteNTName, 1 ); LocationsMgr.importBinding( "allowinventory", CswNbtObjClassLocation.PropertyName.AllowInventory, "", LocationSheetName, SiteNTName, 1 ); #endregion #region Building LocationsMgr.CAFimportOrder( BuildingNTName, "locations", "locations_view", "locationid", false, 2 ); LocationsMgr.importBinding( "locationlevel1name", CswNbtObjClassLocation.PropertyName.Name, "", LocationSheetName, BuildingNTName, 2 ); LocationsMgr.importBinding( "locationcode", CswNbtObjClassLocation.PropertyName.LocationCode, "", LocationSheetName, BuildingNTName, 2 ); LocationsMgr.importBinding( "buildingid", "Legacy Id", "", LocationSheetName, BuildingNTName, 2 ); LocationsMgr.importBinding( "inventorygroupid", CswNbtObjClassLocation.PropertyName.InventoryGroup, CswEnumNbtSubFieldName.NodeID.ToString(), LocationSheetName, BuildingNTName, 2 ); LocationsMgr.importBinding( "controlzoneid", CswNbtObjClassLocation.PropertyName.ControlZone, CswEnumNbtSubFieldName.NodeID.ToString(), LocationSheetName, BuildingNTName, 2 ); LocationsMgr.importBinding( "allowinventory", CswNbtObjClassLocation.PropertyName.AllowInventory, "", LocationSheetName, BuildingNTName, 2 ); #endregion #region Room LocationsMgr.CAFimportOrder( RoomNTName, "locations", "locations_view", "locationid", false, 3 ); LocationsMgr.importBinding( "locationlevel2name", CswNbtObjClassLocation.PropertyName.Name, "", LocationSheetName, RoomNTName, 3 ); LocationsMgr.importBinding( "locationcode", CswNbtObjClassLocation.PropertyName.LocationCode, "", LocationSheetName, RoomNTName, 3 ); LocationsMgr.importBinding( "roomid", "Legacy Id", "", LocationSheetName, RoomNTName, 3 ); LocationsMgr.importBinding( "inventorygroupid", CswNbtObjClassLocation.PropertyName.InventoryGroup, CswEnumNbtSubFieldName.NodeID.ToString(), LocationSheetName, RoomNTName, 3 ); LocationsMgr.importBinding( "controlzoneid", CswNbtObjClassLocation.PropertyName.ControlZone, CswEnumNbtSubFieldName.NodeID.ToString(), LocationSheetName, RoomNTName, 3 ); LocationsMgr.importBinding( "allowinventory", CswNbtObjClassLocation.PropertyName.AllowInventory, "", LocationSheetName, RoomNTName, 3 ); #endregion #region Cabinet LocationsMgr.CAFimportOrder( CabinetNTName, "locations", "locations_view", "locationid", false, 4 ); LocationsMgr.importBinding( "locationlevel3name", CswNbtObjClassLocation.PropertyName.Name, "", LocationSheetName, CabinetNTName, 4 ); LocationsMgr.importBinding( "locationcode", CswNbtObjClassLocation.PropertyName.LocationCode, "", LocationSheetName, CabinetNTName, 4 ); LocationsMgr.importBinding( "cabinetid", "Legacy Id", "", LocationSheetName, CabinetNTName, 4 ); LocationsMgr.importBinding( "inventorygroupid", CswNbtObjClassLocation.PropertyName.InventoryGroup, CswEnumNbtSubFieldName.NodeID.ToString(), LocationSheetName, CabinetNTName, 4 ); LocationsMgr.importBinding( "controlzoneid", CswNbtObjClassLocation.PropertyName.ControlZone, CswEnumNbtSubFieldName.NodeID.ToString(), LocationSheetName, CabinetNTName, 4 ); LocationsMgr.importBinding( "allowinventory", CswNbtObjClassLocation.PropertyName.AllowInventory, "", LocationSheetName, CabinetNTName, 4 ); #endregion #region Shelf LocationsMgr.CAFimportOrder( ShelfNTName, "locations", "locations_view", "locationid", false, 5 ); LocationsMgr.importBinding( "locationlevel4name", CswNbtObjClassLocation.PropertyName.Name, "", LocationSheetName, ShelfNTName, 5 ); LocationsMgr.importBinding( "locationcode", CswNbtObjClassLocation.PropertyName.LocationCode, "", LocationSheetName, ShelfNTName, 5 ); LocationsMgr.importBinding( "shelfid", "Legacy Id", "", LocationSheetName, ShelfNTName, 5 ); LocationsMgr.importBinding( "inventorygroupid", CswNbtObjClassLocation.PropertyName.InventoryGroup, CswEnumNbtSubFieldName.NodeID.ToString(), LocationSheetName, ShelfNTName, 5 ); LocationsMgr.importBinding( "controlzoneid", CswNbtObjClassLocation.PropertyName.ControlZone, CswEnumNbtSubFieldName.NodeID.ToString(), LocationSheetName, ShelfNTName, 5 ); LocationsMgr.importBinding( "allowinventory", CswNbtObjClassLocation.PropertyName.AllowInventory, "", LocationSheetName, ShelfNTName, 5 ); #endregion #region Box LocationsMgr.CAFimportOrder( BoxNTName, "locations", "locations_view", "locationid", false, 6 ); LocationsMgr.importBinding( "locationlevel5name", CswNbtObjClassLocation.PropertyName.Name, "", LocationSheetName, BoxNTName, 6 ); LocationsMgr.importBinding( "locationcode", CswNbtObjClassLocation.PropertyName.LocationCode, "", LocationSheetName, BoxNTName, 6 ); LocationsMgr.importBinding( "boxid", "Legacy Id", "", LocationSheetName, BoxNTName, 6 ); LocationsMgr.importBinding( "inventorygroupid", CswNbtObjClassLocation.PropertyName.InventoryGroup, CswEnumNbtSubFieldName.NodeID.ToString(), LocationSheetName, BoxNTName, 6 ); LocationsMgr.importBinding( "controlzoneid", CswNbtObjClassLocation.PropertyName.ControlZone, CswEnumNbtSubFieldName.NodeID.ToString(), LocationSheetName, BoxNTName, 6 ); LocationsMgr.importBinding( "allowinventory", CswNbtObjClassLocation.PropertyName.AllowInventory, "", LocationSheetName, BoxNTName, 6 ); #endregion //Relationships LocationsMgr.importRelationship( LocationSheetName, BuildingNTName, CswNbtObjClassLocation.PropertyName.Location, 1, "siteid" ); LocationsMgr.importRelationship( LocationSheetName, RoomNTName, CswNbtObjClassLocation.PropertyName.Location, 2, "buildingid" ); LocationsMgr.importRelationship( LocationSheetName, CabinetNTName, CswNbtObjClassLocation.PropertyName.Location, 3, "roomid" ); LocationsMgr.importRelationship( LocationSheetName, ShelfNTName, CswNbtObjClassLocation.PropertyName.Location, 4, "cabinetid" ); LocationsMgr.importRelationship( LocationSheetName, BoxNTName, CswNbtObjClassLocation.PropertyName.Location, 5, "shelfid" ); LocationsMgr.finalize(); } // update()
public override void doUpdate() { // Case 30043 - CAF Migration: Sites/Locations/Work Units CswNbtSchemaUpdateImportMgr LocationsMgr = new CswNbtSchemaUpdateImportMgr( _CswNbtSchemaModTrnsctn, "CAF" ); // Bindings LocationsMgr.removeImportOrder( "CAF", "Site", 1, true ); LocationsMgr.removeImportOrder( "CAF", "Building", 2, true ); LocationsMgr.removeImportOrder( "CAF", "Room", 3, true ); LocationsMgr.removeImportOrder( "CAF", "Cabinet", 4, true ); LocationsMgr.removeImportOrder( "CAF", "Shelf", 5, true ); LocationsMgr.removeImportOrder( "CAF", "Box", 6, true ); //the instance on the relationships is different for Locations, so they must be deleted manually LocationsMgr.removeImportRelationship( "CAF", "Building", "Location", 1 ); LocationsMgr.removeImportRelationship( "CAF", "Room", "Location", 2 ); LocationsMgr.removeImportRelationship( "CAF", "Cabinet", "Location", 3 ); LocationsMgr.removeImportRelationship( "CAF", "Shelf", "Location", 4 ); LocationsMgr.removeImportRelationship( "CAF", "Box", "Location", 5 ); #region Site LocationsMgr.CAFimportOrder( "Site", "sites", "site_view", "siteid" ); LocationsMgr.importBinding( "sitename", CswNbtObjClassLocation.PropertyName.Name, "" ); LocationsMgr.importBinding( "sitecode", CswNbtObjClassLocation.PropertyName.LocationCode, "" ); LocationsMgr.importBinding( "barcode", CswNbtObjClassLocation.PropertyName.Barcode, "" ); #endregion #region Building LocationsMgr.CAFimportOrder( "Building", "locations", "building_view", "locationid" ); LocationsMgr.importBinding( "locationlevel1name", CswNbtObjClassLocation.PropertyName.Name, ""); LocationsMgr.importBinding( "locationcode", CswNbtObjClassLocation.PropertyName.LocationCode, ""); LocationsMgr.importBinding( "inventorygroupid", CswNbtObjClassLocation.PropertyName.InventoryGroup, CswEnumNbtSubFieldName.NodeID.ToString()); LocationsMgr.importBinding( "controlzoneid", CswNbtObjClassLocation.PropertyName.ControlZone, CswEnumNbtSubFieldName.NodeID.ToString() ); LocationsMgr.importBinding( "allowinventory", CswNbtObjClassLocation.PropertyName.AllowInventory, "" ); LocationsMgr.importBinding( "barcode", CswNbtObjClassLocation.PropertyName.Barcode, "" ); LocationsMgr.importBinding( "siteid", CswNbtObjClassLocation.PropertyName.Location, CswEnumNbtSubFieldName.NodeID.ToString() ); #endregion #region Room LocationsMgr.CAFimportOrder( "Room", "locations", "room_view", "locationid" ); LocationsMgr.importBinding( "locationlevel2name", CswNbtObjClassLocation.PropertyName.Name, "" ); LocationsMgr.importBinding( "locationcode", CswNbtObjClassLocation.PropertyName.LocationCode, "" ); LocationsMgr.importBinding( "inventorygroupid", CswNbtObjClassLocation.PropertyName.InventoryGroup, CswEnumNbtSubFieldName.NodeID.ToString() ); LocationsMgr.importBinding( "controlzoneid", CswNbtObjClassLocation.PropertyName.ControlZone, CswEnumNbtSubFieldName.NodeID.ToString() ); LocationsMgr.importBinding( "allowinventory", CswNbtObjClassLocation.PropertyName.AllowInventory, "" ); LocationsMgr.importBinding( "barcode", CswNbtObjClassLocation.PropertyName.Barcode, "" ); LocationsMgr.importBinding( "buildingid", CswNbtObjClassLocation.PropertyName.Location, CswEnumNbtSubFieldName.NodeID.ToString() ); #endregion #region Cabinet LocationsMgr.CAFimportOrder( "Cabinet", "locations", "cabinet_view", "locationid" ); LocationsMgr.importBinding( "locationlevel3name", CswNbtObjClassLocation.PropertyName.Name, "" ); LocationsMgr.importBinding( "locationcode", CswNbtObjClassLocation.PropertyName.LocationCode, "" ); LocationsMgr.importBinding( "inventorygroupid", CswNbtObjClassLocation.PropertyName.InventoryGroup, CswEnumNbtSubFieldName.NodeID.ToString() ); LocationsMgr.importBinding( "controlzoneid", CswNbtObjClassLocation.PropertyName.ControlZone, CswEnumNbtSubFieldName.NodeID.ToString() ); LocationsMgr.importBinding( "allowinventory", CswNbtObjClassLocation.PropertyName.AllowInventory, "" ); LocationsMgr.importBinding( "barcode", CswNbtObjClassLocation.PropertyName.Barcode, "" ); LocationsMgr.importBinding( "roomid", CswNbtObjClassLocation.PropertyName.Location, CswEnumNbtSubFieldName.NodeID.ToString() ); #endregion #region Shelf LocationsMgr.CAFimportOrder( "Shelf", "locations", "shelf_view", "locationid" ); LocationsMgr.importBinding( "locationlevel4name", CswNbtObjClassLocation.PropertyName.Name, "" ); LocationsMgr.importBinding( "locationcode", CswNbtObjClassLocation.PropertyName.LocationCode, "" ); LocationsMgr.importBinding( "inventorygroupid", CswNbtObjClassLocation.PropertyName.InventoryGroup, CswEnumNbtSubFieldName.NodeID.ToString() ); LocationsMgr.importBinding( "controlzoneid", CswNbtObjClassLocation.PropertyName.ControlZone, CswEnumNbtSubFieldName.NodeID.ToString() ); LocationsMgr.importBinding( "allowinventory", CswNbtObjClassLocation.PropertyName.AllowInventory, "" ); LocationsMgr.importBinding( "barcode", CswNbtObjClassLocation.PropertyName.Barcode, "" ); LocationsMgr.importBinding( "cabinetid", CswNbtObjClassLocation.PropertyName.Location, CswEnumNbtSubFieldName.NodeID.ToString() ); #endregion #region Box LocationsMgr.CAFimportOrder( "Box", "locations", "box_view", "locationid" ); LocationsMgr.importBinding( "locationlevel5name", CswNbtObjClassLocation.PropertyName.Name, "" ); LocationsMgr.importBinding( "locationcode", CswNbtObjClassLocation.PropertyName.LocationCode, "" ); LocationsMgr.importBinding( "inventorygroupid", CswNbtObjClassLocation.PropertyName.InventoryGroup, CswEnumNbtSubFieldName.NodeID.ToString() ); LocationsMgr.importBinding( "controlzoneid", CswNbtObjClassLocation.PropertyName.ControlZone, CswEnumNbtSubFieldName.NodeID.ToString() ); LocationsMgr.importBinding( "allowinventory", CswNbtObjClassLocation.PropertyName.AllowInventory, "" ); LocationsMgr.importBinding( "barcode", CswNbtObjClassLocation.PropertyName.Barcode, "" ); LocationsMgr.importBinding( "shelfid", CswNbtObjClassLocation.PropertyName.Location, CswEnumNbtSubFieldName.NodeID.ToString() ); #endregion LocationsMgr.finalize(); } // update()
public override void doUpdate() { // CAF bindings definitions for Vendors CswNbtSchemaUpdateImportMgr ImpMgr = new CswNbtSchemaUpdateImportMgr(_CswNbtSchemaModTrnsctn, "CAF"); //PACKAGES not MATERIALS (intentional) ImpMgr.CAFimportOrder("Chemical", "packages", "chemicals_view", "packageid"); //Simple Props ImpMgr.importBinding("aqueous_solubility", CswNbtObjClassChemical.PropertyName.AqueousSolubility, ""); ImpMgr.importBinding("casno", CswNbtObjClassChemical.PropertyName.CasNo, ""); ImpMgr.importBinding("boiling_point", CswNbtObjClassChemical.PropertyName.BoilingPoint, ""); ImpMgr.importBinding("formula", CswNbtObjClassChemical.PropertyName.Formula, ""); ImpMgr.importBinding("materialname", CswNbtObjClassChemical.PropertyName.TradeName, ""); ImpMgr.importBinding("melting_point", CswNbtObjClassChemical.PropertyName.MeltingPoint, ""); ImpMgr.importBinding("molecular_weight", CswNbtObjClassChemical.PropertyName.MolecularWeight, ""); ImpMgr.importBinding("ph", CswNbtObjClassChemical.PropertyName.pH, ""); ImpMgr.importBinding("physical_description", CswNbtObjClassChemical.PropertyName.PhysicalDescription, ""); ImpMgr.importBinding("ppe", CswNbtObjClassChemical.PropertyName.PPE, ""); ImpMgr.importBinding("specific_gravity", CswNbtObjClassChemical.PropertyName.SpecificGravity, ""); ImpMgr.importBinding("vapor_density", CswNbtObjClassChemical.PropertyName.VaporDensity, ""); ImpMgr.importBinding("vapor_pressure", CswNbtObjClassChemical.PropertyName.VaporPressure, ""); ImpMgr.importBinding("storage_conditions", CswNbtObjClassChemical.PropertyName.StorageAndHandling, ""); ImpMgr.importBinding("istier2", CswNbtObjClassChemical.PropertyName.IsTierII, ""); ImpMgr.importBinding("productno", CswNbtObjClassChemical.PropertyName.PartNumber, ""); ImpMgr.importBinding("einecs", CswNbtObjClassChemical.PropertyName.EINECS, ""); ImpMgr.importBinding("compressed_gas", CswNbtObjClassChemical.PropertyName.CompressedGas, ""); ImpMgr.importBinding("dot_code", CswNbtObjClassChemical.PropertyName.DOTCode, ""); ImpMgr.importBinding("subclassname", CswNbtObjClassChemical.PropertyName.SubclassName, ""); ImpMgr.importBinding("expireinterval", CswNbtObjClassChemical.PropertyName.ExpirationInterval, CswEnumNbtSubFieldName.Value.ToString()); ImpMgr.importBinding("expireintervalunits", CswNbtObjClassChemical.PropertyName.ExpirationInterval, CswEnumNbtSubFieldName.Name.ToString()); ImpMgr.importBinding("openexpireinterval", CswNbtObjClassChemical.PropertyName.OpenExpireInterval, CswEnumNbtSubFieldName.Value.ToString()); ImpMgr.importBinding("openexpireintervalunits", CswNbtObjClassChemical.PropertyName.OpenExpireInterval, CswEnumNbtSubFieldName.Name.ToString()); //NFPA ImpMgr.importBinding("firecode", CswNbtObjClassChemical.PropertyName.NFPA, CswEnumNbtSubFieldName.Flammability.ToString()); ImpMgr.importBinding("healthcode", CswNbtObjClassChemical.PropertyName.NFPA, CswEnumNbtSubFieldName.Health.ToString()); ImpMgr.importBinding("reactivecode", CswNbtObjClassChemical.PropertyName.NFPA, CswEnumNbtSubFieldName.Reactivity.ToString()); ImpMgr.importBinding("nfpacode", CswNbtObjClassChemical.PropertyName.NFPA, CswEnumNbtSubFieldName.Special.ToString()); //Relationships ImpMgr.importBinding("vendorid", CswNbtObjClassChemical.PropertyName.Supplier, CswEnumNbtSubFieldName.NodeID.ToString()); //Transformed props ImpMgr.importBinding("physical_state_trans", CswNbtObjClassChemical.PropertyName.PhysicalState, ""); ImpMgr.importBinding("nonhazardous3e_trans", CswNbtObjClassChemical.PropertyName.Hazardous, ""); ImpMgr.importBinding("ppe_trans", CswNbtObjClassChemical.PropertyName.PPE, ""); //LOBs ImpMgr.importBinding("struct_pict", CswNbtObjClassChemical.PropertyName.Structure, "", BlobTableName: "materials", LobDataPkColOverride: "materialid"); ImpMgr.importBinding("disposal", CswNbtObjClassChemical.PropertyName.DisposalInstructions, "", BlobTableName: "materials", LobDataPkColOverride: "materialid"); ImpMgr.importBinding("smiles", CswNbtObjClassChemical.PropertyName.SMILES, "", ClobTableName: "materials", LobDataPkColOverride: "materialid"); //DSD ImpMgr.importBinding("labelcodes", CswNbtObjClassChemical.PropertyName.AddLabelCodes, ""); ImpMgr.importBinding("pictograms", CswNbtObjClassChemical.PropertyName.Pictograms, ""); //Storage Compatibility ImpMgr.importBinding("storagecompatibility", CswNbtObjClassChemical.PropertyName.StorageCompatibility, ""); ImpMgr.finalize(); }