protected void SubmitButton_Click(object sender, EventArgs e) { DashboardReports.ResponseTimeXtraRpt report = new DashboardReports.ResponseTimeXtraRpt(); report.Parameters["TypeVal"].Value = TypeComboBox.SelectedItem.Text; report.CreateDocument(); ASPxDocumentViewer1.Report = report; ASPxDocumentViewer1.DataBind(); }
//10/31/2013 NS modified - SCHEDULED REPORTS sample code protected void EmailRptButton_Click(object sender, EventArgs e) { try { // Create a new report. DashboardReports.ResponseTimeXtraRpt report = new DashboardReports.ResponseTimeXtraRpt(); report = (DashboardReports.ResponseTimeXtraRpt)ASPxDocumentViewer1.Report; // Create a new memory stream and export the report into it as PDF. MemoryStream mem = new MemoryStream(); report.ExportToPdf(mem); // Create a new attachment and put the PDF report into it. mem.Seek(0, System.IO.SeekOrigin.Begin); Attachment att = new Attachment(mem, "TestReport.pdf", "application/pdf"); // Create a new message and attach the PDF report to it. MailMessage mail = new MailMessage(); mail.Attachments.Add(att); // Specify sender and recipient options for the e-mail message. mail.From = new MailAddress("*****@*****.**", "VitalSigns"); report.ExportOptions.Email.RecipientAddress = "*****@*****.**"; report.ExportOptions.Email.RecipientName = "Natallya Shkarayeva"; report.ExportOptions.Email.Subject = "Response Time report (VS)"; mail.To.Add(new MailAddress(report.ExportOptions.Email.RecipientAddress, report.ExportOptions.Email.RecipientName)); // Specify other e-mail options. mail.Subject = report.ExportOptions.Email.Subject; mail.Body = "This is a test scheduled report from VS."; // Send the e-mail message via the specified SMTP server. string myEmailAddress = ConfigurationSettings.AppSettings["AdminMailID"]; //"*****@*****.**"; string mypwd = ConfigurationSettings.AppSettings["Password"]; //"vitalsigns2012"; myEmailAddress = "*****@*****.**"; mypwd = "vitalsigns2012"; SmtpClient smtp = new SmtpClient("smtp.gmail.com", 587) { Credentials = new System.Net.NetworkCredential(myEmailAddress, mypwd), EnableSsl = true }; smtp.Send(mail); // Close the memory stream. mem.Close(); } catch (Exception ex) { throw ex; //MessageBox.Show(this, "Error sending a report.\n" + ex.ToString()); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { FillCombobox(); } report = new DashboardReports.ResponseTimeXtraRpt(); report.Parameters["TypeVal"].Value = TypeComboBox.SelectedItem.Text; report.CreateDocument(); ASPxDocumentViewer1.Report = report; ASPxDocumentViewer1.DataBind(); }
public DashboardReports.ResponseTimeXtraRpt GetRpt() { report = new DashboardReports.ResponseTimeXtraRpt(); DataTable dt = new DataTable(); string typeval = ""; typeval = "Domino"; dt = VSWebBL.ReportsBL.ReportsBL.Ins.GetResponseTimes(typeval); if (dt.Rows.Count > 0) { report.BuildChart(0, dt.Rows.Count, dt, (XRChart)report.FindControl("xrChart1", true)); } return(report); }
public void SendReport(int ReportID, string Subject, string Body, string SendTo, string CopyTo, string BlindCopyTo, string FileFormat) { DevExpress.XtraReports.UI.XtraReport report = null; string myEmailAddress = ""; string mypwd = ""; string[] mailparams = new string[5]; Settings[] settingsObject = new Settings[5]; Settings[] rtsettingsObject = new Settings[5]; //try //{ switch (ReportID) { case ResponseTimes: report = new DashboardReports.ResponseTimeXtraRpt(); report = (DashboardReports.ResponseTimeXtraRpt)VSWebUI.DashboardReports.ResponseTimeRpt.Ins.GetRpt(); break; case DailyMailVolume: report = new DashboardReports.DailyMailVolumeXtraRpt(); report = (DashboardReports.DailyMailVolumeXtraRpt)VSWebUI.DashboardReports.DailyMailVolumeRpt.Ins.GetRpt(); break; case DominoDiskTrend: report = new DashboardReports.DominoDiskAvgXtraRpt(); report = (DashboardReports.DominoDiskAvgXtraRpt)VSWebUI.DashboardReports.DominoDiskTrendRpt.Ins.GetRpt(); break; } if (report != null) { // Create a new memory stream and export the report into it as PDF. MemoryStream mem = new MemoryStream(); //WriteServiceHistoryEntry(DateTime.Now.ToString() + " report size: " + report.PageSize); //try //{ switch (FileFormat.ToLower()) { case "pdf": report.ExportToPdf(mem); break; case "xls": report.ExportToXls(mem); break; case "xlsx": report.ExportToXlsx(mem); break; case "csv": report.ExportToText(mem); break; } //} //catch (Exception ex) //{ // WriteServiceHistoryEntry(DateTime.Now.ToString() + " report not exported: " + ex.Message); //} // Create a new attachment and put the PDF report into it. mem.Seek(0, System.IO.SeekOrigin.Begin); Attachment att = new Attachment(mem, "VSReport." + FileFormat.ToLower(), "application/" + FileFormat.ToLower()); // Create a new message and attach the PDF report to it. MailMessage mail = new MailMessage(); mail.Attachments.Add(att); // Specify sender and recipient options for the e-mail message. for (int i = 0; i < 5; ++i) { settingsObject[i] = new Settings(); } for (int i = 0; i < 5; ++i) { rtsettingsObject[i] = new Settings(); } settingsObject[0].sname = "PrimaryHostName"; settingsObject[1].sname = "primaryUserID"; settingsObject[2].sname = "primarypwd"; settingsObject[3].sname = "primaryport"; settingsObject[4].sname = "primarySSL"; mailparams[0] = "smtp.gmail.com"; mailparams[1] = ConfigurationSettings.AppSettings["AdminMailID"]; //"*****@*****.**"; mailparams[2] = ConfigurationSettings.AppSettings["Password"]; //"vitalsigns2012"; mailparams[3] = "587"; mailparams[4] = "true"; for (int i = 0; i < 5; i++) { try { rtsettingsObject[i] = VSWebBL.SettingBL.SettingsBL.Ins.GetData(settingsObject[i]); if (rtsettingsObject[i].svalue == "" || rtsettingsObject[i].svalue == null) { //do nothing //WriteServiceHistoryEntry(DateTime.Now.ToString() + " " + settingsObject[i].sname + " is empty"); } else { mailparams[i] = rtsettingsObject[i].svalue; //WriteServiceHistoryEntry(DateTime.Now.ToString() + " " + settingsObject[i].sname + " " + mailparams[i]); } } catch (Exception) { throw; } } mail.From = new MailAddress(mailparams[1], "VitalSigns"); report.ExportOptions.Email.RecipientAddress = SendTo; //report.ExportOptions.Email.RecipientName = SendTo; report.ExportOptions.Email.Subject = Subject; mail.To.Add(new MailAddress(report.ExportOptions.Email.RecipientAddress)); if (CopyTo != "") { mail.CC.Add(new MailAddress(CopyTo)); } if (BlindCopyTo != "") { mail.Bcc.Add(new MailAddress(BlindCopyTo)); } // Specify other e-mail options. mail.Subject = report.ExportOptions.Email.Subject; mail.Body = Body; // Send the e-mail message via the specified SMTP server. myEmailAddress = mailparams[1]; //"*****@*****.**"; mypwd = mailparams[2]; //"vitalsigns2012"; SmtpClient smtp = new SmtpClient(mailparams[0], Convert.ToInt32(mailparams[3])) { Credentials = new System.Net.NetworkCredential(myEmailAddress, mypwd), EnableSsl = true }; smtp.Send(mail); // Close the memory stream. mem.Close(); } //} //catch (Exception ex) //{ // WriteServiceHistoryEntry(DateTime.Now.ToString() + " The following error has occurred in SendReport: " + ex.Message); //} }