private void doExport() { var ei = new ExcelExportInformation { Project = _project, ReferenceLanguageCode = ((Pair <string, string>)referenceLanguageGroupBox.SelectedItem).Second, DestinationFilePath = destinationFileTextEdit.Text.Trim(), EliminateDuplicateRows = eliminateDuplicateRowsCheckEdit.Checked, OnlyExportRowsWithNoTranslation = exportWithoutDestinationTranslationOnlyCheckEdit.Checked, ExportCompletelyEmptyRows = exportCompletelyEmptyRowsCheckEdit.Checked, OnlyExportRowsWithChangedTexts = exportOnlyRowsWithChangedTextsCheckEdit.Checked, ExportAllGroupsMode = exportGroupsAsOneWorkSheetCheckEdit.Checked ? ExcelExportInformation.ExportFileGroupMode.AllGroupsIntoOneWorksheet : exportGroupsAsWorkSheetsCheckEdit.Checked ? ExcelExportInformation.ExportFileGroupMode.EachGroupIntoSeparateWorksheet : ExcelExportInformation.ExportFileGroupMode.OneExcelFilePerGroup, ExportFileGroupColumn = exportFileGroupColumnCheckEdit.Checked, ExportNameColumn = exportNameColumnCheckEdit.Checked, ExportCommentColumn = exportCommentColumnCheckEdit.Checked, ExportReferenceLanguageColumn = exportReferenceLanguageColumnCheckEdit.Checked, ExportEachLanguageIntoSeparateExcelFile = exportEachLanguageIntoSeparateExcelFileCheckEdit.Checked, UseCrypticExcelExportSheetNames = useCrypticExcelExportSheetNamesCheckEdit.Checked, SendFilesWithZetaUploader = sendFilesToEMailReceiversCheckEdit.Checked, SendFilesEMailReceivers = zulReceiversTextEdit.Text.Trim(), SendFilesEMailSubject = zulSubjectTextEdit.Text.Trim(), SendFilesEMailBody = zulBodyTextEdit.Text.Trim() }; var groups = new List <FileGroup>(); foreach (CheckedListBoxItem item in fileGroupsListBox.CheckedItems) { var p = (Pair <string, FileGroup>)item.Value; groups.Add(p.Second); } ei.FileGroups = groups.ToArray(); var languages = new List <string>(); foreach (CheckedListBoxItem item in languagesToExportCheckListBox.CheckedItems) { var p = (Pair <string, string>)item.Value; languages.Add(p.Second); } ei.DestinationLanguageCodes = languages.ToArray(); // -- progressBackgroundWorker.RunWorkerAsync(ei); UpdateUI(); }
private void progressBackgroundWorker_DoWork( object sender, DoWorkEventArgs e) { Host.ApplyLanguageSettingsToCurrentThread(); var ei = (ExcelExportInformation)e.Argument; _latestExportInformation = ei; var cp = new ExcelExportController(); cp.Prepare(ei); cp.Process((BackgroundWorker)sender); }
private void doExport() { var ei = new ExcelExportInformation { Project = _project, ReferenceLanguageCode = ((Pair<string, string>)referenceLanguageGroupBox.SelectedItem).Second, DestinationFilePath = destinationFileTextEdit.Text.Trim(), EliminateDuplicateRows = eliminateDuplicateRowsCheckEdit.Checked, OnlyExportRowsWithNoTranslation = exportWithoutDestinationTranslationOnlyCheckEdit.Checked, ExportCompletelyEmptyRows = exportCompletelyEmptyRowsCheckEdit.Checked, OnlyExportRowsWithChangedTexts = exportOnlyRowsWithChangedTextsCheckEdit.Checked, ExportAllGroupsMode = exportGroupsAsOneWorkSheetCheckEdit.Checked ? ExcelExportInformation.ExportFileGroupMode.AllGroupsIntoOneWorksheet : exportGroupsAsWorkSheetsCheckEdit.Checked ? ExcelExportInformation.ExportFileGroupMode.EachGroupIntoSeparateWorksheet : ExcelExportInformation.ExportFileGroupMode.OneExcelFilePerGroup, ExportFileGroupColumn = exportFileGroupColumnCheckEdit.Checked, ExportNameColumn = exportNameColumnCheckEdit.Checked, ExportCommentColumn = exportCommentColumnCheckEdit.Checked, ExportReferenceLanguageColumn = exportReferenceLanguageColumnCheckEdit.Checked, ExportEachLanguageIntoSeparateExcelFile = exportEachLanguageIntoSeparateExcelFileCheckEdit.Checked, UseCrypticExcelExportSheetNames = useCrypticExcelExportSheetNamesCheckEdit.Checked, SendFilesWithZetaUploader = sendFilesToEMailReceiversCheckEdit.Checked, SendFilesEMailReceivers = zulReceiversTextEdit.Text.Trim(), SendFilesEMailSubject = zulSubjectTextEdit.Text.Trim(), SendFilesEMailBody = zulBodyTextEdit.Text.Trim() }; var groups = new List<FileGroup>(); foreach (CheckedListBoxItem item in fileGroupsListBox.CheckedItems) { var p = (Pair<string, FileGroup>)item.Value; groups.Add(p.Second); } ei.FileGroups = groups.ToArray(); var languages = new List<string>(); foreach (CheckedListBoxItem item in languagesToExportCheckListBox.CheckedItems) { var p = (Pair<string, string>)item.Value; languages.Add(p.Second); } ei.DestinationLanguageCodes = languages.ToArray(); // -- progressBackgroundWorker.RunWorkerAsync(ei); UpdateUI(); }