private static string CreateDocumentWithSexDependendwords(Sex s, InternalDetails internDetails)
{
string tempTemplatePath = @"Files\temp.docx";
DocX document = null;
if (SavepathSerializer.Instance.SavePath != "")
{
File.Copy(SavepathSerializer.Instance.SavePath, tempTemplatePath, true);
try
{
document = DocX.Load(tempTemplatePath);
}
catch (FileFormatException)
{
MessageDialog Dialog = new MessageDialog(WORDPROCESS_ERR_TITLE, WORDPROCESS_ERR_EMPTY_FILE);
Dialog.ShowDialog();
throw new FileFormatException();
}
}
else
{
File.Copy(@"Files/Vorlage.docx", tempTemplatePath, true);
document = DocX.Load(tempTemplatePath);
}
StringEditor.ReplaceWordsBasedOnGender(document, internDetails, tempTemplatePath);
StringEditor.ReplaceDatesAndNames(document, internDetails, tempTemplatePath);
return(tempTemplatePath);
}
public static void WordReplacerInterop(InternalDetails internDetails, Dictionary <string, string> textParts, bool PractExpBulletpoints, bool ExcercisesBulletPoints)
{
//Erstelle nötige Pfade
string csvFileName = "csvTempFile.csv";
string fullCsvFilePath = Path.GetFullPath(csvFileName);
string tempTemplatePath = "";
try
{
tempTemplatePath = CreateDocumentWithSexDependendwords(internDetails.Sex, internDetails);
}
catch (FileFormatException)
{
return;
}
string fullTemplatePath = Path.GetFullPath(tempTemplatePath);
//Erstelle nötige Strings
string lastname = internDetails.LastName != null ? internDetails.LastName : "";
string firstname = internDetails.FirstName != null ? internDetails.FirstName : "";
string dateOfBirth = internDetails.DateOfBirth.Date.ToString().Replace(" 00:00:00", "");
string department = internDetails.Department != null ? internDetails.Department : "";
string fromDate = internDetails.FromDate.Date.ToString().Replace(" 00:00:00", "");
string untilDate = internDetails.UntilDate.Date.ToString().Replace(" 00:00:00", "");
string exercises = internDetails.Exercises != null ? internDetails.Exercises : "";
string praticalExp = internDetails.PracitcalExperience != null ? internDetails.PracitcalExperience : "";
string today = DateTime.Now.Date.ToString().Replace(" 00:00:00", "");
string criteriaEvaluation = "";
foreach (KeyValuePair <string, string> text in textParts)
{
criteriaEvaluation += text.Value + " ";
}
criteriaEvaluation = StringEditor.ReplaceDatesAndNames(internDetails, criteriaEvaluation);
criteriaEvaluation = StringEditor.ReplaceWordsBasedOnGender(internDetails, criteriaEvaluation);
Regex backSlashN = new Regex(@"\n");
criteriaEvaluation = backSlashN.Replace(criteriaEvaluation, " ");
//Überschreibe MailMergeField "PraktischeErfahrung" und "Aufgaben" damit diese Mehrzeilig sind
try
{
using (WordprocessingDocument wrdProssesDoc = WordprocessingDocument.Open(tempTemplatePath, true))
{
Document document = wrdProssesDoc.MainDocumentPart.Document;
IEnumerable <FieldCode> allMailMergeFields = document.Body.Descendants <FieldCode>();
foreach (FieldCode mm in allMailMergeFields)
{
if (mm.InnerText == " MERGEFIELD PraktischeErfahrung ")
{
OpenXmlElement refParagraph;
for (refParagraph = mm; !(refParagraph is DocumentFormat.OpenXml.Wordprocessing.Paragraph) && !(refParagraph is Body); refParagraph = refParagraph.Parent)
{
;
}
if (refParagraph is Body)
{
continue;
}
if (PractExpBulletpoints)
{
ParagraphProperties prp = (ParagraphProperties)refParagraph.GetFirstChild <ParagraphProperties>().CloneNode(true);
OverrideMailmergefield(refParagraph, praticalExp, prp);
}
else
{
ParagraphProperties prp = new ParagraphProperties();
OverrideMailmergefield(refParagraph, praticalExp, prp);
}
wrdProssesDoc.MainDocumentPart.Document.Save();
}
if (mm.InnerText == " MERGEFIELD Aufgaben ")
{
OpenXmlElement refParagraph;
for (refParagraph = mm; !(refParagraph is DocumentFormat.OpenXml.Wordprocessing.Paragraph) && !(refParagraph is Body); refParagraph = refParagraph.Parent)
{
;
}
if (refParagraph is Body)
{
continue;
}
if (ExcercisesBulletPoints)
{
ParagraphProperties prp = (ParagraphProperties)refParagraph.GetFirstChild <ParagraphProperties>();
OverrideMailmergefield(refParagraph, exercises, prp);
}
else
{
ParagraphProperties prp = new ParagraphProperties();
OverrideMailmergefield(refParagraph, exercises, prp);
}
wrdProssesDoc.MainDocumentPart.Document.Save();
}
}
}
}
catch (Exception)
{
MessageDialog msg = new MessageDialog(WORDPROCESS_ERR_TITLE, WORDPROCESS_ERR_TEXT);
}
//Erstelle .csv Datei für Serienbrief
using (FileStream csvFileStream = new FileStream(csvFileName, FileMode.Create))
{
using (StreamWriter streamWriter = new StreamWriter(csvFileStream))
{
streamWriter.WriteLine("Name; Vorname; Geburtsdatum; Abteilung; Anfangsdatum; Enddatum; Aufgaben; PraktischeErfahrung; HeutigesDatum; Benotung");
streamWriter.WriteLine(lastname + ";" + firstname + ";" + dateOfBirth + ";" + department + ";" + fromDate + ";" + untilDate + ";" + " " + ";" + " " + ";" + today + ";" + criteriaEvaluation);
}
}
//Mailmerge ausführen
Word.Application wrdApp = new Word.Application();
Word._Document wrdDoc = null;
wrdApp.Visible = true;
try
{
wrdDoc = wrdApp.Documents.Open(fullTemplatePath);
wrdDoc.MailMerge.OpenDataSource(fullCsvFilePath);
wrdDoc.MailMerge.Destination = Word.WdMailMergeDestination.wdSendToNewDocument;
wrdDoc.MailMerge.Execute();
}
finally
{
if (wrdDoc != null)
{
wrdDoc.Close(false);
}
wrdApp = null;
}
DeleteUsedFiles(csvFileName, tempTemplatePath);
}
