public DashboardReports.DominoServerHealthXtraRpt GetRpt()
{
report = new DashboardReports.DominoServerHealthXtraRpt();
DataTable dt = new DataTable();
dt = VSWebBL.ReportsBL.ReportsBL.Ins.GetDominoServerHealth();
report.DataSource = dt;
XRLabel xrLabel2;
XRTableCell mtServerName;
XRTableCell mtStatus;
XRTableCell mtDetails;
XRTableCell mtResponse;
XRTableCell mtResponseThreshold;
xrLabel2 = (XRLabel)report.FindControl("xrLabel2", true);
xrLabel2.DataBindings.Add("Text", dt, "Location");
mtServerName = (XRTableCell)report.FindControl("mtServerName", true);
mtServerName.DataBindings.Add("Text", dt, "Name");
mtStatus = (XRTableCell)report.FindControl("mtStatus", true);
mtStatus.DataBindings.Add("Text", dt, "Status");
mtDetails = (XRTableCell)report.FindControl("mtDetails", true);
mtDetails.DataBindings.Add("Text", dt, "Details");
mtResponse = (XRTableCell)report.FindControl("mtResponseTime", true);
mtResponse.DataBindings.Add("Text", dt, "ResponseTime");
mtResponseThreshold = (XRTableCell)report.FindControl("mtResponseThreshold", true);
mtResponseThreshold.DataBindings.Add("Text", dt, "ResponseThreshold");
return(report);
}
protected void Page_Load(object sender, EventArgs e)
{
DashboardReports.DominoServerHealthXtraRpt report = new DashboardReports.DominoServerHealthXtraRpt();
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);
//}
}
