public void SendReport(Report report, Contact[] contacts, Report.ExportFormat Format, DateTime getCachedFrom, out bool isFromCache) { isFromCache = false; if (report.IsProxy) { throw new Exception("Report cannot be Proxy"); } if (contacts.Length == 0) { return; } string fileNamePattern = report.GetType().Name + "_" + report.ID.ToString() + "_"; string fileName = fileNamePattern + DateTime.Now.ToString("yyyyMMddHHmmss") + "." + Format.ToString(); string cacheLookupFileName = fileNamePattern + getCachedFrom.ToString("yyyyMMddHHmmss") + "." + Format.ToString(); string filePath = null; string reportString = null; // lookup cached report string[] lookupPaths = Directory.GetFiles(FI.Common.AppConfig.TempDir, fileNamePattern + "*." + Format.ToString()); if (lookupPaths != null) { foreach (string path in lookupPaths) { string file = Path.GetFileName(path); if (file.Length == cacheLookupFileName.Length && file.CompareTo(cacheLookupFileName) > 0) { filePath = FI.Common.AppConfig.TempDir + @"\" + file; isFromCache = true; break; } } } if (filePath == null) { filePath = FI.Common.AppConfig.TempDir + @"\" + fileName; report.Export(filePath, Format); } foreach (Contact cnt in contacts) { if (Format == Report.ExportFormat.HTML && reportString == null) { if (cnt.DistributionFormat == Contact.DistributionFormatEnum.MessageBody || cnt.DistributionFormat == Contact.DistributionFormatEnum.Body_And_Attachment) { StreamReader sr = new StreamReader(filePath, System.Text.Encoding.Unicode, true); if (sr != null) { reportString = sr.ReadToEnd(); sr.Close(); } } } //send via email try { if (cnt.IsProxy) { cnt.Fetch(); } // message object OpenSmtp.Mail.MailMessage msg = new OpenSmtp.Mail.MailMessage(); msg.From = new OpenSmtp.Mail.EmailAddress(FI.Common.AppConfig.SmtpSender); msg.To.Add(new OpenSmtp.Mail.EmailAddress(cnt.EMail)); msg.Subject = report.Name + " (" + report.Description + ")"; // attachment if ordered or report is not html if (cnt.DistributionFormat == Contact.DistributionFormatEnum.Attachment || cnt.DistributionFormat == Contact.DistributionFormatEnum.Body_And_Attachment || Format != Report.ExportFormat.HTML) { OpenSmtp.Mail.Attachment att = new OpenSmtp.Mail.Attachment(filePath); //att.Encoding=System.Web.Mail.MailEncoding.UUEncode; msg.Attachments.Add(att); } // message body (if retport is html) if (Format == Report.ExportFormat.HTML && (cnt.DistributionFormat == Contact.DistributionFormatEnum.MessageBody || cnt.DistributionFormat == Contact.DistributionFormatEnum.Body_And_Attachment)) { msg.HtmlBody = reportString; } // msg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "0"); //This is crucial. put 0 there // msg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout", 90); OpenSmtp.Mail.SmtpConfig.LogToText = false; OpenSmtp.Mail.Smtp smtp = new OpenSmtp.Mail.Smtp(); smtp.SendTimeout = 600; smtp.Host = FI.Common.AppConfig.SmtpServer; if (FI.Common.AppConfig.SmtpUserName != null && FI.Common.AppConfig.SmtpUserName != "") { smtp.Username = FI.Common.AppConfig.SmtpUserName; smtp.Password = FI.Common.AppConfig.SmtpPassword; } smtp.SendMail(msg); // System.Web.Mail.SmtpMail.SmtpServer=FI.Common.AppConfig.SmtpServer; // System.Web.Mail.SmtpMail.Send(msg); } catch (Exception exc) { // because real exception is inside: while (exc.InnerException != null) { exc = exc.InnerException; } Common.LogWriter.Instance.WriteEventLogEntry(exc); throw exc; } } }
public void SendReport(Report report, Guid olapTaskGuid, Contact[] contacts, Report.ExportFormat Format, DateTime minCacheTimestamp, DateTime currentTimestamp, out bool isFromCache) { isFromCache = false; if (contacts.Length == 0) { return; } if (report.IsProxy) { report.Open(); } string fileNamePattern = report.GetType().Name + "_" + report.ID.ToString() + "_"; string newFileName = fileNamePattern + currentTimestamp.ToString("yyyyMMddHHmmssfff") + "." + Format.ToString(); string cacheLookupFileName = fileNamePattern + minCacheTimestamp.ToString("yyyyMMddHHmmssfff") + "." + Format.ToString(); string filePath = null; string reportString = null; // lookup cached report if (minCacheTimestamp != DateTime.MinValue && minCacheTimestamp != DateTime.MaxValue) { string[] lookupPaths = Directory.GetFiles(FI.Common.AppConfig.TempDir, fileNamePattern + "*." + Format.ToString()); if (lookupPaths != null) { foreach (string path in lookupPaths) { string file = Path.GetFileName(path); if (file.Length == cacheLookupFileName.Length && file.CompareTo(cacheLookupFileName) > 0) { filePath = FI.Common.AppConfig.TempDir + @"\" + file; isFromCache = true; break; } } } } // no cache, execute if (filePath == null) { if (report.State == Report.StateEnum.Open) { OlapReport olapRpt = report as OlapReport; if (olapRpt != null) { olapRpt.Execute(olapTaskGuid); } else { report.Execute(); } } filePath = FI.Common.AppConfig.TempDir + @"\" + newFileName; report.Export(filePath, Format); } // send to contacts foreach (Contact cnt in contacts) { if (Format == Report.ExportFormat.HTML && reportString == null) { if (cnt.DistributionFormat == Contact.DistributionFormatEnum.MessageBody || cnt.DistributionFormat == Contact.DistributionFormatEnum.Body_And_Attachment) { StreamReader sr = new StreamReader(filePath, System.Text.Encoding.Unicode, true); if (sr != null) { reportString = sr.ReadToEnd(); sr.Close(); } } } //send via email try { if (cnt.IsProxy) { cnt.Fetch(); } // message object System.Net.Mail.MailMessage msg = new System.Net.Mail.MailMessage(); msg.From = new System.Net.Mail.MailAddress(FI.Common.AppConfig.SmtpSender); msg.To.Add(cnt.EMail); msg.Subject = report.Name + " (" + report.Description + ")"; //OpenSmtp.Mail.MailMessage msg=new OpenSmtp.Mail.MailMessage(); //msg.From=new OpenSmtp.Mail.EmailAddress(FI.Common.AppConfig.SmtpSender); //msg.To.Add(new OpenSmtp.Mail.EmailAddress(cnt.EMail)); //msg.Subject=report.Name + " (" + report.Description + ")"; // attachment if ordered or report is not html if (cnt.DistributionFormat == Contact.DistributionFormatEnum.Attachment || cnt.DistributionFormat == Contact.DistributionFormatEnum.Body_And_Attachment || Format != Report.ExportFormat.HTML) { //OpenSmtp.Mail.Attachment att=new OpenSmtp.Mail.Attachment(filePath); //att.Encoding=System.Web.Mail.MailEncoding.UUEncode; System.Net.Mail.Attachment att = new System.Net.Mail.Attachment(filePath); msg.Attachments.Add(att); } // message body (if retport is html) if (Format == Report.ExportFormat.HTML && (cnt.DistributionFormat == Contact.DistributionFormatEnum.MessageBody || cnt.DistributionFormat == Contact.DistributionFormatEnum.Body_And_Attachment)) { //msg.HtmlBody=reportString; msg.Body = reportString; msg.IsBodyHtml = true; } // msg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate", "0"); //This is crucial. put 0 there // msg.Fields.Add("http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout", 90); //OpenSmtp.Mail.SmtpConfig.LogToText=false; System.Net.Mail.SmtpClient smtp = new System.Net.Mail.SmtpClient(); smtp.DeliveryMethod = System.Net.Mail.SmtpDeliveryMethod.Network; smtp.Host = FI.Common.AppConfig.SmtpServer; smtp.Timeout = 600000; // 10 minutes if (FI.Common.AppConfig.SmtpPort > 0) { smtp.Port = FI.Common.AppConfig.SmtpPort; } //OpenSmtp.Mail.Smtp smtp=new OpenSmtp.Mail.Smtp(); //smtp.SendTimeout=600; //smtp.Host=FI.Common.AppConfig.SmtpServer; if (FI.Common.AppConfig.SmtpUserName != null && FI.Common.AppConfig.SmtpUserName != "") { smtp.Credentials = new System.Net.NetworkCredential(FI.Common.AppConfig.SmtpUserName, FI.Common.AppConfig.SmtpPassword); //smtp.Username=FI.Common.AppConfig.SmtpUserName; //smtp.Password=FI.Common.AppConfig.SmtpPassword; } smtp.Send(msg); //smtp.SendMail(msg); // System.Web.Mail.SmtpMail.SmtpServer=FI.Common.AppConfig.SmtpServer; // System.Web.Mail.SmtpMail.Send(msg); } catch (Exception exc) { // because real exception is inside: while (exc.InnerException != null) { exc = exc.InnerException; } Common.LogWriter.Instance.WriteEventLogEntry(exc); throw exc; } } }