} // _addNodeToData() public static void UploadBulkEditData(ICswResources CswResources, BulkEditReturn ret, BulkEditUpload Params) { CswNbtResources NbtResources = (CswNbtResources)CswResources; CswTempFile temp = new CswTempFile(CswResources); string tempPath = temp.saveToTempFile(Params.PostedFile.InputStream, CswResources.AccessId + "_bulkedit_" + DateTime.Now.Ticks.ToString()); DataSet uploadDataSet = CswNbtImportTools.ReadExcel(tempPath); if (uploadDataSet.Tables.Count > 0) { DataTable uploadTable = uploadDataSet.Tables[0]; CswNbtBatchOpBulkEdit batch = new CswNbtBatchOpBulkEdit(NbtResources); CswNbtObjClassBatchOp batchNode = batch.makeBatchOp(uploadTable); CswNbtView BatchOpsView = new CswNbtView((CswNbtResources)CswResources); BatchOpsView.ViewName = "New Batch Operations"; BatchOpsView.ViewMode = CswEnumNbtViewRenderingMode.Tree; CswNbtViewRelationship BatchRel = BatchOpsView.AddViewRelationship(batchNode.NodeType, false); BatchRel.NodeIdsToFilterIn.Add(batchNode.NodeId); BatchOpsView.SaveToCache(true); ret.ViewId = BatchOpsView.SessionViewId.ToString(); } // if( uploadDataSet.Tables.Count > 0 ) } // UploadBulkEditData()
static void Main(string[] args) { if (args.Length != 4) { Console.Write("\nUsage:\n\n" + "CAFSqlGenerator.exe <NBT AccessId> <CAF DB Username> <CAF DB Password> <CAF DB server>\n\n" + "For example, if you were setting up a CAF import from cis0001/userpass@CAFDB to nbt_master, you would type " + "\"CAFSqlGenerator.exe nbt_master cis0001 userpass CAFDB\"\n"); } else { //assign the command line params to readable variables string AccessId = args[0]; string CAFSchema = args[1]; string CAFPassword = args[2]; string CAFDatabase = args[3]; //create the NbtResources and assign the DB Resources using the access id CswNbtResources NbtResources = CswNbtResourcesFactory.makeCswNbtResources(CswEnumAppType.Nbt, CswEnumSetupMode.NbtExe, true); NbtResources.AccessId = AccessId; CswNbtImportTools.startCAFImportImpl(NbtResources, CAFDatabase, CAFSchema, CAFPassword, CswEnumSetupMode.NbtExe); } //if correct number of args } //Main
public static void getImportJobs(ICswResources CswResources, CswNbtImportWcf.ImportJobsReturn ret, object parms) { CswNbtResources CswNbtResources = (CswNbtResources)CswResources; foreach (CswNbtImportDataJob Job in CswNbtImportTools.getJobs(CswNbtResources)) { ret.Data.Add(Job); } }
public Int32 getLoadCount(ICswResources CswResources) { CswNbtResources CswNbtResources = (CswNbtResources)CswResources; // Only recalculate load count if it's zero if (_DataTableNames.Count == 0) { _DataTableNames = CswNbtImportTools.getImportDataTableNames(CswNbtResources); } return(_DataTableNames.Count); }
public static void uploadImportData(ICswResources CswResources, CswNbtImportWcf.ImportDataReturn ret, CswNbtImportWcf.ImportFileParams parms) { CswNbtResources CswNbtResources = (CswNbtResources)CswResources; // Write uploaded file to temp dir CswFilePath FilePathMgr = new CswFilePath(CswResources); string FullFilePath = System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath + "\\import\\" + FilePathMgr.getFileNameForSchema(parms.PostedFile.FileName); FileStream ImportDataFile = File.Create(FullFilePath); parms.PostedFile.InputStream.CopyTo(ImportDataFile); ImportDataFile.Close(); parms.PostedFile.InputStream.Close(); ret.JobId = CswNbtImportTools.storeData(CswNbtResources, parms.PostedFile.FileName, FullFilePath, parms.ImportDefName, parms.Overwrite); }
/// <summary> /// Cancel a running job /// </summary> public static void cancelJob(ICswResources CswResources, CswWebSvcReturn ret, CswNbtImportWcf.JobRequest parms) { CswNbtImportTools.CancelJob((CswNbtResources)CswResources, parms.JobId); }
public static void getImportDefs(ICswResources CswResources, CswNbtImportWcf.ImportDefsReturn ret, object parms) { CswNbtResources CswNbtResources = (CswNbtResources)CswResources; ret.Data = CswNbtImportTools.getDefinitionNames(CswNbtResources).ToString(); }
public static void startCAFImport(ICswResources CswResources, CswWebSvcReturn Ret, CswNbtImportWcf.StartImportParams Params) { CswNbtImportTools.startCAFImportImpl(CswResources, Params.CAFDatabase, Params.CAFSchema, Params.CAFPassword, CswEnumSetupMode.NbtWeb); }