Example #1
0
        public static void Main(string[] args)
        {
            string[] Names, Values;
            int      InterviewID = 42;

            try
            {
                MainProgram      mail      = new MainProgram();
                CreateWordDoc    creator   = new CreateWordDoc();
                SendingEmail     sender    = new SendingEmail();
                WordToPDF        converter = new WordToPDF();
                ExtractFieldsXML job       = new ExtractFieldsXML();

                ReadSettingsFile(sender);

                int count = mail.ReadWithRESTSaveXMLReportFile();

                for (int i = 0; i < count; i++)
                {
                    try
                    {
                        InterviewID = ProcessedInterviewIDs.ElementAt <int>(i);

                        job.ExtractFieldsfromXML(InterviewID, PathToXMLFiles + XMLFileName,
                                                 NumberOfFieldsFromXML, out Names, out Values);

                        creator.CreateWordDocFromFields(InterviewID, PathToWordTemplate + WordTemplateFileName, PathToWordDoc + WordDocFileName, Names, Values);

                        string PDFFilePathFileName = PathToPDFFile + PDFFileName.Replace(".pdf", "") + "_" + Values[9] + ".pdf";

                        string WordFilePathFileName = PathToWordDoc + WordDocFileName;

                        converter.ConvertDOCtoPDF(InterviewID, WordFilePathFileName, PDFFilePathFileName);

                        sender.SendEmail(InterviewID, PDFFilePathFileName, Values[10]);
                    } catch (Exception e)
                    {
                        S.WriteLine($"Error in Processing Record ID: { InterviewID }.");
                        S.WriteLine("Exception " + e);
                        if (i <= count - 2)
                        {
                            S.WriteLine("Moving to next record.");
                        }
                        else
                        {
                            S.WriteLine("All records processed.");
                        }
                        continue;
                    }
                }
            }
            catch (Exception e)
            {
                System.Console.WriteLine(e);
            }

            finally
            {
                System.Console.ReadLine();
            }
        }
Example #2
0
        public void WordToPDFConv(string input, string outpath)
        {
            isDone = false;
            //Opens Microsoft Word in Background
            Microsoft.Office.Interop.Word.Application word = new Microsoft.Office.Interop.Word.Application();
            //Gets DocumentName and DocumentPath
            List <string> file = input.Split('\\').ToList();

            List <string> path = new List <string>();

            for (int i = 0; i < file.Count - 1; i++)
            {
                path.Add(file[i]);
            }
            var worddoc = file.Last();
            //Saves the name and the path
            DirectoryInfo dirInfo = new DirectoryInfo(string.Join("\\", path));

            FileInfo[] wordFiles = dirInfo.GetFiles(worddoc);
            if (wordFiles.Count() == 0)
            {
                MessageBox.Show("No Documents In This path");
            }


            //Hides the word document in Background
            word.Visible        = false;
            word.ScreenUpdating = false;
            //Using foreach for future upgrade where you would convert multiple documents at once
            foreach (FileInfo wordFile in wordFiles)
            {
                try
                {
                    WordToPDF wordToPDF      = new WordToPDF();
                    object    outputFileName = null;
                    Object    filename       = (Object)wordFile.FullName;
                    //Opens the file in word
                    Document doc = word.Documents.Open(ref filename);
                    doc.Activate();
                    //Renaming the original's file extension to PDF
                    outputFileName = wordFile.FullName.Replace(".doc", ".pdf");
                    if (wordFile.Extension == ".docx")
                    {
                        outputFileName = wordFile.FullName.Replace(".docx", ".pdf");
                    }
                    //Saves the renamed file in PDF format
                    object fileFormat = WdSaveFormat.wdFormatPDF;
                    doc.SaveAs(ref outputFileName,
                               ref fileFormat);

                    object saveChanges = WdSaveOptions.wdDoNotSaveChanges;
                    //Closes the document
                    (doc).Close(ref saveChanges);
                    doc = null;

                    string sourceFile = (string)(input);
                    string destinationFile;


                    if (wordFile.Extension == ".docx")
                    {
                        destinationFile = outpath + "\\" + wordFile.Name.Replace(".docx", ".pdf");
                    }
                    else
                    {
                        destinationFile = outpath + "\\" + wordFile.Name.Replace(".doc", ".pdf");
                    }
                    if (outpath == string.Join("\\", path))
                    {
                        isDone = true;
                        ConvertorDbService.AddDocConvert(wordFile.Name.Replace(".doc", ".pdf"), outpath, true);
                    }
                    else
                    {
                        if (File.Exists(destinationFile))
                        {
                            var messagebox = MessageBox.Show("File with same name already exists! Do you want to overwrite it?", "Error", MessageBoxButtons.YesNoCancel);
                            if (messagebox == DialogResult.Yes)
                            {
                                File.Delete(destinationFile);
                                File.Move((string)(outputFileName), destinationFile);
                                isDone = true;
                                ConvertorDbService.AddDocConvert(wordFile.Name.Replace(".doc", ".pdf"), outpath, true);
                            }
                            else if (messagebox == DialogResult.No)
                            {
                                MessageBox.Show("Converting Canceled");
                                ConvertorDbService.AddDocConvert(wordFile.Name, outpath, false);
                            }
                            else
                            {
                                ConvertorDbService.AddDocConvert(wordFile.Name, outpath, false);
                            }
                        }
                        else
                        {
                            ConvertorDbService.AddDocConvert((string)(outputFileName), destinationFile, false);
                            File.Move((string)(outputFileName), destinationFile);
                            isDone = true;
                        }
                    }

                    string newDirect   = destinationFile;
                    string newFileName = sourceFile;
                    wordToPDF.FileName        = newFileName;
                    wordToPDF.DirectoryPath   = dirInfo.FullName;
                    wordToPDF.OutputDirectory = newDirect;
                    wordToPDF.Type            = "Document";
                }
                catch (ArgumentException)
                {
                    ConvertorDbService.AddDocConvert(wordFile.Name, wordFile.DirectoryName, false);
                    MessageBox.Show("Error during converting. Please check if you selected correct convert file and settings!");
                }

                //Quitting Microsoft Word from the background
                word.Quit(ref oMissing, ref oMissing, ref oMissing);
                word = null;

                string message = "Converting Done!";
                string title   = "Done!";
                if (isDone)
                {
                    MessageBox.Show(message, title);
                }
            }
        }