private void button1_Click(object sender, EventArgs e)//OK TO PROCESS Button { listView1.Clear(); File.Delete(TempFolderPath + NonstandardFormFileNameOnly); Process.Start(GroupsFolderPath + GroupName + @"\Import"); Process.Start(TempFolderPath); PopulateNonstandardWikiLog populate = new PopulateNonstandardWikiLog(); populate.PopulateNonstandardWikiLogMethod(); CreateTestResultOutlookEmail createEmail = new CreateTestResultOutlookEmail(); foreach (string erid in GetNonstandardFileData.EmployerID) { ERID = erid; } GetStringBetweenString getStringBetweenString = new GetStringBetweenString(); string requestersFirstName = getStringBetweenString.GetStringBetweenStringMethod(GetNonstandardFileData.Requester, "", " "); string managersLastName = getStringBetweenString.GetStringBetweenStringMethod(GetNonstandardFileData.ApprovingManager, " ", "•"); string emailTo = GetNonstandardFileData.Requester; string emailCC = GetNonstandardFileData.ApprovingManager; string emailSubject = GetNonstandardFileData.EmployerName + " - " + ERID + " - Nonstandard File Request Approved"; string emailBody = String.Format("<p style = \"font-size:11pt;\">Hello " + requestersFirstName + ",<br/><br/>" + "Your file(s) have been staged for processing and should " + "produce results within the next few hours.</p> "); createEmail.CreateTestResultOutlookEmailMethod(emailTo, string.Empty, string.Empty, string.Empty, emailCC, string.Empty, string.Empty, string.Empty, emailSubject, emailBody); }
private void PrivateGetOutlookEmailsFromDesignatedFolderMethod(string InboxFolderName) { Microsoft.Office.Interop.Outlook.Application outlook = new Microsoft.Office.Interop.Outlook.Application(); NameSpace outlookNameSpace = outlook.GetNamespace("MAPI"); MAPIFolder rootFolder = outlookNameSpace.DefaultStore.GetRootFolder(); MAPIFolder defaultFolder = outlookNameSpace.GetDefaultFolder(OlDefaultFolders.olFolderInbox); try { try { MAPIFolder subFolderETL = defaultFolder.Folders[InboxFolderName]; SubFolderETLObject = subFolderETL; SubFolderETLString = subFolderETL.ToString(); } catch (System.Exception ex) { MessageBox.Show("The subfolder " + SubFolderETLObject + " is not found under root folder " + defaultFolder, "", MessageBoxButtons.OK, MessageBoxIcon.Error); } //MessageBox.Show(rootFolder.Name); //Get folder other than default inbox for (int i = 1; i <= SubFolderETLObject.Items.Count; i++) { Microsoft.Office.Interop.Outlook.MailItem item = SubFolderETLObject.Items[i]; //MessageBox.Show(i.ToString()); //MessageBox.Show(item.Subject); //MessageBox.Show(item.Body); //MessageBox.Show(item.HTMLBody); EmailSubjectLine = item.Subject; EmailBody = item.Body; GetStringBetweenString getBody = new GetStringBetweenString(); GetStringBetweenString getSubject = new GetStringBetweenString(); string body = getBody.GetStringBetweenStringMethod(EmailBody, "Comment", "Ticket URL"); string etlTicketNumberAndErid = getSubject.GetStringBetweenStringMethod(EmailSubjectLine.ToString(), "#", "-"); string etlTicketNumber = getSubject.GetStringBetweenStringMethod(etlTicketNumberAndErid, "", ":"); string erid = getSubject.GetStringBetweenStringMethod(etlTicketNumberAndErid, " ", " "); //string erid = getSubject.GetStringBetweenStringMethod(eridWithSpaces, " ", " "); MessageBox.Show(EmailSubjectLine); MessageBox.Show(body); MessageBox.Show(etlTicketNumberAndErid); MessageBox.Show(etlTicketNumber); //MessageBox.Show(eridWithSpaces); MessageBox.Show(erid); //if (EmailBody.Contains("Comment")) //{ // MessageBox.Show(body); // if (EmailSubjectLine.Contains("Employer:")) // { // MessageBox.Show("If Subject line contains.."+erid); // ERID = erid; // } // else // { // MessageBox.Show("If Subject line contains.." + erid); // ERID = erid; // } //} //else //{ // //do nothing //} //get email contacts from the implementation spreadsheet //MessageBox.Show("ERID going into GetSpecificDataFromExcelDatabase: " + ERID); GetSpecificDataFromExcelDatabase getData = new GetSpecificDataFromExcelDatabase(); getData.GetSpecificDataFromExcelDatabaseMethod(ERID); //create email string emailBody = String.Format("<p style = \"font-size:11pt;\">Hello Everyone,<br/><br/>" + "Test results are below:<br/><br/></p> "); CreateTestResultOutlookEmail createEmail = new CreateTestResultOutlookEmail(); //createEmail.CreateTestResultOutlookEmailMethod(); } } catch (NullReferenceException ex) { } catch (ObjectDisposedException ex) { } catch (EntryPointNotFoundException ex) { } }