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;
}
}
private static EmailDetails GetEmailDetails(IDataRecord record)
{
try
{
var emailData = new EmailDetails
{
/*
* Pers_FullName = record["fullname"].ToString(),
* Pers_SubjectName = record["subjectname"].ToString(),
* Pers_Position = record["position"].ToString(),
* Pers_Region = record["region"].ToString(),
* Pers_MajorOrg = record["majororg"].ToString(),
* Pers_IsCitizen = record["iscitizen"].ToString(),
* Pers_InvestigationDate = record["investigationdate"].ToString(),
* Pers_InvestigationRequested = record["investigationrequested"].ToString(),
* Pers_InvestigationType = record["investigationtype"].ToString(),
* Pers_SponsorDate = record["sponsoreddate"].ToString(),
* Pers_PortofEntry = record["portofentry"].ToString(),
* boolTemplate = record["Templates"].ToString(),
* boolAttachement = record["Attachments"].ToString(),
* boolSummary = record["Summary"].ToString(),
* GSAPOCEMails = record["gsaPOCEMails"].ToString(),
* VendorPOCEmails = record["vendorPOCEmails"].ToString(),
* FASEMail = record["fasEMail"].ToString(),
* ChildcareEMail = record["childcareEMail"].ToString(),
* RegionalEMail = record["zone_email"].ToString(),
* SponsorshipEmails = record["sponsorshipEmails"].ToString(),
* PhoneNumber = record["zone_phone"].ToString()
*/
EmailBody = record["eMailBody"].ToString(),
EmailSubject = record["eMailSubject"].ToString(),
EmailFromAdd = record["eMailFromAdd"].ToString(),
EmailToAdd = record["eMailToAdd"].ToString(),
EmailCCAdd = record["eMailCCAdd"].ToString(),
EmailBCCAdd = record["eMailBCCAdd"].ToString(),
EmailAttachment = record["eMailAttachment"].ToString()
};
return(emailData);
//return null;
}
catch (Exception)
{
//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);
}
}
}