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();
}
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);
}
