private OracleConnection GetDatabaseConnection()
{
OracleConnection connection = null;
try
{
connection = new OracleConnection(connectionString);
}
catch (Exception ex)
{
LoggingUtility.WriteLog(ELogLevel.ERROR, "Error in GetDatabaseConnection() " + ex.Message.ToString());
}
return(connection);
}
public void ProcessEmailNotificationsWithAttachments(bool IsConnectionSuccess)
{
LoggingUtility.WriteLog(ELogLevel.INFO, "Processing attachment emails started");
Email email;
DataTable emailNotificationsData = dbContext.GetEmailNotificationsWithAttachment();
if (emailNotificationsData != null && emailNotificationsData.Rows.Count > 0)
{
foreach (DataRow notification in emailNotificationsData.Rows)
{
int notificationId = 0;
try
{
notificationId = Convert.ToInt32(notification["NOTIFICATIONID"]);
email = new Email();
email.To = Convert.ToString(notification["MailTo"]);
if (!string.IsNullOrEmpty(Convert.ToString(notification["EmailTEMPLATEID"])) && !string.IsNullOrEmpty(Convert.ToString(notification["EVENTDATE"])))
{
email.Bcc = Program.appConfig[Constants.ACCEASecretariat].ToString();
}
email.Subject = Convert.ToString(notification["MailSubject"]);
email.Body = Convert.ToString(notification["MailBody"]);
email.AttachmentName = Convert.ToString(notification["COMMFILENAME"]);
email.AttachmentData = (byte[])(notification["Communicationfile"]);
bool result = sendMail.TriggerEmail(email);
dbContext.UpdateMailAttemptsAndStatus(notificationId, result, Convert.ToInt32(Program.appConfig[Constants.MaxRetryAttempts]));
}
catch (Exception ex)
{
LoggingUtility.WriteLog(ELogLevel.ERROR, "ProcessEmailNotificationsWithAttachments() | Error in sending emails : " + notificationId.ToString() + " " + ex.Message.ToString());
dbContext.UpdateEmailErrorLogs(notificationId, ex.Message.ToString(), IsConnectionSuccess);
}
}
}
else
{
LoggingUtility.WriteLog(ELogLevel.INFO, "No pending emails with attachment for process");
}
}
