public DashboardReports.DominoDiskHealthLocXtraRpt GetRpt() { report = new DashboardReports.DominoDiskHealthLocXtraRpt(); DataTable dt = new DataTable(); dt = VSWebBL.ReportsBL.XsdBL.Ins.DominoDiskSpaceLocBL(report.Parameters["LocationName"].Value.ToString()); report.DataSource = dt; XRLabel xrLabel2; XRLabel xrLabel3; XRTableCell mtDiskName; XRTableCell mtPercentFree; XRTableCell mtDiskSize; XRTableCell mtDiskFree; XRTableCell mtUpdated; XRTableCell mtThreshold; xrLabel2 = (XRLabel)report.FindControl("xrLabel2", true); xrLabel2.DataBindings.Add("Text", dt, "Location"); xrLabel3 = (XRLabel)report.FindControl("xrLabel3", true); xrLabel3.DataBindings.Add("Text", dt, "ServerName"); mtDiskName = (XRTableCell)report.FindControl("mtDiskName", true); mtDiskName.DataBindings.Add("Text", dt, "DiskName"); mtPercentFree = (XRTableCell)report.FindControl("mtPercentFree", true); mtPercentFree.DataBindings.Add("Text", dt, "PercentFree"); mtDiskSize = (XRTableCell)report.FindControl("mtDiskSize", true); mtDiskSize.DataBindings.Add("Text", dt, "DiskSize"); mtDiskFree = (XRTableCell)report.FindControl("mtDiskFree", true); mtDiskFree.DataBindings.Add("Text", dt, "DiskFree"); mtUpdated = (XRTableCell)report.FindControl("mtUpdated", true); mtUpdated.DataBindings.Add("Text", dt, "Updated"); mtThreshold = (XRTableCell)report.FindControl("mtThreshold", true); mtThreshold.DataBindings.Add("Text", dt, "Threshold"); return(report); }
protected void ServerListResetButton_Click(object sender, EventArgs e) { this.ServerListFilterComboBox.SelectedIndex = -1; DashboardReports.DominoDiskHealthLocXtraRpt report = new DashboardReports.DominoDiskHealthLocXtraRpt(); report.Parameters["LocationName"].Value = ""; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); }
protected void ServerListFilterComboBox_SelectedIndexChanged(object sender, EventArgs e) { string selectedServer = ""; if (this.ServerListFilterComboBox.SelectedIndex >= 0) { selectedServer = this.ServerListFilterComboBox.SelectedItem.Value.ToString(); } DashboardReports.DominoDiskHealthLocXtraRpt report = new DashboardReports.DominoDiskHealthLocXtraRpt(); report.Parameters["LocationName"].Value = selectedServer; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); }
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[6]; Settings[] settingsObject = new Settings[6]; Settings[] rtsettingsObject = new Settings[6]; //try //{ //12/9/2015 NS modified for VSPLUS-2395 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; case DiskHealthLoc: report = new DashboardReports.DominoDiskHealthLocXtraRpt(); report = (DashboardReports.DominoDiskHealthLocXtraRpt)VSWebUI.DashboardReports.DominoDiskHealthLocRpt.Ins.GetRpt(); break; case DominoServerHealth: report = new DashboardReports.DominoServerHealthXtraRpt(); report = (DashboardReports.DominoServerHealthXtraRpt)VSWebUI.DashboardReports.DominoServerHealthRpt.Ins.GetRpt(); break; case ServerDiskFreeSpace: report = new DashboardReports.SrvDiskFreeSpaceTrendXtraRpt(); report = (DashboardReports.SrvDiskFreeSpaceTrendXtraRpt)VSWebUI.DashboardReports.SrvDiskFreeSpaceTrendRpt.Ins.GetRpt(); break; case MonthlyServerDownTime: report = new DashboardReports.ServerAvailabilityXtraRpt(); report = (DashboardReports.ServerAvailabilityXtraRpt)VSWebUI.DashboardReports.ServerAvailabilityRpt.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 < 6; ++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"; settingsObject[5].sname = "primaryFrom"; mailparams[0] = "smtp.gmail.com"; mailparams[1] = ConfigurationSettings.AppSettings["AdminMailID"]; //"*****@*****.**"; mailparams[2] = ConfigurationSettings.AppSettings["Password"]; //"vitalsigns2012"; mailparams[3] = "587"; mailparams[4] = "true"; mailparams[5] = "VS Plus"; for (int i = 0; i < 6; 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], mailparams[5]); 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 = Convert.ToBoolean(mailparams[4].ToString()) }; 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); //} }