public void sendDailyEmail( ) { RproDBHandler rproDBHandler = new RproDBHandler(settings); try { List <string[]> errorLogs = rproDBHandler.getLogDetails("where logtype != '" + MainController.LogType.REPORT.ToString() + "' and date1 > trunc(sysdate) "); List <string[]> zeroCostLogs = rproDBHandler.getZeroCost("where date1 > trunc(sysdate)"); String body = "<table width='100%' cellspacing='0' border='1' style='border - collapse:collapse;' >"; body += "<caption>Error Logs</caption>"; foreach (var item in errorLogs) { body += "<tr>"; for (int i = 0; i < item.Length - 1; i++) { body += "<td stlye='color:blue;'>" + item[i] + "</td>"; } body += "</tr>"; } body += "</table>"; body += "<br> <br/>"; body += "<table width='100%' cellspacing='0' border='1' style='border - collapse:collapse;' >"; body += "<caption>Zero Cost Logs</caption>"; foreach (var item in zeroCostLogs) { body += "<tr>"; for (int i = 0; i < item.Length; i++) { body += "<td stlye='color:blue;'>" + item[i] + "</td>"; } body += "</tr>"; } body += "</table>"; MailMessage mail = new MailMessage(); SmtpClient SmtpServer = new SmtpClient(smtp_address, smtp_port); mail.From = new MailAddress(email_sender_address); mail.To.Add(email_recepient_address); mail.Subject = "B1 Daily Email " + System.DateTime.Today.ToShortDateString().ToString(); mail.IsBodyHtml = true; mail.Body = body; //SmtpServer.Port = smtp_port; SmtpServer.Credentials = new System.Net.NetworkCredential(email_sender_address, email_password); SmtpServer.EnableSsl = email_enable_SSL; SmtpServer.DeliveryMethod = SmtpDeliveryMethod.Network; SmtpServer.Send(mail); rproDBHandler.addLog(MainController.LogType.REPORT, "", "", MainController.Features.SEND_EMAIL, "Email Sent (Today's Log)", null); } catch (Exception e) { if (rproDBHandler != null) { string msg = "Exception occurred when sending email on error report. "; rproDBHandler.addLog(MainController.LogType.REPORT, "", "", MainController.Features.SEND_EMAIL, msg, e); } } }