public EmailDetails GetEmailDetails(string AppCode, int PersID, MySqlConnection conn, string ContractNumber, string ContractName, string ContractEndDate, string DaysUntilExpired, string ToEmails, string CCEmails) { try { using (conn) { //Open connection if not open if (conn.State == ConnectionState.Closed) { conn.Open(); } using (cmd) { cmd.Connection = conn; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("AppCode", AppCode); cmd.Parameters.AddWithValue("PersonID", PersID); cmd.Parameters.AddWithValue("ContractNumber", ContractNumber); cmd.Parameters.AddWithValue("ContractName", ContractName); cmd.Parameters.AddWithValue("ContractEndDate", ContractEndDate); cmd.Parameters.AddWithValue("DaysUntilExpired", DaysUntilExpired); cmd.Parameters.AddWithValue("ToEmails", ToEmails); cmd.Parameters.AddWithValue("CCEmails", CCEmails); cmd.CommandText = "HSPD12Email_Main"; cmd.CommandType = CommandType.StoredProcedure; MySqlDataReader emailData = cmd.ExecuteReader(); //Return details depending on type while (emailData.Read()) { return(EmailDetails.GetEmailDetails(emailData)); } return(null); } } } catch (MySqlException) { //Log exception throw; } }
/// <summary> /// New method that access the DB and gets the email details. /// Developed as part of email consolidation. /// <summary> /// <param name="AppCode"></param> private void HSPD12Email(string AppCode, string ContractNumber, string ContractName, string ContractEndDate, string DaysUntilExpired, string ToEmails, string CCEmails) { //Declare function variables EmailDetails emailData = new EmailDetails(); emailData = emailData.GetEmailDetails(AppCode, personID, conn, ContractNumber, ContractName, ContractEndDate, DaysUntilExpired, ToEmails, CCEmails); if (emailData != null) { string strEmailAttachment = string.Empty; if (emailData.EmailAttachment.IndexOf(";") > 0) { strEmailAttachment = onboardingLocation + emailData.EmailAttachment.Replace(";", string.Concat(";", onboardingLocation)); } if (emailData.EmailFromAdd.Contains("@")) { message.Send(emailData.EmailFromAdd, emailData.EmailToAdd, emailData.EmailCCAdd, emailData.EmailBCCAdd, emailData.EmailSubject, emailData.EmailBody, strEmailAttachment, smtpServer, true); } } }