public DashboardReports.SrvDiskFreeSpaceTrendXtraRpt GetRpt() { string date; string srvName = ""; string srvType = ""; date = DateTime.Now.ToString(); DateTime dt = Convert.ToDateTime(date); dt.AddDays(-1); try { report = new DashboardReports.SrvDiskFreeSpaceTrendXtraRpt(); report.Parameters["DateM"].Value = dt.Month; report.Parameters["DateY"].Value = dt.Year; report.Parameters["ServerName"].Value = srvName; report.Parameters["ServerType"].Value = srvType; report.SetReport(report); } catch (Exception ex) { WriteServiceHistoryEntry(DateTime.Now.ToString() + " The following error has occurred in GetRpt: " + ex.Message); } return(report); }
public void SetReport(DashboardReports.SrvDiskFreeSpaceTrendXtraRpt report) { DataTable dt = new DataTable(); dt = VSWebBL.ReportsBL.XsdBL.Ins.SrvDiskFreeSpaceTrendRptDSBL(int.Parse(this.DateM.Value.ToString()), int.Parse(this.DateY.Value.ToString()), this.Parameters["ServerName"].Value.ToString(), this.Parameters["ServerType"].Value.ToString()); Series series = null; string srvName = ""; if (dt.Rows.Count > 0) { //xrChart1.Series.Clear(); srvName = dt.Rows[0]["ServerDiskName"].ToString(); series = new Series(dt.Rows[0]["ServerDiskName"].ToString(), ViewType.Line); for (int i = 0; i < dt.Rows.Count; i++) { if (srvName != dt.Rows[i]["ServerDiskName"].ToString()) { if (series != null) { xrChart1.Series.Add(series); } series = new Series(dt.Rows[i]["ServerDiskName"].ToString(), ViewType.Line); series.ArgumentDataMember = dt.Columns["Date"].ToString(); series.ArgumentScaleType = ScaleType.DateTime; series.ValueScaleType = ScaleType.Numerical; } srvName = dt.Rows[i]["ServerDiskName"].ToString(); if (series != null) { series.Points.Add(new SeriesPoint(dt.Rows[i]["Date"].ToString(), Convert.ToDouble(dt.Rows[i]["StatValue"].ToString()))); series.LabelsVisibility = DevExpress.Utils.DefaultBoolean.True; series.Label.ResolveOverlappingMode = ResolveOverlappingMode.HideOverlapped; } } if (series != null) { xrChart1.Series.Add(series); } ((XYDiagram)xrChart1.Diagram).PaneLayoutDirection = PaneLayoutDirection.Horizontal; XYDiagram seriesXY = (XYDiagram)xrChart1.Diagram; seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowRotate = true; seriesXY.AxisX.Label.ResolveOverlappingOptions.AllowHide = false; seriesXY.AxisY.Title.Text = "Space (GB)"; seriesXY.AxisX.Title.Text = "Date"; seriesXY.AxisY.Title.Visible = true; seriesXY.AxisX.Title.Visible = true; } xrChart1.DataSource = dt; MonthYearLabel.Text = "Report for " + this.MonthYear.Value.ToString(); }
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); //} }
public void Report() { string selectedServer = ""; /* * if (this.ServerListFilterComboBox.SelectedIndex >= 0) * { * selectedServer = this.ServerListFilterComboBox.SelectedItem.Value.ToString(); * } */ if (ServerListFilterListBox.SelectedItems.Count > 0) { selectedServer = ""; for (int i = 0; i < ServerListFilterListBox.SelectedItems.Count; i++) { selectedServer += "'" + ServerListFilterListBox.SelectedItems[i].Text + "'" + ","; } try { selectedServer = selectedServer.Substring(0, selectedServer.Length - 1); } catch { selectedServer = ""; // throw ex; } finally { } } //2/4/2015 NS added for VSPLUS-1370 if (this.ServerTypeFilterListBox.SelectedItems.Count > 0) { selectedType = ""; for (int i = 0; i < this.ServerTypeFilterListBox.SelectedItems.Count; i++) { selectedType += "'" + this.ServerTypeFilterListBox.SelectedItems[i].Text + "'" + ","; } try { selectedType = selectedType.Substring(0, selectedType.Length - 1); } catch { selectedType = ""; // throw ex; } finally { } } string date; //10/23/2013 NS modified - added jQuery month/year control /* * if (this.DateParamEdit.Text == "") * { * date = DateTime.Now.ToString(); * this.DateParamEdit.Date = Convert.ToDateTime(date); * } * else * { * date = this.DateParamEdit.Value.ToString(); * } */ /* * if (dde.Text == "") * { * date = DateTime.Now.ToString(); * } * else * { * //date = startDate.Value.ToString(); * date = dde.Text; * } */ if (startDate.Value.ToString() == "") { date = DateTime.Now.ToString(); } else { date = startDate.Value.ToString(); } DateTime dt = Convert.ToDateTime(date); DashboardReports.SrvDiskFreeSpaceTrendXtraRpt report = new DashboardReports.SrvDiskFreeSpaceTrendXtraRpt(); report.Parameters["DateM"].Value = dt.Month; report.Parameters["DateY"].Value = dt.Year; System.Globalization.DateTimeFormatInfo mfi = new System.Globalization.DateTimeFormatInfo(); string strMonthName = mfi.GetMonthName(dt.Month).ToString() + ", " + dt.Year.ToString(); report.Parameters["MonthYear"].Value = strMonthName; report.Parameters["ServerName"].Value = selectedServer; //2/4/2015 NS added for VSPLUS-1370 report.Parameters["ServerType"].Value = selectedType; this.ReportViewer1.Report = report; this.ReportViewer1.DataBind(); }