} // _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);
}
