private void SourceNextButton_Click(object sender, RoutedEventArgs e) { if (SourceQueryGeneratorControl.QueryResults.Count == 0) { MessageBox.Show("Please select a list object for source"); return; } //SourceSiteSetting = ApplicationContext.Current.GetSiteSetting(SourceFolder.SiteSettingID); //Logger.Error("10", "SyncCopyListWizardForm"); //SourceFolderFields = ApplicationContext.Current.GetFields(SourceSiteSetting, SourceFolder); //SourceFolderFields = SourceQueryGeneratorControl.QueryResults[0].Fields; SyncTask.SourceQueryResultMapping.Mappings.Clear(); Logger.Error("11", "SyncCopyListWizardForm"); for (int i = 0; i < SourceQueryGeneratorControl.QueryResults.Count; i++) { /* * QueryResult test1QueryResult = new QueryResult(); * test1QueryResult.Fields = sourceFieldNames.ToArray(); * test1QueryResult.ListName = SourceFolder.GetListName(); * test1QueryResult.Name = SourceFolder.GetListName(); * test1QueryResult.SiteSetting = (SiteSetting)SourceSiteSetting; * test1QueryResult.Filters = new CamlFilters(); */ QueryResultMapping test1QueryResultMapping = new QueryResultMapping(); test1QueryResultMapping.QueryResult = SourceQueryGeneratorControl.QueryResults[i]; test1QueryResultMapping.SelectFields = SourceQueryGeneratorControl.QueryResultMappingSelectFields[i]; SyncTask.SourceQueryResultMapping.Mappings.Add(test1QueryResultMapping); } /* * Field ctField = new Field() * { * ID = Guid.Empty, * Name = "ContentType", * DisplayName = "ContentType", * FromBaseType = false * }; * SourceFolderFields.Add(ctField); */ CurrentTabIndex = 1; WizardTabControl.SelectedIndex = CurrentTabIndex; }
private void GenerateExcelImportTask() { ISiteSetting siteSetting = ApplicationContext.Current.GetSiteSetting(_MainObject.SiteSettingID); List <string> excelHeaders = new List <string>(); List <string> sharePointFieldNames = new List <string>(); Dictionary <string, string> fieldMappings = new Dictionary <string, string>(); foreach (UIElement element in DynamicGrid.Children) { if (element is ComboBox) { string excelHeader = ((ComboBox)element).Tag.ToString(); string sharePointFieldName = ((ComboBoxItem)((ComboBox)element).SelectedItem).Tag.ToString(); if (string.IsNullOrEmpty(sharePointFieldName) == true) { continue; } excelHeaders.Add(excelHeader); sharePointFieldNames.Add(sharePointFieldName); fieldMappings.Add(excelHeader, sharePointFieldName); } } excelHeaders.Insert(0, "ID"); sharePointFieldNames.Insert(0, "SourceItemID"); //List<SyncTask> syncTasks = new List<SyncTask>(); SyncTask syncTask = SyncTask.NewSyncTask(); syncTask.ID = Guid.NewGuid(); syncTask.ScheduleInterval = 240; string folderPath = ConfigurationManager.GetInstance().GetSyncTaskFolder(syncTask); System.IO.File.Copy(_SelectedFileFullPath, folderPath + "\\ProcessedExport.xlsx"); QueryResult test1QueryResult = new QueryResult(); test1QueryResult.Fields = excelHeaders.ToArray(); test1QueryResult.ListName = "Test1"; test1QueryResult.Name = "Test1"; test1QueryResult.SiteSetting = null; test1QueryResult.Filters = new CamlFilters(); /* * test1QueryResult.ReferenceFields.Add(new QueryResultReferenceField() * { * SiteSetting = GetTestSiteSetting(), * ReferenceFilterFieldName = "FilterValue", * ReferenceListName = "TestLookup", * ReferenceValueFieldName = "DataValue", * SourceFieldName = "RefField", * OutputName = "RefField1" * }); */ QueryResultMapping test1QueryResultMapping = new QueryResultMapping(); test1QueryResultMapping.QueryResult = test1QueryResult; List <QueryResultMappingSelectField> queryResultMappingSelectFields = new List <QueryResultMappingSelectField>(); foreach (string excelHeader in excelHeaders) { queryResultMappingSelectFields.Add(new QueryResultMappingSelectField(excelHeader, excelHeader)); } test1QueryResultMapping.SelectFields = queryResultMappingSelectFields.ToArray(); syncTask.SourceQueryResultMapping.Mappings.Add(test1QueryResultMapping); syncTask.DestinationListName = _MainObject.GetListName(); syncTask.DestinationRootFolderPath = _MainObject.GetListName(); syncTask.Name = _MainObject.GetListName(); syncTask.SourceUniqueFieldHeaderNames = new string[] { "ID" }; syncTask.DestinationUniqueFieldNames = new string[] { "SourceItemID" }; syncTask.DestinationIDFieldHeaderName = "ID"; syncTask.SourceFieldHeaderMappings = excelHeaders.ToArray(); //syncTask.DestinationFieldMappings = sharePointFieldNames.ToArray(); syncTask.IsDestinationDocumentLibrary = false; syncTask.DestinationTermStoreName = "Taxonomy_BrjLUNqY3/3gqp8FAbbKiQ=="; syncTask.DestinationSiteSetting = (SiteSetting)siteSetting; //syncTasks.Add(syncTask); //SyncTasksManager.GetInstance().SyncTasks.Clear(); //SyncTasksManager.GetInstance().SyncTasks.Add(syncTask); //SyncTasksManager.GetInstance().SaveSyncTasks(); SyncBackgroundWorker.RunWorkerAsync(new object[] { syncTask }); }