I need to be able to run the following code in my XAF controller:
private async void simpleActionLoadData_Execute(object sender, SimpleActionExecuteEventArgs e) {
var loadTask = Task<bool>.Factory.StartNew(() => LoadData()); await loadTask; //var connectTask = Task<bool>.Factory.StartNew(() => ConnectDevicesToApplications()); //await connectTask; View.Refresh(); }
private bool LoadData() { bool status=true;
SecuritySystemUser user; user = (SecuritySystemUser)SecuritySystem.CurrentUser;
string timeStamp = string.Format("{0:yyyy-MM-dd_hh-mm-ss-tt}", DateTime.Now);
string fn = string.Format(user.UserName + "-" + timeStamp + "-" + dl.InputFile.FileName); string targetFilePath = @"C:\AccountView\DataInput" + fn; dl.ImportFileName = targetFilePath; FileStream myStream = new FileStream(targetFilePath, FileMode.OpenOrCreate);
dl.InputFile.SaveToStream(myStream);
myStream.Close();
ExcelEngine excelEngine = new ExcelEngine(); IApplication application = excelEngine.Excel; IWorkbook workbook = excelEngine.Excel.Workbooks.Open(dl.ImportFileName, ExcelOpenType.Automatic);
IWorksheet appsheet = workbook.Worksheets["Application"];
IWorksheet serversheet = workbook.Worksheets["Device"];
IWorksheet workloadsheet = workbook.Worksheets["Workload"];
IWorksheet storagesheet = workbook.Worksheets["Storage"];
IWorksheet networksheet = workbook.Worksheets["Network"];
IWorksheet softwaresheet = workbook.Worksheets["Software"];
IWorksheet devicesoftwaresheet = workbook.Worksheets["DeviceSoftware"];
DataTable applicationsTable; applicationsTable = appsheet.ExportDataTable(appsheet.UsedRange, ExcelExportDataTableOptions.ColumnNames);
var appsrowsArray = new DataRow[applicationsTable.Rows.Count]; applicationsTable.Rows.CopyTo(appsrowsArray, 0); var rowsList = appsrowsArray.ToList();
foreach (var record in rowsList) { AccountView2.Module.BusinessObjects.Application app = new Module.BusinessObjects.Application(((XPObjectSpace)ObjectSpace).Session);
app.AppId = Convert.ToInt32(record[0]); app.AppName = record[1].ToString();
}
ObjectSpace.CommitChanges();
return status; }
When I try this, I get the following error:
Asynchronous operations are not allowed in this context. Page starting an asynchronous operation has to have the Async attribute set to true and an asynchronous operation can only be started on a page prior to PreRenderComplete event.
How do I fix this?
-Eugene