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();
}
