protected void SendNowButton_Click(object sender, System.EventArgs e)
        {
            int keyCount = _gr.SelectedPrimaryKeys.Count;

            if (keyCount == 0)
            {
                return;
            }

            Report.ExportFormat exportFormat = (Report.ExportFormat)Enum.Parse(typeof(Report.ExportFormat), this.ddlFormat.SelectedValue, true);
            Contact[]           contacts     = new Contact[_gr.SelectedPrimaryKeys.Count];

            for (int i = 0; i < keyCount; i++)
            {
                string[] keys      = (string[])_gr.SelectedPrimaryKeys[i];
                decimal  contactId = decimal.Parse(keys[0]);
                contacts[i] = _user.ContactSystem.GetContact(contactId, true);
            }

            try
            {
                _reportProxy.Open();
                _reportProxy.Execute();
                Guid olapTaskGuid = Guid.NewGuid();
                bool isFromCache  = false;

                DistributionManager.Instance.SendReport(_reportProxy, olapTaskGuid, contacts, exportFormat, DateTime.MaxValue, DateTime.Now, out isFromCache);
            }
            catch (Exception exc)
            {
                ShowException(exc);
            }
        }
        internal Distribution(User Owner, Report report, Contact contact, Report.ExportFormat format)
        {
            _owner       = Owner;
            this.Report  = report;
            this.Contact = contact;
            this.Format  = format;

            FI.DataAccess.Distributions dacObj = DataAccessFactory.Instance.GetDistributionsDA();
            _id = dacObj.InsertDistribution(_owner.ID, report.ID, contact.ID, report.GetTypeCode(), this.FrequencyType.ToString(), this.FrequencyValue.ToString(), (int)this.Format);

            _isProxy = false;
            _isDirty = false;
        }
        protected void UpdateButton_Click(object sender, System.EventArgs e)
        {
            Report.ExportFormat exportFormat = (Report.ExportFormat)Enum.Parse(typeof(Report.ExportFormat), this.ddlFormat.SelectedValue, true);

            Distribution.FrequencyTypeEnum  frequencyType  = Distribution.FrequencyTypeEnum.Monthly;
            Distribution.FrequencyValueEnum frequencyValue = Distribution.FrequencyValueEnum.Monthly;

            if (radioWeekDays.Checked == true)
            {
                frequencyType = Distribution.FrequencyTypeEnum.Weekdays;

                //setting FrequencyValue
                if (chkMon.Checked == true)
                {
                    frequencyValue = frequencyValue | Distribution.FrequencyValueEnum.Mon;
                }
                if (chkTue.Checked == true)
                {
                    frequencyValue = frequencyValue | Distribution.FrequencyValueEnum.Tue;
                }
                if (chkWed.Checked == true)
                {
                    frequencyValue = frequencyValue | Distribution.FrequencyValueEnum.Wed;
                }
                if (chkThu.Checked == true)
                {
                    frequencyValue = frequencyValue | Distribution.FrequencyValueEnum.Thu;
                }
                if (chkFri.Checked == true)
                {
                    frequencyValue = frequencyValue | Distribution.FrequencyValueEnum.Fri;
                }
                if (chkSat.Checked == true)
                {
                    frequencyValue = frequencyValue | Distribution.FrequencyValueEnum.Sat;
                }
                if (chkSun.Checked == true)
                {
                    frequencyValue = frequencyValue | Distribution.FrequencyValueEnum.Sun;
                }
            }
            else if (radioWeeks.Checked == true)
            {
                frequencyType = Distribution.FrequencyTypeEnum.Weeks;

                //setting FrequencyValue
                if (chkWeek1.Checked == true)
                {
                    frequencyValue = frequencyValue | Distribution.FrequencyValueEnum.Week1;
                }
                if (chkWeek2.Checked == true)
                {
                    frequencyValue = frequencyValue | Distribution.FrequencyValueEnum.Week2;
                }
                if (chkWeek3.Checked == true)
                {
                    frequencyValue = frequencyValue | Distribution.FrequencyValueEnum.Week3;
                }
                if (chkWeek4.Checked == true)
                {
                    frequencyValue = frequencyValue | Distribution.FrequencyValueEnum.Week4;
                }
            }
            else if (radioMonthly.Checked == true)
            {
                frequencyType = Distribution.FrequencyTypeEnum.Monthly;
            }


            foreach (string[] keys in _gr.SelectedPrimaryKeys)
            {
                try
                {
                    string contact_id      = keys[0];
                    string distribution_id = keys[1];

                    Contact cnt = _user.ContactSystem.GetContact(decimal.Parse(contact_id), false);

                    Distribution distr = null;
                    if (distribution_id != null && distribution_id.Trim() != "")
                    {
                        distr = _user.DistributionSystem.GetDistribution(decimal.Parse(distribution_id), false);
                        if (radioNone.Checked == true)
                        {
                            _user.DistributionSystem.DeleteDistribution(distr);
                            continue;
                        }
                        else
                        {
                            distr.Fetch();
                        }
                    }
                    else
                    {
                        distr = _user.DistributionSystem.NewDistribution(_reportProxy, cnt, exportFormat);
                    }

                    distr.FrequencyType  = frequencyType;
                    distr.FrequencyValue = frequencyValue;
                    distr.Format         = exportFormat;
                    distr.Save();
                }
                catch (Exception exc)
                {
                    ShowException(exc);
                }
            }

            //_gr.DataBind(true);
        }
 public Distribution NewDistribution(Report report, Contact contact, Report.ExportFormat format)
 {
     return(new Distribution(this.Owner, report, contact, format));
 }
        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;
                }
            }
        }