public static void Main(string[] args)
{
switch (args[0])
{
case "install":
InstallArgs installArgs = new InstallArgs(args);
InstallProcess installProcess = new InstallProcess();
installProcess.Execute(installArgs);
break;
case "delete":
DeleteArgs deleteArgs = new DeleteArgs(args);
DeleteProcess deleteProcess = new DeleteProcess();
deleteProcess.Execute(deleteArgs);
break;
case "export":
var exportArgs = new ExportArgs(args);
var exportProcess = new ExportProcess();
exportProcess.Execute(exportArgs);
break;
case "import":
var importArgs = new ImportArgs(args);
var importProcess = new ImportProcess();
importProcess.Execute(importArgs);
break;
}
}
protected void ReadDataFromXMLFile(string fileName)
{
var serializer = new SharpSerializer();
var importArgs = new ImportArgs();
importArgs = (ImportArgs)serializer.Deserialize(fileName);
var fieldDelimiter = importArgs.FieldDelimiter.ToString();
if (fieldDelimiter != null)
{
ddlDelimiter.SelectedItem.Text = fieldDelimiter;
}
var importOptions = importArgs.CurrentImportOptions.ToString().Spacify();
var io = importOptions.Split(new[] { ',' }, StringSplitOptions.None);
chkBoxImportType.DataSource = io;
chkBoxImportType.DataBind();
foreach (var i in io)
{
switch (i.Trim())
{
case "CreateMissingSkus":
chkBoxImportType.Items.FindByValue(i).Selected = true;
break;
case "CreateMissingTaxonomies":
chkBoxImportType.Items.FindByValue(i).Selected = true;
break;
case "CreateMissingAttributes":
chkBoxImportType.Items.FindByValue(i).Selected = true;
break;
case "CreateMissingMetaAttributes":
chkBoxImportType.Items.FindByValue(i).Selected = true;
break;
case "CreateMissingValues":
chkBoxImportType.Items.FindByValue(i).Selected = true;
break;
}
}
dict = importArgs.FieldMappings;
}
public static async Task AddImportTask(ImportArgs args)
{
var json = JsonConvert.SerializeObject(args);
HttpWebRequest wq = WebRequest.CreateHttp(SERVER_PATH + "/jobs/new/import");
wq.Method = "POST";
var reqStr = await wq.GetRequestStreamAsync();
using (var sw = new StreamWriter(reqStr))
{
await sw.WriteAsync(json);
sw.Close();
}
var res = await wq.GetResponseAsync() as HttpWebResponse;
if ((int)res.StatusCode != 200)
{
MessageBox.Show("error");
}
}
public IList <ApplicationDataModel> Import(string dataPath, Properties properties = null)
{
ImportArgs.Add(new ImportArgs(dataPath, properties));
return(DataModels);
}
private void DoImportLocalities()
{
var importArgs = new ImportArgs<Locality>
{
Filename = filename,
WorkSheetName = sheet
};
importArgs.Columns.Clear();
foreach (var columnViewModel in Columns)
{
var reader = columnViewModel.GetCellReader();
if (reader != null)
{
importArgs.Columns.Add((ICellReader<Locality>)reader);
}
}
var excelImport = new ExcelImport<Locality>(context, locality => locality, _ => { });
excelImport.ProgressChanged += (o, e) => { Progress = excelImport.Progress*100; };
excelImport.Cancelled += (o, e) => { MessageBox.Show("Import cancelled."); };
excelImport.Error += (o, e) => { MessageBox.Show("ERROR!\n\n" + e.Error); };
excelImport.Finished += (o, e) =>
{
excelImport.Save();
MessageBox.Show("Import complete");
};
excelImport.Start(importArgs);
}
private void DoImportData()
{
var importArgs = new ImportArgs<Mouse>
{
Filename = filename,
WorkSheetName = sheet
};
importArgs.Columns.Clear();
foreach (var columnViewModel in Columns)
{
var reader = columnViewModel.GetCellReader();
if (reader != null)
{
importArgs.Columns.Add((ICellReader<Mouse>) reader);
}
}
var excelImport = new ExcelImport<Mouse>(context,
mice => mice.Include(m => m.Records).Include(m => m.Locality),
c => c.Localities.Include(l => l.Mice).Load());
excelImport.ProgressChanged += (o, e) => { Progress = excelImport.Progress*100; };
excelImport.Finished += (o, e) =>
{
excelImport.Save();
MessageBox.Show("Import complete");
};
excelImport.Cancelled += (o, e) => { MessageBox.Show("Import cancelled."); };
excelImport.Error += (o, e) => { MessageBox.Show("ERROR!\n\n" + e.Error); };
excelImport.Start(importArgs);
}
private Guid GetAllValues()
{
//This method should be called when the Save or Load button is clicked by the user
var fileName = Path.GetFileName(inputFileLocation.Value);
if (fileName == null)
{
return(Guid.Empty);
}
ImportArgs ia = null;
if (fileName.Contains(".xml"))
{
//var allImports = ImportWorkerBase.GetAvailableImports();
//foreach (var import in allImports)
//{
// var className = import.GetType();
// Type[] typeArgs = { className };
// object o = Activator.CreateInstance(className);
//}
ia = new ImportArgs
{
Id = Guid.NewGuid(),
InputFilePath = inputFileLocation.Value,
JobDescription = txtProjectDesc.Text,
ProjectId = Guid.Parse(projectId.Value),
UserId = Guid.Parse(userId.Value),
CurrentImportOptions =
ImportOptions.CreateMissingMetaAttributes
| ImportOptions.CreateMissingAttributes | ImportOptions.CreateMissingSkus
| ImportOptions.CreateMissingTaxonomies | ImportOptions.CreateMissingValues
| ImportOptions.CreateMissingLOVs,
UpdateFrequency = 4000
};
}
else
{
ia = new ImportArgs
{
Id = Guid.NewGuid(),
InputFilePath = inputFileLocation.Value,
FieldDelimiter =
(Delimiter)Enum.Parse(typeof(Delimiter), ddlDelimiter.SelectedValue),
ProjectId = Guid.Parse(projectId.Value),
UserId = Guid.Parse(userId.Value),
NotificationEmailAddresses = notificationEmail.Value,
CurrentImportOptions =
ImportOptions.CreateMissingMetaAttributes
| ImportOptions.CreateMissingAttributes | ImportOptions.CreateMissingSkus
| ImportOptions.CreateMissingTaxonomies | ImportOptions.CreateMissingValues
| ImportOptions.CreateMissingLOVs,
JobDescription = txtProjectDesc.Text,
UpdateFrequency = 4000,
FieldMappings = MapFields()
};
Session["FieldMappings"] = ia.FieldMappings;
var io = ImportOptions.None;
io = SelectImportType(io);
Session["ImportType"] = io;
ia.CurrentImportOptions = io;
}
var iaFilePath = new FileInfo(inputFileLocation.Value).Directory.FullName;
argsPath.Value = iaFilePath;
var iaFileName = Path.Combine(iaFilePath, WorkerArguments.ArgumentsFileName);
var settings = ia.GetSharpSerializerXmlSettings(WorkerArguments.ArgumentsFileRootName);
var serializer = new SharpSerializer(settings);
serializer.Serialize(ia, iaFileName);
importArgs.Value = iaFileName;
return(ia.Id);
}
protected override void Process(ImportArgs args)
{
string websiteFolderPath = args.rootPath;
SetupWebsiteHelper.SetDataFolder(websiteFolderPath);
}
protected override void Process(ImportArgs args)
{
string websiteFolderPath = args.rootPath;
SetupWebsiteHelper.SetDataFolder(websiteFolderPath);
}
private async void btImport_Click(object sender, EventArgs e)
{
var fname = cbFiles.SelectedItem.ToString();
var logName = tbLogName.Text;
if (string.IsNullOrWhiteSpace(logName))
{
MessageBox.Show("Enter name of the log");
return;
}
var groupingField = cbGroupingField.SelectedItem?.ToString();
if (groupingField == null)
{
MessageBox.Show("Select grouping field");
return;
}
var groupingFieldType = cbGroupingFieldType.SelectedItem?.ToString();
if (groupingFieldType == null)
{
MessageBox.Show("Select grouping field type");
return;
}
var timeField = cbTimeField.SelectedItem?.ToString();
if (timeField == null)
{
MessageBox.Show("Select time field");
return;
}
var timeFieldType = cbTimeFieldType.SelectedItem?.ToString();
if (timeFieldType == null)
{
MessageBox.Show("Select time field type");
return;
}
if (tbDelimiter.Text.Length < 1)
{
MessageBox.Show("Enter delimiter character");
return;
}
var delimiter = tbDelimiter.Text[0];
var guid = Guid.NewGuid();
var importArgs = new ImportArgs()
{
JobID = guid,
LogName = logName,
FileName = fname,
GroupingField = groupingField,
GroupingFieldType = groupingFieldType,
TimeField = timeField,
TimeFieldType = timeFieldType,
CsvDelimiter = delimiter
};
await ApiBoundary.AddImportTask(importArgs);
JobWaiterForm form = new JobWaiterForm(guid);
form.ShowDialog();
Close();
//btJobsRefresh_Click(null, null);
}
